Поставил обычный ocStore последний, никаких посторонних модулей.
Работает в принципе быстро, но когда я посмотрел в лог MySQL я был ва**е.
Просто нажав на любой товар в логе появляется примерно такое кол-во запросов:
7200 Connect oc_store@localhost on 7200 Init DB oc_store 7200 Query SET NAMES 'utf8' 7200 Query SET CHARACTER SET utf8 7200 Query SET CHARACTER_SET_CONNECTION=utf8 7200 Query SET SQL_MODE = '' 7200 Query SELECT * FROM oc_setting 7200 Query SELECT * FROM oc_store WHERE url = '**' OR url = '**' 7200 Query SELECT * FROM oc_language 7200 Query SELECT * FROM oc_currency 7200 Query SELECT tr.tax_class_id, tr.rate AS rate, tr.description, tr.priority FROM oc_tax_rate tr LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id) WHERE (z2gz.country_id = '0' OR z2gz.country_id = '220') AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3487') ORDER BY tr.priority ASC 7200 Query SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1' 7200 Query SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1' 7200 Query SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, ss.name AS stock FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN oc_stock_status ss ON (p.stock_status_id = ss.stock_status_id) WHERE p.product_id = '66' AND pd.language_id = '1' AND p2s.store_id = '0' AND ss.language_id = '1' AND p.date_available <= NOW() AND p.status = '1' 7200 Query SELECT COUNT(*) AS total FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '66' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' 7200 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '66' GROUP BY product_id101007 17:23:16 7200 Query SELECT price FROM oc_product_discount WHERE product_id = '66' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7200 Query SELECT price FROM oc_product_special WHERE product_id = '66' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7200 Query SELECT * FROM oc_product_discount WHERE product_id = '66' AND customer_group_id = '8' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC 7200 Query SELECT * FROM oc_product_option WHERE product_id = '66' ORDER BY sort_order 7200 Query SELECT * FROM oc_product_image WHERE product_id = '66' 7200 Query SELECT * FROM oc_product_related WHERE product_id = '66' 7200 Query UPDATE oc_product SET viewed = viewed + 1 WHERE product_id = '66' 7200 Query SELECT * FROM oc_product_tags WHERE product_id = '66' AND language_id = '1' 7200 Query SELECT * FROM oc_extension WHERE `type` = 'module' 7200 Query SELECT * FROM oc_extension WHERE `type` = 'total' 7200 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '66' GROUP BY product_id 7200 Query SELECT price FROM oc_product_discount WHERE product_id = '66' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7200 Query SELECT price FROM oc_product_special WHERE product_id = '66' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7200 Query SELECT * FROM oc_product_option WHERE product_id = '66' ORDER BY sort_order 7200 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '57' GROUP BY product_id 7200 Query SELECT price FROM oc_product_discount WHERE product_id = '57' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7200 Query SELECT price FROM oc_product_special WHERE product_id = '57' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7200 Query SELECT * FROM oc_product_option WHERE product_id = '57' ORDER BY sort_order 7200 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '66' GROUP BY product_id 7200 Query SELECT price FROM oc_product_discount WHERE product_id = '66' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7200 Query SELECT price FROM oc_product_special WHERE product_id = '66' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7200 Query SELECT * FROM oc_product_option WHERE product_id = '66' ORDER BY sort_order 7200 Query SELECT * FROM oc_extension WHERE `type` = 'module' 7200 Query SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' AND i.sort_order <> '-1' ORDER BY i.sort_order, LCASE(id.title) ASC 7200 Query SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '37' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1' ORDER BY c.sort_order, LCASE(cd.name) 7200 Query SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '35' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1' ORDER BY c.sort_order, LCASE(cd.name) 7200 Query SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '38' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1' ORDER BY c.sort_order, LCASE(cd.name) 7200 Query SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '39' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1' ORDER BY c.sort_order, LCASE(cd.name) 7200 Quit 7201 Connect oc_store@localhost on 7201 Init DB oc_store 7201 Query SET NAMES 'utf8' 7201 Query SET CHARACTER SET utf8 7201 Query SET CHARACTER_SET_CONNECTION=utf8 7201 Query SET SQL_MODE = '' 7201 Query SELECT * FROM oc_setting 7201 Query SELECT * FROM oc_store WHERE url = '**' OR url = '**' 7201 Query SELECT * FROM oc_language 7201 Query SELECT * FROM oc_currency 7201 Query SELECT tr.tax_class_id, tr.rate AS rate, tr.description, tr.priority FROM oc_tax_rate tr LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id) WHERE (z2gz.country_id = '0' OR z2gz.country_id = '220') AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3487') ORDER BY tr.priority ASC 7201 Query SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1' 7201 Query SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1' 7201 Quit 7202 Connect oc_store@localhost on 7202 Init DB oc_store 7202 Query SET NAMES 'utf8' 7202 Query SET CHARACTER SET utf8 7202 Query SET CHARACTER_SET_CONNECTION=utf8 7202 Query SET SQL_MODE = '' 7202 Query SELECT * FROM oc_setting 7202 Query SELECT * FROM oc_store WHERE url = '**' OR url = '**' 7202 Query SELECT * FROM oc_language 7203 Connect oc_store@localhost on 7203 Init DB oc_store 7203 Query SET NAMES 'utf8' 7203 Query SET CHARACTER SET utf8 7203 Query SET CHARACTER_SET_CONNECTION=utf8 7203 Query SET SQL_MODE = '' 7203 Query SELECT * FROM oc_setting 7203 Query SELECT * FROM oc_store WHERE url = '**' OR url = 'h**' 7202 Query SELECT * FROM oc_currency 7202 Query SELECT tr.tax_class_id, tr.rate AS rate, tr.description, tr.priority FROM oc_tax_rate tr LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id) WHERE (z2gz.country_id = '0' OR z2gz.country_id = '220') AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3487') ORDER BY tr.priority ASC 7202 Query SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1' 7202 Query SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1' 7202 Query SELECT * FROM oc_extension WHERE `type` = 'module' 7202 Query SELECT * FROM oc_extension WHERE `type` = 'module' 7202 Query SELECT * FROM oc_extension WHERE `type` = 'total' 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '66' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '66' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '66' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '66' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '57' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '57' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '57' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '57' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '66' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '66' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '66' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '66' ORDER BY sort_order 7202 Query SELECT * FROM oc_extension WHERE `type` = 'module' 7202 Query SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' AND i.sort_order <> '-1' ORDER BY i.sort_order, LCASE(id.title) ASC 7202 Query SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '37' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1' ORDER BY c.sort_order, LCASE(cd.name) 7202 Query SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '35' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1' ORDER BY c.sort_order, LCASE(cd.name) 7202 Query SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '38' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1' ORDER BY c.sort_order, LCASE(cd.name) 7202 Query SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '39' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1' ORDER BY c.sort_order, LCASE(cd.name) 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '67' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '67' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '67' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '67' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '66' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '66' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '66' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '66' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '65' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '65' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '65' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '65' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '64' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '64' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '64' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '64' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '63' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '63' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '63' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '63' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '62' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '62' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '62' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '62' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '61' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '61' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '61' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '61' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '60' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '60' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '60' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '60' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '59' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '59' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '59' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '59' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '58' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '58' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '58' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '58' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '57' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '57' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '57' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '57' ORDER BY sort_order 7202 Query SELECT AVG(rating) AS total FROM oc_review WHERE status = '1' AND product_id = '56' GROUP BY product_id 7202 Query SELECT price FROM oc_product_discount WHERE product_id = '56' AND customer_group_id = '8' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT price FROM oc_product_special WHERE product_id = '56' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1 7202 Query SELECT * FROM oc_product_option WHERE product_id = '56' ORDER BY sort_order 7202 Quit 7203 Query SELECT * FROM oc_language 7203 Query SELECT * FROM oc_currency 7203 Query SELECT tr.tax_class_id, tr.rate AS rate, tr.description, tr.priority FROM oc_tax_rate tr LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id) WHERE (z2gz.country_id = '0' OR z2gz.country_id = '220') AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3487') ORDER BY tr.priority ASC 7203 Query SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1' 7203 Query SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1' 7203 Query SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '66' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,5 7203 Query SELECT COUNT(*) AS total FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '66' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' 7203 Quit
Это нормально?
Хостинг у меня слабый, серьезно думаю о смене движка. Есть движки, которые делают по 4 запроса на страницу.