INFO     sqlalchemy.engine.Engine:base.py:1846 select pg_catalog.version()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 select current_schema()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 show standard_conforming_strings
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
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 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 [generated in 0.00016s] {'first_name_1': 'Phantom', 'last_name_1': 'Lancer', 'barcode_1': <WMSTestUserStatus.FREE: 'FREE'>, '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 [generated in 0.00013s] {'pk_1': 100379}
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 [generated in 0.00012s] {'barcode': <WMSTestUserStatus.TAKEN: 'TAKEN'>, 'wms_id_1': 100379}
INFO     sqlalchemy.engine.Engine:base.py:1846 select pg_catalog.version()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 select current_schema()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 show standard_conforming_strings
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
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 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.00015s] {'key': 'QA-70204065254749952', 'zone_id': <WMSZoneIds.QA_UZ_ZONE: 31>, 'cell_picking_type': <AvailabilityCellPickingType.PICKUP: 'PICKUP'>, 'barcode': None, 'old_barcode': '2026-02-04T11:21:05.254764', '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': 479569}
INFO     sqlalchemy.engine.Engine:base.py:1846 select pg_catalog.version()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 select current_schema()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 show standard_conforming_strings
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
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.invoice_number, invoice.invoice_status 
FROM shaded_id JOIN sku ON shaded_id.id = sku.shaded_id_id JOIN barcode_info ON sku.id = barcode_info.sku_id JOIN cart_item ON barcode_info.id = cart_item.barcode_info_id JOIN cart ON cart.id = cart_item.cart_id JOIN invoice ON invoice.id = cart.invoice_id 
WHERE shaded_id.external IN (%(external_1_1)s)
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00018s] {'external_1_1': 787844650342606}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT shaded_id.external AS external_sku_id, shaded_id.internal AS internal_sku_id, barcode_info.barcode, sku.name, sku_picture.url, CAST(sku.purchase_price AS FLOAT) AS purchase_price, cart_item.quantity, cart_item.currency 
FROM sku LEFT OUTER JOIN shaded_id ON sku.shaded_id_id = shaded_id.id LEFT OUTER JOIN barcode_info ON sku.id = barcode_info.sku_id LEFT OUTER JOIN sku_picture ON sku.id = sku_picture.sku_id LEFT OUTER JOIN cart_item ON barcode_info.id = cart_item.barcode_info_id 
WHERE shaded_id.external IN (%(external_1_1)s)
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00022s] {'external_1_1': 787844650342606}
INFO     src.framework.common.api:api.py:97 {"timestamp": "2026-02-04T11:21:06.025250", "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 48f90f11-aaf1-4a1c-b6ec-51a3d9c42ddd"}, "params": {"internalIds": 4100000000000042512}}
INFO     src.framework.common.api:api.py:121 {"timestamp": "2026-02-04T11:21:06.065366", "type": "response", "method": "POST", "url": "https://dm-ff-be-service-stock.k8s-review.dailymail-tech.uz/qa-api/v1/pull-stock-records?internalIds=4100000000000042512", "status_code": 200, "trace_id": null, "headers": {}, "body": "[{\"id\":\"null_4100000000000042512_1693627\",\"internalSkuId\":4100000000000042512,\"externalSkuId\":787844650342606,\"barcode\":null,\"provider\":\"YA\",\"quantityActive\":0,\"quantityPending\":0,\"quantityOverage\":0,\"quantityUnknown\":0,\"quantityDefected\":0,\"quantityMissing\":0,\"warehouseId\":1693627,\"synchronized\":false,\"synchronizedTime\":\"2026-02-04T16:21:06.062+05:00\",\"showcaseQuantity\":0}]", "elapsed_time": 0.038695, "reason": "OK"}
INFO     sqlalchemy.engine.Engine:base.py:1846 select pg_catalog.version()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 select current_schema()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 show standard_conforming_strings
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
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 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 [generated in 0.00013s] {'internal_sku_id_1': 4100000000000042512}
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 [generated in 0.00012s] {'quantity_active': 8, 'internal_sku_id_1': 4100000000000042512}
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 [generated in 0.00019s] {'invoice_document_number': 'autotest_20260204_588', 'invoice_document_date': '2026-02-04 00:00:00.000000', 'invoice_id_1': '410000008156'}
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 [generated in 0.00030s] {'key_1': 'QA-70204065254749952', '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 [generated in 0.00014s] {'sku_id_1': 4100000000000042512, 'barcode_1': '24964587603', 'invoice_id_1': '410000008156'}
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 1.4s ago] {'key': 'QA-70204066668859648', 'zone_id': <WMSZoneIds.QA_UZ_ZONE: 31>, 'cell_picking_type': <AvailabilityCellPickingType.UNAVAILABLE: 'UNAVAILABLE'>, 'barcode': None, 'old_barcode': '2026-02-04T11:21:06.668873', '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 1.398s ago] {'pk_1': 479570}
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 0.592s ago] {'internal_sku_id_1': 4100000000000042512}
INFO     sqlalchemy.engine.Engine:base.py:1846 select pg_catalog.version()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 select current_schema()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 show standard_conforming_strings
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
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 task SET worker_id=%(worker_id)s, worker_name=%(worker_name)s WHERE task.worker_id = %(worker_id_1)s AND task.task_status != %(task_status_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'worker_id': 0, 'worker_name': '0', 'worker_id_1': 100379, 'task_status_1': <MovementTaskStatus.COMPLETED: 'COMPLETED'>}
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 pg_catalog.version()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 select current_schema()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 show standard_conforming_strings
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
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 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.warehouse_id = %(warehouse_id_1)s AND box.status = %(status_1)s AND box.barcode LIKE %(barcode_1)s AND box.stock_return_task_id IS NULL AND box.inventory_task_id IS NULL AND box.picking_task_id IS NULL
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00023s] {'warehouse_id_1': 1693627, 'status_1': <BoxStatus.FREE: 'FREE'>, 'barcode_1': 'BX%'}
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, barcode_info.id AS id_1, barcode_info.barcode, barcode_info.quantity_active, barcode_info.quantity_pending, barcode_info.warehouse_id, barcode_info.sku_id AS sku_id_1, barcode_info.quantity_movement 
FROM sku JOIN barcode_info ON barcode_info.sku_id = sku.sku_id 
WHERE barcode_info.barcode = %(barcode_1)s AND barcode_info.sku_id = %(sku_id_2)s AND barcode_info.warehouse_id = %(warehouse_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00022s] {'barcode_1': '24964587603', 'sku_id_2': 4100000000000042512, 'warehouse_id_1': 1693627}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id, cell.key, cell.zone_id, cell.active, cell.mix_type, cell.skus_amount, cell.cell_picking_type, cell.barcode, cell.old_barcode, cell.height, cell.length, cell.width, cell.placing_order, cell.picking_order, cell.inventory_task_id, cell.last_inventory_date, cell.last_inventory_worker_id, cell.deactivate_reason 
FROM cell JOIN zone ON zone.id = cell.zone_id 
WHERE cell.key = %(key_1)s AND zone.warehouse_id = %(warehouse_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'key_1': 'QA-70204065254749952', 'warehouse_id_1': 1693627}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT barcode_info.id AS barcode_info_id, barcode_info.barcode AS barcode_info_barcode, barcode_info.quantity_active AS barcode_info_quantity_active, barcode_info.quantity_pending AS barcode_info_quantity_pending, barcode_info.warehouse_id AS barcode_info_warehouse_id, barcode_info.sku_id AS barcode_info_sku_id, barcode_info.quantity_movement AS barcode_info_quantity_movement 
FROM barcode_info 
WHERE barcode_info.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] {'pk_1': '24964587603_4100000000000042512_1693627'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku.id AS sku_id_1, sku.adult AS sku_adult, sku.content_hidden AS sku_content_hidden, sku.identifier_required AS sku_identifier_required, sku.product_group AS sku_product_group, sku.returnable AS sku_returnable, sku.sku_id AS sku_sku_id, sku.title AS sku_title, sku.quantity_reserved_awaiting_lp_answer AS sku_quantity_reserved_awaiting_lp_answer, sku.has_datamatrix AS sku_has_datamatrix, sku.was_weighted AS sku_was_weighted, sku.has_shelf_life AS sku_has_shelf_life, sku.has_serial AS sku_has_serial, sku.has_imei AS sku_has_imei, sku.description AS sku_description, sku.height AS sku_height, sku.length AS sku_length, sku.width AS sku_width, sku.full_name AS sku_full_name, sku.image_url AS sku_image_url, sku.product_id AS sku_product_id, sku.shop_id AS sku_shop_id, sku.volume AS sku_volume, sku.weight AS sku_weight 
FROM sku 
WHERE sku.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00010s] {'pk_1': 4100000000000042512}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id, sku_cell_barcode_info.amount, sku_cell_barcode_info.quantity_pending, sku_cell_barcode_info.warehouse_id, sku_cell_barcode_info.barcode_info_id, sku_cell_barcode_info.cell_id, sku_cell_barcode_info.sku_id, sku_cell_barcode_info.sku_cell_id, sku_cell_barcode_info.inventory_needed, sku_cell_barcode_info.batch_id 
FROM sku_cell_barcode_info 
WHERE sku_cell_barcode_info.barcode_info_id = %(barcode_info_id_1)s AND sku_cell_barcode_info.cell_id = %(cell_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00012s] {'barcode_info_id_1': '24964587603_4100000000000042512_1693627', 'cell_id_1': 479569}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT barcode_info.id, barcode_info.barcode, barcode_info.quantity_active, barcode_info.quantity_pending, barcode_info.warehouse_id, barcode_info.sku_id, barcode_info.quantity_movement 
FROM barcode_info 
WHERE barcode_info.sku_id = %(sku_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00010s] {'sku_id_1': 4100000000000042512}
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, barcode_info.id AS id_1, barcode_info.barcode, barcode_info.quantity_active, barcode_info.quantity_pending, barcode_info.warehouse_id, barcode_info.sku_id AS sku_id_1, barcode_info.quantity_movement 
FROM sku JOIN barcode_info ON barcode_info.sku_id = sku.sku_id 
WHERE barcode_info.barcode = %(barcode_1)s AND barcode_info.sku_id = %(sku_id_2)s AND barcode_info.warehouse_id = %(warehouse_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3617s ago] {'barcode_1': '24964587603', 'sku_id_2': 4100000000000042512, 'warehouse_id_1': 1693627}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT cell.id, cell.key, cell.zone_id, cell.active, cell.mix_type, cell.skus_amount, cell.cell_picking_type, cell.barcode, cell.old_barcode, cell.height, cell.length, cell.width, cell.placing_order, cell.picking_order, cell.inventory_task_id, cell.last_inventory_date, cell.last_inventory_worker_id, cell.deactivate_reason 
FROM cell JOIN zone ON zone.id = cell.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 0.3604s ago] {'key_1': 'QA-70204066668859648', 'warehouse_id_1': 1693627}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT barcode_info.id AS barcode_info_id, barcode_info.barcode AS barcode_info_barcode, barcode_info.quantity_active AS barcode_info_quantity_active, barcode_info.quantity_pending AS barcode_info_quantity_pending, barcode_info.warehouse_id AS barcode_info_warehouse_id, barcode_info.sku_id AS barcode_info_sku_id, barcode_info.quantity_movement AS barcode_info_quantity_movement 
FROM barcode_info 
WHERE barcode_info.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.36s ago] {'pk_1': '24964587603_4100000000000042512_1693627'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku.id AS sku_id_1, sku.adult AS sku_adult, sku.content_hidden AS sku_content_hidden, sku.identifier_required AS sku_identifier_required, sku.product_group AS sku_product_group, sku.returnable AS sku_returnable, sku.sku_id AS sku_sku_id, sku.title AS sku_title, sku.quantity_reserved_awaiting_lp_answer AS sku_quantity_reserved_awaiting_lp_answer, sku.has_datamatrix AS sku_has_datamatrix, sku.was_weighted AS sku_was_weighted, sku.has_shelf_life AS sku_has_shelf_life, sku.has_serial AS sku_has_serial, sku.has_imei AS sku_has_imei, sku.description AS sku_description, sku.height AS sku_height, sku.length AS sku_length, sku.width AS sku_width, sku.full_name AS sku_full_name, sku.image_url AS sku_image_url, sku.product_id AS sku_product_id, sku.shop_id AS sku_shop_id, sku.volume AS sku_volume, sku.weight AS sku_weight 
FROM sku 
WHERE sku.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3597s ago] {'pk_1': 4100000000000042512}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sku_cell_barcode_info.id, sku_cell_barcode_info.amount, sku_cell_barcode_info.quantity_pending, sku_cell_barcode_info.warehouse_id, sku_cell_barcode_info.barcode_info_id, sku_cell_barcode_info.cell_id, sku_cell_barcode_info.sku_id, sku_cell_barcode_info.sku_cell_id, sku_cell_barcode_info.inventory_needed, sku_cell_barcode_info.batch_id 
FROM sku_cell_barcode_info 
WHERE sku_cell_barcode_info.barcode_info_id = %(barcode_info_id_1)s AND sku_cell_barcode_info.cell_id = %(cell_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3591s ago] {'barcode_info_id_1': '24964587603_4100000000000042512_1693627', 'cell_id_1': 479570}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT barcode_info.id, barcode_info.barcode, barcode_info.quantity_active, barcode_info.quantity_pending, barcode_info.warehouse_id, barcode_info.sku_id, barcode_info.quantity_movement 
FROM barcode_info 
WHERE barcode_info.sku_id = %(sku_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3588s ago] {'sku_id_1': 4100000000000042512}
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 5.409s ago] {'internal_sku_id_1': 4100000000000042512}
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 6.334s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100379}