Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.old_id AS old_id_1,
  s0_.name AS name_2,
  s0_.name_en AS name_en_3,
  s0_.description AS description_4,
  s0_.description_en AS description_en_5,
  s0_.photo AS photo_6,
  s0_.video AS video_7,
  s0_.price AS price_8,
  s0_.discount_percentage AS discount_percentage_9,
  s0_.min_amount AS min_amount_10,
  s0_.hit AS hit_11,
  s0_.display AS display_12,
  s0_.created_at AS created_at_13,
  s0_.updated_at AS updated_at_14,
  s0_.type AS type_15
FROM
  shop_item_cake s1_
  INNER JOIN shop_item s0_ ON s1_.id = s0_.id
  INNER JOIN shop_item_cake_shop_item_cake_category s3_ ON s1_.id = s3_.shop_item_cake_id
  INNER JOIN shop_item_cake_category s2_ ON s2_.id = s3_.shop_item_cake_category_id
  INNER JOIN shop_item_cake_shop_item_cake_sub_category s5_ ON s1_.id = s5_.shop_item_cake_id
  INNER JOIN shop_item_cake_sub_category s4_ ON s4_.id = s5_.shop_item_cake_sub_category_id
WHERE
  s0_.display = 1
  AND s2_.id = 15
  AND s4_.id = 60
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
ORDER BY
  s0_.created_at DESC

SELECT s0_.id AS id_0, s0_.old_id AS old_id_1, s0_.name AS name_2, s0_.name_en AS name_en_3, s0_.description AS description_4, s0_.description_en AS description_en_5, s0_.photo AS photo_6, s0_.video AS video_7, s0_.price AS price_8, s0_.discount_percentage AS discount_percentage_9, s0_.min_amount AS min_amount_10, s0_.hit AS hit_11, s0_.display AS display_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14, s0_.type AS type_15 FROM shop_item_cake s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id INNER JOIN shop_item_cake_shop_item_cake_category s3_ ON s1_.id = s3_.shop_item_cake_id INNER JOIN shop_item_cake_category s2_ ON s2_.id = s3_.shop_item_cake_category_id INNER JOIN shop_item_cake_shop_item_cake_sub_category s5_ ON s1_.id = s5_.shop_item_cake_id INNER JOIN shop_item_cake_sub_category s4_ ON s4_.id = s5_.shop_item_cake_sub_category_id WHERE s0_.display = 1 AND s2_.id = 15 AND s4_.id = 60 AND s0_.id IN (687, 689, 700, 629, 641, 643, 645, 646, 648, 650, 653, 654, 657, 667, 670, 583, 584, 615) ORDER BY s0_.created_at DESC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.name_en AS name_en_2,
  s0_.photo AS photo_3,
  s0_.description AS description_4,
  s0_.description_en AS description_en_5,
  s0_.slug AS slug_6,
  s0_.position AS position_7,
  s0_.display AS display_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10,
  s0_.category_id AS category_id_11
FROM
  shop_item_cake_sub_category s0_
WHERE
  s0_.category_id = ?
  AND s0_.id <> 60
  AND s0_.display = 1
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.name_en AS name_en_2, s0_.photo AS photo_3, s0_.description AS description_4, s0_.description_en AS description_en_5, s0_.slug AS slug_6, s0_.position AS position_7, s0_.display AS display_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.category_id AS category_id_11 FROM shop_item_cake_sub_category s0_ WHERE s0_.category_id = 15 AND s0_.id <> 60 AND s0_.display = 1 ORDER BY s0_.position ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_13
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.old_id AS old_id_1,
          s0_.name AS name_2,
          s0_.name_en AS name_en_3,
          s0_.description AS description_4,
          s0_.description_en AS description_en_5,
          s0_.photo AS photo_6,
          s0_.video AS video_7,
          s0_.price AS price_8,
          s0_.discount_percentage AS discount_percentage_9,
          s0_.min_amount AS min_amount_10,
          s0_.hit AS hit_11,
          s0_.display AS display_12,
          s0_.created_at AS created_at_13,
          s0_.updated_at AS updated_at_14,
          s1_.id AS id_15,
          s1_.name AS name_16,
          s1_.name_en AS name_en_17,
          s1_.photo AS photo_18,
          s1_.description AS description_19,
          s1_.description_en AS description_en_20,
          s1_.slug AS slug_21,
          s1_.position AS position_22,
          s1_.display AS display_23,
          s1_.created_at AS created_at_24,
          s1_.updated_at AS updated_at_25,
          s2_.id AS id_26,
          s2_.name AS name_27,
          s2_.name_en AS name_en_28,
          s2_.photo AS photo_29,
          s2_.description AS description_30,
          s2_.description_en AS description_en_31,
          s2_.slug AS slug_32,
          s2_.position AS position_33,
          s2_.display AS display_34,
          s2_.created_at AS created_at_35,
          s2_.updated_at AS updated_at_36,
          s0_.type AS type_37
        FROM
          shop_item_cake s3_
          INNER JOIN shop_item s0_ ON s3_.id = s0_.id
          INNER JOIN shop_item_cake_shop_item_cake_category s4_ ON s3_.id = s4_.shop_item_cake_id
          INNER JOIN shop_item_cake_category s1_ ON s1_.id = s4_.shop_item_cake_category_id
          INNER JOIN shop_item_cake_shop_item_cake_sub_category s5_ ON s3_.id = s5_.shop_item_cake_id
          INNER JOIN shop_item_cake_sub_category s2_ ON s2_.id = s5_.shop_item_cake_sub_category_id
        WHERE
          s0_.display = 1
          AND s1_.id = 15
          AND s2_.id = 60
      ) dctrn_result_inner
    ORDER BY
      created_at_13 DESC
  ) dctrn_result
