Symfony Profiler

Query Metrics

20 Database Queries

12 Different statements

6.83 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.85 ms
(12.51%)

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.hora_inicio AS hora_inicio_3, t0.hora_fin AS hora_fin_4, t0.obs AS obs_5, t0.activo AS activo_6, t0.tiempo_total AS tiempo_total_7, t0.compartida AS compartida_8, t0.confirmada AS confirmada_9, t0.borrado AS borrado_10, t0.usuario_id AS usuario_id_11, t0.empresa_id AS empresa_id_12, t0.sector_id AS sector_id_13, t0.cliente_id AS cliente_id_14, t0.tarea_id AS tarea_id_15, t0.tiempo_padre_id AS tiempo_padre_id_16, t0.carga_rapida_id AS carga_rapida_id_17, t0.puesto_id AS puesto_id_18 FROM tiempo t0 WHERE t0.usuario_id = ? AND t0.fecha = ? AND t0.activo = ? AND t0.confirmada = ? ORDER BY t0.fecha DESC, t0.hora_inicio DESC

Parameters:

[
  61
  "2026-08-25"
  0
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.hora_inicio AS hora_inicio_3,
  t0.hora_fin AS hora_fin_4,
  t0.obs AS obs_5,
  t0.activo AS activo_6,
  t0.tiempo_total AS tiempo_total_7,
  t0.compartida AS compartida_8,
  t0.confirmada AS confirmada_9,
  t0.borrado AS borrado_10,
  t0.usuario_id AS usuario_id_11,
  t0.empresa_id AS empresa_id_12,
  t0.sector_id AS sector_id_13,
  t0.cliente_id AS cliente_id_14,
  t0.tarea_id AS tarea_id_15,
  t0.tiempo_padre_id AS tiempo_padre_id_16,
  t0.carga_rapida_id AS carga_rapida_id_17,
  t0.puesto_id AS puesto_id_18
FROM
  tiempo t0
WHERE
  t0.usuario_id = ?
  AND t0.fecha = ?
  AND t0.activo = ?
  AND t0.confirmada = ?
ORDER BY
  t0.fecha DESC,
  t0.hora_inicio DESC

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.hora_inicio AS hora_inicio_3, t0.hora_fin AS hora_fin_4, t0.obs AS obs_5, t0.activo AS activo_6, t0.tiempo_total AS tiempo_total_7, t0.compartida AS compartida_8, t0.confirmada AS confirmada_9, t0.borrado AS borrado_10, t0.usuario_id AS usuario_id_11, t0.empresa_id AS empresa_id_12, t0.sector_id AS sector_id_13, t0.cliente_id AS cliente_id_14, t0.tarea_id AS tarea_id_15, t0.tiempo_padre_id AS tiempo_padre_id_16, t0.carga_rapida_id AS carga_rapida_id_17, t0.puesto_id AS puesto_id_18 FROM tiempo t0 WHERE t0.usuario_id = 61 AND t0.fecha = '2026-08-25' AND t0.activo = 0 AND t0.confirmada = 1 ORDER BY t0.fecha DESC, t0.hora_inicio DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 66)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 88)
5	App\Controller\TiempoController->mishorasPorDia (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.82 ms
(12.06%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.borrado AS borrado_3, t0.tarea_id AS tarea_id_4 FROM sub_tarea t0 INNER JOIN carga_rapida_sub_tarea ON t0.id = carga_rapida_sub_tarea.sub_tarea_id WHERE carga_rapida_sub_tarea.carga_rapida_id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.borrado AS borrado_3,
  t0.tarea_id AS tarea_id_4
FROM
  sub_tarea t0
  INNER JOIN carga_rapida_sub_tarea ON t0.id = carga_rapida_sub_tarea.sub_tarea_id
WHERE
  carga_rapida_sub_tarea.carga_rapida_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.borrado AS borrado_3, t0.tarea_id AS tarea_id_4 FROM sub_tarea t0 INNER JOIN carga_rapida_sub_tarea ON t0.id = carga_rapida_sub_tarea.sub_tarea_id WHERE carga_rapida_sub_tarea.carga_rapida_id = 12;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1047)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 976)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2703)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 620)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 184)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 394)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 556)
