Clicking on adjustments results to 100% cpu utilization for mysql

Hi,

Recently found a bug in my system , such that whenever I click on adjustments tab of specific product edit page, the cpu utilization for mysql shoots up to 100% for some reason.

I tried firing directly the query on mysql command line but still the mysql hangs up .It may be because of too much data for that specific product.

Below is the query that is being fired for the product page:_

SELECT COUNT(*) FROM (uc_product_options AS po1 LEFT JOIN uc_attribute_options AS ao1 ON po1.oid = ao1.oid AND po1.nid = 176), (uc_product_options AS po2 LEFT JOIN uc_attribute_options AS ao2 ON po2.oid = ao2.oid AND po2.nid = 176), (uc_product_options AS po3 LEFT JOIN uc_attribute_options AS ao3 ON po3.oid = ao3.oid AND po3.nid = 176), (uc_product_options AS po4 LEFT JOIN uc_attribute_options AS ao4 ON po4.oid = ao4.oid AND po4.nid = 176), (uc_product_options AS po5 LEFT JOIN uc_attribute_options AS ao5 ON po5.oid = ao5.oid AND po5.nid = 176), (uc_product_options AS po6 LEFT JOIN uc_attribute_options AS ao6 ON po6.oid = ao6.oid AND po6.nid = 176), (uc_product_options AS po7 LEFT JOIN uc_attribute_options AS ao7 ON po7.oid = ao7.oid AND po7.nid = 176), (uc_product_options AS po8 LEFT JOIN uc_attribute_options AS ao8 ON po8.oid = ao8.oid AND po8.nid = 176), (uc_product_options AS po9 LEFT JOIN uc_attribute_options AS ao9 ON po9.oid = ao9.oid AND po9.nid = 176) WHERE ao1.aid = 20 AND ao2.aid = 21 AND ao3.aid = 4 AND ao4.aid = 1 AND ao5.aid = 2 AND ao6.aid = 6 AND ao7.aid = 5 AND ao8.aid = 19 AND ao9.aid = 10

I tried increasing mysql parameters like "max_packet_sent" and all but still thats not really helping.

Is there any solution by which I can fix this issue?

Tks
Vil