How do you approach database optimization in PHP applications, and what tools or techniques do you use?

Database optimization is crucial for PHP applications. I focus on efficient query design, indexing, and caching mechanisms. Tools like MySQL's EXPLAIN statement help identify bottlenecks, and using an Object-Relational Mapping (ORM) system like Eloquent in Laravel simplifies database interactions.