Падает база - подсобите советом (Opencart)

# Query_time: 74.790640 Lock_time: 0.000149 Rows_sent: 10 Rows_examined:
72863490
SELECT p.product_id, (SELECT AVG(rating) AS total FROM oym_review r1 WHERE
r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS
rati
ng, (SELECT price FROM oym_product_special ps WHERE ps.product_id =
p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00'
OR ps.da
te_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT COUNT(*)
AS
total FROM oym_order_product op LEFT JOIN `oym_order` o ON (op.order_id =
o.order_id) WHERE o.order_status_id > '0' AND op.product_id = p.product_id
GROUP
BY op.product_id) as topsellers FROM oym_product p LEFT JOIN
oym_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN
oym_product_to_store p2
s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status =
'1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_
id ORDER BY p.date_added DESC LIMIT 10;

# Query_time: 145.558326 Lock_time: 66.791127 Rows_sent: 10 Rows_examined:
72863490
SELECT p.product_id, (SELECT AVG(rating) AS total FROM oym_review r1 WHERE
r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS
rati
ng, (SELECT price FROM oym_product_special ps WHERE ps.product_id =
p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00'
OR ps.da
te_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT COUNT(*)
AS
total FROM oym_order_product op LEFT JOIN `oym_order` o ON (op.order_id =
o.order_id) WHERE o.order_status_id > '0' AND op.product_id = p.product_id
GROUP
BY op.product_id) as topsellers FROM oym_product p LEFT JOIN
oym_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN
oym_product_to_store p2
s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status =
'1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_
id ORDER BY p.date_added DESC LIMIT 10;

# Query_time: 72.412323 Lock_time: 6.867669 Rows_sent: 10 Rows_examined:
72863490
SELECT p.product_id, (SELECT AVG(rating) AS total FROM oym_review r1 WHERE
r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS
rati
ng, (SELECT price FROM oym_product_special ps WHERE ps.product_id =
p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00'
OR ps.da
te_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT COUNT(*)
AS
total FROM oym_order_product op LEFT JOIN `oym_order` o ON (op.order_id =
o.order_id) WHERE o.order_status_id > '0' AND op.product_id = p.product_id
GROUP
BY op.product_id) as topsellers FROM oym_product p LEFT JOIN
oym_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN
oym_product_to_store p2
s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status =
'1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_
id ORDER BY p.date_added DESC LIMIT 10;

# Query_time: 128.729961 Lock_time: 63.209647 Rows_sent: 10 Rows_examined:
72844697
use shopauto_db;
SELECT p.product_id, (SELECT AVG(rating) AS total FROM oym_review r1 WHERE
r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS
rati
ng, (SELECT price FROM oym_product_special ps WHERE ps.product_id =
p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00'
OR ps.da
te_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT COUNT(*)
AS
total FROM oym_order_product op LEFT JOIN `oym_order` o ON (op.order_id =
o.order_id) WHERE o.order_status_id > '0' AND op.product_id = p.product_id
GROUP
BY op.product_id) as topsellers FROM oym_product p LEFT JOIN
oym_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN
oym_product_to_store p2
s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status =
'1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_
id ORDER BY p.viewed DESC LIMIT 10;