Query Metrics
30
Database Queries
1
Different statements
4855.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 362.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-21 23:59:59" "2025-11-21 00:00:00" ]
|
||||||||||||||||||||||||||||
| 2 | 228.73 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" ]
|
||||||||||||||||||||||||||||
| 3 | 234.26 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" ]
|
||||||||||||||||||||||||||||
| 4 | 225.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-11-24 23:59:59" "2025-11-24 00:00:00" ]
|
||||||||||||||||||||||||||||
| 5 | 230.16 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" ]
|
||||||||||||||||||||||||||||
| 6 | 227.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-11-26 23:59:59" "2025-11-26 00:00:00" ]
|
||||||||||||||||||||||||||||
| 7 | 203.20 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" ]
|
||||||||||||||||||||||||||||
| 8 | 140.09 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" ]
|
||||||||||||||||||||||||||||
| 9 | 142.65 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" ]
|
||||||||||||||||||||||||||||
| 10 | 137.12 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" ]
|
||||||||||||||||||||||||||||
| 11 | 136.71 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" ]
|
||||||||||||||||||||||||||||
| 12 | 136.03 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" ]
|
||||||||||||||||||||||||||||
| 13 | 136.05 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" ]
|
||||||||||||||||||||||||||||
| 14 | 136.14 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" ]
|
||||||||||||||||||||||||||||
| 15 | 135.68 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" ]
|
||||||||||||||||||||||||||||
| 16 | 136.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-06 23:59:59" "2025-12-06 00:00:00" ]
|
||||||||||||||||||||||||||||
| 17 | 135.76 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" ]
|
||||||||||||||||||||||||||||
| 18 | 135.75 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" ]
|
||||||||||||||||||||||||||||
| 19 | 135.73 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" ]
|
||||||||||||||||||||||||||||
| 20 | 136.28 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" ]
|
||||||||||||||||||||||||||||
| 21 | 136.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-11 23:59:59" "2025-12-11 00:00:00" ]
|
||||||||||||||||||||||||||||
| 22 | 135.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-12 23:59:59" "2025-12-12 00:00:00" ]
|
||||||||||||||||||||||||||||
| 23 | 135.71 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" ]
|
||||||||||||||||||||||||||||
| 24 | 135.94 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" ]
|
||||||||||||||||||||||||||||
| 25 | 137.33 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" ]
|
||||||||||||||||||||||||||||
| 26 | 136.74 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" ]
|
||||||||||||||||||||||||||||
| 27 | 136.19 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" ]
|
||||||||||||||||||||||||||||
| 28 | 137.20 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" ]
|
||||||||||||||||||||||||||||
| 29 | 136.13 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" ]
|
||||||||||||||||||||||||||||
| 30 | 137.00 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" ]
|
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. |