INNER JOIN t_category tc1 ON tc.comb_code = tc1.comb_code AND tc.lft <= tc1.lft AND tc.rgt >= tc1.rgt AND tc1.`status` = 0 AND tc1.platform_type = 1 AND tc1.is_deleted = 0
INNER JOIN t_sku_category_amazon sca ON sca.category_id = tc1.id
WHERE tc.`status` = 0 AND tc.platform_type = 1 AND tc.is_deleted = 0 AND tc.customer_id = 1 AND sca.sku IN ( '15674814' , '15671428' , '15679274' , '15598297' , '15683881' , '15681463' , '15682439' , '15683526' , '15675909' , '15680013' , '15681465' , '15682554' , '15681588' , '15683523' , '15683644' , '15674822' , '15670584' , '15679038' , '15680020' , '15680029' , '15683417' , '15683899' , '15681115' , '15682324' , '15675800' , '15675803' , '15673983' , '15674831' , '15675920' , '15682454' , '15683664' , '15682572' , '15680033' , '15683420' , '15682450' , '15682338' , '15683548' , '15683428' , '15679171' , '15682578' , '15682579' , '15681247' , '15682335' , '15683666' , '15671454' , '15675932' , '15675814' , '15675939' , '15671459' , '15673991' , '15671458' , '15674720' , '15682101' , '15682462' , '15682224' , '15683555' , '15681016' , '15682346' , '15671582' , '15674738' , '15675828' , '15683202' , '15684411' , '15682594' , '15682474' , '15683328' , '15683326' , '15675834' , '15675957' , '15671590' , '15675830' , '15675952' , '15682000' , '15683573' , '15682485' , '15683339' , '15682006' , '15675603' , '15674639' , '15674750' , '15674510' , '15682497' , '15682374' , '15683582' , '15616907' , '15679092' , '15683225' , '15675856' , '15675976' , '15672227' , '15675618' , '15682387' , '15683476' , '15684324' );
优化建议;
SELECT DISTINCT sca.sku FROM t_category tc
INNER JOIN t_sku_category_amazon sca ON sca.category_id = tc.id
WHERE tc.`status` = 0 AND tc.platform_type = 1 AND tc.is_deleted = 0 AND tc.customer_id = 1 AND sca.sku IN ( '15674814' , '15671428' , '15679274' , '15598297' , '15683881' , '15681463' , '15682439' , '15683526' , '15675909' , '15680013' , '15681465' , '15682554' , '15681588' , '15683523' , '15683644' , '15674822' , '15670584' , '15679038' , '15680020' , '15680029' , '15683417' , '15683899' , '15681115' , '15682324' , '15675800' , '15675803' , '15673983' , '15674831' , '15675920' , '15682454' , '15683664' , '15682572' , '15680033' , '15683420' , '15682450' , '15682338' , '15683548' , '15683428' , '15679171' , '15682578' , '15682579' , '15681247' , '15682335' , '15683666' , '15671454' , '15675932' , '15675814' , '15675939' , '15671459' , '15673991' , '15671458' , '15674720' , '15682101' , '15682462' , '15682224' , '15683555' , '15681016' , '15682346' , '15671582' , '15674738' , '15675828' , '15683202' , '15684411' , '15682594' , '15682474' , '15683328' , '15683326' , '15675834' , '15675957' , '15671590' , '15675830' , '15675952' , '15682000' , '15683573' , '15682485' , '15683339' , '15682006' , '15675603' , '15674639' , '15674750' , '15674510' , '15682497' , '15682374' , '15683582' , '15616907' , '15679092' , '15683225' , '15675856' , '15675976' , '15672227' , '15675618' , '15682387' , '15683476' , '15684324' );
去掉 tc.lft <= tc1.lft AND tc.rgt >= tc1.rgt