INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.1s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100040}
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 434.9s ago] {'pk_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00014s] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00017s] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] [{'cell_id': None, 'reservation_id': 38884254}, {'cell_id': None, 'reservation_id': 38884255}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435s ago] {'pk_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03082s ago] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02716s ago] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02588s ago] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02522s ago] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02438s ago] [{'cell_id': None, 'reservation_id': 38884254}, {'cell_id': None, 'reservation_id': 38884255}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435s ago] {'pk_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.0438s ago] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04024s ago] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03902s ago] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03835s ago] {'param_1': 488059}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03727s ago] [{'cell_id': None, 'reservation_id': 38884254}, {'cell_id': None, 'reservation_id': 38884255}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.1s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100040}
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode 
FROM packing_table 
WHERE packing_table.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 432.8s ago] {'pk_1': 103061}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id 
FROM box 
WHERE %(param_1)s = box.packing_table_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'param_1': 103061}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00015s] {'id': 103061}
INFO     sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.2s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100320}
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.1s ago] {'pk_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1448s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1415s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.14s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1392s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1383s ago] [{'cell_id': None, 'reservation_id': 38884261}, {'cell_id': None, 'reservation_id': 38884262}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.1s ago] {'pk_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.157s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1523s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1507s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1506s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1498s ago] [{'cell_id': None, 'reservation_id': 38884261}, {'cell_id': None, 'reservation_id': 38884262}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.1s ago] {'pk_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1716s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1697s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1683s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1675s ago] {'param_1': 488082}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1664s ago] [{'cell_id': None, 'reservation_id': 38884261}, {'cell_id': None, 'reservation_id': 38884262}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.3s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100320}
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode 
FROM packing_table 
WHERE packing_table.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 433s ago] {'pk_1': 103067}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id 
FROM box 
WHERE %(param_1)s = box.packing_table_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1176s ago] {'param_1': 103067}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.112s ago] {'id': 103067}
INFO     sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.3s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100060}
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.2s ago] {'pk_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.241s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2372s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2357s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2349s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2338s ago] [{'cell_id': None, 'reservation_id': 38884265}, {'cell_id': None, 'reservation_id': 38884266}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.2s ago] {'pk_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2524s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2475s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.246s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2451s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2439s ago] [{'cell_id': None, 'reservation_id': 38884265}, {'cell_id': None, 'reservation_id': 38884266}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.2s ago] {'pk_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2631s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2583s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2568s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.256s ago] {'param_1': 488088}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2549s ago] [{'cell_id': None, 'reservation_id': 38884265}, {'cell_id': None, 'reservation_id': 38884266}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.4s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100060}
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode 
FROM packing_table 
WHERE packing_table.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 433.1s ago] {'pk_1': 103069}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id 
FROM box 
WHERE %(param_1)s = box.packing_table_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2067s ago] {'param_1': 103069}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2018s ago] {'id': 103069}
INFO     sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.4s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100333}
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.3s ago] {'pk_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3298s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3261s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3247s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3239s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3228s ago] [{'cell_id': None, 'reservation_id': 38884270}, {'cell_id': None, 'reservation_id': 38884271}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.3s ago] {'pk_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3419s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3372s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3376s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3368s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3356s ago] [{'cell_id': None, 'reservation_id': 38884270}, {'cell_id': None, 'reservation_id': 38884271}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id AS cell_id, cell.key AS cell_key, cell.zone_id AS cell_zone_id, cell.active AS cell_active, cell.mix_type AS cell_mix_type, cell.skus_amount AS cell_skus_amount, cell.cell_picking_type AS cell_cell_picking_type, cell.barcode AS cell_barcode, cell.old_barcode AS cell_old_barcode, cell.height AS cell_height, cell.length AS cell_length, cell.width AS cell_width, cell.placing_order AS cell_placing_order, cell.picking_order AS cell_picking_order, cell.inventory_task_id AS cell_inventory_task_id, cell.last_inventory_date AS cell_last_inventory_date, cell.last_inventory_worker_id AS cell_last_inventory_worker_id, cell.deactivate_reason AS cell_deactivate_reason 
FROM cell 
WHERE cell.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.3s ago] {'pk_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3543s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3496s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3481s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3473s ago] {'param_1': 488092}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.346s ago] [{'cell_id': None, 'reservation_id': 38884270}, {'cell_id': None, 'reservation_id': 38884271}]
INFO     sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100317}
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode 
FROM packing_table 
WHERE packing_table.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 433.1s ago] {'pk_1': 103071}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id 
FROM box 
WHERE %(param_1)s = box.packing_table_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2965s ago] {'param_1': 103071}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2912s ago] {'id': 103071}
INFO     sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100399}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100360}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100073}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100228}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100252}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100276}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100335}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100353}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 435.5s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100224}