Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.78 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.29 ms
(72.36%)

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.fecha_salida AS fecha_salida_19, t0.dias_vacaciones_pendientes AS dias_vacaciones_pendientes_20, t0.borrado AS borrado_21, t0.personaltoken AS personaltoken_22, t0.password AS password_23, t0.login_admin AS login_admin_24, t0.cuenta_bancaria AS cuenta_bancaria_25, t0.entidad_bancaria AS entidad_bancaria_26, t0.direccion_bancaria AS direccion_bancaria_27, t0.oficina_bancaria AS oficina_bancaria_28, t0.localidad_bancaria AS localidad_bancaria_29, t0.provincia_bancaria AS provincia_bancaria_30, t0.pais_bancario AS pais_bancario_31, t0.motivo_baja AS motivo_baja_32, t0.dias_vacaciones_disfrutados AS dias_vacaciones_disfrutados_33, t0.dias_vacaciones_solicitados AS dias_vacaciones_solicitados_34, t0.seed AS seed_35, t0.direccion AS direccion_36, t0.contacto_emergencia_nombre AS contacto_emergencia_nombre_37, t0.contacto_emergencia_direccion AS contacto_emergencia_direccion_38, t0.contacto_emergencia_telefono AS contacto_emergencia_telefono_39, t0.contacto_emergencia_correo AS contacto_emergencia_correo_40, t0.contacto_emergencia_relacion AS contacto_emergencia_relacion_41, t0.dia_teletrabajo AS dia_teletrabajo_42, t0.fondo_formacion AS fondo_formacion_43, t0.teletrabajo_multi_dia AS teletrabajo_multi_dia_44, t0.dias_pendientes_ano_pasado AS dias_pendientes_ano_pasado_45, t0.dias_solicitados_ano_pasado AS dias_solicitados_ano_pasado_46, t0.dias_disfrutados_ano_pasado AS dias_disfrutados_ano_pasado_47, t0.departamento_id AS departamento_id_48, t0.id_responsable_id AS id_responsable_id_49, t0.admintoken_id AS admintoken_id_50, t0.proceso_edicion_id AS proceso_edicion_id_51, t0.viaje_aacompanante_id AS viaje_aacompanante_id_52 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.fecha_salida AS fecha_salida_19,
  t0.dias_vacaciones_pendientes AS dias_vacaciones_pendientes_20,
  t0.borrado AS borrado_21,
  t0.personaltoken AS personaltoken_22,
  t0.password AS password_23,
  t0.login_admin AS login_admin_24,
  t0.cuenta_bancaria AS cuenta_bancaria_25,
  t0.entidad_bancaria AS entidad_bancaria_26,
  t0.direccion_bancaria AS direccion_bancaria_27,
  t0.oficina_bancaria AS oficina_bancaria_28,
  t0.localidad_bancaria AS localidad_bancaria_29,
  t0.provincia_bancaria AS provincia_bancaria_30,
  t0.pais_bancario AS pais_bancario_31,
  t0.motivo_baja AS motivo_baja_32,
  t0.dias_vacaciones_disfrutados AS dias_vacaciones_disfrutados_33,
  t0.dias_vacaciones_solicitados AS dias_vacaciones_solicitados_34,
  t0.seed AS seed_35,
  t0.direccion AS direccion_36,
  t0.contacto_emergencia_nombre AS contacto_emergencia_nombre_37,
  t0.contacto_emergencia_direccion AS contacto_emergencia_direccion_38,
  t0.contacto_emergencia_telefono AS contacto_emergencia_telefono_39,
  t0.contacto_emergencia_correo AS contacto_emergencia_correo_40,
  t0.contacto_emergencia_relacion AS contacto_emergencia_relacion_41,
  t0.dia_teletrabajo AS dia_teletrabajo_42,
  t0.fondo_formacion AS fondo_formacion_43,
  t0.teletrabajo_multi_dia AS teletrabajo_multi_dia_44,
  t0.dias_pendientes_ano_pasado AS dias_pendientes_ano_pasado_45,
  t0.dias_solicitados_ano_pasado AS dias_solicitados_ano_pasado_46,
  t0.dias_disfrutados_ano_pasado AS dias_disfrutados_ano_pasado_47,
  t0.departamento_id AS departamento_id_48,
  t0.id_responsable_id AS id_responsable_id_49,
  t0.admintoken_id AS admintoken_id_50,
  t0.proceso_edicion_id AS proceso_edicion_id_51,
  t0.viaje_aacompanante_id AS viaje_aacompanante_id_52
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.fecha_salida AS fecha_salida_19, t0.dias_vacaciones_pendientes AS dias_vacaciones_pendientes_20, t0.borrado AS borrado_21, t0.personaltoken AS personaltoken_22, t0.password AS password_23, t0.login_admin AS login_admin_24, t0.cuenta_bancaria AS cuenta_bancaria_25, t0.entidad_bancaria AS entidad_bancaria_26, t0.direccion_bancaria AS direccion_bancaria_27, t0.oficina_bancaria AS oficina_bancaria_28, t0.localidad_bancaria AS localidad_bancaria_29, t0.provincia_bancaria AS provincia_bancaria_30, t0.pais_bancario AS pais_bancario_31, t0.motivo_baja AS motivo_baja_32, t0.dias_vacaciones_disfrutados AS dias_vacaciones_disfrutados_33, t0.dias_vacaciones_solicitados AS dias_vacaciones_solicitados_34, t0.seed AS seed_35, t0.direccion AS direccion_36, t0.contacto_emergencia_nombre AS contacto_emergencia_nombre_37, t0.contacto_emergencia_direccion AS contacto_emergencia_direccion_38, t0.contacto_emergencia_telefono AS contacto_emergencia_telefono_39, t0.contacto_emergencia_correo AS contacto_emergencia_correo_40, t0.contacto_emergencia_relacion AS contacto_emergencia_relacion_41, t0.dia_teletrabajo AS dia_teletrabajo_42, t0.fondo_formacion AS fondo_formacion_43, t0.teletrabajo_multi_dia AS teletrabajo_multi_dia_44, t0.dias_pendientes_ano_pasado AS dias_pendientes_ano_pasado_45, t0.dias_solicitados_ano_pasado AS dias_solicitados_ano_pasado_46, t0.dias_disfrutados_ano_pasado AS dias_disfrutados_ano_pasado_47, t0.departamento_id AS departamento_id_48, t0.id_responsable_id AS id_responsable_id_49, t0.admintoken_id AS admintoken_id_50, t0.proceso_edicion_id AS proceso_edicion_id_51, t0.viaje_aacompanante_id AS viaje_aacompanante_id_52 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
(27.64%)

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 36)
7	App\Controller\MainController->__construct (line 24)
8	ContainerR3OpMbQ\getMainControllerService::do (line 531)
9	ContainerR3OpMbQ\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