SELECT
*
FROM
bjy_article
WHERE
id<10 LIMIT 1
ORDER
BY
id
DESC
; #上一篇
SELECT
*
FROM
bjy_article
WHERE
id>10 LIMIT 1; #下一篇
SELECT
*
FROM
bjy_article
WHERE
id<10 LIMIT 1
ORDER
BY
id
DESC
; #上一篇
SELECT
*
FROM
bjy_article
WHERE
id>10 LIMIT 1; #下一篇