Query Metrics
10
Database Queries
7
Different statements
8.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.43 ms (53.62%) |
1 |
SELECT m0_.id AS id_0, m1_.nombre AS nombre_1, m0_.detalle AS detalle_2, m2_.id AS id_3, m3_.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 m3_ ON m0_.id_depto = m3_.id LEFT JOIN mant_maquinarias m2_ ON m0_.id_equipo = m2_.id WHERE m0_.eliminada = ? AND m0_.realizada = ? AND m0_.id NOT IN (?) AND m1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m3_.id IN (?, ?, ?)
Parameters:
[ 0 0 "2559,2560,2561,2562" 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 1 26 21 22 25 61 62 63 64 50 1 2 3 ] |
|
1.28 ms (15.48%) |
4 |
SELECT t0.id AS id_1, t0.fecha_carga AS fecha_carga_2, t0.fecha_diagrama AS fecha_diagrama_3, t0.detalle AS detalle_4, t0.diagramada AS diagramada_5, t0.realizada AS realizada_6, t0.eliminada AS eliminada_7, t0.nombre_archivo_imagen AS nombre_archivo_imagen_8, t0.id_sector AS id_sector_9, t0.id_tipo AS id_tipo_10, t0.id_equipo AS id_equipo_11, t0.id_user_alta AS id_user_alta_12, t0.id_solicitante AS id_solicitante_13, t0.id_tarea_plan AS id_tarea_plan_14, t0.id_depto AS id_depto_15 FROM mant_pedido_reparacion t0 WHERE t0.id = ?
Parameters:
[
2559
]
|
|
0.67 ms (8.09%) |
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:
[
11
]
|
|
0.62 ms (7.52%) |
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:
[
11
]
|
|
0.57 ms (6.88%) |
1 |
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.observacion_responsable AS observacion_responsable_3, t0.observacion_reparacion AS observacion_reparacion_4, t0.realizada AS realizada_5, t0.id_pedido AS id_pedido_6, t0.id_diagrama AS id_diagrama_7, t0.id_equipo AS id_equipo_8 FROM pedido_reparacion_diagramado t0 WHERE t0.id_diagrama = ?
Parameters:
[
899
]
|
|
0.40 ms (4.84%) |
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:
[
11
]
|
|
0.30 ms (3.57%) |
1 |
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.fecha_diagrama AS fecha_diagrama_3, t0.procesado AS procesado_4, t0.id_depto AS id_depto_5, t0.id_user_alta AS id_user_alta_6 FROM diagrama_tarea t0 WHERE t0.id = ?
Parameters:
[
"899"
]
|
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\DiagramaTarea | No errors. |
| App\Entity\Mantenimiento\PedidoReparacionDiagramado | No errors. |
| App\Entity\RRHH\Empleado | No errors. |
| App\Entity\Mantenimiento\PedidoReparacion | No errors. |
| App\Entity\Equipos\Maquinaria | No errors. |
| App\Entity\Mantenimiento\TipoReparacion | No errors. |
| App\Entity\Mantenimiento\SolicitantePedidoReparacion | No errors. |
| App\Entity\Mantenimiento\Preventivo\TareaPlanDiagramada | No errors. |