كيفية تخزين استعلامات قاعدة البيانات المكلفة مؤقتاً في Laravel

use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\DB;

$categories = Cache::remember('categories.all', 3600, function () {
    return DB::table('categories')
        ->where('active', true)
        ->orderBy('name')
        ->get();
});

// Eloquent version
$settings = Cache::remember('settings.all', 86400, fn () =>
    Setting::all()->keyBy('key')
);

// Bad — collides across locales
Cache::remember('posts', 3600, fn () => Post::published()->get());

// Good — locale-scoped
$locale = app()->getLocale();
Cache::remember("posts.featured.{$locale}", 3600, fn () =>
    Post::published()->featured()->with('author')->get()
);

// Good — user-scoped
Cache::remember("user.{$user->id}.dashboard", 600, fn () =>
    Dashboard::buildFor($user)
);

// Remember
cache()->remember('key', 3600, fn () => expensiveQuery());

// Store forever
cache()->rememberForever('key', fn () => expensiveQuery());

// Get with default
$value = cache('key', 'default');

// Put
cache(['key' => $value], now()->addHour());

// Forget
cache()->forget('key');

<?php

namespace App\Observers;

use App\Models\Category;
use Illuminate\Support\Facades\Cache;

class CategoryObserver
{
    public function saved(Category $category): void
    {
        Cache::forget('categories.all');
        Cache::forget("categories.all.en");
        Cache::forget("categories.all.ar");
    }

    public function deleted(Category $category): void
    {
        $this->saved($category);
    }
}

// Register in AppServiceProvider or via #[ObservedBy] attribute (Laravel 10+)
// Category::observe(CategoryObserver::class);

# .env
CACHE_STORE=redis     # redis | database | file | array
REDIS_HOST=127.0.0.1
REDIS_PORT=6379

# For database driver, create the table first:
php artisan cache:table
php artisan migrate

# In your deploy script (after git pull)
php artisan cache:clear
php artisan optimize
php artisan view:cache

// Quick benchmark in a controller or tinker
$start = microtime(true);

$result = Cache::remember('expensive.query', 600, fn () =>
    HeavyReport::generate()
);

$ms = round((microtime(true) - $start) * 1000, 2);
logger("Cache query took {$ms}ms");

// Or use DB::listen() to log all queries during a request
DB::listen(fn($q) => logger($q->sql, ['time' => $q->time . 'ms']));