Query Metrics
7
Database Queries
7
Different statements
113.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
36.29 ms (32.00%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.active AS active_3 FROM mant_sector_planta t0 WHERE t0.nombre = ? LIMIT 2
Parameters:
[
"EVISCERADO"
]
|
|
29.32 ms (25.86%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.active AS active_3 FROM mant_sector_planta t0 INNER JOIN users_sectores_system ON t0.id = users_sectores_system.id_sector WHERE users_sectores_system.id_user = ?
Parameters:
[
8
]
|
|
24.44 ms (21.55%) |
1 |
SELECT m0_.fecha_carga AS fecha_carga_0, m0_.fecha_carga AS fecha_carga_1, m0_.detalle AS detalle_2, m1_.nombre AS nombre_3, m2_.nombre AS nombre_4 FROM mant_pedido_reparacion m0_ INNER JOIN mant_sector_planta m1_ ON m0_.id_sector = m1_.id LEFT JOIN mant_departamento m2_ ON m0_.id_depto = m2_.id WHERE m0_.realizada = ? AND m0_.diagramada = ? AND m0_.id_sector = ? AND m2_.id = ? AND DATE(m0_.fecha_carga) >= ? AND DATE(m0_.fecha_carga) <= ? ORDER BY m0_.realizada DESC, m0_.fecha_carga ASC, m1_.nombre ASC
Parameters:
[ 0 0 5 2 "2025-12-16 00:00:00" "2025-12-17 00:00:00" ] |
|
9.93 ms (8.76%) |
1 |
SELECT DISTINCT m0_.fecha_carga AS fecha_carga_0, m0_.realizada AS realizada_1, m0_.fecha_carga AS fecha_carga_2, m0_.detalle AS detalle_3, m1_.nombre AS nombre_4, d2_.fecha AS fecha_5, m3_.nombre AS nombre_6 FROM mant_pedido_reparacion m0_ INNER JOIN pedido_reparacion_diagramado p4_ ON m0_.id = p4_.id_pedido INNER JOIN diagrama_tarea d2_ ON p4_.id_diagrama = d2_.id INNER JOIN mant_sector_planta m1_ ON m0_.id_sector = m1_.id INNER JOIN mant_departamento m3_ ON m0_.id_depto = m3_.id WHERE m0_.id_sector = ? AND m3_.id = ? AND DATE(m0_.fecha_carga) >= ? AND DATE(m0_.fecha_carga) <= ? ORDER BY m0_.realizada DESC, m0_.fecha_carga ASC, m1_.nombre ASC
Parameters:
[ 5 2 "2025-12-16 00:00:00" "2025-12-17 00:00:00" ] |
|
5.76 ms (5.08%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3 FROM mant_departamento t0 WHERE t0.nombre = ? LIMIT 2
Parameters:
[
"Mecanica"
]
|
|
3.86 ms (3.40%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3 FROM mant_departamento t0 INNER JOIN users_departamentos_system ON t0.id = users_departamentos_system.id_departamento WHERE users_departamentos_system.id_user = ?
Parameters:
[
8
]
|
|
3.79 ms (3.34%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.id_default AS id_default_5 FROM users_system t0 WHERE t0.id = ?
Parameters:
[
8
]
|
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\User | No errors. |
| App\Entity\Almacen\Deposito | No errors. |
| App\Entity\Mantenimiento\SectorPlanta | No errors. |
| App\Entity\Mantenimiento\Departamento | No errors. |
| App\Entity\Almacen\AplicacionArticulo | No errors. |
| App\Entity\Mantenimiento\PedidoReparacion | No errors. |
| App\Entity\Mantenimiento\PedidoReparacionDiagramado | No errors. |
| App\Entity\Mantenimiento\DiagramaTarea | No errors. |