Symfony Profiler

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

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

SELECT
  id,
  cat,
  intname,
  name,
  art,
  price,
  price2,
  price3,
  priceopt,
  priceopt2,
  priceopt3,
  skidka,
  skidka2,
  skidka3,
  skidkaopt,
  skidkaopt2,
  skidkaopt3,
  numdiscount,
  numdiscount2,
  numdiscount3,
  chars,
  numdiscountopt,
  numdiscountopt2,
  numdiscountopt3,
  num,
  num2,
  num3,
  weight,
  weight2,
  weight3,
  inpack,
  inpack2,
  inpack3,
  pop,
  new,
  mix,
  action,
  onsale,
  selection1,
  selection2,
  prior,
  ordered,
  changed,
  colors
FROM
  prod
WHERE
  visible = 1
  and (
    num > 0
    or num2 > 0
    or num3 > 0
  )
  and (
    cat = 3
    or cat = 419
    or cat = 420
    or cat = 421
    or cat = 422
    or cat = 423
    or cat = 424
    or cat = 909
    or cat = 9
    or cat = 910
    or cat = 29
    or cat = 426
    or cat = 428
    or cat = 430
    or cat = 433
    or cat = 767
    or cat = 434
    or cat = 435
    or cat = 436
    or cat = 485
    or cat = 487
    or cat = 28
    or cat = 638
    or cat = 639
    or cat = 640
    or cat = 22
    or cat = 24
    or cat = 470
    or cat = 625
    or cat = 626
    or cat = 204
    or cat = 641
    or cat = 645
    or cat = 646
    or cat = 647
    or cat = 648
    or cat = 649
    or cat = 652
    or cat = 653
    or cat = 733
    or cat = 734
    or cat = 735
    or cat = 736
    or cat = 738
    or cat = 739
    or cat = 740
    or cat = 741
    or cat = 742
    or cat = 743
    or cat = 744
    or cat = 766
    or cat = 797
    or cat = 805
    or cat = 855
    or cat = 856
    or cat = 895
    or cat = 896
    or cat = 897
    or cat = 898
    or cat = 899
    or cat = 900
    or cat = 901
    or cat = 902
    or cat = 903
    or cat = 904
    or cat = 905
    or cat = 906
    or cat = 954
    or cat = 457
    or cat = 852
    or cat = 854
    or cat = 931
    or cat = 913
    or cat = 794
    or cat = 795
    or cat = 796
    or cat = 469
    or cat = 104
    or cat = 23
    or cat = 620
    or cat = 953
    or cat = 27
    or cat = 627
    or cat = 628
    or cat = 629
    or cat = 630
    or cat = 631
    or cat = 632
    or cat = 634
    or cat = 635
    or cat = 636
    or cat = 637
    or cat = 811
    or cat = 1
  )

SELECT id, cat, intname, name, art, price, price2, price3, priceopt, priceopt2, priceopt3, skidka, skidka2, skidka3, skidkaopt, skidkaopt2, skidkaopt3, numdiscount, numdiscount2, numdiscount3, chars, numdiscountopt, numdiscountopt2, numdiscountopt3, num, num2, num3, weight, weight2, weight3, inpack, inpack2, inpack3, pop, new, mix, action, onsale, selection1, selection2, prior, ordered, changed, colors FROM prod WHERE visible = 1 and (num > 0 or num2 > 0 or num3 > 0) and (cat = 3 or cat = 419 or cat = 420 or cat = 421 or cat = 422 or cat = 423 or cat = 424 or cat = 909 or cat = 9 or cat = 910 or cat = 29 or cat = 426 or cat = 428 or cat = 430 or cat = 433 or cat = 767 or cat = 434 or cat = 435 or cat = 436 or cat = 485 or cat = 487 or cat = 28 or cat = 638 or cat = 639 or cat = 640 or cat = 22 or cat = 24 or cat = 470 or cat = 625 or cat = 626 or cat = 204 or cat = 641 or cat = 645 or cat = 646 or cat = 647 or cat = 648 or cat = 649 or cat = 652 or cat = 653 or cat = 733 or cat = 734 or cat = 735 or cat = 736 or cat = 738 or cat = 739 or cat = 740 or cat = 741 or cat = 742 or cat = 743 or cat = 744 or cat = 766 or cat = 797 or cat = 805 or cat = 855 or cat = 856 or cat = 895 or cat = 896 or cat = 897 or cat = 898 or cat = 899 or cat = 900 or cat = 901 or cat = 902 or cat = 903 or cat = 904 or cat = 905 or cat = 906 or cat = 954 or cat = 457 or cat = 852 or cat = 854 or cat = 931 or cat = 913 or cat = 794 or cat = 795 or cat = 796 or cat = 469 or cat = 104 or cat = 23 or cat = 620 or cat = 953 or cat = 27 or cat = 627 or cat = 628 or cat = 629 or cat = 630 or cat = 631 or cat = 632 or cat = 634 or cat = 635 or cat = 636 or cat = 637 or cat = 811 or cat = 1);

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

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

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 = 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
  prod_translation t0
WHERE
  t0.object_id = ?

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

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

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,
  `inpack`
FROM
  cube
WHERE
  `model` = 'M1-00HF7W'
  AND `color` = 15266
  AND `size` = 60741
GROUP BY
  inpack
order by
  prod

SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-00HF7W' AND `color` = 15266 AND `size` = 60741 GROUP BY inpack order by prod;

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

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

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

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

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'M1-00HF7W'
  AND `size` = 60741
  AND inpack = '1 нитка'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'M1-00HF7W' AND `size` = 60741 AND inpack = '1 нитка' GROUP BY color order by size;

SELECT
  prod,
  `size`
FROM
  cube
WHERE
  `model` = 'M1-002HWC'
  AND `color` = 18085
  AND inpack = '1 нитка'
GROUP BY
  size
order by
  color

SELECT prod, `size` FROM cube WHERE `model` = 'M1-002HWC' AND `color` = 18085 AND inpack = '1 нитка' GROUP BY size order by color;

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'M1-002DY5'
  AND `size` = 61034
  AND inpack = '1 нитка'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'M1-002DY5' AND `size` = 61034 AND inpack = '1 нитка' 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.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 = 1;

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

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 (110922, 114739, 75642, 75647, 75650, 75651, 77474, 77475, 40112, 58409, 531, 549, 550, 559, 14675, 15162, 17342, 18678, 33662, 40207, 56876, 56890, 56910, 73472, 73839, 73843, 74000, 74001, 74003, 74004);

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

SELECT
  prod,
  `inpack`
FROM
  cube
WHERE
  `model` = 'M1-002HWC'
  AND `color` = 18085
  AND `size` = 60717
GROUP BY
  inpack
order by
  prod

SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-002HWC' AND `color` = 18085 AND `size` = 60717 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 = '17342'
  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 = '17342' and cv.value != '';

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

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 = 'catalog/search/cat-1-busini' LIMIT 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

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;

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

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 = 0 AND t0.visible = 1 ORDER BY t0.prior DESC;

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

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

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;

SELECT
  prod,
  `inpack`
FROM
  cube
WHERE
  `model` = 'M1-002DY5'
  AND `color` = 13017
  AND `size` = 61034
GROUP BY
  inpack
order by
  prod

SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-002DY5' AND `color` = 13017 AND `size` = 61034 GROUP BY inpack order by prod;