Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Emails
• Workflow
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.device_eui AS device_eui_2, t0.app_key AS app_key_3, t0.app_eui AS app_eui_4, t0.created_swisscom AS created_swisscom_5, t0.last_seen AS last_seen_6, t0.serial_number AS serial_number_7, t0.last_latitude AS last_latitude_8, t0.last_longitude AS last_longitude_9, t0.last_battery AS last_battery_10, t11.id AS id_12, t11.description AS description_13, t11.status AS status_14, t11.gps AS gps_15, t11.type_id AS type_id_16, t11.client_id AS client_id_17, t11.chantier_id AS chantier_id_18, t11.materiel_id AS materiel_id_19, t11.provenance_id AS provenance_id_20, t11.destination_id AS destination_id_21, t11.emplacement_actuel_id AS emplacement_actuel_id_22, t11.tracker_id AS tracker_id_23, t24.id AS id_25, t24.plaques AS plaques_26, t24.km AS km_27, t24.heures AS heures_28, t24.is_remorque AS is_remorque_29, t24.is_accessoire AS is_accessoire_30, t24.can_remorque AS can_remorque_31, t24.total_weight AS total_weight_32, t24.per_axle_weight AS per_axle_weight_33, t24.height AS height_34, t24.length AS length_35, t24.width AS width_36, t24.nb_axles AS nb_axles_37, t24.date_reception AS date_reception_38, t24.date_reddition AS date_reddition_39, t24.tracker_id AS tracker_id_40 FROM tracker t0 LEFT JOIN bennes t11 ON t11.tracker_id = t0.id LEFT JOIN vehicules t24 ON t24.tracker_id = t0.id WHERE t0.device_eui = ? LIMIT 1

[
  "70B3D5705000835C"
]

SELECT
  t0.id AS id_1,
  t0.device_eui AS device_eui_2,
  t0.app_key AS app_key_3,
  t0.app_eui AS app_eui_4,
  t0.created_swisscom AS created_swisscom_5,
  t0.last_seen AS last_seen_6,
  t0.serial_number AS serial_number_7,
  t0.last_latitude AS last_latitude_8,
  t0.last_longitude AS last_longitude_9,
  t0.last_battery AS last_battery_10,
  t11.id AS id_12,
  t11.description AS description_13,
  t11.status AS status_14,
  t11.gps AS gps_15,
  t11.type_id AS type_id_16,
  t11.client_id AS client_id_17,
  t11.chantier_id AS chantier_id_18,
  t11.materiel_id AS materiel_id_19,
  t11.provenance_id AS provenance_id_20,
  t11.destination_id AS destination_id_21,
  t11.emplacement_actuel_id AS emplacement_actuel_id_22,
  t11.tracker_id AS tracker_id_23,
  t24.id AS id_25,
  t24.plaques AS plaques_26,
  t24.km AS km_27,
  t24.heures AS heures_28,
  t24.is_remorque AS is_remorque_29,
  t24.is_accessoire AS is_accessoire_30,
  t24.can_remorque AS can_remorque_31,
  t24.total_weight AS total_weight_32,
  t24.per_axle_weight AS per_axle_weight_33,
  t24.height AS height_34,
  t24.length AS length_35,
  t24.width AS width_36,
  t24.nb_axles AS nb_axles_37,
  t24.date_reception AS date_reception_38,
  t24.date_reddition AS date_reddition_39,
  t24.tracker_id AS tracker_id_40
FROM
  tracker t0
  LEFT JOIN bennes t11 ON t11.tracker_id = t0.id
  LEFT JOIN vehicules t24 ON t24.tracker_id = t0.id
WHERE
  t0.device_eui = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.device_eui AS device_eui_2, t0.app_key AS app_key_3, t0.app_eui AS app_eui_4, t0.created_swisscom AS created_swisscom_5, t0.last_seen AS last_seen_6, t0.serial_number AS serial_number_7, t0.last_latitude AS last_latitude_8, t0.last_longitude AS last_longitude_9, t0.last_battery AS last_battery_10, t11.id AS id_12, t11.description AS description_13, t11.status AS status_14, t11.gps AS gps_15, t11.type_id AS type_id_16, t11.client_id AS client_id_17, t11.chantier_id AS chantier_id_18, t11.materiel_id AS materiel_id_19, t11.provenance_id AS provenance_id_20, t11.destination_id AS destination_id_21, t11.emplacement_actuel_id AS emplacement_actuel_id_22, t11.tracker_id AS tracker_id_23, t24.id AS id_25, t24.plaques AS plaques_26, t24.km AS km_27, t24.heures AS heures_28, t24.is_remorque AS is_remorque_29, t24.is_accessoire AS is_accessoire_30, t24.can_remorque AS can_remorque_31, t24.total_weight AS total_weight_32, t24.per_axle_weight AS per_axle_weight_33, t24.height AS height_34, t24.length AS length_35, t24.width AS width_36, t24.nb_axles AS nb_axles_37, t24.date_reception AS date_reception_38, t24.date_reddition AS date_reddition_39, t24.tracker_id AS tracker_id_40 FROM tracker t0 LEFT JOIN bennes t11 ON t11.tracker_id = t0.id LEFT JOIN vehicules t24 ON t24.tracker_id = t0.id WHERE t0.device_eui = '70B3D5705000835C' LIMIT 1;

INSERT INTO tracker_uplink (acceleration, battery, altitude, latitude, longitude, datetime, frequency, gateway, tracker_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  null
  "3.63"
  null
  null
  null
  "2026-07-04 05:31:06"
  null
  null
  2
]

INSERT INTO tracker_uplink (
  acceleration, battery, altitude, latitude,
  longitude, datetime, frequency, gateway,
  tracker_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO tracker_uplink (acceleration, battery, altitude, latitude, longitude, datetime, frequency, gateway, tracker_id) VALUES (NULL, '3.63', NULL, NULL, NULL, '2026-07-04 05:31:06', NULL, NULL, 2);

UPDATE tracker SET last_seen = ?, last_battery = ? WHERE id = ?

[
  "2026-07-04 05:31:06"
  3.63
  2
]

UPDATE
  tracker
SET
  last_seen = ?,
  last_battery = ?
WHERE
  id = ?

UPDATE tracker SET last_seen = '2026-07-04 05:31:06', last_battery = 3.63 WHERE id = 2;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";