???????? ?????????????е???????з???????????????????????????????????? root@sns 07:16:25>select count(*) from  reply_0004 where thread_id = 5616385 and deleted = 0; +———-+ | count(*) | +———-+ |  1236795 | +———-+ 1 row in set (0.
?????????????????е???????з????????????????????????????????????
root@sns 07:16:25>select count(*) from  reply_0004 where thread_id = 5616385 and deleted = 0;
+———-+
| count(*) |
+———-+
|  1236795 |
+———-+
1 row in set (0.44 sec)
root@sns 07:16:30>select id
from reply_0004 where thread_id = 5616385 and deleted = 0
order by id asc limit 1236785?? 10 ;
+———–+
| id        |
+———–+
| 162436798 |
| 162438180 |
| 162440102 |
| 162442044 |
| 162479222 |
| 162479598 |
| 162514705 |
| 162832588 |
| 162863394 |
| 162899685 |
+———–+
10 rows in set (1.32 sec)
??????????threa_id+deleted+id??gmt_Create??
????10 rows in set (1.32 sec)
??????????sql??????????????sql?????????????η???????????????С?????????10?????????????????????????????????????????????????????????????????????????
????????????????????С?????????????????????????????????????????????????Ч?????????????????????????????￡???
?????????????????????????е??????????????????????????У?????????????????????????????????????????????????????????????????????????10000????????????????????5000????asc??????5000??desc??????limit startnum??pagesize????????????????????
?????????????????ó???????????????sql?????????????????sql?????????????????????????????????????????????????????????????desc????????????????????????????????
root@snsgroup 07:16:49>select * from (select id
->            from group_thread_reply_0004 where thread_id = 5616385 and deleted = 0
->        order by id desc limit 0?? 10)t order by t.id asc;
+———–+
| id        |
+———–+
| 162436798 |
| 162438180 |
| 162440102 |
| 162442044 |
| 162479222 |
| 162479598 |
| 162514705 |
| 162832588 |
| 162863394 |
| 162899685 |
+———–+
10 rows in set (0.87 sec)
?????????????????????50%?????