1 (1.024)
SELECT `data`
FROM `oc_session`
WHERE session_id = '69ec972d0590ec1e2dcdfd96bc' AND expire > 1738936050
/profiles/s/st/sto/stockishop/stockishop.com/system/library/session/db.php:21
2 (0.688)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/openbay.php:61
3 (0.613)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
4 (0.507)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/openbay.php:61
5 (0.446)
SET SQL_BIG_SELECTS = 1
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/opencart.php:29
6 (1.315)
SHOW TABLES LIKE 'oc_ocfilter_setting'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/setting.php:10
7 (0.397)
SELECT *
FROM oc_ocfilter_setting
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/setting.php:18
8 (0.922)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'a9f867300de22183c7ca745416' AND expire > 1738936050
/profiles/s/st/sto/stockishop/stockishop.com/system/library/session/db.php:21
9 (0.510)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://stockishop.com/'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/controller/startup/startup.php:6
10 (1.506)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/controller/startup/startup.php:25
11 (0.577)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/localisation/language.php:15
12 (0.612)
SELECT *
FROM oc_store
ORDER BY url
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/setting/store.php:7
13 (0.465)
SELECT *
FROM oc_language
WHERE status = '1'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/agoo/multilang.php:32
14 (0.559)
SELECT *
FROM oc_currency
/profiles/s/st/sto/stockishop/stockishop.com/system/library/cart/currency.php:10
15 (0.544)
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 = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/profiles/s/st/sto/stockishop/stockishop.com/system/library/cart/tax.php:44
16 (0.516)
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 = '2'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/cart/weight.php:10
17 (0.396)
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 = '2'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/cart/length.php:10
18 (0.678)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:86
19 (0.420)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/openbay.php:61
20 (0.670)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/setting/event.php:4
21 (0.583)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/manufacturer' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
22 (0.680)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/lib/v0015/traits/installed.php:12
23 (1.225)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) JOIN oc_manufacturer_description md ON (md.manufacturer_id='34') AND (md.language_id='2')
WHERE m.manufacturer_id = '34' AND m2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/manufacturer.php:5
24 (0.726)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
25 (0.461)
SELECT *
FROM oc_layout_module
WHERE layout_id = '15' AND `code` = 'ocfilter'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
26 (13.093)
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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '34'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:622
27 (14.468)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.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
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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '34' GROUP BY p.product_id
ORDER BY (p.quantity>0) DESC, LCASE(pd.name) ASC, LCASE(pd.name) ASC LIMIT 0,18
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:240
28 (1.548)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
29 (1.958)
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 = '2') 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 = '2') 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 = '2') 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 = '202' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
30 (1.225)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
31 (1.778)
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 = '2') 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 = '2') 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 = '2') 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 = '200' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
32 (1.206)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
33 (1.835)
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 = '2') 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 = '2') 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 = '2') 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 = '201' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
34 (1.336)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
35 (1.936)
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 = '2') 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 = '2') 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 = '2') 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 = '251' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
36 (1.253)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
37 (1.785)
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 = '2') 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 = '2') 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 = '2') 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 = '846' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
38 (1.202)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
39 (1.831)
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 = '2') 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 = '2') 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 = '2') 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 = '920' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
40 (1.226)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
41 (1.780)
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 = '2') 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 = '2') 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 = '2') 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 = '745' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
42 (1.242)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
43 (1.812)
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 = '2') 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 = '2') 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 = '2') 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 = '776' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
44 (1.258)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
45 (1.710)
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 = '2') 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 = '2') 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 = '2') 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 = '885' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
46 (1.073)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
47 (1.638)
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 = '2') 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 = '2') 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 = '2') 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 = '404' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
48 (0.983)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
49 (1.744)
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 = '2') 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 = '2') 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 = '2') 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 = '1054' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
50 (0.610)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 202
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
51 (1.363)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 202
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
52 (1.471)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '202' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
53 (0.430)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 200
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
54 (1.040)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 200
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
55 (1.647)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '200' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
56 (0.614)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 201
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
57 (1.548)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 201
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
58 (1.610)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '201' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
59 (0.635)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 251
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
60 (1.338)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 251
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
61 (1.284)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '251' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
62 (0.440)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 846
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
63 (1.014)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 846
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
64 (1.484)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '846' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
65 (0.710)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 920
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
66 (1.219)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 920
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
67 (1.458)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '920' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
68 (0.530)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 745
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
69 (1.237)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 745
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
70 (1.117)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '745' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
71 (0.381)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 776
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
72 (0.979)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 776
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
73 (1.565)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '776' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
74 (0.615)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 885
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
75 (1.354)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 885
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
76 (1.559)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '885' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
77 (0.511)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 404
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
78 (0.999)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 404
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
79 (1.235)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '404' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
80 (0.526)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1054
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
81 (1.013)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV
ON ( POIP.product_option_id = POV.product_option_id
AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2)
,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2)
,oc_product_option PO
WHERE POIP.product_id = 1054
AND PO.product_option_id = POIP.product_option_id
AND PO.option_id = O.option_id
AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
82 (1.230)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1054' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
83 (0.873)
SELECT value
FROM oc_setting
WHERE `key` = 'module_microdatapro_key'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/microdatapro.php:137
84 (0.590)
SELECT value
FROM oc_setting
WHERE `key` = 'module_microdatapro_key'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/microdatapro.php:137
85 (0.707)
SELECT value
FROM oc_setting
WHERE `key` = 'module_microdatapro_key'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/microdatapro.php:137
86 (0.778)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/ocfilter' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
87 (0.830)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
88 (0.809)
SELECT *
FROM oc_layout_module
WHERE layout_id = '15' AND position = 'column_left'
ORDER BY sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:23
89 (0.733)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/ocfilter' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
90 (0.792)
SELECT *
FROM oc_ocfilter_setting
WHERE `key` = 'placement_layout'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/setting.php:68
91 (4.093)
SELECT COUNT(DISTINCT p.product_id) AS total, IF(p.quantity > '0', '2', '1') AS vid
FROM oc_product p
WHERE p.status = '1' AND p.date_available <= '2025-02-07' AND p.manufacturer_id = '34' GROUP BY vid
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
92 (3.801)
SELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid
FROM oc_ocfilter_filter_value_to_product fv2p
LEFT JOIN oc_product p ON (fv2p.product_id = p.product_id)
WHERE p.status = '1' AND p.date_available <= '2025-02-07' AND p.manufacturer_id = '34' GROUP BY fk, vid
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
93 (4.225)
SELECT CONCAT(f.filter_id, '.', f.source) AS filter_key
FROM oc_ocfilter_filter f
LEFT JOIN oc_ocfilter_filter_to_store f2s ON (f.filter_id = f2s.filter_id AND f.source = f2s.source)
RIGHT JOIN (SELECT fv2p.filter_id, fv2p.source
FROM oc_ocfilter_filter_value_to_product fv2p
RIGHT JOIN (SELECT DISTINCT p.product_id
FROM oc_product p
WHERE p.status = '1' AND p.date_available <= '2025-02-07' AND p.manufacturer_id = '34') p ON (fv2p.product_id = p.product_id) GROUP BY fv2p.filter_id, fv2p.source) fv2p ON (f.filter_id = fv2p.filter_id AND f.source = fv2p.source)
WHERE f.status = '1' AND f2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
94 (3.000)
SELECT MIN(price) AS `min`, MAX(price) AS `max`
FROM (SELECT ocf_ps.price
FROM oc_product_special ocf_ps
LEFT JOIN oc_product p ON (ocf_ps.product_id = p.product_id)
WHERE ocf_ps.price > '0' AND ocf_ps.customer_group_id = '1' AND ((ocf_ps.date_start = '0000-00-00' OR ocf_ps.date_start < '2025-02-07') AND (ocf_ps.date_end = '0000-00-00' OR ocf_ps.date_end > '2025-02-07')) AND p.status = '1' AND p.date_available <= '2025-02-07' AND p.manufacturer_id = '34') result
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
95 (2.166)
SELECT MIN(price) AS `min`, MAX(price) AS `max`
FROM (SELECT option_price AS price
FROM (SELECT COALESCE(
IF(ocf_pov.price_prefix = '-', p.price - ocf_pov.price, NULL),
IF(ocf_pov.price_prefix = '+', p.price + ocf_pov.price, NULL),
IF(ocf_pov.price_prefix = '=', ocf_pov.price, NULL),
IF(ocf_pov.price_prefix = '*', p.price + p.price * ocf_pov.price, NULL),
IF(ocf_pov.price_prefix = '%', p.price + p.price * (ocf_pov.price / 100), NULL),
p.price
) AS option_price
FROM oc_product_option_value ocf_pov
LEFT JOIN oc_product p ON (ocf_pov.product_id = p.product_id)
WHERE ocf_pov.price > '0'/* AND ocf_pov.quantity > '0'*/ AND p.status = '1' AND p.date_available <= '2025-02-07' AND p.manufacturer_id = '34') results
WHERE option_price > '0') results2
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
96 (0.741)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_left'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
97 (0.725)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
98 (0.621)
SELECT *
FROM oc_layout_module
WHERE layout_id = '15' AND position = 'column_right'
ORDER BY sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:23
99 (0.708)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_right'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
100 (0.570)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
101 (0.611)
SELECT *
FROM oc_layout_module
WHERE layout_id = '15' AND position = 'content_top'
ORDER BY sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:23
102 (0.729)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
103 (0.726)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'agootemplates/widgets/langmark/langmark'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
104 (0.637)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_top'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
105 (0.735)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
106 (0.734)
SELECT *
FROM oc_layout_module
WHERE layout_id = '15' AND position = 'content_bottom'
ORDER BY sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:23
107 (0.733)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_bottom'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
108 (0.733)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/buyoneclick' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
109 (0.616)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
110 (0.857)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/catalog/information.php:10
111 (0.715)
SELECT value
FROM oc_setting
WHERE `key` = 'module_microdatapro_key'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/microdatapro.php:137
112 (0.790)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2025-02-07 14:47:31'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/tool/online.php:4
113 (0.737)
REPLACE INTO `oc_customer_online` SET `ip` = '18.97.9.173', `customer_id` = '0', `url` = 'https://stockishop.com/vonyx', `referer` = '', `date_added` = '2025-02-07 15:47:31', `bot_name` = 'Bot'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/tool/online.php:15
114 (0.738)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/footer'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
115 (0.743)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/setting/extension.php:4
116 (0.614)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'related_options'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/lib/v0007/traits/installed.php:12
117 (0.733)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
118 (0.722)
SELECT *
FROM oc_store
ORDER BY url
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/setting/store.php:7
119 (0.743)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
120 (0.809)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/localisation/language.php:15
121 (0.581)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'agootemplates/record/langmark'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
122 (0.769)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
123 (0.800)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/currency'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
124 (0.660)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
125 (0.791)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/search'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
126 (0.775)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
127 (0.930)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
128 (0.996)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
129 (0.612)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/setting/extension.php:4
130 (0.602)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
131 (0.439)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
132 (0.650)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
133 (0.714)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
134 (0.758)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
135 (0.785)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
136 (0.499)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
137 (0.493)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
138 (0.755)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
139 (0.527)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
140 (0.340)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
141 (0.585)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'a9f867300de22183c7ca745416'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
142 (0.723)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/cart'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
143 (0.740)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
144 (0.682)
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 = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
145 (0.795)
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 = '20' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
146 (0.603)
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 = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
147 (0.773)
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 = '26' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
148 (0.762)
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 = '18' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
149 (0.532)
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 = '25' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
150 (0.609)
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 = '33' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
151 (0.383)
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 = '70' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
152 (0.711)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/menu'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
153 (0.743)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/header'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
154 (0.533)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/search' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
155 (0.550)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/buyoneclick' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
156 (0.778)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'product/manufacturer_info'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4