Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

10.74 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.07 ms
(28.61%)

UPDATE registro_horas SET ultima_atividade = ?, tempo_total = ?, ultimo_tempo_recebido = ? WHERE id = ?

Parameters:

[
  "2025-12-11 22:49:22"
  8910
  8910
  448
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  registro_horas
SET
  ultima_atividade = ?,
  tempo_total = ?,
  ultimo_tempo_recebido = ?
WHERE
  id = ?

UPDATE registro_horas SET ultima_atividade = '2025-12-11 22:49:22', tempo_total = 8910, ultimo_tempo_recebido = 8910 WHERE id = 448;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 35)
7	App\Repository\SuperClassRepository->flush (line 61)
8	App\Controller\RecursosHumanos\MonitorController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

2.15 ms
(19.98%)

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cpf AS cpf_3, t0.rg AS rg_4, t0.telefone AS telefone_5, t0.celular AS celular_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.data_admissao AS data_admissao_9, t0.data_demissao AS data_demissao_10, t0.ativo AS ativo_11, t0.situacao AS situacao_12, t0.password AS password_13, t0.role AS role_14, t0.endereco_id AS endereco_id_15, t0.cargo_id AS cargo_id_16, t0.empresa_registro_id AS empresa_registro_id_17, t0.tipo_cadastro FROM colaborador t0 WHERE t0.id = ?

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.cpf AS cpf_3,
  t0.rg AS rg_4,
  t0.telefone AS telefone_5,
  t0.celular AS celular_6,
  t0.email AS email_7,
  t0.created_at AS created_at_8,
  t0.data_admissao AS data_admissao_9,
  t0.data_demissao AS data_demissao_10,
  t0.ativo AS ativo_11,
  t0.situacao AS situacao_12,
  t0.password AS password_13,
  t0.role AS role_14,
  t0.endereco_id AS endereco_id_15,
  t0.cargo_id AS cargo_id_16,
  t0.empresa_registro_id AS empresa_registro_id_17,
  t0.tipo_cadastro
FROM
  colaborador t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cpf AS cpf_3, t0.rg AS rg_4, t0.telefone AS telefone_5, t0.celular AS celular_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.data_admissao AS data_admissao_9, t0.data_demissao AS data_demissao_10, t0.ativo AS ativo_11, t0.situacao AS situacao_12, t0.password AS password_13, t0.role AS role_14, t0.endereco_id AS endereco_id_15, t0.cargo_id AS cargo_id_16, t0.empresa_registro_id AS empresa_registro_id_17, t0.tipo_cadastro FROM colaborador t0 WHERE t0.id = 33;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 7)

2.09 ms
(19.50%)

SELECT t0.id AS id_1, t0.data AS data_2, t0.horario_login AS horario_login_3, t0.ultima_atividade AS ultima_atividade_4, t0.tempo_total AS tempo_total_5, t0.ultimo_tempo_recebido AS ultimo_tempo_recebido_6, t0.usuario_id AS usuario_id_7 FROM registro_horas t0 WHERE t0.usuario_id = ? AND t0.data = ? LIMIT 1

Parameters:

[
  33
  "2025-12-11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.data AS data_2,
  t0.horario_login AS horario_login_3,
  t0.ultima_atividade AS ultima_atividade_4,
  t0.tempo_total AS tempo_total_5,
  t0.ultimo_tempo_recebido AS ultimo_tempo_recebido_6,
  t0.usuario_id AS usuario_id_7
FROM
  registro_horas t0
WHERE
  t0.usuario_id = ?
  AND t0.data = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.data AS data_2, t0.horario_login AS horario_login_3, t0.ultima_atividade AS ultima_atividade_4, t0.tempo_total AS tempo_total_5, t0.ultimo_tempo_recebido AS ultimo_tempo_recebido_6, t0.usuario_id AS usuario_id_7 FROM registro_horas t0 WHERE t0.usuario_id = 33 AND t0.data = '2025-12-11' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 26)
5	App\Controller\RecursosHumanos\MonitorController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 7)

1.89 ms
(17.59%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 35)
5	App\Repository\SuperClassRepository->flush (line 61)
6	App\Controller\RecursosHumanos\MonitorController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 7)

1.54 ms
(14.32%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 35)
4	App\Repository\SuperClassRepository->flush (line 61)
5	App\Controller\RecursosHumanos\MonitorController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 7)

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.

Entities Mapping

Class	Mapping errors
App\Entity\RecursosHumanos\Colaborador	No errors.
App\Entity\Comum\Endereco	No errors.
App\Entity\RecursosHumanos\Cargo	No errors.
App\Entity\Empresas\DadosJuridica	No errors.
App\Entity\Empresas\Empresa	No errors.
App\Entity\Operacional\Vendas\Edital\Edital	The association App\Entity\Operacional\Vendas\Edital\Edital#estado refers to the inverse side field App\Entity\Comum\Estado#edital which does not exist.
App\Entity\RecursosHumanos\ContasBancariasColaborador	No errors.
App\Entity\Comum\Arquivo	No errors.
App\Entity\RecursosHumanos\ArquivoColaborador	No errors.
App\Entity\RecursosHumanos\ContaEmail	No errors.
App\Entity\Operacional\Compras\Solicitacao	No errors.
App\Entity\RecursosHumanos\RegistroHoras	No errors.

Symfony Profiler

POST https://licita360.com.br/erp/comum/monitor/registro-horas

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping