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

Query Metrics

37 Database Queries
6 Different statements
9.88 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.66 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 FROM mov_movimiento_stock t0 WHERE t0.id = ? AND t0.discr IN ('ms', 'oc', 'tr', 'ph', 'or', 'as', 'ore')
Parameters:
[
  "6568"
]
2 0.38 ms
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
]
3 0.25 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
Parameters:
[]
4 0.28 ms
SELECT t0.id AS id_1, t0.razon_social AS razon_social_2, t0.cuit AS cuit_3, t0.activo AS activo_4 FROM mov_proveedores t0 WHERE t0.id = ?
Parameters:
[
  75
]
5 0.46 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:
[
  6568
]
6 0.57 ms
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:
[
  25221
]
7 0.51 ms
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:
[
  20250
]
8 0.24 ms
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:
[
  25287
]
9 0.27 ms
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:
[
  19709
]
10 0.23 ms
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:
[
  19713
]
11 0.26 ms
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:
[
  19490
]
12 0.24 ms
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:
[
  19491
]
13 0.23 ms
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:
[
  19494
]
14 0.23 ms
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:
[
  19498
]
15 0.22 ms
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:
[
  19497
]
16 0.22 ms
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:
[
  19499
]
17 0.21 ms
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:
[
  19508
]
18 0.22 ms
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:
[
  19507
]
19 0.22 ms
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:
[
  19514
]
20 0.23 ms
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:
[
  19521
]
21 0.22 ms
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:
[
  19523
]
22 0.21 ms
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:
[
  19714
]
23 0.21 ms
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:
[
  17259
]
24 0.24 ms
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:
[
  17260
]
25 0.21 ms
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:
[
  20042
]
26 0.24 ms
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:
[
  24617
]
27 0.25 ms
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:
[
  19991
]
28 0.21 ms
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:
[
  17276
]
29 0.25 ms
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:
[
  17281
]
30 0.22 ms
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:
[
  17282
]
31 0.21 ms
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:
[
  17283
]
32 0.21 ms
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:
[
  17267
]
33 0.23 ms
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:
[
  17272
]
34 0.20 ms
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:
[
  17273
]
35 0.24 ms
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:
[
  17274
]
36 0.22 ms
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:
[
  19876
]
37 0.21 ms
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:
[
  25293
]

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.