[步骤]
select p.id,p.wareHouse_id,p.sku,p.good_num,p.order_source_sku,p.fn_sku,p.stock_type from (SELECT id FROM rb_ware_house_product FORCE index(idx_sku) WHERE sku IN('17104933','21366005','22982866','18036219','7581054','4362121','22966266','9273428','15425509','2505724','20786474','2690946','4249667','4284795','15869243','1864586','7149897','1954382','8190989','13358770','22982736','22339508','4270253','17534124','2320437','11412189','15472868','13286019','14878550','15920937','2975981','2619849','18677104','4262874','20512546','1884056','10343411','4281139','22956237','18769324','2953727','10836432','1727655','19318881','2353131','7873870','21972034','20648453','2890399','4215518','11037796','21965503','7272020','19627963','8014381','2614256','2377108','4815917','13275588','4499382','1954373','17456780','22945338','1270580','12109343','21182142','12594788','22105287','1735286','17191239','16050777','9705218','13552479','22143889','4649776','1819694','21084417','17802912','12113545','17469783','7995796','9793960','16256268','14950720','2188096','20306837','15008184','2505757','21785833','16062517','19385662','4441061','8990982','14760224','2738080','4294011','1876630','2079261','17995376','16303791','19668397','2144167','22945384','4133130','22945385','6954119','6892622','4486393','22972850','10760721','2972498','19576002','17089780','4278910','9894324','21552659','9320561','12295311','7070768','10023364','7760408','22995863','9054992','19264506','10756950','22463755','18660539','19532666','19570903','4139843','13326638','20773214','12013940','4581659','6996689','2245999','1986101','2430430','2956982','22040241','2829639','11860658','11022203','7742587','22964960','17096102','10355181','17335762','8668130','2013752','8151734','22984451','2432747','20366222','7264346','22951631','14954920','1859107','2430200','19543404','7168366','2872775','16969150','22964973','4546521','16705279','7646140','22983111','22984423','11553283','2340975','22934086','2328604','2120706','2380158','17519204','16035910','17870988','22972799','2013772','22962641','2775183','14041011','20754501','17611395','23011921','1819701','1673477','9920611','23008891','22887041','9877048','2771814','7360852','21908716','4452686','8296235','18680327','1829742','22983693') and is_deleted=0 and id>0 order by id asc
) t join rb_ware_house_product p on t.id=p.id limit 1000
[结果]
[期望]
优化SQL 提升性能 减少阻塞
原来是亚马逊的sql