$sub = SyncLog::select('insert_num', 'created_at', 'end_time')->where('status', '=', 1)->orderBy('id', 'desc');
$dailyResults = \DB::table( \DB::raw("({$sub->toSql()}) as sub") )
->mergeBindings($sub->getQuery())
->select(DB::raw('end_time, sum(insert_num) as total'))
->groupBy('end_time')
->orderBy('end_time', 'desc')
->limit($days)
->get();
laravel 子查询
最新推荐文章于 2024-09-07 09:37:39 发布