1 (0.205)
SELECT `data`
FROM `oc_session`
WHERE session_id = '78412ada876bccb533b556246b' AND expire > 1728352416
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/session/db.php:21
2 (0.200)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/openbay.php:61
3 (0.189)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
4 (0.156)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/openbay.php:61
5 (0.214)
SELECT `data`
FROM `oc_session`
WHERE session_id = '78412ada876bccb533b556246b' AND expire > 1728352416
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/session/db.php:21
6 (0.162)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://abricol.com.ua/'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/controller/startup/startup.php:6
7 (49.942)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/controller/startup/startup.php:25
8 (0.198)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/localisation/language.php:15
9 (1.851)
SELECT *
FROM oc_currency
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/currency.php:10
10 (23.702)
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 = '3487')
ORDER BY tr1.priority ASC
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/tax.php:16
11 (4.753)
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 = '3487')
ORDER BY tr1.priority ASC
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/tax.php:44
12 (0.731)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/weight.php:10
13 (0.539)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/length.php:10
14 (7.116)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/cart.php:30
15 (0.162)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/openbay.php:61
16 (0.470)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/setting/event.php:4
17 (7.957)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/ocfilter' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
18 (0.341)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = 'aksessuary-dlya-bilyarda' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
19 (0.405)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = 'nakleyki-i-nakonechniki-dlya-kiya' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
20 (0.326)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = 'strana-proizvodstva' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
21 (0.826)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = 'ukraina' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
22 (0.195)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = 'tverdost-po-shoru' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
23 (0.242)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = '78' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
24 (0.170)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = '92' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
25 (0.160)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = '84' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
26 (0.165)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = '80' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
27 (0.149)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = '88' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
28 (0.205)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = '89' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
29 (0.213)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = '94' LIMIT 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:747
30 (0.218)
SELECT value_id
FROM oc_ocfilter_option_value
WHERE option_id = '30033' AND `keyword` = 'tverdost-po-shoru'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/controller/extension/module/ocfilter.php:802
31 (0.914)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/ocfilter.php:514
32 (0.270)
SELECT `value`
FROM `oc_setting`
WHERE `key` = 'config_language'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/controller/startup/seo_pro.php:70
33 (0.157)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/controller/startup/seo_pro.php:72
34 (0.198)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
35 (0.159)
SELECT status
FROM oc_modification
WHERE `code`='NS->QUICK-ORDER'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/ns/moduleonoff.php:12
36 (0.146)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'ns/newstorelang' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
37 (0.157)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '20' AND store_id = '0'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:55
38 (0.228)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20'
ORDER BY sort_order
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/ns/layout_home_page.php:4
39 (0.269)
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 = '3' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:4
40 (0.237)
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 = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:4
41 (0.217)
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 = '3' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:4
42 (0.665)
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 = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
43 (64.070)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN(SELECT oov2p1.product_id
FROM oc_ocfilter_option_value_to_product oov2p1
INNER JOIN oc_ocfilter_option_value_to_product oov2p2 ON (oov2p1.product_id = oov2p2.product_id)
WHERE oov2p1.option_id = '30033' AND (oov2p1.value_id = '1633903715') AND oov2p2.option_id = '30165' AND (oov2p2.value_id = '361168519' OR oov2p2.value_id = '1808808471' OR oov2p2.value_id = '2611523171' OR oov2p2.value_id = '2630183546' OR oov2p2.value_id = '4292847073' OR oov2p2.value_id = '4292847074' OR oov2p2.value_id = '4292847090'))
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:701
44 (11.761)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ps.store_id IN (-1,0) AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN(SELECT oov2p1.product_id
FROM oc_ocfilter_option_value_to_product oov2p1
INNER JOIN oc_ocfilter_option_value_to_product oov2p2 ON (oov2p1.product_id = oov2p2.product_id)
WHERE oov2p1.option_id = '30033' AND (oov2p1.value_id = '1633903715') AND oov2p2.option_id = '30165' AND (oov2p2.value_id = '361168519' OR oov2p2.value_id = '1808808471' OR oov2p2.value_id = '2611523171' OR oov2p2.value_id = '2630183546' OR oov2p2.value_id = '4292847073' OR oov2p2.value_id = '4292847074' OR oov2p2.value_id = '4292847090')) GROUP BY p.product_id
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) ASC, LCASE(pd.name) ASC LIMIT 0,30
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:239
45 (5.168)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3343' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3343' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
46 (1.217)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3343 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
47 (1.030)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3342' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3342' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
48 (0.356)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3342 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
49 (0.956)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3725' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3725' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
50 (0.361)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3725 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
51 (1.271)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3823' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3823' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
52 (0.330)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3823 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
53 (5.447)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3841' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3841' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
54 (0.372)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3841 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
55 (0.823)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3844' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3844' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
56 (0.266)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3844 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
57 (0.746)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3842' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3842' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
58 (12.814)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3842 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
59 (1.434)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3843' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3843' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
60 (0.937)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3843 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
61 (0.755)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3754' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3754' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
62 (2.748)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3754 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
63 (0.760)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3753' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3753' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
64 (6.238)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3753 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
65 (5.740)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3481' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3481' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
66 (2.483)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3481 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
67 (12.866)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '2463' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '2463' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
68 (4.179)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 2463 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
69 (4.203)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3001' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3001' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
70 (3.331)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3001 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
71 (0.871)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3002' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3002' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
72 (5.924)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3002 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
73 (4.071)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3347' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3347' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
74 (2.780)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3347 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
75 (3.500)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3607' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3607' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
76 (3.535)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3607 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
77 (14.125)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3779' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3779' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
78 (3.372)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3779 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
79 (0.923)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3348' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3348' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
80 (5.629)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3348 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
81 (0.891)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3606' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3606' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
82 (7.067)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3606 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
83 (0.868)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '2557' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '2557' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
84 (1.603)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 2557 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
85 (3.693)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '2969' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '2969' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
86 (2.447)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 2969 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
87 (2.250)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '2558' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '2558' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
88 (5.589)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 2558 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
89 (18.518)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '2559' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '2559' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
90 (3.977)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 2559 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
91 (2.393)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3854' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3854' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
92 (0.297)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3854 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
93 (6.249)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3724' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3724' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
94 (4.524)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3724 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
95 (6.536)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '2462' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '2462' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
96 (7.086)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 2462 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
97 (0.675)
SELECT *
FROM oc_product_image
WHERE product_id = '3343'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
98 (0.869)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3343'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
99 (11.256)
SELECT *
FROM oc_product_image
WHERE product_id = '3342'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
100 (1.964)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3342'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
101 (8.101)
SELECT *
FROM oc_product_image
WHERE product_id = '3725'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
102 (4.824)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3725'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
103 (0.208)
SELECT *
FROM oc_product_image
WHERE product_id = '3823'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
104 (2.682)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3823'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
105 (0.190)
SELECT *
FROM oc_product_image
WHERE product_id = '3841'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
106 (1.557)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3841'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
107 (0.152)
SELECT *
FROM oc_product_image
WHERE product_id = '3844'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
108 (0.223)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3844'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
109 (0.186)
SELECT *
FROM oc_product_image
WHERE product_id = '3842'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
110 (0.189)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3842'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
111 (0.176)
SELECT *
FROM oc_product_image
WHERE product_id = '3843'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
112 (0.158)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3843'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
113 (0.149)
SELECT *
FROM oc_product_image
WHERE product_id = '3754'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
114 (0.323)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3754'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
115 (1.382)
SELECT *
FROM oc_product_image
WHERE product_id = '3753'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
116 (2.240)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3753'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
117 (3.869)
SELECT *
FROM oc_product_image
WHERE product_id = '3481'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
118 (0.365)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3481'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
119 (10.711)
SELECT *
FROM oc_product_image
WHERE product_id = '2463'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
120 (4.456)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '2463'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
121 (5.951)
SELECT *
FROM oc_product_image
WHERE product_id = '3001'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
122 (2.257)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3001'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
123 (16.555)
SELECT *
FROM oc_product_image
WHERE product_id = '3002'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
124 (2.610)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3002'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
125 (2.927)
SELECT *
FROM oc_product_image
WHERE product_id = '3347'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
126 (1.504)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3347'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
127 (3.906)
SELECT *
FROM oc_product_image
WHERE product_id = '3607'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
128 (3.007)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3607'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
129 (7.616)
SELECT *
FROM oc_product_image
WHERE product_id = '3779'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
130 (17.654)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3779'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
131 (18.192)
SELECT *
FROM oc_product_image
WHERE product_id = '3348'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
132 (0.380)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3348'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
133 (11.049)
SELECT *
FROM oc_product_image
WHERE product_id = '3606'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
134 (0.441)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3606'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
135 (0.164)
SELECT *
FROM oc_product_image
WHERE product_id = '2557'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
136 (0.274)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '2557'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
137 (0.150)
SELECT *
FROM oc_product_image
WHERE product_id = '2969'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
138 (0.293)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '2969'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
139 (1.129)
SELECT *
FROM oc_product_image
WHERE product_id = '2558'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
140 (0.372)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '2558'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
141 (12.066)
SELECT *
FROM oc_product_image
WHERE product_id = '2559'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
142 (1.652)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '2559'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
143 (12.642)
SELECT *
FROM oc_product_image
WHERE product_id = '3854'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
144 (6.864)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3854'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
145 (3.952)
SELECT *
FROM oc_product_image
WHERE product_id = '3724'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
146 (0.509)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '3724'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
147 (2.632)
SELECT *
FROM oc_product_image
WHERE product_id = '2462'
ORDER BY sort_order ASC
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:503
148 (0.914)
SELECT SUM(quantity) AS total
FROM oc_order_product op
WHERE op.product_id = '2462'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:388
149 (11.687)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/ocfilter.php:514
150 (18.404)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '20' AND store_id = '0'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:55
151 (10.396)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'column_left'
ORDER BY sort_order
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/layout.php:14
152 (2.361)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/ocfilter' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
153 (0.238)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'extension/module/ocfilter'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
154 (17.975)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/column_left'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
155 (42.865)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '20' AND store_id = '0'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:55
156 (1.546)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'column_right'
ORDER BY sort_order
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/layout.php:14
157 (3.802)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/column_right'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
158 (20.188)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '20' AND store_id = '0'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:55
159 (0.329)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'content_top'
ORDER BY sort_order
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/layout.php:14
160 (0.853)
SELECT *
FROM oc_module
WHERE module_id = '45'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/setting/module.php:4
161 (1.271)
SELECT *
FROM oc_module
WHERE module_id = '46'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/setting/module.php:4
162 (5.963)
SELECT *
FROM oc_module
WHERE module_id = '51'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/setting/module.php:4
163 (10.354)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/content_top'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
164 (6.933)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '20' AND store_id = '0'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:55
165 (2.759)
SELECT *
FROM oc_layout_module
WHERE layout_id = '20' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/layout.php:14
166 (0.201)
SELECT *
FROM oc_module
WHERE module_id = '52'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/setting/module.php:4
167 (3.214)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'extension/module/html'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
168 (7.204)
SELECT *
FROM oc_module
WHERE module_id = '41'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/setting/module.php:4
169 (17.217)
SELECT DISTINCT *
FROM ( ( SELECT DISTINCT r.*, pd.name, p.price, p.image
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p2s.store_id = '0' AND p.date_available <= NOW()
AND (p.status = '1' OR p.product_id = 0)
AND r.status = '1'
AND r.store_id = 0
AND pd.language_id = '1'
AND p2c.category_id = '20'
ORDER BY date_added DESC LIMIT 10)) a LIMIT 10
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/reviewscustomer.php:17
170 (10.921)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '2104' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '2104' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
171 (2.082)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 2104 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
172 (8.430)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3302' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3302' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
173 (0.316)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3302 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
174 (5.518)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3302' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3302' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
175 (1.778)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3302 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
176 (9.445)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '2077' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '2077' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
177 (2.292)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 2077 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
178 (8.323)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '2077' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '2077' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
179 (0.716)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 2077 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
180 (11.913)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3343' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3343' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
181 (0.715)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3343 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
182 (18.657)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3302' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3302' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
183 (1.015)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3302 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
184 (10.263)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3554' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3554' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
185 (1.311)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3554 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
186 (14.429)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3302' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3302' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
187 (3.066)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3302 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
188 (12.002)
SELECT DISTINCT *, pd.name AS name, p.like_count, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.store_id IN (-1,0) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' AND r1.store_id = 0 GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.store_id = 0 AND r2.status = '1' GROUP BY r2.product_id) AS reviews,(SELECT date_end
FROM oc_product_special
WHERE product_id = '3554' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, price ASC LIMIT 1) AS date_end, 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 = '3554' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:17
189 (4.833)
SELECT pso.*, pd.name, p.price as oldprice, p.model, p.image
FROM `oc_product_special_offer` pso, `oc_product_description` pd,`oc_product` p
WHERE p.product_id = pd.product_id AND pso.offer_product_id = pd.product_id AND pd.language_id = 1 AND (date_end > DATE(NOW()) OR date_end = '0000-00-00') AND pso.store_id IN (-1,0) AND pso.product_id = 3554 AND pso.price = 0
ORDER BY (p.price>0) DESC,(p.image>'') DESC,(p.quantity>0) DESC, pso.sort_order ASC LIMIT 1
/var/www/abricol.com.ua/data/www/storage/modification/catalog/model/catalog/product.php:794
190 (15.701)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'extension/module/reviewscustomer'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
191 (47.235)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/content_bottom'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
192 (20.120)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
193 (17.637)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'ns/newstorelang' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
194 (13.149)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/information.php:10
195 (7.721)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2024-10-08 00:53:39'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/tool/online.php:4
196 (0.201)
REPLACE INTO `oc_customer_online` SET `ip` = '3.14.254.22', `customer_id` = '0', `url` = 'https://abricol.com.ua/aksessuary-dlya-bilyarda/nakleyki-i-nakonechniki-dlya-kiya/strana-proizvodstva/ukraina/tverdost-po-shoru/78/92/84/80/88/89/94/', `referer` = 'https://abricol.com.ua/aksessuary-dlya-bilyarda/nakleyki-i-nakonechniki-dlya-kiya/strana-proizvodstva/ukraina/tverdost-po-shoru/78/92/84/80/88/89/94', `date_added` = '2024-10-08 01:53:39'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/tool/online.php:6
197 (2.763)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/footer'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
198 (22.734)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/setting/extension.php:4
199 (44.634)
SELECT status
FROM oc_modification
WHERE `code`='NS > CALLBACK'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/ns/moduleonoff.php:4
200 (1.380)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'ns/newstorelang' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
201 (2.342)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
202 (1.281)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
203 (1.376)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 55 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
204 (0.437)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 12 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
205 (0.360)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 11 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
206 (0.324)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 13 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
207 (0.875)
SELECT c.`category_id`, cd.`name`
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 = '55'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
208 (4.054)
SELECT c.`category_id`, cd.`name`
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 = '56'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
209 (1.521)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 56
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
210 (0.629)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
211 (1.018)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
212 (0.898)
SELECT c.`category_id`, cd.`name`
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 = '57'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
213 (0.589)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 57
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
214 (0.290)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
215 (19.981)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
216 (0.475)
SELECT c.`category_id`, cd.`name`
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 = '58'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
217 (0.376)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 58
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
218 (0.115)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
219 (0.302)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
220 (1.596)
SELECT c.`category_id`, cd.`name`
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 = '60'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
221 (0.952)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 60
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
222 (3.303)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
223 (0.560)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
224 (2.479)
SELECT c.`category_id`, cd.`name`
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 = '61'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
225 (0.112)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 61
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
226 (0.276)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
227 (0.287)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
228 (0.583)
SELECT c.`category_id`, cd.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '65'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
229 (0.317)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 65
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
230 (0.264)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
231 (0.278)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
232 (0.554)
SELECT c.`category_id`, cd.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '67'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
233 (0.283)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 67
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
234 (0.303)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
235 (0.258)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
236 (0.893)
SELECT c.`category_id`, cd.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '69'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
237 (0.305)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 69
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
238 (0.283)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
239 (0.286)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
240 (1.195)
SELECT c.`category_id`, cd.`name`
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 = '70'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
241 (1.172)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 70
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
242 (0.302)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
243 (0.269)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
244 (4.649)
SELECT c.`category_id`, cd.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '71'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
245 (2.373)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 71
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
246 (0.375)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
247 (0.329)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
248 (10.877)
SELECT c.`category_id`, cd.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '73'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
249 (0.568)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 73
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
250 (1.077)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
251 (0.449)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
252 (0.322)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 55
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
253 (2.054)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
254 (0.420)
SELECT c.`category_id`, cd.`name`
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 = '12'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
255 (5.595)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 12
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
256 (0.625)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
257 (8.894)
SELECT c.`category_id`, cd.`name`
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 = '11'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
258 (0.572)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 11
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
259 (0.150)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
260 (4.083)
SELECT c.`category_id`, cd.`name`
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 = '13'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
261 (0.762)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 13
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
262 (0.124)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 2
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
263 (0.433)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 18 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
264 (0.358)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 17 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
265 (0.349)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 77 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
266 (0.346)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 19 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
267 (0.328)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 20 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
268 (0.350)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 21 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
269 (0.339)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 23 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
270 (0.331)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 25 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
271 (0.404)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 26 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
272 (0.418)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 90 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
273 (0.527)
SELECT c.`category_id`, cd.`name`
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 = '18'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
274 (0.531)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 18
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
275 (0.114)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 3
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
276 (0.411)
SELECT c.`category_id`, cd.`name`
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 = '17'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
277 (0.719)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 17
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
278 (0.131)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 3
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
279 (0.547)
SELECT c.`category_id`, cd.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '77'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
280 (0.504)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 77
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
281 (0.116)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 3
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
282 (0.827)
SELECT c.`category_id`, cd.`name`
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 = '19'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
283 (0.488)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 19
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
284 (1.686)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 3
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
285 (0.940)
SELECT c.`category_id`, cd.`name`
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 = '20'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
286 (0.149)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 20
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
287 (0.293)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 3
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
288 (0.755)
SELECT c.`category_id`, cd.`name`
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 = '21'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
289 (0.116)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 21
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
290 (0.295)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 3
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
291 (0.643)
SELECT c.`category_id`, cd.`name`
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 = '23'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
292 (0.200)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 23
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
293 (1.423)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 3
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
294 (0.759)
SELECT c.`category_id`, cd.`name`
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 = '25'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
295 (0.120)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 25
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
296 (0.293)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 3
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
297 (0.744)
SELECT c.`category_id`, cd.`name`
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 = '26'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
298 (0.135)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 26
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
299 (0.478)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 3
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
300 (2.346)
SELECT c.`category_id`, cd.`name`
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 = '90'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
301 (0.143)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 90
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
302 (0.119)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 3
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
303 (1.371)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 10 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
304 (0.343)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 9 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
305 (0.388)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 14 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
306 (5.360)
SELECT c.`category_id`, cd.`name`
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 = '10'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
307 (2.316)
SELECT c.`category_id`, cd.`name`
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 = '45'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
308 (1.109)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 45
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
309 (1.899)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 10
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
310 (1.219)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
311 (1.249)
SELECT c.`category_id`, cd.`name`
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 = '46'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
312 (0.892)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 46
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
313 (0.338)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 10
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
314 (4.133)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
315 (13.772)
SELECT c.`category_id`, cd.`name`
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 = '47'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
316 (0.131)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 47
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
317 (0.341)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 10
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
318 (0.108)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
319 (0.548)
SELECT c.`category_id`, cd.`name`
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 = '81'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
320 (0.451)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 81
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
321 (0.289)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 10
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
322 (1.320)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
323 (12.899)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 10
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
324 (0.433)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
325 (2.227)
SELECT c.`category_id`, cd.`name`
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 = '9'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
326 (2.856)
SELECT c.`category_id`, cd.`name`
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 = '39'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
327 (0.125)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 39
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
328 (0.106)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 9
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
329 (0.273)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
330 (0.906)
SELECT c.`category_id`, cd.`name`
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 = '40'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
331 (0.139)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 40
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
332 (0.267)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 9
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
333 (0.262)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
334 (1.613)
SELECT c.`category_id`, cd.`name`
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 = '41'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
335 (0.123)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 41
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
336 (0.301)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 9
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
337 (0.266)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
338 (0.753)
SELECT c.`category_id`, cd.`name`
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 = '42'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
339 (0.115)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 42
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
340 (1.743)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 9
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
341 (0.276)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
342 (2.112)
SELECT c.`category_id`, cd.`name`
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 = '54'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
343 (0.126)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 54
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
344 (0.269)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 9
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
345 (0.279)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
346 (0.701)
SELECT c.`category_id`, cd.`name`
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 = '79'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
347 (0.121)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 79
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
348 (0.297)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 9
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
349 (0.429)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
350 (2.613)
SELECT c.`category_id`, cd.`name`
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 = '80'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
351 (0.118)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 80
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
352 (10.353)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 9
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
353 (0.735)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
354 (1.995)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 9
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
355 (0.309)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
356 (0.651)
SELECT c.`category_id`, cd.`name`
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 = '14'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
357 (2.822)
SELECT c.`category_id`, cd.`name`
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 = '82'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
358 (0.133)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 82
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
359 (0.312)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 14
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
360 (0.311)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
361 (0.768)
SELECT c.`category_id`, cd.`name`
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 = '83'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
362 (0.116)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 83
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
363 (0.107)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 14
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
364 (1.155)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
365 (0.852)
SELECT c.`category_id`, cd.`name`
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 = '84'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
366 (0.108)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 84
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
367 (0.303)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 14
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
368 (0.683)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
369 (1.759)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 14
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
370 (0.138)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
371 (2.609)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 15 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
372 (0.367)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 72 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
373 (0.431)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 51 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
374 (0.407)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 52 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
375 (0.325)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 53 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
376 (1.265)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 78 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
377 (0.584)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 16 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
378 (4.886)
SELECT c.`category_id`, cd.`name`
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 = '15'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
379 (0.347)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 15
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
380 (1.936)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 5
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
381 (1.933)
SELECT c.`category_id`, cd.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '72'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
382 (0.116)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 72
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
383 (0.387)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 5
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
384 (0.566)
SELECT c.`category_id`, cd.`name`
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 = '51'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
385 (0.309)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 51
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
386 (0.624)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 5
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
387 (1.693)
SELECT c.`category_id`, cd.`name`
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 = '52'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
388 (0.326)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 52
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
389 (0.462)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 5
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
390 (0.403)
SELECT c.`category_id`, cd.`name`
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 = '53'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
391 (1.448)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 53
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
392 (0.483)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 5
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
393 (0.374)
SELECT c.`category_id`, cd.`name`
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 = '78'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
394 (0.295)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 78
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
395 (0.693)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 5
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
396 (1.405)
SELECT c.`category_id`, cd.`name`
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 = '16'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
397 (1.506)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 16
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
398 (0.359)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 5
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
399 (1.343)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 31 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
400 (0.448)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 30 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
401 (0.378)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 29 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
402 (1.771)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 28 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
403 (0.333)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 68 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
404 (0.568)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 32 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
405 (1.414)
SELECT c.`category_id`, cd.`name`
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 = '31'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
406 (0.195)
SELECT c.`category_id`, cd.`name`
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 = '88'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
407 (0.319)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 88
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
408 (0.293)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 31
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
409 (0.286)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 8
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
410 (0.691)
SELECT c.`category_id`, cd.`name`
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 = '89'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
411 (3.388)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 89
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
412 (1.832)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 31
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
413 (0.124)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 8
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
414 (0.744)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 31
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
415 (0.114)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 8
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
416 (0.561)
SELECT c.`category_id`, cd.`name`
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 = '30'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
417 (0.464)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 30
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
418 (0.124)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 8
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
419 (11.590)
SELECT c.`category_id`, cd.`name`
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 = '29'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
420 (23.819)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 29
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
421 (1.430)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 8
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
422 (0.465)
SELECT c.`category_id`, cd.`name`
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 = '28'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
423 (0.350)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 28
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
424 (0.502)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 8
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
425 (0.403)
SELECT c.`category_id`, cd.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '68'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
426 (1.763)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 68
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
427 (0.917)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 8
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
428 (8.220)
SELECT c.`category_id`, cd.`name`
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 = '32'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
429 (0.157)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 32
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
430 (0.149)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 8
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
431 (0.720)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 33 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
432 (2.551)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 34 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
433 (0.433)
SELECT c.`category_id`, cd.`name`
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 = '33'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
434 (0.304)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 33
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
435 (0.762)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 6
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
436 (0.214)
SELECT c.`category_id`, cd.`name`
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 = '34'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
437 (0.130)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 34
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
438 (0.340)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 6
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
439 (2.592)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 36 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
440 (0.361)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 37 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
441 (0.557)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 38 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
442 (0.180)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 63 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
443 (0.370)
SELECT c.`category_id`, cd.`name`
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 = '36'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
444 (0.279)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 36
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
445 (0.540)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 35
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
446 (0.389)
SELECT c.`category_id`, cd.`name`
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 = '37'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
447 (0.296)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 37
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
448 (1.413)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 35
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
449 (0.587)
SELECT c.`category_id`, cd.`name`
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 = '38'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
450 (0.111)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 38
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
451 (0.736)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 35
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
452 (8.148)
SELECT c.`category_id`, cd.`name`
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 = '63'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
453 (0.512)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 63
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
454 (0.322)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 35
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
455 (1.014)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 49 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
456 (0.185)
SELECT c.`category_id`, cd.`name`
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 = '49'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
457 (0.360)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 49
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
458 (0.353)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 48
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
459 (0.928)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 86 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
460 (0.501)
SELECT c.`category_id`,c.`image`, cd2.`name`
FROM oc_category c
LEFT JOIN oc_category_description cd2 ON (c.`category_id` = cd2.`category_id`)
WHERE c.`category_id` = 87 AND cd2.language_id = 1
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:215
461 (1.464)
SELECT c.`category_id`, cd.`name`
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 = '86'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
462 (0.144)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 86
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
463 (0.111)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 85
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
464 (0.181)
SELECT c.`category_id`, cd.`name`
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 = '87'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:225
465 (0.116)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 87
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
466 (0.126)
SELECT c.`category_id`,c.`parent_id`
FROM oc_category c
WHERE c.`category_id` = 85
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/extension/module/nsmenu.php:205
467 (2.508)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' AND i.is_service = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/information.php:17
468 (14.918)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '78412ada876bccb533b556246b'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/cart.php:51
469 (0.544)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
470 (1.469)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/localisation/language.php:15
471 (0.201)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/language'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
472 (15.051)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
473 (2.860)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/currency'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
474 (10.562)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
475 (8.014)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'ns/newstorelang' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
476 (8.978)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
477 (1.492)
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 = '2' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
478 (3.178)
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 = '3' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
479 (0.902)
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 = '1' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
480 (11.366)
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 = '5' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
481 (2.911)
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 = '8' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
482 (0.673)
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 = '4' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
483 (1.267)
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 = '6' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
484 (6.704)
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 = '35' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
485 (4.088)
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 = '48' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
486 (0.771)
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 = '85' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
487 (12.904)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
488 (0.174)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/search'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
489 (6.563)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
490 (22.474)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '78412ada876bccb533b556246b'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/cart.php:51
491 (9.131)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/setting/extension.php:4
492 (14.177)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
493 (0.298)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '78412ada876bccb533b556246b'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/cart.php:51
494 (0.244)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '78412ada876bccb533b556246b'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/cart.php:51
495 (0.279)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '78412ada876bccb533b556246b'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/cart.php:51
496 (14.403)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
497 (0.148)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/customer.php:129
498 (0.150)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
499 (0.263)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '78412ada876bccb533b556246b'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/cart.php:51
500 (0.240)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '78412ada876bccb533b556246b'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/cart.php:51
501 (0.446)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '78412ada876bccb533b556246b'
/var/www/abricol.com.ua/data/www/abricol.com.ua/system/library/cart/cart.php:51
502 (4.728)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/cart'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
503 (0.438)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/translation.php:6
504 (5.231)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/catalog/category.php:10
505 (0.430)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/menu'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
506 (49.868)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'common/header'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
507 (27.999)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'newstore' AND route = 'product/category'
/var/www/abricol.com.ua/data/www/abricol.com.ua/catalog/model/design/theme.php:4
