You check `EXPLAIN` during code review and find no slow queries, yet in production, hundreds of SQL statements are being executed. This is the N+1 problem. Even if your index design is correct, ...