GET https://home.freyda.de/wetter/api/measurements/last7days

Query Metrics

7 Database Queries
1 Different statements
1886.99 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 371.29 ms
SELECT min(m0_.temp_dht_hic) AS sclr_0, max(m0_.temp_dht_hic) AS sclr_1, avg(m0_.temp_dht_hic) AS sclr_2, min(m0_.temp_dht_hif) AS sclr_3, max(m0_.temp_dht_hif) AS sclr_4, avg(m0_.temp_dht_hif) AS sclr_5, min(m0_.humidity_dht) AS sclr_6, max(m0_.humidity_dht) AS sclr_7, avg(m0_.humidity_dht) AS sclr_8, min(m0_.pressure_bmp) AS sclr_9, max(m0_.pressure_bmp) AS sclr_10, avg(m0_.pressure_bmp) AS sclr_11, min(m0_.temp_bmp) AS sclr_12, max(m0_.temp_bmp) AS sclr_13, avg(m0_.temp_bmp) AS sclr_14, min(m0_.add_datetime) AS sclr_15, max(m0_.add_datetime) AS sclr_16 FROM measurements m0_ WHERE m0_.add_datetime < ? AND m0_.add_datetime > ? AND (m0_.temp_bmp - m0_.temp_dht_hic) < 8 AND (m0_.temp_dht_hic - m0_.temp_bmp) < 8 ORDER BY m0_.add_datetime ASC
Parameters:
[
  "2025-12-15 23:59:59"
  "2025-12-15 00:00:00"
]
2 272.08 ms
SELECT min(m0_.temp_dht_hic) AS sclr_0, max(m0_.temp_dht_hic) AS sclr_1, avg(m0_.temp_dht_hic) AS sclr_2, min(m0_.temp_dht_hif) AS sclr_3, max(m0_.temp_dht_hif) AS sclr_4, avg(m0_.temp_dht_hif) AS sclr_5, min(m0_.humidity_dht) AS sclr_6, max(m0_.humidity_dht) AS sclr_7, avg(m0_.humidity_dht) AS sclr_8, min(m0_.pressure_bmp) AS sclr_9, max(m0_.pressure_bmp) AS sclr_10, avg(m0_.pressure_bmp) AS sclr_11, min(m0_.temp_bmp) AS sclr_12, max(m0_.temp_bmp) AS sclr_13, avg(m0_.temp_bmp) AS sclr_14, min(m0_.add_datetime) AS sclr_15, max(m0_.add_datetime) AS sclr_16 FROM measurements m0_ WHERE m0_.add_datetime < ? AND m0_.add_datetime > ? AND (m0_.temp_bmp - m0_.temp_dht_hic) < 8 AND (m0_.temp_dht_hic - m0_.temp_bmp) < 8 ORDER BY m0_.add_datetime ASC
Parameters:
[
  "2025-12-16 23:59:59"
  "2025-12-16 00:00:00"
]
3 248.77 ms
SELECT min(m0_.temp_dht_hic) AS sclr_0, max(m0_.temp_dht_hic) AS sclr_1, avg(m0_.temp_dht_hic) AS sclr_2, min(m0_.temp_dht_hif) AS sclr_3, max(m0_.temp_dht_hif) AS sclr_4, avg(m0_.temp_dht_hif) AS sclr_5, min(m0_.humidity_dht) AS sclr_6, max(m0_.humidity_dht) AS sclr_7, avg(m0_.humidity_dht) AS sclr_8, min(m0_.pressure_bmp) AS sclr_9, max(m0_.pressure_bmp) AS sclr_10, avg(m0_.pressure_bmp) AS sclr_11, min(m0_.temp_bmp) AS sclr_12, max(m0_.temp_bmp) AS sclr_13, avg(m0_.temp_bmp) AS sclr_14, min(m0_.add_datetime) AS sclr_15, max(m0_.add_datetime) AS sclr_16 FROM measurements m0_ WHERE m0_.add_datetime < ? AND m0_.add_datetime > ? AND (m0_.temp_bmp - m0_.temp_dht_hic) < 8 AND (m0_.temp_dht_hic - m0_.temp_bmp) < 8 ORDER BY m0_.add_datetime ASC
Parameters:
[
  "2025-12-17 23:59:59"
  "2025-12-17 00:00:00"
]
4 272.07 ms
SELECT min(m0_.temp_dht_hic) AS sclr_0, max(m0_.temp_dht_hic) AS sclr_1, avg(m0_.temp_dht_hic) AS sclr_2, min(m0_.temp_dht_hif) AS sclr_3, max(m0_.temp_dht_hif) AS sclr_4, avg(m0_.temp_dht_hif) AS sclr_5, min(m0_.humidity_dht) AS sclr_6, max(m0_.humidity_dht) AS sclr_7, avg(m0_.humidity_dht) AS sclr_8, min(m0_.pressure_bmp) AS sclr_9, max(m0_.pressure_bmp) AS sclr_10, avg(m0_.pressure_bmp) AS sclr_11, min(m0_.temp_bmp) AS sclr_12, max(m0_.temp_bmp) AS sclr_13, avg(m0_.temp_bmp) AS sclr_14, min(m0_.add_datetime) AS sclr_15, max(m0_.add_datetime) AS sclr_16 FROM measurements m0_ WHERE m0_.add_datetime < ? AND m0_.add_datetime > ? AND (m0_.temp_bmp - m0_.temp_dht_hic) < 8 AND (m0_.temp_dht_hic - m0_.temp_bmp) < 8 ORDER BY m0_.add_datetime ASC
Parameters:
[
  "2025-12-18 23:59:59"
  "2025-12-18 00:00:00"
]
5 259.04 ms
SELECT min(m0_.temp_dht_hic) AS sclr_0, max(m0_.temp_dht_hic) AS sclr_1, avg(m0_.temp_dht_hic) AS sclr_2, min(m0_.temp_dht_hif) AS sclr_3, max(m0_.temp_dht_hif) AS sclr_4, avg(m0_.temp_dht_hif) AS sclr_5, min(m0_.humidity_dht) AS sclr_6, max(m0_.humidity_dht) AS sclr_7, avg(m0_.humidity_dht) AS sclr_8, min(m0_.pressure_bmp) AS sclr_9, max(m0_.pressure_bmp) AS sclr_10, avg(m0_.pressure_bmp) AS sclr_11, min(m0_.temp_bmp) AS sclr_12, max(m0_.temp_bmp) AS sclr_13, avg(m0_.temp_bmp) AS sclr_14, min(m0_.add_datetime) AS sclr_15, max(m0_.add_datetime) AS sclr_16 FROM measurements m0_ WHERE m0_.add_datetime < ? AND m0_.add_datetime > ? AND (m0_.temp_bmp - m0_.temp_dht_hic) < 8 AND (m0_.temp_dht_hic - m0_.temp_bmp) < 8 ORDER BY m0_.add_datetime ASC
Parameters:
[
  "2025-12-19 23:59:59"
  "2025-12-19 00:00:00"
]
6 234.91 ms
SELECT min(m0_.temp_dht_hic) AS sclr_0, max(m0_.temp_dht_hic) AS sclr_1, avg(m0_.temp_dht_hic) AS sclr_2, min(m0_.temp_dht_hif) AS sclr_3, max(m0_.temp_dht_hif) AS sclr_4, avg(m0_.temp_dht_hif) AS sclr_5, min(m0_.humidity_dht) AS sclr_6, max(m0_.humidity_dht) AS sclr_7, avg(m0_.humidity_dht) AS sclr_8, min(m0_.pressure_bmp) AS sclr_9, max(m0_.pressure_bmp) AS sclr_10, avg(m0_.pressure_bmp) AS sclr_11, min(m0_.temp_bmp) AS sclr_12, max(m0_.temp_bmp) AS sclr_13, avg(m0_.temp_bmp) AS sclr_14, min(m0_.add_datetime) AS sclr_15, max(m0_.add_datetime) AS sclr_16 FROM measurements m0_ WHERE m0_.add_datetime < ? AND m0_.add_datetime > ? AND (m0_.temp_bmp - m0_.temp_dht_hic) < 8 AND (m0_.temp_dht_hic - m0_.temp_bmp) < 8 ORDER BY m0_.add_datetime ASC
Parameters:
[
  "2025-12-20 23:59:59"
  "2025-12-20 00:00:00"
]
7 228.84 ms
SELECT min(m0_.temp_dht_hic) AS sclr_0, max(m0_.temp_dht_hic) AS sclr_1, avg(m0_.temp_dht_hic) AS sclr_2, min(m0_.temp_dht_hif) AS sclr_3, max(m0_.temp_dht_hif) AS sclr_4, avg(m0_.temp_dht_hif) AS sclr_5, min(m0_.humidity_dht) AS sclr_6, max(m0_.humidity_dht) AS sclr_7, avg(m0_.humidity_dht) AS sclr_8, min(m0_.pressure_bmp) AS sclr_9, max(m0_.pressure_bmp) AS sclr_10, avg(m0_.pressure_bmp) AS sclr_11, min(m0_.temp_bmp) AS sclr_12, max(m0_.temp_bmp) AS sclr_13, avg(m0_.temp_bmp) AS sclr_14, min(m0_.add_datetime) AS sclr_15, max(m0_.add_datetime) AS sclr_16 FROM measurements m0_ WHERE m0_.add_datetime < ? AND m0_.add_datetime > ? AND (m0_.temp_bmp - m0_.temp_dht_hic) < 8 AND (m0_.temp_dht_hic - m0_.temp_bmp) < 8 ORDER BY m0_.add_datetime ASC
Parameters:
[
  "2025-12-21 23:59:59"
  "2025-12-21 00:00:00"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Measurement No errors.