https://mantenimiento.gestion-miralejos.com.ar/movimientos/item/movimiento/8237/new Return to referer URL

Query Metrics

11 Database Queries
10 Different statements
28.99 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.67 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:
[
  20
]
2 0.86 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:
[
  "8237"
]
3 0.70 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM gral_aplicacion_articulo t0 INNER JOIN gral_usuarios_aplicacion ON t0.id = gral_usuarios_aplicacion.id_aplicacion WHERE gral_usuarios_aplicacion.id_usuario = ?
Parameters:
[
  20
]
4 0.79 ms
SELECT DISTINCT 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_ INNER JOIN gral_articulo_aplicacion g2_ ON g0_.id = g2_.id_articulo INNER JOIN gral_aplicacion_articulo g1_ ON g1_.id = g2_.id_aplicacion WHERE g0_.activo = ? AND g1_.id IN (?) AND g0_.id IN (?) ORDER BY g0_.descripcion ASC
Parameters:
[
  1
  2
  "25444"
]
5 0.33 ms
"START TRANSACTION"
Parameters:
[]
6 0.79 ms
INSERT INTO item_movimiento (cantidad, cantidad_ingresada, observaciones, observado, remito, trazabilidad, estado, id_articulo, id_movimiento, id_tarea_diag, id_insumo, id_producto, id_tipo, id_descripcion) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  400.0
  0
  null
  0
  null
  null
  null
  25444
  8237
  null
  null
  null
  null
  null
]
7 0.78 ms
"COMMIT"
Parameters:
[]
8 22.02 ms
SELECT DISTINCT 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_ INNER JOIN gral_articulo_aplicacion g2_ ON g0_.id = g2_.id_articulo INNER JOIN gral_aplicacion_articulo g1_ ON g1_.id = g2_.id_aplicacion WHERE g0_.activo = ? AND g1_.id IN (?) ORDER BY g0_.descripcion ASC
Parameters:
[
  1
  2
]
9 0.62 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
]
10 0.31 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:
[
  16
]
11 1.13 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:
[
  8237
]

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\Movimientos\MovimientoStock 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\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\Equipos\Maquinaria No errors.
App\Entity\Almacen\ArticuloDeposito No errors.
App\Entity\Calidad\Descripcion No errors.