Очень долго выполняется хранимая процедура

USE [WebProject]
GO
/****** Object:  StoredProcedure [dbo].[info_SetCollectedSignWithSerialNumbers]    Script Date: 05.01.2020 10:37:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ARITHABORT ON
GO
ALTER PROCEDURE [dbo].[info_SetCollectedSignWithSerialNumbers]
  @basketOrderId int,
  @dataTable dbo.NotPayedOrdersExcel readonly
AS
BEGIN
    
    SET nocount ON
    
 
IF object_id('tempdb..#tmpSerial', 'u') IS NOT NULL DROP TABLE #tmpSerial
CREATE TABLE #tmpSerial (serial nvarchar(100) NOT NULL, goodId int NOT NULL)
 
INSERT INTO #tmpSerial 
SELECT 
  RTRIM(LTRIM(ts.serial)), g.GoodId
FROM
  @dataTable AS ts
  inner join dbo.Goods AS g WITH(nolock) ON g.GoodArticle = ts.article
 
  SET nocount off
  
 
INSERT INTO dbo.BasketOrdersAddInfo
(
  BasketOrderId,
  SerialNumber,
  BasketOrderGoodId,
  UserId
)
SELECT DISTINCT
  bog.BasketOrderId, 
  NULL,
  bog.Id, 
  5
FROM
  dbo.BasketOrderGoods AS bog WITH(nolock)
  --cross join #tmpSerial s
WHERE  
  bog.BasketOrderId = @basketOrderId
 
--select distinct ts.serial from #tmpSerial as ts with(nolock)
--select * from #tmpSerial as ts with(nolock)
 
DECLARE 
  @serial nvarchar(100) = NULL, 
  @i int = 0,
  @goodId int = NULL
 
---------------------------------------------------------- 1
WHILE EXISTS (
  SELECT * 
  FROM 
    dbo.BasketOrdersAddInfo AS boai WITH(nolock) 
    --inner join dbo.BasketOrderGoods as bog with(nolock) on bog.Id = boai.BasketOrderGoodId
  WHERE 
    boai.BasketOrderId = @basketOrderId AND 
    boai.SerialNumber IS NULL --and bog.GoodId = 254203
)
BEGIN
  
  --set @goodId = 254203
  
  SELECT top 1 
    @serial = s.serial, 
    @goodId = s.goodId
  FROM 
    #tmpSerial s
    left outer join dbo.BasketOrdersAddInfo AS boai WITH(nolock) 
      ON 
        boai.BasketOrderId = @basketOrderId AND 
        boai.SerialNumber = s.serial
  WHERE 
    --s.goodId = 254203 and
    boai.Id IS NULL
    
  IF (@serial IS NULL) raiserror('Серийный номер не распознан', 11, 1)
  
  UPDATE boai
  SET 
    boai.SerialNumber = @serial
  FROM 
    dbo.BasketOrdersAddInfo AS boai WITH(nolock) 
    inner join dbo.BasketOrderGoods AS bog WITH(nolock) 
      ON 
        bog.Id = boai.BasketOrderGoodId AND 
        bog.GoodId = @goodId
  WHERE 
    boai.BasketOrderId = @basketOrderId AND
    boai.SerialNumber IS NULL AND 
    boai.Id = (
      SELECT MIN(boai.Id) 
      FROM 
        dbo.BasketOrdersAddInfo AS boai WITH(nolock) 
        inner join dbo.BasketOrderGoods AS bog WITH(nolock) 
        ON 
          bog.Id = boai.BasketOrderGoodId AND 
          bog.GoodId = @goodId
      WHERE 
        boai.BasketOrderId = @basketOrderId AND 
        boai.SerialNumber IS NULL --and boai.BasketOrderGoodId = bog.Id
    )
    
  UPDATE bog SET bog.IsCollected = 1 FROM BasketOrderGoods AS bog WHERE bog.BasketOrderId = @basketOrderId
    
  UPDATE bo SET bo.IsCollected = 1 FROM BasketOrders AS bo WHERE bo.Id=  @basketOrderId
  SET @i += 1
    
  --print @i
  --if (@i > 2) break
  
  --select @i, @goodId, @serial
  
  SET @goodId = NULL
  SET @serial = NULL
  
END
 
--select @i
 
SET @i = 0
 
END