Query Metrics
6
Database Queries
6
Different statements
8.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.84 ms (46.72%) |
1 |
SELECT d0_.fecha AS fecha_0, p1_.observacion_responsable AS observacion_responsable_1, m2_.nombre AS nombre_2, m3_.nombre AS nombre_3, p1_.id AS id_4 FROM diagrama_tarea d0_ INNER JOIN mant_departamento m3_ ON d0_.id_depto = m3_.id INNER JOIN pedido_reparacion_diagramado p1_ ON d0_.id = p1_.id_diagrama INNER JOIN mant_pedido_reparacion m4_ ON p1_.id_pedido = m4_.id INNER JOIN mant_maquinarias m2_ ON m4_.id_equipo = m2_.id WHERE (d0_.fecha BETWEEN ? AND ?) AND p1_.realizada = ? AND m2_.id = ?
Parameters:
[ "2016-02-17 00:00:00" "2026-08-20 00:00:00" 1 198 ] |
|
1.66 ms (20.13%) |
1 |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.codigo AS codigo_2, m0_.activo AS activo_3, m0_.id_sector AS id_sector_4 FROM mant_maquinarias m0_ WHERE m0_.id_sector IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.nombre ASC
Parameters:
[ 57 58 59 60 49 18 23 24 32 33 8 30 53 17 36 48 13 6 12 5 9 7 11 16 47 55 28 27 29 35 4 10 2 54 20 19 52 39 40 41 42 43 44 46 37 38 45 3 31 56 15 14 51 34 68 1 65 26 21 22 25 61 62 63 64 50 ] |
|
0.91 ms (11.11%) |
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 = ? ORDER BY t0.nombre ASC
Parameters:
[
10
]
|
|
0.82 ms (9.97%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.activo AS activo_4, t0.id_sector AS id_sector_5 FROM mant_maquinarias t0 WHERE t0.nombre = ? LIMIT 2
Parameters:
[
"COMPRESOR FRICK N°4"
]
|
|
0.53 ms (6.48%) |
1 |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.codigo AS codigo_2, m0_.activo AS activo_3, m0_.id_sector AS id_sector_4 FROM mant_maquinarias m0_ WHERE m0_.id_sector IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m0_.id IN (?) ORDER BY m0_.nombre ASC
Parameters:
[ 57 58 59 60 49 18 23 24 32 33 8 30 53 17 36 48 13 6 12 5 9 7 11 16 47 55 28 27 29 35 4 10 2 54 20 19 52 39 40 41 42 43 44 46 37 38 45 3 31 56 15 14 51 34 68 1 65 26 21 22 25 61 62 63 64 50 "198" ] |
|
0.46 ms (5.60%) |
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:
[
10
]
|
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\Equipos\Maquinaria | No errors. |
| App\Entity\Almacen\Articulo | No errors. |
| App\Entity\Mantenimiento\DiagramaTarea | No errors. |
| App\Entity\Mantenimiento\PedidoReparacionDiagramado | No errors. |
| App\Entity\Mantenimiento\PedidoReparacion | No errors. |