INFO sqlalchemy.engine.Engine:base.py:1846 SELECT account.wms_id, account.is_active, account.first_name, account.last_name, account.password, account.phone, account.is_pass_change_needed, account.code, account.date_created, account.linked_delivery_point_id, account.patronymic, account.zone_id, account.role_wms_id, account.warehouse_id, account.barcode, account.cell_key, account.jobtitle, account.pinfl FROM account WHERE account.first_name = %(first_name_1)s AND account.last_name = %(last_name_1)s AND account.barcode = %(barcode_1)s AND account.warehouse_id = %(warehouse_id_1)s ORDER BY random() LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 22.03s ago] {'first_name_1': 'Phantom', 'last_name_1': 'Lancer', 'barcode_1': , 'warehouse_id_1': 1693627, 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT account.wms_id AS account_wms_id, account.is_active AS account_is_active, account.first_name AS account_first_name, account.last_name AS account_last_name, account.password AS account_password, account.phone AS account_phone, account.is_pass_change_needed AS account_is_pass_change_needed, account.code AS account_code, account.date_created AS account_date_created, account.linked_delivery_point_id AS account_linked_delivery_point_id, account.patronymic AS account_patronymic, account.zone_id AS account_zone_id, account.role_wms_id AS account_role_wms_id, account.warehouse_id AS account_warehouse_id, account.barcode AS account_barcode, account.cell_key AS account_cell_key, account.jobtitle AS account_jobtitle, account.pinfl AS account_pinfl FROM account WHERE account.wms_id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 22.02s ago] {'pk_1': 100325} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 22.02s ago] {'barcode': , 'wms_id_1': 100325} INFO sqlalchemy.engine.Engine:base.py:1846 INSERT INTO cell (key, zone_id, cell_picking_type, barcode, old_barcode, height, length, width, placing_order, picking_order, inventory_task_id, last_inventory_date, last_inventory_worker_id, deactivate_reason) VALUES (%(key)s, %(zone_id)s, %(cell_picking_type)s, %(barcode)s, %(old_barcode)s, %(height)s, %(length)s, %(width)s, %(placing_order)s, %(picking_order)s, %(inventory_task_id)s, %(last_inventory_date)s, %(last_inventory_worker_id)s, %(deactivate_reason)s) RETURNING cell.id, cell.active, cell.mix_type, cell.skus_amount INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.95s ago] {'key': 'QA-70333853615001088', 'zone_id': , 'cell_picking_type': , 'barcode': None, 'old_barcode': '2026-02-05T23:24:13.615025', 'height': None, 'length': None, 'width': None, 'placing_order': None, 'picking_order': None, 'inventory_task_id': None, 'last_inventory_date': None, 'last_inventory_worker_id': None, 'deactivate_reason': None} 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 21.33s ago] {'pk_1': 479900} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT account.wms_id, account.is_active, account.is_pass_change_needed, account.first_name, account.last_name, account.password, account.phone, account.barcode, account.cell_key, account.code, account.date_created, account.jobtitle, account.linked_delivery_point_id, account.patronymic, account.pinfl, account.warehouse_id, account.zone_id, account.role_wms_id, account.language_code, account.profile_pic, account.cabinet_type, account.company_id FROM account WHERE account.first_name = %(first_name_1)s AND account.last_name = %(last_name_1)s AND account.barcode = %(barcode_1)s ORDER BY random() LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.32s ago] {'first_name_1': , 'last_name_1': , 'barcode_1': , 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.31s ago] {'barcode': , 'wms_id_1': 10011} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT account.wms_id AS account_wms_id, account.is_active AS account_is_active, account.is_pass_change_needed AS account_is_pass_change_needed, account.first_name AS account_first_name, account.last_name AS account_last_name, account.password AS account_password, account.phone AS account_phone, account.barcode AS account_barcode, account.cell_key AS account_cell_key, account.code AS account_code, account.date_created AS account_date_created, account.jobtitle AS account_jobtitle, account.linked_delivery_point_id AS account_linked_delivery_point_id, account.patronymic AS account_patronymic, account.pinfl AS account_pinfl, account.warehouse_id AS account_warehouse_id, account.zone_id AS account_zone_id, account.role_wms_id AS account_role_wms_id, account.language_code AS account_language_code, account.profile_pic AS account_profile_pic, account.cabinet_type AS account_cabinet_type, account.company_id AS account_company_id FROM account WHERE account.wms_id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.31s ago] {'pk_1': 10011} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.invoice_number, invoice.invoice_status FROM shaded_id JOIN sku ON shaded_id.id = sku.shaded_id_id JOIN barcode_info ON sku.id = barcode_info.sku_id JOIN cart_item ON barcode_info.id = cart_item.barcode_info_id JOIN cart ON cart.id = cart_item.cart_id JOIN invoice ON invoice.id = cart.invoice_id WHERE shaded_id.external IN (%(external_1_1)s, %(external_1_2)s) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.26s ago] {'external_1_1': 483033521020219, 'external_1_2': 8955341197741} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT shaded_id.external AS external_sku_id, shaded_id.internal AS internal_sku_id, barcode_info.barcode, sku.name, sku_picture.url, CAST(sku.purchase_price AS FLOAT) AS purchase_price, cart_item.quantity, cart_item.currency FROM sku LEFT OUTER JOIN shaded_id ON sku.shaded_id_id = shaded_id.id LEFT OUTER JOIN barcode_info ON sku.id = barcode_info.sku_id LEFT OUTER JOIN sku_picture ON sku.id = sku_picture.sku_id LEFT OUTER JOIN cart_item ON barcode_info.id = cart_item.barcode_info_id WHERE shaded_id.external IN (%(external_1_1)s, %(external_1_2)s) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.26s ago] {'external_1_1': 483033521020219, 'external_1_2': 8955341197741} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-05T23:24:14.294641", "type": "request", "method": "POST", "url": "https://dm-ff-be-service-stock.k8s-review.dailymail-tech.uz/qa-api/v1/pull-stock-records", "headers": {"x-aer-mock-hub": "true", "x-aer-mock-lp": "true", "x-aer-mock-ff": "true", "x-aer-mock-yandex-bond": "true", "x-aer-mock-egov-uz": "true", "x-aer-mock-tmg": "true", "Authorization": "Bearer 1ce1a4b5-5b8b-4b70-b2e1-f58432598032", "x-aer-mesh": "dm-hub-service-package:master;dm-hub-service-package-external:master;dm-hub-service-sorting:master;dm-hub-service-asn:master;dm-hub-service-inbound:master;dm-hub-service-meta:master;dm-hub-service-configuration:master;dm-hub-service-packing:master;dm-hub-service-dispatch:master;dm-hub-service-label:master;dm-hub-service-storage:master;dm-hub-service-cargo:master;dm-hub-service-country:master;dm-hub-service-customs:master;dm-hub-service-document:master;dm-hub-service-email:master;dm-hub-service-file-storage:master;dm-hub-service-inspection:master;dm-hub-service-osl:master;dm-hub-service-partners:master;dm-hub-service-report:master;dm-hub-service-settings:master;dm-hub-service-short-link:master;dm-hub-service-templates:master;dm-hub-service-tracking:master;dm-hub-service-transliteration:master;dm-hub-service-processing:master;dm-hub-api-cargo-carrier:master;dm-hub-api-fe:master;dm-hub-api-ff:master;dm-hub-api-wms:master;dm-hub-api-aer:master;dm-hub-api-joom:master;dm-hub-api-gateway:master;dm-hub-api-partners:master;dm-hub-api-pochta-global:master;dm-hub-api-public:master;dm-hub-api-wildberries:master;dm-hub-api-internal:master;dm-hub-daemon-package-process:master;dm-hub-daemon-tracking:master;dm-hub-integration-ff:master;dm-hub-integration-aer:master;dm-hub-integration-cainiao:master;dm-hub-integration-cargo-carrier:master;dm-hub-integration-gtt:master;dm-hub-integration-kazpost:master;dm-hub-integration-kgpost:master;dm-hub-integration-partners:master;dm-hub-integration-post:master;dm-hub-integration-rupost:master;dm-hub-integration-telegram:master;dm-hub-integration-upu:master;dm-hub-integration-wms:master;dm-hub-workflow-asn:master;dm-hub-workflow-email:master;dm-hub-workflow-hub-external:master;dm-hub-workflow-hub-internal:master;dm-hub-workflow-integration:master;dm-hub-workflow-package:master;dm-hub-workflow-tracking:master"}, "params": {"internalIds": 4100000000000042942}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-05T23:24:14.325439", "type": "response", "method": "POST", "url": "https://dm-ff-be-service-stock.k8s-review.dailymail-tech.uz/qa-api/v1/pull-stock-records?internalIds=4100000000000042942", "status_code": 200, "trace_id": null, "headers": {}, "body": "[{\"id\":\"null_4100000000000042942_1693627\",\"internalSkuId\":4100000000000042942,\"externalSkuId\":483033521020219,\"barcode\":null,\"provider\":\"YA\",\"quantityActive\":0,\"quantityPending\":0,\"quantityOverage\":0,\"quantityUnknown\":0,\"quantityDefected\":0,\"quantityMissing\":0,\"warehouseId\":1693627,\"synchronized\":false,\"synchronizedTime\":\"2026-02-06T04:24:14.322+05:00\",\"showcaseQuantity\":0}]", "elapsed_time": 0.02956, "reason": "OK"} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT stock.id, stock.internal_sku_id, stock.external_sku_id, stock.provider, stock.quantity_active, stock.quantity_pending, stock.quantity_overage, stock.quantity_unknown, stock.quantity_defected, stock.quantity_missing, stock.warehouse_id, stock.synchronized, stock.synchronized_time, stock.barcode FROM stock WHERE stock.internal_sku_id = %(internal_sku_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.23s ago] {'internal_sku_id_1': 4100000000000042942} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE stock SET quantity_active=%(quantity_active)s WHERE stock.internal_sku_id = %(internal_sku_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.23s ago] {'quantity_active': 7, 'internal_sku_id_1': 4100000000000042942} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-05T23:24:14.331251", "type": "request", "method": "POST", "url": "https://dm-ff-be-service-stock.k8s-review.dailymail-tech.uz/qa-api/v1/pull-stock-records", "headers": {"x-aer-mock-hub": "true", "x-aer-mock-lp": "true", "x-aer-mock-ff": "true", "x-aer-mock-yandex-bond": "true", "x-aer-mock-egov-uz": "true", "x-aer-mock-tmg": "true", "Authorization": "Bearer 1ce1a4b5-5b8b-4b70-b2e1-f58432598032", "x-aer-mesh": "dm-hub-service-package:master;dm-hub-service-package-external:master;dm-hub-service-sorting:master;dm-hub-service-asn:master;dm-hub-service-inbound:master;dm-hub-service-meta:master;dm-hub-service-configuration:master;dm-hub-service-packing:master;dm-hub-service-dispatch:master;dm-hub-service-label:master;dm-hub-service-storage:master;dm-hub-service-cargo:master;dm-hub-service-country:master;dm-hub-service-customs:master;dm-hub-service-document:master;dm-hub-service-email:master;dm-hub-service-file-storage:master;dm-hub-service-inspection:master;dm-hub-service-osl:master;dm-hub-service-partners:master;dm-hub-service-report:master;dm-hub-service-settings:master;dm-hub-service-short-link:master;dm-hub-service-templates:master;dm-hub-service-tracking:master;dm-hub-service-transliteration:master;dm-hub-service-processing:master;dm-hub-api-cargo-carrier:master;dm-hub-api-fe:master;dm-hub-api-ff:master;dm-hub-api-wms:master;dm-hub-api-aer:master;dm-hub-api-joom:master;dm-hub-api-gateway:master;dm-hub-api-partners:master;dm-hub-api-pochta-global:master;dm-hub-api-public:master;dm-hub-api-wildberries:master;dm-hub-api-internal:master;dm-hub-daemon-package-process:master;dm-hub-daemon-tracking:master;dm-hub-integration-ff:master;dm-hub-integration-aer:master;dm-hub-integration-cainiao:master;dm-hub-integration-cargo-carrier:master;dm-hub-integration-gtt:master;dm-hub-integration-kazpost:master;dm-hub-integration-kgpost:master;dm-hub-integration-partners:master;dm-hub-integration-post:master;dm-hub-integration-rupost:master;dm-hub-integration-telegram:master;dm-hub-integration-upu:master;dm-hub-integration-wms:master;dm-hub-workflow-asn:master;dm-hub-workflow-email:master;dm-hub-workflow-hub-external:master;dm-hub-workflow-hub-internal:master;dm-hub-workflow-integration:master;dm-hub-workflow-package:master;dm-hub-workflow-tracking:master"}, "params": {"internalIds": 4100000000000042943}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-05T23:24:14.361730", "type": "response", "method": "POST", "url": "https://dm-ff-be-service-stock.k8s-review.dailymail-tech.uz/qa-api/v1/pull-stock-records?internalIds=4100000000000042943", "status_code": 200, "trace_id": null, "headers": {}, "body": "[{\"id\":\"null_4100000000000042943_1693627\",\"internalSkuId\":4100000000000042943,\"externalSkuId\":8955341197741,\"barcode\":null,\"provider\":\"YA\",\"quantityActive\":0,\"quantityPending\":0,\"quantityOverage\":0,\"quantityUnknown\":0,\"quantityDefected\":0,\"quantityMissing\":0,\"warehouseId\":1693627,\"synchronized\":false,\"synchronizedTime\":\"2026-02-06T04:24:14.358+05:00\",\"showcaseQuantity\":0}]", "elapsed_time": 0.029318, "reason": "OK"} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT stock.id, stock.internal_sku_id, stock.external_sku_id, stock.provider, stock.quantity_active, stock.quantity_pending, stock.quantity_overage, stock.quantity_unknown, stock.quantity_defected, stock.quantity_missing, stock.warehouse_id, stock.synchronized, stock.synchronized_time, stock.barcode FROM stock WHERE stock.internal_sku_id = %(internal_sku_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.27s ago] {'internal_sku_id_1': 4100000000000042943} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE stock SET quantity_active=%(quantity_active)s WHERE stock.internal_sku_id = %(internal_sku_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.26s ago] {'quantity_active': 7, 'internal_sku_id_1': 4100000000000042943} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE batch SET invoice_document_number=%(invoice_document_number)s, invoice_document_date=%(invoice_document_date)s WHERE batch.invoice_id = %(invoice_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.19s ago] {'invoice_document_number': 'autotest_20260205_847', 'invoice_document_date': '2026-02-05 00:00:00.000000', 'invoice_id_1': '410000008471'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT zone.id, zone.key, zone.sort_key, zone.warehouse_id, zone.zone_stock_type, zone.for_global_inventory, zone.action, zone.activated, zone.creation_date, zone.deactivation_reason, zone.disable_date, zone.pattern, zone.title, zone.last_editor_id, zone.action_id FROM zone JOIN cell ON cell.zone_id = zone.id WHERE cell.key = %(key_1)s AND zone.warehouse_id = %(warehouse_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.19s ago] {'key_1': 'QA-70333853615001088', 'warehouse_id_1': 1693627} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT batch.id, batch.batch_number, batch.sku_id, batch.barcode, batch.warehouse_id, batch.invoice_id, batch.is_return, batch.invoice_barcode, batch.invoice_date_created, batch.invoice_date_placed, batch.date_production, batch.date_expired, batch.shelf_life, batch.purchase_price, batch.sell_price, batch.vat, batch.invoice_document_number, batch.currency, batch.invoice_document_date FROM batch WHERE batch.sku_id = %(sku_id_1)s AND batch.barcode = %(barcode_1)s AND batch.invoice_id = %(invoice_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.18s ago] {'sku_id_1': 4100000000000042942, 'barcode_1': '966637326634', 'invoice_id_1': '410000008471'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT batch.id, batch.batch_number, batch.sku_id, batch.barcode, batch.warehouse_id, batch.invoice_id, batch.is_return, batch.invoice_barcode, batch.invoice_date_created, batch.invoice_date_placed, batch.date_production, batch.date_expired, batch.shelf_life, batch.purchase_price, batch.sell_price, batch.vat, batch.invoice_document_number, batch.currency, batch.invoice_document_date FROM batch WHERE batch.sku_id = %(sku_id_1)s AND batch.barcode = %(barcode_1)s AND batch.invoice_id = %(invoice_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.19s ago] {'sku_id_1': 4100000000000042943, 'barcode_1': '2269389969038', 'invoice_id_1': '410000008471'} 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, zone.id AS zone_id, zone.key AS zone_key, zone.sort_key AS zone_sort_key, zone.warehouse_id AS zone_warehouse_id, zone.zone_stock_type AS zone_zone_stock_type, zone.for_global_inventory AS zone_for_global_inventory, zone.action AS zone_action, zone.activated AS zone_activated, zone.creation_date AS zone_creation_date, zone.deactivation_reason AS zone_deactivation_reason, zone.disable_date AS zone_disable_date, zone.pattern AS zone_pattern, zone.title AS zone_title, zone.last_editor_id AS zone_last_editor_id, zone.action_id AS zone_action_id FROM cell JOIN zone ON zone.id = cell.zone_id WHERE cell.key = %(key_1)s AND zone.warehouse_id = %(warehouse_id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.17s ago] {'key_1': , 'warehouse_id_1': 1693627, 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 INSERT INTO packing_table (barcode, warehouse_id, date_updated, big_bag_barcode, worker_id, workplace_id, box_barcode) VALUES (%(barcode)s, %(warehouse_id)s, %(date_updated)s, %(big_bag_barcode)s, %(worker_id)s, %(workplace_id)s, %(box_barcode)s) RETURNING packing_table.id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.03s ago] {'barcode': 'UP-QA-70333854999442944', 'warehouse_id': 1693627, 'date_updated': None, 'big_bag_barcode': None, 'worker_id': None, 'workplace_id': None, 'box_barcode': None} 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 packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 21.03s ago] {'pk_1': 98498} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:default.py:1713 select nextval('orders_id_seq') INFO sqlalchemy.engine.Engine:default.py:1713 [raw sql] {} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 SELECT orders.id, orders.barcode, orders.problematic, orders.status, orders.delivery_retry, orders.first_order, orders.order_id, orders.status_redelivery, orders.canceled_by_ff, orders.is_test, orders.assembly_blocked, orders.comment, orders.date_updated, orders.key, orders.price, orders.stock_id, orders.date_created, orders.issue_code, orders.platform, orders.customer_id, orders.delivery_id, orders.trade_order_id, orders.cut_off, orders.handover_list_id, orders.logistic_order_id, orders.platform_tracking_code, orders.canceled_at, orders.weight, orders.order_sticker_url, orders.canceled_reason, orders.currency, orders.logistic_template_id, orders.transit_country, orders.external_order_id FROM orders WHERE orders.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 20.9s ago] {'order_id_1': 8900636} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-05T23:24:15.005810", "type": "request", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/supply/ya/api/v1/order", "headers": {"x-aer-mock-hub": "true", "x-aer-mock-lp": "true", "x-aer-mock-ff": "true", "x-aer-mock-yandex-bond": "true", "x-aer-mock-egov-uz": "true", "x-aer-mock-tmg": "true", "Authorization": "Bearer 4a33ac47-f60c-40f5-a663-910697639d87", "x-aer-mesh": "dm-hub-service-package:master;dm-hub-service-package-external:master;dm-hub-service-sorting:master;dm-hub-service-asn:master;dm-hub-service-inbound:master;dm-hub-service-meta:master;dm-hub-service-configuration:master;dm-hub-service-packing:master;dm-hub-service-dispatch:master;dm-hub-service-label:master;dm-hub-service-storage:master;dm-hub-service-cargo:master;dm-hub-service-country:master;dm-hub-service-customs:master;dm-hub-service-document:master;dm-hub-service-email:master;dm-hub-service-file-storage:master;dm-hub-service-inspection:master;dm-hub-service-osl:master;dm-hub-service-partners:master;dm-hub-service-report:master;dm-hub-service-settings:master;dm-hub-service-short-link:master;dm-hub-service-templates:master;dm-hub-service-tracking:master;dm-hub-service-transliteration:master;dm-hub-service-processing:master;dm-hub-api-cargo-carrier:master;dm-hub-api-fe:master;dm-hub-api-ff:master;dm-hub-api-wms:master;dm-hub-api-aer:master;dm-hub-api-joom:master;dm-hub-api-gateway:master;dm-hub-api-partners:master;dm-hub-api-pochta-global:master;dm-hub-api-public:master;dm-hub-api-wildberries:master;dm-hub-api-internal:master;dm-hub-daemon-package-process:master;dm-hub-daemon-tracking:master;dm-hub-integration-ff:master;dm-hub-integration-aer:master;dm-hub-integration-cainiao:master;dm-hub-integration-cargo-carrier:master;dm-hub-integration-gtt:master;dm-hub-integration-kazpost:master;dm-hub-integration-kgpost:master;dm-hub-integration-partners:master;dm-hub-integration-post:master;dm-hub-integration-rupost:master;dm-hub-integration-telegram:master;dm-hub-integration-upu:master;dm-hub-integration-wms:master;dm-hub-workflow-asn:master;dm-hub-workflow-email:master;dm-hub-workflow-hub-external:master;dm-hub-workflow-hub-internal:master;dm-hub-workflow-integration:master;dm-hub-workflow-package:master;dm-hub-workflow-tracking:master"}, "json": {"id": 8900636, "dateCreated": "2026-02-05T23:24:15Z", "deliveryDate": "2026-02-06T11:00:00Z", "delivery": {"address": "к. Урюпинск, наб. Нижняя, д. 3 стр. 4/7, 083013", "timeFrom": "2026-02-05T23:24:15Z", "timeTo": "2026-02-06T11:00:00Z", "type": "RU_POST", "lastMile": "YaMarket", "lastMileId": 12, "firstMileId": 12, "orderSource": "YaMarket"}, "orderItems": [{"skuId": 483033521020219, "amount": 7, "currency": "RUR", "purchasePrice": 25053, "paymentPrice": 97281, "tradeOrderId": null}, {"skuId": 8955341197741, "amount": 7, "currency": "RUR", "purchasePrice": 84378, "paymentPrice": 68604, "tradeOrderId": null}], "price": 4646, "stockId": "WH_TASHKENT", "tradeOrderId": 70333855004270336, "cutOff": "2026-02-06T11:00:00Z", "currency": "RUR", "transitCountry": "KG", "isTest": true, "platformTrackingCode": 8900636}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-05T23:24:15.035874", "type": "response", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/supply/ya/api/v1/order", "status_code": 200, "trace_id": null, "headers": {}, "body": "", "elapsed_time": 0.028794, "reason": "OK"} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT orders.id, orders.barcode, orders.problematic, orders.status, orders.delivery_retry, orders.first_order, orders.order_id, orders.status_redelivery, orders.canceled_by_ff, orders.is_test, orders.assembly_blocked, orders.comment, orders.date_updated, orders.key, orders.price, orders.stock_id, orders.date_created, orders.issue_code, orders.platform, orders.customer_id, orders.delivery_id, orders.trade_order_id, orders.cut_off, orders.handover_list_id, orders.logistic_order_id, orders.platform_tracking_code, orders.canceled_at, orders.weight, orders.order_sticker_url, orders.canceled_reason, orders.currency, orders.logistic_template_id, orders.transit_country, orders.external_order_id FROM orders WHERE orders.platform_tracking_code = %(platform_tracking_code_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 20.88s ago] {'platform_tracking_code_1': '8900636'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT orders.id, orders.barcode, orders.problematic, orders.status, orders.delivery_retry, orders.first_order, orders.order_id, orders.status_redelivery, orders.canceled_by_ff, orders.is_test, orders.assembly_blocked, orders.comment, orders.date_updated, orders.key, orders.price, orders.stock_id, orders.date_created, orders.issue_code, orders.platform, orders.customer_id, orders.delivery_id, orders.trade_order_id, orders.cut_off, orders.handover_list_id, orders.logistic_order_id, orders.platform_tracking_code, orders.canceled_at, orders.weight, orders.order_sticker_url, orders.canceled_reason, orders.currency, orders.logistic_template_id, orders.transit_country, orders.external_order_id FROM orders WHERE orders.platform_tracking_code = %(platform_tracking_code_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 23.07s ago] {'platform_tracking_code_1': '8900636'} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00020s] {'barcode': , 'barcode_1': } INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 25.86s ago] {'barcode': , 'wms_id_1': 100325} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 25.11s ago] {'barcode': , 'wms_id_1': 10011} 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 25.13s ago] {'pk_1': 479887} 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': 479887} 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.00012s] {'param_1': 479887} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user FROM sku_cell WHERE %(param_1)s = sku_cell.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] {'param_1': 479887} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id FROM sku_cell_barcode_info WHERE %(param_1)s = sku_cell_barcode_info.cell_id INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] {'param_1': 479887} 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': 479887} 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 25.15s ago] {'pk_1': 479888} 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.01848s ago] {'param_1': 479888} 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.01608s ago] {'param_1': 479888} 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.01518s ago] {'param_1': 479888} 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.01524s ago] {'param_1': 479888} 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.01449s ago] {'id': 479888} 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 25.17s ago] {'pk_1': 479889} 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.03186s ago] {'param_1': 479889} 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.03098s ago] {'param_1': 479889} 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.03017s ago] {'param_1': 479889} 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.02935s ago] {'param_1': 479889} 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.02833s ago] {'id': 479889} 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 25.18s ago] {'pk_1': 479890} 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.04728s ago] {'param_1': 479890} 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.04559s ago] {'param_1': 479890} 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.04471s ago] {'param_1': 479890} 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.04377s ago] {'param_1': 479890} 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.04277s ago] {'id': 479890} 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 25.2s ago] {'pk_1': 479891} 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.06128s ago] {'param_1': 479891} 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.05971s ago] {'param_1': 479891} 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.05881s ago] {'param_1': 479891} 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.05786s ago] {'param_1': 479891} 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.05682s ago] {'id': 479891} 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 25.21s ago] {'pk_1': 479892} 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.07424s ago] {'param_1': 479892} 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.07172s ago] {'param_1': 479892} 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.07086s ago] {'param_1': 479892} 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.06992s ago] {'param_1': 479892} 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.06901s ago] {'id': 479892} 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 25.22s ago] {'pk_1': 479893} 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.08653s ago] {'param_1': 479893} 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.08378s ago] {'param_1': 479893} 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.08292s ago] {'param_1': 479893} 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.08194s ago] {'param_1': 479893} 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.08084s ago] {'id': 479893} 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 25.23s ago] {'pk_1': 479894} 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.09792s ago] {'param_1': 479894} 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.09522s ago] {'param_1': 479894} 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.0943s ago] {'param_1': 479894} 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.09325s ago] {'param_1': 479894} 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.09208s ago] {'id': 479894} 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 25.25s ago] {'pk_1': 479895} 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.1091s ago] {'param_1': 479895} 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.1063s ago] {'param_1': 479895} 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.1059s ago] {'param_1': 479895} 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.105s ago] {'param_1': 479895} 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.1039s ago] {'id': 479895} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 25.99s ago] {'barcode': , 'wms_id_1': 100299} 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 25.26s ago] {'pk_1': 479896} 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.1228s ago] {'param_1': 479896} 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.1201s ago] {'param_1': 479896} 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.1196s ago] {'param_1': 479896} 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.1187s ago] {'param_1': 479896} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'cell_id': None, 'reservation_id': 38879631} 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 25.27s ago] {'pk_1': 479896} 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.1364s ago] {'param_1': 479896} 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.1337s ago] {'param_1': 479896} 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.1329s ago] {'param_1': 479896} 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.132s ago] {'param_1': 479896} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01259s ago] {'cell_id': None, 'reservation_id': 38879631} 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 25.28s ago] {'pk_1': 479896} 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.1464s ago] {'param_1': 479896} 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.1438s ago] {'param_1': 479896} 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.143s ago] {'param_1': 479896} 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.1424s ago] {'param_1': 479896} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02328s ago] {'cell_id': None, 'reservation_id': 38879631} 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 UPDATE picking_task SET worker_id=%(worker_id)s WHERE picking_task.id = %(id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] {'worker_id': 0, 'id_1': 1497071} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE sorting_task SET status=%(status)s WHERE sorting_task.worker_id = %(worker_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] {'status': , 'worker_id_1': 33349} 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 assembly_wall_cell SET status=%(status)s, current_assembly_id=%(current_assembly_id)s WHERE assembly_wall_cell.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00010s] {'status': , 'current_assembly_id': None, 'barcode_1': '12.12.1.49'} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 26.06s ago] {'barcode': , 'wms_id_1': 100265} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 23.64s ago] {'pk_1': 98493} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00013s] {'param_1': 98493} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00013s] {'id': 98493} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 26.11s ago] {'barcode': , 'wms_id_1': 100265} 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 sorting_task SET status=%(status)s WHERE sorting_task.worker_id = %(worker_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.07295s ago] {'status': , 'worker_id_1': 33349} 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 assembly_wall_cell SET status=%(status)s, current_assembly_id=%(current_assembly_id)s WHERE assembly_wall_cell.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.07659s ago] {'status': , 'current_assembly_id': None, 'barcode_1': '12.12.1.49'} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 23.72s ago] {'pk_1': 98495} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.07501s ago] {'param_1': 98495} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.07445s ago] {'id': 98495} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 26.18s ago] {'barcode': , 'wms_id_1': 100009} 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 25.45s ago] {'pk_1': 479898} 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.317s ago] {'param_1': 479898} 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.3161s ago] {'param_1': 479898} 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.3152s ago] {'param_1': 479898} 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.3144s ago] {'param_1': 479898} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1956s ago] {'cell_id': None, 'reservation_id': 38879634} 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 25.47s ago] {'pk_1': 479898} 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.3297s ago] {'param_1': 479898} 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.3281s ago] {'param_1': 479898} 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.3273s ago] {'param_1': 479898} 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.3264s ago] {'param_1': 479898} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2073s ago] {'cell_id': None, 'reservation_id': 38879634} 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 25.48s ago] {'pk_1': 479898} 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.3422s ago] {'param_1': 479898} 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.3399s ago] {'param_1': 479898} 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.3391s ago] {'param_1': 479898} 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.3381s ago] {'param_1': 479898} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2197s ago] {'cell_id': None, 'reservation_id': 38879634} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 26.22s ago] {'barcode': , 'wms_id_1': 100273} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 23.81s ago] {'pk_1': 98496} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1642s ago] {'param_1': 98496} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1632s ago] {'id': 98496} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 26.27s ago] {'barcode': , 'wms_id_1': 100342} 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 25.54s ago] {'pk_1': 479899} 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.4057s ago] {'param_1': 479899} 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.4045s ago] {'param_1': 479899} 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.4041s ago] {'param_1': 479899} 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.4032s ago] {'param_1': 479899} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2843s ago] {'cell_id': None, 'reservation_id': 38879635} 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 25.55s ago] {'pk_1': 479899} 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.4186s ago] {'param_1': 479899} 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.4166s ago] {'param_1': 479899} 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.4159s ago] {'param_1': 479899} 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.4151s ago] {'param_1': 479899} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2957s ago] {'cell_id': None, 'reservation_id': 38879635} 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 25.57s ago] {'pk_1': 479899} 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.4318s ago] {'param_1': 479899} 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.43s ago] {'param_1': 479899} 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.4294s ago] {'param_1': 479899} 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.4286s ago] {'param_1': 479899} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3099s ago] {'cell_id': None, 'reservation_id': 38879635} INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 26.31s ago] {'barcode': , 'wms_id_1': 100234} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 23.9s ago] {'pk_1': 98497} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2535s ago] {'param_1': 98497} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2533s ago] {'id': 98497} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 26.36s ago] {'barcode': , 'wms_id_1': 100325} 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 25.63s ago] {'pk_1': 479900} 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.4954s ago] {'param_1': 479900} 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.4938s ago] {'param_1': 479900} 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.4938s ago] {'param_1': 479900} 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.4931s ago] {'param_1': 479900} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00013s] [{'cell_id': None, 'reservation_id': 38879636}, {'cell_id': None, 'reservation_id': 38879637}] 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 25.64s ago] {'pk_1': 479900} 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.5095s ago] {'param_1': 479900} 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.5087s ago] {'param_1': 479900} 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.508s ago] {'param_1': 479900} 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.5077s ago] {'param_1': 479900} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.01435s ago] [{'cell_id': None, 'reservation_id': 38879636}, {'cell_id': None, 'reservation_id': 38879637}] 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 25.66s ago] {'pk_1': 479900} 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.5232s ago] {'param_1': 479900} 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.5216s ago] {'param_1': 479900} 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.5208s ago] {'param_1': 479900} 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.5202s ago] {'param_1': 479900} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE reservation SET cell_id=%(cell_id)s WHERE reservation.id = %(reservation_id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02667s ago] [{'cell_id': None, 'reservation_id': 38879636}, {'cell_id': None, 'reservation_id': 38879637}] INFO sqlalchemy.engine.Engine:base.py:2713 ROLLBACK using DBAPI connection.rollback(); set skip_autocommit_rollback to prevent fully INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 26.4s ago] {'barcode': , 'wms_id_1': 100325} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 23.99s ago] {'pk_1': 98498} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id AS box_id, box.barcode AS box_barcode, box.warehouse_id AS box_warehouse_id, box.picking_task_id AS box_picking_task_id, box.status AS box_status, box.stock_return_task_id AS box_stock_return_task_id, box.inventory_task_id AS box_inventory_task_id, box.packing_table_id AS box_packing_table_id, box.consolidation_cell_pre_id AS box_consolidation_cell_pre_id, box.consolidation_cell_id AS box_consolidation_cell_id, box.sorting_task_id AS box_sorting_task_id FROM box WHERE %(param_1)s = box.packing_table_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3444s ago] {'param_1': 98498} INFO sqlalchemy.engine.Engine:base.py:1846 DELETE FROM packing_table WHERE packing_table.id = %(id)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3435s ago] {'id': 98498} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode