[步骤]
SELECT SKU, ProductSize, ProductColor, ProductMaterial, ProductGroupSKU, Length, Width, Height FROM RB_Product (nolock) WHERE SKU IN (N'15709621')
SELECT SKU, ProductSize, ProductColor, ProductMaterial, ProductGroupSKU, Length, Width, Height FROM RB_Product (nolock) WHERE SKU IN (N'14171693')
SELECT SKU, ProductSize, ProductColor, ProductMaterial, ProductGroupSKU, Length, Width, Height FROM RB_Product (nolock) WHERE SKU IN (N'15520686')
SELECT SKU, ProductSize, ProductColor, ProductMaterial, ProductGroupSKU, Length, Width, Height FROM RB_Product (nolock) WHERE SKU IN (N'19531396')

WHERE SKU IN (N'19531396') 无需包含N 并且缺少 CustomerID =? 的条件,请求数量极大 添加缓存
[结果]
[期望]
1.去掉 其中的字符串N 2 添加 CustomerID =1 的条件,3,添加缓存,减少数据库的请求