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 42900

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 42900;

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 (1029892, 1029893, 1029894, 1029897, 1029898, 1029899, 1029901, 1029903, 1029904, 1029908, 1029910, 1029911, 1029913, 1029918, 1029919, 1029921, 1029923, 1029924, 1029925, 1036008) 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 = 1029892;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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