Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

4.01 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.83 ms
(45.67%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

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

0.70 ms
(17.57%)

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cognome AS cognome_3, t0.wno_id AS wno_id_4, t0.codice_fiscale AS codice_fiscale_5, t0.contract_type AS contract_type_6, t0.codice_comunicazione_intermittente AS codice_comunicazione_intermittente_7, t0.email AS email_8, t0.telefono AS telefono_9, t0.nick_name AS nick_name_10, t0.data_scadenza_contratto AS data_scadenza_contratto_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.ore_lun AS ore_lun_15, t0.ore_mar AS ore_mar_16, t0.ore_mer AS ore_mer_17, t0.ore_gio AS ore_gio_18, t0.ore_ven AS ore_ven_19, t0.ore_sab AS ore_sab_20, t0.ore_dom AS ore_dom_21, t0.straordinari_mode AS straordinari_mode_22, t0.straordinari_max_value AS straordinari_max_value_23 FROM dipendenti t0 WHERE t0.wno_id = ? LIMIT 1

Parameters:

[
  "33"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.cognome AS cognome_3,
  t0.wno_id AS wno_id_4,
  t0.codice_fiscale AS codice_fiscale_5,
  t0.contract_type AS contract_type_6,
  t0.codice_comunicazione_intermittente AS codice_comunicazione_intermittente_7,
  t0.email AS email_8,
  t0.telefono AS telefono_9,
  t0.nick_name AS nick_name_10,
  t0.data_scadenza_contratto AS data_scadenza_contratto_11,
  t0.is_active AS is_active_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.ore_lun AS ore_lun_15,
  t0.ore_mar AS ore_mar_16,
  t0.ore_mer AS ore_mer_17,
  t0.ore_gio AS ore_gio_18,
  t0.ore_ven AS ore_ven_19,
  t0.ore_sab AS ore_sab_20,
  t0.ore_dom AS ore_dom_21,
  t0.straordinari_mode AS straordinari_mode_22,
  t0.straordinari_max_value AS straordinari_max_value_23
FROM
  dipendenti t0
WHERE
  t0.wno_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cognome AS cognome_3, t0.wno_id AS wno_id_4, t0.codice_fiscale AS codice_fiscale_5, t0.contract_type AS contract_type_6, t0.codice_comunicazione_intermittente AS codice_comunicazione_intermittente_7, t0.email AS email_8, t0.telefono AS telefono_9, t0.nick_name AS nick_name_10, t0.data_scadenza_contratto AS data_scadenza_contratto_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.ore_lun AS ore_lun_15, t0.ore_mar AS ore_mar_16, t0.ore_mer AS ore_mer_17, t0.ore_gio AS ore_gio_18, t0.ore_ven AS ore_ven_19, t0.ore_sab AS ore_sab_20, t0.ore_dom AS ore_dom_21, t0.straordinari_mode AS straordinari_mode_22, t0.straordinari_max_value AS straordinari_max_value_23 FROM dipendenti t0 WHERE t0.wno_id = '33' 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\PresenzeApiController->sync (line 157)
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.50 ms
(12.49%)

UPDATE presenze SET data_in = ?, data_out = ? WHERE id = ?

Parameters:

[
  "2026-06-19 08:17:00"
  "2026-06-19 12:39:00"
  2850
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  presenze
SET
  data_in = ?,
  data_out = ?
WHERE
  id = ?

UPDATE presenze SET data_in = '2026-06-19 08:17:00', data_out = '2026-06-19 12:39:00' WHERE id = 2850;

#	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\PresenzeApiController->sync (line 231)
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.37 ms
(9.24%)

SELECT t0.id AS id_1, t0.wno_id AS wno_id_2, t0.data_in AS data_in_3, t0.data_out AS data_out_4, t0.note AS note_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.dipendente_id AS dipendente_id_8 FROM presenze t0 WHERE t0.wno_id = ? LIMIT 1

Parameters:

[
  "2823"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.wno_id AS wno_id_2,
  t0.data_in AS data_in_3,
  t0.data_out AS data_out_4,
  t0.note AS note_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.dipendente_id AS dipendente_id_8
FROM
  presenze t0
WHERE
  t0.wno_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.wno_id AS wno_id_2, t0.data_in AS data_in_3, t0.data_out AS data_out_4, t0.note AS note_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.dipendente_id AS dipendente_id_8 FROM presenze t0 WHERE t0.wno_id = '2823' 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\PresenzeApiController->sync (line 179)
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.22 ms
(5.54%)

SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->createSavepoint (line 1173)
2	Doctrine\DBAL\Connection->beginTransaction (line 1063)
3	Doctrine\ORM\UnitOfWork->commit (line 382)
4	Doctrine\ORM\EntityManager->flush (line 268)
5	App\Controller\Api\PresenzeApiController->sync (line 231)
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.22 ms
(5.45%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\EntityManager->beginTransaction (line 172)
2	App\Controller\Api\PresenzeApiController->sync (line 68)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 193)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 5)

0.16 ms
(4.05%)

RELEASE SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->releaseSavepoint (line 1195)
2	Doctrine\DBAL\Connection->commit (line 1088)
3	Doctrine\ORM\UnitOfWork->commit (line 433)
4	Doctrine\ORM\EntityManager->flush (line 268)
5	App\Controller\Api\PresenzeApiController->sync (line 231)
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)

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\Dipendente	1
App\Entity\Presenza	1

Entities Mapping

Class	Mapping errors
App\Entity\Dipendente	No errors.
App\Entity\Presenza	No errors.
App\Entity\ConsumoRiga	No errors.
App\Entity\DipendenteDocumento	No errors.

Symfony Profiler

POST https://dipendenti.ebisnc.it/api/presenze/sync

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping