I am looking at my slow query logs and trying to fix some of slow queries, I identified one to fix and ran EXPLAIN on it and noticed it using filesort

Why would the following query show “using filesort”

Here is the EXPLAIN

Here are all the indexs

Here is the index I want to use: