The query run by IPContributoiunsPager can be improved in a couple of ways:

• In revision mode, use RevisionStore::newSelectQueryBuilder instead of the deprecated RevisionStore::getQueryInfo method
• Avoid unnecessary joins by using more fields on the cu_changes table, instead of their equivalents on the revision and archive tables (e.g. join to the comment table using cuc_comment_id rather than rev_comment_id, etc.)