Перейти к содержанию
porter

Запросы к базе, 100500шт это нормально?

Рекомендуемые сообщения

Поставил обычный 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 запроса на страницу.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

я в панике, 4 соединения, и каждому надо пицот запросов.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Забавно. А как собиралась статистика?

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Какая статистика?В сабже лог mysql после обновления страницы.Я не понимаю почему не кешируется меню, зачем делать запрос о рейтинге к каждому товару отдельным запросом (это вообще жесть), зачем 4(!) соединения. Это основное, что бросается в глаза.Зачем рейтинг товаров пересчитывать в каждом запросе , когда можно это сделать при посте отзыва и вписать в поле.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

localhost/phpmyadmin -> текущее состояние mysql:

Статистика запросов: со времени запуска, на сервер было отослано запросов - 3,000.

после нажатия ссылки "обновить статистику":

Статистика запросов: со времени запуска, на сервер было отослано запросов - 3,019.

итого 19 запросов на сервер просто при обновлении статистики.

теперь обновляю страницу с продуктом:

Статистика запросов: со времени запуска, на сервер было отослано запросов - 3,144.

как видим - запросов прошло:

3144 - 3019 - 19 = 106

porter, откуда у Вас "такие" данные ?! О_о

не потеряли ли Вы дефис 100-500шт при создании темы?

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Я это и имею в виду: 100 запросов на генерацию страницы, ... нет слов.

Тупо в цикле, наверно, вызываются. Вместо того, чтобы вызвать 10-15 больших - вызывается 100 мелких.

Каждый раз генерируется меню - зачем? Почти все модули можно закешировать, это сопряжено со сбросом кеша в необходимых местах. Но, конечно, 100 запросов сделать проще.

PS: 100500 == "очень много" :oops:

PS2: вот прочитал на хабре http://habrahabr.ru/blogs/webdev/92607/ про некий ECShop - судя по описанию, как минимум стоит поставить и потестить.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Для публикации сообщений создайте учётную запись или авторизуйтесь

Вы должны быть пользователем, чтобы оставить комментарий

Создать учетную запись

Зарегистрируйте новую учётную запись в нашем сообществе. Это очень просто!

Регистрация нового пользователя

Войти

Уже есть аккаунт? Войти в систему.

Войти

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

×

Важная информация

На нашем сайте используются файлы cookie и происходит обработка некоторых персональных данных пользователей, чтобы улучшить пользовательский интерфейс. Чтобы узнать для чего и какие персональные данные мы обрабатываем перейдите по ссылке. Если Вы нажмете «Я даю согласие», это означает, что Вы понимаете и принимаете все условия, указанные в этом Уведомлении о Конфиденциальности.