Symfony Profiler

SELECT
  count(f0_.id) AS sclr_0
FROM
  finance_trade_product_comment f0_
WHERE
  f0_.product_id = ?

SELECT count(f0_.id) AS sclr_0 FROM finance_trade_product_comment f0_ WHERE f0_.product_id = 54;

SELECT
  count(p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id
WHERE
  p1_.id = ?
  OR p1_.parent_id = ?
ORDER BY
  p0_.price ASC

SELECT count(p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id WHERE p1_.id = '2' OR p1_.parent_id = '2' ORDER BY p0_.price ASC;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.price AS price_1
FROM
  product p0_
  LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id
WHERE
  p1_.id = ?
  OR p1_.parent_id = ?
ORDER BY
  p0_.price ASC
LIMIT
  10

SELECT DISTINCT p0_.id AS id_0, p0_.price AS price_1 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id WHERE p1_.id = '2' OR p1_.parent_id = '2' ORDER BY p0_.price ASC LIMIT 10;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id
WHERE
  p1_.id = ?
  OR p1_.parent_id = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id WHERE p1_.id = '2' OR p1_.parent_id = '2';

SELECT
  p0_.id AS id_0,
  p0_.old_price AS old_price_1,
  p0_.price AS price_2,
  p0_.name AS name_3,
  p0_.image AS image_4,
  p0_.sales AS sales_5
FROM
  product p0_
  LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id
WHERE
  (
    p1_.id = ?
    OR p1_.parent_id = ?
  )
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.price ASC

SELECT p0_.id AS id_0, p0_.old_price AS old_price_1, p0_.price AS price_2, p0_.name AS name_3, p0_.image AS image_4, p0_.sales AS sales_5 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id WHERE (p1_.id = '2' OR p1_.parent_id = '2') AND p0_.id IN (54, 61, 46, 34, 62, 69, 16, 17, 75, 52) ORDER BY p0_.price ASC;