I've seen similar questions asked on this site, but haven't seen a solution or fix to resolve the problem. Our site is spawning a large number of select queries to the point where mysql is overloaded and causing sever capacity problems. Here's the query:
e INNER JOIN
at_inventory_in_stock ON (at_inventory_in_stock.
product_id=e.entity_id) AND ((at_inventory_in_stock.use_config_manage_stock = 0 AND at_inventory_in_stock.manage_stock=1 AND at_inventory_in_stock.is_in_stock=1) OR (at_inventory_in_stock.use_config_manage_stock = 0 AND at_inventory_in_stock.manage_stock=0) OR (at_inventory_in_stock.use_config_manage_stock = 1)) INNER JOIN
stock_status_index ON e.entity_id = stock_status_index.product_id INNER JOIN
links ON links.linked_product_id = e.entity_id AND links.link_type_id = 6 INNER JOIN
product_entity_table ON links.product_id = product_entity_table.entity_id WHERE (stock_status_index.stock_status = 1) AND (links.product_id in ('27120')) AND (
entity_id != '27120')
Our site has about 11000 products listed. This appeared out of the blue about 1 week ago and we do not have a solution.
Any help would be great! Thank you!