任务描述
查询条件做缓存Key，查询列做缓存值
需求描述
1.待优化Sql
| 10 | (@1 smallint)SELECT [ID],[CustomerID],[OrderSourceType],[OrderSourceName],[OrderSourceImage],[SendDeliveryEmail],[SendDeliveryEmailTitle],[SendDeliveryEmailTemplate],[OrderSourceCountry],[DefaultWareHouseID],[DefaultTransportID],[SaleAdminID],[SaleAd | (@1 smallint)SELECT [ID],[CustomerID],[OrderSourceType],[OrderSourceName],[OrderSourceImage],[SendDeliveryEmail],[SendDeliveryEmailTitle],[SendDeliveryEmailTemplate],[OrderSourceCountry],[DefaultWareHouseID],[DefaultTransportID],[SaleAdminID],[SaleAdminName],[ServiceAdminID],[ServiceAdminName],[ServiceEmail],[SameAddressMergerPackage],[UpdateTrackNumberPlatform],[OrderNeedCheck],[IsActive],[AddAdminID],[AddAdminName],[AddTime],[UpdateTime],[IsPrintNote],[IsPrintPirckingOrder],[TrackingNOConfig],[DomainName],[TuanGouOrderType],[TuanGouCurrency],[ApiID],[ImgDomainName],[VATRatio],[ExchangeRateLoss],[SourceStatus],[CDNDomainName],[CDNImgDomainName],[IsB2CCustoms],[OrderSynCycle],[IsNoRules],[PriorityNum],[OrderSourceEmail],[IsDelete],[IsDownloadOrder],[IsGetTrackNo],[IsMarkDelivery],[IsReceiveMail],[IsSendMail],[RealShopName],[VATNumber],[LogisticsTemplateID],[VATRate],[CustomsPeopleManageID],[IsAutoDownLoadWishListing],[IsDownLoadOrderLoan],[OrderLoanStartTime],[RemovalOrderDefaultWareHouseID],[SaleVATRatio],[ReportEncoding],[ChildShopID],[SetShipDays],[IsBoutique],[PayPalAccountID],[OverseasWarehouseUpdatetime],[SenderTaxNumber],[WareHouseAccountType],[IsMainShop],[EORI],[ChannelPlatformStatus],[RemovalOrderTelephone],[ReasonWithException],[ReasonWithPause],[ReasonWithRemark] FROM [RB_OrderSource](nolock) WHERE [ID]=@1 | 57935 | 10 | 624385 | 0 | 624385 | 0 | 6539 | 全表查询做缓存，其他数据从缓存中读取，找不到查一遍数据库 |
3.对应最近改动文件人员
验收标准
暂无
测试地址：http://localhost:31196/xyftest.aspx