Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.descrizione AS descrizione_3, t0.token AS token_4 FROM gateway_temperatura t0 WHERE t0.token = ? LIMIT 1

[
  "5d9a37b33fe78c5905666af7c4709837d6d5d129cdc72a28551bdec9268df6b6"
]

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.descrizione AS descrizione_3,
  t0.token AS token_4
FROM
  gateway_temperatura t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.descrizione AS descrizione_3, t0.token AS token_4 FROM gateway_temperatura t0 WHERE t0.token = '5d9a37b33fe78c5905666af7c4709837d6d5d129cdc72a28551bdec9268df6b6' LIMIT 1;

SELECT t0.id AS id_1, t0.sensor_id AS sensor_id_2, t0.nome AS nome_3, t0.descrizione AS descrizione_4, t0.timeout_minuti AS timeout_minuti_5, t0.temp_min AS temp_min_6, t0.temp_max AS temp_max_7, t0.last_seen AS last_seen_8, t0.last_temperatura AS last_temperatura_9, t0.last_humidity AS last_humidity_10, t0.last_voltage AS last_voltage_11, t0.last_rssi AS last_rssi_12, t0.offset_gradi AS offset_gradi_13, t0.gateway_id AS gateway_id_14 FROM sensore_temperatura t0 WHERE t0.sensor_id = ? AND t0.gateway_id = ? LIMIT 1

[
  "10007067"
  1
]

SELECT
  t0.id AS id_1,
  t0.sensor_id AS sensor_id_2,
  t0.nome AS nome_3,
  t0.descrizione AS descrizione_4,
  t0.timeout_minuti AS timeout_minuti_5,
  t0.temp_min AS temp_min_6,
  t0.temp_max AS temp_max_7,
  t0.last_seen AS last_seen_8,
  t0.last_temperatura AS last_temperatura_9,
  t0.last_humidity AS last_humidity_10,
  t0.last_voltage AS last_voltage_11,
  t0.last_rssi AS last_rssi_12,
  t0.offset_gradi AS offset_gradi_13,
  t0.gateway_id AS gateway_id_14
FROM
  sensore_temperatura t0
WHERE
  t0.sensor_id = ?
  AND t0.gateway_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sensor_id AS sensor_id_2, t0.nome AS nome_3, t0.descrizione AS descrizione_4, t0.timeout_minuti AS timeout_minuti_5, t0.temp_min AS temp_min_6, t0.temp_max AS temp_max_7, t0.last_seen AS last_seen_8, t0.last_temperatura AS last_temperatura_9, t0.last_humidity AS last_humidity_10, t0.last_voltage AS last_voltage_11, t0.last_rssi AS last_rssi_12, t0.offset_gradi AS offset_gradi_13, t0.gateway_id AS gateway_id_14 FROM sensore_temperatura t0 WHERE t0.sensor_id = '10007067' AND t0.gateway_id = 1 LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sensore_temperatura_lettura (temperatura, temperatura_corretta, humidity, voltage, rssi, registrata_at, sensore_id) VALUES (?, ?, ?, ?, ?, ?, ?)

[
  0.1
  1.1
  0.0
  2.77
  -76
  "2026-04-19 19:19:22"
  2
]

INSERT INTO sensore_temperatura_lettura (
  temperatura, temperatura_corretta,
  humidity, voltage, rssi, registrata_at,
  sensore_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO sensore_temperatura_lettura (temperatura, temperatura_corretta, humidity, voltage, rssi, registrata_at, sensore_id) VALUES (0.1, 1.1, 0, 2.77, -76, '2026-04-19 19:19:22', 2);

UPDATE sensore_temperatura SET last_seen = ?, last_temperatura = ?, last_rssi = ? WHERE id = ?

[
  "2026-04-19 19:19:22"
  1.1
  -76
  2
]

UPDATE
  sensore_temperatura
SET
  last_seen = ?,
  last_temperatura = ?,
  last_rssi = ?
WHERE
  id = ?

UPDATE sensore_temperatura SET last_seen = '2026-04-19 19:19:22', last_temperatura = 1.1, last_rssi = -76 WHERE id = 2;

"COMMIT"

[]

"COMMIT"

"COMMIT";

DELETE FROM sensore_temperatura_lettura WHERE registrata_at < ?

[
  "2026-04-12 19:19:22"
]

DELETE FROM
  sensore_temperatura_lettura
WHERE
  registrata_at < ?

DELETE FROM sensore_temperatura_lettura WHERE registrata_at < '2026-04-12 19:19:22';