The following index :
is never used in the queries. Indeed the query search is based on the different values except "CLOSED" and the optimizer engine always make a full table scan to the find the right rows. The index is never used.
I recommend to drop this index.