From de1f3aab868f8d18198438c405d0852c58f34e10 Mon Sep 17 00:00:00 2001 From: Eugen Rochko Date: Sun, 16 Oct 2016 18:57:54 +0200 Subject: Fix #16 - Optimize n+1 queries when checking reblogged/favourited values for status lists in API --- app/models/follow_suggestion.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'app/models/follow_suggestion.rb') diff --git a/app/models/follow_suggestion.rb b/app/models/follow_suggestion.rb index 25d28f5ac..dbe86a0e4 100644 --- a/app/models/follow_suggestion.rb +++ b/app/models/follow_suggestion.rb @@ -22,7 +22,7 @@ END account_ids = results['data'].map(&:first) blocked_ids = Block.where(account_id: for_account_id).pluck(:target_account_id) - accounts_map = Account.where(id: account_ids - blocked_ids).map { |a| [a.id, a] }.to_h + accounts_map = Account.where(id: account_ids - blocked_ids).with_counters.map { |a| [a.id, a] }.to_h account_ids.map { |id| accounts_map[id] }.compact rescue Neography::NeographyError, Excon::Error::Socket => e -- cgit