优化查询——它使用文件集。(包括解释、查询和显示create表)

I am wondering why my query isn't using the index "created_2" which covers all the fields used in the query. It seems to use a filesort. What are the rules for picking an index?I am wondering why my query isn't using the ind