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 161.7s ago] {'pk_1': 480206}
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.00012s] {'param_1': 480206}
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': 480206}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'param_1': 480206}
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.00013s] {'param_1': 480206}
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.00012s] [{'cell_id': None, 'sku_cell_id': 1271200}, {'cell_id': None, 'sku_cell_id': 1271201}, {'cell_id': None, 'sku_cell_id': 1271202}]
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 161.7s ago] {'pk_1': 480206}
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.01839s ago] {'param_1': 480206}
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.01789s ago] {'param_1': 480206}
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.01698s ago] {'param_1': 480206}
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.01612s ago] {'param_1': 480206}
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.01525s ago] [{'cell_id': None, 'sku_cell_id': 1271200}, {'cell_id': None, 'sku_cell_id': 1271201}, {'cell_id': None, 'sku_cell_id': 1271202}]
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 161.7s ago] {'pk_1': 480206}
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.0318s ago] {'param_1': 480206}
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.03087s ago] {'param_1': 480206}
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.03049s ago] {'param_1': 480206}
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.02971s ago] {'param_1': 480206}
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.02909s ago] [{'cell_id': None, 'sku_cell_id': 1271200}, {'cell_id': None, 'sku_cell_id': 1271201}, {'cell_id': None, 'sku_cell_id': 1271202}]
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.00012s] {'zone_barcode_1': 'PZ-1-44-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 [generated in 0.00013s] {'zone_barcode': None, 'zone_barcode_1': 'PZ-1-44-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 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.00013s] {'content_type': None, 'state': <AcceptanceCartState.FREE: 'FREE'>, 'user_info': None, 'barcode_1': 'TEL-001-025'}
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.00013s] {'cart_barcode': None, 'cart_barcode_1': 'TEL-001-025'}
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.008583s ago] {'zone_barcode_1': 'BV-46-2-15'}
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.00019s] {'invoice_number_1': 7059424259, '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.00013s] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12473421}
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.01762s ago] {'zone_barcode_1': 'RP-1-97-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 161.8s ago] {'pk_1': 480214}
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.06587s ago] {'param_1': 480214}
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.06517s ago] {'param_1': 480214}
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.06441s ago] {'param_1': 480214}
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.06354s ago] {'param_1': 480214}
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.06267s ago] [{'cell_id': None, 'sku_cell_id': 1271213}, {'cell_id': None, 'sku_cell_id': 1271214}, {'cell_id': None, 'sku_cell_id': 1271215}]
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 161.8s ago] {'pk_1': 480214}
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.07968s ago] {'param_1': 480214}
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.07907s ago] {'param_1': 480214}
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.07867s ago] {'param_1': 480214}
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.07796s ago] {'param_1': 480214}
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.07748s ago] [{'cell_id': None, 'sku_cell_id': 1271213}, {'cell_id': None, 'sku_cell_id': 1271214}, {'cell_id': None, 'sku_cell_id': 1271215}]
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 161.8s ago] {'pk_1': 480214}
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.0942s ago] {'param_1': 480214}
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.09265s ago] {'param_1': 480214}
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.09193s ago] {'param_1': 480214}
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.09105s ago] {'param_1': 480214}
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.09013s ago] [{'cell_id': None, 'sku_cell_id': 1271213}, {'cell_id': None, 'sku_cell_id': 1271214}, {'cell_id': None, 'sku_cell_id': 1271215}]
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.06107s ago] {'zone_barcode_1': 'PZ-1-100-01-2-12'}
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.06081s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-1-100-01-2-12'}
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.06427s ago] {'zone_barcode_1': 'PZ-1-102-01-2-15'}
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.06387s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-1-102-01-2-15'}
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.06709s ago] {'zone_barcode_1': 'PZ-1-28-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.06663s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-1-28-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 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.06503s ago] {'content_type': None, 'state': <AcceptanceCartState.FREE: 'FREE'>, 'user_info': None, 'barcode_1': 'TEL-001-077'}
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.06466s ago] {'cart_barcode': None, 'cart_barcode_1': 'TEL-001-077'}
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.0722s ago] {'zone_barcode_1': 'BV-46-1-15'}
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.06287s ago] {'invoice_number_1': 7059427524, '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.06308s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12473599}
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.08016s ago] {'zone_barcode_1': 'RP-1-42-2'}
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 161.8s ago] {'pk_1': 480218}
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.1282s ago] {'param_1': 480218}
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.1265s ago] {'param_1': 480218}
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.1259s ago] {'param_1': 480218}
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.1254s ago] {'param_1': 480218}
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.00022s] {'id': 480218}
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.09832s ago] {'zone_barcode_1': 'BV-39-2-11'}
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.08843s ago] {'invoice_number_1': 7059431823, '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.08929s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12473883}
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.1063s ago] {'zone_barcode_1': 'RP-1-93-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 161.8s ago] {'pk_1': 480219}
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.1541s ago] {'param_1': 480219}
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.1522s ago] {'param_1': 480219}
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.1522s ago] {'param_1': 480219}
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.1517s ago] {'param_1': 480219}
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.1511s ago] [{'cell_id': None, 'sku_cell_id': 1271218}, {'cell_id': None, 'sku_cell_id': 1271219}, {'cell_id': None, 'sku_cell_id': 1271220}]
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 161.9s ago] {'pk_1': 480219}
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.1674s ago] {'param_1': 480219}
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.1651s ago] {'param_1': 480219}
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.1642s ago] {'param_1': 480219}
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.1632s ago] {'param_1': 480219}
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.1624s ago] [{'cell_id': None, 'sku_cell_id': 1271218}, {'cell_id': None, 'sku_cell_id': 1271219}, {'cell_id': None, 'sku_cell_id': 1271220}]
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 161.9s ago] {'pk_1': 480219}
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.1781s ago] {'param_1': 480219}
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.1759s ago] {'param_1': 480219}
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.1749s ago] {'param_1': 480219}
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.1745s ago] {'param_1': 480219}
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.1737s ago] [{'cell_id': None, 'sku_cell_id': 1271218}, {'cell_id': None, 'sku_cell_id': 1271219}, {'cell_id': None, 'sku_cell_id': 1271220}]
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.1448s ago] {'zone_barcode_1': 'PZ-7-08-15-20-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.1445s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-7-08-15-20-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.1433s 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.1431s 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.1508s ago] {'zone_barcode_1': 'BV-02-05'}
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.1409s ago] {'invoice_number_1': 7059432236, '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.1395s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12473925}
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.1562s 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 161.9s ago] {'pk_1': 480221}
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.2036s ago] {'param_1': 480221}
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.2018s ago] {'param_1': 480221}
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.2013s ago] {'param_1': 480221}
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.2008s ago] {'param_1': 480221}
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.2s ago] [{'cell_id': None, 'sku_cell_id': 1271224}, {'cell_id': None, 'sku_cell_id': 1271225}, {'cell_id': None, 'sku_cell_id': 1271226}]
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 161.9s ago] {'pk_1': 480221}
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.2163s ago] {'param_1': 480221}
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.2169s ago] {'param_1': 480221}
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.216s ago] {'param_1': 480221}
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.215s ago] {'param_1': 480221}
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.2139s ago] [{'cell_id': None, 'sku_cell_id': 1271224}, {'cell_id': None, 'sku_cell_id': 1271225}, {'cell_id': None, 'sku_cell_id': 1271226}]
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 161.9s ago] {'pk_1': 480221}
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.2301s ago] {'param_1': 480221}
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.2284s ago] {'param_1': 480221}
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.2274s ago] {'param_1': 480221}
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.2266s ago] {'param_1': 480221}
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.2258s ago] [{'cell_id': None, 'sku_cell_id': 1271224}, {'cell_id': None, 'sku_cell_id': 1271225}, {'cell_id': None, 'sku_cell_id': 1271226}]
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.1966s ago] {'zone_barcode_1': 'PZ-4-11-08-9-99'}
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.1961s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-4-11-08-9-99'}
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.1992s ago] {'zone_barcode_1': 'PZ-8-01-10-09-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.1987s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-8-01-10-09-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.2017s ago] {'zone_barcode_1': 'PZ-8-16-09-17-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.2012s ago] {'zone_barcode': None, 'zone_barcode_1': 'PZ-8-16-09-17-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.1994s ago] {'content_type': None, 'state': <AcceptanceCartState.FREE: 'FREE'>, 'user_info': None, 'barcode_1': 'TEL-101-006'}
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.1996s ago] {'cart_barcode': None, 'cart_barcode_1': 'TEL-101-006'}
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.2075s ago] {'zone_barcode_1': 'BV-02-05'}
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.1976s ago] {'invoice_number_1': 7059435435, '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.2018s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12474026}
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.2188s 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 162s ago] {'pk_1': 480225}
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.267s ago] {'param_1': 480225}
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.2656s ago] {'param_1': 480225}
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.2648s ago] {'param_1': 480225}
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.2639s ago] {'param_1': 480225}
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.138s ago] {'id': 480225}
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.2368s 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.2271s ago] {'invoice_number_1': 7059440064, '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.2265s ago] {'work_table_barcode': <BinCells.RP: 'RP-000-000'>, 'invoice_wms_id_1': 12474317}
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.2435s 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 162s ago] {'pk_1': 480226}
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.2914s ago] {'param_1': 480226}
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.2903s ago] {'param_1': 480226}
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.2894s ago] {'param_1': 480226}
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.289s ago] {'param_1': 480226}
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.1626s ago] {'id': 480226}
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 162s ago] {'pk_1': 480227}
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.3068s ago] {'param_1': 480227}
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.3054s ago] {'param_1': 480227}
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.3045s ago] {'param_1': 480227}
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.3035s ago] {'param_1': 480227}
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.1774s ago] {'id': 480227}
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 162s ago] {'pk_1': 480228}
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.322s ago] {'param_1': 480228}
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.3204s ago] {'param_1': 480228}
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.3195s ago] {'param_1': 480228}
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.3191s ago] {'param_1': 480228}
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.1927s ago] {'id': 480228}
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 162s ago] {'pk_1': 480229}
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.3369s ago] {'param_1': 480229}
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.3349s ago] {'param_1': 480229}
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.3344s ago] {'param_1': 480229}
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.3335s ago] {'param_1': 480229}
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.2072s ago] {'id': 480229}
INFO     sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode