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

Query Metrics

30 Database Queries
1 Different statements
5039.25 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 349.69 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-11-22 23:59:59"
  "2025-11-22 00:00:00"
]
2 270.69 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-11-23 23:59:59"
  "2025-11-23 00:00:00"
]
3 249.18 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-11-24 23:59:59"
  "2025-11-24 00:00:00"
]
4 269.36 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-11-25 23:59:59"
  "2025-11-25 00:00:00"
]
5 260.23 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-11-26 23:59:59"
  "2025-11-26 00:00:00"
]
6 241.27 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-11-27 23:59:59"
  "2025-11-27 00:00:00"
]
7 235.62 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-11-28 23:59:59"
  "2025-11-28 00:00:00"
]
8 142.15 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-11-29 23:59:59"
  "2025-11-29 00:00:00"
]
9 136.98 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-11-30 23:59:59"
  "2025-11-30 00:00:00"
]
10 135.86 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-01 23:59:59"
  "2025-12-01 00:00:00"
]
11 136.99 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-02 23:59:59"
  "2025-12-02 00:00:00"
]
12 136.02 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-03 23:59:59"
  "2025-12-03 00:00:00"
]
13 136.51 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-04 23:59:59"
  "2025-12-04 00:00:00"
]
14 136.41 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-05 23:59:59"
  "2025-12-05 00:00:00"
]
15 136.15 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-06 23:59:59"
  "2025-12-06 00:00:00"
]
16 148.46 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-07 23:59:59"
  "2025-12-07 00:00:00"
]
17 136.30 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-08 23:59:59"
  "2025-12-08 00:00:00"
]
18 136.41 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-09 23:59:59"
  "2025-12-09 00:00:00"
]
19 136.50 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-10 23:59:59"
  "2025-12-10 00:00:00"
]
20 137.59 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-11 23:59:59"
  "2025-12-11 00:00:00"
]
21 136.62 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-12 23:59:59"
  "2025-12-12 00:00:00"
]
22 135.92 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-13 23:59:59"
  "2025-12-13 00:00:00"
]
23 137.38 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-14 23:59:59"
  "2025-12-14 00:00:00"
]
24 136.99 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"
]
25 136.83 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"
]
26 136.79 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"
]
27 137.32 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"
]
28 137.61 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"
]
29 138.23 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"
]
30 137.17 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.