Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.type AS type_2,
          p0_.catalog AS catalog_3,
          p0_.unit AS unit_4,
          p0_.pkwiu AS pkwiu_5,
          p0_.margin AS margin_6,
          p0_.unit_margin AS unit_margin_7,
          p0_.slug AS slug_8,
          p0_.created_at AS created_at_9,
          p0_.updated_at AS updated_at_10,
          p1_.id AS id_11,
          p1_.type AS type_12,
          p1_.unit_cost AS unit_cost_13,
          p1_.vat_rate AS vat_rate_14,
          p1_.vat AS vat_15,
          p1_.gross AS gross_16,
          p1_.created_at AS created_at_17,
          p1_.updated_at AS updated_at_18,
          p2_.id AS id_19,
          p2_.name AS name_20,
          p2_.created_at AS created_at_21,
          p2_.updated_at AS updated_at_22,
          p2_.active AS active_23,
          p3_.id AS id_24,
          p3_.media AS media_25,
          p3_.thumbnail AS thumbnail_26,
          p3_.position AS position_27
        FROM
          product p0_
          LEFT JOIN price p1_ ON p0_.id = p1_.product_id
          LEFT JOIN price_list p2_ ON p1_.price_list_id = p2_.id
          LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id
        ORDER BY
          p0_.created_at DESC,
          p3_.position ASC,
          p3_.id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.catalog AS catalog_3, p0_.unit AS unit_4, p0_.pkwiu AS pkwiu_5, p0_.margin AS margin_6, p0_.unit_margin AS unit_margin_7, p0_.slug AS slug_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p1_.id AS id_11, p1_.type AS type_12, p1_.unit_cost AS unit_cost_13, p1_.vat_rate AS vat_rate_14, p1_.vat AS vat_15, p1_.gross AS gross_16, p1_.created_at AS created_at_17, p1_.updated_at AS updated_at_18, p2_.id AS id_19, p2_.name AS name_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, p2_.active AS active_23, p3_.id AS id_24, p3_.media AS media_25, p3_.thumbnail AS thumbnail_26, p3_.position AS position_27 FROM product p0_ LEFT JOIN price p1_ ON p0_.id = p1_.product_id LEFT JOIN price_list p2_ ON p1_.price_list_id = p2_.id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id ORDER BY p0_.created_at DESC, p3_.position ASC, p3_.id ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_9
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.type AS type_2,
          p0_.catalog AS catalog_3,
          p0_.unit AS unit_4,
          p0_.pkwiu AS pkwiu_5,
          p0_.margin AS margin_6,
          p0_.unit_margin AS unit_margin_7,
          p0_.slug AS slug_8,
          p0_.created_at AS created_at_9,
          p0_.updated_at AS updated_at_10,
          p1_.id AS id_11,
          p1_.type AS type_12,
          p1_.unit_cost AS unit_cost_13,
          p1_.vat_rate AS vat_rate_14,
          p1_.vat AS vat_15,
          p1_.gross AS gross_16,
          p1_.created_at AS created_at_17,
          p1_.updated_at AS updated_at_18,
          p2_.id AS id_19,
          p2_.name AS name_20,
          p2_.created_at AS created_at_21,
          p2_.updated_at AS updated_at_22,
          p2_.active AS active_23,
          p3_.id AS id_24,
          p3_.media AS media_25,
          p3_.thumbnail AS thumbnail_26,
          p3_.position AS position_27
        FROM
          product p0_
          LEFT JOIN price p1_ ON p0_.id = p1_.product_id
          LEFT JOIN price_list p2_ ON p1_.price_list_id = p2_.id
          LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id
        ORDER BY
          p3_.position ASC,
          p3_.id ASC
      ) dctrn_result_inner
    ORDER BY
      created_at_9 DESC
  ) dctrn_result
LIMIT
  24
