10
08月
2021
构建查询语句
$Query = Db::table("group_table") ->where(['status'=>'1']) ->order(['created_at'=>'desc']) ->limit(1000000000)// 不加这行无法出现最新数据 ->buildSql();//构建查询语句
分组
$group = Db::table($query."a") ->field("a.id,count(a.id) as count,a.member_id,a.content,a.status") ->order(["created_at"=>"desc"]) ->group("member_id") ->select();
分组并分页
$group = Db::table($query."a") ->field("a.id,count(a.id) as count,a.member_id,a.content,a.status") ->order(["created_at"=>"desc"]) ->group("member_id") ->paginate(10,false,['page'=>1]);
双表联查最新
$comment_subquery = Db::name ('sorder') ->field('sorder_id,clientid,client_id') ->order('sorder_id','desc') ->limit(100000) ->buildSql(); $newClients = Db::name('client') ->alias ( 'c' ) ->join([$comment_subquery=>'s'], 'c.clientid=s.clientid' ) ->group('s.client_id') ->order('s.sorder_id desc') ->paginate(10, $count, ['path' => $path]);
原文地址:https://blog.csdn.net/liangyu_/article/details/108164581