Symfony Profiler

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 = ?

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 = 'prod' AND t0.par = 2067;

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 = ?

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 = 20605;

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 = ?

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 = 60;

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

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 = 1 AND t0.cat = 60 ORDER BY t0.prior DESC, t0.name ASC;

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 = ?

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 = 35010;

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

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 = 'guest_69cfbeadbb4dc' LIMIT 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 = ?

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 = 317;

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'M1-008MRR'
  AND `size` = 64774
  AND inpack = '5 шт'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'M1-008MRR' AND `size` = 64774 AND inpack = '5 шт' GROUP BY color order by size;

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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 (74889, 74900, 74892, 2067, 2096, 57025, 38986, 74669, 74671, 75535, 76241, 77105, 110981, 114313, 115224, 72041, 72042, 72043, 74689, 76215, 76220, 76268, 76571, 76747, 76877, 78244, 35009, 35017, 35021, 43775);

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'M1-004GHX'
  AND `size` = 60964
  AND inpack = '50 шт'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'M1-004GHX' AND `size` = 60964 AND inpack = '50 шт' GROUP BY color order by size;

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'М1-0282PC'
  AND `size` = 64752
  AND inpack = '2 шт'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'М1-0282PC' AND `size` = 64752 AND inpack = '2 шт' GROUP BY color order by size;

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'М1-00RE8N'
  AND `size` = 61953
  AND inpack = '1 пара'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'М1-00RE8N' AND `size` = 61953 AND inpack = '1 пара' GROUP BY color order by size;

SELECT
  t0.id AS id_1,
  t0.intname AS intname_2,
  t0.name AS name_3,
  t0.value AS value_4
FROM
  block t0

SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.value AS value_4 FROM block t0;

SELECT
  prod,
  `size`
FROM
  cube
WHERE
  `model` = 'M1-00B34S'
  AND `color` = 20605
  AND inpack = '50 шт'
GROUP BY
  size
order by
  color

SELECT prod, `size` FROM cube WHERE `model` = 'M1-00B34S' AND `color` = 20605 AND inpack = '50 шт' GROUP BY size order by color;

SELECT
  prod,
  `size`
FROM
  cube
WHERE
  `model` = 'M1-00D3T7'
  AND `color` = 20605
  AND inpack = '20 шт'
GROUP BY
  size
order by
  color

SELECT prod, `size` FROM cube WHERE `model` = 'M1-00D3T7' AND `color` = 20605 AND inpack = '20 шт' GROUP BY size order by color;

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'М1-00MGQZ'
  AND `size` = 61877
  AND inpack = '5 шт'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'М1-00MGQZ' AND `size` = 61877 AND inpack = '5 шт' GROUP BY color order by size;

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'M1-00D3T7'
  AND `size` = 61032
  AND inpack = '20 шт'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'M1-00D3T7' AND `size` = 61032 AND inpack = '20 шт' GROUP BY color order by size;

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'M1-00N4C8'
  AND `size` = 61788
  AND inpack = '5 шт'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'M1-00N4C8' AND `size` = 61788 AND inpack = '5 шт' GROUP BY color order by size;

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 = '76877'
  and cv.value != ''

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 = '76877' and cv.value != '';

SELECT
  prod,
  `size`
FROM
  cube
WHERE
  `model` = 'M1-004GHX'
  AND `color` = 17893
  AND inpack = '50 шт'
GROUP BY
  size
order by
  color

SELECT prod, `size` FROM cube WHERE `model` = 'M1-004GHX' AND `color` = 17893 AND inpack = '50 шт' GROUP BY size order by color;

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 = '74689'
  and cv.value != ''

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 = '74689' and cv.value != '';

SELECT
  prod,
  `inpack`
FROM
  cube
WHERE
  `model` = 'М1-0282PC'
  AND `color` = 17842
  AND `size` = 64752
GROUP BY
  inpack
order by
  prod

SELECT prod, `inpack` FROM cube WHERE `model` = 'М1-0282PC' AND `color` = 17842 AND `size` = 64752 GROUP BY inpack order by prod;

SELECT
  prod,
  `inpack`
FROM
  cube
WHERE
  `model` = 'M1-008MRR'
  AND `color` = 17936
  AND `size` = 64774
GROUP BY
  inpack
order by
  prod

SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-008MRR' AND `color` = 17936 AND `size` = 64774 GROUP BY inpack order by prod;

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 = '76747'
  and cv.value != ''

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 = '76747' and cv.value != '';

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 = '74889'
  and cv.value != ''

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 = '74889' and cv.value != '';

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'M1-00DKR5'
  AND `size` = 61519
  AND inpack = '100 шт'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'M1-00DKR5' AND `size` = 61519 AND inpack = '100 шт' GROUP BY color order by size;

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'M1-00QHTZ'
  AND `size` = 61832
  AND inpack = '10 шт'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'M1-00QHTZ' AND `size` = 61832 AND inpack = '10 шт' GROUP BY color order by size;

SELECT
  prod,
  `size`
FROM
  cube
WHERE
  `model` = 'M1-008MRR'
  AND `color` = 17936
  AND inpack = '5 шт'
GROUP BY
  size
order by
  color

SELECT prod, `size` FROM cube WHERE `model` = 'M1-008MRR' AND `color` = 17936 AND inpack = '5 шт' GROUP BY size order by color;

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 = '74669'
  and cv.value != ''

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 = '74669' and cv.value != '';

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 = '74671'
  and cv.value != ''

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 = '74671' and cv.value != '';

SELECT
  prod,
  `inpack`
FROM
  cube
WHERE
  `model` = 'M1-00D3T7'
  AND `color` = 20605
  AND `size` = 61032
GROUP BY
  inpack
order by
  prod

SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-00D3T7' AND `color` = 20605 AND `size` = 61032 GROUP BY inpack order by prod;