LIMIT
  18

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_13 FROM (SELECT s0_.id AS id_0, s0_.old_id AS old_id_1, s0_.name AS name_2, s0_.name_en AS name_en_3, s0_.description AS description_4, s0_.description_en AS description_en_5, s0_.photo AS photo_6, s0_.video AS video_7, s0_.price AS price_8, s0_.discount_percentage AS discount_percentage_9, s0_.min_amount AS min_amount_10, s0_.hit AS hit_11, s0_.display AS display_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14, s1_.id AS id_15, s1_.name AS name_16, s1_.name_en AS name_en_17, s1_.photo AS photo_18, s1_.description AS description_19, s1_.description_en AS description_en_20, s1_.slug AS slug_21, s1_.position AS position_22, s1_.display AS display_23, s1_.created_at AS created_at_24, s1_.updated_at AS updated_at_25, s2_.id AS id_26, s2_.name AS name_27, s2_.name_en AS name_en_28, s2_.photo AS photo_29, s2_.description AS description_30, s2_.description_en AS description_en_31, s2_.slug AS slug_32, s2_.position AS position_33, s2_.display AS display_34, s2_.created_at AS created_at_35, s2_.updated_at AS updated_at_36, s0_.type AS type_37 FROM shop_item_cake s3_ INNER JOIN shop_item s0_ ON s3_.id = s0_.id INNER JOIN shop_item_cake_shop_item_cake_category s4_ ON s3_.id = s4_.shop_item_cake_id INNER JOIN shop_item_cake_category s1_ ON s1_.id = s4_.shop_item_cake_category_id INNER JOIN shop_item_cake_shop_item_cake_sub_category s5_ ON s3_.id = s5_.shop_item_cake_id INNER JOIN shop_item_cake_sub_category s2_ ON s2_.id = s5_.shop_item_cake_sub_category_id WHERE s0_.display = 1 AND s1_.id = 15 AND s2_.id = 60) dctrn_result_inner ORDER BY created_at_13 DESC) dctrn_result LIMIT 18;

SELECT
  MIN(s0_.price) AS sclr_0,
  MAX(s0_.price) AS sclr_1
FROM
  shop_item_cake s1_
  INNER JOIN shop_item s0_ ON s1_.id = s0_.id
  INNER JOIN shop_item_cake_shop_item_cake_category s3_ ON s1_.id = s3_.shop_item_cake_id
  INNER JOIN shop_item_cake_category s2_ ON s2_.id = s3_.shop_item_cake_category_id
  INNER JOIN shop_item_cake_shop_item_cake_sub_category s5_ ON s1_.id = s5_.shop_item_cake_id
  INNER JOIN shop_item_cake_sub_category s4_ ON s4_.id = s5_.shop_item_cake_sub_category_id
WHERE
  s0_.display = 1
  AND s2_.id = 15
  AND s4_.id = 60

