Index Condition Pushdown Optimization
MariaDB [(none)]> SET optimizer_switch = 'index_condition_pushdown=off';
vi /etc/my.cnf.d/server.cnf
optimizer_switch=index_condition_pushdown=off
To check:
mysql -e 'show global variables like "%optimizer_switch%";' | grep index_condition_pushdown