1 обьемный запрос сайт opencart 3
Добавлено: 06 окт 2019 13:05
Подскажите как решить проблему обьёмных запросов?
Обнаружено на URL: avtozapchasti/zapchasti-moskvich/begunok-
Вызвано из: start -> require_once -> Router:dispatch -> Router:execute -> Action:execute -> ControllerStartupRouter:index -> Action:execute -> ControllerProductCategory:index -> Proxy:__call -> Loader:{closure} -> ModelCatalogCategory:getCategory -> light_optimize_query -> Wdp
SELECT *, (SELECT `keyword` FROM oc_seo_url WHERE `query` = CONCAT('category_id=', c.category_id) AND language_id='1' AND store_id='0' LIMIT 1) as xseo 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 cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
Обнаружено на URL: avtozapchasti/zapchasti-moskvich/begunok-
Вызвано из: start -> require_once -> Router:dispatch -> Router:execute -> Action:execute -> ControllerStartupRouter:index -> Action:execute -> ControllerProductCategory:index -> Proxy:__call -> Loader:{closure} -> ModelCatalogCategory:getCategory -> light_optimize_query -> Wdp
SELECT *, (SELECT `keyword` FROM oc_seo_url WHERE `query` = CONCAT('category_id=', c.category_id) AND language_id='1' AND store_id='0' LIMIT 1) as xseo 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 cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)