LIMIT Query Optimization
LIMIT limitFrom , perPageNum
LIMIT offset, size
MySQL :: MySQL 8.0 Reference Manual :: 13.2.10 SELECT Syntax https://dev.mysql.com/doc/refman/8.0/en/select.html
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
offset从0开始计数 :[0,totalRowsNum-1]
MySQL :: MySQL 8.0 Reference Manual :: 8.2.1.17 LIMIT Query Optimization https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html