РТИ

Сорт:

Показывать:

Шланг тормозной Лачетти зад прав CRB

Днепр - В наличии
Харьков - Отсутствует

Производитель: CRB

Код товара: 13114-C1014

Кат. номер: 13114144; 13114-C1014

Ориг. номер: 96,387,196

Внутр. код: MD-00021212

В наличии

Кол-во:

Уплотнитель стекла двери Лачетти (молдинг) (седан) зад лев GM

Днепр - В наличии
Харьков - Отсутствует

Производитель: GENERAL MOTORS

Код товара: 95979257

Кат. номер: 95979257

Ориг. номер: 95979257

Внутр. код: MD-00059575

В наличии

Кол-во:

Стойка стабилизатора Ланос /Сенс/Нексия (в сборе) (АМ-90009367) АМТ

Днепр - В наличии
Харьков - Отсутствует

Производитель: АМТ

Код товара: АМ-90009367

Кат. номер: 90009367

Внутр. код: MD-00043225

В наличии

Кол-во:

Сальник Ланос /Авео/Лачетти КПП вала первичного (23х35х8) CRB

Днепр - В наличии
Харьков - Отсутствует

Производитель: CRB

Код товара: 13099-D4011

Кат. номер: 13099210; 13099-D4011

Ориг. номер: 90182168; 25189395

Внутр. код: MD-00028634

В наличии

Кол-во:

Сальник 412 КПП вала первичного (30х50х9,5) (NBR) черный КременчугРезиноТехника

Днепр - В наличии
Харьков - Отсутствует

Производитель: КременчугРезиноТехника

Код товара: KRT-404

Кат. номер: 412-1701033

Внутр. код: MD-00020107

В наличии

Кол-во:

Сальник 2101-08/1102 клапанов (FPM) черный (к-т 8шт) КременчугРезиноТехника

Днепр - В наличии
Харьков - Отсутствует

Производитель: КременчугРезиноТехника

Код товара: KRT-1К-Ф

Кат. номер: 2101-1007026

Внутр. код: MD-00016845

В наличии

Кол-во:

Сальник 2101 ступицы (40х57,15х10) (NBR) черный КременчугРезиноТехника

Днепр - В наличии
Харьков - Отсутствует

Производитель: КременчугРезиноТехника

Код товара: KRT-7

Кат. номер: 2101-3103038

Внутр. код: MD-00020118

В наличии

Кол-во:

Сальник 1102 /Сенс ДВС (FPM) красный (к-т 3шт) КременчугРезиноТехника

Днепр - В наличии
Харьков - Отсутствует

Производитель: КременчугРезиноТехника

Код товара: KRT-103К-Ф1

Внутр. код: MD-00004003

В наличии

Кол-во:

Сайлентблок 1102 заднего амортизатора (к-т 2шт) ЗАЗ Деталь

Днепр - Отсутствует
Харьков - В наличии

Производитель: ЗАЗ Деталь

Код товара: 1102-2915580

Внутр. код: MD-00051418

В наличии

Кол-во:

Сайлентблок 1102 балки задн (к-т 2шт) ЗАЗ Деталь

Днепр - В наличии
Харьков - Отсутствует

Производитель: ЗАЗ Деталь

Код товара: 1102-2914084

Кат. номер: 1102-2914084

Внутр. код: MD-00003701

В наличии

Кол-во:

Ремкомплект суппорта Авео (2 колеса) (4 направл+4 пыльника) CRB

Днепр - В наличии
Харьков - Отсутствует

Производитель: CRB

Код товара: 13094-B4021

Кат. номер: 13094003; 13094-B4021

Ориг. номер: 93742635

Внутр. код: MD-00043992

В наличии

Кол-во:

Ремкомплект карбюратора 421 (К-151Т) ЧАЗ

Днепр - В наличии
Харьков - Отсутствует

Производитель: ЧАЗ

Код товара: 00-00000726

Внутр. код: MD-00053821

В наличии

Кол-во:

Ремкомплект карбюратора 3110 (ЛЮКС) ДААЗ

Днепр - В наличии
Харьков - Отсутствует

Производитель: ДААЗ

Код товара: 00-00000716

Внутр. код: MD-00044475

В наличии

Кол-во:

Ремкомплект карбюратора 2108 ЧАЗ

Днепр - В наличии
Харьков - Отсутствует

Производитель: ЧАЗ

Код товара: 00-00000746

Кат. номер: 2108-1107991

Внутр. код: MD-00043858

В наличии

Кол-во:

Ремкомплект карбюратора 2107 ЧАЗ

Днепр - В наличии
Харьков - Отсутствует

Производитель: ЧАЗ

Код товара: 00-00000735

Кат. номер: 2107-1107980

Внутр. код: MD-00043855

В наличии

Кол-во:

