如果 一定 要用IN的话,就把IN里面的分成两块:
select * fron tablename where id in (..)
union all
select * from tablename where id in (...)
select * fron tablename where id in (..)
union all
select * from tablename where id in (...)
select * from tb where exists(select bm from tab_tmp);
这样的效率会很高