Symfony Profiler

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

Query Metrics

SELECT distinct(word)FROM word_incidence_ts

[]

SELECT
  distinct(word)
FROM
  word_incidence_ts

SELECT distinct(word)FROM word_incidence_ts;

SELECT word , round(avg(`incidence`), 2) as `incidence` 
                    FROM  word_incidence_ts
                    WHERE transmitted_at >= ? AND transmitted_at < ?
                    AND word in ('hitzetod','hitzetot','luftverschmutzung','klimakrise','klimawandel','mord','terror')
                    GROUP BY word ORDER BY incidence

[
  "2016-01-01 00:00:00"
  "2025-01-06 00:00:00"
]

SELECT
  word,
  round(
    avg(`incidence`),
    2
  ) as `incidence`
FROM
  word_incidence_ts
WHERE
  transmitted_at >= ?
  AND transmitted_at < ?
  AND word in (
    'hitzetod', 'hitzetot', 'luftverschmutzung',
    'klimakrise', 'klimawandel', 'mord',
    'terror'
  )
GROUP BY
  word
ORDER BY
  incidence

SELECT word , round(avg(`incidence`), 2) as `incidence` 
                    FROM  word_incidence_ts
                    WHERE transmitted_at >= '2016-01-01 00:00:00' AND transmitted_at < '2025-01-06 00:00:00'
                    AND word in ('hitzetod','hitzetot','luftverschmutzung','klimakrise','klimawandel','mord','terror')
                    GROUP BY word ORDER BY incidence
                    ;