文章上一篇 下一篇

select * from t_info where colid = 7 ORDER BY create_time desc;
 -- 上一篇
select id,title from t_info where colid = (select colid from t_info where  id = '5deb4a2209634c688722a74381ef24d2') and isdelete = 1 
and  create_time > (select create_time from t_info where  id = '5deb4a2209634c688722a74381ef24d2') order by create_time LIMIT 1;
 -- 下一篇
select id,title from t_info where colid = (select colid from t_info where  id = '5deb4a2209634c688722a74381ef24d2') and isdelete = 1
and create_time < (select create_time from t_info where  id = '5deb4a2209634c688722a74381ef24d2')  order by create_time desc LIMIT 1;