Class->method	Time (mcsec)
ControllerEventCompatibility -> language	9.9897384643555E-5
ControllerEventTheme -> index	9.8943710327148E-5
ControllerEventTheme -> index	9.7990036010742E-5
ControllerEventCompatibility -> language	9.7036361694336E-5
ControllerEventCompatibility -> language	9.6797943115234E-5
ControllerEventTheme -> index	9.608268737793E-5
ControllerEventCompatibility -> beforeModel	9.5844268798828E-5
ControllerEventCompatibility -> language	9.4175338745117E-5
ControllerEventCompatibility -> language	9.3936920166016E-5
ControllerEventCompatibility -> beforeModel	9.2029571533203E-5
ControllerEventCompatibility -> language	9.1075897216797E-5
ControllerEventCompatibility -> language	9.0122222900391E-5
ControllerEventCompatibility -> language	8.9883804321289E-5
ControllerEventCompatibility -> language	8.9168548583984E-5
ControllerEventCompatibility -> language	8.8930130004883E-5
ControllerEventCompatibility -> language	8.8214874267578E-5
ControllerEventCompatibility -> language	8.702278137207E-5
ControllerEventCompatibility -> beforeModel	8.6069107055664E-5
ControllerEventCompatibility -> beforeModel	8.0108642578125E-5
ControllerEventCompatibility -> beforeModel	7.9870223999023E-5
ControllerEventCompatibility -> beforeModel	7.8916549682617E-5
ControllerEventCompatibility -> beforeModel	7.7962875366211E-5
ControllerEventCompatibility -> beforeModel	7.6055526733398E-5
ControllerStartupMaintenance -> index	5.9604644775391E-6
ControllerStartupSeoUrl -> index	1.3828277587891E-5
ControllerStartupRouter -> index	1.1017870903015
ControllerProductCategory -> index	1.1012759208679
ControllerCommonHeader -> index	0.046014070510864
ControllerCommonColumnLeft -> index	0.023270130157471
ControllerStartupStartup -> index	0.021535873413086
ControllerExtensionModuleCategory -> index	0.013722896575928
ControllerCommonFooter -> index	0.0087311267852783
ControllerCommonCart -> index	0.0067031383514404
ControllerCommonColumnRight -> index	0.0051150321960449
ControllerCommonCurrency -> index	0.0042998790740967
ControllerCommonContentTop -> index	0.0035440921783447
ControllerExtensionModuleBanner -> index	0.0027389526367188
ControllerCommonLanguage -> index	0.0027079582214355
ControllerCommonSearch -> index	0.0026199817657471
ControllerCommonContentBottom -> index	0.0022768974304199
ControllerStartupEvent -> index	0.001255989074707
ControllerEventCompatibility -> beforeModel	0.00020813941955566
ControllerEventCompatibility -> beforeModel	0.00017809867858887
ControllerEventCompatibility -> beforeModel	0.00017094612121582
ControllerEventCompatibility -> beforeModel	0.00016593933105469
ControllerEventCompatibility -> beforeModel	0.00016498565673828
ControllerEventCompatibility -> beforeModel	0.00016307830810547
ControllerEventCompatibility -> beforeModel	0.00016188621520996
ControllerEventCompatibility -> beforeModel	0.00015902519226074
ControllerEventCompatibility -> beforeModel	0.00015711784362793
ControllerEventCompatibility -> beforeModel	0.00015687942504883
ControllerEventTheme -> index	0.00015592575073242
ControllerEventCompatibility -> beforeModel	0.00015401840209961
ControllerEventCompatibility -> beforeModel	0.0001530647277832
ControllerEventCompatibility -> beforeModel	0.0001518726348877
ControllerEventCompatibility -> beforeModel	0.00015091896057129
ControllerEventTheme -> index	0.00011801719665527
ControllerEventCompatibility -> language	0.00011706352233887
ControllerEventTheme -> index	0.00011301040649414
ControllerEventTheme -> index	0.00011181831359863
ControllerEventTheme -> index	0.00011110305786133
ControllerEventTheme -> index	0.00011014938354492
ControllerEventCompatibility -> language	0.00010800361633301
ControllerEventCompatibility -> language	0.0001070499420166
ControllerEventTheme -> index	0.00010585784912109
ControllerEventCompatibility -> language	0.00010490417480469
ControllerEventTheme -> index	0.00010299682617188
ControllerEventCompatibility -> beforeModel	0.00010180473327637
ControllerEventCompatibility -> language	0.00010013580322266

Class->method

Time (mcsec)

ControllerEventCompatibility -> language

9.9897384643555E-5

ControllerEventTheme -> index

9.8943710327148E-5

ControllerEventTheme -> index

9.7990036010742E-5

ControllerEventCompatibility -> language

9.7036361694336E-5

ControllerEventCompatibility -> language

9.6797943115234E-5

ControllerEventTheme -> index

9.608268737793E-5

ControllerEventCompatibility -> beforeModel

9.5844268798828E-5

ControllerEventCompatibility -> language

9.4175338745117E-5

ControllerEventCompatibility -> language

9.3936920166016E-5

ControllerEventCompatibility -> beforeModel

9.2029571533203E-5

ControllerEventCompatibility -> language

9.1075897216797E-5

ControllerEventCompatibility -> language

9.0122222900391E-5

ControllerEventCompatibility -> language

8.9883804321289E-5

ControllerEventCompatibility -> language

8.9168548583984E-5

ControllerEventCompatibility -> language

8.8930130004883E-5

ControllerEventCompatibility -> language

8.8214874267578E-5

ControllerEventCompatibility -> language

8.702278137207E-5

ControllerEventCompatibility -> beforeModel

8.6069107055664E-5

ControllerEventCompatibility -> beforeModel

8.0108642578125E-5

ControllerEventCompatibility -> beforeModel

7.9870223999023E-5

ControllerEventCompatibility -> beforeModel

7.8916549682617E-5

ControllerEventCompatibility -> beforeModel

7.7962875366211E-5

ControllerEventCompatibility -> beforeModel

7.6055526733398E-5

ControllerStartupMaintenance -> index

5.9604644775391E-6

ControllerStartupSeoUrl -> index

1.3828277587891E-5

ControllerStartupRouter -> index

1.1017870903015

ControllerProductCategory -> index

1.1012759208679

ControllerCommonHeader -> index

0.046014070510864

ControllerCommonColumnLeft -> index

0.023270130157471

ControllerStartupStartup -> index

0.021535873413086

ControllerExtensionModuleCategory -> index

0.013722896575928

ControllerCommonFooter -> index

0.0087311267852783

ControllerCommonCart -> index