SELECT MIN(s0_.price) AS sclr_0, MAX(s0_.price) AS sclr_1 FROM shop_item_cake s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id INNER JOIN shop_item_cake_shop_item_cake_category s3_ ON s1_.id = s3_.shop_item_cake_id INNER JOIN shop_item_cake_category s2_ ON s2_.id = s3_.shop_item_cake_category_id INNER JOIN shop_item_cake_shop_item_cake_sub_category s5_ ON s1_.id = s5_.shop_item_cake_id INNER JOIN shop_item_cake_sub_category s4_ ON s4_.id = s5_.shop_item_cake_sub_category_id WHERE s0_.display = 1 AND s2_.id = 15 AND s4_.id = 60;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.old_id AS old_id_1,
          s0_.name AS name_2,
          s0_.name_en AS name_en_3,
          s0_.description AS description_4,
          s0_.description_en AS description_en_5,
          s0_.photo AS photo_6,
          s0_.video AS video_7,
          s0_.price AS price_8,
          s0_.discount_percentage AS discount_percentage_9,
          s0_.min_amount AS min_amount_10,
          s0_.hit AS hit_11,
          s0_.display AS display_12,
          s0_.created_at AS created_at_13,
          s0_.updated_at AS updated_at_14,
          s0_.type AS type_15
        FROM
          shop_item_cake s1_
          INNER JOIN shop_item s0_ ON s1_.id = s0_.id
          INNER JOIN shop_item_cake_shop_item_cake_category s3_ ON s1_.id = s3_.shop_item_cake_id
          INNER JOIN shop_item_cake_category s2_ ON s2_.id = s3_.shop_item_cake_category_id
          INNER JOIN shop_item_cake_shop_item_cake_sub_category s5_ ON s1_.id = s5_.shop_item_cake_id
          INNER JOIN shop_item_cake_sub_category s4_ ON s4_.id = s5_.shop_item_cake_sub_category_id
        WHERE
          s0_.display = 1
          AND s2_.id = 15
          AND s4_.id = 60
        ORDER BY
          s0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.old_id AS old_id_1, s0_.name AS name_2, s0_.name_en AS name_en_3, s0_.description AS description_4, s0_.description_en AS description_en_5, s0_.photo AS photo_6, s0_.video AS video_7, s0_.price AS price_8, s0_.discount_percentage AS discount_percentage_9, s0_.min_amount AS min_amount_10, s0_.hit AS hit_11, s0_.display AS display_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14, s0_.type AS type_15 FROM shop_item_cake s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id INNER JOIN shop_item_cake_shop_item_cake_category s3_ ON s1_.id = s3_.shop_item_cake_id INNER JOIN shop_item_cake_category s2_ ON s2_.id = s3_.shop_item_cake_category_id INNER JOIN shop_item_cake_shop_item_cake_sub_category s5_ ON s1_.id = s5_.shop_item_cake_id INNER JOIN shop_item_cake_sub_category s4_ ON s4_.id = s5_.shop_item_cake_sub_category_id WHERE s0_.display = 1 AND s2_.id = 15 AND s4_.id = 60 ORDER BY s0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.name_en AS name_en_2,
  s0_.photo AS photo_3,
  s0_.description AS description_4,
  s0_.description_en AS description_en_5,
  s0_.slug AS slug_6,
  s0_.position AS position_7,
  s0_.display AS display_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10,
  s0_.category_id AS category_id_11
FROM
  shop_item_cake_sub_category s0_
  INNER JOIN shop_item_cake_category s1_ ON s0_.category_id = s1_.id
WHERE
  s1_.slug = 'corporate'
  AND s0_.slug = 'for-boys'
  AND s0_.display = 1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.name_en AS name_en_2, s0_.photo AS photo_3, s0_.description AS description_4, s0_.description_en AS description_en_5, s0_.slug AS slug_6, s0_.position AS position_7, s0_.display AS display_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.category_id AS category_id_11 FROM shop_item_cake_sub_category s0_ INNER JOIN shop_item_cake_category s1_ ON s0_.category_id = s1_.id WHERE s1_.slug = 'corporate' AND s0_.slug = 'for-boys' AND s0_.display = 1;

SELECT
  r0_.id AS id_0,
  r0_.link_from AS link_from_1,
  r0_.link_to AS link_to_2,
  r0_.code AS code_3,
  r0_.created_at AS created_at_4,
  r0_.updated_at AS updated_at_5
FROM
  redirect r0_
WHERE
  r0_.link_from = '/collection/corporate/for-boys'

SELECT r0_.id AS id_0, r0_.link_from AS link_from_1, r0_.link_to AS link_to_2, r0_.code AS code_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5 FROM redirect r0_ WHERE r0_.link_from = '/collection/corporate/for-boys';

SELECT
  s0_.id AS id_0,
  s0_.link AS link_1,
  s0_.title AS title_2,
  s0_.title_en AS title_en_3,
  s0_.description AS description_4,
  s0_.description_en AS description_en_5,
  s0_.keywords AS keywords_6,
  s0_.keywords_en AS keywords_en_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9
FROM
  static_meta s0_
WHERE
  s0_.link = '/collection/corporate/for-boys'

SELECT s0_.id AS id_0, s0_.link AS link_1, s0_.title AS title_2, s0_.title_en AS title_en_3, s0_.description AS description_4, s0_.description_en AS description_en_5, s0_.keywords AS keywords_6, s0_.keywords_en AS keywords_en_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9 FROM static_meta s0_ WHERE s0_.link = '/collection/corporate/for-boys';

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.name_en AS name_en_2,
  s0_.photo AS photo_3,
  s0_.description AS description_4,
  s0_.description_en AS description_en_5,
  s0_.slug AS slug_6,
  s0_.position AS position_7,
  s0_.display AS display_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10
FROM
  shop_item_cake_category s0_
WHERE
  s0_.slug = 'corporate'
  AND s0_.display = 1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.name_en AS name_en_2, s0_.photo AS photo_3, s0_.description AS description_4, s0_.description_en AS description_en_5, s0_.slug AS slug_6, s0_.position AS position_7, s0_.display AS display_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM shop_item_cake_category s0_ WHERE s0_.slug = 'corporate' AND s0_.display = 1;