https://mantenimiento.gestion-miralejos.com.ar/movimientos/item/movimiento/2754/new

Query Metrics

6 Database Queries
6 Different statements
23.89 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.73 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.numero AS numero_3, t0.eliminado AS eliminado_4, t0.pendiente AS pendiente_5, t0.fecha_ingreso AS fecha_ingreso_6, t0.ya_procesada AS ya_procesada_7, t0.observaciones AS observaciones_8, t0.finalizo_circuito AS finalizo_circuito_9, t0.id_deposito AS id_deposito_10, t0.id_user_alta AS id_user_alta_11, t0.id_destino AS id_destino_12, t0.id_tarea_diag AS id_tarea_diag_13, t0.id_tare_preventivo AS id_tare_preventivo_14, t0.discr, t0.fecha_recepcion AS fecha_recepcion_15, t0.id_proveedor AS id_proveedor_16, t0.fecha_devolucion AS fecha_devolucion_17, t0.devolucion_procesada AS devolucion_procesada_18, t0.id_empleado AS id_empleado_19, t0.id_empleado AS id_empleado_20, t0.tipo AS tipo_21, t0.id_proveedor_externo AS id_proveedor_externo_22, t0.numero_comprobante AS numero_comprobante_23, t0.id_proveedor AS id_proveedor_24 FROM mov_movimiento_stock t0 WHERE t0.id = ? AND t0.discr IN ('ms', 'oc', 'tr', 'ph', 'or', 'as', 'ore', 're')
Parameters:
[
  "2754"
]
2 15.56 ms
SELECT g0_.id AS id_0, g0_.descripcion AS descripcion_1, g0_.codigo AS codigo_2, g0_.codigo_barras AS codigo_barras_3, g0_.activo AS activo_4, g0_.herramienta AS herramienta_5, g0_.id_uda_med AS id_uda_med_6, g0_.id_categoria AS id_categoria_7, g0_.id_insumo AS id_insumo_8, g0_.id_producto AS id_producto_9, g0_.id_tipo AS id_tipo_10 FROM gral_articulos g0_ WHERE g0_.activo = ? ORDER BY g0_.descripcion ASC
Parameters:
[
  1
]
3 6.43 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
]
4 0.52 ms
SELECT t0.id AS id_1, t0.apellido AS apellido_2, t0.nombre AS nombre_3, t0.legajo AS legajo_4, t0.cuit AS cuit_5, t0.empleado AS empleado_6, t0.activo AS activo_7 FROM rrhh_empleado t0 WHERE t0.id = ?
Parameters:
[
  102
]
5 0.23 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
]
6 0.41 ms
SELECT t0.id AS id_1, t0.cantidad AS cantidad_2, t0.cantidad_ingresada AS cantidad_ingresada_3, t0.observaciones AS observaciones_4, t0.observado AS observado_5, t0.remito AS remito_6, t0.trazabilidad AS trazabilidad_7, t0.estado AS estado_8, t0.id_articulo AS id_articulo_9, t0.id_movimiento AS id_movimiento_10, t0.id_tarea_diag AS id_tarea_diag_11, t0.id_insumo AS id_insumo_12, t0.id_producto AS id_producto_13, t0.id_tipo AS id_tipo_14, t0.id_descripcion AS id_descripcion_15 FROM item_movimiento t0 WHERE t0.id_movimiento = ?
Parameters:
[
  2754
]

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\Almacen\Deposito No errors.
App\Entity\User No errors.
App\Entity\Mantenimiento\PedidoReparacionDiagramado No errors.
App\Entity\Mantenimiento\Preventivo\TareaPlanDiagramada No errors.
App\Entity\Movimientos\OrdenCompra No errors.
App\Entity\Movimientos\Proveedor No errors.
App\Entity\Movimientos\Transferencia No errors.
App\Entity\Movimientos\PrestamoHerramienta No errors.
App\Entity\RRHH\Empleado No errors.
App\Entity\Movimientos\OrdenReparacion No errors.
App\Entity\Movimientos\AjusteStock No errors.
App\Entity\Movimientos\OrdenReparacionExterna No errors.
App\Entity\Movimientos\RemitoEntrega No errors.
App\Entity\Movimientos\ItemMovimiento No errors.
App\Entity\Equipos\Maquinaria No errors.
App\Entity\Almacen\Articulo
  • The field App\Entity\Almacen\Articulo#articulosDeposito is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Almacen\ArticuloDeposito#articulo does not contain the required 'inversedBy="articulosDeposito"' attribute.
App\Entity\Almacen\UnidadMedida No errors.
App\Entity\Almacen\Categoria No errors.
App\Entity\Calidad\InsumoArticulo No errors.
App\Entity\Calidad\ProductoArticulo No errors.
App\Entity\Calidad\TipoArticulo No errors.
App\Entity\Mantenimiento\DiagramaTarea No errors.
App\Entity\Mantenimiento\PedidoReparacion No errors.
App\Entity\Almacen\ArticuloDeposito No errors.
App\Entity\Almacen\AplicacionArticulo No errors.
App\Entity\Calidad\Descripcion No errors.