1.原sql
| SQL | 执行次数 | 平均I_O | 总I_O | 逻辑写 | 逻辑读 | CPU平均耗时 | 总CPU耗时_秒 | 优化建议 |
| (@1 varchar(8000),@2 tinyint)SELECT [ID],[CustomerID],[SKU],[RecommendValue],[AddAdminID],[AddAdminName],[AddTime],[ToDevelopMemo],[DevelopStatus],[DevelopAdminID],[DevelopAdminName],[DevelopTime],[DevelopRefuseReason],[DevelopRefuseTime],[AssignDevelopAdminID],[AssignDevelopAdminName],[ToEditorAttachment],[ToEditorMemo],[EditStatus],[EditAdminID],[EditAdminName],[EditTime],[EditRefuseReason],[EditRefuseTime],[ToImageMemo],[ImageStatus],[ImageAdminID],[ImageAdminName],[ImageTime],[ImageRefuseReason],[ImageRefuseTime],[BuyerID],[BuyerName],[BuyerSetTime],[CheckStatus],[CheckReason],[CheckAdminID],[CheckAdminName],[CheckTime],[OnlineTime],[OfflineTime],[OfflineAdminID],[OfflineAdminName],[CopyProductID],[PackageCommission],[PickingCommission],[ToProcurementCheckMemo],[PriceAdminID],[PriceAdminName],[PriceSpecialistOperatTime],[ToDeliveryPackNoteMemo],[IsEditRemarkApplyAllVariants],[ProductDevelopmentAuditTime],[ProductEditAuditTime],[ProductPictureAuditTime],[ProductStatusModifyTime],[ProductPropertyModifyTime],[UpdateTime],[DevelopmentAuditOperatorId],[DevelopmentAuditOperatorName],[EditAuditOperatorId],[EditAuditOperatorName],[PictureAuditOperatorId],[PictureAuditOperatorName],[SetStopProductionTime],[SetStopProductionOperatorId],[SetStopProductionOperatorName],[SetShortageTime],[SetShortageOperatorId],[SetShortageOperatorName],[SetClearLibraryTime],[SetClearLibraryOperatorId],[SetClearLibraryOperatorName],[SettingUpImitationCardsOperatorId],[SettingUpImitationCardsOperatorName],[SettingMoldingsTime],[IsAmazonSale],[NoSalePlatform],[PhotographerId],[PhotographerName],[PhotographerTime],[IntellectualPropertyRightsAdminID],[IntellectualPropertyRightsAdminName],[IntellectualPropertyRightsTime],[NoSaleCountry],[WrapDesignerId],[WrapDesignerName],[WrapDesignerTime],[ImageDesignerId],[ImageDesignerName],[ImageDesignerTime],[AssignDevelopTime],[CompeteAsin],[IsRiskControlEnquiry],[RiskControlEnquiryAdminId],[RiskControlEnquiryAdminName],[RiskControlEnquiryTime],[RiskLevelType],[RiskLevelRemark],[RiskLevelAdminId],[RiskLevelAdminName],[RiskLevelTime] FROM [RB_Product_Admin](NOLOCK) WHERE [SKU]=@1 AND [CustomerID]=@2 | 4362 | 7 | 39538 | 0 | 39538 | 0 | 1418 | 第三方项目调用，看看能否独立出去，访问自己本地库 |
2.Erp系统对应位置
3.代码最后提交记录
