在laravel中从数据库中获取数据的更优化的方法

$posts = Post::with('user')->get();

$posts = Post::paginate(10);

class Post extends Model
{
    public function scopePublished($query)
    {
        return $query->where('status', 'published');
    }
}

$posts = Post::published()->get();

$posts = DB::select('SELECT * FROM posts WHERE status = ?', ['published']);

$posts = Cache::remember('posts', $minutes, function () {
    return Post::all();
});

// 错误示例
foreach ($posts as $post) {
    $user = User::find($post->user_id); // 每次循环都会查询数据库
}

// 正确示例
$posts = Post::with('user')->get(); // 预加载用户数据
foreach ($posts as $post) {
    $user = $post->user; // 直接从预加载的数据中获取用户信息
}

Cache::tags(['posts', 'users'])->remember('posts', $minutes, function () {
    return Post::all();
});