Категорії

Кошик

SmartStream


Рекуператор SmartStream Classic

7500 грн.

Рекуператор SmartStream Classic

Рекуператор СмартСтрім серії Класік працює за принципом «Включив та забув». Він має один..

7500 грн.

Рекуператор SmartStream Standart Evo

Рекуператор SmartStream Standart EvoБагатофункційний прилад, виконує функції 3-х: провітрювач, ..

9500 грн.

Рекуператор SmartStream Air Q

11000 грн.

Рекуператор SmartStream Air Q

Рекуператор SmartStream Air QПерший, в своєму роді, дійсно автоматизований рекуператор з повним дист..

11000 грн.

Рекуператор SmartStream M150 Wi-Fi квадратний

Рекуператор SmartStream M150 Wi-Fi (Стандарт) має власний незалежний Wi-Fi модуль, який дає можливіс..

Рекуператор SmartStream M150 Wi-Fi круглий

Рекуператор SmartStream M150 Wi-Fi (Стандарт) має власний незалежний Wi-Fi модуль, який дає можливіс..

Рекуператор SmartStream M150 Wi-Fi PRO квадратний

Це без перебільшення революційна модель від українського виробника, адже ми дали можливість налаштув..

Рекуператор SmartStream M150 Wi-Fi PRO круглий

Це без перебільшення революційна модель від українського виробника, адже ми дали можливість налаштув..

