| 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"
]
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;
|
| 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
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0;
|
| 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"
]
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';
|
| 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 = ?
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;
|
| 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 = ?
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;
|
| 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 600;
|