[步骤]

(@CustomerID0 int)SELECT * FROM (SELECT  [SKU] AS [SKU] , [OriginalImageUrl] AS [OriginalImage] , [ImageUrl] AS [MarketingImage] ,ROW_NUMBER() OVER(ORDER BY [ID] ASC) AS RowIndex  FROM [RB_Product_Image_Marketing] WITH(NOLOCK)   WHERE ( [CustomerID] = @CustomerID0 )  AND  ([SKU] IN ('11480436','11477276','11483943','11512121','10970721','11545052','11547229','11511266','11514777','11482628','11547241','11491112','11547244','11491115','11501441','11487094','11511254','11520196','11502786','11522375','11553926','11480469','11503627','10279108','11524140','11491132','11480472','11483984','11451084','11533021','11535681','11524130','11282116','11546341','11494636','11545014','11502365','11546344','11501033','11550835','11503206','11556155','11515647','11503667','11529814','11527635','11504990','11516504','11550843','11536554','11550856','11534381','11523259','11537415','11509341','11520137','11519159','11533461','11480038','11479051','11519158','11535646','10372705','11494679','11522795','11522786','11523636','11545461','11550808','11480061','11483566','11501852','11499905','11518279','11535673','11537853','11555682','11533416','11523214','11502751','11543223','11499939','11483587','11545878','11483105','11487946','11533423','11492055','11502764','11480093','11548921','11525861','11488801','11534762','11512539','11494265','11535614','11499955','11533438','11508033','11520157','11535624','11498614','11499941','11501409','11533451','11494166','11530348','11495019','11545832','11544985','11486537','11488711','11509754','11540159','11521860','11506244','11544521','11528499','11542338','11518218','11544517','11552136','11544525','11517351','11497203','11553013','11499867','11478942','11510706','11515164','11520984','11486565','11518673','11508458','11499417','11552571','11512952','11520580','11479803','11490605','11524936','11491939','11488756','10445413','11495060','11476780','11369043','11554743','11487429','11552563','11532973','11486590','11520565','11491927','11501821','11551247','11511602','11533839','11506255','11541453','11492803','11521407','11522737','11548090','11489629','11500949','11506266','11501805','11545828','11477661','11518232','11548036','11526248','11500096','11491979','11487466','11551673','11550342','11499448','11552540','11530754','11490635','11527564','11503583','11528882','11499001','11538255','11552544','11503114','11516407','11491984','11505770','10720827','11480864','11499476','11479889','11556091','11489209','11480875','11507533','11491521','11491528','11479419','11521811','11521816','11550798','11538686','11548012','11532907','11538210','11478584','11538212','11483921','11541866','11489246','11489243','11508840','11535190','11535195','11489237','11481753','11515509','11515508','11515507','11500014','11488284','11527971','11495815','11523128','11511156','11552922','11511157','11478480','11524457','11536464','11505703','11511141','11491473','11556072','11524445','11523595','11547119','11538650','11482994','11480335','11534299','11550780','11504841','11546286','11524434','11501333','11500001','11502236','11478046','11527528','11548400','11546219','11550712','11527519','11535573','11537756','11512017','11501366','11523155','11502208','11515536','11535102','11500046','11483890','11528826','11538622','11515525','11535594','11482567','11513724','11507043','11545316','11537700','11484756','11484757','11519036','11532019','11501751','11545327','11523519','11482586','11524846','11534687','11532022','11503926','11532024','11486947','11524842','11523995','11523511','11523506','11486959','11537728','10579110','11483454','11487812','11510672','11532043','11491072','11510670','11540069','11521397','11502627','11531121','11532459','11511577','11358652','11483478','11502636','11535970','11511584','11555582','11523554','11501758','11482158','11487848','11510241','11510226','11520030','11501773','11542285','11522687','11487853','11511563','11532885','11487750','11482062','11542694','11538196','11520897','11486898','11545712','11527044','11530233','11532418','11510601','11520892','11509630','11486426','11490917','11498881','11517242','11554210','11478819','11526181','11526180','11526182','11544405','11495387','11475796','11533768','11506109','11505253','11547921','11486444','11490965','11511991','11507018','11510649','11512823','10970488','11491807','11501703','11501702','11501701','11541336','11479706','11517270','11553311','11476207','11499301','11499788','10720751','11491827','11521758','11486004','11552477','11538189','11555985','11505663','11540428','11490524','10898623','11543936','11480711','11547071','11547076','11532814','11503018','11529624','11535091','10532832','11552896','11551564','11490540','11492725','11490546','11487371','11513273','11552428','11489544','11515455','11514123','11552421','11504326','11518948','11490539','11488227','11516779','11539402','11503056','11507415','11506568','11517204','11537239','11529650','11490588','11549227','11528322','11488259','11515498','10279032','11483818','11490573','11518509','11479318','11004445','11535072','11550698','11481638','11503884','11491330','11478360','11478364','11537665','11511035','11536337','11488170','11503893','11526995','11502564','11513688','11511020','11538522','11547484','11525647','11547490','11489047','11492678','11490019','11537691','11551507','11481551','11539872','11535038','11535437','11491372','11502597','11547422','11482895','11518945','11517615','11534596','11514584','11525224','11512393','11481578','11540805','11491394','11543083','11513228','11502572','11489075','11533281','11503418','11513233','11570698','11513230','11570697','10397846','11536317','11493563','11543096','11495747','11523026','11501252','11481110','11547448','11537657','11513601','11530190','11501611','11534550','11535408','11509592','11545698','11536740','11495794','11514914','11547881','11520358','11511892','11512741','11485989','11502928','11546561','11544383','11482491','11521679','11485993','11502993','11545634','11482494','11544305','11501659','11523446','11502503','11481166','11514501','11510144','11512308','11512304','11493146','11525623','11543472','11502517','11512313','11521251','11526942','11535863','11486879','11534536','11545670','11522571','11513621','11507326','11487626','11490806','11533620','11519310','11506487','11546947','11486310','11517592','11517595','11505136','11543453','11488502','11553246','11510539','11530545','11508213','11539362','11518028','11502907','11529145','11550163','11490836','11522986','11518016','11541690','11502912','11551008','11538047','10458110','11553200','11532747','11487210','11522983','11507341','11486360','11487207','10898717','11543877','11488533','11499684','11554521','11531427','11529126','11543885','11540383','11522967','11544739','11550178','11497037','11530506','11546098','11527336','11478755','11526485','11516682','11488556','11490870','11490871','11490872','11552778','11509908','11480603','11502015','11490425','11525135','11527311','11479629','11539343','11552307','11517516','11516668','11553632','11527780','11503357','11517979','11478303','11542512','11525119','11555829','11552798','11513144','11538027','11528228','11488119','11505117','11527360','11487283','11542933','11518417','11552735','11480648','11499250','11509921','11493973','11490463','11546079','11490467','11515371','11552745','11539300','11546082','11492634','11513185','11537130','11517546','11480663','11537137','11538469','11507749','11550573','11513186','11514417','11537539','11493872','11530902','11524218','11538876','11536698','11501590','11510048','11521185','11489389','11488053','11494716','11534044','11490384','11530923','11502896','11549542','11522026','11526858','11510042','11542909','11491226','11552719','11551868','11480101','11502899','11499194','11504651','11527772','11515790','11525107','11481441','11514465','11536659','11494302','11538849','11494304','11550966','11529927','11534012','11513111','11538850','11534498','11510087','11491260','11546005','11510071','11549509','11533176','11536202','11536605','11521593','11544232','11549917','11479171','11514805','11491286','11510446','11495649','11543393','11501502','11517083','11494343','11533119','11496523','11512613','11525926','11486711','11529050','11533123','11534459','11508128','11510428','11496992','11545591','11496995','11546440','11545595','11518395','11533136','11554476','11535711','11531357','11493032','11515704','11496544','11525994','11544675','11522486','11476936','11522001','11545997','11480199','11512685','11535721','11511339','11492175','11513997','11502401','11520293','11537908','11545523','11521136','11485892','11482387','11512670','11535730','11496563','11533556','11533559','11509000','11544695','11523307','11544687','11501517','11482395','11531386','11498735','11495227','11523301','11522454','11502855','11510474','11487618','11534826','11510853','11545959','11532652','11552245','11490703','11490705','11487526','11530012','11534854','11532676','11499984','11535709','11545993','11527268','11479914','11522800','11544658','11555789','11519640','11496000','11531353','11533936','11492903','11483192','11520218','11506390','11517057','11501938','11510886','11496016','11501951','11485382','11518370','11553549','11523718','11529491','11509885','11543759','11504190','11497367','11555750','11510863','11511711','11520673','11505054','11545944','11519206','11505421','11528547','11488441','11502396','11479973','11480950','11551330','11528533','11549018','11514378','11551321','11378919','11496089','11422297','11505404','11548177','11491635','11512185','11490774','11488476','11490775','11528995','11488468','11515203','11538389','11547263','11547264','11478683','11510800','11545093','11530831','11505479','11526392','11490797','11489341','11515264','11481851','11536141','11537479','11526384','11489355','11499147','11490336','11488034','11489361','11489357','11538346')) ) T WHERE RowIndex BETWEEN 1 AND 20

SQL 语句 查询In 太多 依赖系统的统计信息 更新，没有及时更新就阻塞

[结果]

[期望]