Symfony Profiler

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_698483657d8e0' LIMIT 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
  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 = 29577;

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

select
  c.id,
  c.name,
  c.prior
from
  `catchar` as cc
  right join `char` as c on c.id = cc.char
where
  c.search > 0
group by
  c.id
order by
  c.prior desc

select c.id, c.name, c.prior
                from `catchar` as cc 
                right join `char` as c on c.id = cc.char 
                where c.search > 0 group by c.id order by c.prior desc;

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

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

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.colors AS colors_68,
  t0.sku AS sku_69,
  t0.model AS model_70,
  t0.chars AS chars_71,
  t0.tags AS tags_72,
  t0.external_id AS external_id_73
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.colors AS colors_68, t0.sku AS sku_69, t0.model AS model_70, t0.chars AS chars_71, t0.tags AS tags_72, t0.external_id AS external_id_73 FROM prod t0 WHERE t0.id IN (36471, 15494, 17445);

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

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

SELECT
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 309
  AND c0_.id IN (646, 653, 629)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 309 AND c0_.id IN (646, 653, 629) ORDER BY c0_.prior DESC, c0_.value ASC;

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 IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )
ORDER BY
  t0.prior DESC

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 IN (298, 309, 312, 270, 287, 274, 279, 272, 283, 288, 284, 315, 314, 297, 281, 311, 310, 316, 401, 402, 408) ORDER BY t0.prior DESC;

SELECT
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 270
  AND c0_.id IN (18739, 17189, 175)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 270 AND c0_.id IN (18739, 17189, 175) ORDER BY c0_.prior DESC, c0_.value ASC;

SELECT
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 283
  AND c0_.id IN (25904, 25901, 25896)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 283 AND c0_.id IN (25904, 25901, 25896) ORDER BY c0_.prior DESC, c0_.value ASC;

SELECT
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 272
  AND c0_.id IN (22290, 22290, 22292)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 272 AND c0_.id IN (22290, 22290, 22292) ORDER BY c0_.prior DESC, c0_.value ASC;

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.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  page_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 page_translation t0 WHERE t0.object_id = 565;

SELECT
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 287
  AND c0_.id IN (654, 654, 654)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 287 AND c0_.id IN (654, 654, 654) ORDER BY c0_.prior DESC, c0_.value ASC;

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
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 274
  AND c0_.id IN (3222, 30202, 29551)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 274 AND c0_.id IN (3222, 30202, 29551) ORDER BY c0_.prior DESC, c0_.value ASC;

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

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 = 0 ORDER BY t0.id DESC;

SELECT
  c0_.id AS id_0,
  c0_.intname AS intname_1,
  c0_.cat AS cat_2
FROM
  cat c0_
WHERE
  c0_.id = 27
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 = 27 ORDER BY c0_.prior DESC;

SELECT
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 298
  AND c0_.id IN (29577, 29578, 29578)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 298 AND c0_.id IN (29577, 29578, 29578) ORDER BY c0_.prior DESC, c0_.value ASC;

SELECT
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 288
  AND c0_.id IN (339, 5924, 23)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 288 AND c0_.id IN (339, 5924, 23) ORDER BY c0_.prior DESC, c0_.value ASC;

SELECT
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 310
  AND c0_.id IN (12847, 12847)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 310 AND c0_.id IN (12847, 12847) ORDER BY c0_.prior DESC, c0_.value ASC;

SELECT
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 312
  AND c0_.id IN (12790, 12790, 12790)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 312 AND c0_.id IN (12790, 12790, 12790) ORDER BY c0_.prior DESC, c0_.value ASC;

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/action' LIMIT 1;

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
  c0_.id AS id_0,
  c0_.char AS char_1,
  c0_.value AS value_2,
  c0_.visible AS visible_3,
  c0_.prior AS prior_4
FROM
  charval c0_
WHERE
  c0_.char = 315
  AND c0_.id IN (25895, 25895, 25895)
ORDER BY
  c0_.prior DESC,
  c0_.value ASC

SELECT c0_.id AS id_0, c0_.char AS char_1, c0_.value AS value_2, c0_.visible AS visible_3, c0_.prior AS prior_4 FROM charval c0_ WHERE c0_.char = 315 AND c0_.id IN (25895, 25895, 25895) ORDER BY c0_.prior DESC, c0_.value ASC;