如何在MySQL中使用单个查询查找上一条和下一条记录？

I have a database, and I want to find out the previous and next record ordered by ID, using a single query. I tried to do a union but that does not work. :( I have a database, and I want to find out the p