按日期排序并允许重复日期时，在MySQL中获取前后记录

I've tried looking up other help for this problem but I'm just not getting it. Suppose I have a table that looks like the one below.I've tried looking up other help for this probl