В категории 0.5 секунд коту под хвост одим только запросом
Без комментариев
Страница: /seks-tovary-dlya-zhenshin/pompy-dlya-klitora/
Источник: /catalog/model/revolution/revolution.php
Время (общее): 0.73191309 c
Время: 0.42477703 c
Номер запроса: 37
SELECT * FROM (SELECT p.product_id, p.sort_order, p.model, pd.name, p.quantity, p.price, p.date_added, p.quantity > 0 as nalichie, p.price > 0 as nalichie2, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW() ) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW() )) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW() ) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW() )) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM oc_product p LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' AND p.date_added BETWEEN '2020-03-26 14:30:58' AND NOW() ORDER BY p.date_added DESC LIMIT 0, 240) p ORDER BY nalichie2 DESC, nalichie DESC, p.date_added DESC, LCASE(p.name) DESC LIMIT 0,240
start [/index.php::19] -> require_once [/system/startup.php::105] -> Front::dispatch [/system/framework.php::103] -> Front::execute [/system/engine/front.php::29] -> Action::execute [/system/engine/front.php::34] -> ControllerProductCategory::index [/system/storage/modification/system/engine/action.php::51] -> Proxy::__call [/system/storage/modification/catalog/controller/product/category.php::597] -> Loader::{closure} [/system/engine/proxy.php::25] -> ModelRevolutionRevolution::getLastProducts [/system/storage/modification/system/engine/loader.php::218] -> DB::query [/catalog/model/revolution/revolution.php::260]
Loader -> {closure}
ModelRevolutionRevolution -> getLastProducts
Зачем там LastProducts в контроллере категории (которые даже не выводятся)
Заходят потом пользователи, боты и просто вот таким хламом убивают даже хорошо настроенный сервер
Уважаемые темо-писатели (грешат 90%) зачем вы вставляете такой хлам (который по сути и не надо) в основные, стандартные, котроллеры opencart.