Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 17
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations
• Messages
• Serializer
• Configuration

Query Metrics

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 FROM instagram_photo t0 ORDER BY t0.id DESC LIMIT 6

[]

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
FROM
  instagram_photo t0
ORDER BY
  t0.id DESC
LIMIT
  6

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 FROM instagram_photo t0 ORDER BY t0.id DESC LIMIT 6;

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 WHERE s0_.display = 1 AND (s0_.hit = 1 OR s0_.discount_percentage > 0 OR DATEDIFF(CURRENT_TIME, s0_.created_at) < 30) 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_cake s1_
          INNER JOIN shop_item s0_ ON s1_.id = s0_.id
        WHERE
          s0_.display = 1
          AND (
            s0_.hit = 1
            OR s0_.discount_percentage > 0
            OR DATEDIFF(CURRENT_TIME, s0_.created_at) < 30
          )
        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_cake s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id WHERE s0_.display = 1 AND (s0_.hit = 1 OR s0_.discount_percentage > 0 OR DATEDIFF(CURRENT_TIME, s0_.created_at) < 30) 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_cake s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id WHERE s0_.display = 1 AND (s0_.hit = 1 OR s0_.discount_percentage > 0 OR DATEDIFF(CURRENT_TIME, s0_.created_at) < 30)) 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_cake s1_
          INNER JOIN shop_item s0_ ON s1_.id = s0_.id
        WHERE
          s0_.display = 1
          AND (
            s0_.hit = 1
            OR s0_.discount_percentage > 0
            OR DATEDIFF(CURRENT_TIME, s0_.created_at) < 30
          )
      ) 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_cake s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id WHERE s0_.display = 1 AND (s0_.hit = 1 OR s0_.discount_percentage > 0 OR DATEDIFF(CURRENT_TIME, s0_.created_at) < 30)) 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_cake s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id WHERE s0_.display = 1 AND (s0_.hit = 1 OR s0_.discount_percentage > 0 OR DATEDIFF(CURRENT_TIME, s0_.created_at) < 30) AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY RAND() ASC

[
  616
  589
  543
  511
  561
  692
  518
  626
]

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
WHERE
  s0_.display = 1
  AND (
    s0_.hit = 1
    OR s0_.discount_percentage > 0
    OR DATEDIFF(CURRENT_TIME, s0_.created_at) < 30
  )
  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_cake s1_ INNER JOIN shop_item s0_ ON s1_.id = s0_.id WHERE s0_.display = 1 AND (s0_.hit = 1 OR s0_.discount_percentage > 0 OR DATEDIFF(CURRENT_TIME, s0_.created_at) < 30) AND s0_.id IN (616, 589, 543, 511, 561, 692, 518, 626) ORDER BY RAND() ASC;