Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.72 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.23 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.nombre AS nombre_3, t0.salario AS salario_4, t0.bonus AS bonus_5, t0.cargo AS cargo_6, t0.pais AS pais_7, t0.fecha_inicio AS fecha_inicio_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.dni AS dni_10, t0.telefono_empresa AS telefono_empresa_11, t0.telefono_personal AS telefono_personal_12, t0.estado AS estado_13, t0.apellidos AS apellidos_14, t0.lenguaje AS lenguaje_15, t0.uuid AS uuid_16, t0.roles AS roles_17, t0.oficina AS oficina_18, t0.nivel_organizativo AS nivel_organizativo_19, t0.fecha_salida AS fecha_salida_20, t0.dias_vacaciones_pendientes AS dias_vacaciones_pendientes_21, t0.borrado AS borrado_22, t0.personaltoken AS personaltoken_23, t0.password AS password_24, t0.login_admin AS login_admin_25, t0.cuenta_bancaria AS cuenta_bancaria_26, t0.entidad_bancaria AS entidad_bancaria_27, t0.direccion_bancaria AS direccion_bancaria_28, t0.oficina_bancaria AS oficina_bancaria_29, t0.localidad_bancaria AS localidad_bancaria_30, t0.provincia_bancaria AS provincia_bancaria_31, t0.pais_bancario AS pais_bancario_32, t0.motivo_baja AS motivo_baja_33, t0.dias_vacaciones_disfrutados AS dias_vacaciones_disfrutados_34, t0.dias_vacaciones_solicitados AS dias_vacaciones_solicitados_35, t0.seed AS seed_36, t0.direccion AS direccion_37, t0.contacto_emergencia_nombre AS contacto_emergencia_nombre_38, t0.contacto_emergencia_direccion AS contacto_emergencia_direccion_39, t0.contacto_emergencia_telefono AS contacto_emergencia_telefono_40, t0.contacto_emergencia_correo AS contacto_emergencia_correo_41, t0.contacto_emergencia_relacion AS contacto_emergencia_relacion_42, t0.dia_teletrabajo AS dia_teletrabajo_43, t0.fondo_formacion AS fondo_formacion_44, t0.teletrabajo_multi_dia AS teletrabajo_multi_dia_45, t0.dias_pendientes_ano_pasado AS dias_pendientes_ano_pasado_46, t0.dias_solicitados_ano_pasado AS dias_solicitados_ano_pasado_47, t0.dias_disfrutados_ano_pasado AS dias_disfrutados_ano_pasado_48, t0.datos_dispositivo AS datos_dispositivo_49, t0.departamento_id AS departamento_id_50, t0.id_responsable_id AS id_responsable_id_51, t0.admintoken_id AS admintoken_id_52, t0.proceso_edicion_id AS proceso_edicion_id_53, t0.viaje_aacompanante_id AS viaje_aacompanante_id_54 FROM usuario t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "anon."
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nombre AS nombre_3,
  t0.salario AS salario_4,
  t0.bonus AS bonus_5,
  t0.cargo AS cargo_6,
  t0.pais AS pais_7,
  t0.fecha_inicio AS fecha_inicio_8,
  t0.fecha_nacimiento AS fecha_nacimiento_9,
  t0.dni AS dni_10,
  t0.telefono_empresa AS telefono_empresa_11,
  t0.telefono_personal AS telefono_personal_12,
  t0.estado AS estado_13,
  t0.apellidos AS apellidos_14,
  t0.lenguaje AS lenguaje_15,
  t0.uuid AS uuid_16,
  t0.roles AS roles_17,
  t0.oficina AS oficina_18,
  t0.nivel_organizativo AS nivel_organizativo_19,
  t0.fecha_salida AS fecha_salida_20,
  t0.dias_vacaciones_pendientes AS dias_vacaciones_pendientes_21,
  t0.borrado AS borrado_22,
  t0.personaltoken AS personaltoken_23,
  t0.password AS password_24,
  t0.login_admin AS login_admin_25,
  t0.cuenta_bancaria AS cuenta_bancaria_26,
  t0.entidad_bancaria AS entidad_bancaria_27,
  t0.direccion_bancaria AS direccion_bancaria_28,
  t0.oficina_bancaria AS oficina_bancaria_29,
  t0.localidad_bancaria AS localidad_bancaria_30,
  t0.provincia_bancaria AS provincia_bancaria_31,
  t0.pais_bancario AS pais_bancario_32,
  t0.motivo_baja AS motivo_baja_33,
  t0.dias_vacaciones_disfrutados AS dias_vacaciones_disfrutados_34,
  t0.dias_vacaciones_solicitados AS dias_vacaciones_solicitados_35,
  t0.seed AS seed_36,
  t0.direccion AS direccion_37,
  t0.contacto_emergencia_nombre AS contacto_emergencia_nombre_38,
  t0.contacto_emergencia_direccion AS contacto_emergencia_direccion_39,
  t0.contacto_emergencia_telefono AS contacto_emergencia_telefono_40,
  t0.contacto_emergencia_correo AS contacto_emergencia_correo_41,
  t0.contacto_emergencia_relacion AS contacto_emergencia_relacion_42,
  t0.dia_teletrabajo AS dia_teletrabajo_43,
  t0.fondo_formacion AS fondo_formacion_44,
  t0.teletrabajo_multi_dia AS teletrabajo_multi_dia_45,
  t0.dias_pendientes_ano_pasado AS dias_pendientes_ano_pasado_46,
  t0.dias_solicitados_ano_pasado AS dias_solicitados_ano_pasado_47,
  t0.dias_disfrutados_ano_pasado AS dias_disfrutados_ano_pasado_48,
  t0.datos_dispositivo AS datos_dispositivo_49,
  t0.departamento_id AS departamento_id_50,
  t0.id_responsable_id AS id_responsable_id_51,
  t0.admintoken_id AS admintoken_id_52,
  t0.proceso_edicion_id AS proceso_edicion_id_53,
  t0.viaje_aacompanante_id AS viaje_aacompanante_id_54
