https://test.dombusin.com/catalog/cat-944-cepi-iz-busin-handmade?start=30

Query Metrics

145 Database Queries
53 Different statements
278.77 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.