What is N+1 queries in Query Optimization?

N+1 queries is an important concept in Query Optimization. Understand its purpose, how it works, when to use it, and the tradeoffs it introduces before applying it in a production system.