Forum: Ruby on Rails Duplicate queries while eager loading multiple associations

Hello all,

given the following models and console log: 
https://gist.github.com/3735116

I do not understand why the latter statements (o.order_items and 
o.total)
yield sql queries.
Have I missed something in AR documentation? What should be done to get 
rid
of redundant sql queries?

On Monday, September 17, 2012 2:45:05 AM UTC+1, Dennis Krupenik wrote:
>
> oi = o.order_items.includes(item: :photos)

does not mutate o.order_items, adding the includes to it: it returns a 
new
array of objects that has the extra options applied.

You do o = Order.includes(order_items: {item: photos}).last in which 
case

o.order_items should  not execute any queries

Fred

thanks a lot, that did it