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
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: watchlist
         type: ref
possible_keys: wl_user,namespace_title,wl_user_notificationtimestamp
          key: wl_user
      key_len: 4
          ref: const
         rows: 138546
        Extra: Using temporary; Using filesort
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: recentchanges
         type: ref
possible_keys: rc_timestamp,rc_namespace_title,rc_ns_usertext,tmp_3,rc_name_type_patrolled_timestamp
          key: rc_namespace_title
      key_len: 261
          ref: ruwiki.watchlist.wl_namespace,ruwiki.watchlist.wl_title
         rows: 13
        Extra: Using where
*************************** 3. row ***************************
           id: 1
  select_type: SIMPLE
        table: page
         type: eq_ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 4
          ref: ruwiki.recentchanges.rc_cur_id
         rows: 1
        Extra: 
3 rows in set (0.00 sec)