[Solved] SQL Help Please!
Posted: Sun May 09, 2021 2:15 pm
Hi,
Can anyone help me identify what could be using this SQL statement? Unforunately I don't get much info from the slow query log that a2hosting is giving me. We are on their prestige VPS so I am not sure why we are maxing out the resources. This query stands out as taking long as it runs against all 80,000 products. I have no clue what is triggering it. www.stevestonmarine.com and on opencart 2.3.0.2
SELECT p.product_id, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id AND pd.language_id = 1) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id AND p2s.store_id = 0) LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_category_description cd ON (p2c.category_id = cd.category_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.date_available <= NOW() AND p.status = 1 AND ((p.product_id =
Can anyone help me identify what could be using this SQL statement? Unforunately I don't get much info from the slow query log that a2hosting is giving me. We are on their prestige VPS so I am not sure why we are maxing out the resources. This query stands out as taking long as it runs against all 80,000 products. I have no clue what is triggering it. www.stevestonmarine.com and on opencart 2.3.0.2
SELECT p.product_id, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id AND pd.language_id = 1) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id AND p2s.store_id = 0) LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_category_description cd ON (p2c.category_id = cd.category_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.date_available <= NOW() AND p.status = 1 AND ((p.product_id =