Query Metrics
6
Database Queries
6
Different statements
11.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.15 ms (35.82%) |
1 |
SELECT p0_.id AS id_0, p0_.fecha AS fecha_1, p0_.observacion_responsable AS observacion_responsable_2, p0_.observacion_reparacion AS observacion_reparacion_3, p0_.realizada AS realizada_4, p0_.id_pedido AS id_pedido_5, p0_.id_diagrama AS id_diagrama_6, p0_.id_equipo AS id_equipo_7 FROM pedido_reparacion_diagramado p0_ INNER JOIN diagrama_tarea d1_ ON p0_.id_diagrama = d1_.id WHERE d1_.procesado = ?
Parameters:
[
0
]
|
|
2.65 ms (22.85%) |
1 |
SELECT MAX(m0_.numero) + 1 AS sclr_0 FROM mov_movimiento_stock m0_ WHERE m0_.discr IN ('or')
Parameters:
[] |
|
1.53 ms (13.23%) |
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_.activo = ? ORDER BY m0_.nombre ASC
Parameters:
[
1
]
|
|
1.38 ms (11.89%) |
1 |
SELECT t0_.id AS id_0, t0_.detalle AS detalle_1, t0_.realizada AS realizada_2, t0_.id_tarea AS id_tarea_3, t0_.id_plan_diagramado AS id_plan_diagramado_4 FROM tarea_plan_diagramada t0_ INNER JOIN plan_mantenimiento_diagramado p1_ ON t0_.id_plan_diagramado = p1_.id WHERE p1_.realizado = ?
Parameters:
[
0
]
|
|
1.27 ms (10.98%) |
1 |
SELECT r0_.id AS id_0, r0_.apellido AS apellido_1, r0_.nombre AS nombre_2, r0_.legajo AS legajo_3, r0_.cuit AS cuit_4, r0_.empleado AS empleado_5, r0_.activo AS activo_6 FROM rrhh_empleado r0_
Parameters:
[] |
|
0.61 ms (5.22%) |
1 |
SELECT g0_.id AS id_0, g0_.nombre AS nombre_1, g0_.ubicacion AS ubicacion_2, g0_.activo AS activo_3, g0_.deposito_defecto AS deposito_defecto_4 FROM gral_depositos g0_
Parameters:
[] |
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\Movimientos\MovimientoStock | No errors. |
| App\Entity\Movimientos\OrdenReparacion | No errors. |
| App\Entity\Mantenimiento\PedidoReparacionDiagramado | No errors. |
| App\Entity\Mantenimiento\DiagramaTarea | No errors. |
| App\Entity\Mantenimiento\PedidoReparacion | No errors. |
| App\Entity\Equipos\Maquinaria | No errors. |
| App\Entity\Mantenimiento\Preventivo\TareaPlanDiagramada | No errors. |
| App\Entity\Mantenimiento\Preventivo\PlanMantenimientoDiagramado | No errors. |
| App\Entity\Mantenimiento\Preventivo\TareaPlan | No errors. |
| App\Entity\Almacen\Deposito | No errors. |
| App\Entity\Mantenimiento\SectorPlanta | No errors. |
| App\Entity\RRHH\Empleado | No errors. |
| App\Entity\Almacen\Articulo | No errors. |