Was having the same problem ...
I am working on a PS4 site with about 350+ products, most of which have 5-8 advanced options. It was excruciatingly slow to retrieve a list of products. I ran these queries (changing the table names for PS4) and the speed was improved dramatically. This should probably be posted as a known issue for sites with a lot of products that have many advanced options.