Slow SQL query in Views relationship from Content Profile

SELECT node.nid AS nid,
       node_users.field_photo_fid AS node_users_node_data_field_photo_field_photo_fid,
       node_users.field_photo_list AS node_users_node_data_field_photo_field_photo_list,
       node_users.field_photo_data AS node_users_node_data_field_photo_field_photo_data,
       node_users.nid AS node_users_nid,
       node_users.language AS node_users_language,
       node_users.type AS node_users_type,
       node_users.vid AS node_users_vid,
       users.name AS users_name,
       users.uid AS users_uid,
       node.type AS node_type,
       node.language AS node_language,
       node.title AS node_title,
       node.created AS node_created,
       userpoints.points AS userpoints_points,
       node.vid AS node_vid,
       node_revisions.teaser AS node_revisions_teaser,
       node_revisions.format AS node_revisions_format,
       'taxonomy_views:page_1' AS view_name
FROM node node
INNER JOIN term_node tn ON tn.tid = 11855 and node.vid = tn.vid
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN (SELECT n.nid, uid, type, language, n.vid, field_photo_fid, field_photo_list, field_photo_data FROM node n
                INNER JOIN content_type_profile ctp ON n.vid = ctp.vid
                WHERE type = 'profile'
      ) node_users ON users.uid = node_users.uid
LEFT JOIN userpoints userpoints ON node.uid = userpoints.uid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE (node.status <> 0 OR (node.uid = 1 AND 1 <> 0) OR 1 = 1)
LIMIT 0, 10