Query Metrics
30
Database Queries
1
Different statements
4908.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
4908.66 ms (100.00%) |
30 |
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" ]
|
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. |