Symfony Profiler

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
WHERE
  p0_.is_home = 1
  AND p0_.is_enabled = 1

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.is_home = 1 AND p0_.is_enabled = 1;

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
WHERE
  p0_.is_home = 1
  AND p0_.is_enabled = 1
LIMIT
  10
OFFSET
  670

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ WHERE p0_.is_home = 1 AND p0_.is_enabled = 1 LIMIT 10 OFFSET 670;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price AS price_2,
  p0_.old_price AS old_price_3,
  p0_.image AS image_4
FROM
  product p0_
WHERE
  p0_.is_home = 1
  AND p0_.is_enabled = 1
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.old_price AS old_price_3, p0_.image AS image_4 FROM product p0_ WHERE p0_.is_home = 1 AND p0_.is_enabled = 1 AND p0_.id IN (835, 836, 837, 838, 839, 840, 841, 842, 843, 844);