10	__TwigTemplate_e6e9af52042b0294290f186746440b36->block_body (line 171)
11	Twig\Template->displayBlock (line 258)
12	__TwigTemplate_99f52d63c15a42c5d52c65354a0a4512->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 49)
15	__TwigTemplate_e6e9af52042b0294290f186746440b36->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 482)
24	App\Controller\TiempoController->mishorasPorDia (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.78 ms
(11.34%)

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.estado AS estado_3, t0.usuario_id AS usuario_id_4, t0.cliente_id AS cliente_id_5, t0.tarea_id AS tarea_id_6 FROM carga_rapida t0 WHERE t0.usuario_id = ? AND t0.numero = ? LIMIT 1

Parameters:

[
  61
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.numero AS numero_2,
  t0.estado AS estado_3,
  t0.usuario_id AS usuario_id_4,
  t0.cliente_id AS cliente_id_5,
  t0.tarea_id AS tarea_id_6
FROM
  carga_rapida t0
WHERE
  t0.usuario_id = ?
  AND t0.numero = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.numero AS numero_2, t0.estado AS estado_3, t0.usuario_id AS usuario_id_4, t0.cliente_id AS cliente_id_5, t0.tarea_id AS tarea_id_6 FROM carga_rapida t0 WHERE t0.usuario_id = 61 AND t0.numero = '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 395)
5	App\Controller\TiempoController->mishorasPorDia (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.76 ms
(11.12%)

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.hora_inicio AS hora_inicio_3, t0.hora_fin AS hora_fin_4, t0.obs AS obs_5, t0.activo AS activo_6, t0.tiempo_total AS tiempo_total_7, t0.compartida AS compartida_8, t0.confirmada AS confirmada_9, t0.borrado AS borrado_10, t0.usuario_id AS usuario_id_11, t0.empresa_id AS empresa_id_12, t0.sector_id AS sector_id_13, t0.cliente_id AS cliente_id_14, t0.tarea_id AS tarea_id_15, t0.tiempo_padre_id AS tiempo_padre_id_16, t0.carga_rapida_id AS carga_rapida_id_17, t0.puesto_id AS puesto_id_18 FROM tiempo t0 WHERE t0.usuario_id = ? AND t0.fecha = ? AND t0.activo = ? LIMIT 1

Parameters:

[
  61
  "2026-08-25"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.hora_inicio AS hora_inicio_3,
  t0.hora_fin AS hora_fin_4,
  t0.obs AS obs_5,
  t0.activo AS activo_6,
  t0.tiempo_total AS tiempo_total_7,
  t0.compartida AS compartida_8,
  t0.confirmada AS confirmada_9,
  t0.borrado AS borrado_10,
  t0.usuario_id AS usuario_id_11,
  t0.empresa_id AS empresa_id_12,
  t0.sector_id AS sector_id_13,
  t0.cliente_id AS cliente_id_14,
  t0.tarea_id AS tarea_id_15,
  t0.tiempo_padre_id AS tiempo_padre_id_16,
  t0.carga_rapida_id AS carga_rapida_id_17,
  t0.puesto_id AS puesto_id_18
FROM
  tiempo t0
WHERE
  t0.usuario_id = ?
  AND t0.fecha = ?
  AND t0.activo = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.hora_inicio AS hora_inicio_3, t0.hora_fin AS hora_fin_4, t0.obs AS obs_5, t0.activo AS activo_6, t0.tiempo_total AS tiempo_total_7, t0.compartida AS compartida_8, t0.confirmada AS confirmada_9, t0.borrado AS borrado_10, t0.usuario_id AS usuario_id_11, t0.empresa_id AS empresa_id_12, t0.sector_id AS sector_id_13, t0.cliente_id AS cliente_id_14, t0.tarea_id AS tarea_id_15, t0.tiempo_padre_id AS tiempo_padre_id_16, t0.carga_rapida_id AS carga_rapida_id_17, t0.puesto_id AS puesto_id_18 FROM tiempo t0 WHERE t0.usuario_id = 61 AND t0.fecha = '2026-08-25' 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 89)
5	App\Controller\TiempoController->mishorasPorDia (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.70 ms
(10.30%)

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.texto AS texto_3, t0.vista AS vista_4, t0.usuario_id AS usuario_id_5, t0.usuario_generado_id AS usuario_generado_id_6, t0.solicitud_id AS solicitud_id_7 FROM notificacion t0 WHERE (t0.vista = ? AND t0.usuario_id = ?) ORDER BY t0.fecha DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.texto AS texto_3,
  t0.vista AS vista_4,
  t0.usuario_id AS usuario_id_5,
  t0.usuario_generado_id AS usuario_generado_id_6,
  t0.solicitud_id AS solicitud_id_7
FROM
  notificacion t0
WHERE
  (
    t0.vista = ?
    AND t0.usuario_id = ?
  )
ORDER BY
  t0.fecha DESC

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.texto AS texto_3, t0.vista AS vista_4, t0.usuario_id AS usuario_id_5, t0.usuario_generado_id AS usuario_generado_id_6, t0.solicitud_id AS solicitud_id_7 FROM notificacion t0 WHERE (t0.vista = 0 AND t0.usuario_id = 61) ORDER BY t0.fecha DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 852)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCriteria (line 594)
3	Doctrine\ORM\PersistentCollection->matching (line 504)
4	App\Entity\Usuario->getNotificacionesNoLeidas (line 1635)
5	twig_get_attribute (line 53)
6	__TwigTemplate_34c0d9e6ac442908f3053b8a3f776b59->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 379)
9	Twig\Template->render (line 38)
10	Twig\TemplateWrapper->render (line 1347)
11	twig_include (line 179)
12	__TwigTemplate_99f52d63c15a42c5d52c65354a0a4512->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 49)
15	__TwigTemplate_e6e9af52042b0294290f186746440b36->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 482)
24	App\Controller\TiempoController->mishorasPorDia (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.70 ms
(10.27%)

SELECT t0_.id AS id_0, t0_.fecha AS fecha_1, t0_.hora_inicio AS hora_inicio_2, t0_.hora_fin AS hora_fin_3, t0_.obs AS obs_4, t0_.activo AS activo_5, t0_.tiempo_total AS tiempo_total_6, t0_.compartida AS compartida_7, t0_.confirmada AS confirmada_8, t0_.borrado AS borrado_9, t0_.usuario_id AS usuario_id_10, t0_.empresa_id AS empresa_id_11, t0_.sector_id AS sector_id_12, t0_.cliente_id AS cliente_id_13, t0_.tarea_id AS tarea_id_14, t0_.tiempo_padre_id AS tiempo_padre_id_15, t0_.carga_rapida_id AS carga_rapida_id_16, t0_.puesto_id AS puesto_id_17 FROM tiempo t0_ WHERE t0_.fecha < '2026-08-25' AND t0_.usuario_id = '61' AND t0_.activo = 1 AND t0_.confirmada = 1 AND t0_.borrado = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.fecha AS fecha_1,
  t0_.hora_inicio AS hora_inicio_2,
  t0_.hora_fin AS hora_fin_3,
  t0_.obs AS obs_4,
  t0_.activo AS activo_5,
  t0_.tiempo_total AS tiempo_total_6,
  t0_.compartida AS compartida_7,
  t0_.confirmada AS confirmada_8,
  t0_.borrado AS borrado_9,
  t0_.usuario_id AS usuario_id_10,
  t0_.empresa_id AS empresa_id_11,
  t0_.sector_id AS sector_id_12,
  t0_.cliente_id AS cliente_id_13,
  t0_.tarea_id AS tarea_id_14,
  t0_.tiempo_padre_id AS tiempo_padre_id_15,
  t0_.carga_rapida_id AS carga_rapida_id_16,
  t0_.puesto_id AS puesto_id_17
FROM
  tiempo t0_
WHERE
  t0_.fecha < '2026-08-25'
  AND t0_.usuario_id = '61'
  AND t0_.activo = 1
  AND t0_.confirmada = 1
  AND t0_.borrado = 0

SELECT t0_.id AS id_0, t0_.fecha AS fecha_1, t0_.hora_inicio AS hora_inicio_2, t0_.hora_fin AS hora_fin_3, t0_.obs AS obs_4, t0_.activo AS activo_5, t0_.tiempo_total AS tiempo_total_6, t0_.compartida AS compartida_7, t0_.confirmada AS confirmada_8, t0_.borrado AS borrado_9, t0_.usuario_id AS usuario_id_10, t0_.empresa_id AS empresa_id_11, t0_.sector_id AS sector_id_12, t0_.cliente_id AS cliente_id_13, t0_.tarea_id AS tarea_id_14, t0_.tiempo_padre_id AS tiempo_padre_id_15, t0_.carga_rapida_id AS carga_rapida_id_16, t0_.puesto_id AS puesto_id_17 FROM tiempo t0_ WHERE t0_.fecha < '2026-08-25' AND t0_.usuario_id = '61' AND t0_.activo = 1 AND t0_.confirmada = 1 AND t0_.borrado = 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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 123)
7	App\Repository\TiempoRepository->obtenerPorUsuarioActivasSinFinalizar (line 91)
8	App\Controller\TiempoController->mishorasPorDia (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.62 ms
(9.02%)

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.hora_inicio AS hora_inicio_3, t0.hora_fin AS hora_fin_4, t0.obs AS obs_5, t0.activo AS activo_6, t0.tiempo_total AS tiempo_total_7, t0.compartida AS compartida_8, t0.confirmada AS confirmada_9, t0.borrado AS borrado_10, t0.usuario_id AS usuario_id_11, t0.empresa_id AS empresa_id_12, t0.sector_id AS sector_id_13, t0.cliente_id AS cliente_id_14, t0.tarea_id AS tarea_id_15, t0.tiempo_padre_id AS tiempo_padre_id_16, t0.carga_rapida_id AS carga_rapida_id_17, t0.puesto_id AS puesto_id_18 FROM tiempo t0 WHERE t0.usuario_id = ? AND t0.confirmada = ? AND t0.borrado = ? AND t0.activo = ? ORDER BY t0.fecha DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.hora_inicio AS hora_inicio_3,
  t0.hora_fin AS hora_fin_4,
  t0.obs AS obs_5,
  t0.activo AS activo_6,
  t0.tiempo_total AS tiempo_total_7,
  t0.compartida AS compartida_8,
  t0.confirmada AS confirmada_9,
  t0.borrado AS borrado_10,
  t0.usuario_id AS usuario_id_11,
  t0.empresa_id AS empresa_id_12,
  t0.sector_id AS sector_id_13,
  t0.cliente_id AS cliente_id_14,
  t0.tarea_id AS tarea_id_15,
  t0.tiempo_padre_id AS tiempo_padre_id_16,
  t0.carga_rapida_id AS carga_rapida_id_17,
  t0.puesto_id AS puesto_id_18
FROM
  tiempo t0
WHERE
  t0.usuario_id = ?
  AND t0.confirmada = ?
  AND t0.borrado = ?
  AND t0.activo = ?
ORDER BY
  t0.fecha DESC

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.hora_inicio AS hora_inicio_3, t0.hora_fin AS hora_fin_4, t0.obs AS obs_5, t0.activo AS activo_6, t0.tiempo_total AS tiempo_total_7, t0.compartida AS compartida_8, t0.confirmada AS confirmada_9, t0.borrado AS borrado_10, t0.usuario_id AS usuario_id_11, t0.empresa_id AS empresa_id_12, t0.sector_id AS sector_id_13, t0.cliente_id AS cliente_id_14, t0.tarea_id AS tarea_id_15, t0.tiempo_padre_id AS tiempo_padre_id_16, t0.carga_rapida_id AS carga_rapida_id_17, t0.puesto_id AS puesto_id_18 FROM tiempo t0 WHERE t0.usuario_id = 61 AND t0.confirmada = 0 AND t0.borrado = 0 AND t0.activo = 0 ORDER BY t0.fecha DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 66)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 150)
5	App\Controller\TiempoController->mishorasPorDia (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.42 ms
(6.08%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.dni AS dni_4, t0.telefono AS telefono_5, t0.activo AS activo_6, t0.borrado AS borrado_7, t0.correo AS correo_8, t0.hash AS hash_9, t0.legajo AS legajo_10, t0.password AS password_11, t0.notificaciones_correo_activas AS notificaciones_correo_activas_12, t0.fecha_alta AS fecha_alta_13, t0.es_responsable_sector AS es_responsable_sector_14, t0.terminos_ycondiciones AS terminos_ycondiciones_15, t0.permiso_supervisor_todos AS permiso_supervisor_todos_16, t0.carga_rapida_tiempo AS carga_rapida_tiempo_17, t0.reset_password_code AS reset_password_code_18, t0.rol_id AS rol_id_19, t0.empresa_id AS empresa_id_20, t0.sector_id AS sector_id_21, t0.puesto_id AS puesto_id_22 FROM usuario t0 WHERE t0.id = ?

Parameters:

[
  61
]

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.dni AS dni_4,
  t0.telefono AS telefono_5,
  t0.activo AS activo_6,
  t0.borrado AS borrado_7,
  t0.correo AS correo_8,
  t0.hash AS hash_9,
  t0.legajo AS legajo_10,
  t0.password AS password_11,
  t0.notificaciones_correo_activas AS notificaciones_correo_activas_12,
  t0.fecha_alta AS fecha_alta_13,
  t0.es_responsable_sector AS es_responsable_sector_14,
  t0.terminos_ycondiciones AS terminos_ycondiciones_15,
  t0.permiso_supervisor_todos AS permiso_supervisor_todos_16,
  t0.carga_rapida_tiempo AS carga_rapida_tiempo_17,
  t0.reset_password_code AS reset_password_code_18,
  t0.rol_id AS rol_id_19,
  t0.empresa_id AS empresa_id_20,
  t0.sector_id AS sector_id_21,
  t0.puesto_id AS puesto_id_22
FROM
  usuario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.dni AS dni_4, t0.telefono AS telefono_5, t0.activo AS activo_6, t0.borrado AS borrado_7, t0.correo AS correo_8, t0.hash AS hash_9, t0.legajo AS legajo_10, t0.password AS password_11, t0.notificaciones_correo_activas AS notificaciones_correo_activas_12, t0.fecha_alta AS fecha_alta_13, t0.es_responsable_sector AS es_responsable_sector_14, t0.terminos_ycondiciones AS terminos_ycondiciones_15, t0.permiso_supervisor_todos AS permiso_supervisor_todos_16, t0.carga_rapida_tiempo AS carga_rapida_tiempo_17, t0.reset_password_code AS reset_password_code_18, t0.rol_id AS rol_id_19, t0.empresa_id AS empresa_id_20, t0.sector_id AS sector_id_21, t0.puesto_id AS puesto_id_22 FROM usuario t0 WHERE t0.id = 61;

#	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 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.36 ms
(5.24%)

SELECT t0_.id AS id_0, t0_.titulo AS titulo_1, t0_.descripcion AS descripcion_2, t0_.tiempo_asignado AS tiempo_asignado_3, t0_.tiempo_compartido AS tiempo_compartido_4, t0_.fecha_alta AS fecha_alta_5, t0_.permiso_todos AS permiso_todos_6, t0_.activa AS activa_7, t0_.tipo_tarea_id AS tipo_tarea_id_8, t0_.usuario_alta_id AS usuario_alta_id_9, t0_.empresa_id AS empresa_id_10 FROM tarea t0_ INNER JOIN tarea_usuario t2_ ON t0_.id = t2_.tarea_id INNER JOIN usuario u1_ ON u1_.id = t2_.usuario_id WHERE u1_.id = ? AND t0_.empresa_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.titulo AS titulo_1,
  t0_.descripcion AS descripcion_2,
  t0_.tiempo_asignado AS tiempo_asignado_3,
  t0_.tiempo_compartido AS tiempo_compartido_4,
  t0_.fecha_alta AS fecha_alta_5,
  t0_.permiso_todos AS permiso_todos_6,
  t0_.activa AS activa_7,
  t0_.tipo_tarea_id AS tipo_tarea_id_8,
  t0_.usuario_alta_id AS usuario_alta_id_9,
  t0_.empresa_id AS empresa_id_10
FROM
  tarea t0_
  INNER JOIN tarea_usuario t2_ ON t0_.id = t2_.tarea_id
  INNER JOIN usuario u1_ ON u1_.id = t2_.usuario_id
WHERE
  u1_.id = ?
  AND t0_.empresa_id = ?

SELECT t0_.id AS id_0, t0_.titulo AS titulo_1, t0_.descripcion AS descripcion_2, t0_.tiempo_asignado AS tiempo_asignado_3, t0_.tiempo_compartido AS tiempo_compartido_4, t0_.fecha_alta AS fecha_alta_5, t0_.permiso_todos AS permiso_todos_6, t0_.activa AS activa_7, t0_.tipo_tarea_id AS tipo_tarea_id_8, t0_.usuario_alta_id AS usuario_alta_id_9, t0_.empresa_id AS empresa_id_10 FROM tarea t0_ INNER JOIN tarea_usuario t2_ ON t0_.id = t2_.tarea_id INNER JOIN usuario u1_ ON u1_.id = t2_.usuario_id WHERE u1_.id = 61 AND t0_.empresa_id = 5;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\TareaRepository->findTareasByUsuario (line 149)
8	App\Controller\TiempoController->mishorasPorDia (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.28 ms
(4.11%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.dni AS dni_4, t0.telefono AS telefono_5, t0.activo AS activo_6, t0.borrado AS borrado_7, t0.correo AS correo_8, t0.hash AS hash_9, t0.legajo AS legajo_10, t0.password AS password_11, t0.notificaciones_correo_activas AS notificaciones_correo_activas_12, t0.fecha_alta AS fecha_alta_13, t0.es_responsable_sector AS es_responsable_sector_14, t0.terminos_ycondiciones AS terminos_ycondiciones_15, t0.permiso_supervisor_todos AS permiso_supervisor_todos_16, t0.carga_rapida_tiempo AS carga_rapida_tiempo_17, t0.reset_password_code AS reset_password_code_18, t0.rol_id AS rol_id_19, t0.empresa_id AS empresa_id_20, t0.sector_id AS sector_id_21, t0.puesto_id AS puesto_id_22 FROM usuario t0 WHERE t0.empresa_id = ? AND t0.borrado = ?

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.dni AS dni_4,
  t0.telefono AS telefono_5,
  t0.activo AS activo_6,
  t0.borrado AS borrado_7,
  t0.correo AS correo_8,
  t0.hash AS hash_9,
  t0.legajo AS legajo_10,
  t0.password AS password_11,
  t0.notificaciones_correo_activas AS notificaciones_correo_activas_12,
  t0.fecha_alta AS fecha_alta_13,
  t0.es_responsable_sector AS es_responsable_sector_14,
  t0.terminos_ycondiciones AS terminos_ycondiciones_15,
  t0.permiso_supervisor_todos AS permiso_supervisor_todos_16,
  t0.carga_rapida_tiempo AS carga_rapida_tiempo_17,
  t0.reset_password_code AS reset_password_code_18,
  t0.rol_id AS rol_id_19,
  t0.empresa_id AS empresa_id_20,
  t0.sector_id AS sector_id_21,
  t0.puesto_id AS puesto_id_22
FROM
  usuario t0
WHERE
  t0.empresa_id = ?
  AND t0.borrado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.dni AS dni_4, t0.telefono AS telefono_5, t0.activo AS activo_6, t0.borrado AS borrado_7, t0.correo AS correo_8, t0.hash AS hash_9, t0.legajo AS legajo_10, t0.password AS password_11, t0.notificaciones_correo_activas AS notificaciones_correo_activas_12, t0.fecha_alta AS fecha_alta_13, t0.es_responsable_sector AS es_responsable_sector_14, t0.terminos_ycondiciones AS terminos_ycondiciones_15, t0.permiso_supervisor_todos AS permiso_supervisor_todos_16, t0.carga_rapida_tiempo AS carga_rapida_tiempo_17, t0.reset_password_code AS reset_password_code_18, t0.rol_id AS rol_id_19, t0.empresa_id AS empresa_id_20, t0.sector_id AS sector_id_21, t0.puesto_id AS puesto_id_22 FROM usuario t0 WHERE t0.empresa_id = 5 AND t0.borrado = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 66)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 148)
5	App\Controller\TiempoController->mishorasPorDia (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.28 ms
(4.07%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.abreviatura AS abreviatura_4 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
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 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 120)
7	Proxies\__CG__\App\Entity\Rol->__get (line 42)
8	App\Entity\Rol->getNombre (line 71)
9	App\Entity\Rol->getCredencial (line 125)
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 60)
15	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.26 ms
(3.88%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.abrev AS abrev_3, t0.descripcion AS descripcion_4, t0.borrado AS borrado_5, t0.hash AS hash_6, t0.empresa_id AS empresa_id_7 FROM cliente t0 WHERE t0.empresa_id = ? AND t0.borrado = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.abrev AS abrev_3,
  t0.descripcion AS descripcion_4,
  t0.borrado AS borrado_5,
  t0.hash AS hash_6,
  t0.empresa_id AS empresa_id_7
FROM
  cliente t0
WHERE
  t0.empresa_id = ?
  AND t0.borrado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.abrev AS abrev_3, t0.descripcion AS descripcion_4, t0.borrado AS borrado_5, t0.hash AS hash_6, t0.empresa_id AS empresa_id_7 FROM cliente t0 WHERE t0.empresa_id = 5 AND t0.borrado = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 66)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 147)
5	App\Controller\TiempoController->mishorasPorDia (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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	The association App\Entity\Usuario#sector refers to the inverse side field App\Entity\Sector#responsable which does not exist.
App\Entity\Rol	No errors.
App\Entity\Empresa	The field App\Entity\Empresa#puestos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Puesto#empresa does not contain the required 'inversedBy="puestos"' attribute. The field App\Entity\Empresa#feriados is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Feriado#empresa does not contain the required 'inversedBy="feriados"' attribute. The field App\Entity\Empresa#clientes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cliente#empresa does not contain the required 'inversedBy="clientes"' attribute.
App\Entity\Sector	No errors.
App\Entity\Puesto	No errors.
App\Entity\UsuarioHorasPorPeriodo	No errors.
App\Entity\Notificacion	No errors.
App\Entity\Tiempo	No errors.
App\Entity\Cliente	No errors.
App\Entity\Tarea	No errors.
App\Entity\CargaRapida	No errors.
App\Entity\SubTarea	No errors.
App\Entity\TareaTipo	No errors.
App\Entity\SolicitudTarea	No errors.

Symfony Profiler

GET https://horas.tech/tiempo/2026-08-25/mishorasPorDia

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping