How to figure out correct wp_options to have autoload=’yes’

WP-Rocket was deactivated, but the wp-content/object-cache.php file was still present. This file redefined the wp_cache_add in such a way that the method didn’t work, so all requests to get a single option value were resulting in a query to the wp_options table.

I deleted the wp-content/object-cache.php file and the page response time dropped to 2 seconds from a peak of 15 seconds, and the total number of queries to 288 from a peak of 15,000.