https://mantenimiento.gestion-miralejos.com.ar/movimientos/orden/reparacion/new

Query Metrics

8 Database Queries
8 Different statements
18.48 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.53 ms
SELECT MAX(m0_.numero) + 1 AS sclr_0 FROM mov_movimiento_stock m0_ WHERE m0_.discr IN ('or')
Parameters:
[]
2 0.51 ms
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
]
3 1.08 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.ubicacion AS ubicacion_3, t0.activo AS activo_4, t0.deposito_defecto AS deposito_defecto_5 FROM gral_depositos t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 7.07 ms
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
]
5 4.09 ms
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
]
6 0.54 ms
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:
[]
7 1.43 ms
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
]
8 1.22 ms
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:
[]

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.