Opencart 2.1 решить проблему медленных запросов SQL

Проблема медленных запросов к базе данных 

хостинг провайдер отключил сайт из за перегрузки процессора медленными запросами к базе 

пример запросов: 

SELECT p.product_id,pd.name,p.price,p.quantity,p.model,p.sku,\n\np.weight,w.unit\n\t\t\t\t\t\t\t\t FROM\n\t\t\t\t\t\t\t\t oc_product AS p\n\t\t\t\t\t\t\t\t INNER JOIN oc_product_description AS pd ON pd.product_id = p.product_id\n\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\tINNER JOIN oc_product_attribute AS pa ON pa.attribute_id = 21 AND pa.product_id = p.product_id\n\t\t\t\t\t\t\t\t\tINNER JOIN oc_weight_class_description AS w ON w.weight_class_id = p.weight_class_id\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tpa.text =13212\n\t\t\t\t\t\t\t\t\tORDER BY product_id ASC  670408490

razborkam_sich  razborkam_sich  0  Copying to tmp table  SELECT p.product_id,pd.name,p.price,p.quantity,p.model,p.sku,\n\np.weight,w.unit\n\t\t\t\t\t\t\t\t FROM\n\t\t\t\t\t\t\t\t oc_product AS p\n\t\t\t\t\t\t\t\t INNER JOIN oc_product_description AS pd ON pd.product_id = p.product_id\n\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\tINNER JOIN oc_product_attribute AS pa ON pa.attribute_id = 21 AND pa.product_id = p.product_id\n\t\t\t\t\t\t\t\t\tINNER JOIN oc_weight_class_description AS w ON w.weight_class_id = p.weight_class_id\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tpa.text =1861\n\t\t\t\t\t\t\t\t\tORDER BY product_id ASC  670408464

razborkam_sich  razborkam_sich  0  Copying to tmp table  SELECT p.product_id,pd.name,p.price,p.quantity,p.model,p.sku,\n\np.weight,w.unit\n\t\t\t\t\t\t\t\t FROM\n\t\t\t\t\t\t\t\t oc_product AS p\n\t\t\t\t\t\t\t\t INNER JOIN oc_product_description AS pd ON pd.product_id = p.product_id\n\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\tINNER JOIN oc_product_attribute AS pa ON pa.attribute_id = 21 AND pa.product_id = p.product_id\n\t\t\t\t\t\t\t\t\tINNER JOIN oc_weight_class_description AS w ON w.weight_class_id = p.weight_class_id\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tpa.text =2305\n\t\t\t\t\t\t\t\t\tORDER BY product_id ASC  670408599

razborkam_sich  razborkam_sich  0  Copying to tmp table  SELECT p.product_id,pd.name,p.price,p.quantity,p.model,p.sku,\n\np.weight,w.unit\n\t\t\t\t\t\t\t\t FROM\n\t\t\t\t\t\t\t\t oc_product AS p\n\t\t\t\t\t\t\t\t INNER JOIN oc_product_description AS pd ON pd.product_id = p.product_id\n\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\tINNER JOIN oc_product_attribute AS pa ON pa.attribute_id = 21 AND pa.product_id = p.product_id\n\t\t\t\t\t\t\t\t\tINNER JOIN oc_weight_class_description AS w ON w.weight_class_id = p.weight_class_id\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tpa.text =361\n\t\t\t\t\t\t\t\t\tORDER BY product_id ASC  670408323

razborkam_sich  razborkam_sich  0  Copying to tmp table  SELECT p.product_id,pd.name,p.price,p.quantity,p.model,p.sku,\n\np.weight,w.unit\n\t\t\t\t\t\t\t\t FROM\n\t\t\t\t\t\t\t\t oc_product AS p\n\t\t\t\t\t\t\t\t INNER JOIN oc_product_description AS pd ON pd.product_id = p.product_id\n\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\tINNER JOIN oc_product_attribute AS pa ON pa.attribute_id = 21 AND pa.product_id = p.product_id\n\t\t\t\t\t\t\t\t\tINNER JOIN oc_weight_class_description AS w ON w.weight_class_id = p.weight_class_id\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tpa.text =3670\n\t\t\t\t\t\t\t\t\tORDER BY product_id ASC