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

porter

Newbie
  
  • Posts

    5
  • Joined

  • Last visited

1 Follower

porter's Achievements

Newbie

Newbie (1/14)

  • Conversation Starter
  • First Post
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

0

Reputation

  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 запроса на страницу.
Guest
×
  • 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.