深圳智汇创想科技有限公司

[步骤]

慢SQL:  

SELECT `Id`,`OrderSourceID`,`OrderSourceName`,`SiteCode`,`OrderSourceSKU`,`Sku`,`OrderSourceSKUID`,`BrowseNodeID`,`BrowseNodeName`,`BrowseNodeNameCn`,`BrowsePathByID`,`BrowsePathByName`,`IsEndNode`,`IsEnable`,`AddTime`,`UpdateTime` FROM `Amazon_SaleListing_Category`  WHERE (( `OrderSourceID` = 7905 ) AND  (`OrderSourceSKU` IN ('4MQN4021EVXZ9TWLN1NX23ZX','E24E18566AY','171C1MYVPD302TE4Z4T39LG4U','0U393U04Q1FS17A','HY83RPG5209WUH1722J','LIO0917M53I1V222L805C','17SIUWB54YGP3TL022L','ZK557CQ11722WN','08CV00NS23GUAW6PEO','0XB23084Z16LE','MIXV24MMJBTZB0816R4','TRRR32528S5D16ZK','OZM53JZJKC716O321TBX','16AV93253W96FP','JBX74O0JB385GP1646GJ0Y2','513F146386JHVH','10563OYVA5E556S3I','ONWBIL05L6GP955QP16NY1','06255R28EB55KD281K16N','16U07HIH5550EOIU','0816FQXK55NW6GGL','IFG39INO0717P40','M07402CFW517Y','Y07S416U17WI51','07428YI17ZLF3S','OHPAV133992YNNODQ030ERQ4P','31GJZH19ZOV0Y194331TH0ZK7','JC205728E3VZ14A','2598HB9F914NXKL','12901X14W2BT9TGL6','07033TYDPG9V18MEYO','18B0803B244D','IC405Z6YT4015UF','B27913177CPM','X7L3194G5AI0O4K327717Y27C','1GQ27331HKE179964TZNNR37','2V140M02906IMWFXP1J','14104S22PK3IJ0','11R142W47ZR5CT5O9U4EPDTM6','M4999VZZ19LO2M061DR6L','0649HC19E9','S09552RDFQ51WXNA1BS1P','N3X1746MRU326N3LTK','14RV809S46NJ10KVL','R518TAYG18N5B10VN2HHHYDJ9','35HHQ13316A','21Q11Y46213VAY','11F8ICO42213Q10','3810IIQ14YL2637PYGJ','WJGX5X10BM5556OALHEJW','KKKPCP41236354Q9','01DP08RK2DRBQ81837JR26U','28QEQ1588IQ','53616XE28EN05U6IOH','E7AGUG517ZNL5KRJBE4313SXV','J020018GEZ','PD001028AY','DU137438JIDYA','LYY525AJ11414X66LEDTY0SJ','XXT3TG11005EOG516E5IMOR','V795U57MG1D61503XITQU','D15G491Y2075Z3A','438208OO17U','01237J6J17CQY38SO2SF2W','33F17A0WC5H36IXO8IY','3SL17147748S','461168DCQ11KURGKC','YI1224080LN0N0AVHI0J6','WS11G02E16H52','15CZ5849HXWHP64E','Q5941020N0','7K41634414DS8','PB4K1E934CF4510G','0FR1418658JU','5E3J41I15972C2211H','5PVLB90034K5HQOTP117PC3','T341531W2VXQ2X3','24Y56O1144','O061440D6Z7UM87FBNDQS6','4530UVIFL717Z9RG9EZF47A6I','BUXIM22492ETM18Z','32552T525KF','KLN255225NRKGBG652VOWU','T3G5OJW0656H0LG23CPNSW','L23XIL06574SAW7','B5STCTKW230576KIUP','8H6Q57A2306KPI','S17856VZJ710L4','Z8ZTY2OCRQ44UVXLV58181TM','DAG116E10P070L49FG9','6QDLK39ZR43RYRGJ11D16HNTV','K3F434HDS395SWR11GU','18F90921KELMRM176EZGNSY5','P7328V7J39NAH152','20C02TP191AN','2002AL7D9G19S','7N2002194C','2019ND8VMX02X6PL','U022019JIC6I','NQ19S6KH153FA7708NRC','17L53V707GGMB2QA58Q7GBTPI','UY2818WW46IDNT5R22','K5000917RVDR','I44B50X10GZF4PRM','102200P16O','1621G28JT6F2VB9W63F0V44','2DKLWQG52MI9747515V5IV95X','Q613TS57N1574V0ROOE','Q16O1417OQ3','3715XG2W17V716TR2R','N10K09JJZAO93NTHNJROE18H','H9DC2206IPMQ8KS7ST1057ZG','319650QF7382U6E0C','PTW8X12N111D45LGZFOL','5FLI41WN13UYDDT175MXB','4517OPR180','I53839PC17183H5IJ','2112544XWOJ','31580214O784','1441M5054J','X3GD4L1125D6CV6201XU7XWT','I12V5317HW66UJ','NR18I046B62B302C54T','L5Q3422E9CJD61XX18N','16G16FTZ1OV11DYT71Y','1637A33FJ9','25YZK505UNRLK416M34B','31PT204C22BCAO17RG13','FPZB6HXC02XJOO17245KWA','LQKP17F55RL40NEG','17Y5AX44YUZE55BKA8TLK8Z4E','U06S55T13Z','11F4144P303V82K','11P4130UM3','113835JXAPK','WWIHX023L2AZUWZAOA29V15D5','3JR24I37916CQ2AVENL','123716QG6UROTTR47S68N89DC','1JOK7T0710R9PH42TLIDW','F321201KB6PCCJ','911B4IP203794BXMKEE','25211I110O7','F48581111O','U53W114VA15D8TP8ATP','V19372B145','0542X15UM2F','4418Q14SZHQD7N','8A56YSX9L1420C020JIAV','HLQDQP6H0423S56A3K0PO','204I3563R23J','8DWDB04WOTZY4X56VWDHR2307','860352103XBKWZ','90P8A143W58E710PD56K37V1L','V6U063TB4313V','OX7FT30NQDXLJ150WS16E','34ZBH58JB009Y','HD9L7S801O111OGUUY45BPMQ','6165574QNM7TADJY2OW','J0459L55BPVN','W3527MEW1630','49452UKEYQ17S9','581349LVCVQ','14Y05OPB04WT5','16Z8441314PV','20522119KGLE6','IM1411O07IVE8','CJC9P5O03913R34GT99L2','00GN16413Y2N15K4DD4YQH','02N04Q09S1631C1','5094X02916MB4DTJ','KUPXK156420GRC05N8','YX4LMQVN44V404DI26B8B097','0115O58OTJT','RA6303FB00CV1108NB','5B226424S144','4QF6V0OP4214B26ITWW43EV','1034QHJZBJT843A7I','12F2U5IW251650PTV','FF816V5197120L0LXB','G57T1134366389CDHM2','451137380NR','1137838F80','M8XXTQ01A1W41353LB1H','DJ13D01U53E54','3NEV1110E4658UYO5GLZ3FK5T','00SA1147CO39L2DQSUJ','53494RV9A1V115','09H03YUC144RAILN','BGR50WA49L3096','742260JVC10872','62822VK4OR4CN5B11I','V351132B2CK','X283NYQMXW03VO11VT2GI7','B618PY7T0Y33VLKOW140N34P','2742UN14M1','E066A14R5BR42ETU','30B15R9521NT','34579A3D0997ZQL47NMMOXVF','N3W49811BU11JM215FW','N8TC13LYE48748D4MG9S0U8','6511371BOG16AG','2205EBC18K6SZL','MB323454J20TU3BQI','FO24YF347W2096YD728AC','A916LB459HO5966J','17HEOG071N326ETCKASF05FSX','49M0379GOAOY','YU103098RGN4A2XUEVQ56C3IR','08S11PZTGX18KQC1','3004180QH9N','J54MJ543090GI5VXX7HYJP','09615118HENF','JXVA811912CFPOD4Q045ATPH6','10C0810W8DDC','B3313O58TOE','A3227315J3R','LP2858Q018T','18O2818O58IAS3','BXSIGA58182U28XLUTP3F0B','KD48401VDA19W47TZLPV','0481CR019Z','G2014YL1948HFPQBR','Y3BHLE1977368IM05A0KPDSIJ','OQP054X3364LM3MLKQ19KYQ6D','369190GRJYEN9D4NQ05VA94','27Q123717YPSRI','14D8L38YPS224EW540','172SBUJQHV35FIDN2754T5','J55ZND117H26UYXC5T8QUU','43N719MICDM36UVE30ZN8BO','X136O43QT7Y3W19K64DAD','4572ML155NNQKOEIP7U55W0S','B120547QR3','UI1X537K0S219SJC6140QR','54CL0620D4IA','N5Y5042456SGZBY8200W','H20RC1552SJ9B','YRW357G3U1006N3MPQGRTD','E3005FD7C16B','4FG00IHH3516OO','0R7ZH1F11AQJLS44WN14RLP','143DVU44RWV2117ZB','1414CETV6J44O5XNB417WX2','17WLFTGE59TER45YPFIYLA','WL3052221O','FQS241NW610A52TYR','K153C2I45127K3F7','110036J8ZPAC2I','WD5572415Z54W5B4HNLFUY1','7EFL16N1248PD3','2QPDUMK38KG105B6Q10G','17G43R23X8WMZT','00728X7JTGF16QOT7L5','15393965XBSDE70091TF4AN1F','W5502CX09WOZS','0153BO167J','BX227T171CD0ME45EDZFYITIU','37151915SNTW5J','UZ7HMT23PZUS61Z8074Q16SGM','061422CDD5','2EI1224QF5VF432S6K2','C7Y07B307O12UW17FSLEVDE','L172G007VVX9ZTYV12MOG','T511OD377T1020JSWR','PXH20EX3656PUPJ','IX728ZM2QG14966M18O6IY','49J1317CTN9F3','16743W178LJ1DH','S18J26JO528887CT','64I5818928F527AE','0727E33617D','25N176Z07M2776HM9D','IDZD15QBUE0KA41NZB095','11D6519H15JMFTMKJK9','1317T485XPB','1743186DUW','72H03E118P53UCO5HF8I5Z','092337VPT18H','FZ237309SHEQLQEE','X3WE15OA2EXPF48HJI58T0B','0M1253H18BLAGWJTU','08E751095T','112HJ6BP00A53P0WBPHH0CEEG','9DNDD4315LH9151DQN','MUEBYDO0598NT4717T6WJP','WZJH7M3AD01NOU1Y5118KA5K8','016DNWOQ189H951BDV0LFBQ6P','H38185235II7BS3G4')) );

[结果]

[期望]

SQL全表扫描，优化索引， in 后面的数量 进行控制，推荐不超过 10个