[aaronblohowiak]

Why is it more than 7 queries?

[emilsedgh]

If its a collection of 100 items it would be 700 queries.

[chao-]

Wouldn't it only be 7?

First query gets the first 100 items, the second query gets the nested associations for those 100 (assuming you couldn't batch it into the first query), the third gets the nested associations for the second's, and so forth. One query for each entity category?