Показано з 1 по 7 із 7 (1 сторінок)
Queries: 168, Total time: 60.244 ms [By time] [By id] [By file]
1 (0.584)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'c7beba31220bb7997debb8d531' AND expire > 1714007145
/home/hasta/public_html/system/library/session/db.php:21
2 (0.250)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/hasta/public_html/system/library/openbay.php:61
3 (0.267)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/hasta/public_html/catalog/model/design/translation.php:6
4 (0.257)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/hasta/public_html/system/library/openbay.php:61
5 (0.669)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'e5722c4f035dd5564d83d0d8d5' AND expire > 1714007145
/home/hasta/public_html/system/library/session/db.php:21
6 (0.244)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://hasta.life/'
/home/hasta/public_html/storage/modification/catalog/controller/startup/startup.php:6
7 (1.027)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/hasta/public_html/storage/modification/catalog/controller/startup/startup.php:25
8 (0.271)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/hasta/public_html/catalog/model/localisation/language.php:15
9 (0.237)
SELECT *
FROM oc_store
ORDER BY url
/home/hasta/public_html/catalog/model/setting/store.php:7
10 (0.254)
SELECT *
FROM oc_language
WHERE status = '1'
/home/hasta/public_html/system/library/agoo/multilang.php:32
11 (0.244)
SELECT *
FROM oc_currency
/home/hasta/public_html/system/library/cart/currency.php:10
12 (0.460)
SELECT *
FROM oc_seo_url
WHERE `store_id` = '0' AND `language_id` = '3' AND `keyword` = 'smartstream' LIMIT 1
/home/hasta/public_html/catalog/controller/jetcache/jetcache.php:385
13 (0.351)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 60 MINUTE)
/home/hasta/public_html/catalog/controller/jetcache/jetcache.php:263
14 (0.419)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'e5722c4f035dd5564d83d0d8d5'
/home/hasta/public_html/catalog/controller/jetcache/jetcache.php:268
15 (0.260)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '300008' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/hasta/public_html/system/library/cart/tax.php:16
16 (0.235)
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 = '300008' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/hasta/public_html/system/library/cart/tax.php:44
17 (0.238)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '3'
/home/hasta/public_html/system/library/cart/weight.php:10
18 (0.255)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '3'
/home/hasta/public_html/system/library/cart/length.php:10
19 (0.354)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 3 WEEK)
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:46
20 (0.234)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/hasta/public_html/system/library/openbay.php:61
21 (0.262)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/hasta/public_html/catalog/model/setting/event.php:4
22 (0.404)
SELECT *
FROM oc_seo_url
WHERE keyword = 'smartstream' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:41
23 (0.238)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'product/manufacturer' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
24 (0.248)
SELECT DISTINCT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id)
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '298' AND md.language_id = '3' AND m2s.store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:17
25 (0.249)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
26 (0.939)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0' AND p.manufacturer_id = '298'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:617
27 (2.827)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
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)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0' AND p.manufacturer_id = '298' GROUP BY p.product_id
ORDER BY IF(p.quantity = 0, 1, 0), p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,16
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:254
28 (1.699)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70638' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
29 (1.642)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '158498' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
30 (1.633)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '158497' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
31 (1.591)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70588' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
32 (1.300)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70586' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
33 (3.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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70580' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
34 (0.779)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70592' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
35 (0.270)
SELECT *
FROM oc_product_image
WHERE product_id = '70638'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
36 (0.232)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
37 (0.266)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=70638' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
38 (0.244)
SELECT *
FROM oc_product_image
WHERE product_id = '158498'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
39 (0.275)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
40 (0.292)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=158498' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
41 (0.268)
SELECT *
FROM oc_product_image
WHERE product_id = '158497'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
42 (0.238)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
43 (0.259)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=158497' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
44 (0.254)
SELECT *
FROM oc_product_image
WHERE product_id = '70588'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
45 (0.268)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/module/art_ask_price' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
46 (0.236)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
47 (0.251)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=70588' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
48 (0.272)
SELECT *
FROM oc_product_image
WHERE product_id = '70586'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
49 (0.238)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/module/art_ask_price' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
50 (0.261)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
51 (0.265)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=70586' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
52 (0.272)
SELECT *
FROM oc_product_image
WHERE product_id = '70580'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
53 (0.243)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/module/art_ask_price' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
54 (0.257)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
55 (0.249)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=70580' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
56 (0.255)
SELECT *
FROM oc_product_image
WHERE product_id = '70592'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
57 (0.243)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/module/art_ask_price' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
58 (0.253)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
59 (0.245)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=70592' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
60 (0.236)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
61 (0.256)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
62 (0.246)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
63 (0.234)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
64 (0.262)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
65 (0.245)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
66 (0.269)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
67 (0.255)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
68 (0.249)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
69 (0.248)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
70 (0.250)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
71 (0.242)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
72 (0.249)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
73 (0.260)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
74 (0.250)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'extension/module/microdatapro/tc_og'
/home/hasta/public_html/catalog/model/design/theme.php:4
75 (0.255)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'extension/module/microdatapro/category_manufacturer'
/home/hasta/public_html/catalog/model/design/theme.php:4
76 (0.277)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
77 (0.258)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
78 (0.475)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '298' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
79 (0.245)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:4
80 (0.275)
SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'column_left'
ORDER BY sort_order
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:23
81 (0.242)
SELECT *
FROM oc_module
WHERE module_id = '34'
/home/hasta/public_html/catalog/model/setting/module.php:4
82 (0.248)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/module/featured_article' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
83 (0.410)
SELECT *
FROM oc_article_related_mn pr
LEFT JOIN oc_article p ON (pr.article_id = p.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE pr.manufacturer_id = '298' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' LIMIT 4
/home/hasta/public_html/catalog/model/blog/article.php:278
84 (0.265)
SELECT *
FROM oc_module
WHERE module_id = '35'
/home/hasta/public_html/catalog/model/setting/module.php:4
85 (0.411)
SELECT *
FROM oc_product_related_mn pr
LEFT JOIN oc_product p ON (pr.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.manufacturer_id = '298' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' LIMIT 4
/home/hasta/public_html/catalog/model/catalog/cms.php:36
86 (0.246)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/module/featured_product' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
87 (0.254)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'extension/module/featured_product'
/home/hasta/public_html/catalog/model/design/theme.php:4
88 (0.241)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/column_left'
/home/hasta/public_html/catalog/model/design/theme.php:4
89 (0.249)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '298' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
90 (0.251)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:4
91 (0.270)
SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'column_right'
ORDER BY sort_order
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:23
92 (0.251)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/column_right'
/home/hasta/public_html/catalog/model/design/theme.php:4
93 (0.296)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '298' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
94 (0.242)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:4
95 (0.265)
SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'content_top'
ORDER BY sort_order
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:23
96 (0.286)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:4
97 (0.252)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
98 (0.257)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'agootemplates/widgets/langmark/langmark'
/home/hasta/public_html/catalog/model/design/theme.php:4
99 (0.257)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/content_top'
/home/hasta/public_html/catalog/model/design/theme.php:4
100 (0.247)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '298' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
101 (0.238)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:4
102 (0.262)
SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'content_bottom'
ORDER BY sort_order
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:23
103 (0.255)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/content_bottom'
/home/hasta/public_html/catalog/model/design/theme.php:4
104 (0.657)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2024-04-25 03:05:45'
/home/hasta/public_html/catalog/model/tool/online.php:4
105 (0.319)
REPLACE INTO `oc_customer_online` SET `ip` = '3.140.185.170', `customer_id` = '0', `url` = 'https://hasta.life/smartstream', `referer` = '', `date_added` = '2024-04-25 04:05:45'
/home/hasta/public_html/catalog/model/tool/online.php:6
106 (0.261)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'common/header' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
107 (0.251)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/hasta/public_html/catalog/model/setting/extension.php:4
108 (0.244)
SELECT *
FROM oc_module
WHERE module_id = '148'
/home/hasta/public_html/catalog/model/setting/module.php:4
109 (0.240)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/module/formcreator' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
110 (0.236)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'extension/module/formcreator_modal'
/home/hasta/public_html/catalog/model/design/theme.php:4
111 (0.270)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'common/header' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
112 (0.239)
SELECT *
FROM oc_store
ORDER BY url
/home/hasta/public_html/catalog/model/setting/store.php:7
113 (0.244)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'common/language' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
114 (0.261)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/hasta/public_html/catalog/model/localisation/language.php:15
115 (0.264)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
116 (0.462)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '6'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
117 (0.240)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'agootemplates/record/langmark'
/home/hasta/public_html/catalog/model/design/theme.php:4
118 (0.265)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'common/currency' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
119 (0.245)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=298' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
120 (0.252)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/currency'
/home/hasta/public_html/catalog/model/design/theme.php:4
121 (0.243)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'common/search' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
122 (0.236)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/search'
/home/hasta/public_html/catalog/model/design/theme.php:4
123 (0.258)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'common/cart' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
124 (0.242)
SELECT *
FROM oc_setting
WHERE `code` = 'module_simplerewards'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:78
125 (0.415)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e5722c4f035dd5564d83d0d8d5'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:92
126 (0.245)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/hasta/public_html/catalog/model/setting/extension.php:4
127 (0.262)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/total/sub_total' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
128 (0.246)
SELECT *
FROM oc_setting
WHERE `code` = 'module_simplerewards'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:78
129 (0.236)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e5722c4f035dd5564d83d0d8d5'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:92
130 (0.250)
SELECT *
FROM oc_setting
WHERE `code` = 'module_simplerewards'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:78
131 (0.234)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e5722c4f035dd5564d83d0d8d5'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:92
132 (0.241)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/total/total' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
133 (0.260)
SELECT *
FROM oc_setting
WHERE `code` = 'module_simplerewards'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:78
134 (0.279)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e5722c4f035dd5564d83d0d8d5'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:92
135 (0.249)
SELECT *
FROM oc_setting
WHERE `code` = 'module_simplerewards'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:78
136 (0.332)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e5722c4f035dd5564d83d0d8d5'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:92
137 (0.263)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/cart'
/home/hasta/public_html/catalog/model/design/theme.php:4
138 (0.251)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'extension/module/shopping_tw'
/home/hasta/public_html/catalog/model/design/theme.php:4
139 (0.310)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '298' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
140 (0.241)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:4
141 (0.242)
SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'column_left'
ORDER BY sort_order
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:23
142 (0.246)
SELECT *
FROM oc_module
WHERE module_id = '34'
/home/hasta/public_html/catalog/model/setting/module.php:4
143 (0.256)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/module/featured_article' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
144 (0.459)
SELECT *
FROM oc_article_related_mn pr
LEFT JOIN oc_article p ON (pr.article_id = p.article_id)
LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id)
WHERE pr.manufacturer_id = '298' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' LIMIT 4
/home/hasta/public_html/catalog/model/blog/article.php:278
145 (0.240)
SELECT *
FROM oc_module
WHERE module_id = '35'
/home/hasta/public_html/catalog/model/setting/module.php:4
146 (0.396)
SELECT *
FROM oc_product_related_mn pr
LEFT JOIN oc_product p ON (pr.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.manufacturer_id = '298' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' LIMIT 4
/home/hasta/public_html/catalog/model/catalog/cms.php:36
147 (0.251)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '3' AND (route = 'extension/module/featured_product' OR route = 'uk-ua')
/home/hasta/public_html/catalog/model/design/translation.php:6
148 (0.259)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'extension/module/featured_product'
/home/hasta/public_html/catalog/model/design/theme.php:4
149 (0.241)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/column_left'
/home/hasta/public_html/catalog/model/design/theme.php:4
150 (0.259)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '298' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
151 (0.259)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:4
152 (0.236)
SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'column_right'
ORDER BY sort_order
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:23
153 (0.239)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/column_right'
/home/hasta/public_html/catalog/model/design/theme.php:4
154 (0.256)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:4
155 (0.255)
SELECT *
FROM oc_layout_module
WHERE layout_id = '17' AND position = 'header_left'
ORDER BY sort_order
/home/hasta/public_html/storage/modification/catalog/model/design/layout.php:23
156 (0.238)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/header_left'
/home/hasta/public_html/catalog/model/design/theme.php:4
157 (0.267)
SELECT DISTINCT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id)
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '298' AND md.language_id = '3' AND m2s.store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:17
158 (0.278)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
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)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0' AND p.manufacturer_id = '298' GROUP BY p.product_id
ORDER BY IF(p.quantity = 0, 1, 0), p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,16
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:254
159 (0.312)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70638' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
160 (0.281)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '158498' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
161 (0.271)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '158497' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
162 (0.284)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70588' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
163 (0.275)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70586' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
164 (0.267)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70580' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
165 (0.264)
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 < '2024-04-25 04:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-25 04:05:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2024-04-25 04:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-25 04:05:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70592' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-04-25 04:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
166 (0.237)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'common/header'
/home/hasta/public_html/catalog/model/design/theme.php:4
167 (0.266)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'extension/module/facebook_business'
/home/hasta/public_html/catalog/model/design/theme.php:4
168 (0.270)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'OPC090216_2' AND route = 'product/manufacturer_info'
/home/hasta/public_html/catalog/model/design/theme.php:4