分页改为inner join的方式
http://imysql.com/2014/07/26/mysql-optimization-case-paging-optimize.shtml
SELECT * FROM `FONTANA_GAMBLING` LIMIT 4863000, 1000
SELECT
*
FROM
`FONTANA_GAMBLING` t1
INNER JOIN
(SELECT
id
FROM
`FONTANA_GAMBLING`
LIMIT 4863000, 1000) t2 USING (id)
原文：http://www.cnblogs.com/MYSQLZOUQI/p/6909956.html