1 (0.034)
SET time_zone = '+00:00'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/framework.php:84
2 (0.390)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = 'b06b61e75c07433126fb0876f9' AND `expire` > '2024-05-19 23:33:25'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/session/db.php:16
3 (0.045)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://wigwam.hu/'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/startup.php:6
4 (0.257)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/startup.php:25
5 (0.071)
SET time_zone = '+02:00'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/startup.php:40
6 (0.060)
SELECT *
FROM oc_currency
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/cart/currency.php:10
7 (0.034)
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 = '97' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4251')
ORDER BY tr1.priority ASC
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/cart/tax.php:16
8 (0.017)
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 = '97' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4251')
ORDER BY tr1.priority ASC
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/cart/tax.php:44
9 (0.029)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/cart/weight.php:10
10 (0.027)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/cart/length.php:10
11 (0.260)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:15
12 (0.041)
SELECT new_url , code, store_id
FROM oc_redirect_manager
WHERE old_url = 'index.php?route=product/category&path=4&page=8' AND status = 1 AND store_id = 0 LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/controller/extension/module/redirect_manager_pro.php:46
13 (0.075)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/event.php:4
14 (0.048)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b06b61e75c07433126fb0876f9'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:45
15 (0.075)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/design/translation.php:18
16 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
17 (0.038)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '4' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/catalog/category.php:4
18 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
19 (0.014)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
20 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/compare' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
21 (0.022)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '4' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/catalog/category.php:10
22 (0.894)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '2294' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
23 (0.608)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '2291' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
24 (0.540)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '2289' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
25 (0.537)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '2290' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
26 (0.553)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '2293' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
27 (0.532)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '2292' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
28 (0.517)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '1327' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
29 (0.544)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '1326' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
30 (0.548)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '4759' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
31 (0.509)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '472' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
32 (0.561)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '4953' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
33 (0.517)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 = '929' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/catalog/product.php:11
34 (0.491)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2294
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
35 (0.084)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2294'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
36 (0.219)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
37 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
38 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=2294' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
39 (0.270)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2291
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
40 (0.066)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2291'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
41 (0.215)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
42 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
43 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=2291' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
44 (0.279)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2289
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
45 (0.078)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2289'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
46 (0.197)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
47 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
48 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=2289' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
49 (0.270)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2290
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
50 (0.124)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2290'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
51 (0.125)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
52 (0.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
53 (0.030)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=2290' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
54 (0.300)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2293
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
55 (0.074)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2293'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
56 (0.070)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
57 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
58 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=2293' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
59 (0.577)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2292
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
60 (0.102)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2292'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
61 (0.093)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
62 (0.018)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
63 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=2292' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
64 (0.283)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1327
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
65 (0.071)
SELECT *
FROM oc_product_to_category
WHERE product_id = '1327'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
66 (0.069)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
67 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
68 (0.030)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=1327' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
69 (0.503)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1326
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
70 (0.056)
SELECT *
FROM oc_product_to_category
WHERE product_id = '1326'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
71 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
72 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
73 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=1326' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
74 (0.271)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4759
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
75 (0.052)
SELECT *
FROM oc_product_to_category
WHERE product_id = '4759'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
76 (0.151)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
77 (0.036)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
78 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=4759' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
79 (0.285)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 472
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
80 (0.071)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
81 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
82 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=472' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
83 (0.321)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4953
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
84 (0.091)
SELECT *
FROM oc_product_to_category
WHERE product_id = '4953'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
85 (0.074)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
86 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
87 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=4953' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
88 (0.276)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 929
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
89 (0.079)
SELECT *
FROM oc_product_to_category
WHERE product_id = '929'
ORDER BY category_id DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:129
90 (0.206)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
91 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
92 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=929' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
93 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
94 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
95 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
96 (0.021)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
97 (0.023)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
98 (0.018)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
99 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
100 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
101 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
102 (0.018)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
103 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
104 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
105 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
106 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
107 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
108 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
109 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
110 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
111 (0.018)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
112 (0.021)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
113 (0.023)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
114 (0.027)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
115 (0.031)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
116 (0.027)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
117 (0.027)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
118 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
119 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
120 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
121 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
122 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
123 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
124 (0.021)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
125 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
126 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
127 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
128 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
129 (0.023)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
130 (0.049)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '4' AND store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/catalog/category.php:55
131 (0.087)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/design/layout.php:4
132 (0.135)
SELECT *
FROM oc_module
WHERE module_id = '43'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/module.php:4
133 (0.100)
SELECT *
FROM oc_seo_url
WHERE `query` = 'extension/module/ocme_mfp_filter' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
134 (0.108)
SELECT *
FROM oc_theme
WHERE store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/model/design/theme.php:12
135 (0.104)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
136 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
137 (19.324)
SELECT
p.product_id,
(
SELECT AVG(rating) total
FROM `oc_review` r1
WHERE
r1.product_id = p.product_id
AND r1.status = '1'
GROUP BY r1.product_id
) rating,
(
SELECT price
FROM `oc_product_discount` pd2
WHERE
pd2.product_id = p.product_id
AND pd2.customer_group_id = '1'
AND pd2.quantity = '1'
AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW())
AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1
) discount,
(
SELECT price
FROM `oc_product_special` ps
WHERE
ps.product_id = p.product_id
AND ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1
) special,
p.viewed as `p.viewed`,
if (p.quantity, 1, 0) in_stock
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
AND pd.language_id = '1'
AND p2c.category_id IN (4) GROUP BY p.product_id
ORDER BY LCASE(pd.name) DESC, LCASE(pd.name) DESC LIMIT 0, 8
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/filter.php:892
138 (2.364)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 IN (1325,1330,1345,1329,1336,1335,1334,1332) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/product.php:29
139 (0.295)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (1325,1330,1345,1329,1336,1335,1334,1332)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/product.php:97
140 (0.041)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (1325,1330,1345,1329,1336,1335,1334,1332)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/product.php:117
141 (0.272)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1325
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
142 (2.113)
SELECT *
FROM oc_seo_url
WHERE store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/journal3/url.php:102
143 (0.336)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1330
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
144 (0.337)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1345
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
145 (0.479)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1329
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
146 (0.316)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1336
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
147 (0.276)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1335
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
148 (0.639)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1334
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
149 (0.300)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1332
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
150 (0.662)
SELECT
p.product_id
FROM `oc_product` p
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
p.product_id IN (334, 234, 4996, 233, 4462, 1891, 804, 259, 565, 4540, 768, 1405, 469, 4336, 2306, 5140, 4451, 508, 5106, 697)
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/product.php:424
151 (2.635)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 IN (233,234,259,334,469,508,565,697,768,804,1405,1891,2306,4336,4451,4462,4540,4996,5106,5140) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/product.php:29
152 (0.324)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (233,234,259,334,469,508,565,697,768,804,1405,1891,2306,4336,4451,4462,4540,4996,5106,5140)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/product.php:97
153 (0.045)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (233,234,259,334,469,508,565,697,768,804,1405,1891,2306,4336,4451,4462,4540,4996,5106,5140)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/product.php:117
154 (0.083)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 334
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
155 (0.138)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 234
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
156 (0.108)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4996
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
157 (0.112)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 233
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
158 (0.122)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4462
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
159 (0.127)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 1891
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
160 (0.132)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 804
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
161 (0.130)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 259
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
162 (0.080)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 584
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
163 (0.142)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 39
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
164 (0.094)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 583
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
165 (0.113)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 163
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
166 (0.080)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 133
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
167 (0.077)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 881
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
168 (0.071)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4526
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
169 (0.116)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2691
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/tagmanager.php:163
170 (0.076)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/setting.php:6
171 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
172 (0.023)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/return/add' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
173 (0.023)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/sitemap' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
174 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/tracking' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
175 (0.021)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
176 (0.021)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/voucher' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
177 (0.030)
SELECT *
FROM oc_seo_url
WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
178 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
179 (0.023)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
180 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
181 (0.018)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
182 (0.019)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/newsletter' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
183 (0.055)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
184 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
185 (0.027)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/setting.php:6
186 (0.023)
SELECT *
FROM oc_seo_url
WHERE `query` = 'extension/module/isenselabs_gdpr' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
187 (0.023)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/setting.php:6
188 (0.036)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/setting.php:6
189 (28.390)
SELECT *
FROM `oc_journal3_module`
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/module.php:9
190 (0.089)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/setting.php:6
191 (0.061)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/extension.php:4
192 (0.060)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
193 (0.022)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
194 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
195 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
196 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
197 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
198 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
199 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
200 (0.014)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/transaction' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
201 (0.013)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/download' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
202 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
203 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
204 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
205 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
206 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
207 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
208 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
209 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
210 (0.047)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
211 (0.016)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
212 (0.046)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/search' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
213 (0.055)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b06b61e75c07433126fb0876f9'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:45
214 (0.029)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/extension.php:4
215 (0.071)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b06b61e75c07433126fb0876f9'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:45
216 (0.031)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b06b61e75c07433126fb0876f9'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:45
217 (0.040)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/cart/customer.php:122
218 (0.038)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b06b61e75c07433126fb0876f9'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:45
219 (0.029)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b06b61e75c07433126fb0876f9'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:45
220 (0.020)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
221 (0.017)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
222 (0.039)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b06b61e75c07433126fb0876f9'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:45
223 (0.026)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/extension.php:4
224 (0.034)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b06b61e75c07433126fb0876f9'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:45
225 (0.019)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b06b61e75c07433126fb0876f9'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:45
226 (0.037)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/system/library/cart/customer.php:122
227 (0.034)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'b06b61e75c07433126fb0876f9'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/system/library/cart/cart.php:45
228 (0.082)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '4' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/catalog/category.php:4
229 (0.030)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
230 (0.015)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=4' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:130
231 (0.067)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/setting.php:6
232 (0.047)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/search' AND store_id = '0' AND language_id = '1'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
233 (2.497)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' 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 IN (2294,2291,2289,2290,2293,2292,1327,1326,4759,472,4953,929) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/product.php:29
234 (0.389)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (2294,2291,2289,2290,2293,2292,1327,1326,4759,472,4953,929)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/product.php:97
235 (0.028)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (2294,2291,2289,2290,2293,2292,1327,1326,4759,472,4953,929)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/journal3/product.php:117
236 (0.078)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/949090.cloudwaysapps.com/kvrgeksznk/public_html/catalog/model/setting/setting.php:6
12 voltos televízió és kemping műholdas rendszer és multimédia
Ablak és tetőfedél és heki és szellőztetés
Bútorszerkezet és belső burkolat és bútorfogantyúk
Fűtés és hűtőszekrények és hűtőközpontok és légkondicionálás
Gáztechnika és gáztűzhely és gázpalack
Kárpitos szövetek és hab és függönyök és kárpitos kellékek
Kemping kisállat
Kemping sátor és kemping cikkek
Kempingasztal és kempingbútorok
Kempingbusz kiegészítők
Kempingrácsok és kályhák
Kempingszék és kempingágy
Kerékpártartó és tető doboz és lakóautó létra
Lakóautó elektronika és akkumulátorok
Lakókocsi tartozékok
Lopásvédelem és biztonság
Melamin edények és kempingkonyha
Melamin ételek és kempingköteg
Merchandise cikk és POS anyag
Napellenző
Napellenző lakókocsi és napellenző motorház
Naprendszerek
Nyaralás a tengerparton és strand kiegészítők
Utazási kényelem és nappali kényelem és alvó kényelem
Vezetőülés és padok és biztonsági övek és forgatható konzol
Víz és vízvezeték és kemping WC
VW bulli ajándékok és busz kiegészítők
