Query Metrics
4
Database Queries
4
Different statements
23.28 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.10 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.indoor_temperature AS indoor_temperature_3, t0.indoor_humidite AS indoor_humidite_4, t0.outdoor_temperature AS outdoor_temperature_5, t0.outdoor_humidite AS outdoor_humidite_6, t0.wind_direction AS wind_direction_7, t0.wind_vitesse AS wind_vitesse_8, t0.gust_direction AS gust_direction_9, t0.gust_vitesse AS gust_vitesse_10, t0.pluie AS pluie_11, t0.pluie_passee AS pluie_passee_12, t0.pression AS pression_13, t0.message AS message_14 FROM meteo t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[] |
2 | 0.48 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 0.85 ms |
INSERT INTO meteo (date, indoor_temperature, indoor_humidite, outdoor_temperature, outdoor_humidite, wind_direction, wind_vitesse, gust_direction, gust_vitesse, pluie, pluie_passee, pression, message) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2024-09-21 07:30:19" 23.44 59.0 9.89 97.0 108 0.0 108 0.0 0.0 0.0 1002.0 "{"type":"m","ts":"2024-09-21T07:33:03.030Z","deviceId":"d1f2cf97-7a85-493e-bae7-ffe9a29bbeeb","data": {"1":{"indoor":{"w8":{"c84":0,"c87":1,"c88":0,"c89":0,"c82":1490,"c83":1.0,"c81":"442c57d46","c85":0,"c86":1,"c811":"0.00,0.00"},"w9":{"c913":57.1,"c99":240.0,"c96":59,"c95":0,"c914":58.6,"c911":210.0,"c97":59,"c93":76.3,"c915":57.1,"c912":210.0,"c98":59,"c94":74.2,"c91":74.2,"c92":0 },"moonphase":5},"outdoor":{"channel1":{"w7":{"c75":11000,"c77":210,"c73":11000.0,"c71":11000.0,"c76":11000,"c74":11000.0,"c72":11000.0},"w1":{"c17":0,"c16":0,"c14":0,"c13":4050,"c11":0.1,"c12":0.1,"c15":2 },"w5":{"c53":1002.0,"c52":0,"c51":0 },"w4":{"c41":0.00,"c43":0.0,"c42":0.0,"c44":0.00 },"w3":{"c313":56.4,"c39":240.0,"c35":97,"c36":0,"c314":60.9,"c311":210.0,"c37":97,"c33":55.5,"c315":56.4,"c312":210.0,"c38":97,"c34":49.8,"c31":49.8,"c32":0 },"w2":{"c24":6,"c22":0.00,"c25":64,"c23":6,"c21":0.00,"c27":210.0,"c26":210.0,"c28":0,"c29":0.00}}}}}}" ] |
4 | 20.84 ms |
"COMMIT"
Parameters:
[] |
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\Meteo | No errors. |