Mysql 如何不用子查询查询当前数据的上一条和下一条的记录

//上一个
$map1['status'] = '1';
$map1['isvr'] = '2';
$map1['id'] = array('LT', $id);
$shangcase = $cases->where($map1)->order('id desc')->limit(1)->find();
$this->assign('shangcase',$shangcase);


//下一个
$map2['status'] = '1';
$map2['isvr'] = '2';
$map2['id'] = array('GT', $id);
$xiacase = $cases->where($map2)->order('id')->limit(1)->find();
$this->assign('xiacase',$xiacase);

原理

上一页：SELECT * FROM b_county WHERE id < 10 GROUP BY id DESC LIMIT 1
下一页：SELECT * FROM b_county WHERE id > 10 GROUP BY id LIMIT 1
通过你给的id用group by排序然后用limit拿去第一条，下一页就是正序，上一页就是倒序