Say: select count(*) from where navid in (148) and isshow=1 and caogao=0 and isdelete=0 and (1) order by paixu asc,date desc,id descSay: select * from where navid in (148) and isshow=1 and caogao=0 and isdelete=0 and (1) order by paixu asc,date desc,id desc limit 0,0