0.0067031383514404

ControllerCommonColumnRight -> index

0.0051150321960449

ControllerCommonCurrency -> index

0.0042998790740967

ControllerCommonContentTop -> index

0.0035440921783447

ControllerExtensionModuleBanner -> index

0.0027389526367188

ControllerCommonLanguage -> index

0.0027079582214355

ControllerCommonSearch -> index

0.0026199817657471

ControllerCommonContentBottom -> index

0.0022768974304199

ControllerStartupEvent -> index

0.001255989074707

ControllerEventCompatibility -> beforeModel

0.00020813941955566

ControllerEventCompatibility -> beforeModel

0.00017809867858887

ControllerEventCompatibility -> beforeModel

0.00017094612121582

ControllerEventCompatibility -> beforeModel

0.00016593933105469

ControllerEventCompatibility -> beforeModel

0.00016498565673828

ControllerEventCompatibility -> beforeModel

0.00016307830810547

ControllerEventCompatibility -> beforeModel

0.00016188621520996

ControllerEventCompatibility -> beforeModel

0.00015902519226074

ControllerEventCompatibility -> beforeModel

0.00015711784362793

ControllerEventCompatibility -> beforeModel

0.00015687942504883

ControllerEventTheme -> index

0.00015592575073242

ControllerEventCompatibility -> beforeModel

0.00015401840209961

ControllerEventCompatibility -> beforeModel

0.0001530647277832

ControllerEventCompatibility -> beforeModel

0.0001518726348877

ControllerEventCompatibility -> beforeModel

0.00015091896057129

ControllerEventTheme -> index

0.00011801719665527

ControllerEventCompatibility -> language

0.00011706352233887

ControllerEventTheme -> index

0.00011301040649414

ControllerEventTheme -> index

0.00011181831359863

ControllerEventTheme -> index

0.00011110305786133

ControllerEventTheme -> index

0.00011014938354492

ControllerEventCompatibility -> language

0.00010800361633301

ControllerEventCompatibility -> language

0.0001070499420166

ControllerEventTheme -> index

0.00010585784912109

ControllerEventCompatibility -> language

0.00010490417480469

ControllerEventTheme -> index

0.00010299682617188

ControllerEventCompatibility -> beforeModel

0.00010180473327637

ControllerEventCompatibility -> language

0.00010013580322266

