Symfony Profiler

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

Query Metrics

SELECT c0_.city AS city_0, COUNT(DISTINCT c1_.id) AS sclr_1 FROM commerce_profile c0_ LEFT JOIN contest c1_ ON c0_.id = c1_.commerce_id WHERE c1_.start_date <= ? AND c1_.end_date >= ? GROUP BY c0_.city ORDER BY sclr_1 DESC

[
  "2025-12-16 03:18:00"
  "2025-12-16 03:18:00"
]

SELECT
  c0_.city AS city_0,
  COUNT(DISTINCT c1_.id) AS sclr_1
FROM
  commerce_profile c0_
  LEFT JOIN contest c1_ ON c0_.id = c1_.commerce_id
WHERE
  c1_.start_date <= ?
  AND c1_.end_date >= ?
GROUP BY
  c0_.city
ORDER BY
  sclr_1 DESC

SELECT c0_.city AS city_0, COUNT(DISTINCT c1_.id) AS sclr_1 FROM commerce_profile c0_ LEFT JOIN contest c1_ ON c0_.id = c1_.commerce_id WHERE c1_.start_date <= '2025-12-16 03:18:00' AND c1_.end_date >= '2025-12-16 03:18:00' GROUP BY c0_.city ORDER BY sclr_1 DESC;