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

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;

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 (1984, 1985, 1986, 1953, 1954, 1955, 1922, 1923, 1924, 1891, 1892, 1893, 1860, 1861, 1862, 1829, 1830, 1831, 1799, 1800, 1798, 1767, 1768, 1769) 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 = 1986;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;