[性能问题描述]
select
pr.SKU as prosku,
pr.ComeSource,pr.ProductNameCn,
pr.ProductProperty,pr.WithBattery,
pr.PlugRelate,pr.UnitName,
pr.ProductColor,pr.LastSupplierPrice,
pr.MarketPrice,pr.SalePrice,
pr.ProductState,
pr.ProdutcArrivalDate,
pr.ProdutStopDate,
pr.MinSaleNum,
pr.GrossWeight,
pr.NetWeight,
pr.ClassID,
pra.DevelopAdminID,
pra.DevelopAdminName,
pra.BuyerID,
pra.BuyerName,
pra.DevelopStatus
from RB_Product pr
left join RB_Product_SupplierPrice prs on pr.CustomerID=prs.CustomerID and pr.SKU=prs.SKU
left join RB_Product_Admin pra on pr.CustomerID=pra.CustomerID and pr.SKU=pra.SKU
left join RB_Product_Class prc on pr.ClassID = prc.ID and pr.CustomerID=prc.CustomerID
where pr.SKU in ('13943212','13943021','13942847','13942808','13942781','13939535','13939519') and pr.CustomerID=1

[分析过程]
[期望结果]查询参数合理参数化
执行了很多遍,这个语句查询很快,都是秒出,出现超时是当时数据库整体太卡导致的