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

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

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

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;

select
  p.id,
  p.art,
  p.name,
  p.num,
  p.num2,
  p.num3,
  p.price as price,
  p.price2 as price2,
  p.price3 as price3,
  p.colors,
  p.skidka as skidka,
  p.skidka2 as skidka2,
  p.skidka3 as skidka3,
  p.inpack
from
  cart as c
  left join prod as p on p.id = c.prod_id
where
  c.order_id = 2314
  and p.visible = 1
  and (
    p.num > 0
    or p.num2 > 0
    or p.num3 > 0
  )
  and p.id != 58937
limit
  6

select p.id, p.art, p.name, p.num, p.num2, p.num3, p.price as price, p.price2 as price2, p.price3 as price3, p.colors, p.skidka as skidka, p.skidka2 as skidka2, p.skidka3 as skidka3, p.inpack 
					from cart as c
					left join prod as p on p.id = c.prod_id 
					where c.order_id = 2314 and p.visible = 1 and (p.num > 0 or p.num2 > 0 or p.num3 > 0) and p.id != 58937 limit 6;

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_681d3e17c3d14' 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 = 220;

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

SELECT
  t0.id AS id_1,
  t0.order_id AS order_id_2,
  t0.price AS price_3,
  t0.num AS num_4,
  t0.skidka AS skidka_5,
  t0.userdiscount AS userdiscount_6,
  t0.numdiscount AS numdiscount_7,
  t0.sumdiscount AS sumdiscount_8,
  t0.var AS var_9,
  t0.prod_id AS prod_id_10
FROM
  cart t0
WHERE
  t0.prod_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.price AS price_3, t0.num AS num_4, t0.skidka AS skidka_5, t0.userdiscount AS userdiscount_6, t0.numdiscount AS numdiscount_7, t0.sumdiscount AS sumdiscount_8, t0.var AS var_9, t0.prod_id AS prod_id_10 FROM cart t0 WHERE t0.prod_id = 58937 LIMIT 1;

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
  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 = '58937'
  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 = '58937' 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.prior AS prior_52,
  t0.title AS title_53,
  t0.descr AS descr_54,
  t0.kw AS kw_55,
  t0.h1 AS h1_56,
  t0.rating AS rating_57,
  t0.spec AS spec_58,
  t0.ordered AS ordered_59,
  t0.izm AS izm_60,
  t0.pic AS pic_61,
  t0.views AS views_62,
  t0.justuploaded AS justuploaded_63,
  t0.uploaded AS uploaded_64,
  t0.changed AS changed_65,
  t0.colors AS colors_66,
  t0.sku AS sku_67,
  t0.model AS model_68,
  t0.chars AS chars_69,
  t0.tags AS tags_70,
  t0.external_id AS external_id_71
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.prior AS prior_52, t0.title AS title_53, t0.descr AS descr_54, t0.kw AS kw_55, t0.h1 AS h1_56, t0.rating AS rating_57, t0.spec AS spec_58, t0.ordered AS ordered_59, t0.izm AS izm_60, t0.pic AS pic_61, t0.views AS views_62, t0.justuploaded AS justuploaded_63, t0.uploaded AS uploaded_64, t0.changed AS changed_65, t0.colors AS colors_66, t0.sku AS sku_67, t0.model AS model_68, t0.chars AS chars_69, t0.tags AS tags_70, t0.external_id AS external_id_71 FROM prod t0 WHERE t0.id = 58937;

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

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
  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.prior AS prior_52,
  t0.title AS title_53,
  t0.descr AS descr_54,
  t0.kw AS kw_55,
  t0.h1 AS h1_56,
  t0.rating AS rating_57,
  t0.spec AS spec_58,
  t0.ordered AS ordered_59,
  t0.izm AS izm_60,
  t0.pic AS pic_61,
  t0.views AS views_62,
  t0.justuploaded AS justuploaded_63,
  t0.uploaded AS uploaded_64,
  t0.changed AS changed_65,
  t0.colors AS colors_66,
  t0.sku AS sku_67,
  t0.model AS model_68,
  t0.chars AS chars_69,
  t0.tags AS tags_70,
  t0.external_id AS external_id_71
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.prior AS prior_52, t0.title AS title_53, t0.descr AS descr_54, t0.kw AS kw_55, t0.h1 AS h1_56, t0.rating AS rating_57, t0.spec AS spec_58, t0.ordered AS ordered_59, t0.izm AS izm_60, t0.pic AS pic_61, t0.views AS views_62, t0.justuploaded AS justuploaded_63, t0.uploaded AS uploaded_64, t0.changed AS changed_65, t0.colors AS colors_66, t0.sku AS sku_67, t0.model AS model_68, t0.chars AS chars_69, t0.tags AS tags_70, t0.external_id AS external_id_71 FROM prod t0 WHERE t0.id IN (92640, 4310);

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