Profiling Queries: Finding Slow Pages in Laravel

A Laravel app feels slow most often because: - too many queries (N+1) - missing indexes - loading too much data - doing heavy logic inside loops ## Quick win: log queries locally ```php DB::listen(function ($query) { logger()->info($query->sql, $query->bindings); }); ``` This helps you see if your controller triggers 2 queries or 200. ## Reduce loaded columns ```php $users = User::select('id', 'name')->get(); ``` Instead of loading every column. ## Graph: where time is spent ```mermaid flowchart TD A[Request Time] --> B[DB Queries] A --> C[Serialization] A --> D[Template Rendering] ``` In the next tutorial, we will handle background failures and retries.