How do you identify and fix an N+1 query problem in Hibernate that's only showing up in production, not in your local tests?

Ready to master this question?

Generate a complete walkthrough — background, the full answer in plain language, a working code example explained line by line, a real-world scenario, common mistakes, and how this same question gets asked in different ways.