1 (6.115)
SELECT *
FROM `oc_setting`
/var/www/www-root/data/www/4profi.by/index.php:44
2 (7.836)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/www-root/data/www/4profi.by/index.php:155
3 (6.370)
SELECT *
FROM oc_currency
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/currency.php:14
4 (2.060)
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 = '13' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/www-root/data/www/4profi.by/system/library/tax.php:54
5 (0.283)
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/www-root/data/www/4profi.by/system/library/weight.php:9
6 (0.182)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/var/www/www-root/data/www/4profi.by/system/library/length.php:9
7 (0.238)
DELETE
FROM oc_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:83
8 (0.142)
SELECT *
FROM oc_event
/var/www/www-root/data/www/4profi.by/index.php:253
9 (6.402)
SELECT GROUP_CONCAT(REPLACE(`query`, 'category_id=', '')
ORDER BY FIELD(keyword, 'vsyo-dlya-manikyura-i-pedikyura', 'professionalnye-pilki-dlya-nogtej', 'pilki-dlya-nogtej-super-nail') SEPARATOR '_') AS path
FROM oc_url_alias
WHERE `query` LIKE 'category_id=%' AND (keyword = 'vsyo-dlya-manikyura-i-pedikyura' OR keyword = 'professionalnye-pilki-dlya-nogtej' OR keyword = 'pilki-dlya-nogtej-super-nail')
/var/www/www-root/data/www/4profi.by/catalog/controller/module/ocfilter.php:720
10 (8.570)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = 'vsyo-dlya-manikyura-i-pedikyura' LIMIT 1
/var/www/www-root/data/www/4profi.by/catalog/controller/module/ocfilter.php:744
11 (3.526)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = 'professionalnye-pilki-dlya-nogtej' LIMIT 1
/var/www/www-root/data/www/4profi.by/catalog/controller/module/ocfilter.php:744
12 (0.233)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND keyword = 'pilki-dlya-nogtej-super-nail' LIMIT 1
/var/www/www-root/data/www/4profi.by/catalog/controller/module/ocfilter.php:744
13 (8.641)
SELECT value_id, option_id, total
FROM (SELECT p.manufacturer_id AS value_id, 'm' AS option_id, COUNT(p.manufacturer_id) AS total
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p2c.category_id = '362' GROUP BY p.manufacturer_id UNION ALL SELECT IF(p.quantity > '0', 'in', 'out') AS value_id, 's' AS option_id, COUNT(*) AS total
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p2c.category_id = '362' GROUP BY value_id UNION ALL SELECT oov2p.value_id, oov2p.option_id, COUNT(p.product_id) AS total
FROM oc_ocfilter_option_value_to_product oov2p
LEFT JOIN oc_product_to_category p2c ON (oov2p.product_id = p2c.product_id)
LEFT JOIN oc_product p ON (oov2p.product_id = p.product_id)
WHERE oov2p.value_id > '0' AND p.status = '1' AND p2c.category_id = '362' GROUP BY oov2p.option_id, oov2p.value_id) results
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/ocfilter.php:301
14 (0.782)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1'
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/ocfilter.php:471
15 (4.685)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/var/www/www-root/data/www/4profi.by/catalog/model/setting/setting.php:6
16 (0.386)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '30' AND c.status = '1'
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/category.php:4
17 (0.258)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '74' AND c.status = '1'
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/category.php:4
18 (0.237)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.category_id = '362' AND c.status = '1'
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/category.php:4
19 (0.224)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '362' AND c.status = '1'
ORDER BY c.sort_order, cd.name
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/category.php:10
20 (45.221)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND cp.path_id = '362'
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:554
21 (103.260)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ((ps.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_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND cp.path_id = '362' GROUP BY p.product_id
ORDER BY p.sort_order ASC, pd.name ASC LIMIT 0,28
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:241
22 (5.606)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1387' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
23 (6.533)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1389' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
24 (6.525)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1391' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
25 (2.203)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1393' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
26 (12.893)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1395' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
27 (7.005)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1351' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
28 (3.897)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1355' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
29 (11.828)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1357' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
30 (5.878)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1383' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
31 (2.612)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1359' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
32 (9.384)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1361' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
33 (2.371)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1363' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
34 (5.238)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1366' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
35 (2.233)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1367' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
36 (5.584)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1368' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
37 (2.726)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1381' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
38 (5.621)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1365' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
39 (3.443)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1369' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
40 (2.118)
SELECT DISTINCT *, pd.name AS name, 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id) AS points_reward, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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, NULL 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, 'г' AS weight_class, 'см' AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1370' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/var/www/www-root/data/www/4profi.by/system/storage/modification/catalog/model/catalog/product.php:26
41 (0.293)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1387'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
42 (0.230)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1387' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
43 (0.567)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1389'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
44 (0.344)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1389' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
45 (0.236)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1391'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
46 (0.238)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1391' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
47 (0.228)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1393'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
48 (0.189)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1393' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
49 (0.224)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1395'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
50 (0.183)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1395' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
51 (0.214)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1351'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
52 (0.197)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1351' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
53 (0.217)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1355'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
54 (0.210)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1355' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
55 (0.225)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1357'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
56 (0.181)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1357' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
57 (0.212)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1383'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
58 (0.192)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1383' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
59 (0.218)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1359'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
60 (0.181)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1359' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
61 (0.231)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1361'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
62 (0.185)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1361' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
63 (0.218)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1363'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
64 (0.180)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1363' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
65 (0.220)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1366'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
66 (0.219)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1366' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
67 (0.215)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1367'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
68 (0.193)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1367' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
69 (0.217)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1368'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
70 (0.179)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1368' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
71 (0.218)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1381'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
72 (0.180)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1381' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
73 (0.218)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1365'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
74 (0.198)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1365' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
75 (0.209)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1369'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
76 (0.187)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1369' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
77 (0.252)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1370'
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:9
78 (0.184)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1370' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/promotion_label_product.php:138
79 (3.223)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/var/www/www-root/data/www/4profi.by/catalog/model/setting/setting.php:6
80 (0.839)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '362' AND store_id = '0'
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/category.php:62
81 (0.280)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/www-root/data/www/4profi.by/catalog/model/design/layout.php:4
82 (0.209)
SELECT *
FROM oc_layout_module
WHERE layout_id = '10' AND position = 'column_left'
ORDER BY sort_order
/var/www/www-root/data/www/4profi.by/catalog/model/design/layout.php:14
83 (2.772)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/var/www/www-root/data/www/4profi.by/catalog/model/setting/setting.php:6
84 (0.156)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '362' AND store_id = '0'
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/category.php:62
85 (0.190)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/www-root/data/www/4profi.by/catalog/model/design/layout.php:4
86 (0.181)
SELECT *
FROM oc_layout_module
WHERE layout_id = '10' AND position = 'column_right'
ORDER BY sort_order
/var/www/www-root/data/www/4profi.by/catalog/model/design/layout.php:14
87 (0.125)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '362' AND store_id = '0'
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/category.php:62
88 (0.163)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/www-root/data/www/4profi.by/catalog/model/design/layout.php:4
89 (0.170)
SELECT *
FROM oc_layout_module
WHERE layout_id = '10' AND position = 'content_top'
ORDER BY sort_order
/var/www/www-root/data/www/4profi.by/catalog/model/design/layout.php:14
90 (0.117)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '362' AND store_id = '0'
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/category.php:62
91 (0.166)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/www-root/data/www/4profi.by/catalog/model/design/layout.php:4
92 (0.171)
SELECT *
FROM oc_layout_module
WHERE layout_id = '10' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/www-root/data/www/4profi.by/catalog/model/design/layout.php:14
93 (3.019)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/var/www/www-root/data/www/4profi.by/catalog/model/setting/setting.php:6
94 (2.831)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/var/www/www-root/data/www/4profi.by/catalog/model/setting/setting.php:6
95 (0.510)
SELECT *
FROM oc_banner_image bi
LEFT JOIN oc_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id)
WHERE bi.banner_id = '-99' AND bid.language_id = '1'
ORDER BY bi.sort_order ASC
/var/www/www-root/data/www/4profi.by/catalog/model/design/banner.php:4
96 (0.590)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
WHERE i.status = '1'
ORDER BY i.sort_order, id.title ASC
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/information.php:10
97 (0.238)
SELECT *
FROM oc_xdstickers
ORDER BY xdsticker_id ASC
/var/www/www-root/data/www/4profi.by/catalog/model/module/xdstickers.php:51
98 (0.296)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/www-root/data/www/4profi.by/catalog/model/extension/extension.php:4
99 (2.969)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/var/www/www-root/data/www/4profi.by/catalog/model/setting/setting.php:6
100 (1.477)
SELECT c.*,cd.name
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.status = '1'
ORDER BY c.parent_id DESC, c.sort_order, cd.name
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/category.php:11
101 (2.908)
SELECT c.*,cd.name
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.status = '1'
ORDER BY c.parent_id DESC, c.sort_order, cd.name
/var/www/www-root/data/www/4profi.by/catalog/model/catalog/category.php:11
102 (0.560)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:304
103 (0.279)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1' GROUP BY product_id
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:306
104 (3.602)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:7
105 (0.487)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/www-root/data/www/4profi.by/catalog/model/extension/extension.php:4
106 (0.284)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:304
107 (0.325)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1' GROUP BY product_id
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:306
108 (3.557)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:7
109 (3.718)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/var/www/www-root/data/www/4profi.by/catalog/model/setting/setting.php:6
110 (0.392)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:304
111 (0.259)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1' GROUP BY product_id
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:306
112 (3.708)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:7
113 (0.380)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:304
114 (0.254)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1' GROUP BY product_id
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:306
115 (3.703)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:7
116 (0.369)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/www-root/data/www/4profi.by/system/library/customer.php:129
117 (0.307)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:304
118 (0.242)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1' GROUP BY product_id
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:306
119 (3.106)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:7
120 (0.353)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:304
121 (0.304)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1' GROUP BY product_id
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:306
122 (4.012)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:7
123 (0.356)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:304
124 (0.280)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'vq487e0tcnsj5tl7qgso6q5ln1' GROUP BY product_id
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:306
125 (3.813)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/var/www/www-root/data/www/4profi.by/system/storage/modification/system/library/cart.php:7
+375 (29) 639-40-09 
+375 (29) 573-39-53 
Призма: 10:00 - 22:00 
Сервисный центр: Ольшевского 20 - 17 
