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 118s 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 118s ago] {'pk_1': 100037} 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 118s ago] {'barcode': , 'wms_id_1': 100037} 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 117.9s ago] {'key': 'QA-70594329584667136', 'zone_id': , 'cell_picking_type': , 'barcode': None, 'old_barcode': '2026-02-08T23:45:29.584682', '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 117.9s ago] {'pk_1': 480220} 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 117.9s 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 117.9s ago] {'barcode': , 'wms_id_1': 10279} 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 117.9s ago] {'pk_1': 10279} 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) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 117.5s ago] {'external_1_1': 6916478896} 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) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 117.5s ago] {'external_1_1': 6916478896} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-08T23:45:30.020369", "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 c969e268-2f41-42da-972d-26f1638dfd9a", "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": 4100000000000043344}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-08T23:45:30.052281", "type": "response", "method": "POST", "url": "https://dm-ff-be-service-stock.k8s-review.dailymail-tech.uz/qa-api/v1/pull-stock-records?internalIds=4100000000000043344", "status_code": 200, "trace_id": null, "headers": {}, "body": "[{\"id\":\"null_4100000000000043344_1693627\",\"internalSkuId\":4100000000000043344,\"externalSkuId\":6916478896,\"barcode\":null,\"provider\":\"YA\",\"quantityActive\":0,\"quantityPending\":0,\"quantityOverage\":0,\"quantityUnknown\":0,\"quantityDefected\":0,\"quantityMissing\":0,\"warehouseId\":1693627,\"synchronized\":false,\"synchronizedTime\":\"2026-02-09T04:45:30.049+05:00\",\"showcaseQuantity\":0}]", "elapsed_time": 0.03068, "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 117.5s ago] {'internal_sku_id_1': 4100000000000043344} 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 117.5s ago] {'quantity_active': 3, 'internal_sku_id_1': 4100000000000043344} 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 117.4s ago] {'invoice_document_number': 'autotest_20260208_652', 'invoice_document_date': '2026-02-08 00:00:00.000000', 'invoice_id_1': '410000008745'} 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 117.4s ago] {'key_1': 'QA-70594329584667136', '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 117.4s ago] {'sku_id_1': 4100000000000043344, 'barcode_1': '595863364200016', 'invoice_id_1': '410000008745'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT return_gate.id, return_gate.barcode, return_gate.warehouse_id, return_gate.task_id, count(return_gate_cell.barcode) AS "FreeCellsCount" FROM return_gate JOIN return_gate_cell ON return_gate.id = return_gate_cell.return_gate_id WHERE return_gate_cell.status = %(status_1)s AND return_gate_cell.task_id IS NULL AND return_gate_cell.worker_id IS NULL AND return_gate.warehouse_id = %(warehouse_id_1)s GROUP BY return_gate.id, return_gate.barcode, return_gate.warehouse_id, return_gate.task_id INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 109.1s ago] {'status_1': , 'warehouse_id_1': 1693627} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-08T23:45:30.575085", "type": "request", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/ff/publish/invoice/seller-return", "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 86693149-9c0e-4c53-bd8b-178886d45e99", "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": {"warehouseId": 1693627, "sellerId": 9999999999, "sellerFullName": "QA seller Пропадать угол заявление.", "customer": "QA customer Заплакать развитый.", "fulfillmentReturnId": 70594330572906, "chunkNumber": 1, "chunkAmount": 1, "b2b": true, "returnItems": [{"skuId": 4100000000000043344, "amount": 13}], "fromDefected": null, "arrivalIntervalFrom": "2026-02-08T23:45:30Z", "arrivalIntervalTo": "2026-02-09T23:45:30Z", "phoneNumber": "+79999999999", "isTest": true, "scanSerialNumber": false, "scanImei": false}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-08T23:45:30.589430", "type": "response", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/ff/publish/invoice/seller-return", "status_code": 200, "trace_id": null, "headers": {}, "body": "{}", "elapsed_time": 0.013139, "reason": "OK"} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT orders.dtype, orders.id, orders.barcode, orders.key, orders.status, orders.warehouse_id, orders.is_test, orders.is_replenishment_needed, orders.cancel_needed, orders.is_placed_to_sorting_wall_cell, orders.comment, orders.date_assembled, orders.date_assembly_started, orders.date_created, orders.date_updated, orders.delivery_date, orders.wall_cell_key, orders.work_place_id, orders.worker_id, orders.order_id, orders.assembly_group_id, orders.handover_list_id, orders.logistic_order_id, orders.trade_order_id, orders.cut_off, orders.last_mile, orders.last_mile_id, orders.platform_tracking_code, orders.canceled_by_ff, orders.canceled_at, orders.was_weighted, orders.weight, orders.is_mono, orders.is_packing_processed, orders.work_place, orders.expected_weight, orders.first_mile_id, orders.problematic_reason, orders.business_task_id, orders.order_type, orders.seller_id, orders.seller_name, orders.is_awb, orders.big_bag_barcode, orders.logistic_template_id, orders.assembly_wall_group_id, orders.wave_id, orders.first_cut_off, orders.actual_weight, orders.external_order_id, orders.order_source, orders.complete_retry_count FROM orders WHERE orders.business_task_id = %(business_task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 117.3s ago] {'business_task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT orders.dtype, orders.id, orders.barcode, orders.key, orders.status, orders.warehouse_id, orders.is_test, orders.is_replenishment_needed, orders.cancel_needed, orders.is_placed_to_sorting_wall_cell, orders.comment, orders.date_assembled, orders.date_assembly_started, orders.date_created, orders.date_updated, orders.delivery_date, orders.wall_cell_key, orders.work_place_id, orders.worker_id, orders.order_id, orders.assembly_group_id, orders.handover_list_id, orders.logistic_order_id, orders.trade_order_id, orders.cut_off, orders.last_mile, orders.last_mile_id, orders.platform_tracking_code, orders.canceled_by_ff, orders.canceled_at, orders.was_weighted, orders.weight, orders.is_mono, orders.is_packing_processed, orders.work_place, orders.expected_weight, orders.first_mile_id, orders.problematic_reason, orders.business_task_id, orders.order_type, orders.seller_id, orders.seller_name, orders.is_awb, orders.big_bag_barcode, orders.logistic_template_id, orders.assembly_wall_group_id, orders.wave_id, orders.first_cut_off, orders.actual_weight, orders.external_order_id, orders.order_source, orders.complete_retry_count FROM orders WHERE orders.business_task_id = %(business_task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 119s ago] {'business_task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT task.id, task.from_defected, task.fulfillment_return_id, task.seller_id, task.seller_name, task.status, task.type, task.warehouse_id, task.must_be_canceled, task.canceled_sent_to_ff, task.has_datamatrix, task.dm_shipped, task.is_test, task.scan_serial_number, task.scan_imei, task.date_created, task.date_updated, task.shipment_date, task.customer, task.return_gate_id, task.arrival_interval_from, task.arrival_interval_to, task.phone_number, task.chunk_amount FROM task WHERE task.fulfillment_return_id = %(fulfillment_return_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 117.1s ago] {'fulfillment_return_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT task_item.id, task_item.date_created, task_item.date_updated, task_item.sku_id, task_item.expected_amount, task_item.status, task_item.has_imei, task_item.reserved_amount, task_item.returned_amount, task_item.picked_amount, task_item.comment, task_item.order_barcode, task_item.task_id, task_item.key, task_item.has_datamatrix, task_item.chunk_number, task_item.description, task_item.image_url FROM task_item WHERE task_item.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 109.1s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT picking_sku_cell.id, picking_sku_cell.amount, picking_sku_cell.assembly_wall_amount, picking_sku_cell.canceled_amount, picking_sku_cell.cell_id, picking_sku_cell.cell_key, picking_sku_cell.picked_amount, picking_sku_cell.sorted_amount, picking_sku_cell.status, picking_sku_cell.sku_id, picking_sku_cell.assembly_group_id, picking_sku_cell.date_created, picking_sku_cell.date_updated, picking_sku_cell.old_cell_key, picking_sku_cell.reservation_key, picking_sku_cell.update_reservation_key, picking_sku_cell.uuid, picking_sku_cell.zone_id, picking_sku_cell.zone_sort_key, picking_sku_cell.picking_task_id, picking_sku_cell.box_barcodes, picking_sku_cell.allowed_barcodes, picking_sku_cell.picking_order, picking_sku_cell.delivery_point_id FROM picking_sku_cell WHERE picking_sku_cell.reservation_key LIKE %(reservation_key_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 109.1s ago] {'reservation_key_1': '%159945-70594330572906%'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT count(*) AS count_1 FROM business_sku_cell_queue_record WHERE business_sku_cell_queue_record.wave_id = %(wave_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 109s ago] {'wave_id_1': 7059433057290600} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT count(*) AS count_1 FROM business_sku_cell_queue_record WHERE business_sku_cell_queue_record.wave_id = %(wave_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 109s ago] {'wave_id_1': 7059433057290600} 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 109s ago] {'key_1': , 'warehouse_id_1': 1693627, 'param_1': 1} 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 business_sku_cell_queue_record.id, business_sku_cell_queue_record.cell_id, business_sku_cell_queue_record.cell_key, business_sku_cell_queue_record.position_in_wave, business_sku_cell_queue_record.taken, business_sku_cell_queue_record.sku_cell_id, business_sku_cell_queue_record.wave_id, business_sku_cell_queue_record.date_created, business_sku_cell_queue_record.date_updated, business_sku_cell_queue_record.zone_id FROM business_sku_cell_queue_record WHERE business_sku_cell_queue_record.wave_id = %(wave_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 108.9s ago] {'wave_id_1': 7059433057290600} 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 picking_task.id, picking_task.date_created, picking_task.date_assigned, picking_task.date_finished, picking_task.cell_amount, picking_task.worker_id, picking_task.status, picking_task.wave_id, picking_task.zone_name, picking_task.task_id FROM picking_task WHERE picking_task.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 108.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT picking_task.id, picking_task.date_created, picking_task.date_assigned, picking_task.date_finished, picking_task.cell_amount, picking_task.worker_id, picking_task.status, picking_task.wave_id, picking_task.zone_name, picking_task.task_id FROM picking_task WHERE picking_task.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 113.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT picking_task.id, picking_task.date_created, picking_task.date_assigned, picking_task.date_finished, picking_task.cell_amount, picking_task.worker_id, picking_task.status, picking_task.wave_id, picking_task.zone_name, picking_task.task_id FROM picking_task WHERE picking_task.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 118.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT picking_task.id, picking_task.date_created, picking_task.date_assigned, picking_task.date_finished, picking_task.cell_amount, picking_task.worker_id, picking_task.status, picking_task.wave_id, picking_task.zone_name, picking_task.task_id FROM picking_task WHERE picking_task.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 123.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT picking_task.id, picking_task.date_created, picking_task.date_assigned, picking_task.date_finished, picking_task.cell_amount, picking_task.worker_id, picking_task.status, picking_task.wave_id, picking_task.zone_name, picking_task.task_id FROM picking_task WHERE picking_task.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 128.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT picking_task.id, picking_task.date_created, picking_task.date_assigned, picking_task.date_finished, picking_task.cell_amount, picking_task.worker_id, picking_task.status, picking_task.wave_id, picking_task.zone_name, picking_task.task_id FROM picking_task WHERE picking_task.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 133.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT picking_task.id, picking_task.date_created, picking_task.date_assigned, picking_task.date_finished, picking_task.cell_amount, picking_task.worker_id, picking_task.status, picking_task.wave_id, picking_task.zone_name, picking_task.task_id FROM picking_task WHERE picking_task.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 138.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT picking_task.id, picking_task.date_created, picking_task.date_assigned, picking_task.date_finished, picking_task.cell_amount, picking_task.worker_id, picking_task.status, picking_task.wave_id, picking_task.zone_name, picking_task.task_id FROM picking_task WHERE picking_task.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 143.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT picking_task.id, picking_task.date_created, picking_task.date_assigned, picking_task.date_finished, picking_task.cell_amount, picking_task.worker_id, picking_task.status, picking_task.wave_id, picking_task.zone_name, picking_task.task_id FROM picking_task WHERE picking_task.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 148.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT picking_task.id, picking_task.date_created, picking_task.date_assigned, picking_task.date_finished, picking_task.cell_amount, picking_task.worker_id, picking_task.status, picking_task.wave_id, picking_task.zone_name, picking_task.task_id FROM picking_task WHERE picking_task.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 153.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT count(*) AS count_1 FROM business_sku_cell_queue_record WHERE business_sku_cell_queue_record.wave_id = %(wave_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 154.2s ago] {'wave_id_1': 7059433057290600} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT task_item.id, task_item.date_created, task_item.date_updated, task_item.sku_id, task_item.expected_amount, task_item.status, task_item.has_imei, task_item.reserved_amount, task_item.returned_amount, task_item.picked_amount, task_item.comment, task_item.order_barcode, task_item.task_id, task_item.key, task_item.has_datamatrix, task_item.chunk_number, task_item.description, task_item.image_url FROM task_item WHERE task_item.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 155.8s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT task_item.id, task_item.date_created, task_item.date_updated, task_item.sku_id, task_item.expected_amount, task_item.status, task_item.has_imei, task_item.reserved_amount, task_item.returned_amount, task_item.picked_amount, task_item.comment, task_item.order_barcode, task_item.task_id, task_item.key, task_item.has_datamatrix, task_item.chunk_number, task_item.description, task_item.image_url FROM task_item WHERE task_item.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 156.8s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT task_item.id, task_item.date_created, task_item.date_updated, task_item.sku_id, task_item.expected_amount, task_item.status, task_item.has_imei, task_item.reserved_amount, task_item.returned_amount, task_item.picked_amount, task_item.comment, task_item.order_barcode, task_item.task_id, task_item.key, task_item.has_datamatrix, task_item.chunk_number, task_item.description, task_item.image_url FROM task_item WHERE task_item.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 157.8s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT task_item.id, task_item.date_created, task_item.date_updated, task_item.sku_id, task_item.expected_amount, task_item.status, task_item.has_imei, task_item.reserved_amount, task_item.returned_amount, task_item.picked_amount, task_item.comment, task_item.order_barcode, task_item.task_id, task_item.key, task_item.has_datamatrix, task_item.chunk_number, task_item.description, task_item.image_url FROM task_item WHERE task_item.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 158.9s ago] {'task_id_1': 70594330572906} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT task_item.id, task_item.date_created, task_item.date_updated, task_item.sku_id, task_item.expected_amount, task_item.status, task_item.has_imei, task_item.reserved_amount, task_item.returned_amount, task_item.picked_amount, task_item.comment, task_item.order_barcode, task_item.task_id, task_item.key, task_item.has_datamatrix, task_item.chunk_number, task_item.description, task_item.image_url FROM task_item WHERE task_item.task_id = %(task_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 159.9s ago] {'task_id_1': 70594330572906} 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 172.4s ago] {'barcode': , 'wms_id_1': 100037} 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 172.2s ago] {'barcode': , 'wms_id_1': 10279}