是否有更好的查询来获得最匹配的结果

Question

我正在尝试使用匹配对抗最匹配的结果。
我的第一个查询正常工作，但它使用filesort。
第二个查询也效果很好，但是查询复制并看起来很混乱。

我如何优化查询？
为了参考，索引列为class_id和name。

*仅与匹配的查询

    SELECT id, name, MATCH (name) AGAINST('john smi') AS score
    FROM member
    WHERE class_id=5
    AND MATCH (name) AGAINST('john smi');

我想要的是两个最高得分的最高值。

*我的第一个查询

    SELECT * FROM (
        SELECT id, name, MATCH (name) AGAINST('john smi') AS score, dense_rank() over (order by  MATCH (name) AGAINST('john smi') desc) ranking
        FROM member
        WHERE class_id=5
        AND MATCH (name) AGAINST('john smi')
    )t where t.ranking = 1;

*第二查询

    SELECT id, name, MATCH (name) AGAINST('john smi') AS score
    FROM member
    WHERE class_id=5
    AND MATCH (name) AGAINST('john smi') AND MATCH (name) AGAINST('john smi') >= (
        SELECT MATCH (name) AGAINST('john smi')
        FROM member
        WHERE class_id=5
        AND MATCH (name) AGAINST('john smi') limit 1
    )l