FROM
  usuario t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.nombre AS nombre_3, t0.salario AS salario_4, t0.bonus AS bonus_5, t0.cargo AS cargo_6, t0.pais AS pais_7, t0.fecha_inicio AS fecha_inicio_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.dni AS dni_10, t0.telefono_empresa AS telefono_empresa_11, t0.telefono_personal AS telefono_personal_12, t0.estado AS estado_13, t0.apellidos AS apellidos_14, t0.lenguaje AS lenguaje_15, t0.uuid AS uuid_16, t0.roles AS roles_17, t0.oficina AS oficina_18, t0.nivel_organizativo AS nivel_organizativo_19, t0.fecha_salida AS fecha_salida_20, t0.dias_vacaciones_pendientes AS dias_vacaciones_pendientes_21, t0.borrado AS borrado_22, t0.personaltoken AS personaltoken_23, t0.password AS password_24, t0.login_admin AS login_admin_25, t0.cuenta_bancaria AS cuenta_bancaria_26, t0.entidad_bancaria AS entidad_bancaria_27, t0.direccion_bancaria AS direccion_bancaria_28, t0.oficina_bancaria AS oficina_bancaria_29, t0.localidad_bancaria AS localidad_bancaria_30, t0.provincia_bancaria AS provincia_bancaria_31, t0.pais_bancario AS pais_bancario_32, t0.motivo_baja AS motivo_baja_33, t0.dias_vacaciones_disfrutados AS dias_vacaciones_disfrutados_34, t0.dias_vacaciones_solicitados AS dias_vacaciones_solicitados_35, t0.seed AS seed_36, t0.direccion AS direccion_37, t0.contacto_emergencia_nombre AS contacto_emergencia_nombre_38, t0.contacto_emergencia_direccion AS contacto_emergencia_direccion_39, t0.contacto_emergencia_telefono AS contacto_emergencia_telefono_40, t0.contacto_emergencia_correo AS contacto_emergencia_correo_41, t0.contacto_emergencia_relacion AS contacto_emergencia_relacion_42, t0.dia_teletrabajo AS dia_teletrabajo_43, t0.fondo_formacion AS fondo_formacion_44, t0.teletrabajo_multi_dia AS teletrabajo_multi_dia_45, t0.dias_pendientes_ano_pasado AS dias_pendientes_ano_pasado_46, t0.dias_solicitados_ano_pasado AS dias_solicitados_ano_pasado_47, t0.dias_disfrutados_ano_pasado AS dias_disfrutados_ano_pasado_48, t0.datos_dispositivo AS datos_dispositivo_49, t0.departamento_id AS departamento_id_50, t0.id_responsable_id AS id_responsable_id_51, t0.admintoken_id AS admintoken_id_52, t0.proceso_edicion_id AS proceso_edicion_id_53, t0.viaje_aacompanante_id AS viaje_aacompanante_id_54 FROM usuario t0 WHERE t0.email = 'anon.' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 41)
5	App\Security\UserProvider->loadUserByIdentifier (line 87)
6	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
7	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
8	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.49 ms

SELECT t0.id AS id_1, t0.clave AS clave_2, t0.valor AS valor_3, t0.tipo AS tipo_4 FROM configuracion t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.clave AS clave_2,
  t0.valor AS valor_3,
  t0.tipo AS tipo_4
FROM
  configuracion t0

SELECT t0.id AS id_1, t0.clave AS clave_2, t0.valor AS valor_3, t0.tipo AS tipo_4 FROM configuracion t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 60)
6	App\Utils\Config->__construct (line 37)
7	App\Controller\MainController->__construct (line 24)
8	ContainerGErMxM3\getMainControllerService::do (line 538)
9	ContainerGErMxM3\App_KernelDevDebugContainer->load (line 220)
10	Symfony\Component\DependencyInjection\Container::make (line 202)
11	Symfony\Component\DependencyInjection\Container->get (line 38)
12	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 25)
13	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 127)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 95)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 33)
16	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 166)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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\Departamento	No errors.
App\Entity\Token	No errors.
App\Entity\Proceso	No errors.
App\Entity\Viaje	No errors.
App\Entity\Configuracion	No errors.

Symfony Profiler

GET https://pre.people.betandeal.com/

Configuration Settings

Theme