Any index that does not span all AND levels in the WHERE clause is not used to optimize the query. In other words, to be able to use an index, a prefix of the index must be used in every AND group.

https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html