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

[
  "Kenyane"
  "Kenyane"
  "Sud-africaine"
  "Ghanéenne"
  "Ethiopienne"
  "Guadeloupéenne"
  "Sainte-Lucienne"
  "Végétarienne"
  "Sainte-Lucienne"
  "Nigériane"
  "Sainte-Lucienne"
  "Congolaise"
  "Sud-africaine"
  "Guadeloupéenne"
  "Martiniquaise"
  "Végétarienne"
  "Végétalienne"
  "Brésilienne"
  "Ghanéenne"
  "Sénégalaise"
  "Végétarienne"
  "Kenyane"
  "Brésilienne"
  "Végétarienne"
  "Sénégalaise"
  "Marocaine"
  "Martiniquaise"
  "Sénégalaise"
  "Martiniquaise"
  "Brésilienne"
  "Kenyane"
  "Dominicaine"
  "Guadeloupéenne"
  "Végétalienne"
  "Martiniquaise"
  "Kenyane"
  "Marocaine"
  "Sud-africaine"
  "Marocaine"
]

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 ('Kenyane', 'Kenyane', 'Sud-africaine', 'Ghanéenne', 'Ethiopienne', 'Guadeloupéenne', 'Sainte-Lucienne', 'Végétarienne', 'Sainte-Lucienne', 'Nigériane', 'Sainte-Lucienne', 'Congolaise', 'Sud-africaine', 'Guadeloupéenne', 'Martiniquaise', 'Végétarienne', 'Végétalienne', 'Brésilienne', 'Ghanéenne', 'Sénégalaise', 'Végétarienne', 'Kenyane', 'Brésilienne', 'Végétarienne', 'Sénégalaise', 'Marocaine', 'Martiniquaise', 'Sénégalaise', 'Martiniquaise', 'Brésilienne', 'Kenyane', 'Dominicaine', 'Guadeloupéenne', 'Végétalienne', 'Martiniquaise', 'Kenyane', 'Marocaine', 'Sud-africaine', 'Marocaine') 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;