set optimizer_switch='batched_key_access=on,mrr_cost_based=off';

--source include/join_cache.inc

set optimizer_switch = default;