Symfony Profiler

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/candy-bar/748/kendi-bar-no48'

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/candy-bar/748/kendi-bar-no48';

SELECT
  t1.id AS id_2,
  t1.old_id AS old_id_3,
  t1.name AS name_4,
  t1.name_en AS name_en_5,
  t1.description AS description_6,
  t1.description_en AS description_en_7,
  t1.photo AS photo_8,
  t1.video AS video_9,
  t1.price AS price_10,
  t1.discount_percentage AS discount_percentage_11,
  t1.min_amount AS min_amount_12,
  t1.hit AS hit_13,
  t1.display AS display_14,
  t1.created_at AS created_at_15,
  t1.updated_at AS updated_at_16,
  t1.type
FROM
  shop_item_candy_bar t0
  INNER JOIN shop_item t1 ON t0.id = t1.id
WHERE
  t1.id = ?
  AND t1.display = ?
LIMIT
  1

SELECT t1.id AS id_2, t1.old_id AS old_id_3, t1.name AS name_4, t1.name_en AS name_en_5, t1.description AS description_6, t1.description_en AS description_en_7, t1.photo AS photo_8, t1.video AS video_9, t1.price AS price_10, t1.discount_percentage AS discount_percentage_11, t1.min_amount AS min_amount_12, t1.hit AS hit_13, t1.display AS display_14, t1.created_at AS created_at_15, t1.updated_at AS updated_at_16, t1.type FROM shop_item_candy_bar t0 INNER JOIN shop_item t1 ON t0.id = t1.id WHERE t1.id = '748' AND t1.display = 1 LIMIT 1;

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/candy-bar/748/kendi-bar-no48'

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/candy-bar/748/kendi-bar-no48';

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.item_id AS item_id_5
FROM
  shop_item_photo t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5 FROM shop_item_photo t0 WHERE t0.item_id = 748;

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_candy_bar s1_
          INNER JOIN shop_item s0_ ON s1_.id = s0_.id
        WHERE
          s0_.display = 1
          AND s0_.id <> 748
        ORDER BY
          RAND() ASC
      ) 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_candy_bar s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id WHERE s0_.display = 1 AND s0_.id <> 748 ORDER BY RAND() ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      RAND()
    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_candy_bar s1_
          INNER JOIN shop_item s0_ ON s1_.id = s0_.id
        WHERE
          s0_.display = 1
          AND s0_.id <> 748
      ) dctrn_result_inner
    ORDER BY
      RAND() ASC
  ) dctrn_result
LIMIT
  8

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, RAND() 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_candy_bar s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id WHERE s0_.display = 1 AND s0_.id <> 748) dctrn_result_inner ORDER BY RAND() ASC) dctrn_result LIMIT 8;

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_candy_bar s1_
  INNER JOIN shop_item s0_ ON s1_.id = s0_.id
WHERE
  s0_.display = 1
  AND s0_.id <> 748
  AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  RAND() ASC

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_candy_bar s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id WHERE s0_.display = 1 AND s0_.id <> 748 AND s0_.id IN (722, 721, 727, 742, 740, 723, 734, 737) ORDER BY RAND() ASC;