GET https://appapi.lujanes21.com/

Query Metrics

35 Database Queries
5 Different statements
13.71 ms Query time
0 Invalid entities
77 Managed entities

Queries

Group similar statements

# Time Info
1 2.34 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, 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"
]
2 0.82 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:
[]
3 0.37 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"
  "EXTERNA"
]
4 0.86 ms
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
]
5 0.57 ms
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
]
6 0.34 ms
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:
[
  482
]
7 0.38 ms
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:
[
  482
]
8 0.31 ms
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:
[
  578
]
9 0.27 ms
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:
[
  578
]
10 0.29 ms
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:
[
  271
]
11 0.36 ms
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:
[
  271
]
12 0.32 ms
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:
[
  1
]
13 0.32 ms
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:
[
  1
]
14 0.26 ms
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:
[
  614
]
15 0.32 ms
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:
[
  614
]
16 0.26 ms
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:
[
  362
]
17 0.30 ms
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:
[
  362
]
18 0.26 ms
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:
[
  330
]
19 0.25 ms
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:
[
  330
]
20 0.25 ms
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:
[
  603
]
21 0.36 ms
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:
[
  603
]
22 0.20 ms
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:
[
  299
]
23 0.25 ms
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:
[
  299
]
24 0.32 ms
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:
[
  616
]
25 0.28 ms
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:
[
  616
]
26 0.28 ms
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:
[
  623
]
27 0.31 ms
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:
[
  623
]
28 0.25 ms
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:
[
  263
]
29 0.30 ms
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:
[
  263
]
30 0.30 ms
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:
[
  291
]
31 0.27 ms
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:
[
  291
]
32 0.30 ms
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:
[
  579
]
33 0.30 ms
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:
[
  579
]
34 0.31 ms
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:
[
  600
]
35 0.24 ms
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:
[
  600
]

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.