Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

3.72 ms Query time

1 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.54 ms
(41.33%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\Api\TemperatureApiController->sync (line 82)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.55 ms
(14.74%)

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

Parameters:

[
  "5d9a37b33fe78c5905666af7c4709837d6d5d129cdc72a28551bdec9268df6b6"
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\GatewayTemperaturaRepository->findByToken (line 24)
5	App\Controller\Api\TemperatureApiController->sync (line 29)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.44 ms
(11.89%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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 = '10007068' AND t0.gateway_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\Api\TemperatureApiController->sync (line 47)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.42 ms
(11.40%)

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

Parameters:

[
  -23.0
  -21.0
  0.0
  3.55
  -94
  "2026-04-20 03:21:50"
  3
]

View formatted query View runnable query Explain query View query backtrace

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 (-23, -21, 0, 3.55, -94, '2026-04-20 03:21:50', 3);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Api\TemperatureApiController->sync (line 82)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.34 ms
(9.03%)

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

Parameters:

[
  "2026-04-20 03:21:50"
  -21.0
  3
]

View formatted query View runnable query Explain query View query backtrace

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

UPDATE sensore_temperatura SET last_seen = '2026-04-20 03:21:50', last_temperatura = -21 WHERE id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Api\TemperatureApiController->sync (line 82)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.30 ms
(8.17%)

DELETE FROM sensore_temperatura_lettura WHERE registrata_at < ?

Parameters:

[
  "2026-04-13 03:21:50"
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  sensore_temperatura_lettura
WHERE
  registrata_at < ?

DELETE FROM sensore_temperatura_lettura WHERE registrata_at < '2026-04-13 03:21:50';

#	File/Call
1	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 38)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	App\Repository\SensoreTemperaturaLetturaRepository->deleteOlderThan (line 60)
6	App\Controller\Api\TemperatureApiController->sync (line 85)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.13 ms
(3.44%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\Api\TemperatureApiController->sync (line 82)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\GatewayTemperatura	1
App\Entity\SensoreTemperatura	1
App\Entity\SensoreTemperaturaLettura	1

Entities Mapping

Class	Mapping errors
App\Entity\GatewayTemperatura	The field App\Entity\GatewayTemperatura#sensori is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SensoreTemperatura#gateway does not contain the required 'inversedBy: "sensori"' attribute.
App\Entity\SensoreTemperatura	No errors.
App\Entity\SensoreTemperaturaLettura	No errors.

Symfony Profiler

GET https://dipendenti.ebisnc.it/api/temperatureFrigo/sync?data=ID%3D10007068%2CTEP%3D-23.0%A1%E6%2CHUM%3D000.0%25%2CS%3D00000000%2CV%3D3.55V%2CSN%3D085%2CRSSI%3D-0…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping