Symfony Profiler

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,
  prior,
  ordered,
  changed,
  colors
FROM
  prod
WHERE
  visible = 1
  and (
    num > 0
    or num2 > 0
    or num3 > 0
  )
  and (
    cat = 879
    or cat = 880
    or cat = 881
    or cat = 882
    or cat = 888
    or cat = 898
    or cat = 937
    or cat = 949
    or cat = 41
  )

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, prior, ordered, changed, colors FROM prod WHERE visible = 1 and (num > 0 or num2 > 0 or num3 > 0) and (cat = 879 or cat = 880 or cat = 881 or cat = 882 or cat = 888 or cat = 898 or cat = 937 or cat = 949 or cat = 41);

select
  c.id,
  c.name,
  c.prior
from
  `catchar` as cc
  right join `char` as c on c.id = cc.char
where
  cc.cat = '41'
  and 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 cc.cat = '41' and c.search > 0 group by c.id order by c.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 = 272
  AND c0_.id IN (
    59855, 59855, 59855, 59855, 59855, 59855,
    59855, 59855, 59855, 59855, 59855,
    59855, 59855, 59855, 59855, 59855,
    59855, 59855, 59855, 59855, 59855,
    59855, 59855, 59855, 25790, 25790,
    24843, 22292, 59855, 59855, 59855,
    22289, 25954, 22290, 5985, 2, 2, 2, 24843,
    22291, 22291, 22291, 22291, 24843,
    22291, 22291, 2842, 24843, 24843, 22291,
    22295, 22291, 22292, 22291, 59855,
    59855, 59855, 59855, 59855, 59855,
    59855, 59855, 59855, 59855, 59855,
    59855, 59855, 59855, 59855, 59855,
    59855, 59855, 59855, 59855, 59855,
    59855, 59855, 59855, 59855
  )
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 (59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 25790, 25790, 24843, 22292, 59855, 59855, 59855, 22289, 25954, 22290, 5985, 2, 2, 2, 24843, 22291, 22291, 22291, 22291, 24843, 22291, 22291, 2842, 24843, 24843, 22291, 22295, 22291, 22292, 22291, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855, 59855) ORDER BY c0_.prior DESC, c0_.value ASC;

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

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 (
    137, 13211, 132, 593, 13170, 13173, 13173,
    593, 593, 438, 438, 14617, 13211, 13251,
    132, 59355, 593, 146, 14617, 131, 131,
    59410, 28446, 132, 13170
  )
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 (137, 13211, 132, 593, 13170, 13173, 13173, 593, 593, 438, 438, 14617, 13211, 13251, 132, 59355, 593, 146, 14617, 131, 131, 59410, 28446, 132, 13170) ORDER BY c0_.prior DESC, c0_.value ASC;

SELECT
  t0.id AS id_1,
  t0.oldurl AS oldurl_2,
  t0.newurl AS newurl_3
FROM
  redirect t0

SELECT t0.id AS id_1, t0.oldurl AS oldurl_2, t0.newurl AS newurl_3 FROM redirect t0;

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_.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 = 276
  AND c0_.id IN (
    15754, 15754, 9779, 9779, 15754, 15754,
    15754, 9779, 9779, 15754, 9779, 9779,
    9779, 15754, 9779, 9779, 9779, 9779,
    15754, 9779, 9779, 15754, 15754, 9779,
    1571, 1571, 1948, 28254, 28254, 23782,
    1571, 1948, 733, 15721, 15721, 15721,
    2617, 1571, 31087, 31813, 12629, 15790
  )
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 = 276 AND c0_.id IN (15754, 15754, 9779, 9779, 15754, 15754, 15754, 9779, 9779, 15754, 9779, 9779, 9779, 15754, 9779, 9779, 9779, 9779, 15754, 9779, 9779, 15754, 15754, 9779, 1571, 1571, 1948, 28254, 28254, 23782, 1571, 1948, 733, 15721, 15721, 15721, 2617, 1571, 31087, 31813, 12629, 15790) 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 (
    635, 629, 629, 629, 629, 629, 646, 646,
    629, 629, 638, 638, 629, 635, 635, 635,
    631, 635, 635, 635, 638, 638, 12821,
    12821, 634, 629, 631, 629, 634, 634,
    12788, 634, 12788, 12788, 12788, 634
  )
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 (635, 629, 629, 629, 629, 629, 646, 646, 629, 629, 638, 638, 629, 635, 635, 635, 631, 635, 635, 635, 638, 638, 12821, 12821, 634, 629, 631, 629, 634, 634, 12788, 634, 12788, 12788, 12788, 634) 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
  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 (270, 309, 272, 276) ORDER BY t0.prior DESC;