转载：https://blog.csdn.net/xxxxg_xg/article/details/126143246 ``` //目前我用的是这个 SELECT * FROM `user_operation_log` a join (SELECT id FROM `user_operation_log` LIMIT 9000000, 100)b where a.id=b.id 运行时间：3.485s ``` tp框架写法 ~~~ $join_sub = $this->model->field('id')->where($where)->limit($offset,$limit)->order('req_time', 'desc')->buildSql(); $list = $this->model->alias('a')->join($join_sub.' b','b.id=a.id')->select(); ~~~