SQL 多条件查询

select * from [表名] where id in (1,2,3,4) and isopen=0 and isshow=1