mysql offset,limit在offset较大时的优化

查某个表中的分页数据， 分页较深的情况会出现慢查询

例如：SELECT * from tableA where mage_id = 1 order by id desc limit 1219060,10

优化方法：
SELECT a.id, a.mage_id, a.follower_mage_id, a.create_time, a.follow_source from tableA a 
join (select id from tableA where mage_id=1 order by id desc limit 1219060,1) b
on a.id<=b.id and a.mage_id = 1 order by a.id desc
limit 10