https://mantenimiento.gestion-miralejos.com.ar/movimientos/item/movimiento/4587/ingresar

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
0.80 ms
(26.47%)
1
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:
[
  "4587"
]
0.56 ms
(18.29%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3 FROM descripcion t0 WHERE t0.activo = ? ORDER BY t0.nombre ASC
Parameters:
[
  1
]
0.48 ms
(15.66%)
1
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:
[
  4587
]
0.47 ms
(15.36%)
1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.codigo AS codigo_3, t0.codigo_barras AS codigo_barras_4, t0.activo AS activo_5, t0.herramienta AS herramienta_6, t0.id_uda_med AS id_uda_med_7, t0.id_categoria AS id_categoria_8, t0.id_insumo AS id_insumo_9, t0.id_producto AS id_producto_10, t0.id_tipo AS id_tipo_11 FROM gral_articulos t0 WHERE t0.id = ?
Parameters:
[
  18402
]
0.44 ms
(14.41%)
1
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:
[
  457
]
0.30 ms
(9.80%)
1
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
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\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\Calidad\Descripcion 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\Calidad\InsumoArticulo No errors.
App\Entity\Calidad\ProductoArticulo No errors.
App\Entity\Calidad\TipoArticulo No errors.
App\Entity\Almacen\UnidadMedida No errors.
App\Entity\Almacen\Categoria No errors.
App\Entity\Almacen\ArticuloDeposito No errors.
App\Entity\Almacen\AplicacionArticulo No errors.