From b177f09048eb2da61fe0dae35e46df66d9f34fbb Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Fr=C3=A9d=C3=A9ric=20Buclin?= <LpSolit@netscape.net>
Date: Wed, 19 Apr 2017 13:20:03 +0200
Subject: Improve the performance of the SQL query when searching for unvisited
 involved bugs

---
 buglist.cgi | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/buglist.cgi b/buglist.cgi
index 6e5e3d94c..ea6aa6ee5 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -878,10 +878,10 @@ if (@bugidlist) {
               $dbh->selectcol_arrayref('SELECT bugs.bug_id
                                           FROM bugs
                                      LEFT JOIN cc
-                                            ON cc.bug_id = bugs.bug_id
+                                            ON cc.bug_id = bugs.bug_id AND who = ?
                                          WHERE (reporter = ? OR assigned_to = ? OR qa_contact = ? OR who = ?)
                                            AND ' . $dbh->sql_in('bugs.bug_id', $new_bugs),
-                                         undef, ($user->id) x 4);
+                                         undef, ($user->id) x 5);
             %$involved_new_bugs = map { $_ => 1 } @$involved_new_bugs_list;
         }
     }
-- 
cgit v1.2.1