Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.72 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.72 ms

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.hash AS hash_31, t0.fecha_actualizacion AS fecha_actualizacion_32, t0.terminos_ycondiciones AS terminos_ycondiciones_33, t0.sistema_seleccionado AS sistema_seleccionado_34, t0.rol_id AS rol_id_35, t0.area_id AS area_id_36, t0.categoria_id AS categoria_id_37 FROM usuario t0 WHERE t0.correo IS NULL AND t0.borrado = ? AND t0.activo = ? LIMIT 1

Parameters:

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.hash AS hash_31,
  t0.fecha_actualizacion AS fecha_actualizacion_32,
  t0.terminos_ycondiciones AS terminos_ycondiciones_33,
  t0.sistema_seleccionado AS sistema_seleccionado_34,
  t0.rol_id AS rol_id_35,
  t0.area_id AS area_id_36,
  t0.categoria_id AS categoria_id_37
FROM
  usuario t0
WHERE
  t0.correo IS NULL
  AND t0.borrado = ?
  AND t0.activo = ?
LIMIT
  1

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.hash AS hash_31, t0.fecha_actualizacion AS fecha_actualizacion_32, t0.terminos_ycondiciones AS terminos_ycondiciones_33, t0.sistema_seleccionado AS sistema_seleccionado_34, t0.rol_id AS rol_id_35, t0.area_id AS area_id_36, t0.categoria_id AS categoria_id_37 FROM usuario t0 WHERE t0.correo IS NULL AND t0.borrado = 0 AND t0.activo = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 39)
5	App\Security\AppAuthenticator->authenticate (line 70)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
10	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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.

Symfony Profiler

POST http://viaticos-test.ciencia.gba.gob.ar/login

Configuration Settings

Theme