Question about includes

I have three class,HotActivity, Activity和ActivityType

HotActivity and Activity is one to one association, Activity belongs to
ActivityType

in controller I code like this

@hot_activities = HotActivity.includes(:activity)

chrome will prompt me this

user: william
N+1 Query detected
Activity => [:activity_type]
Add to your finder: :include => [:activity_type]
N+1 Query method call stack

if I add like this

@hot_activities = HotActivity.includes(:activity => :activity_type)

it prompt this

user: william
Unused Eager Loading detected
HotActivity => [:activity]
Remove from your finder: :include => [:activity] activities:575
Uniform Notifier activities:587
user: william
Unused Eager Loading detected
Activity => [:activity_type]
Remove from your finder: :include => [:activity_type]

some one please help,

thanks in advs

HI william,

how exactly does chrome prompt that?

whats the view like?

is that the only line you have on your controller?

can you be a little more specific and post exactly what is the error you
get.

all the best,

Andre

hi andreo, thanks for reply

answer you inline

On Sun, Feb 3, 2013 at 7:04 AM, [email protected] wrote:

HI william,

how exactly does chrome prompt that?

Uniform Notifier activities:551 http://localhost:3000/activities
user: william N+1 Query detected Activity => [:activity_type] Add to your
finder: :include => [:activity_type] N+1 Query method call stack
/home/william/work/lly/app/views/activities/index.html.erb:48:in block in _app_views_activities_index_html_erb___3943997569956187419_46069520' /home/william/work/lly/app/views/activities/index.html.erb:32:in_app_views_activities_index_html_erb___3943997569956187419_46069520’

line 48

        <li><div id="type"></div>类型: <%=

hot_activity.activity.activity_type.name %>

line 32

  • 类型: <%=
    hot_activity.activity.activity_type.name %>
  • whats the view like?

       <% @hot_activities.each_with_index do |hot_activity, index| %>
    
    
        <div id="detail<%= index + 1 %>" class="detail cf">
          <ul>
            <li class="header">
              <%= link_to hot_activity.activity.title,
    

    activity_path(hot_activity.activity) %>



  • is that the only line you have on your controller?

    def index
    @hot_activities = HotActivity.includes(:activity)
    .where(“activities.status = ‘open’”)
    .order(‘start_at ASC’)
    .limit(5)

    @closed_activities = Activity.includes(:participants)
                                 .where("status = 'closed'")
                                 .order("participants_count desc")
                                 .limit(5)
    
    @hot_sponsors = User.includes(:created_activities)
                        .where("status = 'A'")
                        .order("created_activities_count desc")
                        .limit(8)
    

    end