Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_2
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.type AS type_1,
          p0_.name AS name_2,
          p0_.description AS description_3,
          p0_.presentation AS presentation_4,
          p0_.is_wholesaler AS is_wholesaler_5,
          p0_.publicSale AS publicSale_6,
          p0_.active AS active_7,
          p0_.isDeleted AS isDeleted_8,
          p0_.recommended AS recommended_9,
          p0_.tax AS tax_10,
          p0_.base_price AS base_price_11,
          p0_.price AS price_12,
          p0_.thumbnail AS thumbnail_13,
          p0_.image AS image_14
        FROM
          product p0_
        WHERE
          p0_.active = ?
          AND p0_.publicSale = ?
          AND p0_.idCategory = ?
      ) dctrn_result_inner
    ORDER BY
      name_2 ASC,
      id_0 ASC
  ) dctrn_result
LIMIT
  20 OFFSET 30

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_2 FROM (SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.name AS name_2, p0_.description AS description_3, p0_.presentation AS presentation_4, p0_.is_wholesaler AS is_wholesaler_5, p0_.publicSale AS publicSale_6, p0_.active AS active_7, p0_.isDeleted AS isDeleted_8, p0_.recommended AS recommended_9, p0_.tax AS tax_10, p0_.base_price AS base_price_11, p0_.price AS price_12, p0_.thumbnail AS thumbnail_13, p0_.image AS image_14 FROM product p0_ WHERE p0_.active = 1 AND p0_.publicSale = 1 AND p0_.idCategory = 16) dctrn_result_inner ORDER BY name_2 ASC, id_0 ASC) dctrn_result LIMIT 20 OFFSET 30;

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.name AS name_2,
  p0_.description AS description_3,
  p0_.presentation AS presentation_4,
  p0_.is_wholesaler AS is_wholesaler_5,
  p0_.publicSale AS publicSale_6,
  p0_.active AS active_7,
  p0_.isDeleted AS isDeleted_8,
  p0_.recommended AS recommended_9,
  p0_.tax AS tax_10,
  p0_.base_price AS base_price_11,
  p0_.price AS price_12,
  p0_.thumbnail AS thumbnail_13,
  p0_.image AS image_14,
  p0_.idCategory AS idCategory_15,
  p0_.idSize AS idSize_16,
  p0_.unit_of_measurement_id AS unit_of_measurement_id_17
FROM
  product p0_
WHERE
  p0_.active = ?
  AND p0_.publicSale = ?
  AND p0_.idCategory = ?
  AND p0_.id IN (?)
ORDER BY
  p0_.name ASC,
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.name AS name_2, p0_.description AS description_3, p0_.presentation AS presentation_4, p0_.is_wholesaler AS is_wholesaler_5, p0_.publicSale AS publicSale_6, p0_.active AS active_7, p0_.isDeleted AS isDeleted_8, p0_.recommended AS recommended_9, p0_.tax AS tax_10, p0_.base_price AS base_price_11, p0_.price AS price_12, p0_.thumbnail AS thumbnail_13, p0_.image AS image_14, p0_.idCategory AS idCategory_15, p0_.idSize AS idSize_16, p0_.unit_of_measurement_id AS unit_of_measurement_id_17 FROM product p0_ WHERE p0_.active = 1 AND p0_.publicSale = 1 AND p0_.idCategory = 16 AND p0_.id IN (390, 969, 807, 77, 423, 424, 884, 910, 963, 790, 527, 528, 621, 529, 834, 622, 623, 190, 379, 992) ORDER BY p0_.name ASC, p0_.id ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.type AS type_1,
          p0_.name AS name_2,
          p0_.description AS description_3,
          p0_.presentation AS presentation_4,
          p0_.is_wholesaler AS is_wholesaler_5,
          p0_.publicSale AS publicSale_6,
          p0_.active AS active_7,
          p0_.isDeleted AS isDeleted_8,
          p0_.recommended AS recommended_9,
          p0_.tax AS tax_10,
          p0_.base_price AS base_price_11,
          p0_.price AS price_12,
          p0_.thumbnail AS thumbnail_13,
          p0_.image AS image_14
        FROM
          product p0_
        WHERE
          p0_.active = ?
          AND p0_.publicSale = ?
          AND p0_.idCategory = ?
        ORDER BY
          p0_.name ASC,
          p0_.id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.name AS name_2, p0_.description AS description_3, p0_.presentation AS presentation_4, p0_.is_wholesaler AS is_wholesaler_5, p0_.publicSale AS publicSale_6, p0_.active AS active_7, p0_.isDeleted AS isDeleted_8, p0_.recommended AS recommended_9, p0_.tax AS tax_10, p0_.base_price AS base_price_11, p0_.price AS price_12, p0_.thumbnail AS thumbnail_13, p0_.image AS image_14 FROM product p0_ WHERE p0_.active = 1 AND p0_.publicSale = 1 AND p0_.idCategory = 16 ORDER BY p0_.name ASC, p0_.id ASC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.display AS display_3,
  t0.parent AS parent_4
FROM
  productCategories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = 16;