Проблема медленных запросов к базе данных 
хостинг провайдер отключил сайт из за перегрузки процессора медленными запросами к базе 
пример запросов: 
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 

Проблема медленных запросов к базе данных 
хостинг провайдер отключил сайт из за перегрузки процессора медленными запросами к базе 
пример запросов: 
SELECT p.product_id,<a href="http://pd.name" rel="nofollow noopener noreferrer" target="_blank">pd.name</a>,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,<a href="http://pd.name" rel="nofollow noopener noreferrer" target="_blank">pd.name</a>,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,<a href="http://pd.name" rel="nofollow noopener noreferrer" target="_blank">pd.name</a>,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,<a href="http://pd.name" rel="nofollow noopener noreferrer" target="_blank">pd.name</a>,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,<a href="http://pd.name" rel="nofollow noopener noreferrer" target="_blank">pd.name</a>,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

Гость guest_15579184481308

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