On profiling it is taking 123s on average, on my test it took over 40s on translatewiki.net.
Truncated query:
query: SELECT rc_user_text AS user_name,rc_user_text,user_id,COUNT(*) AS recentedits,MAX(ipb_deleted) AS ipb_deleted FROM bw_recentchanges FORCE INDEX (rc_user_text) INNER JOIN bw_user ON ((rc_user_text=user_name)) LEFT JOIN bw_ipblocks ON ((user_id
Version: 1.21.x
Severity: normal
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=59988
https://bugzilla.wikimedia.org/show_bug.cgi?id=60468