Категорії

Кошик

Salda


Гнучка вставка LSVF 100

317 грн.

Гнучка вставка LSVF 100

..

317 грн.

Гнучка вставка LSVF 125

317 грн.

Гнучка вставка LSVF 125

..

317 грн.

Гнучка вставка LSVF 150

388 грн.

Гнучка вставка LSVF 150

..

388 грн.

Гнучка вставка LSVF 160

388 грн.

Гнучка вставка LSVF 160

..

388 грн.

Гнучка вставка LSVF 200

494 грн.

Гнучка вставка LSVF 200

..

494 грн.

Гнучка вставка LSVF 250

564 грн.

Гнучка вставка LSVF 250

..

564 грн.

Гнучка вставка LSVF 315

706 грн.

Гнучка вставка LSVF 315

..

706 грн.

Заслінка SKG-A 100

1023 грн.

Заслінка SKG-A 100

..

1023 грн.

Заслінка SKG-A 125

1023 грн.

Заслінка SKG-A 125

..

1023 грн.

Заслінка SKG-A 150

1094 грн.

Заслінка SKG-A 150

..

1094 грн.

Заслінка SKG-A 160

1094 грн.

Заслінка SKG-A 160

..

1094 грн.

Заслінка SKG-A 200

1305 грн.

Заслінка SKG-A 200

..

1305 грн.

Заслінка SKG-A 250

1376 грн.

Заслінка SKG-A 250

..

1376 грн.

Заслінка SKG-A 315

1587 грн.

Заслінка SKG-A 315

..

1587 грн.

Заслінка SKG-R 100

776 грн.

Заслінка SKG-R 100

..

776 грн.

Заслінка SKG-R 150

882 грн.

Заслінка SKG-R 150

..

882 грн.

