QA (public) » openQA Project (public)

On the homepage and group_overview pages comment_data_for_jobs is called. It collects bugrefs and fetches all bugs, but in those views we don't even show this data.
Also, all columns of Comments are selected, while only two are needed.

I looked into this while working on #93925
I already did a fix, so even if this is not a high priority, it's already done, and an easy fix. So i took the liberty to create this ticket and a PR.

Runtime before:
/group_overview/1: 1.0-1.1s
/dashboard_build_results: 0.9-0.95s
Runtime after:
/group_overview/1: 0.8-0.85s
/dashboard_build_results: 0.75-0.77s

SQL statements which will be saved:

SELECT me.id, me.bugid, me.title, me.priority, me.assigned, me.assignee, me.open, me.status, me.resolution, me.existing, me.refreshed, me.t_created, me.t_updated FROM bugs me WHERE ( me.bugid = ? ): 'boo#1183454'
SELECT me.id, me.bugid, me.title, me.priority, me.assigned, me.assignee, me.open, me.status, me.resolution, me.existing, me.refreshed, me.t_created, me.t_updated FROM bugs me WHERE ( me.bugid = ? ): 'poo#92945'
SELECT me.id, me.bugid, me.title, me.priority, me.assigned, me.assignee, me.open, me.status, me.resolution, me.existing, me.refreshed, me.t_created, me.t_updated FROM bugs me WHERE ( me.bugid = ? ): 'poo#92401'
SELECT me.id, me.bugid, me.title, me.priority, me.assigned, me.assignee, me.open, me.status, me.resolution, me.existing, me.refreshed, me.t_created, me.t_updated FROM bugs me WHERE ( me.bugid = ? ): 'boo#1180358'
# and so on

for each build