What is the N+1 query problem, and how do you prevent it?

Sample answer preview

The N+1 query problem is a common performance issue where an application executes one query to fetch a list of records, then N additional queries to fetch related data for each record. This results in N+1 database round trips instead of one or two.