Problem z include

Zielona szkoła
1

subcategory belongs_to => :category has_many => :products has_many => :fotos, :through => :products

@subcategory = SubCategory.find(session[:sub_category], :include => [:products, :category, :fotos])

powinno dawać chyba jedno zapytanie do bazy, a daje 4:

SubCategory Load (0.5ms) SELECT * FROM "sub_categories" WHERE ("sub_categories"."id" = 12) Product Load (18.3ms) SELECT "products".* FROM "products" WHERE ("products".sub_category_id = 12) Category Load (17.3ms) SELECT * FROM "categories" WHERE ("categories"."id" = 5) Foto Load (2.1ms) SELECT "fotos".* FROM "fotos" WHERE ("fotos".product_id IN (21,22,25,26,27,28,30,31,33))

2

Jeśli chcesz mieć jedno zapytanie to użyj :joins

zobacz http://akitaonrails.com/2008/5/26/rolling-with-rails-2-1-the-first-full-tutorial-part-2
a konkretniej “Optimized Eager Loading”

pzdr

3

Dzieki za szybka odpowiedź