任务描述
查询条件做缓存Key，查询列做缓存值
需求描述
1.原sql
| SQL | 执行次数 | 平均I_O | 总I_O | 逻辑写 | 逻辑读 | CPU平均耗时 | 总CPU耗时_秒 | 优化建议 |
| (@ID int)select TOP 1 [ID],[Email],[Password],[CompanyName],[RealName],[QQ],[Phone],[Address],[WebSite],[AddIP],[AddTime],[ActivityID],[CustomerSetting],[IsSystemAdmin],[BeginTime],[EndTime],[IsCheck],[CheckAdminID],[CheckAdminName],[CheckTime],[WareHousePositionType],[OrderBasketType],[Verify],[IsShowSampleOrder],[IsOpenSharing],[IsOpenDownload],[SharingName],[GatherNum],[RobBuyBoxNum],[TimingNum],[IsImageCDN],[OrdinaryGatherNum],[OrdinaryRobBuyBoxNum],[IsChainWarehouseNoOne],[AmazonListingReviewNum],[CurrentAmazonListingReviewNum],[AmazonKeywordRankingNum],[CurrentAmazonKeywordRankingNum],[ImageCDNSavePath],[InitializeDataState],[AllOrderDailyAverage],[AmazonOrderDailyAverage],[EbayDailyAveragerder],[IsUsePromotion],[EbayOrderSynCycle],[AmazonOrderSynCycle],[LLPayFee],[OverseaIsUseGroup],[EbayForStandardNum],[IsAmazonMadePlus],[CustomerManagerName],[CustomerManagerPhone],[CustomerManagerQQ],[IsCustomerManagerInformation],[IsOpenNewFBAStockOrder] from [E_Customer] (nolock) where [ID]=@ID | 20537 | 12 | 251510 | 0 | 251510 | 0 | 1359 | 全表查询做缓存，其他数据从缓存中读取，找不到查一遍数据库，或者把数据全部独立到Redis等数据库中 |
3.代码最后提交记录
验收标准
暂无
开发报告
1.根据id获取商务号配置信息，调整为优先查询缓存数据 ，默认两个小时
测试页面
SELECT IsImageCDN,* FROM E_Customer WHERE ID =1
UPDATE E_Customer SET IsImageCDN =1 WHERE ID =1