Optimizing slow Eloquent queries in Laravel

 My debugging process would be:

1. Identify the slow endpoint/query.

2. Inspect generated SQL.

3. Check for N+1.

4. Use eager loading where appropriate.

5. Select only required columns.

6. Add appropriate indexes.

7. Use EXPLAIN.

8. Check unnecessary relationships and joins.

9. Paginate large datasets.

10. Measure again.

Instead of:

$users = User::with('orders')->get();

if I only need names:

$users = User::select('id', 'name')->get();

For counts:

$users = User::withCount('orders')->get();

For existence:

$users = User::whereHas('orders')->get();

Scenario

If an API suddenly becomes slow after the database grows from 10,000 to 10 million orders, I wouldn't immediately add caching. I'd first inspect query plans, indexes, query volume, returned rows, and N+1 behavior.