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 2336s 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 2336s ago] {'pk_1': 100328} 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 2336s ago] {'barcode': , 'wms_id_1': 100328} 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 2335s ago] {'key': 'QA-70282479113441536', 'zone_id': , 'cell_picking_type': , 'barcode': None, 'old_barcode': '2026-02-05T09:07:59.113451', '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 2335s ago] {'pk_1': 479777} 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 2335s 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 2335s ago] {'barcode': , 'wms_id_1': 10126} 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 2335s ago] {'pk_1': 10126} 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 2335s ago] {'external_1_1': 78548732744, 'external_1_2': 30218594654} 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 2335s ago] {'external_1_1': 78548732744, 'external_1_2': 30218594654} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-05T09:07:59.690524", "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 035e6ec8-c34e-4e2d-95e6-c5add514a120"}, "params": {"internalIds": 4100000000000042780}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-05T09:07:59.720203", "type": "response", "method": "POST", "url": "https://dm-ff-be-service-stock.k8s-review.dailymail-tech.uz/qa-api/v1/pull-stock-records?internalIds=4100000000000042780", "status_code": 200, "trace_id": null, "headers": {}, "body": "[{\"id\":\"null_4100000000000042780_1693627\",\"internalSkuId\":4100000000000042780,\"externalSkuId\":78548732744,\"barcode\":null,\"provider\":\"YA\",\"quantityActive\":0,\"quantityPending\":0,\"quantityOverage\":0,\"quantityUnknown\":0,\"quantityDefected\":0,\"quantityMissing\":0,\"warehouseId\":1693627,\"synchronized\":false,\"synchronizedTime\":\"2026-02-05T14:07:59.718+05:00\",\"showcaseQuantity\":0}]", "elapsed_time": 0.028892, "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 2335s ago] {'internal_sku_id_1': 4100000000000042780} 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 2335s ago] {'quantity_active': 5, 'internal_sku_id_1': 4100000000000042780} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-05T09:07:59.730089", "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 035e6ec8-c34e-4e2d-95e6-c5add514a120"}, "params": {"internalIds": 4100000000000042781}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-05T09:07:59.758769", "type": "response", "method": "POST", "url": "https://dm-ff-be-service-stock.k8s-review.dailymail-tech.uz/qa-api/v1/pull-stock-records?internalIds=4100000000000042781", "status_code": 200, "trace_id": null, "headers": {}, "body": "[{\"id\":\"null_4100000000000042781_1693627\",\"internalSkuId\":4100000000000042781,\"externalSkuId\":30218594654,\"barcode\":null,\"provider\":\"YA\",\"quantityActive\":0,\"quantityPending\":0,\"quantityOverage\":0,\"quantityUnknown\":0,\"quantityDefected\":0,\"quantityMissing\":0,\"warehouseId\":1693627,\"synchronized\":false,\"synchronizedTime\":\"2026-02-05T14:07:59.756+05:00\",\"showcaseQuantity\":0}]", "elapsed_time": 0.027968, "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 2335s ago] {'internal_sku_id_1': 4100000000000042781} 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 2335s ago] {'quantity_active': 5, 'internal_sku_id_1': 4100000000000042781} 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 2335s ago] {'invoice_document_number': 'autotest_20260205_392', 'invoice_document_date': '2026-02-05 00:00:00.000000', 'invoice_id_1': '410000008341'} 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 2335s ago] {'key_1': 'QA-70282479113441536', '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 2335s ago] {'sku_id_1': 4100000000000042780, 'barcode_1': '367231770921', 'invoice_id_1': '410000008341'} 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 2335s ago] {'sku_id_1': 4100000000000042781, 'barcode_1': '303407421126315', 'invoice_id_1': '410000008341'} 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 2333s 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 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 2333s ago] {'barcode': 'UP-QA-70282481070384128', '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 2333s ago] {'pk_1': 98402} 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:2710 BEGIN (implicit; DBAPI should not BEGIN 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 2333s ago] {'order_id_1': 8900485} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-05T09:08:01.131480", "type": "request", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/ff/publish/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 300a2fea-a6bc-40b1-8888-c0b308c6e58c"}, "json": {"barcode": "8900485", "dateUpdated": null, "id": 8900485, "dateCreated": "2026-02-05T09:08:01Z", "deliveryDate": "2026-02-06T11:00:00Z", "customer": {"id": 70282481130697472, "customerId": 70282481130697472, "contactsId": 0, "firstName": "Исидор", "lastName": "Носова", "phone": "+7 (071) 004-9806", "email": "kapiton40@example.com", "comment": "", "patronymic": ""}, "delivery": {"id": 70282481130804480, "address": "г. Бодайбо, ш. Портовое, д. 334, 952545", "entrance": "4", "floor": "4", "date": "2026-02-06T11:00:00Z", "timeFrom": "2026-02-05T09:08:01Z", "timeTo": "2026-02-06T11:00:00Z", "deliveryPointId": 13, "cityId": 11, "type": "RU_POST", "lastMile": "TANAIS", "lastMileId": 13, "firstMileId": 12, "orderSource": "GLOBAL"}, "orderItems": [{"id": 70282481130880512, "skuId": 4100000000000042780, "externalSkuId": 86674, "productId": 70282481130882560, "amount": 5, "currency": "RUB", "purchasePrice": 34844, "paymentPrice": 33825, "tradeOrderLineId": 70282481130884096, "publicSkuId": 70282481130889472}, {"id": 70282481130891008, "skuId": 4100000000000042781, "externalSkuId": 41602, "productId": 70282481130892032, "amount": 5, "currency": "RUB", "purchasePrice": 78992, "paymentPrice": 9647, "tradeOrderLineId": 70282481130893824, "publicSkuId": 70282481130895360}], "price": 7477, "promoCodeId": 0, "issueCode": 0, "comment": "", "stockId": 1693627, "tradeOrderId": 70282481104050432, "cutOff": "2026-02-06T11:00:00Z", "currency": "RUR", "transitCountry": "KG", "isTest": true, "platformTrackingCode": null}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-05T09:08:01.258741", "type": "response", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/ff/publish/order", "status_code": 200, "trace_id": null, "headers": {}, "body": "{}", "elapsed_time": 0.126272, "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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2333s ago] {'order_id_1': 8900485} 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 2336s ago] {'order_id_1': 8900485} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2334s ago] {'order_id_1': 8900485} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-05T09:08:04.269225", "type": "request", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/ff/publish/order/creation/result", "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 300a2fea-a6bc-40b1-8888-c0b308c6e58c"}, "json": {"wms_order_id": 8900485, "error_code": null, "message": null, "success": true, "data": {"logistic_order_id": 70282484269015552, "template_id": "WMS_QA_TEMPLETE", "handover_list_id": 702824842690268, "platform_tracking_code": "177028248426987", "cut_off_date": "2026-02-06T11:00:00Z", "provider_name": "TANAIS"}}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-05T09:08:04.284281", "type": "response", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/ff/publish/order/creation/result", "status_code": 200, "trace_id": null, "headers": {}, "body": "{}", "elapsed_time": 0.014209, "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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2336s ago] {'order_id_1': 8900485} 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 2339s ago] {'order_id_1': 8900485} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2337s ago] {'order_id_1': 8900485} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2337s ago] {'order_id_1': 8900485} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT order_item.id, order_item.adult, order_item.amount, order_item.content_hidden, order_item.order_item_id, order_item.product_group, order_item.returnable, order_item.returned_amount, order_item.order_id, order_item.blocked_by_weighing, order_item.date_created, order_item.date_updated, order_item.epn_commission, order_item.key, order_item.payment_price, order_item.problematic_amount, order_item.problematic_reason, order_item.purchase_price, order_item.seller_profit, order_item.sku_id, order_item.trade_order_line_id, order_item.currency, order_item.public_sku_id, order_item.product_id, order_item.expected_weight FROM order_item JOIN orders ON orders.id = order_item.order_id WHERE orders.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00088s] {'order_id_1': 8900485} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id, reservation.amount, reservation.canceled_amount, reservation.order_item_key, reservation.reservation_key, reservation.status, reservation.sku_id, reservation.cell_id, reservation.warehouse_id, reservation.is_refilled, reservation.date_created, reservation.date_updated, reservation.update_reservation_key FROM reservation WHERE reservation.order_item_key IN (%(order_item_key_1_1)s, %(order_item_key_1_2)s) INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00057s] {'order_item_key_1_1': '25093877-70282481130880512', 'order_item_key_1_2': '25093878-70282481130891008'} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2337s ago] {'order_id_1': 8900485} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT assembly_wall_group.id, assembly_wall_group.group_id, assembly_wall_group.warehouse_id, assembly_wall_group.is_active FROM assembly_wall_group JOIN assembly_wave ON assembly_wave.assembly_wall_group_id = assembly_wall_group.id WHERE assembly_wave.id = %(id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2336s ago] {'id_1': 158729} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2337s ago] {'order_id_1': 8900485} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT assembly_wave.id, assembly_wave.warehouse_id, assembly_wave.date_created, assembly_wave.order_type, assembly_wave.assembly_group_id, assembly_wave.assembly_wall_group_id FROM assembly_wave JOIN orders ON assembly_wave.id = orders.wave_id WHERE orders.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00049s] {'order_id_1': 8900485} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_queue_record.id, sku_cell_queue_record.cell_id, sku_cell_queue_record.cell_key, sku_cell_queue_record.position_in_wave, sku_cell_queue_record.taken, sku_cell_queue_record.sku_cell_id, sku_cell_queue_record.wave_id, sku_cell_queue_record.date_created, sku_cell_queue_record.date_updated, sku_cell_queue_record.zone_id FROM sku_cell_queue_record WHERE sku_cell_queue_record.wave_id = %(wave_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2336s ago] {'wave_id_1': 158729} 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 2340s ago] {'order_id_1': 8900485} 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 2343s ago] {'order_id_1': 8900485} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT order_item.id, order_item.adult, order_item.amount, order_item.content_hidden, order_item.order_item_id, order_item.product_group, order_item.returnable, order_item.returned_amount, order_item.order_id, order_item.blocked_by_weighing, order_item.date_created, order_item.date_updated, order_item.epn_commission, order_item.key, order_item.payment_price, order_item.problematic_amount, order_item.problematic_reason, order_item.purchase_price, order_item.seller_profit, order_item.sku_id, order_item.trade_order_line_id, order_item.currency, order_item.public_sku_id, order_item.product_id, order_item.expected_weight FROM order_item JOIN orders ON orders.id = order_item.order_id WHERE orders.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 3.557s ago] {'order_id_1': 8900485} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT reservation.id, reservation.amount, reservation.canceled_amount, reservation.order_item_key, reservation.reservation_key, reservation.status, reservation.sku_id, reservation.cell_id, reservation.warehouse_id, reservation.is_refilled, reservation.date_created, reservation.date_updated, reservation.update_reservation_key FROM reservation WHERE reservation.order_item_key IN (%(order_item_key_1_1)s, %(order_item_key_1_2)s) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 3.555s ago] {'order_item_key_1_1': '25093877-70282481130880512', 'order_item_key_1_2': '25093878-70282481130891008'} 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 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 sku_cell_barcode_info.sku_id = %(sku_id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00052s] {'sku_id_1': 4100000000000042780, '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 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 sku_cell_barcode_info.sku_id = %(sku_id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.02666s ago] {'sku_id_1': 4100000000000042781, 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT consolidation_cell.id, consolidation_cell.barcode, consolidation_cell.status, consolidation_cell.warehouse_id, consolidation_cell.date_updated, consolidation_cell.assembly_wall_group_id, consolidation_cell.type FROM consolidation_cell JOIN box ON consolidation_cell.id = box.consolidation_cell_id WHERE box.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00082s] {'barcode_1': 'BX-0000489383'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT assembly_wall_cell.id, assembly_wall_cell.barcode, assembly_wall_cell.height, assembly_wall_cell.status, assembly_wall_cell.width, assembly_wall_cell.wall_id, assembly_wall_cell.current_assembly_id, assembly_wall_cell.date_updated, assembly_wall_cell.booked_at, assembly_wall_cell.worker_id FROM assembly_wall_cell JOIN assembly_wall ON assembly_wall.id = assembly_wall_cell.wall_id JOIN assembly_wall_group ON assembly_wall_group.id = assembly_wall.assembly_wall_group_id WHERE assembly_wall_group.group_id = %(group_id_1)s AND assembly_wall_group.warehouse_id = %(warehouse_id_1)s ORDER BY assembly_wall_cell.id DESC LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2328s ago] {'group_id_1': 1108, 'warehouse_id_1': 1693627, 'param_1': 1} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2341s ago] {'order_id_1': 8900485} 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 assembly_wall_cell.id AS assembly_wall_cell_id, assembly_wall_cell.barcode AS assembly_wall_cell_barcode, assembly_wall_cell.height AS assembly_wall_cell_height, assembly_wall_cell.status AS assembly_wall_cell_status, assembly_wall_cell.width AS assembly_wall_cell_width, assembly_wall_cell.wall_id AS assembly_wall_cell_wall_id, assembly_wall_cell.current_assembly_id AS assembly_wall_cell_current_assembly_id, assembly_wall_cell.date_updated AS assembly_wall_cell_date_updated, assembly_wall_cell.booked_at AS assembly_wall_cell_booked_at, assembly_wall_cell.worker_id AS assembly_wall_cell_worker_id FROM assembly_wall_cell WHERE assembly_wall_cell.current_assembly_id = %(current_assembly_id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2328s ago] {'current_assembly_id_1': 8747939, 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT assembly_wall_cell.id, assembly_wall_cell.barcode, assembly_wall_cell.height, assembly_wall_cell.status, assembly_wall_cell.width, assembly_wall_cell.wall_id, assembly_wall_cell.current_assembly_id, assembly_wall_cell.date_updated, assembly_wall_cell.booked_at, assembly_wall_cell.worker_id FROM assembly_wall_cell JOIN assembly_wall ON assembly_wall.id = assembly_wall_cell.wall_id JOIN assembly_wall_group ON assembly_wall_group.id = assembly_wall.assembly_wall_group_id WHERE assembly_wall_group.group_id = %(group_id_1)s AND assembly_wall_group.warehouse_id = %(warehouse_id_1)s AND assembly_wall_cell.status = %(status_1)s AND assembly_wall_cell.current_assembly_id IS NULL ORDER BY assembly_wall_cell.id DESC LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2328s ago] {'group_id_1': 1108, 'warehouse_id_1': 1693627, 'status_1': , '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 assembly_wall_cell.id AS assembly_wall_cell_id, assembly_wall_cell.barcode AS assembly_wall_cell_barcode, assembly_wall_cell.height AS assembly_wall_cell_height, assembly_wall_cell.status AS assembly_wall_cell_status, assembly_wall_cell.width AS assembly_wall_cell_width, assembly_wall_cell.wall_id AS assembly_wall_cell_wall_id, assembly_wall_cell.current_assembly_id AS assembly_wall_cell_current_assembly_id, assembly_wall_cell.date_updated AS assembly_wall_cell_date_updated, assembly_wall_cell.booked_at AS assembly_wall_cell_booked_at, assembly_wall_cell.worker_id AS assembly_wall_cell_worker_id, orders.dtype AS orders_dtype, orders.id AS orders_id, orders.barcode AS orders_barcode, orders.key AS orders_key, orders.status AS orders_status, orders.warehouse_id AS orders_warehouse_id, orders.is_test AS orders_is_test, orders.is_replenishment_needed AS orders_is_replenishment_needed, orders.cancel_needed AS orders_cancel_needed, orders.is_placed_to_sorting_wall_cell AS orders_is_placed_to_sorting_wall_cell, orders.comment AS orders_comment, orders.date_assembled AS orders_date_assembled, orders.date_assembly_started AS orders_date_assembly_started, orders.date_created AS orders_date_created, orders.date_updated AS orders_date_updated, orders.delivery_date AS orders_delivery_date, orders.wall_cell_key AS orders_wall_cell_key, orders.work_place_id AS orders_work_place_id, orders.worker_id AS orders_worker_id, orders.order_id AS orders_order_id, orders.assembly_group_id AS orders_assembly_group_id, orders.handover_list_id AS orders_handover_list_id, orders.logistic_order_id AS orders_logistic_order_id, orders.trade_order_id AS orders_trade_order_id, orders.cut_off AS orders_cut_off, orders.last_mile AS orders_last_mile, orders.last_mile_id AS orders_last_mile_id, orders.platform_tracking_code AS orders_platform_tracking_code, orders.canceled_by_ff AS orders_canceled_by_ff, orders.canceled_at AS orders_canceled_at, orders.was_weighted AS orders_was_weighted, orders.weight AS orders_weight, orders.is_mono AS orders_is_mono, orders.is_packing_processed AS orders_is_packing_processed, orders.work_place AS orders_work_place, orders.expected_weight AS orders_expected_weight, orders.first_mile_id AS orders_first_mile_id, orders.problematic_reason AS orders_problematic_reason, orders.business_task_id AS orders_business_task_id, orders.order_type AS orders_order_type, orders.seller_id AS orders_seller_id, orders.seller_name AS orders_seller_name, orders.is_awb AS orders_is_awb, orders.big_bag_barcode AS orders_big_bag_barcode, orders.logistic_template_id AS orders_logistic_template_id, orders.assembly_wall_group_id AS orders_assembly_wall_group_id, orders.wave_id AS orders_wave_id, orders.first_cut_off AS orders_first_cut_off, orders.actual_weight AS orders_actual_weight, orders.external_order_id AS orders_external_order_id, orders.order_source AS orders_order_source, orders.complete_retry_count AS orders_complete_retry_count FROM assembly_wall_cell JOIN orders ON assembly_wall_cell.current_assembly_id = orders.id WHERE assembly_wall_cell.barcode = %(barcode_1)s AND orders.order_id = %(order_id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2328s ago] {'barcode_1': '12.8.1.48', 'order_id_1': 8900485, 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT orders.dtype AS orders_dtype, orders.id AS orders_id, orders.barcode AS orders_barcode, orders.key AS orders_key, orders.status AS orders_status, orders.warehouse_id AS orders_warehouse_id, orders.is_test AS orders_is_test, orders.is_replenishment_needed AS orders_is_replenishment_needed, orders.cancel_needed AS orders_cancel_needed, orders.is_placed_to_sorting_wall_cell AS orders_is_placed_to_sorting_wall_cell, orders.comment AS orders_comment, orders.date_assembled AS orders_date_assembled, orders.date_assembly_started AS orders_date_assembly_started, orders.date_created AS orders_date_created, orders.date_updated AS orders_date_updated, orders.delivery_date AS orders_delivery_date, orders.wall_cell_key AS orders_wall_cell_key, orders.work_place_id AS orders_work_place_id, orders.worker_id AS orders_worker_id, orders.order_id AS orders_order_id, orders.assembly_group_id AS orders_assembly_group_id, orders.handover_list_id AS orders_handover_list_id, orders.logistic_order_id AS orders_logistic_order_id, orders.trade_order_id AS orders_trade_order_id, orders.cut_off AS orders_cut_off, orders.last_mile AS orders_last_mile, orders.last_mile_id AS orders_last_mile_id, orders.platform_tracking_code AS orders_platform_tracking_code, orders.canceled_by_ff AS orders_canceled_by_ff, orders.canceled_at AS orders_canceled_at, orders.was_weighted AS orders_was_weighted, orders.weight AS orders_weight, orders.is_mono AS orders_is_mono, orders.is_packing_processed AS orders_is_packing_processed, orders.work_place AS orders_work_place, orders.expected_weight AS orders_expected_weight, orders.first_mile_id AS orders_first_mile_id, orders.problematic_reason AS orders_problematic_reason, orders.business_task_id AS orders_business_task_id, orders.order_type AS orders_order_type, orders.seller_id AS orders_seller_id, orders.seller_name AS orders_seller_name, orders.is_awb AS orders_is_awb, orders.big_bag_barcode AS orders_big_bag_barcode, orders.logistic_template_id AS orders_logistic_template_id, orders.assembly_wall_group_id AS orders_assembly_wall_group_id, orders.wave_id AS orders_wave_id, orders.first_cut_off AS orders_first_cut_off, orders.actual_weight AS orders_actual_weight, orders.external_order_id AS orders_external_order_id, orders.order_source AS orders_order_source, orders.complete_retry_count AS orders_complete_retry_count FROM orders WHERE orders.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2328s ago] {'pk_1': 8747939} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2342s ago] {'order_id_1': 8900485} 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 assembly_wall_cell.id AS assembly_wall_cell_id, assembly_wall_cell.barcode AS assembly_wall_cell_barcode, assembly_wall_cell.height AS assembly_wall_cell_height, assembly_wall_cell.status AS assembly_wall_cell_status, assembly_wall_cell.width AS assembly_wall_cell_width, assembly_wall_cell.wall_id AS assembly_wall_cell_wall_id, assembly_wall_cell.current_assembly_id AS assembly_wall_cell_current_assembly_id, assembly_wall_cell.date_updated AS assembly_wall_cell_date_updated, assembly_wall_cell.booked_at AS assembly_wall_cell_booked_at, assembly_wall_cell.worker_id AS assembly_wall_cell_worker_id FROM assembly_wall_cell WHERE assembly_wall_cell.current_assembly_id = %(current_assembly_id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2329s ago] {'current_assembly_id_1': 8747939, 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sorting_log.id, sorting_log.external_sku_id, sorting_log.amount, sorting_log.worker_id, sorting_log.external_order_id, sorting_log.warehouse_id, sorting_log.item_barcode, sorting_log.date_sorted, sorting_log.sorting_cell_barcode FROM sorting_log WHERE sorting_log.external_order_id = %(external_order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00082s] {'external_order_id_1': 8900485} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2343s ago] {'order_id_1': 8900485} 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 2346s ago] {'barcode': 'UP-QA-70282493698083072', '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 2346s ago] {'pk_1': 98403} 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 big_bag.id AS big_bag_id, big_bag.barcode AS big_bag_barcode, big_bag.status AS big_bag_status, big_bag.warehouse_id AS big_bag_warehouse_id, big_bag.closed_date AS big_bag_closed_date, big_bag.shipment_date AS big_bag_shipment_date, big_bag.table_history_list AS big_bag_table_history_list, big_bag.url AS big_bag_url, big_bag.closed_by_worker_id AS big_bag_closed_by_worker_id, big_bag.closed_by_worker_name AS big_bag_closed_by_worker_name, big_bag.shipped_by_worker_id AS big_bag_shipped_by_worker_id, big_bag.shipped_by_worker_name AS big_bag_shipped_by_worker_name, big_bag.created_date AS big_bag_created_date FROM big_bag WHERE big_bag.barcode = %(barcode_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00068s] {'barcode_1': 'BB-0000229396', '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 big_bag.id AS big_bag_id, big_bag.barcode AS big_bag_barcode, big_bag.status AS big_bag_status, big_bag.warehouse_id AS big_bag_warehouse_id, big_bag.closed_date AS big_bag_closed_date, big_bag.shipment_date AS big_bag_shipment_date, big_bag.table_history_list AS big_bag_table_history_list, big_bag.url AS big_bag_url, big_bag.closed_by_worker_id AS big_bag_closed_by_worker_id, big_bag.closed_by_worker_name AS big_bag_closed_by_worker_name, big_bag.shipped_by_worker_id AS big_bag_shipped_by_worker_id, big_bag.shipped_by_worker_name AS big_bag_shipped_by_worker_name, big_bag.created_date AS big_bag_created_date FROM big_bag WHERE big_bag.barcode = %(barcode_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03924s ago] {'barcode_1': 'BB-0000229396', 'param_1': 1} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2344s ago] {'order_id_1': 8900485} 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 2346s ago] {'order_id_1': 8900485} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2344s ago] {'order_id_1': 8900485} 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 2346s ago] {'order_id_1': 8900485} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2345s ago] {'order_id_1': 8900485} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2345s ago] {'order_id_1': 8900485} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT box.id, box.barcode, box.warehouse_id, box.picking_task_id, box.status, box.stock_return_task_id, box.inventory_task_id, box.packing_table_id, box.consolidation_cell_pre_id, box.consolidation_cell_id, box.sorting_task_id FROM box WHERE box.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00049s] {'barcode_1': 'BX-0000489383'} 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 big_bag.id AS big_bag_id, big_bag.barcode AS big_bag_barcode, big_bag.status AS big_bag_status, big_bag.warehouse_id AS big_bag_warehouse_id, big_bag.closed_date AS big_bag_closed_date, big_bag.shipment_date AS big_bag_shipment_date, big_bag.table_history_list AS big_bag_table_history_list, big_bag.url AS big_bag_url, big_bag.closed_by_worker_id AS big_bag_closed_by_worker_id, big_bag.closed_by_worker_name AS big_bag_closed_by_worker_name, big_bag.shipped_by_worker_id AS big_bag_shipped_by_worker_id, big_bag.shipped_by_worker_name AS big_bag_shipped_by_worker_name, big_bag.created_date AS big_bag_created_date FROM big_bag WHERE big_bag.barcode = %(barcode_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2.053s ago] {'barcode_1': 'BB-0000229396', 'param_1': 1} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2345s ago] {'order_id_1': 8900485} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT big_bag.id, big_bag.barcode, big_bag.status, big_bag.warehouse_id, big_bag.closed_date, big_bag.shipment_date, big_bag.table_history_list, big_bag.url, big_bag.closed_by_worker_id, big_bag.closed_by_worker_name, big_bag.shipped_by_worker_id, big_bag.shipped_by_worker_name, big_bag.created_date FROM big_bag JOIN orders ON orders.big_bag_barcode = big_bag.barcode WHERE orders.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00049s] {'order_id_1': 8900485} 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 big_bag.id AS big_bag_id, big_bag.barcode AS big_bag_barcode, big_bag.status AS big_bag_status, big_bag.warehouse_id AS big_bag_warehouse_id, big_bag.closed_date AS big_bag_closed_date, big_bag.shipment_date AS big_bag_shipment_date, big_bag.table_history_list AS big_bag_table_history_list, big_bag.url AS big_bag_url, big_bag.closed_by_worker_id AS big_bag_closed_by_worker_id, big_bag.closed_by_worker_name AS big_bag_closed_by_worker_name, big_bag.shipped_by_worker_id AS big_bag_shipped_by_worker_id, big_bag.shipped_by_worker_name AS big_bag_shipped_by_worker_name, big_bag.created_date AS big_bag_created_date FROM big_bag WHERE big_bag.barcode = %(barcode_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2.829s ago] {'barcode_1': 'BB-0000229396', 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT big_bag.id, big_bag.barcode, big_bag.status, big_bag.warehouse_id, big_bag.closed_date, big_bag.shipment_date, big_bag.table_history_list, big_bag.url, big_bag.closed_by_worker_id, big_bag.closed_by_worker_name, big_bag.shipped_by_worker_id, big_bag.shipped_by_worker_name, big_bag.created_date FROM big_bag WHERE big_bag.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00047s] {'barcode_1': 'BB-0000229396'} 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.order_id = %(order_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 2346s ago] {'order_id_1': 8900485} 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 2348s ago] {'order_id_1': 8900485} 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 2351s ago] {'order_id_1': 8900485} 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 2356s ago] {'barcode': , 'wms_id_1': 100328} 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 2356s ago] {'barcode': , 'wms_id_1': 10126}