Query Metrics
30
Database Queries
1
Different statements
4647.86 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 137.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-11-22 23:59:59" "2025-11-22 00:00:00" ]
|
||||||||||||||||||||||||||||
| 2 | 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-11-23 23:59:59" "2025-11-23 00:00:00" ]
|
||||||||||||||||||||||||||||
| 3 | 135.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-11-24 23:59:59" "2025-11-24 00:00:00" ]
|
||||||||||||||||||||||||||||
| 4 | 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-11-25 23:59:59" "2025-11-25 00:00:00" ]
|
||||||||||||||||||||||||||||
| 5 | 135.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-11-26 23:59:59" "2025-11-26 00:00:00" ]
|
||||||||||||||||||||||||||||
| 6 | 135.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-11-27 23:59:59" "2025-11-27 00:00:00" ]
|
||||||||||||||||||||||||||||
| 7 | 135.95 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 | 136.34 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 | 141.22 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 | 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-01 23:59:59" "2025-12-01 00:00:00" ]
|
||||||||||||||||||||||||||||
| 11 | 135.48 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 | 135.45 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 | 135.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-04 23:59:59" "2025-12-04 00:00:00" ]
|
||||||||||||||||||||||||||||
| 14 | 168.54 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 | 223.34 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 | 191.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-07 23:59:59" "2025-12-07 00:00:00" ]
|
||||||||||||||||||||||||||||
| 17 | 191.70 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 | 209.24 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 | 214.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-10 23:59:59" "2025-12-10 00:00:00" ]
|
||||||||||||||||||||||||||||
| 20 | 232.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-11 23:59:59" "2025-12-11 00:00:00" ]
|
||||||||||||||||||||||||||||
| 21 | 215.78 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.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-13 23:59:59" "2025-12-13 00:00:00" ]
|
||||||||||||||||||||||||||||
| 23 | 136.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-12-14 23:59:59" "2025-12-14 00:00:00" ]
|
||||||||||||||||||||||||||||
| 24 | 135.81 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.42 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.34 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 | 136.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-18 23:59:59" "2025-12-18 00:00:00" ]
|
||||||||||||||||||||||||||||
| 28 | 136.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-19 23:59:59" "2025-12-19 00:00:00" ]
|
||||||||||||||||||||||||||||
| 29 | 136.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-20 23:59:59" "2025-12-20 00:00:00" ]
|
||||||||||||||||||||||||||||
| 30 | 137.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-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. |