it's good to you show all columns of ur table, because we don't know which column you add indexes with.

apparently, this is business privacy, i am not allowed to show columns detail, but what i wrote basically say everything already, like benefiting the query will mean the VARCHAR and DATE columns being called in the testing query, appropriate column index would means the most optimal indexes for the table out of all its query