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

Гість6 років у сервісі

Дані замовника будуть вам доступні після подання заявки

15.05.2019

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

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

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

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

Opencart SQL