N+1

preload 2 SQL. Cannot use where on association.
includes 1 LEFT OUTER JOIN with where on association.
eager_load 1 LEFT OUTER JOIN.
[joins] 1 INNER JOIN. Has duplicates and no associated records.