1.查询
select * from `table` where `id`=1 and `name` in (2,3,4) and `age` in (select `age` from `table2` where 'sex`=1) group by `id` desc limit 10