MySQL indexing issue when trying to search for a part of a string/word
If you can get rid of the leading wildcard (%), do so; then we can discuss better indexes.

Meanwhile, use INDEX(customer_id, date4); it has some chance of speeding up the query.

What version are you running?

Please provide SHOW CREATE TABLE if you want to discuss this further.