MySQL uses limit to implement paging example method

Received from client {pageNo:1,pagesize:10} 
select * from table limit (pageNo-1) * pageSize, pageSize;

Received from client {pageNo:5,pageSize:30} 

select * from table limit (pageNo-1) * pageSize,pageSize;

Assume the primary key or unique index is good_id 
Received from client {pageNo:5,pagesize:10} 
select * from table where good_id > (pageNo-1) * pageSize limit pageSize; 
–Return data with good_id between 40 and 50

select * from table where good_id > (pageNo-1)*pageSize order by good_id limit pageSize; 
–Return data with good_id between 40 and 50, and sort the data by good_id

Display 10 items per page:
Currently 118 120, 125

In reverse order:
      Size 980 970 7 6 6 5 54 43 32

21 19 98   
Next page:

  select 
    * 
  from 
    tb1 
  where 
    nid < (select nid from (select nid from tb1 where nid < current page minimum value order by nid desc limit data per page * [page number - current page]) A order by A.nid asc limit 1) 
  order by 
    nid desc 
  limit 10;



  select 
    * 
  from 
    tb1 
  where 
    nid < (select nid from (select nid from tb1 where nid < 970 order by nid desc limit 40) A order by A.nid asc limit 1) 
  order by 
    nid desc 
  limit 10;


Previous page:

  select 
    * 
  from 
    tb1 
  where 
    nid < (select nid from (select nid from tb1 where nid > current page maximum value order by nid asc limit data per page * [current page - page number]) A order by A.nid asc limit 1) 
  order by 
    nid desc 
  limit 10;


  select 
    * 
  from 
    tb1 
  where 
    nid < (select nid from (select nid from tb1 where nid > 980 order by nid asc limit 20) A order by A.nid desc limit 1) 
  order by 
    nid desc 
  limit 10;