网站首页MySQL

『LIMIT 10』和『LIMIT 5000000, 10』的查询时间对比

mysql> SELECT `id` FROM `prefix_table` ORDER BY `id` DESC LIMIT 10;
+----------+
| id       |
+----------+
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
+----------+
10 rows in set (0.00 sec)
 
mysql> SELECT `id` FROM `prefix_table` ORDER BY `id` DESC LIMIT 5000000, 10;
+----------+
| id       |
+----------+
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
| ******** |
+----------+
10 rows in set (3.39 sec)
 
mysql>

Copyright © 2025 码农人生. All Rights Reserved