explain select cat_id from `273utfyogou`.`ecs_article_cat` where parent_id in (select cat_id from `273utfyogou`.`ecs_article_cat` where cat_id not in(1,14,11) and parent_id=0 order by sort_order desc)id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY ecs_article_cat ALL 26 Using where
2 DEPENDENT SUBQUERY ecs_article_cat unique_subquery PRIMARY,parent_id PRIMARY 2 func 1 Using where
1 PRIMARY ecs_article_cat ALL 26 Using where
2 DEPENDENT SUBQUERY ecs_article_cat unique_subquery PRIMARY,parent_id PRIMARY 2 func 1 Using where
from ecs_article_cat a,(
select cat_id from `273utfyogou`.`ecs_article_cat`
where cat_id not in(1,14,11)
and parent_id=0
order by sort_order desc) b
where a.parent_id=b.cat_id