Pasted

mysql> explain SELECT members.twitter_id FROM `members` INNER JOIN `twitter_identities` ON twitter_identities.persona_id = members.persona_id WHERE (user_id = 266 AND (member_state > 1 OR high_value_type > 0) AND twitter_identities.updated_at < '2013-01-01 09:12:55') LIMIT 100\G;
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: members
         type: ref
possible_keys: user_id,starred_index,hidden_index,members_state_index,high_value_members_index,twitter_id_index,persona_id_index
          key: user_id
      key_len: 4
          ref: const
         rows: 1
        Extra: Using where
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: twitter_identities
         type: ref
possible_keys: updated_at_index,index_twitter_identities_on_persona_id
          key: index_twitter_identities_on_persona_id
      key_len: 5
          ref: communit_pablo.members.persona_id
         rows: 1
        Extra: Using where
2 rows in set (0.00 sec)