Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation 7
• 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 ('fußball','klimakrise','terror')
                    GROUP BY word

[
  "2017-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 (
    'fußball', 'klimakrise', 'terror'
  )
GROUP BY
  word

SELECT word , round(avg(`incidence`), 2) as `incidence` 
                    FROM  word_incidence_ts
                    WHERE transmitted_at >= '2017-01-01 00:00:00' AND transmitted_at < '2025-01-06 00:00:00'
                    AND word in ('fußball','klimakrise','terror')
                    GROUP BY word 
                    ;

SELECT word,  LEFT(transmitted_at, 4) as datetime , round(avg(`incidence`), 2) as `incidence` 
                    FROM  word_incidence_ts
                    WHERE transmitted_at >= ? AND transmitted_at < ?
                    AND word in ('fußball','klimakrise','terror')
                    GROUP BY word,  LEFT(transmitted_at, 4)
                    ORDER BY LEFT(transmitted_at, 4)

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

SELECT
  word,
  LEFT(transmitted_at, 4) as datetime,
  round(
    avg(`incidence`),
    2
  ) as `incidence`
FROM
  word_incidence_ts
WHERE
  transmitted_at >= ?
  AND transmitted_at < ?
  AND word in (
    'fußball', 'klimakrise', 'terror'
  )
GROUP BY
  word,
  LEFT(transmitted_at, 4)
ORDER BY
  LEFT(transmitted_at, 4)

SELECT word,  LEFT(transmitted_at, 4) as datetime , round(avg(`incidence`), 2) as `incidence` 
                    FROM  word_incidence_ts
                    WHERE transmitted_at >= '2017-01-01 00:00:00' AND transmitted_at < '2025-01-06 00:00:00'
                    AND word in ('fußball','klimakrise','terror')
                    GROUP BY word,  LEFT(transmitted_at, 4)
                    ORDER BY LEFT(transmitted_at, 4)
                    ;