Symfony Profiler

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN categories c1_ ON p0_.category_id = c1_.id
  LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id
WHERE
  p0_.price_pdv > 0
  AND p0_.is_suspended = 0
  AND (
    p0_.title LIKE ?
    OR p0_.barcode LIKE ?
    OR p0_.product_key LIKE ?
    OR p0_.sku LIKE ?
  )

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.price_pdv > 0 AND p0_.is_suspended = 0 AND (p0_.title LIKE '%%' OR p0_.barcode LIKE '%%' OR p0_.product_key LIKE '%%' OR p0_.sku LIKE '%%');

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.is_out_of_stock AS is_out_of_stock_1,
  p0_.title AS title_2
FROM
  product p0_
  LEFT JOIN categories c1_ ON p0_.category_id = c1_.id
  LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id
WHERE
  p0_.price_pdv > 0
  AND p0_.is_suspended = 0
  AND (
    p0_.title LIKE ?
    OR p0_.barcode LIKE ?
    OR p0_.product_key LIKE ?
    OR p0_.sku LIKE ?
  )
ORDER BY
  p0_.is_out_of_stock ASC,
  p0_.title ASC
LIMIT
  20 OFFSET 77320

SELECT DISTINCT p0_.id AS id_0, p0_.is_out_of_stock AS is_out_of_stock_1, p0_.title AS title_2 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.price_pdv > 0 AND p0_.is_suspended = 0 AND (p0_.title LIKE '%%' OR p0_.barcode LIKE '%%' OR p0_.product_key LIKE '%%' OR p0_.sku LIKE '%%') ORDER BY p0_.is_out_of_stock ASC, p0_.title ASC LIMIT 20 OFFSET 77320;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.sku AS sku_2,
  p0_.barcode AS barcode_3,
  p0_.product_key AS product_key_4,
  p0_.price_pdv AS price_pdv_5,
  p0_.price AS price_6,
  p0_.vat AS vat_7,
  p0_.price_prikaz AS price_prikaz_8,
  p0_.is_out_of_stock AS is_out_of_stock_9,
  p0_.is_new AS is_new_10,
  p0_.is_discount AS is_discount_11,
  p0_.is_super_product AS is_super_product_12,
  p0_.is_outlet AS is_outlet_13,
  p0_.is_suspended AS is_suspended_14,
  c1_.title AS title_15,
  i2_.thumbnail_100x100 AS thumbnail_100x100_16,
  i2_.thumbnail_500x500 AS thumbnail_500x500_17
FROM
  product p0_
  LEFT JOIN categories c1_ ON p0_.category_id = c1_.id
  LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id
WHERE
  p0_.price_pdv > 0
  AND p0_.is_suspended = 0
  AND (
    p0_.title LIKE ?
    OR p0_.barcode LIKE ?
    OR p0_.product_key LIKE ?
    OR p0_.sku LIKE ?
  )
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p0_.is_out_of_stock ASC,
  p0_.title ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.sku AS sku_2, p0_.barcode AS barcode_3, p0_.product_key AS product_key_4, p0_.price_pdv AS price_pdv_5, p0_.price AS price_6, p0_.vat AS vat_7, p0_.price_prikaz AS price_prikaz_8, p0_.is_out_of_stock AS is_out_of_stock_9, p0_.is_new AS is_new_10, p0_.is_discount AS is_discount_11, p0_.is_super_product AS is_super_product_12, p0_.is_outlet AS is_outlet_13, p0_.is_suspended AS is_suspended_14, c1_.title AS title_15, i2_.thumbnail_100x100 AS thumbnail_100x100_16, i2_.thumbnail_500x500 AS thumbnail_500x500_17 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.price_pdv > 0 AND p0_.is_suspended = 0 AND (p0_.title LIKE '%%' OR p0_.barcode LIKE '%%' OR p0_.product_key LIKE '%%' OR p0_.sku LIKE '%%') AND p0_.id IN (1006930, 1013184, 1007021, 1012750, 1006884, 1006883, 1015197, 1012752, 1006885, 1012748, 1004998, 32877, 1043242, 5141, 4496, 39712, 4301, 1000123, 2571, 39656) ORDER BY p0_.is_out_of_stock ASC, p0_.title ASC;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1006930;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1006930;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1013184;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1013184;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1007021;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1007021;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1012750;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1012750;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1006884;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1006884;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1006883;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1006883;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1015197;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1015197;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1012752;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1012752;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1006885;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1006885;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1012748;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1012748;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1004998;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1004998;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 32877;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 32877;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1043242;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1043242;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 5141;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 5141;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 4496;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 4496;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 39712;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 39712;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1000123;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 1000123;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 4301;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 4301;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 2571;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 2571;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 39656;

SELECT
  AVG(c0_.ocena) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.status = ?
  AND c0_.ocena IS NOT NULL
  AND c0_.product_id = ?

SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 39656;