Say:
select count(*) from where navid in (10,129,116,117,118,231,119,121,122,123,124,125,126,136,137,138,139,140,141,142,143,144,145,146,147,148,150,151,152,153,154,155,156,127,157,158,159,160,161,162,163,128) and isshow=1 and caogao=0 and isdelete=0 and (1) order by paixu asc,date desc,id descSay:
select * from where navid in (10,129,116,117,118,231,119,121,122,123,124,125,126,136,137,138,139,140,141,142,143,144,145,146,147,148,150,151,152,153,154,155,156,127,157,158,159,160,161,162,163,128) and isshow=1 and caogao=0 and isdelete=0 and (1) order by paixu asc,date desc,id desc limit 132,12