Symfony Profiler

Query Metrics

35 Database Queries

5 Different statements

13.71 ms Query time

0 Invalid entities

77 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.12 ms
(37.31%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.latitud AS latitud_3, t0.longitud AS longitud_4, t0.cupo AS cupo_5 FROM taller t0 WHERE t0.id = ?

Parameters:

[
  599
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.latitud AS latitud_3,
  t0.longitud AS longitud_4,
  t0.cupo AS cupo_5
FROM
  taller t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.latitud AS latitud_3, t0.longitud AS longitud_4, t0.cupo AS cupo_5 FROM taller t0 WHERE t0.id = 599;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Taller::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Taller->__get (line 184)
7	App\Entity\Taller->getFabricaciones (line 94)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_dba95253e1148952a448826826d0176d::doDisplay (line 49)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_8b9bd51a0f46b0889a43275aafdf4353->doDisplay (line 107)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_98092491e063f75ea907aa96b6dd36fc->block_contenido (line 122)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_f7b7ed1827786b0f1cc55a2cff80ca11->block_body (line 335)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_f7b7ed1827786b0f1cc55a2cff80ca11->doDisplay (line 147)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_98092491e063f75ea907aa96b6dd36fc->doDisplay (line 54)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
28	App\Controller\AuditoriaController->index (line 41)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 208)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

5.06 ms
(36.93%)

SELECT t0.id AS id_1, t0.fecha_pyme AS fecha_pyme_2, t0.cantidad AS cantidad_3, t0.articulo AS articulo_4, t0.id_agenda AS id_agenda_5, t0.nota AS nota_6, t0.fase AS fase_7, t0.taller_id AS taller_id_8 FROM fabricacion t0 WHERE t0.taller_id = ?

Parameters:

[
  599
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fecha_pyme AS fecha_pyme_2,
  t0.cantidad AS cantidad_3,
  t0.articulo AS articulo_4,
  t0.id_agenda AS id_agenda_5,
  t0.nota AS nota_6,
  t0.fase AS fase_7,
  t0.taller_id AS taller_id_8
FROM
  fabricacion t0
WHERE
  t0.taller_id = ?

SELECT t0.id AS id_1, t0.fecha_pyme AS fecha_pyme_2, t0.cantidad AS cantidad_3, t0.articulo AS articulo_4, t0.id_agenda AS id_agenda_5, t0.nota AS nota_6, t0.fase AS fase_7, t0.taller_id AS taller_id_8 FROM fabricacion t0 WHERE t0.taller_id = 599;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_dba95253e1148952a448826826d0176d->doDisplay (line 50)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_8b9bd51a0f46b0889a43275aafdf4353->doDisplay (line 107)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_98092491e063f75ea907aa96b6dd36fc->block_contenido (line 122)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_f7b7ed1827786b0f1cc55a2cff80ca11->block_body (line 335)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_f7b7ed1827786b0f1cc55a2cff80ca11->doDisplay (line 147)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_98092491e063f75ea907aa96b6dd36fc->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
26	App\Controller\AuditoriaController->index (line 41)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 208)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

2.34 ms
(17.07%)

SELECT f0_.id AS id_0, f0_.fecha_pyme AS fecha_pyme_1, f0_.cantidad AS cantidad_2, f0_.articulo AS articulo_3, f0_.id_agenda AS id_agenda_4, f0_.nota AS nota_5, f0_.fase AS fase_6, t1_.id AS id_7, t1_.nombre AS nombre_8, SUM(f0_.cantidad) AS sclr_9, f0_.taller_id AS taller_id_10 FROM fabricacion f0_ INNER JOIN taller t1_ ON f0_.taller_id = t1_.id WHERE (NOT EXISTS (SELECT 1 AS sclr_11 FROM auditoria a2_ WHERE a2_.taller_id = t1_.id AND a2_.fecha_asignada BETWEEN ? AND ?)) AND f0_.fase <> ? GROUP BY t1_.id ORDER BY t1_.nombre ASC

Parameters:

[
  "2026-02-13 00:00:00"
  "2026-02-13 23:59:59"
  "REVISION INTERNA"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.fecha_pyme AS fecha_pyme_1,
  f0_.cantidad AS cantidad_2,
  f0_.articulo AS articulo_3,
  f0_.id_agenda AS id_agenda_4,
  f0_.nota AS nota_5,
  f0_.fase AS fase_6,
  t1_.id AS id_7,
  t1_.nombre AS nombre_8,
  SUM(f0_.cantidad) AS sclr_9,
  f0_.taller_id AS taller_id_10
FROM
  fabricacion f0_
  INNER JOIN taller t1_ ON f0_.taller_id = t1_.id
WHERE
  (
    NOT EXISTS (
      SELECT
        1 AS sclr_11
      FROM
        auditoria a2_
      WHERE
        a2_.taller_id = t1_.id
        AND a2_.fecha_asignada BETWEEN ?
        AND ?
    )
  )
  AND f0_.fase <> ?
GROUP BY
  t1_.id
ORDER BY
  t1_.nombre ASC

SELECT f0_.id AS id_0, f0_.fecha_pyme AS fecha_pyme_1, f0_.cantidad AS cantidad_2, f0_.articulo AS articulo_3, f0_.id_agenda AS id_agenda_4, f0_.nota AS nota_5, f0_.fase AS fase_6, t1_.id AS id_7, t1_.nombre AS nombre_8, SUM(f0_.cantidad) AS sclr_9, f0_.taller_id AS taller_id_10 FROM fabricacion f0_ INNER JOIN taller t1_ ON f0_.taller_id = t1_.id WHERE (NOT EXISTS (SELECT 1 AS sclr_11 FROM auditoria a2_ WHERE a2_.taller_id = t1_.id AND a2_.fecha_asignada BETWEEN '2026-02-13 00:00:00' AND '2026-02-13 23:59:59')) AND f0_.fase <> 'REVISION INTERNA' GROUP BY t1_.id ORDER BY t1_.nombre ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\FabricacionRepository->findTalleresUnassigned (line 54)
7	App\Controller\AuditoriaController->getUnassignedTalleres (line 158)
8	App\Controller\AuditoriaController->index (line 34)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.82 ms
(5.99%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\AuditoriaController->index (line 35)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 208)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.37 ms
(2.70%)

SELECT a0_.id AS id_0, a0_.fecha_asignada AS fecha_asignada_1, a0_.tipo AS tipo_2, a0_.estado AS estado_3, a0_.taller_id AS taller_id_4, a0_.fabricacion_id AS fabricacion_id_5, a0_.auditor_id AS auditor_id_6 FROM auditoria a0_ WHERE (a0_.fecha_asignada BETWEEN ? AND ?) AND a0_.tipo = ?

Parameters:

[
  "2026-02-13 00:00:00"
  "2026-02-13 23:59:59"
  "EXTERNA"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.fecha_asignada AS fecha_asignada_1,
  a0_.tipo AS tipo_2,
  a0_.estado AS estado_3,
  a0_.taller_id AS taller_id_4,
  a0_.fabricacion_id AS fabricacion_id_5,
  a0_.auditor_id AS auditor_id_6
FROM
  auditoria a0_
WHERE
  (
    a0_.fecha_asignada BETWEEN ?
    AND ?
  )
  AND a0_.tipo = ?

SELECT a0_.id AS id_0, a0_.fecha_asignada AS fecha_asignada_1, a0_.tipo AS tipo_2, a0_.estado AS estado_3, a0_.taller_id AS taller_id_4, a0_.fabricacion_id AS fabricacion_id_5, a0_.auditor_id AS auditor_id_6 FROM auditoria a0_ WHERE (a0_.fecha_asignada BETWEEN '2026-02-13 00:00:00' AND '2026-02-13 23:59:59') AND a0_.tipo = 'EXTERNA';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\AuditoriaRepository->findAuditorias (line 31)
7	App\Controller\AuditoriaController->index (line 36)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	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\Fabricacion	57
App\Entity\Taller	16
App\Entity\User	4

Entities Mapping

Class	Mapping errors
App\Entity\Fabricacion	No errors.
App\Entity\Taller	No errors.
App\Entity\Auditoria	No errors.
App\Entity\AuditoriaDetalle	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://appapi.lujanes21.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping