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 [generated in 0.00023s] {'key': 'PL-QA-70304977457307392', 'zone_id': , 'cell_picking_type': , 'barcode': None, 'old_barcode': '2026-02-05T15:22:57.457320', '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 [generated in 0.00012s] {'pk_1': 479886} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.key FROM cell JOIN zone ON cell.zone_id = zone.id WHERE zone.key = %(key_1)s AND zone.warehouse_id = %(warehouse_id_1)s AND (cell.key NOT IN (%(key_2_1)s, %(key_2_2)s)) AND (cell.key NOT IN (NULL) OR (1 = 1)) INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00015s] {'key_1': , 'warehouse_id_1': 1693627, 'key_2_1': , 'key_2_2': } INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.key FROM cell JOIN zone ON cell.zone_id = zone.id WHERE zone.key = %(key_1)s AND zone.warehouse_id = %(warehouse_id_1)s AND (cell.key NOT IN (%(key_2_1)s, %(key_2_2)s)) AND (cell.key NOT IN (NULL) OR (1 = 1)) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.03006s ago] {'key_1': , 'warehouse_id_1': 1693627, 'key_2_1': , 'key_2_2': } 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 12.65s 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 12.64s ago] {'pk_1': 100275} 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 12.64s ago] {'barcode': , 'wms_id_1': 100275} 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 acceptance_cart.id, acceptance_cart.warehouse_id, acceptance_cart.barcode, acceptance_cart.content_type, acceptance_cart.state, acceptance_cart.user_info, acceptance_cart.process_type FROM acceptance_cart WHERE acceptance_cart.user_info = %(user_info_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'user_info_1': '100275'} INFO sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_cart SET content_type=%(content_type)s, state=%(state)s, user_info=%(user_info)s WHERE acceptance_cart.user_info = %(user_info_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'content_type': None, 'state': , 'user_info': None, 'user_info_1': '100275'} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE acceptance_count_box SET cart_barcode=%(cart_barcode)s WHERE acceptance_count_box.cart_barcode IN (NULL) AND (1 != 1) INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00013s] {'cart_barcode': None} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE return_acceptance_count_box SET cart_barcode=%(cart_barcode)s WHERE return_acceptance_count_box.cart_barcode IN (NULL) AND (1 != 1) INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00013s] {'cart_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:1846 SELECT invoice.wms_id, invoice.warehouse_id, invoice.dm_should_be_scanned, invoice.is_datamatrix_invoice, invoice.is_full_scan, invoice.is1p, invoice.has_diff, invoice.has_imei_invoice, invoice.has_serial_invoice, invoice.is_test, invoice.acceptance_start_time, invoice.accepted_time, invoice.bar_code, invoice.box_barcode, invoice.created_time, invoice.creator, invoice.full_price, invoice.id, invoice.invoice_number, invoice.prepared_time, invoice.status, invoice.seller_id, invoice.arrival_from, invoice.arrival_to, invoice.pallet_amount, invoice.primary_document_number, invoice.is_accepted_auto, invoice.utd_number, invoice.acceptance_process_id, invoice.counter_agent_name, invoice.inn, invoice.primary_document_type, invoice.utd_date, invoice.utd_doc_id, invoice.primary_document_date, invoice.invoice_type, invoice.parent_invoice_number, invoice.declaration_id, invoice.declaration_request_id, invoice.original_invoice_number, invoice.finalization_error, invoice.type FROM invoice WHERE invoice.id = %(id_1)s AND invoice.warehouse_id = %(warehouse_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00014s] {'id_1': 7030497766, 'warehouse_id_1': 1693627} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-05T15:23:07.591881", "type": "request", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/wms/acceptance/invoices/chunked", "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 c9e7d78b-4efc-428a-87ca-aaf67be24ce4"}, "json": {"id": 7030497766, "invoiceNumber": 7030497766, "fullPrice": 33249, "barCode": "7030497766", "sellerId": 9999999999, "shopId": 9999999999, "createdTime": "2026-02-05T15:23:07Z", "arrivalFrom": "2026-02-06T15:23:07Z", "arrivalTo": "2026-02-06T16:23:07Z", "status": "CREATED", "warehouseId": 1693627, "cargoPlaces": 1, "chunkAmount": 1, "crptRequired": false, "hasSerial": false, "hasImei": false, "seller": {"id": 9999999999, "fullName": "", "inn": "9999999999", "phoneNumber": "+79999999999"}, "isTest": true, "type": "TYPE_1P", "cartons": [{"barcode": "70304987591820288", "weight": 2888, "cartonItems": [{"sku": 70304987587579136, "barcode": "558291724322202", "quantity": 1}, {"sku": 70304987587579136, "barcode": "169512894142", "quantity": 1}, {"sku": 70304987587579136, "barcode": "86474679173317", "quantity": 1}]}]}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-05T15:23:07.635157", "type": "response", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/wms/acceptance/invoices/chunked", "status_code": 200, "trace_id": "f9d114ed2b3e43f70c087c63b5fd78d9", "headers": {}, "body": "{\"id\":\"7030497766\",\"warehouseId\":1693627,\"invoiceNumber\":\"7030497766\",\"originalInvoiceNumber\":null,\"barcode\":\"7030497766\",\"seller\":{\"id\":9999999999,\"fullName\":\"\",\"inn\":\"9999999999\",\"phoneNumber\":\"+79999999999\"},\"status\":\"WAITING\",\"items\":[],\"dateCreated\":\"2026-02-05T15:23:07.000+00:00\",\"arrivalFrom\":\"2026-02-06T15:23:07.000+00:00\",\"arrivalTo\":\"2026-02-06T16:23:07.000+00:00\",\"acceptanceStartTime\":null,\"preparedTime\":null,\"acceptedTime\":null,\"warehouseInfo\":\"PLT Узбекистан\",\"creator\":null,\"pallets\":[],\"palletAmount\":1,\"totalPrice\":33249,\"currency\":null,\"primaryDocumentNumber\":null,\"primaryDocumentType\":null,\"primaryDocumentDate\":null,\"hasTailPallet\":null,\"isDatamatrixInvoice\":false,\"utdDate\":null,\"utdDocId\":null,\"hasSerialInvoice\":false,\"hasImeiInvoice\":false,\"finalizationError\":null}", "elapsed_time": 0.042001, "reason": "OK"} 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 invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 FROM invoice WHERE invoice.id = %(id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 10.49s ago] {'id_1': 7030497766, '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 invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 FROM invoice WHERE invoice.id = %(id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 10.49s ago] {'id_1': 7030497766, 'param_1': 1} INFO src.framework.common.api:api.py:97 {"timestamp": "2026-02-05T15:23:07.669936", "type": "request", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/ff/publish/invoice/chunk", "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 c9e7d78b-4efc-428a-87ca-aaf67be24ce4"}, "json": {"invoiceNumber": 7030497766, "invoiceBarcode": "WMS7030497766", "chunkNumber": 1, "chunkAmount": 1, "skuList": [{"kafkaSku": {"sellerId": 9999999999, "shopId": 9999999999, "warehouseId": 1693627, "id": 70304987587579136, "productId": 70304987587586816, "categoryId": 70304987587598080, "skuGroupId": 0, "barCode": "558291724322202", "weight": 6, "description": "QA description Рис хозяйка четко.", "fullName": "QA full_name Опасность развитый.", "factoryBarCode": "7774031805066", "imageUrl": "https://dummyimage.com/217x579", "skuTitle": "QA sku_title Лететь.", "amount": 1, "purchasePrice": 396, "sellPrice": 431, "identifierRequired": false, "expirationDateRequired": false, "returnable": true, "adult": false, "contentHidden": false, "photoRequired": false, "identifierTypes": null, "crptRequired": false, "withSerialNumber": false, "withImei": false, "productGroup": "COMMON", "dimensions": {"length": 8, "width": 8, "height": 8}, "currency": "RUB", "hsCodes": [{"code": "703049875892150", "country": "RU"}, {"code": "703049875892140", "country": "UZ"}]}, "price": 419, "amount": 1, "reason": "NEW", "currency": "RUB", "identifiers": null}, {"kafkaSku": {"sellerId": 9999999999, "shopId": 9999999999, "warehouseId": 1693627, "id": 70304987587579136, "productId": 70304987587586816, "categoryId": 70304987587598080, "skuGroupId": 0, "barCode": "169512894142", "weight": 6, "description": "QA description Рис хозяйка четко.", "fullName": "QA full_name Опасность развитый.", "factoryBarCode": "7774031805066", "imageUrl": "https://dummyimage.com/217x579", "skuTitle": "QA sku_title Лететь.", "amount": 1, "purchasePrice": 396, "sellPrice": 431, "identifierRequired": false, "expirationDateRequired": false, "returnable": true, "adult": false, "contentHidden": false, "photoRequired": false, "identifierTypes": null, "crptRequired": false, "withSerialNumber": false, "withImei": false, "productGroup": "COMMON", "dimensions": {"length": 8, "width": 8, "height": 8}, "currency": "RUB", "hsCodes": [{"code": "703049875892150", "country": "RU"}, {"code": "703049875892140", "country": "UZ"}]}, "price": 419, "amount": 1, "reason": "NEW", "currency": "RUB", "identifiers": null}, {"kafkaSku": {"sellerId": 9999999999, "shopId": 9999999999, "warehouseId": 1693627, "id": 70304987587579136, "productId": 70304987587586816, "categoryId": 70304987587598080, "skuGroupId": 0, "barCode": "86474679173317", "weight": 6, "description": "QA description Рис хозяйка четко.", "fullName": "QA full_name Опасность развитый.", "factoryBarCode": "7774031805066", "imageUrl": "https://dummyimage.com/217x579", "skuTitle": "QA sku_title Лететь.", "amount": 1, "purchasePrice": 396, "sellPrice": 431, "identifierRequired": false, "expirationDateRequired": false, "returnable": true, "adult": false, "contentHidden": false, "photoRequired": false, "identifierTypes": null, "crptRequired": false, "withSerialNumber": false, "withImei": false, "productGroup": "COMMON", "dimensions": {"length": 8, "width": 8, "height": 8}, "currency": "RUB", "hsCodes": [{"code": "703049875892150", "country": "RU"}, {"code": "703049875892140", "country": "UZ"}]}, "price": 419, "amount": 1, "reason": "NEW", "currency": "RUB", "identifiers": null}]}} INFO src.framework.common.api:api.py:121 {"timestamp": "2026-02-05T15:23:07.683324", "type": "response", "method": "POST", "url": "https://dm-ff-be-facade-gateway.k8s-review.dailymail-tech.uz/ff/publish/invoice/chunk", "status_code": 200, "trace_id": null, "headers": {}, "body": "{}", "elapsed_time": 0.011904, "reason": "OK"} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_info.id, sku_info.has_datamatrix, sku_info.has_serial_number, sku_info.has_imei, sku_info.seller_id, sku_info.barcode, sku_info.sku_id FROM sku_info WHERE sku_info.sku_id IN (%(sku_id_1_1)s, %(sku_id_1_2)s, %(sku_id_1_3)s) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 12.66s ago] {'sku_id_1_1': '70304987587579136', 'sku_id_1_2': '70304987587579136', 'sku_id_1_3': '70304987587579136'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku_info.id, sku_info.has_datamatrix, sku_info.has_serial_number, sku_info.has_imei, sku_info.seller_id, sku_info.barcode, sku_info.sku_id FROM sku_info WHERE sku_info.sku_id IN (%(sku_id_1_1)s, %(sku_id_1_2)s, %(sku_id_1_3)s) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 14.66s ago] {'sku_id_1_1': '70304987587579136', 'sku_id_1_2': '70304987587579136', 'sku_id_1_3': '70304987587579136'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT sku.id, sku.adult, sku.content_hidden, sku.identifier_required, sku.product_group, sku.returnable, sku.sku_id, sku.title, sku.quantity_reserved_awaiting_lp_answer, sku.has_datamatrix, sku.was_weighted, sku.has_shelf_life, sku.has_serial, sku.has_imei, sku.description, sku.height, sku.length, sku.width, sku.full_name, sku.image_url, sku.product_id, sku.shop_id, sku.volume, sku.weight FROM sku WHERE sku.id IN (%(id_1_1)s, %(id_1_2)s, %(id_1_3)s) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 12.6s ago] {'id_1_1': 70304987587579136, 'id_1_2': 70304987587579136, 'id_1_3': 70304987587579136} 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 invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 FROM invoice WHERE invoice.id = %(id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 12.55s ago] {'id_1': 7030497766, '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 invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 FROM invoice WHERE invoice.id = %(id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 12.56s ago] {'id_1': 7030497766, 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.key FROM cell JOIN zone ON cell.zone_id = zone.id WHERE zone.key = %(key_1)s AND zone.warehouse_id = %(warehouse_id_1)s AND (cell.key NOT IN (%(key_2_1)s, %(key_2_2)s)) AND (cell.key NOT IN (NULL) OR (1 = 1)) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 12.36s ago] {'key_1': 'BV', 'warehouse_id_1': 1693627, 'key_2_1': , 'key_2_2': } INFO sqlalchemy.engine.Engine:base.py:1846 SELECT acceptance_pallet.id, acceptance_pallet.is_datamatrix_invoice, acceptance_pallet.barcode, acceptance_pallet.cell_id, acceptance_pallet.cell_key, acceptance_pallet.cell_zone_id, acceptance_pallet.cell_zone_title, acceptance_pallet.count_started, acceptance_pallet.created_time, acceptance_pallet.reason, acceptance_pallet.status, acceptance_pallet.work_table_barcode, acceptance_pallet.work_table_id, acceptance_pallet.work_table_zone_id, acceptance_pallet.invoice_wms_id, acceptance_pallet.weight FROM acceptance_pallet WHERE acceptance_pallet.id = %(id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00026s] {'id_1': 12469056} 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 invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 FROM invoice WHERE invoice.id = %(id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 13.08s ago] {'id_1': 7030497766, 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT acceptance_topology.zone_barcode FROM acceptance_topology WHERE acceptance_topology.zone_barcode LIKE %(zone_barcode_1)s AND acceptance_topology.warehouse_id = %(warehouse_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00021s] {'zone_barcode_1': 'RP%', 'warehouse_id_1': 1693627} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT cell.key FROM cell JOIN zone ON cell.zone_id = zone.id WHERE zone.key = %(key_1)s AND zone.warehouse_id = %(warehouse_id_1)s AND (cell.key NOT IN (%(key_2_1)s, %(key_2_2)s)) AND (cell.key NOT IN (%(key_3_1)s, %(key_3_2)s, %(key_3_3)s, %(key_3_4)s, %(key_3_5)s, %(key_3_6)s, %(key_3_7)s, %(key_3_8)s, %(key_3_9)s, %(key_3_10)s, %(key_3_11)s, %(key_3_12)s, %(key_3_13)s, %(key_3_14)s, %(key_3_15)s, %(key_3_16)s, %(key_3_17)s, %(key_3_18)s, %(key_3_19)s, %(key_3_20)s, %(key_3_21)s, %(key_3_22)s, %(key_3_23)s, %(key_3_24)s, %(key_3_25)s, %(key_3_26)s, %(key_3_27)s, %(key_3_28)s, %(key_3_29)s)) INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 12.88s ago] {'key_1': 'RP', 'warehouse_id_1': 1693627, 'key_2_1': , 'key_2_2': , 'key_3_1': 'RP-01-01_01', 'key_3_2': 'RP-11-17', 'key_3_3': 'RP-1-40-2', 'key_3_4': 'RP-11-24', 'key_3_5': 'RP-11-05', 'key_3_6': 'RP-11-15', 'key_3_7': 'RP-01-04', 'key_3_8': 'RP-11-11', 'key_3_9': 'RP-11-20', 'key_3_10': 'RP-01-03', 'key_3_11': 'RP-11-02', 'key_3_12': 'RP-11-23', 'key_3_13': 'RP-11-08', 'key_3_14': 'RP-01-01', 'key_3_15': 'RP-11-21', 'key_3_16': 'RP-11-09', 'key_3_17': 'RP-11-06', 'key_3_18': 'RP-11-10', 'key_3_19': 'RP-11-22', 'key_3_20': 'RP-11-12', 'key_3_21': 'RP-11-16', 'key_3_22': 'RP-11-14', 'key_3_23': 'RP-11-03', 'key_3_24': 'RP-11-19', 'key_3_25': 'RP-11-04', 'key_3_26': 'RP-11-13', 'key_3_27': 'RP-11-01', 'key_3_28': 'RP-11-07', 'key_3_29': 'RP-01-05'} 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 invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 FROM invoice WHERE invoice.id = %(id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 13.3s ago] {'id_1': 7030497766, '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 invoice.wms_id AS invoice_wms_id, invoice.warehouse_id AS invoice_warehouse_id, invoice.dm_should_be_scanned AS invoice_dm_should_be_scanned, invoice.is_datamatrix_invoice AS invoice_is_datamatrix_invoice, invoice.is_full_scan AS invoice_is_full_scan, invoice.is1p AS invoice_is1p, invoice.has_diff AS invoice_has_diff, invoice.has_imei_invoice AS invoice_has_imei_invoice, invoice.has_serial_invoice AS invoice_has_serial_invoice, invoice.is_test AS invoice_is_test, invoice.acceptance_start_time AS invoice_acceptance_start_time, invoice.accepted_time AS invoice_accepted_time, invoice.bar_code AS invoice_bar_code, invoice.box_barcode AS invoice_box_barcode, invoice.created_time AS invoice_created_time, invoice.creator AS invoice_creator, invoice.full_price AS invoice_full_price, invoice.id AS invoice_id, invoice.invoice_number AS invoice_invoice_number, invoice.prepared_time AS invoice_prepared_time, invoice.status AS invoice_status, invoice.seller_id AS invoice_seller_id, invoice.arrival_from AS invoice_arrival_from, invoice.arrival_to AS invoice_arrival_to, invoice.pallet_amount AS invoice_pallet_amount, invoice.primary_document_number AS invoice_primary_document_number, invoice.is_accepted_auto AS invoice_is_accepted_auto, invoice.utd_number AS invoice_utd_number, invoice.acceptance_process_id AS invoice_acceptance_process_id, invoice.counter_agent_name AS invoice_counter_agent_name, invoice.inn AS invoice_inn, invoice.primary_document_type AS invoice_primary_document_type, invoice.utd_date AS invoice_utd_date, invoice.utd_doc_id AS invoice_utd_doc_id, invoice.primary_document_date AS invoice_primary_document_date, invoice.invoice_type AS invoice_invoice_type, invoice.parent_invoice_number AS invoice_parent_invoice_number, invoice.declaration_id AS invoice_declaration_id, invoice.declaration_request_id AS invoice_declaration_request_id, invoice.original_invoice_number AS invoice_original_invoice_number, invoice.finalization_error AS invoice_finalization_error, invoice.type AS invoice_type_1 FROM invoice WHERE invoice.id = %(id_1)s LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 13.31s ago] {'id_1': 7030497766, 'param_1': 1}