File / Class->method	Time (mcsec)	Query
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProducts	0.20461392402649	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_manufacturer m ON (m.manufacturer_id = p.manufacturer_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 = '71' GROUP BY p.product_id ORDER BY (p.quantity>0) DESC,p.quantity ASC, LCASE(pd.name) DESC LIMIT 0,15
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.062754154205322	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 38119
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.059713125228882	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34215
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.057316064834595	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34211
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getTotalProducts	0.056066989898682	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 = '71'
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.055749893188477	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34224
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.044312953948975	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 38133
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.039082050323486	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34370
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.035351991653442	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34818
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.034376859664917	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 35727
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.033623933792114	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 37452
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.032965183258057	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34820
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.032219886779785	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 38162
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.031979084014893	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 38088
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.031784057617188	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 35122
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.031502962112427	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34234
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getProductMultistores	0.029942989349365	SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 36492
/var/www/za.kh.ua/catalog/controller/startup/startup.php ControllerStartupStartup->index	0.007990837097168	SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.0069420337677002	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.0062658786773682	SELECT * FROM oc_url_alias WHERE `query` = 'product_id=34224'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.0056440830230713	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.0056118965148926	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/controller/extension/module/category.php ControllerExtensionModuleCategory->index	0.004209041595459	SELECT image FROM `oc_category` WHERE category_id='76'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.004133939743042	SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='37452'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.0026922225952148	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=67'
/var/www/za.kh.ua/catalog/controller/startup/startup.php Cart\Cart->__construct	0.0023519992828369	DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.0023260116577148	SELECT * FROM oc_custom_menu ORDER BY position
/var/www/za.kh.ua/catalog/model/catalog/information.php ModelCatalogInformation->getInformations	0.0021569728851318	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/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.0019769668579102	SELECT image FROM `oc_category` WHERE category_id='66'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.0017659664154053	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.0017020702362061	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '71' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.0015838146209717	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '37452' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/catalog/model/design/layout.php ModelDesignLayout->getLayoutModules	0.001471996307373	SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategoryLayoutId	0.0013668537139893	SELECT * FROM oc_category_to_layout WHERE category_id = '71' AND store_id = '0'
/var/www/za.kh.ua/catalog/model/design/layout.php ModelDesignLayout->getLayoutModules	0.0012969970703125	SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.0012941360473633	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.0011360645294189	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/controller/startup/startup.php Cart\Tax->setAddress	0.0010809898376465	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 = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4224') ORDER BY tr1.priority ASC
/var/www/za.kh.ua/catalog/model/tool/online.php ModelToolOnline->addOnline	0.0010099411010742	DELETE FROM `oc_customer_online` WHERE date_added < '2021-04-12 05:27:54'
/var/www/za.kh.ua/system/library/cart/cart.php Cart\Cart->getProducts	0.00080990791320801	SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.00078415870666504	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '36492' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.0006558895111084	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '35122' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.00064396858215332	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '38162' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.0006248950958252	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '38119' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.00061988830566406	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34820' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.00061392784118652	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34818' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.00060391426086426	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '38088' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getMultistores	0.00060105323791504	SELECT * FROM `oc_multistore`
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.00059986114501953	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34224' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.00059199333190918	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34370' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategory	0.00056719779968262	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 = '71' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.0005650520324707	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34211' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.0005500316619873	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '38133' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00054788589477539	SELECT * FROM oc_url_alias WHERE `query` = 'manufacturer_id=111'
/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php ModelCatalogProduct->getProduct	0.00052809715270996	SELECT DISTINCT , pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34215' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.0005180835723877	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '71' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/design/banner.php ModelDesignBanner->getBanner	0.00047683715820312	SELECT * FROM oc_banner b LEFT JOIN oc_banner_image bi ON (b.banner_id = bi.banner_id) WHERE b.banner_id = '6' AND b.status = '1' AND bi.language_id = '1' ORDER BY bi.sort_order ASC
/var/www/za.kh.ua/catalog/controller/startup/startup.php Cart\Length->__construct	0.00046682357788086	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/za.kh.ua/catalog/controller/startup/startup.php Cart\Weight->__construct	0.00046515464782715	SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getMultistores	0.00043892860412598	SELECT * FROM `oc_multistore`
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategoryLayoutId	0.00043797492980957	SELECT * FROM oc_category_to_layout WHERE category_id = '71' AND store_id = '0'
/var/www/za.kh.ua/catalog/controller/startup/startup.php Cart\Currency->__construct	0.00041699409484863	SELECT * FROM oc_currency
/var/www/za.kh.ua/system/storage/modification/system/library/config.php	0.00040912628173828	SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type'
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00036406517028809	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '71' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/design/layout.php ModelDesignLayout->getLayout	0.00035691261291504	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00034093856811523	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/model/extension/event.php ModelExtensionEvent->getEvents	0.00033998489379883	SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00033879280090332	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '76' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00033092498779297	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00032997131347656	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '68' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00032496452331543	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00031805038452148	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '69' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00031781196594238	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '77' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00031280517578125	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '75' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00031185150146484	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '72' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00030779838562012	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.00030684471130371	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategories	0.0003058910369873	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00030398368835449	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/controller/startup/startup.php ControllerStartupStartup->index	0.00029492378234863	SELECT * FROM oc_store WHERE REPLACE(`url`, 'www.', '') = 'http://za.kh.ua/'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00028014183044434	SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='34211'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00027894973754883	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.0002751350402832	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.0002741813659668	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00026607513427734	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00026512145996094	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00025606155395508	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/controller/product/category.php Cart\Cart->getProducts	0.00025391578674316	SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'
/var/www/za.kh.ua/catalog/model/design/layout.php ModelDesignLayout->getLayoutModules	0.00025200843811035	SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00024890899658203	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00024700164794922	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00024199485778809	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00023698806762695	SELECT * FROM oc_url_alias WHERE `query` = 'information_id=4'
/var/www/za.kh.ua/system/library/cart/cart.php Cart\Cart->getProducts	0.00023603439331055	SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00023508071899414	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/controller/startup/startup.php Cart\Tax->setAddress	0.00023198127746582	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 = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4224') ORDER BY tr1.priority ASC
/var/www/za.kh.ua/catalog/model/extension/extension.php ModelExtensionExtension->getExtensions	0.00022220611572266	SELECT * FROM oc_extension WHERE `type` = 'analytics'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00021719932556152	SELECT * FROM oc_url_alias WHERE `query` = 'manufacturer_id=7'
/var/www/za.kh.ua/system/library/openbay.php Openbay->getInstalled	0.00021696090698242	SELECT * FROM oc_extension WHERE `type` = 'openbay'
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getMultistores	0.0002129077911377	SELECT * FROM `oc_multistore`
/var/www/za.kh.ua/catalog/model/extension/module.php ModelExtensionModule->getModule	0.00021195411682129	SELECT * FROM oc_module WHERE module_id = '30'
/var/www/za.kh.ua/catalog/model/design/layout.php ModelDesignLayout->getLayout	0.00020599365234375	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
/var/www/za.kh.ua/catalog/controller/common/footer.php ControllerCommonFooter->index	0.00020408630371094	SELECT * FROM oc_custom_menu ORDER BY position
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00019717216491699	SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='34820'
/var/www/za.kh.ua/catalog/model/tool/online.php ModelToolOnline->addOnline	0.00019097328186035	REPLACE INTO `oc_customer_online` SET `ip` = '3.235.41.241', `customer_id` = '0', `url` = 'http://za.kh.ua/index.php?route=product/category&path=71', `referer` = '', `date_added` = '2021-04-12 06:27:54'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00018906593322754	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00018596649169922	SELECT name FROM oc_manufacturer WHERE manufacturer_id='7'
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getMultistores	0.00018310546875	SELECT * FROM `oc_multistore`
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00017905235290527	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00017809867858887	SELECT * FROM oc_url_alias WHERE `query` = 'information_id=5'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00017499923706055	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=73'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php Cart\Cart->countProducts	0.00017404556274414	SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getMultistores	0.00017189979553223	SELECT * FROM `oc_multistore`
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00016999244689941	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=69'
/var/www/za.kh.ua/catalog/controller/common/cart.php Cart\Cart->countProducts	0.00016903877258301	SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'
/var/www/za.kh.ua/catalog/controller/common/cart.php Cart\Cart->getProducts	0.0001678466796875	SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00016593933105469	SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='34234'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00016403198242188	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00016307830810547	SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='35727'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00016188621520996	SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='34224'
/var/www/za.kh.ua/catalog/model/design/layout.php ModelDesignLayout->getLayout	0.00016117095947266	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00016093254089355	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=65'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00015902519226074	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=66'
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getMultistores	0.00015711784362793	SELECT * FROM `oc_multistore`
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00015687942504883	SELECT * FROM oc_url_alias WHERE `query` = 'information_id=3'
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getMultistores	0.00015616416931152	SELECT * FROM `oc_multistore`
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.0001518726348877	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=72'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.00015091896057129	SELECT image FROM `oc_category` WHERE category_id='73'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00014996528625488	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00014901161193848	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=76'
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getMultistores	0.00014805793762207	SELECT * FROM `oc_multistore`
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00014615058898926	SELECT name FROM oc_manufacturer WHERE manufacturer_id='197'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00014591217041016	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=75'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00014495849609375	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00014400482177734	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=65'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00014305114746094	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00014209747314453	SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='34370'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00014114379882812	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00014019012451172	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00013995170593262	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00013899803161621	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=69'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.0001380443572998	SELECT image FROM `oc_category` WHERE category_id='74'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.0001370906829834	SELECT image FROM `oc_category` WHERE category_id='67'
/var/www/za.kh.ua/catalog/model/extension/module/multistore.php ModelExtensionModuleMultistore->getMultistores	0.0001368522644043	SELECT * FROM `oc_multistore`
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00013613700866699	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=77'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00013589859008789	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00013494491577148	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=75'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00013399124145508	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=70'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.00013303756713867	SELECT image FROM `oc_category` WHERE category_id='71'
/var/www/za.kh.ua/catalog/model/design/layout.php ModelDesignLayout->getLayout	0.00013208389282227	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00013184547424316	SELECT * FROM oc_url_alias WHERE `query` = 'product_id=38133'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00013113021850586	SELECT name FROM oc_manufacturer WHERE manufacturer_id='111'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00013089179992676	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=66'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.00013017654418945	SELECT image FROM `oc_category` WHERE category_id='72'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00012993812561035	SELECT * FROM oc_url_alias WHERE `query` = 'product_id=38119'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00012898445129395	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.00012803077697754	SELECT image FROM `oc_category` WHERE category_id='76'
/var/www/za.kh.ua/catalog/controller/extension/module/category.php ControllerExtensionModuleCategory->index	0.00012707710266113	SELECT image FROM `oc_category` WHERE category_id='70'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00012683868408203	SELECT * FROM oc_url_alias WHERE `query` = 'product_id=34234'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00012612342834473	SELECT * FROM oc_url_alias WHERE `query` = 'manufacturer_id=70'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00012588500976562	SELECT name FROM oc_manufacturer WHERE manufacturer_id='97'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00012516975402832	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=73'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00012493133544922	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=68'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00012397766113281	SELECT name FROM oc_manufacturer WHERE manufacturer_id='111'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00012302398681641	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=68'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.0001220703125	SELECT image FROM `oc_category` WHERE category_id='65'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.0001218318939209	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00012016296386719	SELECT name FROM oc_manufacturer WHERE manufacturer_id='111'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00011992454528809	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00011897087097168	SELECT name FROM oc_manufacturer WHERE manufacturer_id='170'
/var/www/za.kh.ua/catalog/controller/extension/module/category.php ControllerExtensionModuleCategory->index	0.00011682510375977	SELECT image FROM `oc_category` WHERE category_id='72'
/var/www/za.kh.ua/catalog/model/catalog/category.php ModelCatalogCategory->getCategoryLayoutId	0.00011610984802246	SELECT * FROM oc_category_to_layout WHERE category_id = '71' AND store_id = '0'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00011587142944336	SELECT name FROM oc_manufacturer WHERE manufacturer_id='70'
/var/www/za.kh.ua/catalog/controller/extension/module/category.php ControllerExtensionModuleCategory->index	0.00011515617370605	SELECT image FROM `oc_category` WHERE category_id='75'
/var/www/za.kh.ua/system/library/url.php ControllerStartupSeoUrl->rewrite	0.00011491775512695	SELECT * FROM oc_url_alias WHERE `query` = 'category_id=72'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00011420249938965	SELECT name FROM oc_manufacturer WHERE manufacturer_id='298'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.00011396408081055	SELECT image FROM `oc_category` WHERE category_id='68'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.00011301040649414	SELECT image FROM `oc_category` WHERE category_id='77'
/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php ControllerCommonHeader->index	0.00011110305786133	SELECT image FROM `oc_category` WHERE category_id='75'
/var/www/za.kh.ua/catalog/controller/product/category.php ControllerProductCategory->index	0.00010991096496582	SELECT name FROM oc_manufacturer WHERE manufacturer_id='197'
/var/www/za.kh.ua/catalog/controller/extension/module/category.php ControllerExtensionModuleCategory->index	0.00010585784912109	SELECT image FROM `oc_category` WHERE category_id='68'
/var/www/za.kh.ua/catalog/controller/extension/module/category.php ControllerExtensionModuleCategory->index	0.00010418891906738	SELECT image FROM `oc_category` WHERE category_id='73'
/var/www/za.kh.ua/catalog/controller/extension/module/category.php ControllerExtensionModuleCategory->index	0.00010299682617188	SELECT image FROM `oc_category` WHERE category_id='74'

File / Class->method

Time (mcsec)

Query

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProducts

0.20461392402649

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_manufacturer m ON (m.manufacturer_id = p.manufacturer_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 = '71' GROUP BY p.product_id ORDER BY (p.quantity>0) DESC,p.quantity ASC, LCASE(pd.name) DESC LIMIT 0,15

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.062754154205322

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 38119

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.059713125228882

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34215

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.057316064834595

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34211

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getTotalProducts

0.056066989898682

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 = '71'

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.055749893188477

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34224

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.044312953948975

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 38133

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.039082050323486

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34370

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.035351991653442

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34818

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.034376859664917

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 35727

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.033623933792114

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 37452

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.032965183258057

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34820

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.032219886779785

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 38162

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.031979084014893

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 38088

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.031784057617188

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 35122

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.031502962112427

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 34234

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getProductMultistores

0.029942989349365

SELECT * FROM `oc_product_to_multistore` WHERE `product_id` = 36492

/var/www/za.kh.ua/catalog/controller/startup/startup.php
ControllerStartupStartup->index

0.007990837097168

SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.0069420337677002

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.0062658786773682

SELECT * FROM oc_url_alias WHERE `query` = 'product_id=34224'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.0056440830230713

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.0056118965148926

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/controller/extension/module/category.php
ControllerExtensionModuleCategory->index

0.004209041595459

SELECT image FROM `oc_category` WHERE category_id='76'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.004133939743042

SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='37452'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.0026922225952148

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=67'

/var/www/za.kh.ua/catalog/controller/startup/startup.php
Cart\Cart->__construct

0.0023519992828369

DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.0023260116577148

SELECT * FROM oc_custom_menu ORDER BY position

/var/www/za.kh.ua/catalog/model/catalog/information.php
ModelCatalogInformation->getInformations

0.0021569728851318

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/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.0019769668579102

SELECT image FROM `oc_category` WHERE category_id='66'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.0017659664154053

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.0017020702362061

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '71' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.0015838146209717

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '37452' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/catalog/model/design/layout.php
ModelDesignLayout->getLayoutModules

0.001471996307373

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategoryLayoutId

0.0013668537139893

SELECT * FROM oc_category_to_layout WHERE category_id = '71' AND store_id = '0'

/var/www/za.kh.ua/catalog/model/design/layout.php
ModelDesignLayout->getLayoutModules

0.0012969970703125

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.0012941360473633

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.0011360645294189

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/controller/startup/startup.php
Cart\Tax->setAddress

0.0010809898376465

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 = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4224') ORDER BY tr1.priority ASC

/var/www/za.kh.ua/catalog/model/tool/online.php
ModelToolOnline->addOnline

0.0010099411010742

DELETE FROM `oc_customer_online` WHERE date_added < '2021-04-12 05:27:54'

/var/www/za.kh.ua/system/library/cart/cart.php
Cart\Cart->getProducts

0.00080990791320801

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.00078415870666504

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '36492' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.0006558895111084

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '35122' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.00064396858215332

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '38162' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.0006248950958252

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '38119' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.00061988830566406

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34820' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.00061392784118652

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34818' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.00060391426086426

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '38088' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getMultistores

0.00060105323791504

SELECT * FROM `oc_multistore`

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.00059986114501953

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34224' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.00059199333190918

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34370' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategory

0.00056719779968262

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 = '71' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.0005650520324707

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34211' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.0005500316619873

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '38133' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00054788589477539

SELECT * FROM oc_url_alias WHERE `query` = 'manufacturer_id=111'

/var/www/za.kh.ua/system/storage/modification/catalog/model/catalog/product.php
ModelCatalogProduct->getProduct

0.00052809715270996

SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '34215' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.0005180835723877

/var/www/za.kh.ua/catalog/model/design/banner.php
ModelDesignBanner->getBanner

0.00047683715820312

SELECT * FROM oc_banner b LEFT JOIN oc_banner_image bi ON (b.banner_id = bi.banner_id) WHERE b.banner_id = '6' AND b.status = '1' AND bi.language_id = '1' ORDER BY bi.sort_order ASC

/var/www/za.kh.ua/catalog/controller/startup/startup.php
Cart\Length->__construct

0.00046682357788086

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/za.kh.ua/catalog/controller/startup/startup.php
Cart\Weight->__construct

0.00046515464782715

SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getMultistores

0.00043892860412598

SELECT * FROM `oc_multistore`

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategoryLayoutId

0.00043797492980957

SELECT * FROM oc_category_to_layout WHERE category_id = '71' AND store_id = '0'

/var/www/za.kh.ua/catalog/controller/startup/startup.php
Cart\Currency->__construct

0.00041699409484863

SELECT * FROM oc_currency

/var/www/za.kh.ua/system/storage/modification/system/library/config.php

0.00040912628173828

SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type'

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00036406517028809

/var/www/za.kh.ua/catalog/model/design/layout.php
ModelDesignLayout->getLayout

0.00035691261291504

SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00034093856811523

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/model/extension/event.php
ModelExtensionEvent->getEvents

0.00033998489379883

SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00033879280090332

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '76' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00033092498779297

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00032997131347656

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '68' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00032496452331543

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00031805038452148

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '69' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00031781196594238

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '77' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00031280517578125

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '75' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00031185150146484

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '72' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00030779838562012

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.00030684471130371

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategories

0.0003058910369873

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00030398368835449

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/controller/startup/startup.php
ControllerStartupStartup->index

0.00029492378234863

SELECT * FROM oc_store WHERE REPLACE(`url`, 'www.', '') = 'http://za.kh.ua/'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00028014183044434

SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='34211'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00027894973754883

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.0002751350402832

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.0002741813659668

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00026607513427734

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00026512145996094

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00025606155395508

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/controller/product/category.php
Cart\Cart->getProducts

0.00025391578674316

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'

/var/www/za.kh.ua/catalog/model/design/layout.php
ModelDesignLayout->getLayoutModules

0.00025200843811035

SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00024890899658203

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00024700164794922

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00024199485778809

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00023698806762695

SELECT * FROM oc_url_alias WHERE `query` = 'information_id=4'

/var/www/za.kh.ua/system/library/cart/cart.php
Cart\Cart->getProducts

0.00023603439331055

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00023508071899414

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/controller/startup/startup.php
Cart\Tax->setAddress

0.00023198127746582

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 = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4224') ORDER BY tr1.priority ASC

/var/www/za.kh.ua/catalog/model/extension/extension.php
ModelExtensionExtension->getExtensions

0.00022220611572266

SELECT * FROM oc_extension WHERE `type` = 'analytics'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00021719932556152

SELECT * FROM oc_url_alias WHERE `query` = 'manufacturer_id=7'

/var/www/za.kh.ua/system/library/openbay.php
Openbay->getInstalled

0.00021696090698242

SELECT * FROM oc_extension WHERE `type` = 'openbay'

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getMultistores

0.0002129077911377

SELECT * FROM `oc_multistore`

/var/www/za.kh.ua/catalog/model/extension/module.php
ModelExtensionModule->getModule

0.00021195411682129

SELECT * FROM oc_module WHERE module_id = '30'

/var/www/za.kh.ua/catalog/model/design/layout.php
ModelDesignLayout->getLayout

0.00020599365234375

SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1

/var/www/za.kh.ua/catalog/controller/common/footer.php
ControllerCommonFooter->index

0.00020408630371094

SELECT * FROM oc_custom_menu ORDER BY position

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00019717216491699

SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='34820'

/var/www/za.kh.ua/catalog/model/tool/online.php
ModelToolOnline->addOnline

0.00019097328186035

REPLACE INTO `oc_customer_online` SET `ip` = '3.235.41.241', `customer_id` = '0', `url` = 'http://za.kh.ua/index.php?route=product/category&path=71', `referer` = '', `date_added` = '2021-04-12 06:27:54'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00018906593322754

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00018596649169922

SELECT name FROM oc_manufacturer WHERE manufacturer_id='7'

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getMultistores

0.00018310546875

SELECT * FROM `oc_multistore`

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00017905235290527

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00017809867858887

SELECT * FROM oc_url_alias WHERE `query` = 'information_id=5'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00017499923706055

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=73'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
Cart\Cart->countProducts

0.00017404556274414

SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getMultistores

0.00017189979553223

SELECT * FROM `oc_multistore`

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00016999244689941

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=69'

/var/www/za.kh.ua/catalog/controller/common/cart.php
Cart\Cart->countProducts

0.00016903877258301

SELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'

/var/www/za.kh.ua/catalog/controller/common/cart.php
Cart\Cart->getProducts

0.0001678466796875

SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '23a1gdp37vqfk614ki7mjng0a3'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00016593933105469

SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='34234'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00016403198242188

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00016307830810547

SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='35727'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00016188621520996

SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='34224'

/var/www/za.kh.ua/catalog/model/design/layout.php
ModelDesignLayout->getLayout

0.00016117095947266

SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00016093254089355

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=65'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00015902519226074

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=66'

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getMultistores

0.00015711784362793

SELECT * FROM `oc_multistore`

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00015687942504883

SELECT * FROM oc_url_alias WHERE `query` = 'information_id=3'

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getMultistores

0.00015616416931152

SELECT * FROM `oc_multistore`

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.0001518726348877

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=72'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.00015091896057129

SELECT image FROM `oc_category` WHERE category_id='73'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00014996528625488

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00014901161193848

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=76'

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getMultistores

0.00014805793762207

SELECT * FROM `oc_multistore`

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00014615058898926

SELECT name FROM oc_manufacturer WHERE manufacturer_id='197'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00014591217041016

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=75'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00014495849609375

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00014400482177734

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=65'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00014305114746094

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00014209747314453

SELECT model, sku, upc, mpn, quantity, manufacturer_id FROM oc_product WHERE product_id='34370'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00014114379882812

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00014019012451172

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00013995170593262

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00013899803161621

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=69'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.0001380443572998

SELECT image FROM `oc_category` WHERE category_id='74'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.0001370906829834

SELECT image FROM `oc_category` WHERE category_id='67'

/var/www/za.kh.ua/catalog/model/extension/module/multistore.php
ModelExtensionModuleMultistore->getMultistores

0.0001368522644043

SELECT * FROM `oc_multistore`

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00013613700866699

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=77'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00013589859008789

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00013494491577148

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=75'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00013399124145508

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=70'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.00013303756713867

SELECT image FROM `oc_category` WHERE category_id='71'

/var/www/za.kh.ua/catalog/model/design/layout.php
ModelDesignLayout->getLayout

0.00013208389282227

SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00013184547424316

SELECT * FROM oc_url_alias WHERE `query` = 'product_id=38133'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00013113021850586

SELECT name FROM oc_manufacturer WHERE manufacturer_id='111'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00013089179992676

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=66'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.00013017654418945

SELECT image FROM `oc_category` WHERE category_id='72'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00012993812561035

SELECT * FROM oc_url_alias WHERE `query` = 'product_id=38119'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00012898445129395

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.00012803077697754

SELECT image FROM `oc_category` WHERE category_id='76'

/var/www/za.kh.ua/catalog/controller/extension/module/category.php
ControllerExtensionModuleCategory->index

0.00012707710266113

SELECT image FROM `oc_category` WHERE category_id='70'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00012683868408203

SELECT * FROM oc_url_alias WHERE `query` = 'product_id=34234'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00012612342834473

SELECT * FROM oc_url_alias WHERE `query` = 'manufacturer_id=70'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00012588500976562

SELECT name FROM oc_manufacturer WHERE manufacturer_id='97'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00012516975402832

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=73'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00012493133544922

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=68'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00012397766113281

SELECT name FROM oc_manufacturer WHERE manufacturer_id='111'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00012302398681641

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=68'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.0001220703125

SELECT image FROM `oc_category` WHERE category_id='65'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.0001218318939209

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00012016296386719

SELECT name FROM oc_manufacturer WHERE manufacturer_id='111'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00011992454528809

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=71'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00011897087097168

SELECT name FROM oc_manufacturer WHERE manufacturer_id='170'

/var/www/za.kh.ua/catalog/controller/extension/module/category.php
ControllerExtensionModuleCategory->index

0.00011682510375977

SELECT image FROM `oc_category` WHERE category_id='72'

/var/www/za.kh.ua/catalog/model/catalog/category.php
ModelCatalogCategory->getCategoryLayoutId

0.00011610984802246

SELECT * FROM oc_category_to_layout WHERE category_id = '71' AND store_id = '0'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00011587142944336

SELECT name FROM oc_manufacturer WHERE manufacturer_id='70'

/var/www/za.kh.ua/catalog/controller/extension/module/category.php
ControllerExtensionModuleCategory->index

0.00011515617370605

SELECT image FROM `oc_category` WHERE category_id='75'

/var/www/za.kh.ua/system/library/url.php
ControllerStartupSeoUrl->rewrite

0.00011491775512695

SELECT * FROM oc_url_alias WHERE `query` = 'category_id=72'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00011420249938965

SELECT name FROM oc_manufacturer WHERE manufacturer_id='298'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.00011396408081055

SELECT image FROM `oc_category` WHERE category_id='68'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.00011301040649414

SELECT image FROM `oc_category` WHERE category_id='77'

/var/www/za.kh.ua/system/storage/modification/catalog/controller/common/header.php
ControllerCommonHeader->index

0.00011110305786133

SELECT image FROM `oc_category` WHERE category_id='75'

/var/www/za.kh.ua/catalog/controller/product/category.php
ControllerProductCategory->index

0.00010991096496582

SELECT name FROM oc_manufacturer WHERE manufacturer_id='197'

/var/www/za.kh.ua/catalog/controller/extension/module/category.php
ControllerExtensionModuleCategory->index

0.00010585784912109

SELECT image FROM `oc_category` WHERE category_id='68'

/var/www/za.kh.ua/catalog/controller/extension/module/category.php
ControllerExtensionModuleCategory->index

0.00010418891906738

SELECT image FROM `oc_category` WHERE category_id='73'

/var/www/za.kh.ua/catalog/controller/extension/module/category.php
ControllerExtensionModuleCategory->index

0.00010299682617188

SELECT image FROM `oc_category` WHERE category_id='74'

Key	Value
route	product/category
path	71

Key

Value

route

product/category

path

Key	Value
HTTP_USER_AGENT	CCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_ACCEPT	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
HTTP_ACCEPT_LANGUAGE	en-US,en;q=0.5
HTTP_IF_MODIFIED_SINCE	Sat, 16 Jan 2021 23:53:13 GMT
HTTP_ACCEPT_ENCODING	br,gzip
HTTP_HOST	za.kh.ua
HTTP_CONNECTION	Keep-Alive
PATH	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
SERVER_SIGNATURE	<address>Apache/2.4.18 (Ubuntu) Server at za.kh.ua Port 80</address>
SERVER_SOFTWARE	Apache/2.4.18 (Ubuntu)
SERVER_NAME	za.kh.ua
SERVER_ADDR	195.69.187.120
SERVER_PORT	80
REMOTE_ADDR	3.235.41.241
DOCUMENT_ROOT	/var/www/za.kh.ua
REQUEST_SCHEME	http
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT	/var/www/za.kh.ua
SERVER_ADMIN	[no address given]
SCRIPT_FILENAME	/var/www/za.kh.ua/index.php
REMOTE_PORT	47614
GATEWAY_INTERFACE	CGI/1.1
SERVER_PROTOCOL	HTTP/1.1
REQUEST_METHOD	GET
QUERY_STRING	route=product/category&path=71
REQUEST_URI	/index.php?route=product/category&path=71
SCRIPT_NAME	/index.php
PHP_SELF	/index.php
REQUEST_TIME_FLOAT	1618208873.567
REQUEST_TIME	1618208873
HTTPS

Key

Value

HTTP_USER_AGENT

CCBot/2.0 (https://commoncrawl.org/faq/)

HTTP_ACCEPT

text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

HTTP_ACCEPT_LANGUAGE

en-US,en;q=0.5

HTTP_IF_MODIFIED_SINCE

Sat, 16 Jan 2021 23:53:13 GMT

HTTP_ACCEPT_ENCODING

br,gzip

HTTP_HOST

za.kh.ua

HTTP_CONNECTION

Keep-Alive

PATH

/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

SERVER_SIGNATURE

<address>Apache/2.4.18 (Ubuntu) Server at za.kh.ua Port 80</address>

SERVER_SOFTWARE

Apache/2.4.18 (Ubuntu)

SERVER_NAME

za.kh.ua

SERVER_ADDR

195.69.187.120

SERVER_PORT

REMOTE_ADDR

3.235.41.241

DOCUMENT_ROOT

/var/www/za.kh.ua

REQUEST_SCHEME

http

CONTEXT_PREFIX

CONTEXT_DOCUMENT_ROOT

/var/www/za.kh.ua

SERVER_ADMIN

[no address given]

SCRIPT_FILENAME

/var/www/za.kh.ua/index.php

REMOTE_PORT

47614

GATEWAY_INTERFACE

CGI/1.1

SERVER_PROTOCOL

HTTP/1.1

REQUEST_METHOD

GET

QUERY_STRING

route=product/category&path=71

REQUEST_URI

/index.php?route=product/category&path=71

SCRIPT_NAME

/index.php

PHP_SELF

/index.php

REQUEST_TIME_FLOAT

1618208873.567

REQUEST_TIME

1618208873

HTTPS

РТИ

Actions

Queries

Requests

GET `2`:

POST `0`:

SERVER `31`:

COOKIE `0`:

РТИ

Actions

Queries

Requests

GET 2:

POST 0:

SERVER 31:

COOKIE 0:

GET `2`:

POST `0`:

SERVER `31`:

COOKIE `0`: