Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.stock AS stock_6, t0.main_image AS main_image_7, t0.images AS images_8, t0.is_active AS is_active_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.weight AS weight_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15 FROM product t0 WHERE t0.slug = ? AND t0.is_active = ? LIMIT 1

[
  "A-and-W-Saveur-Ice-Cream-Sunday"
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.stock AS stock_6,
  t0.main_image AS main_image_7,
  t0.images AS images_8,
  t0.is_active AS is_active_9,
  t0.is_featured AS is_featured_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.weight AS weight_13,
  t0.category_id AS category_id_14,
  t0.sub_category_id AS sub_category_id_15
FROM
  product t0
WHERE
  t0.slug = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.stock AS stock_6, t0.main_image AS main_image_7, t0.images AS images_8, t0.is_active AS is_active_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.weight AS weight_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15 FROM product t0 WHERE t0.slug = 'A-and-W-Saveur-Ice-Cream-Sunday' AND t0.is_active = 1 LIMIT 1;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.price AS price_4, p0_.stock AS stock_5, p0_.main_image AS main_image_6, p0_.images AS images_7, p0_.is_active AS is_active_8, p0_.is_featured AS is_featured_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.weight AS weight_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14 FROM product p0_ WHERE p0_.category_id = ? AND p0_.id <> ? AND p0_.is_active = 1 LIMIT 4

[
  11
  109
]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.price AS price_4,
  p0_.stock AS stock_5,
  p0_.main_image AS main_image_6,
  p0_.images AS images_7,
  p0_.is_active AS is_active_8,
  p0_.is_featured AS is_featured_9,
  p0_.created_at AS created_at_10,
  p0_.updated_at AS updated_at_11,
  p0_.weight AS weight_12,
  p0_.category_id AS category_id_13,
  p0_.sub_category_id AS sub_category_id_14
FROM
  product p0_
WHERE
  p0_.category_id = ?
  AND p0_.id <> ?
  AND p0_.is_active = 1
LIMIT
  4

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.price AS price_4, p0_.stock AS stock_5, p0_.main_image AS main_image_6, p0_.images AS images_7, p0_.is_active AS is_active_8, p0_.is_featured AS is_featured_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.weight AS weight_12, p0_.category_id AS category_id_13, p0_.sub_category_id AS sub_category_id_14 FROM product p0_ WHERE p0_.category_id = 11 AND p0_.id <> 109 AND p0_.is_active = 1 LIMIT 4;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM category t0 WHERE t0.is_active = ? ORDER BY t0.name ASC

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7
FROM
  category t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM category t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.category_id = ?

[
  11
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.category_id AS category_id_7
FROM
  sub_category t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.category_id = 11;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.category_id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.category_id AS category_id_7
FROM
  sub_category t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.category_id = 2;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.category_id = ?

[
  12
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.category_id AS category_id_7
FROM
  sub_category t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.category_id = 12;

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN product_ingredient ON t0.id = product_ingredient.ingredient_id WHERE product_ingredient.product_id = ?

[
  109
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  ingredient t0
  INNER JOIN product_ingredient ON t0.id = product_ingredient.ingredient_id
WHERE
  product_ingredient.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM ingredient t0 INNER JOIN product_ingredient ON t0.id = product_ingredient.ingredient_id WHERE product_ingredient.product_id = 109;