1.原sql
| SQL | 执行次数 | 平均I_O | 总I_O | 逻辑写 | 逻辑读 | CPU平均耗时 | 总CPU耗时_秒 | 优化建议 |
| (@1 tinyint,@2 varchar(8000))SELECT [ID],[CustomerID],[SKU],[ProductGroupSKU],[ComeSource],[ReferenceUrl],[ClientSKU],[ProductName],[ProductNameCN],[SearchKeyword],[ProductProperty],[WithBattery],[ProductState],[PlugRelate],[OnlineStatus],[BeginTime],[EndTime],[ProductModelID],[ClassID],[ClassID1],[ClassID2],[BrandID],[LastSupplierPrice],[LastBuyPrice],[MarketPrice],[SalePrice],[MinSalePrice],[MinSaleNum],[ImageUrl],[NetWeight],[GrossWeight],[PackWeight],[Length],[Width],[Height],[Pack_Length],[Pack_Width],[Pack_Height],[PageTitle],[MateKeyword],[MateDescription],[ProductDescription],[PackingList],[FeatureList],[UnitName],[UnitNum],[Url],[AdvanceSale],[PlanArriveDate],[OrderProductCount],[RecommendType],[IsGroup],[SupplyState],[ProdutcArrivalDate],[ProdutStopDate],[NewUploadUpdateDateTime],[NewUploadImageDateTime],[ProductColor],[ProductSize],[TempOrderState],[IsRawMaterial],[UnitShipFee],[SMTProID],[LastBuyShipFee],[DeleteStatus],[IsNeedPhoto],[PlugRelateType],[Undercarriage],[ProductStateRemarks],[AddedOrderSourceTypes],[ReceiptRemark],[IsQualitInCollection],[ProductType],[TaxPoint],[TaxRate],[IsFBABarCode],[IsRecommendOcean],[Carton_Length],[Carton_Width],[Carton_Height],[Carton_PcsNum],[Carton_GrossWeight],[Carton_NetWeight],[UpdateTaxRateTime],[LastSinglePrice],[IsCheckTransport],[IsCheckDeclarationCode],[NeedToPackType],[ProductSpec],[DefaultLocalWarehouse],[IsDiscontinuedApprove],[DiscontinuedApproveReason],[DiscontinuedApproveApplicant],[DiscontinuedApproveApplicantId],[DiscontinuedApproveApplyTime],[IsBiSycnComplete],[BiSycnCompleteTime],[IsPreclass],[PreclassStatus],[AddTime],[UpdateTime],[ReportingElements],[DevelopType],[AppointDevelopType],[PictureSource],[PreclassType],[Is1688DistributeProduct],[PreclassGoodsCode],[PreclassNumber],[YunAccountId],[ImitatingBrandRemark],[ClassPath],[IsTranslationLanguage],[IsHaveSetSaleSource],[IsSpu],[IsIntelligentStocking],[IsMainGroupSKU],[ImageUpdateTime],[AccurateKeyword],[IsKeyAttributesEdit],[BrandLevel],[IsLogisticsCheck],[LogisticsCheckType],[EditNum],[ProductMaterial],[HolidayID],[IsNeedCeCertification],[GroupSkuID],[IsInfringementConfirm],[AutoChooseKeyWords],[ProductSizeName],[PackingListCn],[TypeOfTorts],[IsSingleDistributeBuyerId],[RiskLevel],[RiskLevelRemark],[IsSeparateDefaultWarehouseSetting],[AccurateKeywordDesc],[IsSelfieToCollection],[IsSyncAndCheckFeature],[MultiGroupSKUDefalutLocalWarehouBySKU],[HasLawFirmAgent] FROM [RB_Product](nolock) WHERE [CustomerID]=@1 AND [SKU]=@2 | 30826 | 18.4 | 619988 | 0 | 619988 | 0 | 8139 |
检查请求频率高是否合 理 |
3.最后提交记录
