TELEGRAM Рассрочка BABETTA NEW WHITE COSMETICS Bonus Babyliss Pro Elipstyle 3500 Рассрочка
Кисть-сметка EUROstil Barber Line черная
Хит продаж!
-4%
Масло для смазки машинок BABETTA 118 мл
Новинка!
-15%
Машинка Babetta 624 -9%

Машинка Babetta 624

 271.25 руб.  248.00 руб.
Машинка Babetta Classic 625
Новинка!
-9%

Машинка Babetta Classic 625

 253.75 руб.  232.00 руб.
Машинка BABYLISS PRO BOOST+ BLACK FX8700RBPE
Новинка!
-9%

Машинка BABYLISS PRO BOOST+ BLACK FX8700RBPE

 612.50 руб.  560.00 руб.
Машинка BABYLISS PRO BOOST+ Chameleon FX8700IBPE
Новинка!
-9%
Машинка BABYLISS PRO BOOST+ GOLD (FX8700GBPE)
Новинка!
-9%

Машинка BABYLISS PRO BOOST+ GOLD (FX8700GBPE)

 612.50 руб.  560.00 руб.
Машинка JRL ONYX FF2020C-B
Новинка!
-10%

Машинка JRL ONYX FF2020C-B

 769.00 руб.  690.00 руб.
Машинка JRL ONYX FF2020C-B-W GHOST
Новинка!
-10%

Машинка JRL ONYX FF2020C-B-W GHOST

 769.00 руб.  690.00 руб.
Набор фен JRL Forte PRO 2020H + 2 расчески
Новинка!
-7%
Плойка Babetta Classic 25мм длинная 500-25
Новинка!
-21%
Плойка Babetta Classic 32мм длинная 500-32
Новинка!
-21%
Плойка BaByliss Pro 19мм BAB2172TTE -9%

Плойка BaByliss Pro 19мм BAB2172TTE

 192.50 руб.  176.00 руб.
Плойка BaByliss Pro 25мм BAB2173TTE
Хит продаж!
-9%

Плойка BaByliss Pro 25мм BAB2173TTE

 192.50 руб.  176.00 руб.
Плойка BaByliss Pro 25мм длинная BAB2473TDE -9%
Плойка BaByliss Pro 25мм цифровая BAB2273TTE -9%
Плойка BaByliss Pro 32мм BAB2174TTE
Хит продаж!
-9%

Плойка BaByliss Pro 32мм BAB2174TTE

 192.50 руб.  176.00 руб.
Плойка BaByliss Pro 32мм длинная BAB2474TDE
Хит продаж!
-9%
Плойка BaByliss Pro 32мм цифровая BAB2274TTE -9%
Плойка BaByliss Pro 38мм цифровая BAB2275TTE -9%
Плойка BaByliss Pro конусная 13-25мм BAB2280TTE -9%
Плойка BaByliss Pro конусная 19-32мм BAB2281TTE
Хит продаж!
-9%
  Хиты продаж
Щеточка для фейда пластиковая -33%
Фен Babyliss Pro CARUSO ionic 2400W BAB6510IRE
Хит продаж!
-9%

Фен Babyliss Pro CARUSO ionic 2400W BAB6510IRE

 253.75 руб.  232.00 руб.
Утюжок BaByliss Pro ELIPSIS3100 BAB3100EPE 24 мм
Хит продаж!
-9%
Утюжок BaByliss Pro ELIPSIS3000 BAB3000EPE 31 мм
Хит продаж!
-9%
Фен Babyliss Pro VENEZIANO ionic 2200W BAB6610INRE
Хит продаж!
-9%

Фен Babyliss Pro VENEZIANO ionic 2200W BAB6610INRE

 218.75 руб.  199.00 руб.
Фен Babyliss Pro Prodigio ionic 2300W BAB6730IRE -9%

Фен Babyliss Pro Prodigio ionic 2300W BAB6730IRE

 236.25 руб.  216.00 руб.
