Symfony Profiler

• Request / Response
• Performance
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Serializer
• Configuration

Query Metrics

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.tag AS tag_2, s0_.listing_type AS listing_type_3, s0_.list_item_type AS list_item_type_4, s0_.slogan AS slogan_5, s1_.priority AS priority_6, c2_.id AS id_7, c2_.name AS name_8, c2_.img AS img_9, c2_.description AS description_10, c2_.type AS type_11, c2_.priority AS priority_12, c2_.slogan AS slogan_13, c2_.created_at AS created_at_14, c2_.deleted_at AS deleted_at_15, s3_.priority AS priority_16, p4_.id AS id_17, p4_.name AS name_18, p4_.thumbnail_type AS thumbnail_type_19, p4_.img AS img_20, p4_.video AS video_21, p4_.price AS price_22, p4_.description AS description_23, p4_.priority AS priority_24, p4_.created_at AS created_at_25, p4_.deleted_at AS deleted_at_26, s0_.section_page_id AS section_page_id_27, s1_.section_id AS section_id_28, s1_.category_id AS category_id_29, s3_.section_id AS section_id_30, s3_.product_id AS product_id_31, p4_.category_id AS category_id_32 FROM section s0_ INNER JOIN section_page s5_ ON s0_.section_page_id = s5_.id LEFT JOIN section_category s1_ ON s0_.id = s1_.section_id LEFT JOIN category c2_ ON s1_.category_id = c2_.id AND (c2_.deleted_at IS NULL) LEFT JOIN section_product s3_ ON s0_.id = s3_.section_id LEFT JOIN product p4_ ON s3_.product_id = p4_.id AND (p4_.deleted_at IS NULL) WHERE s5_.tag = ? AND s0_.tag = ? ORDER BY s1_.priority ASC, s3_.priority ASC

[
  "brunch"
  "signature-dishes"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.tag AS tag_2,
  s0_.listing_type AS listing_type_3,
  s0_.list_item_type AS list_item_type_4,
  s0_.slogan AS slogan_5,
  s1_.priority AS priority_6,
  c2_.id AS id_7,
  c2_.name AS name_8,
  c2_.img AS img_9,
  c2_.description AS description_10,
  c2_.type AS type_11,
  c2_.priority AS priority_12,
  c2_.slogan AS slogan_13,
  c2_.created_at AS created_at_14,
  c2_.deleted_at AS deleted_at_15,
  s3_.priority AS priority_16,
  p4_.id AS id_17,
  p4_.name AS name_18,
  p4_.thumbnail_type AS thumbnail_type_19,
  p4_.img AS img_20,
  p4_.video AS video_21,
  p4_.price AS price_22,
  p4_.description AS description_23,
  p4_.priority AS priority_24,
  p4_.created_at AS created_at_25,
  p4_.deleted_at AS deleted_at_26,
  s0_.section_page_id AS section_page_id_27,
  s1_.section_id AS section_id_28,
  s1_.category_id AS category_id_29,
  s3_.section_id AS section_id_30,
  s3_.product_id AS product_id_31,
  p4_.category_id AS category_id_32
FROM
  section s0_
  INNER JOIN section_page s5_ ON s0_.section_page_id = s5_.id
  LEFT JOIN section_category s1_ ON s0_.id = s1_.section_id
  LEFT JOIN category c2_ ON s1_.category_id = c2_.id
  AND (c2_.deleted_at IS NULL)
  LEFT JOIN section_product s3_ ON s0_.id = s3_.section_id
  LEFT JOIN product p4_ ON s3_.product_id = p4_.id
  AND (p4_.deleted_at IS NULL)
WHERE
  s5_.tag = ?
  AND s0_.tag = ?
ORDER BY
  s1_.priority ASC,
  s3_.priority ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.tag AS tag_2, s0_.listing_type AS listing_type_3, s0_.list_item_type AS list_item_type_4, s0_.slogan AS slogan_5, s1_.priority AS priority_6, c2_.id AS id_7, c2_.name AS name_8, c2_.img AS img_9, c2_.description AS description_10, c2_.type AS type_11, c2_.priority AS priority_12, c2_.slogan AS slogan_13, c2_.created_at AS created_at_14, c2_.deleted_at AS deleted_at_15, s3_.priority AS priority_16, p4_.id AS id_17, p4_.name AS name_18, p4_.thumbnail_type AS thumbnail_type_19, p4_.img AS img_20, p4_.video AS video_21, p4_.price AS price_22, p4_.description AS description_23, p4_.priority AS priority_24, p4_.created_at AS created_at_25, p4_.deleted_at AS deleted_at_26, s0_.section_page_id AS section_page_id_27, s1_.section_id AS section_id_28, s1_.category_id AS category_id_29, s3_.section_id AS section_id_30, s3_.product_id AS product_id_31, p4_.category_id AS category_id_32 FROM section s0_ INNER JOIN section_page s5_ ON s0_.section_page_id = s5_.id LEFT JOIN section_category s1_ ON s0_.id = s1_.section_id LEFT JOIN category c2_ ON s1_.category_id = c2_.id AND (c2_.deleted_at IS NULL) LEFT JOIN section_product s3_ ON s0_.id = s3_.section_id LEFT JOIN product p4_ ON s3_.product_id = p4_.id AND (p4_.deleted_at IS NULL) WHERE s5_.tag = 'brunch' AND s0_.tag = 'signature-dishes' ORDER BY s1_.priority ASC, s3_.priority ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = ?

[
  5
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3
FROM
  tag t0
  INNER JOIN product_tag ON t0.id = product_tag.tag_id
WHERE
  product_tag.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 5;

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = ?

[
  6
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3
FROM
  tag t0
  INNER JOIN product_tag ON t0.id = product_tag.tag_id
WHERE
  product_tag.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 6;

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = ?

[
  7
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3
FROM
  tag t0
  INNER JOIN product_tag ON t0.id = product_tag.tag_id
WHERE
  product_tag.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 7;