Symfony Profiler

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
WHERE
  t0.slug = ?
LIMIT
  1

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 WHERE t0.slug = 'bhp' LIMIT 1;

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
          INNER JOIN category_product c5_ ON p0_.id = c5_.product_id
          INNER JOIN category c4_ ON c4_.id = c5_.category_id
        WHERE
          c4_.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 INNER JOIN category_product c5_ ON p0_.id = c5_.product_id INNER JOIN category c4_ ON c4_.id = c5_.category_id WHERE c4_.id = 8 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,
          c4_.id AS id_28,
          c4_.name AS name_29,
          c4_.slug AS slug_30,
          c4_.created_at AS created_at_31,
          c4_.updated_at AS updated_at_32,
          c4_.active AS active_33
        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
          INNER JOIN category_product c5_ ON p0_.id = c5_.product_id
          INNER JOIN category c4_ ON c4_.id = c5_.category_id
        WHERE
          c4_.id = ?
        ORDER BY
          p3_.position ASC,
          p3_.id ASC
      ) dctrn_result_inner
    ORDER BY
      created_at_9 DESC
  ) dctrn_result
LIMIT
  24
OFFSET
  24

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, c4_.id AS id_28, c4_.name AS name_29, c4_.slug AS slug_30, c4_.created_at AS created_at_31, c4_.updated_at AS updated_at_32, c4_.active AS active_33 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 INNER JOIN category_product c5_ ON p0_.id = c5_.product_id INNER JOIN category c4_ ON c4_.id = c5_.category_id WHERE c4_.id = 8 ORDER BY p3_.position ASC, p3_.id ASC) dctrn_result_inner ORDER BY created_at_9 DESC) dctrn_result LIMIT 24 OFFSET 24;

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
  INNER JOIN category_product c5_ ON p0_.id = c5_.product_id
  INNER JOIN category c4_ ON c4_.id = c5_.category_id
WHERE
  c4_.id = ?
  AND 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 INNER JOIN category_product c5_ ON p0_.id = c5_.product_id INNER JOIN category c4_ ON c4_.id = c5_.category_id WHERE c4_.id = 8 AND p0_.id IN (1736, 1737, 1738, 1707, 1705, 1706, 1674, 1675, 1676, 1643, 1644, 1645, 1612, 1613, 1614, 1581, 1582, 1583, 1551, 1552, 1550, 1519, 1520, 1521) 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 = 1738;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;