Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

4.32 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.09 ms
(25.22%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.tipo_documento AS tipo_documento_4, t0.dni AS dni_5, t0.sexo AS sexo_6, t0.clase AS clase_7, t0.cuil AS cuil_8, t0.regimen_estatutario AS regimen_estatutario_9, t0.planta AS planta_10, t0.agrupamiento AS agrupamiento_11, t0.regimen_horario AS regimen_horario_12, t0.fecha_toma AS fecha_toma_13, t0.codigo_estructura AS codigo_estructura_14, t0.estructura_servicio AS estructura_servicio_15, t0.antiguedad AS antiguedad_16, t0.partido_laboral AS partido_laboral_17, t0.telefono AS telefono_18, t0.activo AS activo_19, t0.borrado AS borrado_20, t0.correo AS correo_21, t0.password AS password_22, t0.notificaciones_correo_activas AS notificaciones_correo_activas_23, t0.fecha_alta AS fecha_alta_24, t0.contratado AS contratado_25, t0.contrato_vigente AS contrato_vigente_26, t0.cbu AS cbu_27, t0.legajo AS legajo_28, t0.cuit AS cuit_29, t0.numero_categoria AS numero_categoria_30, t0.categoria_siape AS categoria_siape_31, t0.hash AS hash_32, t0.fecha_actualizacion AS fecha_actualizacion_33, t0.terminos_ycondiciones AS terminos_ycondiciones_34, t0.sistema_seleccionado AS sistema_seleccionado_35, t0.rol_id AS rol_id_36, t0.area_id AS area_id_37, t0.categoria_id AS categoria_id_38 FROM usuario t0 WHERE t0.id = ?

Parameters:

[
  133
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.apellido AS apellido_3,
  t0.tipo_documento AS tipo_documento_4,
  t0.dni AS dni_5,
  t0.sexo AS sexo_6,
  t0.clase AS clase_7,
  t0.cuil AS cuil_8,
  t0.regimen_estatutario AS regimen_estatutario_9,
  t0.planta AS planta_10,
  t0.agrupamiento AS agrupamiento_11,
  t0.regimen_horario AS regimen_horario_12,
  t0.fecha_toma AS fecha_toma_13,
  t0.codigo_estructura AS codigo_estructura_14,
  t0.estructura_servicio AS estructura_servicio_15,
  t0.antiguedad AS antiguedad_16,
  t0.partido_laboral AS partido_laboral_17,
  t0.telefono AS telefono_18,
  t0.activo AS activo_19,
  t0.borrado AS borrado_20,
  t0.correo AS correo_21,
  t0.password AS password_22,
  t0.notificaciones_correo_activas AS notificaciones_correo_activas_23,
  t0.fecha_alta AS fecha_alta_24,
  t0.contratado AS contratado_25,
  t0.contrato_vigente AS contrato_vigente_26,
  t0.cbu AS cbu_27,
  t0.legajo AS legajo_28,
  t0.cuit AS cuit_29,
  t0.numero_categoria AS numero_categoria_30,
  t0.categoria_siape AS categoria_siape_31,
  t0.hash AS hash_32,
  t0.fecha_actualizacion AS fecha_actualizacion_33,
  t0.terminos_ycondiciones AS terminos_ycondiciones_34,
  t0.sistema_seleccionado AS sistema_seleccionado_35,
  t0.rol_id AS rol_id_36,
  t0.area_id AS area_id_37,
  t0.categoria_id AS categoria_id_38
FROM
  usuario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.tipo_documento AS tipo_documento_4, t0.dni AS dni_5, t0.sexo AS sexo_6, t0.clase AS clase_7, t0.cuil AS cuil_8, t0.regimen_estatutario AS regimen_estatutario_9, t0.planta AS planta_10, t0.agrupamiento AS agrupamiento_11, t0.regimen_horario AS regimen_horario_12, t0.fecha_toma AS fecha_toma_13, t0.codigo_estructura AS codigo_estructura_14, t0.estructura_servicio AS estructura_servicio_15, t0.antiguedad AS antiguedad_16, t0.partido_laboral AS partido_laboral_17, t0.telefono AS telefono_18, t0.activo AS activo_19, t0.borrado AS borrado_20, t0.correo AS correo_21, t0.password AS password_22, t0.notificaciones_correo_activas AS notificaciones_correo_activas_23, t0.fecha_alta AS fecha_alta_24, t0.contratado AS contratado_25, t0.contrato_vigente AS contrato_vigente_26, t0.cbu AS cbu_27, t0.legajo AS legajo_28, t0.cuit AS cuit_29, t0.numero_categoria AS numero_categoria_30, t0.categoria_siape AS categoria_siape_31, t0.hash AS hash_32, t0.fecha_actualizacion AS fecha_actualizacion_33, t0.terminos_ycondiciones AS terminos_ycondiciones_34, t0.sistema_seleccionado AS sistema_seleccionado_35, t0.rol_id AS rol_id_36, t0.area_id AS area_id_37, t0.categoria_id AS categoria_id_38 FROM usuario t0 WHERE t0.id = 133;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 358)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 59)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 347)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 50)
