建议优化为：

drop table if exists #tabStr0;
drop table if exists #tabStr1;
declare @CheckOrderCodeStr0 varchar(max)= '58376,58377,81306,81307',
@CheckOrderCodeStr1 varchar(max)= '1507838,1507839,1507840';
create table #tabStr0(id int);
insert into #tabStr0
exec proc_string_split @CheckOrderCodeStr0,',';
create index idx_id on #tabStr0(id);
create table #tabStr1(id int);
insert into #tabStr1
exec proc_string_split @CheckOrderCodeStr1,',';
create index idx_id on #tabStr1(id);  

declare @CustomerID int= 1 ,@StartDate datetime= '2023-07-03' ,@EndDate datetime= '2023/7/18 0:00:00'

SELECT COUNT(1) FROM (

SELECT DISTINCT
rocrsi.ID
FROM RB_RemovalOrderCreateRecordSkuItems rocrsi (NOLOCK)
LEFT JOIN RB_RemovalOrderCreateRecord rocr (NOLOCK)
    ON rocrsi.CustomerID = rocr.CustomerID
    AND rocrsi.RecordID = rocr.ID
LEFT JOIN RB_Product pro (NOLOCK)
    ON rocrsi.CustomerID = pro.CustomerID
    AND rocrsi.SKU = pro.SKU
LEFT JOIN RB_Amazon_Removal_Order_Detail arod with (NOLOCK)
    ON rocr.CustomerID = arod.CustomerID
    AND rocr.OrderSourceID = arod.OrderSourceID
    AND rocr.RemovalOrderCode = arod.OrderID
    AND rocrsi.MNSKU = arod.SKU
    AND rocrsi.FNSKU  = arod.FnSKU
LEFT JOIN RB_Removeorder_ReceiveDetail rrd with (NOLOCK)
    ON arod.OrderID = rrd.OrderID
    AND arod.OrderSourceID = rrd.OrderSourceID
    AND arod.CustomerID = rrd.CustomerID
    AND arod.SKU  = rrd.SellerSKU
    AND arod.FnSKU = rrd.FNSKU
LEFT JOIN RB_FBA_INVENTORY_PLANNING_DATA rfih with (NOLOCK)
    ON rocr.CustomerID = rfih.CustomerID
    AND rocr.OrderSourceID = rfih.OrderSourceID
    AND rocrsi.MNSKU  = rfih.sku
    AND rocrsi.FNSKU = rfih.fnsku
    AND convert(date,rocr.AddTime) = convert(date,rfih.[snapshot-date])
LEFT JOIN RB_OrderSource (NOLOCK) os
    ON os.CustomerID = rocr.CustomerID
    AND os.ID = rocr.OrderSourceID
LEFT JOIN RB_RemovalOrder_BusinessExpand robe (NOLOCK)    
    ON robe.CustomerID = rocr.CustomerID
    AND robe.OrderSourceID = rocr.OrderSourceID
    AND robe.RemovalOrderCode = rocr.RemovalOrderCode
LEFT JOIN RB_RemovalOrder_SkuItem_AuditSatusExtend (NOLOCK) rsase
    ON rsase.CustomerID = rocrsi.CustomerID
    AND rsase.ReportID = rocrsi.ID
LEFT JOIN RB_Admin (NOLOCK) ra
    ON rocrsi.CustomerID = ra.CustomerID
    AND rocrsi.DestroyedAdminID = ra.ID
LEFT JOIN RB_Department (nolock) dp
    ON ra.CustomerID = dp.CustomerID
    AND ra.DepartmentID = dp.ID
left join  RB_WareHouse (nolock) wh
    on  rocr.CustomerID = wh.CustomerID
    and  rocr.OverseaWareHouseId = wh.ID
INNER JOIN #tabStr0 t0 on t0.id = rocrsi.ID  
WHERE rocrsi.CustomerID = @CustomerID
    AND rocr.AddTime >= @StartDate
    AND rocr.AddTime < @EndDate  AND rsase.AuditSatus = 2  and exists(select  1
            from  RB_OrderSource_SaleAdmin osa (NOLOCK)
        where  osa.OrderSourceID = os.ID
            and  osa.CustomerID = 1
            and  osa.AdminID = 1811
        )
union all
SELECT  DISTINCT
arod.ID
FROM RB_Amazon_Removal_Order_Detail arod with (NOLOCK)
    LEFT JOIN RB_Removeorder_ReceiveDetail rrd with (NOLOCK)
        ON arod.OrderID = rrd.OrderID
        AND arod.OrderSourceID = rrd.OrderSourceID
        AND arod.CustomerID = rrd.CustomerID
        AND arod.SKU  = rrd.SellerSKU
        AND arod.FnSKU = rrd.FNSKU
    LEFT JOIN RB_FBA_INVENTORY_PLANNING_DATA rfih with (NOLOCK)
        ON arod.OrderSourceID = rfih.OrderSourceID
        AND arod.CustomerID = rfih.CustomerID
        AND arod.SKU  = rfih.sku
        AND arod.FnSKU = rfih.fnsku
        AND convert(date,arod.AddTime) = convert(date,rfih.[snapshot-date])
    LEFT JOIN RB_RemovalOrder_BusinessExpand robe (NOLOCK)    
        ON robe.CustomerID = arod.CustomerID
        AND robe.OrderSourceID = arod.OrderSourceID
        AND robe.RemovalOrderCode = arod.OrderID
    LEFT JOIN RB_OrderSource (nolock) os
        ON os.CustomerID = arod.CustomerID
        AND os.ID = arod.OrderSourceID
    left join  RB_WareHouse (nolock) wh
        on  os.CustomerID = wh.CustomerID
        and  os.RemovalOrderDefaultWareHouseID = wh.ID
    LEFT JOIN RB_Product_OrderSourceSKU orsku with (NOLOCK)
        ON arod.CustomerID = orsku.CustomerID
        AND arod.OrderSourceID = orsku.OrderSourceID
        AND arod.SKU = orsku.OrderSourceSKU
    LEFT JOIN RB_Product pro with (NOLOCK)
        ON orsku.SKU = pro.SKU
        AND orsku.CustomerID = pro.CustomerID
    LEFT JOIN RB_RemovalOrder_SkuItem_AuditSatusExtend (NOLOCK) rsase
        ON rsase.CustomerID = arod.CustomerID
        AND rsase.ReportID = arod.ID
    LEFT JOIN RB_Admin (nolock) ra
        ON arod.CustomerID = ra.CustomerID
        AND arod.DestroyedAdminID = ra.ID
    LEFT JOIN RB_Department (nolock) dp
        ON ra.CustomerID = dp.CustomerID
        AND ra.DepartmentID = dp.ID
INNER JOIN #tabStr1 t1 on t1.id = arod.ID  
WHERE arod.CustomerID = @CustomerID
    AND arod.AddTime >= @StartDate
    AND arod.AddTime < @EndDate  AND NOT EXISTS (SELECT 1 FROM  RB_RemovalOrderCreateRecord (nolock) rocr1
                        WHERE rocr1.CustomerID = arod.CustomerID
                            AND rocr1.OrderSourceID = arod.OrderSourceID
                            AND rocr1.RemovalOrderCode = arod.OrderID) AND rsase.AuditSatus = 2  and exists(select  1
            from  RB_OrderSource_SaleAdmin osa (NOLOCK)
        where  osa.OrderSourceID = os.ID
            and  osa.CustomerID = 1
            and  osa.AdminID = 1811
        ) ) AS PagerTable;

详细看附近。