From 4bdfb3fcdec447649525e4d44009ad5604eccbd4 Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Tue, 6 Oct 2026 22:56:48 +0100
Subject: [PATCH] Fix N+1 queries in issues view

---
 app/controllers/issues_controller.rb | 2 ++
 test/prosopite_todo.yml              | 1 -
 2 files changed, 2 insertions(+), 1 deletion(-)

diff --git a/app/controllers/issues_controller.rb b/app/controllers/issues_controller.rb
index 64d600acb..f51d6e7c2 100644
--- a/app/controllers/issues_controller.rb
+++ b/app/controllers/issues_controller.rb
@@ -45,6 +45,8 @@ class IssuesController < ApplicationController
       @issues = @issues.where(:updated_by => last_updated_by)
     end
 
+    @issues = @issues.includes(:reportable, :reported_user)
+
     @issues = get_page_items(@issues, :limit => @params[:limit])
 
     @unique_reporters_limit = 3
diff --git a/test/prosopite_todo.yml b/test/prosopite_todo.yml
index d40877503..82b609905 100644
--- a/test/prosopite_todo.yml
+++ b/test/prosopite_todo.yml
@@ -19,7 +19,6 @@
 - app/views/api/users/_user.xml.builder
 - app/views/diary_entries/_diary_entry.html.erb
 - app/views/diary_entries/_profile_diaries.html.erb
-- app/views/issues/_page.html.erb
 - app/views/notes/index.html.erb
 - app/views/notifications/_notification.html.erb
 - app/views/oauth2_authorized_applications/_application.html.erb
-- 
2.47.3