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 770.7s ago] {'pk_1': 488325}
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.00013s] {'param_1': 488325}
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.00013s] {'param_1': 488325}
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.00011s] {'param_1': 488325}
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': 488325}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00013s] {'cell_id': None, 'sku_cell_id': 1279317}
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 770.7s ago] {'pk_1': 488325}
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.01898s ago] {'param_1': 488325}
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.01718s ago] {'param_1': 488325}
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.01614s ago] {'param_1': 488325}
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.01515s ago] {'param_1': 488325}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01394s ago] {'cell_id': None, 'sku_cell_id': 1279317}
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 770.7s ago] {'pk_1': 488325}
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.03151s ago] {'param_1': 488325}
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.02869s ago] {'param_1': 488325}
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.02761s ago] {'param_1': 488325}
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.02661s ago] {'param_1': 488325}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02525s ago] {'cell_id': None, 'sku_cell_id': 1279317}
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 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] {'zone_barcode_1': 'PZ-1-99-01-1-11'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00013s] {'zone_barcode': None, 'zone_barcode_1': 'PZ-1-99-01-1-11'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_cart SET content_type=%(content_type)s, state=%(state)s, user_info=%(user_info)s WHERE acceptance_cart.barcode = %(barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00010s] {'content_type': None, 'state': <AcceptanceCartState.FREE: 'FREE'>, 'user_info': None, 'barcode_1': 'TEL-001-010'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET cart_barcode=%(cart_barcode)s WHERE acceptance_count_box.cart_barcode = %(cart_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00014s] {'cart_barcode': None, 'cart_barcode_1': 'TEL-001-010'}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.008337s ago] {'zone_barcode_1': 'BV-63-2-10'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 
FROM invoice 
WHERE invoice.invoice_number = %(invoice_number_1)s 
 LIMIT %(param_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'invoice_number_1': 7543277285, 'param_1': 1}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_pallet SET work_table_barcode=%(work_table_barcode)s WHERE acceptance_pallet.invoice_wms_id = %(invoice_wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12575245}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01554s ago] {'zone_barcode_1': 'RP-1-63-1'}
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: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 770.8s ago] {'pk_1': 488330}
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.06714s ago] {'param_1': 488330}
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.06352s ago] {'param_1': 488330}
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.06246s ago] {'param_1': 488330}
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.06151s ago] {'param_1': 488330}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.06018s ago] {'cell_id': None, 'sku_cell_id': 1279324}
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 770.8s ago] {'pk_1': 488330}
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.07733s ago] {'param_1': 488330}
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.07347s ago] {'param_1': 488330}
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.07238s ago] {'param_1': 488330}
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.07143s ago] {'param_1': 488330}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.07021s ago] {'cell_id': None, 'sku_cell_id': 1279324}
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 770.8s ago] {'pk_1': 488330}
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.08736s ago] {'param_1': 488330}
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.08351s ago] {'param_1': 488330}
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.08243s ago] {'param_1': 488330}
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.08144s ago] {'param_1': 488330}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.08007s ago] {'cell_id': None, 'sku_cell_id': 1279324}
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 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04745s ago] {'zone_barcode_1': 'PZ-1-52-01-1-13'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04574s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-1-52-01-1-13'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.05011s ago] {'zone_barcode_1': 'PZ-1-104-01-2-14'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04849s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-1-104-01-2-14'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.05288s ago] {'zone_barcode_1': 'PZ-1-43-01-2-11'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.05108s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-1-43-01-2-11'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_cart SET content_type=%(content_type)s, state=%(state)s, user_info=%(user_info)s WHERE acceptance_cart.barcode = %(barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04991s ago] {'content_type': None, 'state': <AcceptanceCartState.FREE: 'FREE'>, 'user_info': None, 'barcode_1': 'TEL-001-002'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET cart_barcode=%(cart_barcode)s WHERE acceptance_count_box.cart_barcode = %(cart_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04956s ago] {'cart_barcode': None, 'cart_barcode_1': 'TEL-001-002'}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.05773s ago] {'zone_barcode_1': 'BV-91-2-14'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 
FROM invoice 
WHERE invoice.invoice_number = %(invoice_number_1)s 
 LIMIT %(param_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04874s ago] {'invoice_number_1': 7543280100, 'param_1': 1}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_pallet SET work_table_barcode=%(work_table_barcode)s WHERE acceptance_pallet.invoice_wms_id = %(invoice_wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04931s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12575314}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.06451s ago] {'zone_barcode_1': 'RP-1-48-1'}
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: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 770.8s ago] {'pk_1': 488333}
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.116s ago] {'param_1': 488333}
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.1131s ago] {'param_1': 488333}
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.1122s ago] {'param_1': 488333}
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.1112s ago] {'param_1': 488333}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] {'id': 488333}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.08073s ago] {'zone_barcode_1': 'BV-102-1-10'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 
FROM invoice 
WHERE invoice.invoice_number = %(invoice_number_1)s 
 LIMIT %(param_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.07178s ago] {'invoice_number_1': 7543283276, 'param_1': 1}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_pallet SET work_table_barcode=%(work_table_barcode)s WHERE acceptance_pallet.invoice_wms_id = %(invoice_wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.07061s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12575442}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.08559s ago] {'zone_barcode_1': 'RP-1-104-1'}
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: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 770.8s ago] {'pk_1': 488334}
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.1372s ago] {'param_1': 488334}
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.133s ago] {'param_1': 488334}
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.1319s ago] {'param_1': 488334}
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.1308s ago] {'param_1': 488334}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01935s ago] {'id': 488334}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.09859s ago] {'zone_barcode_1': 'PZ-8-03-13-07-77'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.09701s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-8-03-13-07-77'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1021s ago] {'zone_barcode_1': 'BV-011-013'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 
FROM invoice 
WHERE invoice.invoice_number = %(invoice_number_1)s 
 LIMIT %(param_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.0931s ago] {'invoice_number_1': 7543283650, 'param_1': 1}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_pallet SET work_table_barcode=%(work_table_barcode)s WHERE acceptance_pallet.invoice_wms_id = %(invoice_wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.09202s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12575466}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1075s ago] {'zone_barcode_1': 'RP-11-18'}
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: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 770.9s ago] {'pk_1': 488347}
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.159s ago] {'param_1': 488347}
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.1549s ago] {'param_1': 488347}
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.1538s ago] {'param_1': 488347}
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.1527s ago] {'param_1': 488347}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04121s ago] {'id': 488347}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1204s ago] {'zone_barcode_1': 'PZ-1-11-12-2-54'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1189s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-1-11-12-2-54'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1234s ago] {'zone_barcode_1': 'PZ-0-00-00-7-28'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1218s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-0-00-00-7-28'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1263s ago] {'zone_barcode_1': 'PZ-7-07-09-19-77'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1247s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-7-07-09-19-77'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1292s ago] {'zone_barcode_1': 'BV-011-022'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 
FROM invoice 
WHERE invoice.invoice_number = %(invoice_number_1)s 
 LIMIT %(param_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1202s ago] {'invoice_number_1': 7543312215, 'param_1': 1}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_pallet SET work_table_barcode=%(work_table_barcode)s WHERE acceptance_pallet.invoice_wms_id = %(invoice_wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1191s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12575607}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1344s ago] {'zone_barcode_1': 'RP-01-02'}
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: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 770.9s ago] {'pk_1': 488349}
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.1858s ago] {'param_1': 488349}
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.1817s ago] {'param_1': 488349}
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.1806s ago] {'param_1': 488349}
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.1796s ago] {'param_1': 488349}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.06812s ago] {'id': 488349}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1474s ago] {'zone_barcode_1': 'BV-04-01'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 
FROM invoice 
WHERE invoice.invoice_number = %(invoice_number_1)s 
 LIMIT %(param_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1385s ago] {'invoice_number_1': 7543344255, 'param_1': 1}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_pallet SET work_table_barcode=%(work_table_barcode)s WHERE acceptance_pallet.invoice_wms_id = %(invoice_wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1376s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12575679}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1528s ago] {'zone_barcode_1': 'RP-01-02'}
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: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 770.9s ago] {'pk_1': 488350}
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.2043s ago] {'param_1': 488350}
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.2001s ago] {'param_1': 488350}
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.199s ago] {'param_1': 488350}
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.198s ago] {'param_1': 488350}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] [{'cell_id': None, 'sku_cell_id': 1279342}, {'cell_id': None, 'sku_cell_id': 1279343}, {'cell_id': None, 'sku_cell_id': 1279344}]
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 770.9s ago] {'pk_1': 488350}
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.2146s ago] {'param_1': 488350}
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.2105s ago] {'param_1': 488350}
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.2093s ago] {'param_1': 488350}
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.2084s ago] {'param_1': 488350}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01018s ago] [{'cell_id': None, 'sku_cell_id': 1279342}, {'cell_id': None, 'sku_cell_id': 1279343}, {'cell_id': None, 'sku_cell_id': 1279344}]
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 770.9s ago] {'pk_1': 488350}
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.2244s ago] {'param_1': 488350}
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.2201s ago] {'param_1': 488350}
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.219s ago] {'param_1': 488350}
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.218s ago] {'param_1': 488350}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01983s ago] [{'cell_id': None, 'sku_cell_id': 1279342}, {'cell_id': None, 'sku_cell_id': 1279343}, {'cell_id': None, 'sku_cell_id': 1279344}]
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 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.184s ago] {'zone_barcode_1': 'PZ-7-18-04-03-77'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1825s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-7-18-04-03-77'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_cart SET content_type=%(content_type)s, state=%(state)s, user_info=%(user_info)s WHERE acceptance_cart.barcode = %(barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1815s ago] {'content_type': None, 'state': <AcceptanceCartState.FREE: 'FREE'>, 'user_info': None, 'barcode_1': 'TEL-101-029'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET cart_barcode=%(cart_barcode)s WHERE acceptance_count_box.cart_barcode = %(cart_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1812s ago] {'cart_barcode': None, 'cart_barcode_1': 'TEL-101-029'}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1897s ago] {'zone_barcode_1': 'BV-06-04'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 
FROM invoice 
WHERE invoice.invoice_number = %(invoice_number_1)s 
 LIMIT %(param_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1807s ago] {'invoice_number_1': 7543344717, 'param_1': 1}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_pallet SET work_table_barcode=%(work_table_barcode)s WHERE acceptance_pallet.invoice_wms_id = %(invoice_wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1797s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12575703}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1948s ago] {'zone_barcode_1': 'RP-11-18'}
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: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 770.9s ago] {'pk_1': 488352}
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.2464s ago] {'param_1': 488352}
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.2425s ago] {'param_1': 488352}
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.2415s ago] {'param_1': 488352}
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.2406s ago] {'param_1': 488352}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.04257s ago] [{'cell_id': None, 'sku_cell_id': 1279346}, {'cell_id': None, 'sku_cell_id': 1279347}, {'cell_id': None, 'sku_cell_id': 1279348}]
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 771s ago] {'pk_1': 488352}
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.2592s ago] {'param_1': 488352}
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.2551s ago] {'param_1': 488352}
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.2539s ago] {'param_1': 488352}
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.253s ago] {'param_1': 488352}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.05494s ago] [{'cell_id': None, 'sku_cell_id': 1279346}, {'cell_id': None, 'sku_cell_id': 1279347}, {'cell_id': None, 'sku_cell_id': 1279348}]
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 771s ago] {'pk_1': 488352}
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.2691s ago] {'param_1': 488352}
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.2648s ago] {'param_1': 488352}
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.2638s ago] {'param_1': 488352}
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.2628s ago] {'param_1': 488352}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.06473s ago] [{'cell_id': None, 'sku_cell_id': 1279346}, {'cell_id': None, 'sku_cell_id': 1279347}, {'cell_id': None, 'sku_cell_id': 1279348}]
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 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2292s ago] {'zone_barcode_1': 'PZ-8-03-08-14-77'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2276s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-8-03-08-14-77'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.232s ago] {'zone_barcode_1': 'PZ-1-11-11-2-56'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2303s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-1-11-11-2-56'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.235s ago] {'zone_barcode_1': 'PZ-7-14-09-02-77'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2332s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-7-14-09-02-77'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_cart SET content_type=%(content_type)s, state=%(state)s, user_info=%(user_info)s WHERE acceptance_cart.barcode = %(barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2322s ago] {'content_type': None, 'state': <AcceptanceCartState.FREE: 'FREE'>, 'user_info': None, 'barcode_1': 'TEL-101-013'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET cart_barcode=%(cart_barcode)s WHERE acceptance_count_box.cart_barcode = %(cart_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.232s ago] {'cart_barcode': None, 'cart_barcode_1': 'TEL-101-013'}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2402s ago] {'zone_barcode_1': 'BV-011-022'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 
FROM invoice 
WHERE invoice.invoice_number = %(invoice_number_1)s 
 LIMIT %(param_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2313s ago] {'invoice_number_1': 7543347617, 'param_1': 1}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_pallet SET work_table_barcode=%(work_table_barcode)s WHERE acceptance_pallet.invoice_wms_id = %(invoice_wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2307s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12575760}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2458s ago] {'zone_barcode_1': 'RP-11-18'}
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: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 771s ago] {'pk_1': 488353}
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.2977s ago] {'param_1': 488353}
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.2965s ago] {'param_1': 488353}
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.2954s ago] {'param_1': 488353}
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.2945s ago] {'param_1': 488353}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM cell WHERE cell.id = %(id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1831s ago] {'id': 488353}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2642s ago] {'zone_barcode_1': 'BV-011-025'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 
FROM invoice 
WHERE invoice.invoice_number = %(invoice_number_1)s 
 LIMIT %(param_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2552s ago] {'invoice_number_1': 7543350991, 'param_1': 1}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_pallet SET work_table_barcode=%(work_table_barcode)s WHERE acceptance_pallet.invoice_wms_id = %(invoice_wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2541s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12575879}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2691s ago] {'zone_barcode_1': 'RP-01-02'}
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: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 771s ago] {'pk_1': 488354}
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.3206s ago] {'param_1': 488354}
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.3165s ago] {'param_1': 488354}
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.3154s ago] {'param_1': 488354}
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.3146s ago] {'param_1': 488354}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3134s ago] {'cell_id': None, 'sku_cell_id': 1279349}
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 771s ago] {'pk_1': 488354}
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.3312s ago] {'param_1': 488354}
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.3271s ago] {'param_1': 488354}
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.326s ago] {'param_1': 488354}
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.325s ago] {'param_1': 488354}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3236s ago] {'cell_id': None, 'sku_cell_id': 1279349}
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 771s ago] {'pk_1': 488354}
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.3421s ago] {'param_1': 488354}
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.338s ago] {'param_1': 488354}
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.3369s ago] {'param_1': 488354}
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.3361s ago] {'param_1': 488354}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE sku_cell SET cell_id=%(cell_id)s WHERE sku_cell.id = %(sku_cell_id)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3348s ago] {'cell_id': None, 'sku_cell_id': 1279349}
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 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3028s ago] {'zone_barcode_1': 'PZ-8-22-06-08-77'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET zone_barcode=%(zone_barcode)s WHERE acceptance_count_box.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3012s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-8-22-06-08-77'}
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:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_cart SET content_type=%(content_type)s, state=%(state)s, user_info=%(user_info)s WHERE acceptance_cart.barcode = %(barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3002s ago] {'content_type': None, 'state': <AcceptanceCartState.FREE: 'FREE'>, 'user_info': None, 'barcode_1': 'TEL-100-001'}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET cart_barcode=%(cart_barcode)s WHERE acceptance_count_box.cart_barcode = %(cart_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2997s ago] {'cart_barcode': None, 'cart_barcode_1': 'TEL-100-001'}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3079s ago] {'zone_barcode_1': 'BV-011-024'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 
FROM invoice 
WHERE invoice.invoice_number = %(invoice_number_1)s 
 LIMIT %(param_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2989s ago] {'invoice_number_1': 7543351716, 'param_1': 1}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_pallet SET work_table_barcode=%(work_table_barcode)s WHERE acceptance_pallet.invoice_wms_id = %(invoice_wms_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2997s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12575903}
INFO     sqlalchemy.engine.Engine:base.py:1846 DELETE FROM acceptance_topology WHERE acceptance_topology.zone_barcode = %(zone_barcode_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3147s ago] {'zone_barcode_1': 'RP-01-02'}
INFO     sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode