Форумы

Нашел проблему. Нужно было выгружать через phpMyAdmin - импорт
А не через OpenCart

Наблюдайте, исправили домен в сообщении на почту. По поводу Api в личку напишите какие именно заказы пришли без доменов

Пофиксили

Добрый день, Стоит Джеткеш 7, и Мегафильтр. Задача при поиске фильтровать результаты поиска.  Без фильтра поиск работает 1-1.5 сек, с фильтром 4.5-6.5 сек. У фильтра стоит кеш и при последующем поиске уже снова 1.5 сек.  Вопрос, как снизить хотябы до 2-3 сек первоначальную фильтрацию.  Выкладываю лог медленных запросов, как я понимаю это как раз цепочка в поиске которая длиться около 5.6 сек.  Подскажите какие запросы можно закешировать? Джеткеш 7 как я понимаю может отдельные методы кешировать            ***************************************| /index.php?route=product/search&search=%D0%B0%D1%80%D0%B1%D1%83%D0%B7&description= |*************************************** Страница: /index.php?route=product/search&search=%D0%B0%D1%80%D0%B1%D1%83%D0%B7&description= Источник:/var/www/u0302539/data/www/xxxxxxxxx.ru/system/storage/modification/catalog/model/catalog/product.php Время: 0.288999 c Время (общее): : 0.34866 c Номер запроса: : 142 SELECT COUNT(DISTINCT p.product_id) AS total 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_kjseries_product_hidden kph ON (p.product_id = kph.pid) WHERE kph.pid IS NULL AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( pd.name LIKE '%арбуз%' OR pd.tag LIKE '%арбуз%' OR LCASE(p.model) LIKE '%арбуз%') ControllerProductSearch -> index ModelCatalogProduct -> getTotalProducts ---------------------- Страница: /index.php?route=product/search&search=%D0%B0%D1%80%D0%B1%D1%83%D0%B7&description= Источник:/var/www/u0302539/data/www/xxxxxxxxx.ru/system/storage/modification/catalog/model/catalog/product.php Время: 0.305782 c Время (общее): : 0.655198 c Номер запроса: : 143 SELECT p.product_id, (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, (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 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_kjseries_product_hidden kph ON (p.product_id = kph.pid) WHERE kph.pid IS NULL AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( pd.name LIKE '%арбуз%' OR pd.tag LIKE '%арбуз%' OR LCASE(p.model) LIKE '%арбуз%') GROUP BY p.product_id ORDER BY (p.quantity>0) DESC,p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,30 ControllerProductSearch -> index ModelCatalogProduct -> getProducts ---------------------- Страница: /index.php?route=product/search&search=%D0%B0%D1%80%D0%B1%D1%83%D0%B7&description= Источник:/var/www/u0302539/data/www/xxxxxxxx.ru/catalog/model/module/mega_filter.php Время: 1.67247 c Время (общее): : 2.547213 c Номер запроса: : 505 SELECT `a`.`attribute_id` FROM `oc_product` AS `p` INNER JOIN `oc_product_to_store` AS `pts` ON `p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0 INNER JOIN `oc_product_attribute` AS `pa` ON `p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 1 INNER JOIN `oc_attribute` AS `a` ON `a`.`attribute_id` = `pa`.`attribute_id` INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 1 WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND ((LCASE(`pd`.`name`) LIKE '%арбуз%') OR LCASE(`p`.`model`) = 'арбуз' OR LCASE(`p`.`sku`) = 'арбуз' OR LCASE(`p`.`upc`) = 'арбуз' OR LCASE(`p`.`ean`) = 'арбуз' OR LCASE(`p`.`jan`) = 'арбуз' OR LCASE(`p`.`isbn`) = 'арбуз' OR LCASE(`p`.`mpn`) = 'арбуз' OR LCASE(`pd`.`tag`) LIKE '%арбуз%') GROUP BY `pa`.`attribute_id` ModelModuleMegaFilter -> createAttribs ModelModuleMegaFilter -> boostCreateAttribs ---------------------- Страница: /index.php?route=product/search&search=%D0%B0%D1%80%D0%B1%D1%83%D0%B7&description= Источник:/var/www/u0302539/data/www/xxxxxxx.ru/catalog/model/module/mega_filter.php Время: 1.948693 c Время (общее): : 4.49621 c Номер запроса: : 506 SELECT `a`.`attribute_id`, REPLACE(REPLACE(TRIM(pa.text), ' ', ''), ' ', '') AS `txt`, `ad`.`name`, `ad`.`mf_tooltip` AS `tooltip`, `agd`.`name` AS `gname`, `agd`.`attribute_group_id` FROM `oc_product` AS `p` INNER JOIN `oc_product_to_store` AS `pts` ON `p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0 INNER JOIN `oc_product_attribute` AS `pa` ON `p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 1 INNER JOIN `oc_attribute` AS `a` ON `a`.`attribute_id` = `pa`.`attribute_id` INNER JOIN `oc_attribute_description` AS `ad` ON `ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 1 INNER JOIN `oc_attribute_group` AS `ag` ON `ag`.`attribute_group_id` = `a`.`attribute_group_id` INNER JOIN `oc_attribute_group_description` AS `agd` ON `agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 1 INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 1 WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `a`.`attribute_id` IN(741,742,743,747,748,761,785,788,789,791,794,796,798) AND ((LCASE(`pd`.`name`) LIKE '%арбуз%') OR LCASE(`p`.`model`) = 'арбуз' OR LCASE(`p`.`sku`) = 'арбуз' OR LCASE(`p`.`upc`) = 'арбуз' OR LCASE(`p`.`ean`) = 'арбуз' OR LCASE(`p`.`jan`) = 'арбуз' OR LCASE(`p`.`isbn`) = 'арбуз' OR LCASE(`p`.`mpn`) = 'арбуз' OR LCASE(`pd`.`tag`) LIKE '%арбуз%') GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != '' ORDER BY `txt` ModelModuleMegaFilter -> getAttributes ModelModuleMegaFilter -> createAttribs ---------------------- Страница: /index.php?route=product/search&search=%D0%B0%D1%80%D0%B1%D1%83%D0%B7&description= Источник:/var/www/u0302539/data/www/xxxxxxx.ru/catalog/model/module/mega_filter.php Время: 0.258404 c Время (общее): : 4.769351 c Номер запроса: : 510 SELECT `m`.* FROM `oc_manufacturer` AS `m` INNER JOIN `oc_manufacturer_to_store` AS `m2s` ON `m`.`manufacturer_id` = `m2s`.`manufacturer_id` AND `m2s`.`store_id` = '0' INNER JOIN `oc_product` AS `p` ON `p`.`manufacturer_id` = `m`.`manufacturer_id` INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 1 WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND ((LCASE(`pd`.`name`) LIKE '%арбуз%') OR LCASE(`p`.`model`) = 'арбуз' OR LCASE(`p`.`sku`) = 'арбуз' OR LCASE(`p`.`upc`) = 'арбуз' OR LCASE(`p`.`ean`) = 'арбуз' OR LCASE(`p`.`jan`) = 'арбуз' OR LCASE(`p`.`isbn`) = 'арбуз' OR LCASE(`p`.`mpn`) = 'арбуз' OR LCASE(`pd`.`tag`) LIKE '%арбуз%') GROUP BY `m`.`manufacturer_id` ORDER BY `m`.`sort_order` ASC, `m`.`name` ASC ModelModuleMegaFilter -> getAttributes ModelModuleMegaFilter -> getManufacturers ---------------------- Страница: /index.php?route=product/search&search=%D0%B0%D1%80%D0%B1%D1%83%D0%B7&description= Источник:/var/www/u0302539/data/www/xxxxxxx.ru/catalog/model/module/mega_filter.php Время: 0.254399 c Время (общее): : 5.024614 c Номер запроса: : 511 SELECT `ean` AS `field` FROM `oc_product` AS `p` INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 1 WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND ((LCASE(`pd`.`name`) LIKE '%арбуз%') OR LCASE(`p`.`model`) = 'арбуз' OR LCASE(`p`.`sku`) = 'арбуз' OR LCASE(`p`.`upc`) = 'арбуз' OR LCASE(`p`.`ean`) = 'арбуз' OR LCASE(`p`.`jan`) = 'арбуз' OR LCASE(`p`.`isbn`) = 'арбуз' OR LCASE(`p`.`mpn`) = 'арбуз' OR LCASE(`pd`.`tag`) LIKE '%арбуз%') GROUP BY `field` ORDER BY `field` ASC ModelModuleMegaFilter -> getAttributes ModelModuleMegaFilter -> getOptionsByType ---------------------- Страница: /index.php?route=product/search&search=%D0%B0%D1%80%D0%B1%D1%83%D0%B7&description= Источник:/var/www/u0302539/data/www/xxxxxx.ru/system/library/mfilter_core.php Время: 0.289366 c Время (общее): : 5.314939 c Номер запроса: : 512 SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT `price_tmp` AS `price` FROM( SELECT IFNULL( ( SELECT `price` FROM `oc_product_special` AS `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 ), IFNULL( ( SELECT `price` FROM `oc_product_discount` AS `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 ), `p`.`price` ) ) AS `price_tmp` FROM `oc_product` AS `p` INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 1 INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND ((LCASE(`pd`.`name`) LIKE '%арбуз%') OR LCASE(`p`.`model`) = 'арбуз' OR LCASE(`p`.`sku`) = 'арбуз' OR LCASE(`p`.`upc`) = 'арбуз' OR LCASE(`p`.`ean`) = 'арбуз' OR LCASE(`p`.`jan`) = 'арбуз' OR LCASE(`p`.`isbn`) = 'арбуз' OR LCASE(`p`.`mpn`) = 'арбуз' OR LCASE(`pd`.`tag`) LIKE '%арбуз%') ) AS `tmp` ) AS `tmp` MegaFilterModule -> render MegaFilterCore -> getMinMaxPrice ---------------------- Страница: /index.php?route=product/search&search=%D0%B0%D1%80%D0%B1%D1%83%D0%B7&description= Источник:/var/www/u0302539/data/www/xxxxxxxxx.ru/system/library/mfilter_core.php Время: 0.289634 c Время (общее): : 5.604996 c Номер запроса: : 513 SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT `price_tmp` AS `price` FROM( SELECT IFNULL( ( SELECT `price` FROM `oc_product_special` AS `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 ), IFNULL( ( SELECT `price` FROM `oc_product_discount` AS `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 ), `p`.`price` ) ) AS `price_tmp` FROM `oc_product` AS `p` INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 1 INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND ((LCASE(`pd`.`name`) LIKE '%арбуз%') OR LCASE(`p`.`model`) = 'арбуз' OR LCASE(`p`.`sku`) = 'арбуз' OR LCASE(`p`.`upc`) = 'арбуз' OR LCASE(`p`.`ean`) = 'арбуз' OR LCASE(`p`.`jan`) = 'арбуз' OR LCASE(`p`.`isbn`) = 'арбуз' OR LCASE(`p`.`mpn`) = 'арбуз' OR LCASE(`pd`.`tag`) LIKE '%арбуз%') ) AS `tmp` ) AS `tmp` MegaFilterCore -> getMinMaxPrice MegaFilterCore -> getMinMaxPrice ---------------------- Страница: /index.php?route=product/search&search=%D0%B0%D1%80%D0%B1%D1%83%D0%B7&description= Источник:/var/www/u0302539/data/www/xxxxxxx.ru/system/storage/modification/catalog/model/catalog/product.php Время: 0.288331 c Время (общее): : 5.895199 c Номер запроса: : 515 SELECT cd.name, c.parent_id, cp.*, COUNT(cp.path_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_category c ON (cp.path_id = c.category_id) LEFT JOIN oc_category_description cd ON (cp.path_id = cd.category_id ) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) 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) WHERE pd.language_id = '1' AND cd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( pd.name LIKE '%арбуз%' OR pd.tag LIKE '%арбуз%' OR LCASE(p.model) LIKE '%арбуз%') GROUP BY cp.path_id ORDER BY cp.level, cd.name ControllerModuleSearchCategories -> index ModelCatalogProduct -> getCategoriesTree ----------------------

вы случайно слеш не ставили в начале?