-- 当前文章
SELECT * FROM t_news where id = 30
-- 上一篇文章
select * from t_news WHERE id < 30 ORDER BY id DESC LIMIT 1
-- 下一篇文章
select * from t_news WHERE id > 30 ORDER BY id ASC LIMIT 1
-- 当前文章
SELECT * FROM t_news where id = 30
-- 上一篇文章
select * from t_news WHERE id < 30 ORDER BY id DESC LIMIT 1
-- 下一篇文章
select * from t_news WHERE id > 30 ORDER BY id ASC LIMIT 1