# Q: find :include

**URL:** <https://www.ruby-forum.com/t/q-find-include/161560>\
**Category:** Rails\
**Created:** [February 27, 2009, 12:27pm UTC](https://www.ruby-forum.com/t/q-find-include/161560 "2009-02-27T12:27:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [February 27, 2009, 12:27pm UTC](https://www.ruby-forum.com/t/q-find-include/161560/1 "2009-02-27T12:27:12Z")

</div>

So I have…

class Post \< ActiveRecord::Base  
belongs\_to :user  
end

@posts = Post.find :all, :include=\>:user

… but when I look at my logs I see this:

Post Load (2.4ms) SELECT \* FROM `posts`  
User Load (0.2ms) SELECT \* FROM `users` WHERE (`users`.`id` = 1)

I was expecting one combined SQL statement?

Any ideas?  
thanks 🙂

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [February 27, 2009, 12:31pm UTC](https://www.ruby-forum.com/t/q-find-include/161560/2 "2009-02-27T12:31:54Z")

</div>

On 27 Feb 2009, at 11:26, removed\_email\_address@domain.invalid wrote:

> Post Load (2.4ms) SELECT \* FROM `posts`  
> User Load (0.2ms) SELECT \* FROM `users` WHERE (`users`.`id` = 1)
> 
> I was expecting one combined SQL statement?

Not since rails 2.1

Fred

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [February 27, 2009, 12:32pm UTC](https://www.ruby-forum.com/t/q-find-include/161560/3 "2009-02-27T12:32:30Z")

</div>

what exactly do you want to do???

for me it looks like you want all the posts for the particular user  
then it should be @posts = User.posts

---

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [February 27, 2009, 1:55pm UTC](https://www.ruby-forum.com/t/q-find-include/161560/4 "2009-02-27T13:55:13Z")

</div>

> what exactly do you want to do???

I just didn’t want to make a new query everytime i accessed a user of  
a post

However, Fred is right

> **[Rolling with Rails 2.1 - The First Full Tutorial - Part 2 | AkitaOnRails.com](https://www.akitaonrails.com/2008/5/26/rolling-with-rails-2-1-the-first-full-tutorial-part-2)**
>
> So, here it goes, Part 2 of my Rails 2.1 Tutorial. Start from Part 1 if you didn’t read it already.
> Disclaimer: If you like this tutorial and you’...

So 2 queries is ok! 🙂

thanks guys