Фен Babyliss Pro EXCESS HQ 2600W BAB6990IE
Хит продаж!
-9%

Фен Babyliss Pro EXCESS HQ 2600W BAB6990IE

 350.00 руб.  320.00 руб.
Кисть-сметка EUROstil Barber Line черная
Хит продаж!
-4%
Утюжок BaByliss Pro Dry & Wet BAB2073EPE 38 мм
Хит продаж!
-9%

Утюжок BaByliss Pro Dry & Wet BAB2073EPE 38 мм

 315.00 руб.  288.00 руб.
Фен Babyliss Pro STELLATO DIGITAL 2400W BAB7500IE
Хит продаж!
-9%
Спрей охлаждающий Andis Cool Care Plus 5в1 439мл
Хит продаж!
Утюжок для волос Babyliss Pro BAB2654EPE 25 мм
Хит продаж!
-9%
Плойка BaByliss Pro конусная 19-32мм BAB2281TTE
Хит продаж!
-9%
Масло для смазки машинок Andis 118 мл
Хит продаж!
  НОВИНКИ
Queries: 257, Total time: 150.994 ms [By time] [By id] [By file]
1 (2.672)
SELECT *
FROM `oc_setting`
/home/a4profiby/public_html/index.php:44
2 (0.161)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/a4profiby/public_html/index.php:155
3 (0.105)
SELECT *
FROM oc_currency
/home/a4profiby/public_html/system/storage/modification/system/library/currency.php:14
4 (0.228)
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
/home/a4profiby/public_html/system/library/tax.php:54
5 (0.148)
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'
/home/a4profiby/public_html/system/library/weight.php:9
6 (0.100)
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'
/home/a4profiby/public_html/system/library/length.php:9
7 (0.169)
DELETE
FROM oc_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:83
8 (0.083)
SELECT *
FROM oc_event
/home/a4profiby/public_html/index.php:253
9 (1.180)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/home/a4profiby/public_html/catalog/model/setting/setting.php:6
10 (0.144)
SELECT *
FROM oc_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/a4profiby/public_html/catalog/model/design/layout.php:4
11 (0.117)
SELECT *
FROM oc_layout_module
WHERE layout_id = '1' AND position = 'column_left'
ORDER BY sort_order
/home/a4profiby/public_html/catalog/model/design/layout.php:14
12 (1.132)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/home/a4profiby/public_html/catalog/model/setting/setting.php:6
13 (0.107)
SELECT *
FROM oc_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/a4profiby/public_html/catalog/model/design/layout.php:4
14 (0.107)
SELECT *
FROM oc_layout_module
WHERE layout_id = '1' AND position = 'column_right'
ORDER BY sort_order
/home/a4profiby/public_html/catalog/model/design/layout.php:14
15 (0.100)
SELECT *
FROM oc_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/a4profiby/public_html/catalog/model/design/layout.php:4
16 (0.116)
SELECT *
FROM oc_layout_module
WHERE layout_id = '1' AND position = 'content_top'
ORDER BY sort_order
/home/a4profiby/public_html/catalog/model/design/layout.php:14
17 (0.090)
SELECT *
FROM oc_module
WHERE module_id = '41'
/home/a4profiby/public_html/catalog/model/extension/module.php:4
18 (0.062)
SELECT *
FROM oc_module
WHERE module_id = '27'
/home/a4profiby/public_html/catalog/model/extension/module.php:4
19 (0.289)
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 = '7' AND bid.language_id = '1'
ORDER BY bi.sort_order ASC
/home/a4profiby/public_html/catalog/model/design/banner.php:4
20 (0.078)
SELECT *
FROM oc_module
WHERE module_id = '61'
/home/a4profiby/public_html/catalog/model/extension/module.php:4
21 (0.076)
SELECT *
FROM oc_module
WHERE module_id = '35'
/home/a4profiby/public_html/catalog/model/extension/module.php:4
22 (1.145)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/home/a4profiby/public_html/catalog/model/setting/setting.php:6
23 (2.158)
SELECT DISTINCT ps.product_id, (SELECT AVG(rating)
FROM oc_review r1
WHERE r1.product_id = ps.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '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())) GROUP BY ps.product_id
ORDER BY pd.name ASC, pd.name ASC LIMIT 0,50
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:291
24 (1.547)
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 = '1925' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
25 (1.418)
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 = '6696' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
26 (1.368)
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 = '6079' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
27 (1.368)
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 = '6569' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
28 (1.305)
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 = '6572' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
29 (1.287)
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 = '6571' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
30 (1.289)
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 = '6565' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
31 (1.272)
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 = '6563' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
32 (1.307)
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 = '6567' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
33 (1.333)
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 = '9277' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
34 (1.314)
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 = '9315' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
35 (1.319)
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 = '8995' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
36 (1.318)
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 = '9126' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
37 (1.321)
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 = '9125' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
38 (1.304)
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 = '9226' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
39 (1.298)
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 = '9484' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
40 (1.310)
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 = '9637' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
41 (1.398)
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 = '6305' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
42 (1.407)
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 = '9670' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
43 (1.373)
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 = '6316' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
44 (1.350)
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 = '7532' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
45 (1.341)
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 = '7544' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
46 (1.351)
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 = '7546' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
47 (1.334)
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 = '7545' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
48 (1.324)
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 = '7522' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
49 (1.332)
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 = '7523' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
50 (1.321)
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 = '7533' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
51 (1.343)
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 = '7535' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
52 (1.326)
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 = '7547' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
53 (1.324)
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 = '7536' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
54 (1.298)
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 = '7538' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
55 (1.306)
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 = '7537' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
56 (1.311)
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 = '7530' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
57 (1.326)
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 = '7539' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
58 (1.324)
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 = '7557' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
59 (1.328)
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 = '7558' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
60 (1.322)
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 = '7543' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
61 (1.517)
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 = '8648' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
62 (2.052)
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 = '8649' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
63 (1.733)
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 = '2121' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
64 (1.448)
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 = '2122' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
65 (1.375)
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 = '5951' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
66 (1.367)
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 = '2129' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
67 (1.357)
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 = '2123' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
68 (1.335)
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 = '5952' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
69 (1.358)
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 = '2130' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
70 (1.370)
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 = '2131' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
71 (1.334)
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 = '4266' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
72 (1.340)
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 = '2125' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
73 (1.343)
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 = '2126' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
74 (0.669)
SELECT `xdsticker_id`,`product_id`
FROM oc_xdstickers_product
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:18
75 (0.131)
SELECT *
FROM oc_xdstickers
ORDER BY xdsticker_id ASC
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:51
76 (0.158)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1925' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
77 (0.127)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6696' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
78 (0.141)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '6079'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
79 (0.109)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6079' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
80 (0.104)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6569' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
81 (0.102)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6572' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
82 (0.099)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6571' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
83 (0.100)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6565' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
84 (0.102)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6563' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
85 (0.098)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6567' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
86 (0.135)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9277'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
87 (0.101)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9277' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
88 (0.101)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9315' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
89 (0.130)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '8995'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
90 (0.102)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '8995' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
91 (0.129)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9126'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
92 (0.102)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9126' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
93 (0.127)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9125'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
94 (0.101)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9125' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
95 (0.129)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9226'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
96 (0.103)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9226' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
97 (0.127)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9484'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
98 (0.099)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9484' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
99 (0.129)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9637'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
100 (0.099)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9637' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
101 (0.100)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6305' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
102 (0.129)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9670'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
103 (0.099)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9670' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
104 (0.108)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6316' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
105 (0.099)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7532' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
106 (0.099)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7544' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
107 (0.095)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7546' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
108 (0.110)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7545' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
109 (0.105)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7522' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
110 (0.102)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7523' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
111 (0.090)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7533' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
112 (0.094)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7535' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
113 (0.107)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7547' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
114 (0.091)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7536' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
115 (0.093)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7538' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
116 (0.089)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7537' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
117 (0.088)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7530' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
118 (0.089)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7539' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
119 (0.092)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7557' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
120 (0.091)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7558' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
121 (0.089)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '7543' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
122 (0.137)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '8648'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
123 (0.096)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '8648' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
124 (0.129)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '8649'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
125 (0.098)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '8649' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
126 (0.096)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2121' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
127 (0.130)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '2122'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
128 (0.100)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2122' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
129 (0.099)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '5951' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
130 (0.097)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2129' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
131 (0.132)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '2123'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
132 (0.099)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2123' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
133 (0.131)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '5952'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
134 (0.099)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '5952' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
135 (0.098)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2130' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
136 (0.096)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2131' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
137 (0.098)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '4266' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
138 (0.098)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2125' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
139 (0.136)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '2126'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
140 (0.100)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2126' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
141 (0.164)
SELECT *
FROM oc_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/a4profiby/public_html/catalog/model/design/layout.php:4
142 (0.124)
SELECT *
FROM oc_layout_module
WHERE layout_id = '1' AND position = 'content_bottom'
ORDER BY sort_order
/home/a4profiby/public_html/catalog/model/design/layout.php:14
143 (0.079)
SELECT *
FROM oc_module
WHERE module_id = '34'
/home/a4profiby/public_html/catalog/model/extension/module.php:4
144 (1.191)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/home/a4profiby/public_html/catalog/model/setting/setting.php:6
145 (0.470)
SELECT `xdsticker_id`,`product_id`
FROM oc_xdstickers_product
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:18
146 (0.114)
SELECT *
FROM oc_xdstickers
ORDER BY xdsticker_id ASC
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:51
147 (0.129)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '6017'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
148 (0.144)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6017' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
149 (0.103)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2222' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
150 (0.095)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6309' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
151 (0.127)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1989'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
152 (0.097)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1989' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
153 (0.096)
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())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
154 (0.125)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '6059'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
155 (0.096)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6059' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
156 (0.123)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '4267'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
157 (0.095)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '4267' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
158 (0.123)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '6276'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
159 (0.095)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6276' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
160 (0.122)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1987'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
161 (0.095)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1987' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
162 (0.092)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1984' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
163 (0.129)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '6422'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
164 (0.095)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6422' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
165 (0.121)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '6308'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
166 (0.092)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6308' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
167 (0.123)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1752'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
168 (0.096)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1752' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
169 (0.122)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '6079'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
170 (0.093)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6079' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
171 (0.121)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '2137'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
172 (0.092)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2137' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
173 (0.127)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '6285'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
174 (0.094)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '6285' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
175 (0.121)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1816'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
176 (0.092)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1816' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
177 (0.123)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '2139'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
178 (0.092)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2139' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
179 (0.123)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '2126'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
180 (0.092)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '2126' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
181 (0.120)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '1817'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
182 (0.091)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '1817' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
183 (0.084)
SELECT *
FROM oc_module
WHERE module_id = '29'
/home/a4profiby/public_html/catalog/model/extension/module.php:4
184 (0.285)
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 = '8' AND bid.language_id = '1'
ORDER BY bi.sort_order ASC
/home/a4profiby/public_html/catalog/model/design/banner.php:4
185 (0.074)
SELECT *
FROM oc_module
WHERE module_id = '52'
/home/a4profiby/public_html/catalog/model/extension/module.php:4
186 (1.134)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/home/a4profiby/public_html/catalog/model/setting/setting.php:6
187 (17.149)
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_product p
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() GROUP BY p.product_id
ORDER BY p.date_added DESC, pd.name DESC LIMIT 0,15
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:241
188 (1.512)
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 = '9704' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
189 (1.348)
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 = '9703' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
190 (1.302)
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 = '9702' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
191 (1.293)
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 = '9701' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
192 (1.282)
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 = '9700' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
193 (1.351)
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 = '9699' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
194 (1.388)
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 = '9698' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
195 (1.302)
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 = '9697' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
196 (1.277)
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 = '9696' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
197 (1.285)
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 = '9695' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
198 (1.299)
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 = '9694' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
199 (1.291)
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 = '9693' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
200 (1.277)
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 = '9692' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
201 (1.268)
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 = '9691' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
202 (1.295)
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 = '9690' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
/home/a4profiby/public_html/system/storage/modification/catalog/model/catalog/product.php:26
203 (0.414)
SELECT `xdsticker_id`,`product_id`
FROM oc_xdstickers_product
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:18
204 (0.112)
SELECT *
FROM oc_xdstickers
ORDER BY xdsticker_id ASC
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:51
205 (0.129)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9704'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
206 (0.138)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9704' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
207 (0.135)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9703'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
208 (0.106)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9703' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
209 (0.125)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9702'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
210 (0.097)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9702' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
211 (0.122)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '9701'
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:9
212 (0.100)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9701' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
213 (0.095)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9700' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
214 (0.091)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9699' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
215 (0.089)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9698' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
216 (0.090)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9697' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
217 (0.088)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9696' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
218 (0.089)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9695' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
219 (0.087)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9694' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
220 (0.087)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9693' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
221 (0.088)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9692' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
222 (0.086)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9691' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
223 (0.088)
SELECT *
FROM oca_label_product olp
LEFT JOIN oca_label ol ON (olp.label_id = ol.label_id)
WHERE olp.product_id = '9690' AND (olp.date_start = '0000-00-00' OR olp.date_start < NOW()) AND (olp.date_end = '0000-00-00' OR olp.date_end > NOW())
/home/a4profiby/public_html/catalog/model/catalog/promotion_label_product.php:138
224 (1.169)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/home/a4profiby/public_html/catalog/model/setting/setting.php:6
225 (1.109)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/home/a4profiby/public_html/catalog/model/setting/setting.php:6
226 (0.236)
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
/home/a4profiby/public_html/catalog/model/design/banner.php:4
227 (0.392)
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
/home/a4profiby/public_html/catalog/model/catalog/information.php:10
228 (1.147)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/home/a4profiby/public_html/catalog/model/setting/setting.php:6
229 (0.115)
SELECT *
FROM oc_xdstickers
ORDER BY xdsticker_id ASC
/home/a4profiby/public_html/catalog/model/module/xdstickers.php:51
230 (0.165)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/a4profiby/public_html/catalog/model/extension/extension.php:4
231 (1.127)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'xds_coloring_theme'
/home/a4profiby/public_html/catalog/model/setting/setting.php:6
232 (0.824)
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
/home/a4profiby/public_html/catalog/model/catalog/category.php:11
233 (0.749)
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
/home/a4profiby/public_html/catalog/model/catalog/category.php:11
234 (0.157)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:304
235 (0.106)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0' GROUP BY product_id
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:306
236 (1.102)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:7
237 (0.172)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/a4profiby/public_html/catalog/model/extension/extension.php:4
238 (0.098)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:304
239 (0.084)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0' GROUP BY product_id
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:306
240 (1.076)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:7
241 (1.064)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/home/a4profiby/public_html/catalog/model/setting/setting.php:6
242 (0.093)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:304
243 (0.080)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0' GROUP BY product_id
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:306
244 (1.079)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:7
245 (0.084)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:304
246 (0.075)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0' GROUP BY product_id
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:306
247 (1.077)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:7
248 (0.083)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/a4profiby/public_html/system/library/customer.php:129
249 (0.099)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:304
250 (0.078)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0' GROUP BY product_id
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:306
251 (1.151)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:7
252 (0.094)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:304
253 (0.079)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0' GROUP BY product_id
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:306
254 (1.080)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:7
255 (0.087)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:304
256 (0.076)
SELECT product_id,SUM(quantity) AS total
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kv8u6fhnhfkhh25n2i797pu8r0' GROUP BY product_id
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:306
257 (1.081)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'giftTeaser'
/home/a4profiby/public_html/system/storage/modification/system/library/cart.php:7