Slow SQL query in Views relationship from Content Profile

SELECT node.nid AS nid,
       node_users_node_data_field_photo.field_photo_fid AS node_users_node_data_field_photo_field_photo_fid,
       node_users_node_data_field_photo.field_photo_list AS node_users_node_data_field_photo_field_photo_list,
       node_users_node_data_field_photo.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 users users ON node.uid = users.uid
LEFT JOIN node node_users ON users.uid = node_users.uid
AND node_users.TYPE = 'profile'
INNER JOIN content_type_profile node_users_node_data_field_photo ON node_users.vid = node_users_node_data_field_photo.vid
LEFT JOIN userpoints userpoints ON node.uid = userpoints.uid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE (EXISTS
         (SELECT na.nid
          FROM node_access na
          WHERE node.nid = na.nid
            AND (na.grant_view >= 1
                 AND ((na.gid = 0
                       AND na.realm = 'all')
                      OR (na.gid = 1
                          AND na.realm = 'workflow_access')
                      OR (na.gid = 0
                          AND na.realm = 'workflow_access_owner')
                      OR (na.gid = 0
                          AND na.realm = 'og_public')))))
  AND ((node.STATUS <> 0
        OR (node.uid = 0 AND 0 <> 0)
        OR 0 = 1)
       AND (node.vid IN
              ( SELECT tn.vid
               FROM term_node tn
               WHERE tn.tid = 11855 )) )
LIMIT 0, 10