OFFSET
  1896

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_9 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.catalog AS catalog_3, p0_.unit AS unit_4, p0_.pkwiu AS pkwiu_5, p0_.margin AS margin_6, p0_.unit_margin AS unit_margin_7, p0_.slug AS slug_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p1_.id AS id_11, p1_.type AS type_12, p1_.unit_cost AS unit_cost_13, p1_.vat_rate AS vat_rate_14, p1_.vat AS vat_15, p1_.gross AS gross_16, p1_.created_at AS created_at_17, p1_.updated_at AS updated_at_18, p2_.id AS id_19, p2_.name AS name_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, p2_.active AS active_23, p3_.id AS id_24, p3_.media AS media_25, p3_.thumbnail AS thumbnail_26, p3_.position AS position_27 FROM product p0_ LEFT JOIN price p1_ ON p0_.id = p1_.product_id LEFT JOIN price_list p2_ ON p1_.price_list_id = p2_.id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id ORDER BY p3_.position ASC, p3_.id ASC) dctrn_result_inner ORDER BY created_at_9 DESC) dctrn_result LIMIT 24 OFFSET 1896;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.type AS type_2,
  p0_.catalog AS catalog_3,
  p0_.unit AS unit_4,
  p0_.pkwiu AS pkwiu_5,
  p0_.margin AS margin_6,
  p0_.unit_margin AS unit_margin_7,
  p0_.slug AS slug_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  p1_.id AS id_11,
  p1_.type AS type_12,
  p1_.unit_cost AS unit_cost_13,
  p1_.vat_rate AS vat_rate_14,
  p1_.vat AS vat_15,
  p1_.gross AS gross_16,
  p1_.created_at AS created_at_17,
  p1_.updated_at AS updated_at_18,
  p2_.id AS id_19,
  p2_.name AS name_20,
  p2_.created_at AS created_at_21,
  p2_.updated_at AS updated_at_22,
  p2_.active AS active_23,
  p3_.id AS id_24,
  p3_.media AS media_25,
  p3_.thumbnail AS thumbnail_26,
  p3_.position AS position_27,
  p0_.created_by AS created_by_28,
  p0_.updated_by AS updated_by_29,
  p1_.product_id AS product_id_30,
  p1_.price_list_id AS price_list_id_31,
  p1_.created_by AS created_by_32,
  p1_.updated_by AS updated_by_33,
  p2_.created_by AS created_by_34,
  p2_.updated_by AS updated_by_35,
  p3_.product_id AS product_id_36
FROM
  product p0_
  LEFT JOIN price p1_ ON p0_.id = p1_.product_id
  LEFT JOIN price_list p2_ ON p1_.price_list_id = p2_.id
  LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.created_at DESC,
  p3_.position ASC,
  p3_.id ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.catalog AS catalog_3, p0_.unit AS unit_4, p0_.pkwiu AS pkwiu_5, p0_.margin AS margin_6, p0_.unit_margin AS unit_margin_7, p0_.slug AS slug_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p1_.id AS id_11, p1_.type AS type_12, p1_.unit_cost AS unit_cost_13, p1_.vat_rate AS vat_rate_14, p1_.vat AS vat_15, p1_.gross AS gross_16, p1_.created_at AS created_at_17, p1_.updated_at AS updated_at_18, p2_.id AS id_19, p2_.name AS name_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, p2_.active AS active_23, p3_.id AS id_24, p3_.media AS media_25, p3_.thumbnail AS thumbnail_26, p3_.position AS position_27, p0_.created_by AS created_by_28, p0_.updated_by AS updated_by_29, p1_.product_id AS product_id_30, p1_.price_list_id AS price_list_id_31, p1_.created_by AS created_by_32, p1_.updated_by AS updated_by_33, p2_.created_by AS created_by_34, p2_.updated_by AS updated_by_35, p3_.product_id AS product_id_36 FROM product p0_ LEFT JOIN price p1_ ON p0_.id = p1_.product_id LEFT JOIN price_list p2_ ON p1_.price_list_id = p2_.id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id WHERE p0_.id IN (140, 141, 142, 143, 144, 145, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 57, 58, 59, 60, 61, 62, 63, 64) ORDER BY p0_.created_at DESC, p3_.position ASC, p3_.id ASC;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 145;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 144;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 143;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 142;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 141;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 140;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 101;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 106;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 105;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 104;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 103;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 102;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 100;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 99;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 98;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 97;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 57;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 64;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 63;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 62;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 61;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 60;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 59;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.product_id AS product_id_3
FROM
  excerpt t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3 FROM excerpt t0 WHERE t0.product_id = 58;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.active AS active_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  category t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.active AS active_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM category t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.active AS active_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  category t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.active AS active_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM category t0 ORDER BY t0.name ASC;