Spotting the N+1 Problem

The N+1 problem is when your code runs one query to get a list, then one more query for each item in it. 🐢

It usually hides in a loop over objects, where each pass quietly touches a related row in the database again and again.