Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = ? LIMIT 1

[
  "musique-classique"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = 'musique-classique' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = ? LIMIT 1

[
  "musique-classique"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = 'musique-classique' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = ? LIMIT 1

[
  "strasbourg"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.slogan AS slogan_4,
  t0.color AS color_5,
  t0.resident AS resident_6,
  t0.network AS network_7,
  t0.main_borough_id AS main_borough_id_8
FROM
  subdomain t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = 'strasbourg' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = ? LIMIT 1

[
  "strasbourg"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.slogan AS slogan_4,
  t0.color AS color_5,
  t0.resident AS resident_6,
  t0.network AS network_7,
  t0.main_borough_id AS main_borough_id_8
FROM
  subdomain t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = 'strasbourg' LIMIT 1;

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.slogan AS slogan_3, s0_.color AS color_4, s0_.resident AS resident_5, s0_.network AS network_6, s0_.main_borough_id AS main_borough_id_7 FROM subdomain s0_ INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id INNER JOIN borough b1_ ON b1_.id = s2_.borough_id INNER JOIN city c3_ ON b1_.id = c3_.borough_id INNER JOIN event e4_ ON c3_.id = e4_.city_id WHERE e4_.date_end >= ? GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC

[
  "2025-10-28"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.slogan AS slogan_3,
  s0_.color AS color_4,
  s0_.resident AS resident_5,
  s0_.network AS network_6,
  s0_.main_borough_id AS main_borough_id_7
FROM
  subdomain s0_
  INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id
  INNER JOIN borough b1_ ON b1_.id = s2_.borough_id
  INNER JOIN city c3_ ON b1_.id = c3_.borough_id
  INNER JOIN event e4_ ON c3_.id = e4_.city_id
WHERE
  e4_.date_end >= ?
GROUP BY
  s0_.id
HAVING
  COUNT(e4_.id) > 0
ORDER BY
  COUNT(e4_.id) DESC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.slogan AS slogan_3, s0_.color AS color_4, s0_.resident AS resident_5, s0_.network AS network_6, s0_.main_borough_id AS main_borough_id_7 FROM subdomain s0_ INNER JOIN subdomain_borough s2_ ON s0_.id = s2_.subdomain_id INNER JOIN borough b1_ ON b1_.id = s2_.borough_id INNER JOIN city c3_ ON b1_.id = c3_.borough_id INNER JOIN event e4_ ON c3_.id = e4_.city_id WHERE e4_.date_end >= '2025-10-28' GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = ? LIMIT 1

[
  "strasbourg"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.slogan AS slogan_4,
  t0.color AS color_5,
  t0.resident AS resident_6,
  t0.network AS network_7,
  t0.main_borough_id AS main_borough_id_8
FROM
  subdomain t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = 'strasbourg' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = ? LIMIT 1

[
  "strasbourg"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.slogan AS slogan_4,
  t0.color AS color_5,
  t0.resident AS resident_6,
  t0.network AS network_7,
  t0.main_borough_id AS main_borough_id_8
FROM
  subdomain t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.slogan AS slogan_4, t0.color AS color_5, t0.resident AS resident_6, t0.network AS network_7, t0.main_borough_id AS main_borough_id_8 FROM subdomain t0 WHERE t0.slug = 'strasbourg' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.resident AS resident_4, t0.chief_town AS chief_town_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.description AS description_8, t0.zoom AS zoom_9, t0.department_id AS department_id_10 FROM borough t0 WHERE t0.id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.resident AS resident_4,
  t0.chief_town AS chief_town_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.description AS description_8,
  t0.zoom AS zoom_9,
  t0.department_id AS department_id_10
FROM
  borough t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.resident AS resident_4, t0.chief_town AS chief_town_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.description AS description_8, t0.zoom AS zoom_9, t0.department_id AS department_id_10 FROM borough t0 WHERE t0.id = 4;

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.color AS color_3, r0_.single AS single_4, r0_.plural AS plural_5 FROM rubric r0_ INNER JOIN event e1_ ON r0_.id = e1_.rubric_id LEFT JOIN city c2_ ON e1_.city_id = c2_.id LEFT JOIN borough b3_ ON c2_.borough_id = b3_.id LEFT JOIN subdomain_borough s5_ ON b3_.id = s5_.borough_id LEFT JOIN subdomain s4_ ON s4_.id = s5_.subdomain_id WHERE e1_.date_end >= ? AND s4_.slug = ? GROUP BY r0_.id HAVING COUNT(e1_.id) > 0 ORDER BY COUNT(e1_.id) DESC

[
  "2025-10-28 07:14:31"
  "strasbourg"
]

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.slug AS slug_2,
  r0_.color AS color_3,
  r0_.single AS single_4,
  r0_.plural AS plural_5
FROM
  rubric r0_
  INNER JOIN event e1_ ON r0_.id = e1_.rubric_id
  LEFT JOIN city c2_ ON e1_.city_id = c2_.id
  LEFT JOIN borough b3_ ON c2_.borough_id = b3_.id
  LEFT JOIN subdomain_borough s5_ ON b3_.id = s5_.borough_id
  LEFT JOIN subdomain s4_ ON s4_.id = s5_.subdomain_id
WHERE
  e1_.date_end >= ?
  AND s4_.slug = ?
GROUP BY
  r0_.id
HAVING
  COUNT(e1_.id) > 0
ORDER BY
  COUNT(e1_.id) DESC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.color AS color_3, r0_.single AS single_4, r0_.plural AS plural_5 FROM rubric r0_ INNER JOIN event e1_ ON r0_.id = e1_.rubric_id LEFT JOIN city c2_ ON e1_.city_id = c2_.id LEFT JOIN borough b3_ ON c2_.borough_id = b3_.id LEFT JOIN subdomain_borough s5_ ON b3_.id = s5_.borough_id LEFT JOIN subdomain s4_ ON s4_.id = s5_.subdomain_id WHERE e1_.date_end >= '2025-10-28 07:14:31' AND s4_.slug = 'strasbourg' GROUP BY r0_.id HAVING COUNT(e1_.id) > 0 ORDER BY COUNT(e1_.id) DESC;

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM category c0_ INNER JOIN event_category e2_ ON c0_.id = e2_.category_id INNER JOIN event e1_ ON e1_.id = e2_.event_id WHERE e1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY c0_.id ORDER BY COUNT(e1_.id) DESC, c0_.slug ASC

[
  133744
  133992
  133255
  133274
  133319
  133307
  133308
  133314
  133315
]

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2
FROM
  category c0_
  INNER JOIN event_category e2_ ON c0_.id = e2_.category_id
  INNER JOIN event e1_ ON e1_.id = e2_.event_id
WHERE
  e1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  c0_.id
ORDER BY
  COUNT(e1_.id) DESC,
  c0_.slug ASC

SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM category c0_ INNER JOIN event_category e2_ ON c0_.id = e2_.category_id INNER JOIN event e1_ ON e1_.id = e2_.event_id WHERE e1_.id IN (133744, 133992, 133255, 133274, 133319, 133307, 133308, 133314, 133315) GROUP BY c0_.id ORDER BY COUNT(e1_.id) DESC, c0_.slug ASC;