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 distinct(word)FROM word_incidence_tt

[]

SELECT
  distinct(word)
FROM
  word_incidence_tt

SELECT distinct(word)FROM word_incidence_tt;

SELECT word , round(avg(`incidence`), 2) as `incidence` 
                    FROM  word_incidence_ts
                    WHERE transmitted_at >= ? AND transmitted_at < ?
                    AND word in ('klimawandel','klimakrise','klimakatastrophe','hurrikan','hochwasser','hurrikan','sturm')
                    GROUP BY word ORDER BY incidence

[
  "2024-07-01 00:00:00"
  "2024-11-01 00:00:00"
]

SELECT
  word,
  round(
    avg(`incidence`),
    2
  ) as `incidence`
FROM
  word_incidence_ts
WHERE
  transmitted_at >= ?
  AND transmitted_at < ?
  AND word in (
    'klimawandel', 'klimakrise', 'klimakatastrophe',
    'hurrikan', 'hochwasser', 'hurrikan',
    'sturm'
  )
GROUP BY
  word
ORDER BY
  incidence

SELECT word , round(avg(`incidence`), 2) as `incidence` 
                    FROM  word_incidence_ts
                    WHERE transmitted_at >= '2024-07-01 00:00:00' AND transmitted_at < '2024-11-01 00:00:00'
                    AND word in ('klimawandel','klimakrise','klimakatastrophe','hurrikan','hochwasser','hurrikan','sturm')
                    GROUP BY word ORDER BY incidence
                    ;

SELECT word , round(avg(`incidence`), 2) as `incidence` 
                    FROM  word_incidence_tt
                    WHERE transmitted_at >= ? AND transmitted_at < ?
                    AND word in ('klimawandel','klimakrise','klimakatastrophe','hurrikan','hochwasser','hurrikan','sturm')
                    GROUP BY word ORDER BY incidence

[
  "2024-07-01 00:00:00"
  "2024-11-01 00:00:00"
]

SELECT
  word,
  round(
    avg(`incidence`),
    2
  ) as `incidence`
FROM
  word_incidence_tt
WHERE
  transmitted_at >= ?
  AND transmitted_at < ?
  AND word in (
    'klimawandel', 'klimakrise', 'klimakatastrophe',
    'hurrikan', 'hochwasser', 'hurrikan',
    'sturm'
  )
GROUP BY
  word
ORDER BY
  incidence

SELECT word , round(avg(`incidence`), 2) as `incidence` 
                    FROM  word_incidence_tt
                    WHERE transmitted_at >= '2024-07-01 00:00:00' AND transmitted_at < '2024-11-01 00:00:00'
                    AND word in ('klimawandel','klimakrise','klimakatastrophe','hurrikan','hochwasser','hurrikan','sturm')
                    GROUP BY word ORDER BY incidence
                    ;