Why wp_load_alloptions() fetches all options if no options is set to autoload?
Following the history on GitHub, it appears that this behaviour has existed since wp_load_alloptions() was introduced, 17 years ago. It was added as part of code that was introduced to address this ticket, and seems to be intended to fix issues related to object caching. The full explanation for the entire change is given as: … Read more