mysql分页高效率方法

SELECT id,user_id, booth_id, fid, start_time, end_time, stay_time, user_type, user_activity, user_interest, booth_type FROM track_20180518 where id>=(SELECT id FROM track_20180518  ORDER BY user_id, start_time LIMIT 0, 1)  ORDER BY user_id, start_time  LIMIT 1000000