Comment 5 for bug 121363

At the moment, when bugs are ordered by 'most recently closed' the ORDER BY clause is ORDER BY date_closed DESC, id. The id is there to make the results deterministic in the test suite (in real life, it is unnecessary). This ORDER BY clause is unable to use the index created to make this query run quickly. The ORDER BY should be ORDER BY date_closed DESC, id DESC.

The fix may just be a case of finding the relevant order_by parameter and inserting a '-' sign.