Query Metrics
13
Database Queries
7
Different statements
6.91 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.97 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:
[
"4387"
]
|
| 2 | 0.79 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.id_articulo AS id_articulo_6, t0.id_movimiento AS id_movimiento_7, t0.id_tarea_diag AS id_tarea_diag_8 FROM item_movimiento t0 WHERE t0.id_movimiento = ?
Parameters:
[
4387
]
|
| 3 | 0.84 ms |
SELECT c0_.id AS id_0, c0_.stock AS stock_1, c0_.stock_minimo AS stock_minimo_2, c0_.stock_maximo AS stock_maximo_3, c0_.ultima_actualizacion AS ultima_actualizacion_4, c0_.id_articulo AS id_articulo_5, c0_.id_deposito AS id_deposito_6 FROM config_art_deposito c0_ WHERE c0_.id_deposito = ? AND c0_.id_articulo = ?
Parameters:
[ 1 19223 ] |
| 4 | 0.74 ms |
SELECT c0_.id AS id_0, c0_.stock AS stock_1, c0_.stock_minimo AS stock_minimo_2, c0_.stock_maximo AS stock_maximo_3, c0_.ultima_actualizacion AS ultima_actualizacion_4, c0_.id_articulo AS id_articulo_5, c0_.id_deposito AS id_deposito_6 FROM config_art_deposito c0_ WHERE c0_.id_deposito = ? AND c0_.id_articulo = ?
Parameters:
[ 1 19863 ] |
| 5 | 0.47 ms |
SELECT c0_.id AS id_0, c0_.stock AS stock_1, c0_.stock_minimo AS stock_minimo_2, c0_.stock_maximo AS stock_maximo_3, c0_.ultima_actualizacion AS ultima_actualizacion_4, c0_.id_articulo AS id_articulo_5, c0_.id_deposito AS id_deposito_6 FROM config_art_deposito c0_ WHERE c0_.id_deposito = ? AND c0_.id_articulo = ?
Parameters:
[ 1 19192 ] |
| 6 | 0.38 ms |
SELECT c0_.id AS id_0, c0_.stock AS stock_1, c0_.stock_minimo AS stock_minimo_2, c0_.stock_maximo AS stock_maximo_3, c0_.ultima_actualizacion AS ultima_actualizacion_4, c0_.id_articulo AS id_articulo_5, c0_.id_deposito AS id_deposito_6 FROM config_art_deposito c0_ WHERE c0_.id_deposito = ? AND c0_.id_articulo = ?
Parameters:
[ 1 19566 ] |
| 7 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
| 8 | 0.61 ms |
UPDATE mov_movimiento_stock SET ya_procesada = ? WHERE id = ?
Parameters:
[ 1 4387 ] |
| 9 | 0.44 ms |
UPDATE config_art_deposito SET stock = ?, ultima_actualizacion = ? WHERE id = ?
Parameters:
[ 9.0 "2026-02-20 23:31:33" 75 ] |
| 10 | 0.30 ms |
UPDATE config_art_deposito SET stock = ?, ultima_actualizacion = ? WHERE id = ?
Parameters:
[ -1.0 "2026-02-20 23:31:33" 507 ] |
| 11 | 0.26 ms |
UPDATE config_art_deposito SET stock = ?, ultima_actualizacion = ? WHERE id = ?
Parameters:
[ 176.0 "2026-02-20 23:31:33" 77 ] |
| 12 | 0.25 ms |
UPDATE config_art_deposito SET stock = ?, ultima_actualizacion = ? WHERE id = ?
Parameters:
[ 0.0 "2026-02-20 23:31:33" 177 ] |
| 13 | 0.69 ms |
"COMMIT"
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\ItemMovimiento | No errors. |
| App\Entity\Equipos\Maquinaria | No errors. |
| App\Entity\Almacen\Articulo | No errors. |
| App\Entity\Almacen\ArticuloDeposito | No errors. |