| SQL | 执行次数 | 平均I_O | 总I_O | 逻辑写 | 逻辑读 | CPU平均耗时 | 总CPU耗时_秒 | 优化建议 | 代码截图 | 是否建立需求 |
| (@ID_1 bigint,@CustomerID_1 int,@ListingID_1 bigint,@ImageID_1 int,@ImageUrl_1 nvarchar(500),@AliExpressImageID_1 varchar(50),@AliExpressImageUrl_1 nvarchar(500),@IsCover_1 bit,@AddTime_1 datetime,@UpdateTime_1 datetime,@Sort_1 int,@ImageFileName_1 nvarchar(200),@ImageSize_1 nvarchar(100),@ImageType_1 int,@ID_2 bigint,@CustomerID_2 int,@ListingID_2 bigint,@ImageID_2 int,@ImageUrl_2 nvarchar(500),@AliExpressImageID_2 varchar(50),@AliExpressImageUrl_2 nvarchar(500),@IsCover_2 bit,@AddTime_2 datetime,@UpdateTime_2 datetime,@Sort_2 int,@ImageFileName_2 nvarchar(200),@ImageSize_2 nvarchar(100),@ImageType_2 int,@ID_3 bigint,@CustomerID_3 int,@ListingID_3 bigint,@ImageID_3 int,@ImageUrl_3 nvarchar(500),@AliExpressImageID_3 varchar(50),@AliExpressImageUrl_3 nvarchar(500),@IsCover_3 bit,@AddTime_3 datetime,@UpdateTime_3 datetime,@Sort_3 int,@ImageFileName_3 nvarchar(200),@ImageSize_3 nvarchar(100),@ImageType_3 int,@ID_4 bigint,@CustomerID_4 int,@ListingID_4 bigint,@ImageID_4 int,@ImageUrl_4 nvarchar(500),@AliExpressImageID_4 varchar(50),@AliExpressImageUrl_4 nvarchar(500),@IsCover_4 bit,@AddTime_4 datetime,@UpdateTime_4 datetime,@Sort_4 int,@ImageFileName_4 nvarchar(200),@ImageSize_4 nvarchar(100),@ImageType_4 int,@ID_5 bigint,@CustomerID_5 int,@ListingID_5 bigint,@ImageID_5 int,@ImageUrl_5 nvarchar(500),@AliExpressImageID_5 varchar(50),@AliExpressImageUrl_5 nvarchar(500),@IsCover_5 bit,@AddTime_5 datetime,@UpdateTime_5 datetime,@Sort_5 int,@ImageFileName_5 nvarchar(200),@ImageSize_5 nvarchar(100),@ImageType_5 int,@ID_6 bigint,@CustomerID_6 int,@ListingID_6 bigint,@ImageID_6 int,@ImageUrl_6 nvarchar(500),@AliExpressImageID_6 varchar(50),@AliExpressImageUrl_6 nvarchar(500),@IsCover_6 bit,@AddTime_6 datetime,@UpdateTime_6 datetime,@Sort_6 int,@ImageFileName_6 nvarchar(200),@ImageSize_6 nvarchar(100),@ImageType_6 int,@ID_7 bigint,@CustomerID_7 int,@ListingID_7 bigint,@ImageID_7 int,@ImageUrl_7 nvarchar(500),@AliExpressImageID_7 varchar(50),@AliExpressImageUrl_7 nvarchar(500),@IsCover_7 bit,@AddTime_7 datetime,@UpdateTime_7 datetime,@Sort_7 int,@ImageFileName_7 nvarchar(200),@ImageSize_7 nvarchar(100),@ImageType_7 int)update [RB_AliExpress_Listing_Images] set [CustomerID] = @CustomerID_1 , [ListingID] = @ListingID_1 , [ImageID] = @ImageID_1 , [ImageUrl] = @ImageUrl_1 , [AliExpressImageID] = @AliExpressImageID_1 , [AliExpressImageUrl] = @AliExpressImageUrl_1 , [IsCover] = @IsCover_1 , [AddTime] = @AddTime_1 , [UpdateTime] = @UpdateTime_1 , [Sort] = @Sort_1 , [ImageFileName] = @ImageFileName_1 , [ImageSize] = @ImageSize_1 , [ImageType] = @ImageType_1 where ID=@ID_1 ;update [RB_AliExpress_Listing_Images] set [CustomerID] = @CustomerID_2 , [ListingID] = @ListingID_2 , [ImageID] = @ImageID_2 , [ImageUrl] = @ImageUrl_2 , [AliExpressImageID] = @AliExpressImageID_2 , [AliExpressImageUrl] = @AliExpressImageUrl_2 , [IsCover] = @IsCover_2 , [AddTime] = @AddTime_2 , [UpdateTime] = @UpdateTime_2 , [Sort] = @Sort_2 , [ImageFileName] = @ImageFileName_2 , [ImageSize] = @ImageSize_2 , [ImageType] = @ImageType_2 where ID=@ID_2 ;update [RB_AliExpress_Listing_Images] set [CustomerID] = @CustomerID_3 , [ListingID] = @ListingID_3 , [ImageID] = @ImageID_3 , [ImageUrl] = @ImageUrl_3 , [AliExpressImageID] = @AliExpressImageID_3 , [AliExpressImageUrl] = @AliExpressImageUrl_3 , [IsCover] = @IsCover_3 , [AddTime] = @AddTime_3 , [UpdateTime] = @UpdateTime_3 , [Sort] = @Sort_3 , [ImageFileName] = @ImageFileName_3 , [ImageSize] = @ImageSize_3 , [ImageType] = @ImageType_3 where ID=@ID_3 ;update [RB_AliExpress_Listing_Images] set [CustomerID] = @CustomerID_4 , [ListingID] = @ListingID_4 , [ImageID] = @ImageID_4 , [ImageUrl] = @ImageUrl_4 , [AliExpressImageID] = @AliExpressImageID_4 , [AliExpressImageUrl] = @AliExpressImageUrl_4 , [IsCover] = @IsCover_4 , [AddTime] = @AddTime_4 , [UpdateTime] = @UpdateTime_4 , [Sort] = @Sort_4 , [ImageFileName] = @ImageFileName_4 , [ImageSize] = @ImageSize_4 , [ImageType] = @ImageType_4 where ID=@ID_4 ;update [RB_AliExpress_Listing_Images] set [CustomerID] = @CustomerID_5 , [ListingID] = @ListingID_5 , [ImageID] = @ImageID_5 , [ImageUrl] = @ImageUrl_5 , [AliExpressImageID] = @AliExpressImageID_5 , [AliExpressImageUrl] = @AliExpressImageUrl_5 , [IsCover] = @IsCover_5 , [AddTime] = @AddTime_5 , [UpdateTime] = @UpdateTime_5 , [Sort] = @Sort_5 , [ImageFileName] = @ImageFileName_5 , [ImageSize] = @ImageSize_5 , [ImageType] = @ImageType_5 where ID=@ID_5 ;update [RB_AliExpress_Listing_Images] set [CustomerID] = @CustomerID_6 , [ListingID] = @ListingID_6 , [ImageID] = @ImageID_6 , [ImageUrl] = @ImageUrl_6 , [AliExpressImageID] = @AliExpressImageID_6 , [AliExpressImageUrl] = @AliExpressImageUrl_6 , [IsCover] = @IsCover_6 , [AddTime] = @AddTime_6 , [UpdateTime] = @UpdateTime_6 , [Sort] = @Sort_6 , [ImageFileName] = @ImageFileName_6 , [ImageSize] = @ImageSize_6 , [ImageType] = @ImageType_6 where ID=@ID_6 ;update [RB_AliExpress_Listing_Images] set [CustomerID] = @CustomerID_7 , [ListingID] = @ListingID_7 , [ImageID] = @ImageID_7 , [ImageUrl] = @ImageUrl_7 , [AliExpressImageID] = @AliExpressImageID_7 , [AliExpressImageUrl] = @AliExpressImageUrl_7 , [IsCover] = @IsCover_7 , [AddTime] = @AddTime_7 , [UpdateTime] = @UpdateTime_7 , [Sort] = @Sort_7 , [ImageFileName] = @ImageFileName_7 , [ImageSize] = @ImageSize_7 , [ImageType] = @ImageType_7 where ID=@ID_7 ; | 51643 | 4.9565 | 236329 | 9741 | 226588 | 0 | 2995 | 表更新太频繁，排查原因 |
|
3.最后代码提交记录
