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
  144

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 144;

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 (496, 497, 498, 465, 466, 467, 434, 435, 436, 403, 404, 405, 372, 373, 374, 310, 311, 312, 341, 342, 343, 279, 280, 281) 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 = 498;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;