پردازش بالا کویری رو سرور

سلام
این پردازش فروشگاه مصرف بالایی دارد
من از ناپ کامرس 3.9 استفاده میکنم

کسی از اساتید میدونه علت چیه
چطور میتونم حلش کنم
با تشکر

 declare @p31 nvarchar(max)
set @p31=NULL
declare @p32 int
set @p32=0
exec sp_executesql N'ProductLoadAllPaged @CategoryIds, @ManufacturerId, @StoreId, @VendorId, @WarehouseId, @ProductTypeId, @VisibleIndividuallyOnly, @MarkedAsNewOnly, @ProductTagId, @FeaturedProducts, 
@PriceMin, @PriceMax, @Keywords, @SearchDescriptions, @SearchManufacturerPartNumber, @SearchSku, @SearchProductTags, @UseFullTextSearch, @FullTextMode, @FilteredSpecs, @LanguageId, @OrderBy, @AllowedCustomerRoleIds, @PageIndex, @PageSize, @ShowHidden, @OverridePublished, @LoadFilterableSpecificationAttributeOptionIds, @FilterableSpecificationAttributeOptionIds output, @TotalRecords output',N'@CategoryIds nvarchar(4000), @ManufacturerId int, @StoreId int,@VendorId int,@WarehouseId int, @ProductTypeId int, @VisibleIndividuallyOnly int, @MarkedAsNewOnly int, @ProductTagId int,@FeaturedProducts bit, @PriceMin decimal(29,0), @PriceMax decimal(29,0),@Keywords nvarchar(5), @SearchDescriptions bit, @SearchManufacturerPartNumber bit, @SearchSku bit, @SearchProductTags bit, @UseFullTextSearch bit,@FullTextMode int, @FilteredSpecs nvarchar(4000), @LanguageId int, @OrderBy int, @AllowedCustomerRoleIds nvarchar(4000),@PageIndex int, @PageSize int,@ShowHidden bit,@OverridePublished bit, @LoadFilterableSpecificationAttributeOptionIds bit, @FilterableSpecificationAttributeOptionIds nvarchar(max)  output, @TotalRecords int output',@CategoryIds=N'', @ManufacturerId=0, @StoreId=0,@VendorId=0, @WarehouseId=0, @ProductTypeId=NULL,@VisibleIndividuallyOnly=1, @MarkedAsNewOnly=0, @ProductTagId=0, @FeaturedProducts=NULL, @PriceMin=NULL, @PriceMax=NULL, @Keywords=N 'ویگرا',@SearchDescriptions=1, @SearchManufacturerPartNumber=1, @SearchSku=1, @SearchProductTags=1, @UseFullTextSearch=0, @FullTextMode=0, @FilteredSpecs=N'', @LanguageId=0, @OrderBy=0, @AllowedCustomerRoleIds=N'', @PageIndex=0, @PageSize=5, @ShowHidden=0, @OverridePublished=NULL, @LoadFilterableSpecificationAttributeOptionIds=0, @FilterableSpecificationAttributeOptionIds= @p31 output,@TotalRecords= @p32 output
select @p31, @p32