INFO:sqlalchemy.engine.Engine: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:[cached since 0.621s ago] {'first_name_1': 'Phantom', 'last_name_1': 'Lancer', 'barcode_1': <WMSTestUserStatus.FREE: 'FREE'>, 'warehouse_id_1': 1693627, 'param_1': 1}
INFO:sqlalchemy.engine.Engine: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:[cached since 0.582s ago] {'pk_1': 100027}
INFO:sqlalchemy.engine.Engine:UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO:sqlalchemy.engine.Engine:[cached since 0.5805s ago] {'barcode': <WMSTestUserStatus.TAKEN: 'TAKEN'>, 'wms_id_1': 100027}
INFO:sqlalchemy.engine.Engine: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:[cached since 0.4884s ago] {'key': 'QA-70120486271034624', 'zone_id': <WMSZoneIds.QA_UZ_ZONE: 31>, 'cell_picking_type': <AvailabilityCellPickingType.PICKUP: 'PICKUP'>, 'barcode': None, 'old_barcode': '2026-02-03T12:08:06.271052', '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:COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode
INFO:sqlalchemy.engine.Engine:BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO:sqlalchemy.engine.Engine: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:[cached since 0.4848s ago] {'pk_1': 479446}
INFO:sqlalchemy.engine.Engine: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:[cached since 0.4674s ago] {'first_name_1': <AutotestUser.firstname: 'Phantom'>, 'last_name_1': <AutotestUser.lastname: 'Lancer'>, 'barcode_1': <AutotestUser.barcode_free: 'FREE'>, 'param_1': 1}
INFO:sqlalchemy.engine.Engine:UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO:sqlalchemy.engine.Engine:[cached since 0.6392s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100161}
INFO:sqlalchemy.engine.Engine: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:[cached since 0.5017s ago] {'pk_1': 479444}
INFO:sqlalchemy.engine.Engine:SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO:sqlalchemy.engine.Engine:[generated in 0.00014s] {'param_1': 479444}
INFO:sqlalchemy.engine.Engine:SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO:sqlalchemy.engine.Engine:[generated in 0.00013s] {'param_1': 479444}
INFO:sqlalchemy.engine.Engine:SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO:sqlalchemy.engine.Engine:[generated in 0.00012s] {'param_1': 479444}
INFO:sqlalchemy.engine.Engine:SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO:sqlalchemy.engine.Engine:[generated in 0.00011s] {'param_1': 479444}
INFO:sqlalchemy.engine.Engine:DELETE FROM cell WHERE cell.id = %(id)s
INFO:sqlalchemy.engine.Engine:[generated in 0.00011s] {'id': 479444}
INFO:sqlalchemy.engine.Engine:COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode
INFO:sqlalchemy.engine.Engine:UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO:sqlalchemy.engine.Engine:[cached since 0.6625s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100056}
INFO:sqlalchemy.engine.Engine:BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO:sqlalchemy.engine.Engine: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:[cached since 0.523s ago] {'pk_1': 479445}
INFO:sqlalchemy.engine.Engine:SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO:sqlalchemy.engine.Engine:[cached since 0.0202s ago] {'param_1': 479445}
INFO:sqlalchemy.engine.Engine:SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO:sqlalchemy.engine.Engine:[cached since 0.01819s ago] {'param_1': 479445}
INFO:sqlalchemy.engine.Engine:SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO:sqlalchemy.engine.Engine:[cached since 0.01717s ago] {'param_1': 479445}
INFO:sqlalchemy.engine.Engine:SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO:sqlalchemy.engine.Engine:[cached since 0.0162s ago] {'param_1': 479445}
INFO:sqlalchemy.engine.Engine:DELETE FROM cell WHERE cell.id = %(id)s
INFO:sqlalchemy.engine.Engine:[cached since 0.01559s ago] {'id': 479445}
INFO:sqlalchemy.engine.Engine:COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode
INFO:sqlalchemy.engine.Engine:UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s
INFO:sqlalchemy.engine.Engine:[cached since 0.6779s ago] {'barcode': <WMSTestUserStatus.FREE: 'FREE'>, 'wms_id_1': 100027}
INFO:sqlalchemy.engine.Engine:BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
INFO:sqlalchemy.engine.Engine: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:[cached since 0.5382s ago] {'pk_1': 479446}
INFO:sqlalchemy.engine.Engine:SELECT lost_goods.id AS lost_goods_id, lost_goods.status AS lost_goods_status, lost_goods.sku_id AS lost_goods_sku_id, lost_goods.barcode_info_id AS lost_goods_barcode_info_id, lost_goods.cell_id AS lost_goods_cell_id, lost_goods.warehouse_id AS lost_goods_warehouse_id, lost_goods.mark_checked_user AS lost_goods_mark_checked_user, lost_goods.mark_checked_time AS lost_goods_mark_checked_time, lost_goods.amount_returned AS lost_goods_amount_returned 
FROM lost_goods 
WHERE %(param_1)s = lost_goods.cell_id
INFO:sqlalchemy.engine.Engine:[cached since 0.03532s ago] {'param_1': 479446}
INFO:sqlalchemy.engine.Engine:SELECT reservation.id AS reservation_id, reservation.amount AS reservation_amount, reservation.canceled_amount AS reservation_canceled_amount, reservation.order_item_key AS reservation_order_item_key, reservation.reservation_key AS reservation_reservation_key, reservation.status AS reservation_status, reservation.sku_id AS reservation_sku_id, reservation.cell_id AS reservation_cell_id, reservation.warehouse_id AS reservation_warehouse_id, reservation.is_refilled AS reservation_is_refilled, reservation.date_created AS reservation_date_created, reservation.date_updated AS reservation_date_updated, reservation.update_reservation_key AS reservation_update_reservation_key 
FROM reservation 
WHERE %(param_1)s = reservation.cell_id
INFO:sqlalchemy.engine.Engine:[cached since 0.03212s ago] {'param_1': 479446}
INFO:sqlalchemy.engine.Engine:SELECT sku_cell.id AS sku_cell_id, sku_cell.inventory_needed AS sku_cell_inventory_needed, sku_cell.quantity_reserved AS sku_cell_quantity_reserved, sku_cell.cell_id AS sku_cell_cell_id, sku_cell.sku_id AS sku_cell_sku_id, sku_cell.warehouse_id AS sku_cell_warehouse_id, sku_cell.mark_missing_time AS sku_cell_mark_missing_time, sku_cell.mark_missing_user AS sku_cell_mark_missing_user 
FROM sku_cell 
WHERE %(param_1)s = sku_cell.cell_id
INFO:sqlalchemy.engine.Engine:[cached since 0.03122s ago] {'param_1': 479446}
INFO:sqlalchemy.engine.Engine:SELECT sku_cell_barcode_info.id AS sku_cell_barcode_info_id, sku_cell_barcode_info.amount AS sku_cell_barcode_info_amount, sku_cell_barcode_info.quantity_pending AS sku_cell_barcode_info_quantity_pending, sku_cell_barcode_info.warehouse_id AS sku_cell_barcode_info_warehouse_id, sku_cell_barcode_info.barcode_info_id AS sku_cell_barcode_info_barcode_info_id, sku_cell_barcode_info.cell_id AS sku_cell_barcode_info_cell_id, sku_cell_barcode_info.sku_id AS sku_cell_barcode_info_sku_id, sku_cell_barcode_info.sku_cell_id AS sku_cell_barcode_info_sku_cell_id, sku_cell_barcode_info.inventory_needed AS sku_cell_barcode_info_inventory_needed, sku_cell_barcode_info.batch_id AS sku_cell_barcode_info_batch_id 
FROM sku_cell_barcode_info 
WHERE %(param_1)s = sku_cell_barcode_info.cell_id
INFO:sqlalchemy.engine.Engine:[cached since 0.0303s ago] {'param_1': 479446}
INFO:sqlalchemy.engine.Engine:DELETE FROM cell WHERE cell.id = %(id)s
INFO:sqlalchemy.engine.Engine:[cached since 0.02968s ago] {'id': 479446}
INFO:sqlalchemy.engine.Engine:COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode