EXPLAIN Slow SQL query in Views relationship

+----+--------------------+----------------------------------+--------+-------------------------------------+-----------+---------+-----------------------+-------+-------------+
| id |    select_type     |              table               |  type  |            possible_keys            |    key    | key_len |          ref          | rows  |    Extra    |
+----+--------------------+----------------------------------+--------+-------------------------------------+-----------+---------+-----------------------+-------+-------------+
|  1 | PRIMARY            | node_users                       | ref    | vid,node_type,uid                   | node_type |      14 | const                 | 11286 | Using where |
|  1 | PRIMARY            | users                            | eq_ref | PRIMARY,uid_status                  | PRIMARY   |       4 | joinup.node_users.uid |     1 | Using where |
|  1 | PRIMARY            | node_users_node_data_field_photo | eq_ref | PRIMARY                             | PRIMARY   |       4 | joinup.node_users.vid |     1 |             |
|  1 | PRIMARY            | node                             | ref    | node_status_type,uid,status_created | uid       |       4 | joinup.users.uid      |     1 | Using where |
|  1 | PRIMARY            | userpoints                       | ref    | uid_tid                             | uid_tid   |       4 | joinup.node.uid       |     1 |             |
|  1 | PRIMARY            | node_revisions                   | eq_ref | PRIMARY                             | PRIMARY   |       4 | joinup.node.vid       |     1 |             |
|  3 | DEPENDENT SUBQUERY | tn                               | eq_ref | PRIMARY,vid                         | PRIMARY   |       8 | const,func            |     1 | Using index |
|  2 | DEPENDENT SUBQUERY | na                               | ref    | PRIMARY                             | PRIMARY   |       4 | joinup.node.nid       |     1 | Using where |
+----+--------------------+----------------------------------+--------+-------------------------------------+-----------+---------+-----------------------+-------+-------------+