Thinkphp5.1 Model group order 获取最新的数据,并且分组

548 阅读1分钟

    /**
     * 信息列表
     */
    public function list()
    {
        $subQuery  = $this->model
            ->where($this->model->search())
            ->order('id desc')
            ->buildSql();

        $lists = $this->model
            ->table($subQuery.'a')
            ->field('*,count(*) survival_time')
            ->order('id desc')
            ->group('uuid')
            ->paginate($this->limit);



        _lists($lists);

    }