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

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

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

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

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

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

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

SELECT
  prod,
  `color`
FROM
  cube
WHERE
  `model` = 'M1-021RZG'
  AND `size` = 64021
  AND inpack = '5 шт'
GROUP BY
  color
order by
  size

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

SELECT
  prod,
  `size`
FROM
  cube
WHERE
  `model` = 'M1-021RZG'
  AND `color` = 28577
  AND inpack = '5 шт'
GROUP BY
  size
order by
  color

SELECT prod, `size` FROM cube WHERE `model` = 'M1-021RZG' AND `color` = 28577 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 = '47334'
  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 = '47334' and cv.value != '';

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

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

SELECT
  prod,
  `size`
FROM
  cube
WHERE
  `model` = 'M1-00KAG3'
  AND `color` = 17707
  AND inpack = '2 шт'
GROUP BY
  size
order by
  color

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

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
  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 (41164, 59170, 47073, 74789, 77583, 41004, 41023, 41156, 42684, 57231, 47334, 41252, 74711, 69965, 111022, 77549, 41078, 42685, 41152);

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.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-02432N'
  AND `size` = 61777
  AND inpack = '1 набір'
GROUP BY
  color
order by
  size

SELECT prod, `color` FROM cube WHERE `model` = 'M1-02432N' AND `size` = 61777 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.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 = 47332;

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
  prod,
  `inpack`
FROM
  cube
WHERE
  `model` = 'M1-021RZG'
  AND `color` = 28577
  AND `size` = 64021
GROUP BY
  inpack
order by
  prod

SELECT prod, `inpack` FROM cube WHERE `model` = 'M1-021RZG' AND `color` = 28577 AND `size` = 64021 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 = '41164'
  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 = '41164' 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 = '42684'
  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 = '42684' and cv.value != '';

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

SELECT prod, `color` FROM cube WHERE `model` = 'M1-00K656' AND `size` = 65614 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 = '41152'
  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 = '41152' 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 = 545
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 = 545 ORDER BY c0_.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 = '69965'
  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 = '69965' 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 = '74789'
  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 = '74789' and cv.value != '';