Query Metrics
10
Database Queries
10
Different statements
21.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
12.23 ms (56.96%) |
1 |
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
]
|
|
4.84 ms (22.55%) |
1 |
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
]
|
|
0.86 ms (4.00%) |
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:
[
6631
]
|
|
0.70 ms (3.27%) |
1 |
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 = ? AND g0_.id IN (?) ORDER BY g0_.descripcion ASC
Parameters:
[ 1 "19764" ] |
|
0.64 ms (3.00%) |
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 FROM mov_movimiento_stock t0 WHERE t0.id = ? AND t0.discr IN ('ms', 'oc', 'tr', 'ph', 'or', 'as', 'ore')
Parameters:
[
"6631"
]
|
|
0.58 ms (2.70%) |
1 |
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:
[ 2.0 0 null 0 null null null 19764 6631 null null null null null ] |
|
0.55 ms (2.57%) |
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:
[
36
]
|
|
0.55 ms (2.56%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.27 ms (1.24%) |
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 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.25 ms (1.15%) |
1 |
"START TRANSACTION"
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.