Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

2.40 ms Query time

0 Invalid entities

10 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.03 ms

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, f0_.taller_id AS taller_id_7 FROM fabricacion f0_ WHERE (NOT EXISTS (SELECT 1 AS sclr_8 FROM auditoria a1_ WHERE a1_.fabricacion_id = f0_.id AND a1_.fecha_asignada BETWEEN ? AND ?)) AND f0_.fase = ? ORDER BY f0_.articulo 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,
  f0_.taller_id AS taller_id_7
FROM
  fabricacion f0_
WHERE
  (
    NOT EXISTS (
      SELECT
        1 AS sclr_8
      FROM
        auditoria a1_
      WHERE
        a1_.fabricacion_id = f0_.id
        AND a1_.fecha_asignada BETWEEN ?
        AND ?
    )
  )
  AND f0_.fase = ?
ORDER BY
  f0_.articulo 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, f0_.taller_id AS taller_id_7 FROM fabricacion f0_ WHERE (NOT EXISTS (SELECT 1 AS sclr_8 FROM auditoria a1_ WHERE a1_.fabricacion_id = f0_.id AND a1_.fecha_asignada BETWEEN '2026-02-13 00:00:00' AND '2026-02-13 23:59:59')) AND f0_.fase = 'REVISION INTERNA' ORDER BY f0_.articulo 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->findFabricacionesUnassigned (line 73)
7	App\Controller\AuditoriaController->getUnassignedFabricaciones (line 167)
8	App\Controller\AuditoriaController->indexInterno (line 55)
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.64 ms

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, f0_.taller_id AS taller_id_7 FROM fabricacion f0_ WHERE (NOT EXISTS (SELECT 1 AS sclr_8 FROM auditoria a1_ WHERE a1_.fabricacion_id = f0_.id AND a1_.fecha_asignada BETWEEN ? AND ?)) AND f0_.fase = ? ORDER BY f0_.articulo 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,
  f0_.taller_id AS taller_id_7
FROM
  fabricacion f0_
WHERE
  (
    NOT EXISTS (
      SELECT
        1 AS sclr_8
      FROM
        auditoria a1_
      WHERE
        a1_.fabricacion_id = f0_.id
        AND a1_.fecha_asignada BETWEEN ?
        AND ?
    )
  )
  AND f0_.fase = ?
ORDER BY
  f0_.articulo 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, f0_.taller_id AS taller_id_7 FROM fabricacion f0_ WHERE (NOT EXISTS (SELECT 1 AS sclr_8 FROM auditoria a1_ WHERE a1_.fabricacion_id = f0_.id AND a1_.fecha_asignada BETWEEN '2026-02-13 00:00:00' AND '2026-02-13 23:59:59')) AND f0_.fase = 'REVISION INTERNA' ORDER BY f0_.articulo 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->findFabricacionesUnassigned (line 74)
7	App\Controller\AuditoriaController->getUnassignedFabricaciones (line 167)
8	App\Controller\AuditoriaController->indexInterno (line 55)
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.44 ms

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->indexInterno (line 56)
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.29 ms

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"
  "INTERNA"
]

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 = 'INTERNA';

#	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->findAuditoriasInternas (line 45)
7	App\Controller\AuditoriaController->indexInterno (line 57)
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\User	4
App\Entity\Fabricacion	3
App\Entity\Taller	3

Entities Mapping

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

Symfony Profiler

GET https://appapi.lujanes21.com/internos

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping