Query Metrics
145
Database Queries
53
Different statements
278.77 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.64 ms |
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_69d0eb969f0f2"
]
|
| 2 | 0.31 ms |
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_69d0eb969fc7d"
]
|
| 3 | 0.29 ms |
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:
[] |
| 4 | 1.26 ms |
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
]
|
| 5 | 0.52 ms |
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"
]
|
| 6 | 1.22 ms |
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:
[
944
]
|
| 7 | 12.04 ms |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 944 ORDER BY c0_.prior DESC
Parameters:
[] |
| 8 | 8.01 ms |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 495 ORDER BY c0_.prior DESC
Parameters:
[] |
| 9 | 3.04 ms |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 491 ORDER BY c0_.prior DESC
Parameters:
[] |
| 10 | 0.83 ms |
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:
[] |
| 11 | 0.73 ms |
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:
[
491
]
|
| 12 | 0.82 ms |
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 ] |
| 13 | 0.80 ms |
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:
[
495
]
|
| 14 | 7.48 ms |
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:
[ 491 1 ] |
| 15 | 1.02 ms |
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:
[ 495 1 ] |
| 16 | 1.13 ms |
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.visible = ? AND t0.cat = ? ORDER BY t0.prior DESC, t0.name ASC
Parameters:
[ 1 944 ] |
| 17 | 5.06 ms |
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.sku AS sku_68, t0.model AS model_69, t0.chars AS chars_70, t0.tags AS tags_71, t0.external_id AS external_id_72 FROM prod t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 76099 76137 76089 76168 75406 76060 75268 75309 75272 75310 75367 75264 75312 115417 76141 ] |
| 18 | 20.45 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '76099' and cv.value != ''
Parameters:
[] |
| 19 | 0.21 ms |
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 = ?
Parameters:
[
317
]
|
| 20 | 0.20 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
15314
]
|
| 21 | 0.21 ms |
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 = ?
Parameters:
[
415
]
|
| 22 | 0.17 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
66964
]
|
| 23 | 0.17 ms |
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 = ?
Parameters:
[
312
]
|
| 24 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
18189
]
|
| 25 | 0.18 ms |
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 = ?
Parameters:
[
282
]
|
| 26 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
29514
]
|
| 27 | 0.16 ms |
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 = ?
Parameters:
[
278
]
|
| 28 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
58097
]
|
| 29 | 0.18 ms |
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 = ?
Parameters:
[
275
]
|
| 30 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
546
]
|
| 31 | 0.16 ms |
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 = ?
Parameters:
[
272
]
|
| 32 | 0.20 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
28836
]
|
| 33 | 0.16 ms |
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 = ?
Parameters:
[
288
]
|
| 34 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
237
]
|
| 35 | 0.18 ms |
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 = ?
Parameters:
[
270
]
|
| 36 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
57274
]
|
| 37 | 11.05 ms |
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" 76099 ] |
| 38 | 4.28 ms |
SELECT prod, `color` FROM cube WHERE `model` = 'М1-00TBAM' AND `size` = 66964 AND inpack = '1 метр' GROUP BY color order by size
Parameters:
[] |
| 39 | 0.38 ms |
SELECT prod, `inpack` FROM cube WHERE `model` = 'М1-00TBAM' AND `color` = 15314 AND `size` = 66964 GROUP BY inpack order by prod
Parameters:
[] |
| 40 | 1.09 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '76137' and cv.value != ''
Parameters:
[] |
| 41 | 0.20 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
21121
]
|
| 42 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
61871
]
|
| 43 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
870
]
|
| 44 | 0.17 ms |
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 = ?
Parameters:
[
277
]
|
| 45 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
58106
]
|
| 46 | 0.17 ms |
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 = ?
Parameters:
[
276
]
|
| 47 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
58105
]
|
| 48 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
3051
]
|
| 49 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
22291
]
|
| 50 | 0.17 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
17288
]
|
| 51 | 11.17 ms |
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" 76137 ] |
| 52 | 0.70 ms |
SELECT prod, `color` FROM cube WHERE `model` = 'М1021HKY' AND `size` = 61871 AND inpack = '1 катушка' GROUP BY color order by size
Parameters:
[] |
| 53 | 0.86 ms |
SELECT prod, `size` FROM cube WHERE `model` = 'М1021HKY' AND `color` = 21121 AND inpack = '1 катушка' GROUP BY size order by color
Parameters:
[] |
| 54 | 0.62 ms |
SELECT prod, `inpack` FROM cube WHERE `model` = 'М1021HKY' AND `color` = 21121 AND `size` = 61871 GROUP BY inpack order by prod
Parameters:
[] |
| 55 | 11.25 ms |
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" 76089 ] |
| 56 | 11.41 ms |
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" 76168 ] |
| 57 | 11.25 ms |
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" 75406 ] |
| 58 | 11.12 ms |
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" 76060 ] |
| 59 | 0.83 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '75268' and cv.value != ''
Parameters:
[] |
| 60 | 0.17 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
21637
]
|
| 61 | 0.17 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
62498
]
|
| 62 | 0.19 ms |
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 = ?
Parameters:
[
283
]
|
| 63 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
25166
]
|
| 64 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
57318
]
|
| 65 | 0.18 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
26302
]
|
| 66 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
179
]
|
| 67 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
57317
]
|
| 68 | 11.55 ms |
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" 75268 ] |
| 69 | 17.43 ms |
SELECT prod, `color` FROM cube WHERE `model` = 'M1-00NW8W' AND `size` = 62498 AND inpack = '1 нить' GROUP BY color order by size
Parameters:
[] |
| 70 | 0.34 ms |
SELECT prod, `size` FROM cube WHERE `model` = 'M1-00NW8W' AND `color` = 21637 AND inpack = '1 нить' GROUP BY size order by color
Parameters:
[] |
| 71 | 0.36 ms |
SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-00NW8W' AND `color` = 21637 AND `size` = 62498 GROUP BY inpack order by prod
Parameters:
[] |
| 72 | 0.76 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '75309' and cv.value != ''
Parameters:
[] |
| 73 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
27371
]
|
| 74 | 0.17 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
66918
]
|
| 75 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
427
]
|
| 76 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
3214
]
|
| 77 | 0.19 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
57359
]
|
| 78 | 11.63 ms |
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" 75309 ] |
| 79 | 5.59 ms |
SELECT prod, `color` FROM cube WHERE `model` = 'M1-023XWZ' AND `size` = 66918 AND inpack = '1 метр' GROUP BY color order by size
Parameters:
[] |
| 80 | 0.34 ms |
SELECT prod, `size` FROM cube WHERE `model` = 'M1-023XWZ' AND `color` = 27371 AND inpack = '1 метр' GROUP BY size order by color
Parameters:
[] |
| 81 | 0.30 ms |
SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-023XWZ' AND `color` = 27371 AND `size` = 66918 GROUP BY inpack order by prod
Parameters:
[] |
| 82 | 1.68 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '75272' and cv.value != ''
Parameters:
[] |
| 83 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
13609
]
|
| 84 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
62884
]
|
| 85 | 0.13 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
829
]
|
| 86 | 0.13 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
590
]
|
| 87 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
198
]
|
| 88 | 0.14 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
15706
]
|
| 89 | 8.18 ms |
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" 75272 ] |
| 90 | 0.60 ms |
SELECT prod, `size` FROM cube WHERE `model` = 'M1-00BFRE' AND `color` = 13609 AND inpack = '1 нить' GROUP BY size order by color
Parameters:
[] |
| 91 | 0.54 ms |
SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-00BFRE' AND `color` = 13609 AND `size` = 62884 GROUP BY inpack order by prod
Parameters:
[] |
| 92 | 0.80 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '75310' and cv.value != ''
Parameters:
[] |
| 93 | 0.14 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
30884
]
|
| 94 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
66919
]
|
| 95 | 0.18 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
3092
]
|
| 96 | 0.13 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
52841
]
|
| 97 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
105
]
|
| 98 | 7.57 ms |
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" 75310 ] |
| 99 | 0.39 ms |
SELECT prod, `color` FROM cube WHERE `model` = 'M1-022QZX' AND `size` = 66919 AND inpack = '1 метр' GROUP BY color order by size
Parameters:
[] |
| 100 | 0.30 ms |
SELECT prod, `size` FROM cube WHERE `model` = 'M1-022QZX' AND `color` = 30884 AND inpack = '1 метр' GROUP BY size order by color
Parameters:
[] |
| 101 | 0.30 ms |
SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-022QZX' AND `color` = 30884 AND `size` = 66919 GROUP BY inpack order by prod
Parameters:
[] |
| 102 | 0.97 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '75367' and cv.value != ''
Parameters:
[] |
| 103 | 0.17 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
57382
]
|
| 104 | 0.14 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
66929
]
|
| 105 | 0.17 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
57398
]
|
| 106 | 0.13 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
64
]
|
| 107 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
6295
]
|
| 108 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
57397
]
|
| 109 | 7.92 ms |
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" 75367 ] |
| 110 | 0.54 ms |
SELECT prod, `color` FROM cube WHERE `model` = 'M1-00YXMN' AND `size` = 66929 AND inpack = '1 метр' GROUP BY color order by size
Parameters:
[] |
| 111 | 0.41 ms |
SELECT prod, `size` FROM cube WHERE `model` = 'M1-00YXMN' AND `color` = 57382 AND inpack = '1 метр' GROUP BY size order by color
Parameters:
[] |
| 112 | 0.30 ms |
SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-00YXMN' AND `color` = 57382 AND `size` = 66929 GROUP BY inpack order by prod
Parameters:
[] |
| 113 | 1.48 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '75264' and cv.value != ''
Parameters:
[] |
| 114 | 0.16 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
66904
]
|
| 115 | 0.14 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
57313
]
|
| 116 | 0.14 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
22130
]
|
| 117 | 0.13 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
22290
]
|
| 118 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
12974
]
|
| 119 | 12.29 ms |
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" 75264 ] |
| 120 | 0.62 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '75312' and cv.value != ''
Parameters:
[] |
| 121 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
30326
]
|
| 122 | 0.12 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
66920
]
|
| 123 | 0.15 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
15385
]
|
| 124 | 0.11 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
30566
]
|
| 125 | 0.12 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
40
]
|
| 126 | 6.87 ms |
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" 75312 ] |
| 127 | 4.76 ms |
SELECT prod, `color` FROM cube WHERE `model` = 'M1-022QZX' AND `size` = 66920 AND inpack = '1 метр' GROUP BY color order by size
Parameters:
[] |
| 128 | 0.45 ms |
SELECT prod, `size` FROM cube WHERE `model` = 'M1-022QZX' AND `color` = 30326 AND inpack = '1 метр' GROUP BY size order by color
Parameters:
[] |
| 129 | 0.27 ms |
SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-022QZX' AND `color` = 30326 AND `size` = 66920 GROUP BY inpack order by prod
Parameters:
[] |
| 130 | 0.82 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '115417' and cv.value != ''
Parameters:
[] |
| 131 | 0.13 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
61866
]
|
| 132 | 0.12 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
6739
]
|
| 133 | 0.12 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
2387
]
|
| 134 | 0.11 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
1317
]
|
| 135 | 0.11 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
1707
]
|
| 136 | 6.64 ms |
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" 115417 ] |
| 137 | 0.80 ms |
SELECT prod, `color` FROM cube WHERE `model` = 'М1-00TB69' AND `size` = 61866 AND inpack = '1 катушка' GROUP BY color order by size
Parameters:
[] |
| 138 | 0.33 ms |
SELECT prod, `size` FROM cube WHERE `model` = 'М1-00TB69' AND `color` = 30326 AND inpack = '1 катушка' GROUP BY size order by color
Parameters:
[] |
| 139 | 0.97 ms |
select c.id as cid, c.name as cname, c.izm, cv.id as cvid, cv.value as value, pc.charval as val, pc.value as text from `prodchar` as pc left join `char` as c on c.id = pc.`char` left join `charval` as cv on cv.id = pc.charval where c.inprod = 1 and pc.prod = '76141' and cv.value != ''
Parameters:
[] |
| 140 | 0.72 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
15258
]
|
| 141 | 0.18 ms |
SELECT t0.id AS id_1, t0.char AS char_2, t0.value AS value_3, t0.visible AS visible_4, t0.prior AS prior_5 FROM charval t0 WHERE t0.id = ?
Parameters:
[
22292
]
|
| 142 | 6.00 ms |
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" 76141 ] |
| 143 | 2.93 ms |
SELECT prod, `color` FROM cube WHERE `model` = 'М1-029T8C' AND `size` = 61871 AND inpack = '1 катушка' GROUP BY color order by size
Parameters:
[] |
| 144 | 0.46 ms |
SELECT prod, `size` FROM cube WHERE `model` = 'М1-029T8C' AND `color` = 15258 AND inpack = '1 катушка' GROUP BY size order by color
Parameters:
[] |
| 145 | 0.27 ms |
SELECT prod, `inpack` FROM cube WHERE `model` = 'М1-029T8C' AND `color` = 15258 AND `size` = 61871 GROUP BY inpack order by prod
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. |