Symfony Profiler

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 = 'dinner' AND s0_.tag = 'our-menu' ORDER BY s1_.priority ASC, s3_.priority ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.thumbnail_type AS thumbnail_type_3,
  t0.img AS img_4,
  t0.video AS video_5,
  t0.price AS price_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.category_id AS category_id_11
FROM
  product t0
WHERE
  t0.category_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.thumbnail_type AS thumbnail_type_3, t0.img AS img_4, t0.video AS video_5, t0.price AS price_6, t0.description AS description_7, t0.priority AS priority_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.category_id AS category_id_11 FROM product t0 WHERE t0.category_id = 1 AND ((t0.deleted_at IS NULL)) ORDER BY t0.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 = ?

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

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

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.thumbnail_type AS thumbnail_type_3,
  t0.img AS img_4,
  t0.video AS video_5,
  t0.price AS price_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.category_id AS category_id_11
FROM
  product t0
WHERE
  t0.category_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.thumbnail_type AS thumbnail_type_3, t0.img AS img_4, t0.video AS video_5, t0.price AS price_6, t0.description AS description_7, t0.priority AS priority_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.category_id AS category_id_11 FROM product t0 WHERE t0.category_id = 2 AND ((t0.deleted_at IS NULL)) ORDER BY t0.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 = ?

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

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

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

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