POST https://meteo.eltharin18.myds.me/data/send

Response
200 OK
IP
192.168.8.253
Profiled on
Token
80f5bf

Query Metrics

4 Database Queries
4 Different statements
15.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
13.20 ms
(87.96%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.79 ms
(5.24%) 		1 
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: 
[]
View formatted query    View runnable query    Explain query
0.70 ms
(4.69%) 		1 
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 06:15:13"
  23.67
  59.0
  10.17
  97.0
  108
  0.0
  108
  0.0
  0.0
  0.0
  1002.0
  "{"type":"m","ts":"2024-09-21T06:17:58.580Z","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.3,"c99":240.0,"c96":59,"c95":0,"c914":58.6,"c911":210.0,"c97":59,"c93":76.3,"c915":57.3,"c912":210.0,"c98":59,"c94":74.6,"c91":74.6,"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.8,"c39":240.0,"c35":97,"c36":0,"c314":60.9,"c311":210.0,"c37":97,"c33":55.5,"c315":56.8,"c312":210.0,"c38":97,"c34":50.3,"c31":50.3,"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}}}}}}"
]
View formatted query    View runnable query    Explain query
0.32 ms
(2.11%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.