Symfony Profiler

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

Query Metrics

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_.is_created AS is_created_7, s0_.is_activated AS is_activated_8, s0_.created_at AS created_at_9, s0_.data AS data_10, s0_.legal AS legal_11, s0_.wallpaper AS wallpaper_12, s0_.statistical AS statistical_13, s0_.manager_id AS manager_id_14, s0_.main_borough_id AS main_borough_id_15 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

[
  "2026-08-14"
]

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_.is_created AS is_created_7,
  s0_.is_activated AS is_activated_8,
  s0_.created_at AS created_at_9,
  s0_.data AS data_10,
  s0_.legal AS legal_11,
  s0_.wallpaper AS wallpaper_12,
  s0_.statistical AS statistical_13,
  s0_.manager_id AS manager_id_14,
  s0_.main_borough_id AS main_borough_id_15
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_.is_created AS is_created_7, s0_.is_activated AS is_activated_8, s0_.created_at AS created_at_9, s0_.data AS data_10, s0_.legal AS legal_11, s0_.wallpaper AS wallpaper_12, s0_.statistical AS statistical_13, s0_.manager_id AS manager_id_14, s0_.main_borough_id AS main_borough_id_15 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 >= '2026-08-14' GROUP BY s0_.id HAVING COUNT(e4_.id) > 0 ORDER BY COUNT(e4_.id) DESC;