mysql:wikiadmin@db1093 [ruwiki]> EXPLAIN SELECT rc_id,rc_timestamp,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,wl_notificationtimestamp,page_latest FROM `recentchanges` INNER JOIN `watchlist` ON (wl_user = '529055' AND (wl_namespace=rc_namespace) AND (wl_title=rc_title)) LEFT JOIN `page` ON ((rc_cur_id=page_id)) WHERE (rc_type != '6') AND (rc_source != 'wb') AND (rc_timestamp > '20170716043245') AND ((rc_type != 3) OR ((rc_deleted & 1) != 1)) ORDER BY rc_timestamp DESC LIMIT 1000 \G