15	App\Controller\NotificacionController->poll (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.87 ms
(20.12%)

SELECT COUNT(s0_.id) AS sclr_0 FROM solicitud s0_ INNER JOIN area a1_ ON s0_.area_actual_id = a1_.id INNER JOIN solicitud_estado s2_ ON s0_.estado_id = s2_.id INNER JOIN cupo_tipo c3_ ON s0_.tipo_cupo_id = c3_.id WHERE a1_.id = ? AND s2_.id IN (?, ?) AND c3_.id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  solicitud s0_
  INNER JOIN area a1_ ON s0_.area_actual_id = a1_.id
  INNER JOIN solicitud_estado s2_ ON s0_.estado_id = s2_.id
  INNER JOIN cupo_tipo c3_ ON s0_.tipo_cupo_id = c3_.id
WHERE
  a1_.id = ?
  AND s2_.id IN (?, ?)
  AND c3_.id = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM solicitud s0_ INNER JOIN area a1_ ON s0_.area_actual_id = a1_.id INNER JOIN solicitud_estado s2_ ON s0_.estado_id = s2_.id INNER JOIN cupo_tipo c3_ ON s0_.tipo_cupo_id = c3_.id WHERE a1_.id = 9 AND s2_.id IN (2, 3) AND c3_.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 282)
8	App\Repository\SolicitudRepository->countPendientesParaTesoreria (line 111)
9	App\Controller\NotificacionController->calculateSolicitudesBadge (line 91)
10	App\Controller\NotificacionController->buildBadgePayload (line 58)
11	App\Controller\NotificacionController->poll (line 178)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.82 ms
(18.94%)

SELECT COUNT(r0_.id) AS sclr_0 FROM rendicion r0_ LEFT JOIN area a1_ ON r0_.area_id = a1_.id LEFT JOIN min_delegacion m2_ ON a1_.min_delegacion_id = m2_.id WHERE r0_.estado_id = ? AND r0_.pedido_de_fondo_id IS NULL AND m2_.id = 2

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  rendicion r0_
  LEFT JOIN area a1_ ON r0_.area_id = a1_.id
  LEFT JOIN min_delegacion m2_ ON a1_.min_delegacion_id = m2_.id
WHERE
  r0_.estado_id = ?
  AND r0_.pedido_de_fondo_id IS NULL
  AND m2_.id = 2

SELECT COUNT(r0_.id) AS sclr_0 FROM rendicion r0_ LEFT JOIN area a1_ ON r0_.area_id = a1_.id LEFT JOIN min_delegacion m2_ ON a1_.min_delegacion_id = m2_.id WHERE r0_.estado_id = 2 AND r0_.pedido_de_fondo_id IS NULL AND m2_.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 144)
8	App\Repository\RendicionRepository->countPendientesTesoreria (line 126)
9	App\Controller\NotificacionController->calculateRendicionesBadge (line 92)
10	App\Controller\NotificacionController->buildBadgePayload (line 58)
11	App\Controller\NotificacionController->poll (line 178)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.55 ms
(12.80%)

SELECT COALESCE(MAX(n0_.id), 0) AS sclr_0 FROM notificacion n0_ WHERE n0_.usuario_id = ?

Parameters:

[
  133
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COALESCE(
    MAX(n0_.id),
    0
  ) AS sclr_0
FROM
  notificacion n0_
WHERE
  n0_.usuario_id = ?

SELECT COALESCE(MAX(n0_.id), 0) AS sclr_0 FROM notificacion n0_ WHERE n0_.usuario_id = 133;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 46)
8	App\Repository\NotificacionRepository->findLatestIdByUsuario (line 56)
9	App\Controller\NotificacionController->poll (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.50 ms
(11.48%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.abreviatura AS abreviatura_4, t0.color AS color_5 FROM rol t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.abreviatura AS abreviatura_4,
  t0.color AS color_5
FROM
  rol t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.abreviatura AS abreviatura_4, t0.color AS color_5 FROM rol t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 287)
5	Proxies\__CG__\App\Entity\Rol::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\Rol->__get (line 42)
8	App\Entity\Rol->getNombre (line 71)
9	App\Entity\Rol->getCredencial (line 147)
10	App\Entity\Usuario->getRoles (line 303)
11	Symfony\Component\Security\Http\Firewall\ContextListener::hasUserChanged (line 212)
12	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
13	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
15	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
16	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
17	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 347)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 50)
19	App\Controller\NotificacionController->poll (line 178)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.49 ms
(11.44%)

SELECT COUNT(n0_.id) AS sclr_0 FROM notificacion n0_ WHERE n0_.usuario_id = ? AND n0_.leida = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notificacion n0_
WHERE
  n0_.usuario_id = ?
  AND n0_.leida = ?

SELECT COUNT(n0_.id) AS sclr_0 FROM notificacion n0_ WHERE n0_.usuario_id = 133 AND n0_.leida = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 58)
8	App\Repository\NotificacionRepository->countUnreadByUsuario (line 57)
9	App\Controller\NotificacionController->poll (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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.

Entities Mapping

Class	Mapping errors
App\Entity\Usuario	No errors.
App\Entity\Rol	No errors.
App\Entity\Area	No errors.
App\Entity\Categoria	No errors.
App\Entity\UsuarioContrato	No errors.
App\Entity\Notificacion	No errors.
App\Entity\Solicitud	No errors.
App\Entity\SolicitudEstado	No errors.
App\Entity\CupoTipo	No errors.
App\Entity\Rendicion	No errors.
App\Entity\MinDelegacion	No errors.

Symfony Profiler

GET http://viaticos-test.ciencia.gba.gob.ar/notificaciones/poll?_=1783002970777

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping