An application is often only as fast as its database. Understanding how to analyze and optimize slow queries is a superpower for any backend engineer.
Indexing and N+1 Issues
The infamous N+1 query problem is the number one cause of slow pages in ORM-driven applications. Using eager loading and proper compound indexes can drop page load times from seconds to milliseconds.