Показано з 1 по 16 із 522 (33 сторінок)
Queries: 211, Total time: 97.234 ms [By time] [By id] [By file]
1 (2.938)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'b5297aba6175157b38ebfe3d29' AND expire > 1711703110
/home/hasta/public_html/system/library/session/db.php:21
2 (0.260)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/hasta/public_html/system/library/openbay.php:61
3 (0.263)
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.240)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/hasta/public_html/system/library/openbay.php:61
5 (2.029)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'c3654591a3a433b6df88087704' AND expire > 1711703110
/home/hasta/public_html/system/library/session/db.php:21
6 (0.800)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://hasta.life/'
/home/hasta/public_html/storage/modification/catalog/controller/startup/startup.php:6
7 (2.140)
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.595)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/hasta/public_html/catalog/model/localisation/language.php:15
9 (0.255)
SELECT *
FROM oc_store
ORDER BY url
/home/hasta/public_html/catalog/model/setting/store.php:7
10 (0.245)
SELECT *
FROM oc_language
WHERE status = '1'
/home/hasta/public_html/system/library/agoo/multilang.php:32
11 (0.273)
SELECT *
FROM oc_currency
/home/hasta/public_html/system/library/cart/currency.php:10
12 (0.274)
SELECT *
FROM oc_seo_url
WHERE `store_id` = '0' AND `language_id` = '3' AND `keyword` = 'salda' LIMIT 1
/home/hasta/public_html/catalog/controller/jetcache/jetcache.php:385
13 (0.502)
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.746)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'c3654591a3a433b6df88087704'
/home/hasta/public_html/catalog/controller/jetcache/jetcache.php:268
15 (0.243)
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.239)
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.281)
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.237)
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.315)
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.257)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/hasta/public_html/system/library/openbay.php:61
21 (0.261)
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.272)
SELECT *
FROM oc_seo_url
WHERE keyword = 'salda' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:41
23 (0.289)
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.262)
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 = '272' AND md.language_id = '3' AND m2s.store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:17
25 (0.274)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
26 (6.145)
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-03-29 11:05:00' AND p2s.store_id = '0' AND p.manufacturer_id = '272'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:617
27 (11.335)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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-03-29 11:05:00' AND p2s.store_id = '0' AND p.manufacturer_id = '272' 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.008)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175788' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
29 (0.767)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175789' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
30 (0.787)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175790' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
31 (0.762)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175791' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
32 (0.943)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175792' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
33 (0.776)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175793' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
34 (0.839)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175794' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
35 (0.766)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179809' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
36 (0.774)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179810' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
37 (0.754)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179811' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
38 (0.800)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179812' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
39 (0.795)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179813' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
40 (0.839)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179814' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
41 (0.850)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179815' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
42 (0.869)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179817' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
43 (0.811)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179819' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
44 (0.303)
SELECT *
FROM oc_product_image
WHERE product_id = '175788'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
45 (0.271)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
46 (0.253)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=175788' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
47 (0.321)
SELECT *
FROM oc_product_image
WHERE product_id = '175789'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
48 (0.269)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
49 (0.253)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=175789' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
50 (0.249)
SELECT *
FROM oc_product_image
WHERE product_id = '175790'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
51 (0.245)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
52 (0.251)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=175790' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
53 (0.274)
SELECT *
FROM oc_product_image
WHERE product_id = '175791'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
54 (0.235)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
55 (0.260)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=175791' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
56 (0.243)
SELECT *
FROM oc_product_image
WHERE product_id = '175792'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
57 (0.252)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
58 (0.229)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=175792' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
59 (0.231)
SELECT *
FROM oc_product_image
WHERE product_id = '175793'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
60 (0.253)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
61 (0.273)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=175793' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
62 (0.286)
SELECT *
FROM oc_product_image
WHERE product_id = '175794'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
63 (0.242)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
64 (0.307)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=175794' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
65 (0.244)
SELECT *
FROM oc_product_image
WHERE product_id = '179809'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
66 (0.279)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
67 (0.270)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=179809' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
68 (0.254)
SELECT *
FROM oc_product_image
WHERE product_id = '179810'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
69 (0.254)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
70 (0.244)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=179810' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
71 (0.247)
SELECT *
FROM oc_product_image
WHERE product_id = '179811'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
72 (0.268)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
73 (0.281)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=179811' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
74 (0.275)
SELECT *
FROM oc_product_image
WHERE product_id = '179812'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
75 (0.289)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
76 (0.271)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=179812' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
77 (0.267)
SELECT *
FROM oc_product_image
WHERE product_id = '179813'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
78 (0.290)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
79 (0.284)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=179813' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
80 (0.296)
SELECT *
FROM oc_product_image
WHERE product_id = '179814'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
81 (0.241)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
82 (0.255)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=179814' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
83 (0.238)
SELECT *
FROM oc_product_image
WHERE product_id = '179815'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
84 (0.249)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
85 (0.269)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=179815' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
86 (0.232)
SELECT *
FROM oc_product_image
WHERE product_id = '179817'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
87 (0.253)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
88 (0.256)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=179817' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
89 (0.345)
SELECT *
FROM oc_product_image
WHERE product_id = '179819'
ORDER BY sort_order ASC
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:464
90 (0.280)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
91 (0.298)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=179819' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
92 (0.271)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
93 (0.284)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
94 (0.257)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
95 (0.236)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
96 (0.233)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
97 (0.254)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
98 (0.232)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
99 (0.231)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
100 (0.252)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
101 (0.236)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
102 (0.241)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
103 (0.253)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
104 (0.236)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
105 (0.261)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
106 (0.274)
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
107 (0.274)
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
108 (0.286)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
109 (0.265)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
110 (0.259)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
111 (0.284)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '272' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
112 (0.285)
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
113 (0.260)
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
114 (0.265)
SELECT *
FROM oc_module
WHERE module_id = '34'
/home/hasta/public_html/catalog/model/setting/module.php:4
115 (0.253)
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
116 (0.520)
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 = '272' 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
117 (0.265)
SELECT *
FROM oc_module
WHERE module_id = '35'
/home/hasta/public_html/catalog/model/setting/module.php:4
118 (0.429)
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 = '272' 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
119 (0.263)
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
120 (0.264)
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
121 (0.248)
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
122 (0.253)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '272' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
123 (0.232)
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
124 (0.264)
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
125 (0.243)
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
126 (0.244)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '272' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
127 (0.303)
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
128 (0.270)
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
129 (0.258)
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
130 (0.240)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
131 (0.253)
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
132 (0.234)
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
133 (0.234)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '272' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
134 (0.246)
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
135 (0.272)
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
136 (0.260)
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
137 (0.601)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2024-03-29 10:05:10'
/home/hasta/public_html/catalog/model/tool/online.php:4
138 (0.294)
REPLACE INTO `oc_customer_online` SET `ip` = '54.92.135.47', `customer_id` = '0', `url` = 'https://hasta.life/salda', `referer` = '', `date_added` = '2024-03-29 11:05:10'
/home/hasta/public_html/catalog/model/tool/online.php:6
139 (0.239)
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
140 (0.240)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/hasta/public_html/catalog/model/setting/extension.php:4
141 (0.247)
SELECT *
FROM oc_blogger b
LEFT JOIN oc_blogger_description bd ON (b.blogger_id = bd.blogger_id)
WHERE bd.language_id = '3' AND b.blogger_id = '0'
/home/hasta/public_html/catalog/model/megnor/blogger.php:14
142 (0.241)
SELECT *
FROM oc_module
WHERE module_id = '148'
/home/hasta/public_html/catalog/model/setting/module.php:4
143 (0.237)
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
144 (0.237)
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
145 (0.246)
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
146 (0.257)
SELECT *
FROM oc_store
ORDER BY url
/home/hasta/public_html/catalog/model/setting/store.php:7
147 (0.241)
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
148 (0.263)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/hasta/public_html/catalog/model/localisation/language.php:15
149 (0.315)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
150 (0.275)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '6'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
151 (0.261)
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
152 (0.237)
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
153 (0.259)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=272' AND store_id = '0' AND language_id = '3'
/home/hasta/public_html/storage/modification/catalog/controller/startup/seo_url.php:143
154 (0.233)
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
155 (0.263)
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
156 (0.231)
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
157 (0.263)
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
158 (0.266)
SELECT *
FROM oc_setting
WHERE `code` = 'module_simplerewards'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:78
159 (1.175)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c3654591a3a433b6df88087704'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:92
160 (2.366)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/hasta/public_html/catalog/model/setting/extension.php:4
161 (0.360)
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
162 (0.362)
SELECT *
FROM oc_setting
WHERE `code` = 'module_simplerewards'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:78
163 (0.342)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c3654591a3a433b6df88087704'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:92
164 (0.368)
SELECT *
FROM oc_setting
WHERE `code` = 'module_simplerewards'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:78
165 (0.366)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c3654591a3a433b6df88087704'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:92
166 (0.309)
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
167 (0.336)
SELECT *
FROM oc_setting
WHERE `code` = 'module_simplerewards'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:78
168 (0.344)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c3654591a3a433b6df88087704'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:92
169 (0.362)
SELECT *
FROM oc_setting
WHERE `code` = 'module_simplerewards'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:78
170 (0.348)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'c3654591a3a433b6df88087704'
/home/hasta/public_html/storage/modification/system/library/cart/cart.php:92
171 (0.350)
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
172 (0.362)
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
173 (0.821)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '272' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
174 (0.619)
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
175 (0.585)
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
176 (0.530)
SELECT *
FROM oc_module
WHERE module_id = '34'
/home/hasta/public_html/catalog/model/setting/module.php:4
177 (0.570)
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
178 (0.946)
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 = '272' 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
179 (0.627)
SELECT *
FROM oc_module
WHERE module_id = '35'
/home/hasta/public_html/catalog/model/setting/module.php:4
180 (0.439)
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 = '272' 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
181 (0.268)
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
182 (0.293)
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
183 (0.262)
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
184 (0.283)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '272' AND store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:8
185 (0.285)
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
186 (0.261)
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
187 (0.281)
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
188 (0.265)
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
189 (0.281)
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
190 (0.282)
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
191 (0.268)
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 = '272' AND md.language_id = '3' AND m2s.store_id = '0'
/home/hasta/public_html/catalog/model/catalog/manufacturer.php:17
192 (0.268)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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-03-29 11:05:00' AND p2s.store_id = '0' AND p.manufacturer_id = '272' 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
193 (0.270)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175788' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
194 (0.266)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175789' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
195 (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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175790' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
196 (0.315)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175791' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
197 (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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175792' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
198 (0.279)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175793' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
199 (0.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 < '2024-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '175794' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
200 (0.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 < '2024-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179809' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
201 (0.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 < '2024-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179810' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
202 (0.294)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179811' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
203 (0.279)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179812' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
204 (0.279)
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-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179813' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
205 (0.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 < '2024-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179814' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
206 (0.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 < '2024-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179815' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
207 (0.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 < '2024-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179817' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
208 (0.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 < '2024-03-29 11:05:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-29 11: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-03-29 11:05:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-29 11: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 = '179819' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= '2024-03-29 11:05:00' AND p2s.store_id = '0'
/home/hasta/public_html/storage/modification/catalog/model/catalog/product.php:41
209 (0.245)
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
210 (0.239)
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
211 (0.258)
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