Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.43 ms Query time

2 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.64 ms
(47.93%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 434)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\EventListener\UserPresenceSubscriber->onKernelRequest (line 64)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.74 ms
(21.56%)

SELECT a0_.id AS id_0, a0_.nota AS nota_1, a0_.titulo AS titulo_2, a0_.fecha_notificacion AS fecha_notificacion_3, a0_.notificado AS notificado_4, a0_.silenciado AS silenciado_5, a0_.fechacreate AS fechacreate_6, a0_.fechaupdate AS fechaupdate_7, a0_.estado AS estado_8, a0_.delete_logic AS delete_logic_9, a0_.usu_create_id AS usu_create_id_10, a0_.usu_update_id AS usu_update_id_11, a0_.empresa_id AS empresa_id_12 FROM agenda a0_ WHERE a0_.empresa_id = ? AND a0_.fecha_notificacion IS NOT NULL AND a0_.fecha_notificacion >= ? AND a0_.fecha_notificacion <= ? AND a0_.notificado = ? AND a0_.silenciado = ? AND a0_.delete_logic = 0 AND a0_.estado = 1 AND a0_.usu_create_id = ? ORDER BY a0_.fecha_notificacion ASC

Parameters:

[
  2
  "2026-06-30 00:00:00"
  "2026-07-01 23:59:59"
  0
  0
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.nota AS nota_1,
  a0_.titulo AS titulo_2,
  a0_.fecha_notificacion AS fecha_notificacion_3,
  a0_.notificado AS notificado_4,
  a0_.silenciado AS silenciado_5,
  a0_.fechacreate AS fechacreate_6,
  a0_.fechaupdate AS fechaupdate_7,
  a0_.estado AS estado_8,
  a0_.delete_logic AS delete_logic_9,
  a0_.usu_create_id AS usu_create_id_10,
  a0_.usu_update_id AS usu_update_id_11,
  a0_.empresa_id AS empresa_id_12
FROM
  agenda a0_
WHERE
  a0_.empresa_id = ?
  AND a0_.fecha_notificacion IS NOT NULL
  AND a0_.fecha_notificacion >= ?
  AND a0_.fecha_notificacion <= ?
  AND a0_.notificado = ?
  AND a0_.silenciado = ?
  AND a0_.delete_logic = 0
  AND a0_.estado = 1
  AND a0_.usu_create_id = ?
ORDER BY
  a0_.fecha_notificacion ASC

SELECT a0_.id AS id_0, a0_.nota AS nota_1, a0_.titulo AS titulo_2, a0_.fecha_notificacion AS fecha_notificacion_3, a0_.notificado AS notificado_4, a0_.silenciado AS silenciado_5, a0_.fechacreate AS fechacreate_6, a0_.fechaupdate AS fechaupdate_7, a0_.estado AS estado_8, a0_.delete_logic AS delete_logic_9, a0_.usu_create_id AS usu_create_id_10, a0_.usu_update_id AS usu_update_id_11, a0_.empresa_id AS empresa_id_12 FROM agenda a0_ WHERE a0_.empresa_id = 2 AND a0_.fecha_notificacion IS NOT NULL AND a0_.fecha_notificacion >= '2026-06-30 00:00:00' AND a0_.fecha_notificacion <= '2026-07-01 23:59:59' AND a0_.notificado = 0 AND a0_.silenciado = 0 AND a0_.delete_logic = 0 AND a0_.estado = 1 AND a0_.usu_create_id = 2 ORDER BY a0_.fecha_notificacion ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\AgendaRepository->findPendientesCampanaPorEmpresaYTrabajador (line 240)
7	App\Application\Operacionales\Agenda\Service\AgendaApiService->proximas (line 145)
8	App\Application\Operacionales\Agenda\Service\AgendaApiEndpointService->proximas (line 243)
9	App\Controller\api\v1\operacionales\AgendaController->proximas (line 26)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.50 ms
(14.53%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.fecha_incripcion AS fecha_incripcion_5, t0.pw AS pw_6, t0.login AS login_7, t0.fechas_inicio_sesion AS fechas_inicio_sesion_8, t0.onboarding_config_visto AS onboarding_config_visto_9, t0.onboarding_config_visto_at AS onboarding_config_visto_at_10, t0.last_activity_at AS last_activity_at_11, t0.fechacreate AS fechacreate_12, t0.fechaupdate AS fechaupdate_13, t0.estado AS estado_14, t0.delete_logic AS delete_logic_15, t0.trabajador_id AS trabajador_id_16, t0.grupousuario_id AS grupousuario_id_17, t0.suscripciones_id AS suscripciones_id_18, t0.cuenta_pagos_id AS cuenta_pagos_id_19, t0.emision_cheques_id AS emision_cheques_id_20, t0.empresa_id AS empresa_id_21 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.fecha_incripcion AS fecha_incripcion_5,
  t0.pw AS pw_6,
  t0.login AS login_7,
  t0.fechas_inicio_sesion AS fechas_inicio_sesion_8,
  t0.onboarding_config_visto AS onboarding_config_visto_9,
  t0.onboarding_config_visto_at AS onboarding_config_visto_at_10,
  t0.last_activity_at AS last_activity_at_11,
  t0.fechacreate AS fechacreate_12,
  t0.fechaupdate AS fechaupdate_13,
  t0.estado AS estado_14,
  t0.delete_logic AS delete_logic_15,
  t0.trabajador_id AS trabajador_id_16,
  t0.grupousuario_id AS grupousuario_id_17,
  t0.suscripciones_id AS suscripciones_id_18,
  t0.cuenta_pagos_id AS cuenta_pagos_id_19,
  t0.emision_cheques_id AS emision_cheques_id_20,
  t0.empresa_id AS empresa_id_21
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.fecha_incripcion AS fecha_incripcion_5, t0.pw AS pw_6, t0.login AS login_7, t0.fechas_inicio_sesion AS fechas_inicio_sesion_8, t0.onboarding_config_visto AS onboarding_config_visto_9, t0.onboarding_config_visto_at AS onboarding_config_visto_at_10, t0.last_activity_at AS last_activity_at_11, t0.fechacreate AS fechacreate_12, t0.fechaupdate AS fechaupdate_13, t0.estado AS estado_14, t0.delete_logic AS delete_logic_15, t0.trabajador_id AS trabajador_id_16, t0.grupousuario_id AS grupousuario_id_17, t0.suscripciones_id AS suscripciones_id_18, t0.cuenta_pagos_id AS cuenta_pagos_id_19, t0.emision_cheques_id AS emision_cheques_id_20, t0.empresa_id AS empresa_id_21 FROM `user` t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 227)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.36 ms
(10.53%)

UPDATE `user` SET fechas_inicio_sesion = ?, fechaupdate = ? WHERE id = ?

Parameters:

[
  "2026-06-30 14:10:37"
  "2026-06-30 14:10:37"
  2
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `user`
SET
  fechas_inicio_sesion = ?,
  fechaupdate = ?
WHERE
  id = ?

UPDATE `user` SET fechas_inicio_sesion = '2026-06-30 14:10:37', fechaupdate = '2026-06-30 14:10:37' WHERE id = 2;

#	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 1141)
4	Doctrine\ORM\UnitOfWork->commit (line 409)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\EventListener\UserPresenceSubscriber->onKernelRequest (line 64)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.19 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\UnitOfWork->commit (line 383)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\EventListener\UserPresenceSubscriber->onKernelRequest (line 64)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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\User	1
App\Entity\Trabajadores	1
App\Entity\Grupousuarios	1
App\Entity\Suscripciones	1
App\Entity\CuentaPagos	1
App\Entity\ConfiguracionEmisionCheques	1
App\Entity\Empresa	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Trabajadores	The field 'App\Entity\Trabajadores#salario' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field App\Entity\Trabajadores#user is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#trabajador does not contain the required 'inversedBy: "user"' attribute.
App\Entity\Grupousuarios	No errors.
App\Entity\Suscripciones	The field 'App\Entity\Suscripciones#precio' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\CuentaPagos	No errors.
App\Entity\ConfiguracionEmisionCheques	No errors.
App\Entity\Empresa	No errors.
App\Entity\Agenda	No errors.

Symfony Profiler

GET https://dev.ospprojectestimate.com/api/v1/operacionales/agenda/proximas?_ts=1782850237304

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping