Практические паттерны и итоги

namespace App\Queries;

use App\Models\Post;
use Illuminate\Http\Request;

class PostQuery
{
    public function __construct(private Request $request) {}

    public function get()
    {
        return Post::query()
            ->when($this->request->filled('search'), function ($q) {
                $q->where('title', 'like', "%{$this->request->search}%");
            })
            ->when($this->request->filled('status'), function ($q) {
                $q->where('status', $this->request->status);
            })
            ->with('user')
            ->paginate(15);
    }
}

namespace App\Repositories;

use App\Models\Post;

class PostRepository
{
    public function findPublished(): \Illuminate\Database\Eloquent\Collection
    {
        return Post::where('published', true)->get();
    }
}

Post::select('id', 'title', 'slug')->get();

$table->index('status');
$table->index(['status', 'published_at']);

Post::with('user', 'comments')->get();

Post::chunk(200, function ($posts) {
    //
});