1 (0.606)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/openbay.php:117
2 (0.337)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://unitech.com.ua/'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/controller/startup/startup.php:6
3 (21.776)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/controller/startup/startup.php:25
4 (0.266)
SELECT *
FROM oc_store
ORDER BY url
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/setting/store.php:7
5 (0.368)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/agoo/multilang.php:33
6 (0.402)
SELECT *
FROM oc_currency
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/cart/currency.php:10
7 (1.311)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '1db0a7b3e400660d6af054c0d353991a'
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/jetcache/jetcache.php:251
8 (1.205)
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 = '3490')
ORDER BY tr1.priority ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/cart/tax.php:17
9 (0.498)
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 = '3490')
ORDER BY tr1.priority ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/cart/tax.php:45
10 (0.503)
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 = '3'
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/cart/weight.php:10
11 (0.494)
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 = '3'
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/cart/length.php:10
12 (1.283)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/system/library/cart/cart.php:21
13 (0.327)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/openbay.php:117
14 (0.462)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `event_id` ASC
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/event.php:4
15 (0.847)
SELECT `id`, `link`, `short_link`
FROM `oc_filter_vier_hl`
WHERE `short_link` = 'seriya-kolesa_53~65alu' AND `route` = 'category_id' AND `route_id` = 706 AND `status` = 1 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
16 (0.822)
SELECT `main_key`, `main_id`, `key_id`
FROM `oc_url_filter_vier`
WHERE `seo_url` = 'seriya-kolesa' LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
17 (0.332)
SELECT `key_id`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 899 AND `key_id` != 0 AND `seo_url` = '53' LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
18 (0.282)
SELECT `key_id`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 899 AND `key_id` != 0 AND `seo_url` = '65alu' LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
19 (0.394)
SELECT `id`, `link`, `short_link`
FROM `oc_filter_vier_hl`
WHERE `short_link` = 'visota-mm_108~128~240~189' AND `route` = 'category_id' AND `route_id` = 706 AND `status` = 1 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
20 (0.368)
SELECT `main_key`, `main_id`, `key_id`
FROM `oc_url_filter_vier`
WHERE `seo_url` = 'visota-mm' LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
21 (0.360)
SELECT `key_id`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 904 AND `key_id` != 0 AND `seo_url` = '108' LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
22 (0.331)
SELECT `key_id`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 904 AND `key_id` != 0 AND `seo_url` = '128' LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
23 (0.421)
SELECT `key_id`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 904 AND `key_id` != 0 AND `seo_url` = '240' LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
24 (0.393)
SELECT `key_id`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 904 AND `key_id` != 0 AND `seo_url` = '189' LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
25 (0.337)
SELECT `layout_id`
FROM `oc_category_to_layout`
WHERE `category_id` = 706 AND `store_id` = 0 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
26 (0.350)
SELECT `layout_id`
FROM `oc_layout_route`
WHERE 'product/category' LIKE `route` AND `store_id` = 0
ORDER BY `route` DESC, `layout_id` ASC LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
27 (0.282)
SELECT `layout_module_id`
FROM `oc_layout_module`
WHERE `layout_id` = 3 AND `code` = 'filter_vier' LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
28 (0.278)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/controller/common/seoblog.php:87
29 (0.541)
SELECT *
FROM oc_url_alias_blog
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/controller/common/seoblog.php:111
30 (0.310)
SELECT blog_id, design, path
FROM oc_blog
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/controller/common/seoblog.php:123
31 (0.498)
SELECT *
FROM oc_layout l
LEFT JOIN oc_layout_route lr ON (l.layout_id = lr.layout_id)
ORDER BY name ASC
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/design/bloglayout.php:43
32 (0.655)
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 = '706' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:4
33 (0.395)
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 = '676' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:4
34 (0.621)
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 = '0' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:4
35 (0.589)
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 = '706' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:4
36 (0.614)
SELECT `key`, `value`
FROM `oc_watermark_settings`
WHERE 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/module/watermark/image.watermark.php:485
37 (0.871)
SELECT ad.attribute_id, ad.name, a.sort_order
FROM oc_attribute_description ad
LEFT JOIN oc_attribute a ON (ad.attribute_id = a.attribute_id)
WHERE ad.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:13
38 (0.534)
SELECT *
FROM oc_module
WHERE module_id = '43'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/module/bottomslider.php:16
39 (0.328)
SELECT `layout_id`
FROM `oc_category_to_layout`
WHERE `category_id` = 706 AND `store_id` = 0 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
40 (0.396)
SELECT `layout_id`
FROM `oc_layout_route`
WHERE 'product/category' LIKE `route` AND `store_id` = 0
ORDER BY `route` DESC, `layout_id` ASC LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
41 (0.308)
SELECT `layout_module_id`
FROM `oc_layout_module`
WHERE `layout_id` = 3 AND `code` = 'filter_vier' LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
42 (90.583)
SELECT COUNT(DISTINCT p.`product_id`) AS `total`
FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`)
WHERE p2c.`category_id` = 706 AND p.`product_id` IN (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 899 AND afv.`text_id` IN (38258,38260) AND EXISTS (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 904 AND afv.`text_id` IN (38377,38381,38386,38396) )) AND p.`status` = 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
43 (59.259)
SELECT p.`product_id`
FROM `oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`)
LEFT JOIN `oc_product_description` pd ON (p.`product_id` = pd.`product_id`)
WHERE p2c.`category_id` = 706 AND p.`product_id` IN (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 899 AND afv.`text_id` IN (38258,38260) AND EXISTS (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 904 AND afv.`text_id` IN (38377,38381,38386,38396) )) AND p.`status` = 1 AND pd.`language_id` = 3 GROUP BY p.`product_id`
ORDER BY LCASE(pd.name) ASC
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
44 (1.933)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '926' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
45 (0.923)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '923' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
46 (0.832)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '965' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
47 (0.899)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '928' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
48 (0.896)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '968' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
49 (0.846)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '969' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
50 (0.804)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '966' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
51 (0.829)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '925' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
52 (0.858)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '924' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
53 (0.816)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '921' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
54 (0.816)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '920' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
55 (0.803)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1010' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
56 (0.803)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1016' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
57 (0.801)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1013' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
58 (0.776)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1009' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
59 (0.857)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1004' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
60 (1.012)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1007' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
61 (0.797)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1005' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
62 (0.897)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1110' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
63 (0.928)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1107' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
64 (1.170)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1105' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
65 (0.840)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1108' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
66 (0.844)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1122' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
67 (0.811)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1058' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
68 (1.067)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1089' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
69 (0.956)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1083' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
70 (0.820)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, m.image AS mimage, m.country AS mcountry, m.country_ua AS mcountry_ua, m.image2 AS mimage2, (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 = '3') 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 = '3') 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 = '3') 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 = '1300' AND pd.language_id = '3' AND (p.status = '1' or p.status='2')
AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
71 (0.526)
SELECT *
FROM oc_product_image
WHERE product_id = '926'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
72 (0.406)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 926
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
73 (1.014)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '926' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
74 (0.290)
SELECT *
FROM oc_product_image
WHERE product_id = '923'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
75 (0.201)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 923
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
76 (0.679)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '923' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
77 (0.283)
SELECT *
FROM oc_product_image
WHERE product_id = '965'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
78 (0.360)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 965
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
79 (1.233)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '965' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
80 (0.422)
SELECT *
FROM oc_product_image
WHERE product_id = '928'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
81 (0.323)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 928
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
82 (1.198)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '928' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
83 (0.464)
SELECT *
FROM oc_product_image
WHERE product_id = '968'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
84 (0.280)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 968
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
85 (1.105)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '968' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
86 (0.436)
SELECT *
FROM oc_product_image
WHERE product_id = '969'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
87 (0.399)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 969
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
88 (1.240)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '969' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
89 (0.497)
SELECT *
FROM oc_product_image
WHERE product_id = '966'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
90 (0.244)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 966
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
91 (1.136)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '966' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
92 (0.377)
SELECT *
FROM oc_product_image
WHERE product_id = '925'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
93 (0.342)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 925
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
94 (1.476)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '925' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
95 (0.450)
SELECT *
FROM oc_product_image
WHERE product_id = '924'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
96 (0.413)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 924
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
97 (2.010)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '924' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
98 (0.551)
SELECT *
FROM oc_product_image
WHERE product_id = '921'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
99 (0.293)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 921
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
100 (1.475)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '921' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
101 (0.432)
SELECT *
FROM oc_product_image
WHERE product_id = '920'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
102 (0.301)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 920
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
103 (1.668)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '920' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
104 (0.409)
SELECT *
FROM oc_product_image
WHERE product_id = '1010'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
105 (0.257)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1010
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
106 (1.125)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1010' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
107 (0.499)
SELECT *
FROM oc_product_image
WHERE product_id = '1016'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
108 (0.358)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1016
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
109 (1.226)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1016' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
110 (0.422)
SELECT *
FROM oc_product_image
WHERE product_id = '1013'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
111 (0.246)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1013
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
112 (1.302)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1013' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
113 (0.494)
SELECT *
FROM oc_product_image
WHERE product_id = '1009'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
114 (0.280)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1009
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
115 (1.113)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1009' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
116 (0.404)
SELECT *
FROM oc_product_image
WHERE product_id = '1004'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
117 (0.326)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1004
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
118 (1.486)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1004' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
119 (0.478)
SELECT *
FROM oc_product_image
WHERE product_id = '1007'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
120 (0.319)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1007
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
121 (1.236)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1007' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
122 (0.443)
SELECT *
FROM oc_product_image
WHERE product_id = '1005'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
123 (0.316)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1005
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
124 (1.909)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1005' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
125 (0.381)
SELECT *
FROM oc_product_image
WHERE product_id = '1110'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
126 (0.317)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1110
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
127 (4.805)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1110' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
128 (0.528)
SELECT *
FROM oc_product_image
WHERE product_id = '1107'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
129 (0.299)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1107
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
130 (1.229)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1107' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
131 (0.469)
SELECT *
FROM oc_product_image
WHERE product_id = '1105'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
132 (0.294)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1105
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
133 (1.190)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1105' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
134 (0.496)
SELECT *
FROM oc_product_image
WHERE product_id = '1108'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
135 (0.306)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1108
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
136 (1.276)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1108' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
137 (0.459)
SELECT *
FROM oc_product_image
WHERE product_id = '1122'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
138 (0.376)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1122
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
139 (1.365)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1122' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
140 (0.451)
SELECT *
FROM oc_product_image
WHERE product_id = '1058'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
141 (0.308)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1058
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
142 (1.156)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1058' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
143 (0.432)
SELECT *
FROM oc_product_image
WHERE product_id = '1089'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
144 (0.331)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1089
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
145 (1.115)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1089' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
146 (0.464)
SELECT *
FROM oc_product_image
WHERE product_id = '1083'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
147 (0.313)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1083
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
148 (1.292)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1083' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
149 (0.537)
SELECT *
FROM oc_product_image
WHERE product_id = '1300'
ORDER BY sort_order ASC
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:501
150 (0.367)
SELECT d.download_id
FROM `oc_product_to_download` d
RIGHT JOIN `oc_download` o ON (d.download_id = o.download_id)
WHERE `product_id` = 1300
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/account/download.php:66
151 (1.366)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1300' AND a.attribute_id IN (898,894,895,635,896) AND ad.language_id = '3' AND pa.language_id = '3'
ORDER BY a.sort_order, ad.name
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/catalog/product.php:330
152 (0.899)
SELECT `seo_url`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 899 AND `key_id` = 0 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
153 (0.440)
SELECT `seo_url`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 899 AND `key_id` = 38258 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
154 (0.420)
SELECT `seo_url`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 899 AND `key_id` = 38260 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
155 (0.530)
SELECT `seo_url`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 904 AND `key_id` = 0 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
156 (0.447)
SELECT `seo_url`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 904 AND `key_id` = 38377 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
157 (0.421)
SELECT `seo_url`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 904 AND `key_id` = 38381 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
158 (0.437)
SELECT `seo_url`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 904 AND `key_id` = 38386 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
159 (0.436)
SELECT `seo_url`
FROM `oc_url_filter_vier`
WHERE `main_key` = 'attrb' AND `main_id` = 904 AND `key_id` = 38396 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
160 (0.794)
SELECT `id`, `link`, `short_link`
FROM `oc_filter_vier_hl`
WHERE `link` = 'seriya-kolesa_53~65alu/visota-mm_108~128~240~189' AND `route` = 'category_id' AND `route_id` = 706 AND `status` = 1 LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
161 (0.516)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '706' AND store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:55
162 (0.588)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/design/layout.php:4
163 (0.542)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/design/layout.php:23
164 (0.365)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '706' AND store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:55
165 (0.383)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/design/layout.php:4
166 (0.351)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/design/layout.php:23
167 (0.332)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '706' AND store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:55
168 (0.320)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/design/layout.php:4
169 (0.398)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/design/layout.php:23
170 (0.620)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '706' AND store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:55
171 (0.401)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/design/layout.php:4
172 (0.644)
SELECT *
FROM oc_customer
WHERE customer_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/record/avatar.php:10
173 (1.275)
SELECT `id`, `link`
FROM `oc_filter_vier_hl`
WHERE `route` = 'category_id' AND `route_id` = 706 AND `status` = 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
174 (96.963)
SELECT p.`product_id`
FROM
`oc_product` p JOIN `oc_product_to_category` p2c ON (p.`product_id` = p2c.`product_id`)
WHERE p2c.`category_id` = 706 AND p.`product_id` IN (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 899 AND afv.`text_id` IN (38258,38260) AND EXISTS (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 904 AND afv.`text_id` IN (38377,38381,38386,38396) )) AND p.`status` = 1
GROUP BY p.`product_id`
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
175 (58.233)
SELECT p.`manufacturer_id`, 1 AS total
FROM `oc_product` p
WHERE p.`product_id` IN (SELECT p2c.`product_id`
FROM `oc_product_to_category` p2c
WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` = 706 ) AND p.`product_id` IN (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 899 AND afv.`text_id` IN (38258,38260) AND EXISTS (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 904 AND afv.`text_id` IN (38377,38381,38386,38396) )) AND p.`status` = 1 GROUP BY p.`manufacturer_id`
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
176 (44.388)
SELECT CONCAT(afv.`attribute_id`, '_', afv.`text_id`) AS `attr_text`, COUNT(afv.`text_id`) AS total
FROM `oc_attribute_text_product` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`)
WHERE p.`product_id` IN (SELECT p2c.`product_id`
FROM `oc_product_to_category` p2c
WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` = 706 ) AND afv.`attribute_id` IN (439,448,450,453,458,459,461,462,465,466,468,469,471,474,475,477,481,482,490,494,524,530,531,532,534,535,537,538,540,546,547,549,551,553,556,557,561,564,570,571,575,578,586,592,598,608,609,612,614,615,616,618,622,624,647,650,653,654,658,665,670,671,674,676,678,690,692,694,696,697,700,703,707,708,721,723,724,739,741,742,743,758,765,772,773,774,778,785,835,839,858,878,889,890,895,896,903,912,916,920,921,922,923,927,935,955,957,965,970,971,972,993,995,1019,1020,1046,1054,1061,1068,1072,1079,1083,1088,1105,1112,1117) AND p.`product_id` IN (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 899 AND afv.`text_id` IN (38258,38260) AND EXISTS (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 904 AND afv.`text_id` IN (38377,38381,38386,38396) )) AND p.`status` = 1 GROUP BY afv.`attribute_id`, afv.`text_id`
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
177 (4.941)
SELECT CONCAT(afv.`attribute_id`, '_', afv.`text_id`) AS `attr_text`, COUNT(afv.`text_id`) AS total
FROM `oc_attribute_text_product` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`)
WHERE p.`product_id` IN (SELECT p2c.`product_id`
FROM `oc_product_to_category` p2c
WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` = 706 ) AND afv.`attribute_id` IN (899) AND p.`product_id` IN (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE p.`product_id` = afv.`product_id` AND afv.`attribute_id` = 904 AND afv.`text_id` IN (38377,38381,38386,38396) ) AND p.`status` = 1 GROUP BY afv.`attribute_id`, afv.`text_id`
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
178 (4.841)
SELECT CONCAT(afv.`attribute_id`, '_', afv.`text_id`) AS `attr_text`, COUNT(afv.`text_id`) AS total
FROM `oc_attribute_text_product` afv JOIN `oc_product` p ON (afv.`product_id` = p.`product_id`)
WHERE p.`product_id` IN (SELECT p2c.`product_id`
FROM `oc_product_to_category` p2c
WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` = 706 ) AND afv.`attribute_id` IN (904) AND p.`product_id` IN (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE p.`product_id` = afv.`product_id` AND afv.`attribute_id` = 899 AND afv.`text_id` IN (38258,38260) ) AND p.`status` = 1 GROUP BY afv.`attribute_id`, afv.`text_id`
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
179 (51.494)
SELECT MIN( p.`price`) AS price_min, MAX( p.`price`) AS price_max
FROM `oc_product` p
WHERE p.`product_id` IN (SELECT p2c.`product_id`
FROM `oc_product_to_category` p2c
WHERE p.`product_id` = p2c.`product_id` AND p2c.`category_id` = 706 ) AND p.`product_id` IN (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 899 AND afv.`text_id` IN (38258,38260) AND EXISTS (SELECT afv.`product_id`
FROM `oc_attribute_text_product` afv
WHERE afv.`product_id` = p.`product_id` AND afv.`attribute_id` = 904 AND afv.`text_id` IN (38377,38381,38386,38396) )) AND p.`status` = 1
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/module/filter_vier.php:0
180 (0.973)
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 = '706' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:4
181 (0.244)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '706' AND store_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:55
182 (0.263)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/design/layout.php:4
183 (0.276)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/catalog/model/design/layout.php:23
184 (1.154)
SHOW TABLES LIKE 'oc_newsletter'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/module/newsletters.php:6
185 (0.315)
SELECT *
FROM oc_module
WHERE module_id = '43'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/module.php:4
186 (0.392)
SELECT value
FROM oc_setting
WHERE `key` = 'microdatapro_key'
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/microdatapro.php:138
187 (0.298)
SELECT value
FROM oc_setting
WHERE `key` = 'microdatapro_key'
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/microdatapro.php:138
188 (0.240)
SELECT value
FROM oc_setting
WHERE `key` = 'microdatapro_key'
/var/www/sudoadmin/data/www/unitech.com.ua/system/library/microdatapro.php:138
189 (0.363)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/extension.php:4
190 (3.095)
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 = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:10
191 (0.411)
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 = '706' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/catalog/category.php:4
192 (0.306)
SELECT *
FROM oc_store
ORDER BY url
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/setting/store.php:7
193 (0.425)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1db0a7b3e400660d6af054c0d353991a'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/system/library/cart/cart.php:42
194 (0.228)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/extension.php:4
195 (0.274)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1db0a7b3e400660d6af054c0d353991a'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/system/library/cart/cart.php:42
196 (0.265)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1db0a7b3e400660d6af054c0d353991a'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/system/library/cart/cart.php:42
197 (0.312)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/system/library/cart/customer.php:141
198 (0.268)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1db0a7b3e400660d6af054c0d353991a'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/system/library/cart/cart.php:42
199 (0.255)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '1db0a7b3e400660d6af054c0d353991a'
/var/www/sudoadmin/data/www/unitech.com.ua/system/storage/modification/system/library/cart/cart.php:42
200 (0.777)
SELECT *
FROM oc_module
WHERE module_id = '44'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/module/bottomslider.php:16
201 (0.210)
SELECT *
FROM oc_module
WHERE module_id = '37'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/module/bottomslider.php:16
202 (0.215)
SELECT *
FROM oc_module
WHERE module_id = '38'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/module/bottomslider.php:16
203 (0.197)
SELECT *
FROM oc_module
WHERE module_id = '39'
/var/www/sudoadmin/data/www/unitech.com.ua/catalog/model/extension/module/bottomslider.php:16
Металообробка, виготовлення обладнання
Інжиніринг та технічний сервіс
Фільтр товарів
Заявка прийнята. Наш менеджер зв’яжеться з Вами в найближчий час 
