$call_model = M('sort');
$list = $call_model->order('id DESC')->select();
echo $call_model->getLastSql();exit;SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id DESC) AS ROW_NUMBER FROM (SELECT * FROM sort) AS thinkphp) AS T1 WHERE没有设置limit，后面的那个WHERE应该去掉
最佳答案
