Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

7.17 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.58 ms
(77.79%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.imagen AS imagen_6, t0.activo AS activo_7, t0.verified AS verified_8, t0.conformidad AS conformidad_9, t10.id AS id_11, t10.email_personal AS email_personal_12, t10.telefono AS telefono_13, t10.movil AS movil_14, t10.direccion AS direccion_15, t10.poblacion AS poblacion_16, t10.codigo_postal AS codigo_postal_17, t10.provincia AS provincia_18, t10.apellidos AS apellidos_19, t10.fecha_antiguedad AS fecha_antiguedad_20, t10.fecha_baja AS fecha_baja_21, t10.fecha_nacimiento AS fecha_nacimiento_22, t10.horas_contrato AS horas_contrato_23, t10.nacionalidad AS nacionalidad_24, t10.nif AS nif_25, t10.nivel_formativo AS nivel_formativo_26, t10.n_hijos AS n_hijos_27, t10.seguridad_social AS seguridad_social_28, t10.sexo AS sexo_29, t10.vehiculo AS vehiculo_30, t10.tipo_contrato AS tipo_contrato_31, t10.carnet AS carnet_32, t10.zona_trabajo AS zona_trabajo_33, t10.dni_delantero AS dni_delantero_34, t10.dni_trasero AS dni_trasero_35, t10.nombre_contacto AS nombre_contacto_36, t10.telefono_contacto AS telefono_contacto_37, t10.user_id AS user_id_38, t10.informacion_bancaria_id AS informacion_bancaria_id_39, t10.estado_empleado_id AS estado_empleado_id_40, t0.modalidad_ausencia_id AS modalidad_ausencia_id_41 FROM `user` t0 LEFT JOIN user_datos_contacto t10 ON t10.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  304
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nombre AS nombre_5,
  t0.imagen AS imagen_6,
  t0.activo AS activo_7,
  t0.verified AS verified_8,
  t0.conformidad AS conformidad_9,
  t10.id AS id_11,
  t10.email_personal AS email_personal_12,
  t10.telefono AS telefono_13,
  t10.movil AS movil_14,
  t10.direccion AS direccion_15,
  t10.poblacion AS poblacion_16,
  t10.codigo_postal AS codigo_postal_17,
  t10.provincia AS provincia_18,
  t10.apellidos AS apellidos_19,
  t10.fecha_antiguedad AS fecha_antiguedad_20,
  t10.fecha_baja AS fecha_baja_21,
  t10.fecha_nacimiento AS fecha_nacimiento_22,
  t10.horas_contrato AS horas_contrato_23,
  t10.nacionalidad AS nacionalidad_24,
  t10.nif AS nif_25,
  t10.nivel_formativo AS nivel_formativo_26,
  t10.n_hijos AS n_hijos_27,
  t10.seguridad_social AS seguridad_social_28,
  t10.sexo AS sexo_29,
  t10.vehiculo AS vehiculo_30,
  t10.tipo_contrato AS tipo_contrato_31,
  t10.carnet AS carnet_32,
  t10.zona_trabajo AS zona_trabajo_33,
  t10.dni_delantero AS dni_delantero_34,
  t10.dni_trasero AS dni_trasero_35,
  t10.nombre_contacto AS nombre_contacto_36,
  t10.telefono_contacto AS telefono_contacto_37,
  t10.user_id AS user_id_38,
  t10.informacion_bancaria_id AS informacion_bancaria_id_39,
  t10.estado_empleado_id AS estado_empleado_id_40,
  t0.modalidad_ausencia_id AS modalidad_ausencia_id_41
FROM
  `user` t0
  LEFT JOIN user_datos_contacto t10 ON t10.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.imagen AS imagen_6, t0.activo AS activo_7, t0.verified AS verified_8, t0.conformidad AS conformidad_9, t10.id AS id_11, t10.email_personal AS email_personal_12, t10.telefono AS telefono_13, t10.movil AS movil_14, t10.direccion AS direccion_15, t10.poblacion AS poblacion_16, t10.codigo_postal AS codigo_postal_17, t10.provincia AS provincia_18, t10.apellidos AS apellidos_19, t10.fecha_antiguedad AS fecha_antiguedad_20, t10.fecha_baja AS fecha_baja_21, t10.fecha_nacimiento AS fecha_nacimiento_22, t10.horas_contrato AS horas_contrato_23, t10.nacionalidad AS nacionalidad_24, t10.nif AS nif_25, t10.nivel_formativo AS nivel_formativo_26, t10.n_hijos AS n_hijos_27, t10.seguridad_social AS seguridad_social_28, t10.sexo AS sexo_29, t10.vehiculo AS vehiculo_30, t10.tipo_contrato AS tipo_contrato_31, t10.carnet AS carnet_32, t10.zona_trabajo AS zona_trabajo_33, t10.dni_delantero AS dni_delantero_34, t10.dni_trasero AS dni_trasero_35, t10.nombre_contacto AS nombre_contacto_36, t10.telefono_contacto AS telefono_contacto_37, t10.user_id AS user_id_38, t10.informacion_bancaria_id AS informacion_bancaria_id_39, t10.estado_empleado_id AS estado_empleado_id_40, t0.modalidad_ausencia_id AS modalidad_ausencia_id_41 FROM `user` t0 LEFT JOIN user_datos_contacto t10 ON t10.user_id = t0.id WHERE t0.id = 304;

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

0.86 ms
(12.03%)

SELECT t0.id AS id_1, t0.fecha_entrada AS fecha_entrada_2, t0.fecha_salida AS fecha_salida_3, t0.aceptada AS aceptada_4, t0.comentarios AS comentarios_5, t0.user_id AS user_id_6 FROM jornada t0 WHERE t0.user_id = ?

Parameters:

[
  304
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fecha_entrada AS fecha_entrada_2,
  t0.fecha_salida AS fecha_salida_3,
  t0.aceptada AS aceptada_4,
  t0.comentarios AS comentarios_5,
  t0.user_id AS user_id_6
FROM
  jornada t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.fecha_entrada AS fecha_entrada_2, t0.fecha_salida AS fecha_salida_3, t0.aceptada AS aceptada_4, t0.comentarios AS comentarios_5, t0.user_id AS user_id_6 FROM jornada t0 WHERE t0.user_id = 304;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Service\JornadaService->obtenerJornadasUser (line 33)
4	App\Service\AgendaService->obtenerTodasLasJornadasDelUsuario (line 185)
5	App\Controller\FicharController->app_ajax_control_ficha_load (line 100)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.73 ms
(10.18%)

SELECT t0.id AS id_1, t0.documento AS documento_2, t0.firmado AS firmado_3, t0.user_datos_contacto_id AS user_datos_contacto_id_4 FROM modelo145 t0 WHERE t0.user_datos_contacto_id = ?

Parameters:

[
  294
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.documento AS documento_2,
  t0.firmado AS firmado_3,
  t0.user_datos_contacto_id AS user_datos_contacto_id_4
FROM
  modelo145 t0
WHERE
  t0.user_datos_contacto_id = ?

SELECT t0.id AS id_1, t0.documento AS documento_2, t0.firmado AS firmado_3, t0.user_datos_contacto_id AS user_datos_contacto_id_4 FROM modelo145 t0 WHERE t0.user_datos_contacto_id = 294;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 876)
3	Doctrine\ORM\UnitOfWork->createEntity (line 3038)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 449)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 149)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 276)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 787)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
10	Doctrine\ORM\EntityManager->find (line 530)
11	Doctrine\ORM\EntityRepository->find (line 196)
12	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
13	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
14	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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\Jornada	8
App\Entity\User	1
App\Entity\UserDatosContacto	1
App\Entity\TipoEstado	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserDatosContacto	No errors.
App\Entity\InformacionBancaria	No errors.
App\Entity\TipoEstado	No errors.
App\Entity\ModalidadAusencia	No errors.
App\Entity\AbstractAgenda	No errors.
App\Entity\Ausencia	No errors.
App\Entity\Documento	No errors.
App\Entity\Horario	No errors.
App\Entity\Anuncio	No errors.
App\Entity\Centro	No errors.
App\Entity\Album	No errors.
App\Entity\Jornada	No errors.
App\Entity\UserNotificaciones	No errors.
App\Entity\Solicitudes	No errors.
App\Entity\Isla	No errors.
App\Entity\Formacion	No errors.
App\Entity\Modelo145	No errors.

Symfony Profiler

POST https://intranet.formasnivaria.es/gestion/control/ficha/load/ajax

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping