My SQL Efficient Paging

/* * Normal paging * Offset on data file 1000000 isolated 10 */select *from zoldesk_92game_net_ecms_bjwhere classid=303order by ID asclimit 1000000,10 ;/* * Efficient paging, identifying the starting index on the index * 2, from the starting index to detect 10 */select * from ZOLDESK_92GAME_NET_ECMS_BJ WHERE ID >= (    SELECT ID from    z OLDESK_92GAME_NET_ECMS_BJ    where classid=303    ORDER by id ASC    LIMIT 1000000, 1) and Classid=303order by ID Asclimit 10;

This is the downstairs approach.

SELECT * FROM ZOLDESK_92GAME_NET_ECMS_BJ WHERE ID in    (        select id from     (        select id from            zoldesk_ 92GAME_NET_ECMS_BJ            where classid=303            ORDER by id ASC            LIMIT 1000000, as    temp)

My SQL Efficient Paging