Two N+1 patterns I fixed recently (the assembly loop, and an N+1 hiding inside a predicate) and the batching approach that makes the query count stop growing with your data.