Count: 90
Class->method | Time (mcsec) |
ControllerEventTheme -> index | 9.5367431640625E-7 |
ControllerEventTheme -> index | 8.1062316894531E-6 |
ControllerEventLanguage -> index | 6.7949295043945E-5 |
ControllerEventLanguage -> index | 6.6995620727539E-5 |
ControllerEventLanguage -> index | 5.8174133300781E-5 |
ControllerEventLanguage -> index | 5.793571472168E-5 |
ControllerEventLanguage -> index | 5.7220458984375E-5 |
ControllerEventLanguage -> index | 5.6982040405273E-5 |
ControllerEventLanguage -> index | 5.6028366088867E-5 |
ControllerEventLanguage -> index | 5.5074691772461E-5 |
ControllerEventLanguage -> index | 5.3167343139648E-5 |
ControllerEventLanguage -> index | 5.2928924560547E-5 |
ControllerEventLanguage -> index | 5.0067901611328E-5 |
ControllerEventLanguage -> index | 4.3869018554688E-5 |
ControllerEventLanguage -> index | 4.1961669921875E-5 |
ControllerEventDebug -> after | 4.0531158447266E-6 |
ControllerEventDebug -> after | 3.0994415283203E-6 |
ControllerEventLanguage -> before | 3.0040740966797E-5 |
ControllerEventLanguage -> before | 2.9087066650391E-5 |
ControllerEventTheme -> index | 2.8610229492188E-6 |
ControllerEventTheme -> index | 2.1457672119141E-6 |
ControllerEventDebug -> after | 2.0027160644531E-5 |
ControllerEventTheme -> index | 1.9073486328125E-6 |
ControllerEventLanguage -> before | 1.8835067749023E-5 |
ControllerEventLanguage -> before | 1.8119812011719E-5 |
ControllerStartupError -> index | 1.7881393432617E-5 |
ControllerEventLanguage -> before | 1.6927719116211E-5 |
ControllerEventLanguage -> before | 1.5974044799805E-5 |
ControllerEventLanguage -> before | 1.5020370483398E-5 |
ControllerEventLanguage -> before | 1.3828277587891E-5 |
ControllerEventLanguage -> before | 1.3113021850586E-5 |
ControllerEventLanguage -> before | 1.2874603271484E-5 |
ControllerEventLanguage -> before | 1.1920928955078E-5 |
ControllerEventLanguage -> before | 1.0967254638672E-5 |
ControllerEventLanguage -> before | 1.0013580322266E-5 |
ControllerStartupRouter -> index | 0.38190793991089 |
ControllerProductCategory -> index | 0.38043904304504 |
ControllerCommonHeader -> index | 0.085927963256836 |
ControllerCommonMenu -> index | 0.033077955245972 |
ControllerCommonColumnLeft -> index | 0.021070003509521 |
ControllerExtensionModuleCategory -> index | 0.017874002456665 |
ControllerBlogMenu -> index | 0.0083098411560059 |
ControllerCommonCurrency -> index | 0.0081551074981689 |
ControllerCommonCart -> index | 0.0079119205474854 |
ControllerCommonFooter -> index | 0.0076329708099365 |
ControllerStartupStartup -> index | 0.0074129104614258 |
ControllerEventTheme -> override | 0.0061249732971191 |
ControllerCommonLanguage -> index | 0.0051209926605225 |
ControllerOCTemplatesModuleOctMegamenu -> mobileSideBar | 0.0040140151977539 |
ControllerCommonHeader -> octBreadcrumbs | 0.0039639472961426 |
ControllerEventTheme -> override | 0.0026659965515137 |
ControllerCommonCurrency -> index | 0.0025930404663086 |
ControllerCommonSearch -> index | 0.0025670528411865 |
ControllerCommonContentTop -> index | 0.0024290084838867 |
ControllerCommonColumnRight -> index | 0.0022628307342529 |
ControllerCommonContentBottom -> index | 0.0022339820861816 |
ControllerEventTheme -> override | 0.00078797340393066 |
ControllerStartupEvent -> index | 0.00065302848815918 |
ControllerEventTranslation -> index | 0.00043392181396484 |
ControllerEventTranslation -> index | 0.00042200088500977 |
ControllerEventTheme -> override | 0.00040197372436523 |
ControllerEventTranslation -> index | 0.00038385391235352 |
ControllerEventTranslation -> index | 0.00033807754516602 |
ControllerEventTheme -> override | 0.0003209114074707 |
ControllerEventTheme -> override | 0.0003049373626709 |
ControllerEventTranslation -> index | 0.00028014183044434 |
ControllerEventTranslation -> index | 0.00027704238891602 |
ControllerEventTranslation -> index | 0.0002751350402832 |
ControllerStartupSeoUrl -> index | 0.0002748966217041 |
ControllerEventTranslation -> index | 0.00026416778564453 |
ControllerEventTranslation -> index | 0.00026297569274902 |
ControllerEventTranslation -> index | 0.00025796890258789 |
ControllerEventTheme -> override | 0.00024986267089844 |
ControllerEventTranslation -> index | 0.00024890899658203 |
ControllerEventTranslation -> index | 0.00024604797363281 |
ControllerEventTheme -> override | 0.00024509429931641 |
ControllerEventTranslation -> index | 0.0002439022064209 |
ControllerEventTheme -> override | 0.00023984909057617 |
ControllerEventTheme -> override | 0.00023818016052246 |
ControllerEventTranslation -> index | 0.00023508071899414 |
ControllerEventTheme -> override | 0.0002281665802002 |
ControllerEventTheme -> override | 0.00022792816162109 |
ControllerEventTheme -> override | 0.00022101402282715 |
ControllerEventTheme -> override | 0.00021910667419434 |
ControllerEventTheme -> override | 0.00021195411682129 |
ControllerEventTheme -> override | 0.00020098686218262 |
ControllerEventTheme -> override | 0.00019502639770508 |
ControllerStartupSession -> index | 0.00015616416931152 |
ControllerEventLanguage -> index | 0.00011396408081055 |
ControllerEventLanguage -> index | 0.00011205673217773 |
Count: 130
File / Class->method | Time (mcsec) | Query |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
9.918212890625E-5 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/layout.php ModelDesignLayout->getLayout |
9.7990036010742E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/cart/cart.php Cart\Cart->getProducts |
9.608268737793E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '90668617f67d3cb00ac1036111' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/layout.php ModelDesignLayout->getLayout |
9.5129013061523E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
9.4890594482422E-5 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
9.3936920166016E-5 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
9.1075897216797E-5 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/setting/extension.php ModelSettingExtension->getExtensions |
9.0837478637695E-5 | SELECT * FROM oc_extension WHERE `type` = 'analytics' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
9.0122222900391E-5 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/layout.php ModelDesignLayout->getLayoutModules |
8.8930130004883E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/translation.php ModelDesignTranslation->getTranslations |
8.7976455688477E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru') |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/translation.php ModelDesignTranslation->getTranslations |
8.702278137207E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru') |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/cart/cart.php Cart\Cart->getProducts |
8.6069107055664E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '90668617f67d3cb00ac1036111' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
8.5115432739258E-5 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/storage/modification/catalog/controller/common/cart.php Cart\Cart->getProducts |
8.392333984375E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '90668617f67d3cb00ac1036111' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
8.3208084106445E-5 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/translation.php ModelDesignTranslation->getTranslations |
8.2969665527344E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru') |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
8.2015991210938E-5 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/layout.php ModelDesignLayout->getLayout |
8.1062316894531E-5 | SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
8.082389831543E-5 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
8.0108642578125E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/menu' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/layout.php ModelDesignLayout->getLayoutModules |
7.9870223999023E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
7.9154968261719E-5 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/translation.php ModelDesignTranslation->getTranslations |
7.7009201049805E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru') |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/cart/cart.php Cart\Cart->getProducts |
7.5101852416992E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '90668617f67d3cb00ac1036111' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/translation.php ModelDesignTranslation->getTranslations |
7.4863433837891E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru') |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
7.319450378418E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/currency' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/cart/cart.php Cart\Cart->getProducts |
7.2002410888672E-5 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '90668617f67d3cb00ac1036111' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/layout.php ModelDesignLayout->getLayoutModules |
7.1048736572266E-5 | SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/translation.php ModelDesignTranslation->getTranslations |
7.0810317993164E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru') |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/translation.php ModelDesignTranslation->getTranslations |
7.0095062255859E-5 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru') |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
6.9141387939453E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'extension/module/category' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/category.php ModelCatalogCategory->getCategoryLayoutId |
6.8902969360352E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '444' AND store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/category.php ModelCatalogCategory->getCategoryLayoutId |
6.7949295043945E-5 | SELECT * FROM oc_category_to_layout WHERE category_id = '444' AND store_id = '0' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/setting/extension.php ModelSettingExtension->getExtensions |
6.6995620727539E-5 | SELECT * FROM oc_extension WHERE `type` = 'total' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
6.4849853515625E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'octemplates/menu/oct_sidebar_mobile' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
6.413459777832E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/content_bottom' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
5.9127807617188E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/search' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
5.8174133300781E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/footer' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
5.6982040405273E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/cart' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
5.4836273193359E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/language' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
5.2928924560547E-5 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/content_top' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/extension/total/credit.php Cart\Customer->getBalance |
4.9114227294922E-5 | SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProducts |
0.010774850845337 | 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_to_category p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '444' GROUP BY p.product_id ORDER BY p.quantity > 0 DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 1008,24 |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getTotalProducts |
0.0084221363067627 | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '444' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0078079700469971 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '455178' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0076949596405029 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '458773' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0072798728942871 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '457788' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0069839954376221 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '456684' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0069308280944824 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '461019' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0068809986114502 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '459016' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.006680965423584 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '455057' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0062580108642578 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '457816' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0062088966369629 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '458863' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0061450004577637 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '461046' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0059390068054199 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '458862' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0059330463409424 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '455087' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
0.0058798789978027 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'product/category' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0058290958404541 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '458781' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0058088302612305 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '461048' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0057311058044434 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '461049' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0057220458984375 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '457815' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0056960582733154 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '461051' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0055320262908936 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '459184' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0055220127105713 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '462005' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0055050849914551 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '460975' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0054728984832764 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '458779' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0054459571838379 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '458771' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct |
0.0053348541259766 | SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (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 points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order 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) WHERE p.product_id = '462143' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.0024571418762207 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
0.0023219585418701 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/header' |
/var/www/www-root/data/www/storage/modification/catalog/controller/startup/startup.php ControllerStartupStartup->index |
0.0012540817260742 | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
0.00058698654174805 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/currency' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/blog/category.php ModelBlogCategory->getCategories |
0.00054597854614258 | SELECT * FROM oc_blog_category c LEFT JOIN oc_blog_category_description cd ON (c.blog_category_id = cd.blog_category_id) LEFT JOIN oc_blog_category_to_store c2s ON (c.blog_category_id = c2s.blog_category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/catalog/information.php ModelCatalogInformation->getInformations |
0.00039887428283691 | 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' ORDER BY i.sort_order, LCASE(id.title) ASC |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/translation.php ModelDesignTranslation->getTranslations |
0.00024795532226562 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru') |
/var/www/www-root/data/www/storage/modification/catalog/controller/startup/startup.php Cart\Tax->setShippingAddress |
0.00024318695068359 | SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
0.00023293495178223 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'octemplates/module/oct_breadcrumbs' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/blog/article.php ModelBlogArticle->getTotalArticles |
0.00023198127746582 | SELECT COUNT(DISTINCT p.article_id) AS total FROM oc_article p LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id) LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id) LEFT JOIN oc_article_to_blog_category a2c ON (p.article_id = a2c.article_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND a2c.blog_category_id = '71' |
/var/www/www-root/data/www/storage/modification/catalog/controller/startup/seo_url.php ControllerStartupSeoUrl->index |
0.00021195411682129 | SELECT * FROM oc_seo_url WHERE keyword = 'adapters' AND store_id = '0' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00020098686218262 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/session.php Session\DB->read |
0.00018906593322754 | SELECT `data` FROM `oc_session` WHERE session_id = '90668617f67d3cb00ac1036111' AND expire > 1746477090 |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/blog/article.php ModelBlogArticle->getTotalArticles |
0.00018811225891113 | SELECT COUNT(DISTINCT p.article_id) AS total FROM oc_article p LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id) LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id) LEFT JOIN oc_article_to_blog_category a2c ON (p.article_id = a2c.article_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND a2c.blog_category_id = '69' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00018000602722168 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00017714500427246 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=456684' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00017595291137695 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/blog/article.php ModelBlogArticle->getTotalArticles |
0.0001680850982666 | SELECT COUNT(DISTINCT p.article_id) AS total FROM oc_article p LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id) LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id) LEFT JOIN oc_article_to_blog_category a2c ON (p.article_id = a2c.article_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND a2c.blog_category_id = '70' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00016593933105469 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=458779' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/storage/modification/catalog/model/catalog/category.php ModelCatalogCategory->getCategory |
0.00016403198242188 | SELECT DISTINCT * 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.category_id = '444' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00016283988952637 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=457816' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00015401840209961 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=455087' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.0001518726348877 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=458771' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00015020370483398 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=461051' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/setting/event.php ModelSettingEvent->getEvents |
0.00014996528625488 | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00014710426330566 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=459016' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00014591217041016 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=461049' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/theme.php ModelDesignTheme->getTheme |
0.00014090538024902 | SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'oct_feelmart' AND route = 'common/column_left' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/translation.php ModelDesignTranslation->getTranslations |
0.00013899803161621 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru') |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.0001380443572998 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=462143' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.0001370906829834 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00013589859008789 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=458863' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00013399124145508 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00013303756713867 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00012993812561035 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00012898445129395 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=460975' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00012803077697754 | SELECT * FROM oc_seo_url WHERE `query` = 'information_id=4' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00012707710266113 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=459184' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00012683868408203 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=457788' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00012493133544922 | SELECT * FROM oc_seo_url WHERE `query` = 'information_id=5' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00012397766113281 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00012302398681641 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=457815' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.0001220703125 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=462005' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.0001218318939209 | SELECT * FROM oc_seo_url WHERE `query` = 'information_id=3' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00012111663818359 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00011992454528809 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=458781' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/catalog/model/design/translation.php ModelDesignTranslation->getTranslations |
0.00011897087097168 | SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru') |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00011801719665527 | SELECT * FROM oc_seo_url WHERE `query` = 'information_id=6' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/cart/cart.php Cart\Cart->getProducts |
0.00011706352233887 | SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '90668617f67d3cb00ac1036111' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00011587142944336 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=455086' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00011491775512695 | SELECT * FROM oc_seo_url WHERE `query` = 'product_id=461048' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/storage/modification/catalog/controller/startup/startup.php Cart\Length->__construct |
0.00011301040649414 | 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' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00011110305786133 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00011014938354492 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00010585784912109 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00010514259338379 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/session.php Session\DB->read |
0.00010490417480469 | SELECT `data` FROM `oc_session` WHERE session_id = '90668617f67d3cb00ac1036111' AND expire > 1746477090 |
/var/www/www-root/data/www/storage/modification/catalog/controller/startup/startup.php Cart\Cart->__construct |
0.00010395050048828 | DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR) |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/openbay.php Openbay->getInstalled |
0.00010299682617188 | SELECT * FROM oc_extension WHERE `type` = 'openbay' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00010108947753906 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
/var/www/www-root/data/www/dveri.kugoo-shop.online/system/library/url.php ControllerStartupSeoUrl->rewrite |
0.00010085105895996 | SELECT * FROM oc_seo_url WHERE `query` = 'category_id=444' AND store_id = '0' AND language_id = '1' |
Key | Value |
_route_ | adapters |
page | 43 |
Empty
Key | Value |
REDIRECT_HTTPS | on |
REDIRECT_UNIQUE_ID | aBkgIhAPx9Ltgmc80kywwQAAAAE |
REDIRECT_PERL5LIB | /usr/share/awstats/lib:/usr/share/awstats/plugins |
REDIRECT_STATUS | 200 |
HTTPS | 1 |
UNIQUE_ID | aBkgIhAPx9Ltgmc80kywwQAAAAE |
PERL5LIB | /usr/share/awstats/lib:/usr/share/awstats/plugins |
HTTP_HOST | tgsys.ru |
HTTP_X_FORWARDED_PROTO | https |
HTTP_X_FORWARDED_PORT | 443 |
HTTP_CONNECTION | close |
HTTP_ACCEPT | */* |
HTTP_USER_AGENT | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
HTTP_ACCEPT_ENCODING | gzip, br, zstd, deflate |
HTTP_COOKIE | language=ru-ru; OCSESSID=90668617f67d3cb00ac1036111; currency=USD |
PATH | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin |
SERVER_SIGNATURE | |
SERVER_SOFTWARE | Apache/2.4.6 (CentOS) mpm-itk/2.4.7-04 OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/5.4.16 |
SERVER_NAME | tgsys.ru |
SERVER_ADDR | 127.0.0.1 |
SERVER_PORT | 80 |
REMOTE_ADDR | 3.137.222.1 |
DOCUMENT_ROOT | /var/www/www-root/data/www/dveri.kugoo-shop.online |
REQUEST_SCHEME | http |
CONTEXT_PREFIX | |
CONTEXT_DOCUMENT_ROOT | /var/www/www-root/data/www/dveri.kugoo-shop.online |
SERVER_ADMIN | 89671000964@ya.ru |
SCRIPT_FILENAME | /var/www/www-root/data/www/dveri.kugoo-shop.online/index.php |
REMOTE_PORT | 40278 |
REDIRECT_QUERY_STRING | _route_=adapters&page=43 |
REDIRECT_URL | /adapters |
GATEWAY_INTERFACE | CGI/1.1 |
SERVER_PROTOCOL | HTTP/1.0 |
REQUEST_METHOD | GET |
QUERY_STRING | _route_=adapters&page=43 |
REQUEST_URI | /adapters?page=43 |
SCRIPT_NAME | /index.php |
PHP_SELF | /index.php |
REQUEST_TIME_FLOAT | 1746477090.692 |
REQUEST_TIME | 1746477090 |
Key | Value |
language | ru-ru |
OCSESSID | 90668617f67d3cb00ac1036111 |
currency | USD |