select z.* from table as z, (select (max(id) - 100) as BegID from table ) as m where z.ID >= m.BegID order by z.id desc
create index ix_tb_id on tb(id desc) --为ID创建索引
給id加上索引試試.
34,590
社区成员
254,589
社区内容
加载中
试试用AI创作助手写篇文章吧