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 c0_.name AS name_0, c0_.id AS id_1, COUNT(r1_.id) AS sclr_2 FROM restaurant_cooking_style r2_ INNER JOIN cooking_style c0_ ON r2_.cooking_style_id = c0_.id INNER JOIN restaurant r1_ ON r2_.restaurant_id = r1_.id GROUP BY c0_.name, c0_.id ORDER BY sclr_2 DESC

[]

SELECT
  c0_.name AS name_0,
  c0_.id AS id_1,
  COUNT(r1_.id) AS sclr_2
FROM
  restaurant_cooking_style r2_
  INNER JOIN cooking_style c0_ ON r2_.cooking_style_id = c0_.id
  INNER JOIN restaurant r1_ ON r2_.restaurant_id = r1_.id
GROUP BY
  c0_.name,
  c0_.id
ORDER BY
  sclr_2 DESC

SELECT c0_.name AS name_0, c0_.id AS id_1, COUNT(r1_.id) AS sclr_2 FROM restaurant_cooking_style r2_ INNER JOIN cooking_style c0_ ON r2_.cooking_style_id = c0_.id INNER JOIN restaurant r1_ ON r2_.restaurant_id = r1_.id GROUP BY c0_.name, c0_.id ORDER BY sclr_2 DESC;

SELECT r0_.id AS id_0, c1_.id AS id_1, c1_.name AS name_2 FROM restaurant r0_ LEFT JOIN address a2_ ON r0_.shop_address_id = a2_.id LEFT JOIN city c1_ ON a2_.city_id = c1_.id WHERE a2_.id IS NOT NULL GROUP BY c1_.name ORDER BY c1_.name ASC

[]

SELECT
  r0_.id AS id_0,
  c1_.id AS id_1,
  c1_.name AS name_2
FROM
  restaurant r0_
  LEFT JOIN address a2_ ON r0_.shop_address_id = a2_.id
  LEFT JOIN city c1_ ON a2_.city_id = c1_.id
WHERE
  a2_.id IS NOT NULL
GROUP BY
  c1_.name
ORDER BY
  c1_.name ASC

SELECT r0_.id AS id_0, c1_.id AS id_1, c1_.name AS name_2 FROM restaurant r0_ LEFT JOIN address a2_ ON r0_.shop_address_id = a2_.id LEFT JOIN city c1_ ON a2_.city_id = c1_.id WHERE a2_.id IS NOT NULL GROUP BY c1_.name ORDER BY c1_.name ASC;