Jim;
Here is the error log of slow or poor Sql from the Control Panel that traps mysql_slow_queries.... I hope this will be the help you need to fix this issue....
Fri May 21 07:07:36 2010
# Query_time: 1.078522 Lock_time: 0.000055 Rows_sent: 0 Rows_examined: 2542150
SELECT * FROM ps3_optiongroups WHERE OptionGroupID IN (SELECT DISTINCT OptionGroupID FROM ps3_productoptions INNER JOIN ps3_options ON ps3_productoptions.OptionID = ps3_options.OptionID WHERE ProductID = 7504)
# Fri May 21 07:10:35 2010
# Query_time: 1.655210 Lock_time: 0.000043 Rows_sent: 0 Rows_examined: 2581260
SELECT * FROM ps3_optiongroups WHERE OptionGroupID IN (SELECT DISTINCT OptionGroupID FROM ps3_productoptions INNER JOIN ps3_options ON ps3_productoptions.OptionID = ps3_options.OptionID WHERE ProductID = 7504)
# Fri May 21 07:11:43 2010
# Query_time: 47.420225 Lock_time: 0.000150 Rows_sent: 10 Rows_examined: 45484
SELECT *,(SELECT ProductStock - coalesce(sum(DetailQuantity),0) AS NumLeft FROM (ps3_orderdetails join ps3_orders on((ps3_orders.OrderID = ps3_orderdetails.DetailOrderID))) WHERE ((ps3_orderdetails.DetailProductID = ProductID) and (ps3_orders.OrderDate > ProductUpdateDate))) AS NumLeft, (SELECT CouponProductID FROM ps3_couponproducts WHERE ps3_couponproducts.ProductID = ps3_products.ProductID AND couponID = -1 LIMIT 1) AS CouponProductID, coalesce((select ps3_productoptions.GroupingID FROM ps3_productoptions where ps3_productoptions.ProductID = ps3_products.ProductID limit 1),ps3_products.ProductID) AS GroupingID FROM ps3_products GROUP BY GroupingID ORDER BY ProductName LIMIT 0, 10
# Fri May 21 07:12:25 2010
# Query_time: 41.796191 Lock_time: 0.000122 Rows_sent: 54 Rows_examined: 45528
SELECT *,(SELECT ProductStock - coalesce(sum(DetailQuantity),0) AS NumLeft FROM (ps3_orderdetails join ps3_orders on((ps3_orders.OrderID = ps3_orderdetails.DetailOrderID))) WHERE ((ps3_orderdetails.DetailProductID = ProductID) and (ps3_orders.OrderDate > ProductUpdateDate))) AS NumLeft, (SELECT CouponProductID FROM ps3_couponproducts WHERE ps3_couponproducts.ProductID = ps3_products.ProductID AND couponID = -1 LIMIT 1) AS CouponProductID, coalesce((select ps3_productoptions.GroupingID FROM ps3_productoptions where ps3_productoptions.ProductID = ps3_products.ProductID limit 1),ps3_products.ProductID) AS GroupingID FROM ps3_products GROUP BY GroupingID ORDER BY ProductName
# Fri May 21 07:13:20 2010
# Query_time: 9.466472 Lock_time: 0.000163 Rows_sent: 0 Rows_examined: 20971453
SELECT *,(SELECT ProductStock - coalesce(sum(DetailQuantity),0) AS NumLeft FROM (ps3_orderdetails join ps3_orders on((ps3_orders.OrderID = ps3_orderdetails.DetailOrderID))) WHERE ((ps3_orderdetails.DetailProductID = ProductID) and (ps3_orders.OrderDate > ProductUpdateDate))) AS NumLeft, (SELECT CouponProductID FROM ps3_couponproducts WHERE ps3_couponproducts.ProductID = ps3_products.ProductID AND couponID = -1 LIMIT 1) AS CouponProductID, coalesce((select ps3_productoptions.GroupingID FROM ps3_productoptions where ps3_productoptions.ProductID = ps3_products.ProductID limit 1),ps3_products.ProductID) AS GroupingID FROM ps3_products WHERE ProductID IN (SELECT ProductID FROM ps3_productcategories WHERE (CategoryID = 15)) GROUP BY GroupingID ORDER BY ProductName LIMIT 0, 10
# Fri May 21 07:13:30 2010
# Query_time: 10.146906 Lock_time: 0.000133 Rows_sent: 0 Rows_examined: 20971453
SELECT *,(SELECT ProductStock - coalesce(sum(DetailQuantity),0) AS NumLeft FROM (ps3_orderdetails join ps3_orders on((ps3_orders.OrderID = ps3_orderdetails.DetailOrderID))) WHERE ((ps3_orderdetails.DetailProductID = ProductID) and (ps3_orders.OrderDate > ProductUpdateDate))) AS NumLeft, (SELECT CouponProductID FROM ps3_couponproducts WHERE ps3_couponproducts.ProductID = ps3_products.ProductID AND couponID = -1 LIMIT 1) AS CouponProductID, coalesce((select ps3_productoptions.GroupingID FROM ps3_productoptions where ps3_productoptions.ProductID = ps3_products.ProductID limit 1),ps3_products.ProductID) AS GroupingID FROM ps3_products WHERE ProductID IN (SELECT ProductID FROM ps3_productcategories WHERE (CategoryID = 15)) GROUP BY GroupingID ORDER BY ProductName
# Fri May 21 07:14:21 2010
# Query_time: 11.745622 Lock_time: 0.000162 Rows_sent: 3 Rows_examined: 48748
SELECT *,(SELECT ProductStock - coalesce(sum(DetailQuantity),0) AS NumLeft FROM (ps3_orderdetails join ps3_orders on((ps3_orders.OrderID = ps3_orderdetails.DetailOrderID))) WHERE ((ps3_orderdetails.DetailProductID = ProductID) and (ps3_orders.OrderDate > ProductUpdateDate))) AS NumLeft, (SELECT CouponProductID FROM ps3_couponproducts WHERE ps3_couponproducts.ProductID = ps3_products.ProductID AND couponID = -1 LIMIT 1) AS CouponProductID, coalesce((select ps3_productoptions.GroupingID FROM ps3_productoptions where ps3_productoptions.ProductID = ps3_products.ProductID limit 1),ps3_products.ProductID) AS GroupingID FROM ps3_products WHERE ProductID IN (SELECT ProductID FROM ps3_productcategories WHERE (CategoryID = 17)) GROUP BY GroupingID ORDER BY ProductName LIMIT 0, 10
# Fri May 21 07:14:33 2010
# Query_time: 12.275066 Lock_time: 0.000119 Rows_sent: 3 Rows_examined: 48748
SELECT *,(SELECT ProductStock - coalesce(sum(DetailQuantity),0) AS NumLeft FROM (ps3_orderdetails join ps3_orders on((ps3_orders.OrderID = ps3_orderdetails.DetailOrderID))) WHERE ((ps3_orderdetails.DetailProductID = ProductID) and (ps3_orders.OrderDate > ProductUpdateDate))) AS NumLeft, (SELECT CouponProductID FROM ps3_couponproducts WHERE ps3_couponproducts.ProductID = ps3_products.ProductID AND couponID = -1 LIMIT 1) AS CouponProductID, coalesce((select ps3_productoptions.GroupingID FROM ps3_productoptions where ps3_productoptions.ProductID = ps3_products.ProductID limit 1),ps3_products.ProductID) AS GroupingID FROM ps3_products WHERE ProductID IN (SELECT ProductID FROM ps3_productcategories WHERE (CategoryID = 17)) GROUP BY GroupingID ORDER BY ProductName
# Fri May 21 07:15:07 2010
# Query_time: 1.100011 Lock_time: 0.000036 Rows_sent: 0 Rows_examined: 2581260
SELECT * FROM ps3_optiongroups WHERE OptionGroupID IN (SELECT DISTINCT OptionGroupID FROM ps3_productoptions INNER JOIN ps3_options ON ps3_productoptions.OptionID = ps3_options.OptionID WHERE ProductID = 7528)
# Fri May 21 07:16:28 2010
# Query_time: 15.762986 Lock_time: 0.000562 Rows_sent: 10 Rows_examined: 20011017
SELECT * , coalesce((select ps3_productoptions.GroupingID from ps3_productoptions WHERE ps3_productoptions.ProductID = ps3_products.ProductID limit 1),ps3_products.ProductID) AS GroupingID FROM ps3_products WHERE ProductLive = 1 GROUP BY GroupingID ORDER BY ProductName LIMIT 10, 10
# Fri May 21 07:21:06 2010
# Query_time: 1.117596 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 2620370
SELECT * FROM ps3_optiongroups WHERE OptionGroupID IN (SELECT DISTINCT OptionGroupID FROM ps3_productoptions INNER JOIN ps3_options ON ps3_productoptions.OptionID = ps3_options.OptionID WHERE ProductID = 7528)
# Fri May 21 07:23:04 2010
# Query_time: 111.880396 Lock_time: 0.000059 Rows_sent: 0 Rows_examined: 39109
SELECT DISTINCT ps3_products.ProductID, COALESCE(ps3_productoptions.GroupingID,ps3_products.ProductID) AS GroupingID FROM ps3_products LEFT OUTER JOIN ps3_productoptions ON ps3_productoptions.ProductID = ps3_products.ProductID WHERE ps3_productoptions.GroupingID = (SELECT GroupingID FROM ps3_productoptions WHERE ProductID = 7528 LIMIT 1 ) OR ps3_products.ProductID = 7528
# Fri May 21 07:28:36 2010
# Query_time: 117.540000 Lock_time: 0.000070 Rows_sent: 0 Rows_examined: 39109
SELECT DISTINCT ps3_products.ProductID, COALESCE(ps3_productoptions.GroupingID,ps3_products.ProductID) AS GroupingID FROM ps3_products LEFT OUTER JOIN ps3_productoptions ON ps3_productoptions.ProductID = ps3_products.ProductID WHERE ps3_productoptions.GroupingID = (SELECT GroupingID FROM ps3_productoptions WHERE ProductID = 7528 LIMIT 1 ) OR ps3_products.ProductID = 7528