基于explain的Mysql优化

我有以下查询，需要很长时间才能执行。我需要加快速度，但我不知道该使用什么技术。这是查询：

SELECT 
    `User`.`id`, 
    `User`.`username`, 
    `User`.`password`, 
    `User`.`role`, 
    `User`.`created`, 
    `User`.`modified`, 
    `User`.`email`, 
    `User`.`other_user_id`, 
    `User`.`first_name`, 
    `User`.`last_name`, 
    `User`.`place_id`, 
    `Resume`.`id`, 
    `Resume`.`user_id`, 
    `Resume`.`other_resume_id`, 
    `Resume`.`other_user_id`, 
    `Resume`.`file_extension`, 
    `Resume`.`created`, 
    `Resume`.`modified`, 
    `Resume`.`is_deleted`, 
    `Resume`.`has_file`, 
    `Resume`.`is_stamped`, 
    `Resume`.`is_active` 
FROM 
    `streetofwalls`.`users` AS `User` 
    LEFT JOIN `my_database`.`attempts` AS `Attempt` 
        ON (`Attempt`.`user_id` = `User`.`id` AND `Attempt`.`test_id` != 5) 
    LEFT JOIN `my_database`.`reports` AS `Resume` 
        ON (`Resume`.`user_id` = `User`.`id`) 
WHERE 
    `Attempt`.`test_id` = 8 
    AND `Attempt`.`score` > 60 
    AND `User`.`id` IN (
        SELECT 
            `User1`.`id` 
        FROM 
            `my_database`.`users` AS User1 
            LEFT JOIN `my_database`.`tags_users` AS TagUser 
                ON (`User1`.`id`= `TagUser`.`user_id`) 
            LEFT JOIN `my_database`.`tags` AS Tag 
                ON (`TagUser`.`tag_id`= `Tag`.`id`) 
        WHERE `Tag`.`id` = (8) ) 
    AND `User`.`id` NOT IN (
        SELECT 
            `User1`.`id` 
        FROM 
            `my_database`.`users` AS User1 
            LEFT JOIN `my_database`.`tags_users` AS TagUser 
                ON (`User1`.`id`= `TagUser`.`user_id`) 
            LEFT JOIN `my_database`.`tags` AS Tag 
                ON (`TagUser`.`tag_id`= `Tag`.`id`) 
        WHERE `Tag`.`id` = (3) ) 
    AND `Resume`.`has_file` = 1 
GROUP BY `User`.`id` 
ORDER BY `Attempt`.`score` DESC;

This query generates the following explain:

正如您所看到的，我对此查询有多个索引。目前只有简历表无法建立索引。是否可以在此查询的上下文中索引该表？还有其他我没有想到的方法来加速这个查询吗？对于其预期功能来说，它的速度慢得令人望而却步，我已经没有主意了。感谢任何可以提供帮助的人。如果需要任何其他信息，请告诉我。

尝试内连接而不是子查询 默认情况下引导查询而不运行数据，但遵循查询可能会对您有所帮助。

SELECT User.id, User.username, User.password, User.role, User.created, User.modified, User.email, User.other_user_id, User.first_name, User.last_name, User.place_id, Resume.id, Resume.user_id, Resume.other_resume_id, Resume.other_user_id, Resume.file_extension, Resume.created, Resume.modified, Resume.is_deleted, Resume.has_file, Resume.is_stamped, Resume.is_active

从streetofwalls.users AS User
左连接my_database.attempts AS Attempt ON (Attempt.user_id = User.id AND Attempt.test_id!= 5) 左连接my_database.reports AS Resume ON (Resume.user_id = User.id)

, my_database.users作为用户1

左连接my_database.tags_usersAS 标签用户 (User1.id= TagUser.user_id)

左连接my_database.tagsAS 标签开启 (TagUser.tag_id= Tag.id)

在哪里User.id = User1.id和Attempt.test_id= 8 和Attempt.score > 60
和Resume.has_file= 1 和Tag.id='8'并且Tag.id!='3' 通过...分组User.id订购依据Attempt.score DESC;