Query Metrics
85
Database Queries
17
Different statements
66.71 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
23.82 ms (35.71%) |
1 |
SELECT id, cat, intname, name, art, price, price2, price3, priceopt, priceopt2, priceopt3, skidka, skidka2, skidka3, skidkaopt, skidkaopt2, skidkaopt3, numdiscount, numdiscount2, numdiscount3, chars, numdiscountopt, numdiscountopt2, numdiscountopt3, num, num2, num3, weight, weight2, weight3, inpack, inpack2, inpack3, pop, new, mix, action, onsale, selection1, selection2, prior, ordered, changed, colors FROM prod WHERE visible = 1 and (num > 0 or num2 > 0 or num3 > 0) and (cat = 790 or cat = 791 or cat = 73)
Parameters:
[] |
18.89 ms (28.32%) |
43 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM charval_translation t0 WHERE t0.object_id = ?
Parameters:
[
142
]
|
5.56 ms (8.34%) |
21 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM block_translation t0 WHERE t0.object_id = ?
Parameters:
[
1
]
|
2.69 ms (4.03%) |
1 |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.cart AS cart_3 FROM cart_unsaved t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
"guest_68f4ba8a87191"
]
|
2.60 ms (3.90%) |
7 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM char_translation t0 WHERE t0.object_id = ?
Parameters:
[
270
]
|
1.77 ms (2.65%) |
1 |
SELECT t0.id AS id_1, t0.oldurl AS oldurl_2, t0.newurl AS newurl_3 FROM redirect t0
Parameters:
[] |
1.74 ms (2.61%) |
1 |
select c.id, c.name, c.prior from `catchar` as cc right join `char` as c on c.id = cc.char where cc.cat = '73' and c.search > 0 group by c.id order by c.prior desc
Parameters:
[] |
1.41 ms (2.11%) |
1 |
SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 284 AND c0_.id IN (17830, 17825, 17832, 17828, 17828, 17832, 17831, 17831, 17831, 17828, 18596, 17831, 17831, 17831, 21331, 18596, 17825, 18596, 17825, 17831, 17831, 17828, 18596, 17831, 17831, 17832, 17825, 17825, 17831, 17831, 17825, 17825, 17825, 17831, 17825, 17831, 17831, 17831, 17830, 17828, 17832, 17825, 17831, 17825, 17825, 17831, 17831, 17831, 17832, 17828, 17828, 17828, 17831, 17825, 18596, 17831, 17825, 18596, 18596, 17831, 18596, 17828, 17828, 17828, 18596, 17828, 18596, 17828, 17831, 17828) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
1.30 ms (1.94%) |
1 |
SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 272 AND c0_.id IN (22288, 22293, 22291, 22291, 22292, 22289, 22289, 22291, 22292, 22289, 22291, 22289, 22309, 22293, 29120, 59855, 22291, 22288, 22292, 22309, 31247, 22290, 24843, 26322, 22290, 31247, 22309, 26322, 22309, 26322, 22293, 22288, 22289, 22291, 22289, 22290, 22290, 31248, 22288, 22294, 22778, 59855, 22291, 59855, 59855, 22289, 22288, 22290, 22288, 59855, 59855, 59855, 22288, 22309, 22291, 29120, 59855, 22291, 22290, 22291, 22289, 22291, 22290, 22294, 22293, 22288, 22290, 22293, 22291, 22289, 22309, 22294, 22289, 22293, 22294, 22293, 22293) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
1.15 ms (1.72%) |
1 |
SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 274 AND c0_.id IN (539, 539, 539, 539, 539, 537, 537, 537, 537, 537, 64136, 537, 537, 64136, 539, 539, 539, 537, 539, 537, 539, 539, 64136, 537, 539, 539, 537, 537, 539, 539, 64136, 64136, 64136, 64136, 537, 64136, 64136, 64136, 539, 537, 539, 539, 539, 539, 537, 537, 537, 537, 539, 539, 539, 537, 537, 539, 64136, 539, 537, 64136, 539, 539, 539, 64137, 64137, 539, 537, 539, 539, 539, 539, 539, 537, 537, 64137, 539, 539, 537, 539) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
1.03 ms (1.54%) |
1 |
SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 298 AND c0_.id IN (29865, 29865, 29865, 547, 547, 29874, 551, 551, 551, 551, 24878, 29866, 551, 29866, 29865, 29874, 547, 551, 547, 29865, 29865, 547, 547, 551, 29865, 551, 29865, 29865, 29865, 29865, 547, 547, 547, 547, 551, 29874, 551, 551, 29865, 551, 29874, 29865, 29874, 29865, 29866, 551, 551, 551, 551, 29866, 29866, 29874, 551, 551, 19207, 29865, 19207, 29865, 29865, 29865, 29865, 29865, 29866, 29865, 29865, 551, 29865, 29865, 29866, 29866, 29874, 547, 29865, 29866, 29866, 29866) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
0.94 ms (1.41%) |
1 |
SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 315 AND c0_.id IN (3057, 3057, 3057, 3057, 3057, 3057, 3057, 3057, 3057, 3057, 3057, 12946, 3057, 3057, 3057, 3057, 3057, 3057, 3057, 3057, 12946, 3057, 3057, 3057, 3057, 64180, 64180, 3057, 3057, 3057, 3057, 3057, 3057) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
0.94 ms (1.41%) |
1 |
SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 287 AND c0_.id IN (134, 108, 108, 108, 108, 108, 108, 108, 108, 108, 81, 108, 108, 108, 108, 108, 108, 81, 108, 108, 108, 108, 81, 108, 17747, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 81, 17747, 108, 134, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 108, 81, 108, 108, 81, 181, 181, 582, 582, 582, 582, 582, 582, 582, 582, 582, 81, 142, 108, 582, 582, 582, 582, 582) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
0.85 ms (1.28%) |
1 |
SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = ? ORDER BY t0.id DESC
Parameters:
[
0
]
|
0.75 ms (1.13%) |
1 |
SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 270 AND c0_.id IN (22, 1, 307, 17, 2, 2, 172, 24, 1) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
0.68 ms (1.02%) |
1 |
SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.value AS value_4 FROM block t0
Parameters:
[] |
0.59 ms (0.88%) |
1 |
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.name AS name_3, t0.type AS type_4, t0.search AS search_5, t0.buy AS buy_6, t0.izm AS izm_7, t0.prior AS prior_8, t0.visible AS visible_9, t0.incat AS incat_10, t0.inprod AS inprod_11 FROM `char` t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY t0.prior DESC
Parameters:
[ 270 272 274 284 287 298 315 ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Discount | No errors. |
App\Entity\Redirect | No errors. |
App\Entity\Prod | No errors. |
App\Entity\CartUnsaved | No errors. |
App\Entity\Cart | No errors. |
App\Entity\Page | No errors. |
App\Entity\Cat | No errors. |
App\Entity\Catpage | No errors. |
App\Entity\Timer | No errors. |
App\Entity\Char | No errors. |
App\Entity\Charval | No errors. |
App\Entity\Block | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
App\Entity\Translation\BlockTranslation | No errors. |
App\Entity\Wishlist | No errors. |
App\Entity\Translation\CharTranslation | No errors. |
App\Entity\Translation\CharvalTranslation | No errors. |