porter

Новичок
  • Публикаций

    5
  • Зарегистрирован

  • Посещение

Репутация

0 Обычный

Информация о porter

  • Звание
    Новичок
  1. Я это и имею в виду: 100 запросов на генерацию страницы, ... нет слов. Тупо в цикле, наверно, вызываются. Вместо того, чтобы вызвать 10-15 больших - вызывается 100 мелких. Каждый раз генерируется меню - зачем? Почти все модули можно закешировать, это сопряжено со сбросом кеша в необходимых местах. Но, конечно, 100 запросов сделать проще. PS: 100500 == "очень много" :oops: PS2: вот прочитал на хабре http://habrahabr.ru/blogs/webdev/92607/ про некий ECShop - судя по описанию, как минимум стоит поставить и потестить.
  2. Какая статистика?В сабже лог mysql после обновления страницы.Я не понимаю почему не кешируется меню, зачем делать запрос о рейтинге к каждому товару отдельным запросом (это вообще жесть), зачем 4(!) соединения. Это основное, что бросается в глаза.Зачем рейтинг товаров пересчитывать в каждом запросе , когда можно это сделать при посте отзыва и вписать в поле.
  3. надо создать отдельную статью (то есть просто html страницу) и кинуть на нее ссылку. Может можно еще как-то.
  4. я в панике, 4 соединения, и каждому надо пицот запросов.
  5. Поставил обычный 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 запроса на страницу.