Query Metrics
24
Database Queries
3
Different statements
15.62 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.54 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.fecha_recepcion AS fecha_recepcion_10, t0.id_deposito AS id_deposito_11, t0.id_user_alta AS id_user_alta_12, t0.id_destino AS id_destino_13, t0.id_tarea_diag AS id_tarea_diag_14, t0.id_tare_preventivo AS id_tare_preventivo_15, t0.id_proveedor AS id_proveedor_16, t0.discr FROM mov_movimiento_stock t0 WHERE t0.id = ? AND t0.discr IN ('oc')
Parameters:
[
"7530"
]
|
| 2 | 2.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:
[
7530
]
|
| 3 | 1.17 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
]
|
| 4 | 0.76 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:
[
20043
]
|
| 5 | 1.03 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
]
|
| 6 | 0.37 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:
[
17261
]
|
| 7 | 0.42 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
]
|
| 8 | 0.35 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
]
|
| 9 | 0.32 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
]
|
| 10 | 0.77 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
]
|
| 11 | 0.31 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:
[
19711
]
|
| 12 | 0.63 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.29 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:
[
19493
]
|
| 14 | 0.34 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
]
|
| 15 | 0.31 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
]
|
| 16 | 0.30 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
]
|
| 17 | 0.32 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:
[
19541
]
|
| 18 | 0.37 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:
[
19543
]
|
| 19 | 0.72 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
]
|
| 20 | 0.64 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:
[
24554
]
|
| 21 | 0.63 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:
[
25433
]
|
| 22 | 0.31 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:
[
19728
]
|
| 23 | 0.28 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:
[
19724
]
|
| 24 | 0.32 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:
[
19726
]
|
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.