EXPLAIN EXTENDED
SELECT SQL_NO_CACHE *
  FROM `fh_user_file` `t` 
  LEFT OUTER JOIN `fh_file` `file` ON (`t`.`file_id`=`file`.`id`) 
  LEFT OUTER JOIN `fh_domain` `domain` ON (`t`.`domain_id`=`domain`.`id`)
  LEFT OUTER JOIN `fh_abuse_file_user` `abuseFileUser` ON (`t`.`file_id`=`abuseFileUser`.`file_id`) 
  WHERE (((t.deleted = 0) AND (parent_id IS NULL)) AND (t.user_id='42')) 
  LIMIT 100

  WHERE t.user_id='42' AND t.deleted=0 AND t.abuse_status=0 AND t.file_id is not null
  ORDER BY t.date_download_last, t.downloads 
  LIMIT 100

INDEX IDX_fh_user_file2 (user_id, abuse_status, deleted, file_id, date_download_last, downloads),