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

Response
200 OK
IP
192.168.8.253
Profiled on
Token
d4b52c

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
8.09 ms
(85.53%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.59 ms
(6.19%) 		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.55 ms
(5.84%) 		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 13:45:39"
  26.22
  49.0
  23.61
  61.0
  126
  0.0
  144
  0.0
  0.0
  0.0
  1002.0
  "{"type":"m","ts":"2024-09-21T13:48:26.260Z","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":56.9,"c99":240.0,"c96":49,"c95":0,"c914":58.7,"c911":210.0,"c97":60,"c93":79.7,"c915":56.9,"c912":210.0,"c98":49,"c94":73.9,"c91":79.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":58.4,"c39":240.0,"c35":61,"c36":0,"c314":64.0,"c311":210.0,"c37":97,"c33":77.1,"c315":56.3,"c312":210.0,"c38":55,"c34":49.6,"c31":74.5,"c32":0 },"w2":{"c24":8,"c22":0.00,"c25":128,"c23":7,"c21":0.00,"c27":210.0,"c26":210.0,"c28":0,"c29":0.00}}}}}}"
]
View formatted query    View runnable query    Explain query
0.23 ms
(2.45%) 		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.