Practical Checklist for Optimizing Slow MySQL Queries in Laravel Apps

A Laravel developer has shared a structured checklist for diagnosing and fixing slow database queries, arguing that poor query design is often the real cause of sluggish APIs rather than insufficient server resources. The guide recommends starting with measurement tools such as Laravel Telescope, Debugbar, and MySQL's Slow Query Log to identify the most problematic queries before making any changes. Key optimizations covered include avoiding SELECT *, using the EXPLAIN command to analyze query execution, adding appropriate single or composite indexes, and eliminating N+1 query problems through eager loading. Additional recommendations include caching frequently accessed data with Laravel's Cache facade and using pagination instead of fetching entire tables at once. The author emphasizes that performance gains should always be verified by re-measuring query execution time, rows scanned, and API response time after each change.