select id from alarm order by id limit 16870,1;
//改为
select * from alarm where id >= (select id from alarm order by id limit 16870,1) limit 10;
注意
要加上order by保证数据有序,分页结果一致。id范围查询应该>=
select id from alarm order by id limit 16870,1;
//改为
select * from alarm where id >= (select id from alarm order by id limit 16870,1) limit 10;
注意
要加上order by保证数据有序,分页结果一致。id范围查询应该>=