mysql 查询前后相邻10条记录

select * from(select * from tbl where win <= (select  min(win)  from tbl where id='foo') orderby win desc limit 6unionselect * from tbl where win > (select  min(win)  from tbl where id='foo') orderby win limit 5) as aorderby win;