Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
  • Sign Up

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


Recommended Posts

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

Link to post
Share on other sites

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

Link to post
Share on other sites

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

Link to post
Share on other sites

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

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

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

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

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

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

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

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

3144 - 3019 - 19 = 106

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

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

Link to post
Share on other sites

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

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

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

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

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

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.