https://lara.camileia.com/devices/lora/wattecoTemperature

Query Metrics

5 Database Queries
5 Different statements
7.34 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.89 ms
(80.17%)
1
"COMMIT"
Parameters:
[]
0.82 ms
(11.22%)
1
SELECT d0_.id AS id_0, d0_.id_client AS id_client_1, d0_.libelle_client AS libelle_client_2, d0_.numero_serie AS numero_serie_3, d0_.voltage AS voltage_4, d0_.date_activation AS date_activation_5, d0_.is_bon_etat AS is_bon_etat_6, d0_.pourcentage_batterie AS pourcentage_batterie_7, d0_.pac AS pac_8, d0_.link_quality AS link_quality_9, d0_.date_derniere_communication AS date_derniere_communication_10, d0_.ville AS ville_11, d0_.libelle AS libelle_12, d0_.delai_limite AS delai_limite_13, d0_.trigger_alert AS trigger_alert_14, d0_.dev_eui AS dev_eui_15, d0_.gateway_path AS gateway_path_16, d0_.modele_id AS modele_id_17, d0_.scenario_id AS scenario_id_18 FROM device d0_ WHERE d0_.numero_serie = ?
Parameters:
[
  "70b3d5e75e01549a"
]
0.26 ms
(3.52%)
1
INSERT INTO data_uplinks (temperature, humidity, source_button, type_trigger, horodating, mode, code_alerte, message_alerte, severity, error_message, activity_level, co2ppm, dev_eui, illumination, infrared, infrared_and_visible, pressure, tvoc, dba, dbaeq, dbamax, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  19.11
  null
  null
  null
  "2025-10-14 02:34:48"
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  15
]
0.20 ms
(2.70%)
1
UPDATE device SET link_quality = ?, date_derniere_communication = ? WHERE id = ?
Parameters:
[
  "0"
  "2025-10-14 02:34:48"
  15
]
0.18 ms
(2.40%)
1
"START TRANSACTION"
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\Device No errors.
App\Entity\Modele No errors.
App\Entity\Scenario No errors.
App\Entity\DataUplinks No errors.