activeadminの場合だけN+1問題が起きてしまいます。
どこに追加すれば良いのかわかりません、教えて下さい
lang
1ActiveAdmin.register Item do 2 3 index do 4 column :id 5 column :user_id 6 column :category do |item| 7 if item.category.present? 8 link_to item.category.name, admin_category_path(item.category) 9 else 10 status_tag('Empty') 11 end 12 end 13 column "タイトル",:title 14 column :condition do |item| 15 if item.condition.present? 16 link_to item.condition.name, admin_condition_path(item.condition) 17 else 18 status_tag('Empty') 19 end 20 end 21 column "地域",:area 22 date_column :limit_day 23 column "トレード",:trade 24 column :item_status do |item| 25 if item.item_status.present? 26 item.item_status.name 27 else 28 status_tag('Empty') 29 end 30 end 31 column :limit_check 32 column :infraction 33 date_column :created_at 34 # 削除済みの場合は"削除"と表示 35 column :deleted do |f| 36 f.deleted_at ? "削除済み" : nil 37 end 38 39 actions 40 end 41end
ログ
lang
1http://localhost:3000/admin/items 2N+1 Query detected 3 Item => [:category] 4 Add to your finder: :includes => [:category] 5N+1 Query method call stack 6 /Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:32:in `block (3 levels) in <top (required)>' 7 /Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:31:in `block (2 levels) in <top (required)>' 8 9/Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:32:in `block (3 levels) in <top (required)>' 10/Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:31:in `block (2 levels) in <top (required)>' 11user: maimai 12http://localhost:3000/admin/items 13N+1 Query detected 14 Item => [:condition] 15 Add to your finder: :includes => [:condition] 16N+1 Query method call stack 17 /Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:40:in `block (3 levels) in <top (required)>' 18 /Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:39:in `block (2 levels) in <top (required)>' 19 20/Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:40:in `block (3 levels) in <top (required)>' 21/Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:39:in `block (2 levels) in <top (required)>' 22user: maimai 23http://localhost:3000/admin/items 24N+1 Query detected 25 Item => [:item_status] 26 Add to your finder: :includes => [:item_status] 27N+1 Query method call stack 28 /Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:50:in `block (3 levels) in <top (required)>' 29 /Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:49:in `block (2 levels) in <top (required)>' 30 31/Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:50:in `block (3 levels) in <top (required)>' 32/Users/maimai/RubymineProjects/kopotyan-master/app/admin/item.rb:49:in `block (2 levels) in <top (required)>' 33
回答3件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。