Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• 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 WHERE c0_.name IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY c0_.name, c0_.id ORDER BY sclr_2 DESC

[
  "Végétarienne"
  "Kenyane"
  "Végétarienne"
  "Ethiopienne"
  "Sainte-Lucienne"
  "Guadeloupéenne"
  "Végétalienne"
  "Kenyane"
  "Congolaise"
  "Kenyane"
  "Nigériane"
  "Kenyane"
  "Guadeloupéenne"
  "Créole"
  "Végétarienne"
  "Congolaise"
  "Créole"
]

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
WHERE
  c0_.name IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )
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 WHERE c0_.name IN ('Végétarienne', 'Kenyane', 'Végétarienne', 'Ethiopienne', 'Sainte-Lucienne', 'Guadeloupéenne', 'Végétalienne', 'Kenyane', 'Congolaise', 'Kenyane', 'Nigériane', 'Kenyane', 'Guadeloupéenne', 'Créole', 'Végétarienne', 'Congolaise', 'Créole') 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 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;