Symfony Profiler

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 = ?

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 = '70b3d5e75e01549a';

"START TRANSACTION"

"START TRANSACTION";

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
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

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 (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);

UPDATE
  device
SET
  link_quality = ?,
  date_derniere_communication = ?
WHERE
  id = ?

UPDATE device SET link_quality = '0', date_derniere_communication = '2025-10-14 02:34:48' WHERE id = 15;

"COMMIT"

"COMMIT";