Query Metrics
184
Database Queries
31
Different statements
150.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
43.42 ms (28.94%) |
2 |
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_698469895f484"
]
|
|
27.16 ms (18.10%) |
20 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.par AS par_3, t0.name AS name_4, t0.prior AS prior_5, t0.visible AS visible_6 FROM photo t0 WHERE t0.type = ? AND t0.par = ?
Parameters:
[ "prod" 71958 ] |
|
23.51 ms (15.67%) |
20 |
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
8447
]
|
|
20.09 ms (13.39%) |
48 |
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:
[
547
]
|
|
11.90 ms (7.93%) |
1 |
select c.id, c.name, c.prior from `catchar` as cc right join `char` as c on c.id = cc.char where c.search > 0 group by c.id order by c.prior desc
Parameters:
[] |
|
5.20 ms (3.47%) |
23 |
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 cat_translation t0 WHERE t0.object_id = ?
Parameters:
[
9
]
|
|
4.18 ms (2.79%) |
22 |
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
]
|
|
3.87 ms (2.58%) |
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 char_translation t0 WHERE t0.object_id = ?
Parameters:
[
298
]
|
|
1.79 ms (1.19%) |
3 |
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.intname AS intname_3, t0.name AS name_4, t0.short AS short_5, t0.cont AS cont_6, t0.cont2 AS cont2_7, t0.prior AS prior_8, t0.visible AS visible_9, t0.spec AS spec_10, t0.newlabel AS newlabel_11, t0.inprice AS inprice_12, t0.incatalog AS incatalog_13, t0.notinxml AS notinxml_14, t0.title AS title_15, t0.h1 AS h1_16, t0.kw AS kw_17, t0.descr AS descr_18, t0.pic AS pic_19 FROM cat t0 WHERE t0.cat = ? AND t0.visible = ? ORDER BY t0.prior DESC
Parameters:
[ 0 1 ] |
|
1.07 ms (0.71%) |
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:
[ 298 309 312 270 287 274 279 272 283 288 284 315 314 297 281 311 310 316 401 402 408 ] |
|
0.93 ms (0.62%) |
1 |
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.intname AS intname_3, t0.name AS name_4, t0.art AS art_5, t0.short AS short_6, t0.cont AS cont_7, t0.price AS price_8, t0.price2 AS price2_9, t0.price3 AS price3_10, t0.price4 AS price4_11, t0.priceopt AS priceopt_12, t0.priceopt2 AS priceopt2_13, t0.priceopt3 AS priceopt3_14, t0.priceopt4 AS priceopt4_15, t0.skidka AS skidka_16, t0.skidka2 AS skidka2_17, t0.skidka3 AS skidka3_18, t0.skidka4 AS skidka4_19, t0.skidkaopt AS skidkaopt_20, t0.skidkaopt2 AS skidkaopt2_21, t0.skidkaopt3 AS skidkaopt3_22, t0.skidkaopt4 AS skidkaopt4_23, t0.numdiscount AS numdiscount_24, t0.numdiscount2 AS numdiscount2_25, t0.numdiscount3 AS numdiscount3_26, t0.numdiscount4 AS numdiscount4_27, t0.numdiscountopt AS numdiscountopt_28, t0.numdiscountopt2 AS numdiscountopt2_29, t0.numdiscountopt3 AS numdiscountopt3_30, t0.numdiscountopt4 AS numdiscountopt4_31, t0.num AS num_32, t0.num2 AS num2_33, t0.num3 AS num3_34, t0.num4 AS num4_35, t0.inpack AS inpack_36, t0.inpack2 AS inpack2_37, t0.inpack3 AS inpack3_38, t0.inpack4 AS inpack4_39, t0.weight AS weight_40, t0.weight2 AS weight2_41, t0.weight3 AS weight3_42, t0.weight4 AS weight4_43, t0.visible AS visible_44, t0.pop AS pop_45, t0.action AS action_46, t0.mix AS mix_47, t0.main AS main_48, t0.new AS new_49, t0.sale AS sale_50, t0.onsale AS onsale_51, t0.selection1 AS selection1_52, t0.selection2 AS selection2_53, t0.prior AS prior_54, t0.title AS title_55, t0.descr AS descr_56, t0.kw AS kw_57, t0.h1 AS h1_58, t0.rating AS rating_59, t0.spec AS spec_60, t0.ordered AS ordered_61, t0.izm AS izm_62, t0.pic AS pic_63, t0.views AS views_64, t0.justuploaded AS justuploaded_65, t0.uploaded AS uploaded_66, t0.changed AS changed_67, t0.colors AS colors_68, t0.sku AS sku_69, t0.model AS model_70, t0.chars AS chars_71, t0.tags AS tags_72, t0.external_id AS external_id_73 FROM prod t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 71958 71879 71881 45591 57250 71943 71962 38206 47313 77137 47449 45619 71918 47374 47451 8447 33637 38204 47446 45642 ] |
|
0.70 ms (0.46%) |
3 |
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.intname AS intname_3, t0.name AS name_4, t0.short AS short_5, t0.cont AS cont_6, t0.cont2 AS cont2_7, t0.prior AS prior_8, t0.visible AS visible_9, t0.spec AS spec_10, t0.newlabel AS newlabel_11, t0.inprice AS inprice_12, t0.incatalog AS incatalog_13, t0.notinxml AS notinxml_14, t0.title AS title_15, t0.h1 AS h1_16, t0.kw AS kw_17, t0.descr AS descr_18, t0.pic AS pic_19 FROM cat t0 WHERE t0.id = ?
Parameters:
[
9
]
|
|
0.54 ms (0.36%) |
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 (537, 537, 544, 3222, 544, 544, 544, 544, 3222, 544, 29551, 544, 544, 544, 544, 29551, 537, 537, 29551, 3222, 3222, 29979, 29979, 539, 544, 29551, 29549, 3222, 544, 537, 29979, 21207, 21207, 29551, 537, 537, 537, 544, 544, 3222, 29549, 3222, 539, 29551, 29551, 21207, 537, 539, 544, 539) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.46 ms (0.31%) |
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 = 288 AND c0_.id IN (13085, 206, 206, 550, 206, 237, 198, 179, 550, 206, 550, 23, 550, 179, 179, 15914, 550, 3220, 12927, 179, 550, 206, 206, 550, 550, 206, 15155, 206, 550, 550, 15155, 15155, 15155, 21353, 237, 237, 237, 237, 237, 237, 237, 206, 198, 138, 550, 206, 550, 12927, 550, 3220) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.45 ms (0.30%) |
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 = 309 AND c0_.id IN (12306, 12306, 12306, 634, 12306, 12306, 12788, 12821, 634, 634, 634, 629, 634, 12821, 12821, 634, 634, 12821, 634, 12821, 634, 634, 634, 634, 634, 634, 12306, 12306, 634, 634, 12306, 12306, 12306, 12306, 12306, 12306, 12306, 12306, 12306, 12306, 12306, 634, 12788, 629, 634, 634, 634, 634, 634, 12821) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.44 ms (0.30%) |
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.43 ms (0.29%) |
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.42 ms (0.28%) |
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 (81, 81, 26, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 59, 654, 81, 81, 14718, 14718, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 654, 81, 81, 81, 81, 81, 81, 81, 81, 81, 26, 81, 640, 81, 81, 81, 81) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.41 ms (0.28%) |
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 (29577, 29586, 29586, 29577, 29586, 29586, 551, 551, 29586, 29577, 29586, 29577, 29586, 547, 29577, 29586, 29586, 29586, 29586, 29586, 29586, 29576, 29576, 547, 551, 29576, 29578, 29586, 29586, 551, 29586, 29586, 29586, 29586, 29586, 29586, 29578, 29578, 29586, 29586, 29576, 29586, 547, 29586, 29586, 29586, 551, 551, 29577, 547) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.39 ms (0.26%) |
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 = 297 AND c0_.id IN (25191, 25191, 25191, 25191, 25191, 25191, 15415, 15415, 15415, 15415, 25191, 15415, 15415, 15415, 15415, 15415, 25191, 15415, 15415, 15415, 15415, 17182, 17182, 15415, 15415, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 25191, 15415, 25191, 15415, 25191) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.36 ms (0.24%) |
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 = 312 AND c0_.id IN (12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 30097, 30097, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790, 12790) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.33 ms (0.22%) |
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 = 316 AND c0_.id IN (29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29911, 29911, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29873, 29911, 29873, 29873, 29873, 29873) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.30 ms (0.20%) |
1 |
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
33
]
|
|
0.30 ms (0.20%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.page AS page_3, t0.intname AS intname_4, t0.mainpage AS mainpage_5, t0.name AS name_6, t0.href AS href_7, t0.short AS short_8, t0.cont AS cont_9, t0.prior AS prior_10, t0.visible AS visible_11, t0.title AS title_12, t0.h1 AS h1_13, t0.kw AS kw_14, t0.descr AS descr_15, t0.tstamp AS tstamp_16, t0.icon AS icon_17 FROM page t0 WHERE t0.intname = ? LIMIT 1
Parameters:
[
"catalog/pop"
]
|
|
0.26 ms (0.17%) |
1 |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 9 ORDER BY c0_.prior DESC
Parameters:
[] |
|
0.21 ms (0.14%) |
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 (137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137, 137) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.20 ms (0.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 = 283 AND c0_.id IN (15416, 15416) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.19 ms (0.13%) |
1 |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 1 ORDER BY c0_.prior DESC
Parameters:
[] |
|
0.18 ms (0.12%) |
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 (29964, 29964, 29964, 29964, 29964, 29964, 29964, 29964) ORDER BY c0_.prior DESC, c0_.value ASC
Parameters:
[] |
|
0.17 ms (0.11%) |
1 |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 909 ORDER BY c0_.prior DESC
Parameters:
[] |
|
0.16 ms (0.11%) |
1 |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 0 ORDER BY c0_.prior DESC
Parameters:
[] |
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\Prod | No errors. |
| App\Entity\CartUnsaved | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Cat | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Catpage | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\Char | No errors. |
| App\Entity\Cube | 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\Catchar | No errors. |
| App\Entity\Charval | No errors. |
| App\Entity\PagePhoto | No errors. |
| App\Entity\PageBlock | No errors. |
| App\Entity\Translation\PageTranslation | No errors. |
| App\Entity\Translation\CatTranslation | No errors. |
| App\Entity\Translation\ProdTranslation | No errors. |
| App\Entity\Translation\CharTranslation | No errors. |
| App\Entity\Translation\CharvalTranslation | No errors. |