1 (0.306)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://selfy.com.ua/'
/home/selfy/selfy.com.ua/www/index.php:46
2 (9.341)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/selfy/selfy.com.ua/www/index.php:58
3 (0.428)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/selfy/selfy.com.ua/www/index.php:157
4 (0.211)
SELECT *
FROM oc_currency
/home/selfy/selfy.com.ua/www/system/library/currency.php:13
5 (0.375)
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 = '300012' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '200420')
ORDER BY tr1.priority ASC
/home/selfy/selfy.com.ua/www/system/library/tax.php:26
6 (0.275)
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 = '300012' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '200420')
ORDER BY tr1.priority ASC
/home/selfy/selfy.com.ua/www/system/library/tax.php:54
7 (0.286)
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/selfy/selfy.com.ua/www/system/library/weight.php:9
8 (0.238)
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/selfy/selfy.com.ua/www/system/library/length.php:9
9 (0.635)
DELETE
FROM oc_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 24 HOUR)
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:17
10 (0.378)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
11 (0.297)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
12 (0.283)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/selfy/selfy.com.ua/www/system/library/openbay.php:117
13 (0.176)
SELECT *
FROM oc_event
/home/selfy/selfy.com.ua/www/index.php:271
14 (0.460)
SELECT
GROUP_CONCAT(REPLACE(`query`, 'category_id=', '')
ORDER BY FIELD(keyword, 'demar-winter') SEPARATOR '_') AS path,
GROUP_CONCAT(`keyword`
ORDER BY FIELD(keyword, 'demar-winter') SEPARATOR '/') AS keywords
FROM oc_url_alias
WHERE `query` LIKE 'category_id=%' AND (keyword = 'demar-winter')
/home/selfy/selfy.com.ua/www/catalog/model/catalog/ocfilter.php:149
15 (0.364)
SELECT REPLACE(`query`, 'manufacturer_id=', '') AS manufacturer_id
FROM oc_url_alias
WHERE `query` LIKE 'manufacturer_id=%' AND LCASE(`keyword`) = 'demar-winter' LIMIT 1
/home/selfy/selfy.com.ua/www/catalog/model/catalog/ocfilter.php:124
16 (0.757)
SELECT p.manufacturer_id AS value_id, 'm' AS option_id, COUNT(DISTINCT p.product_id) AS total
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p2c.category_id = '122' GROUP BY p.manufacturer_id
/home/selfy/selfy.com.ua/www/catalog/model/catalog/ocfilter.php:603
17 (0.526)
SELECT IF(p.quantity > '0', 'in', 'out') AS value_id, 's' AS option_id, COUNT(DISTINCT p.product_id) AS total
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p2c.category_id = '122' GROUP BY value_id
/home/selfy/selfy.com.ua/www/catalog/model/catalog/ocfilter.php:603
18 (1.023)
SELECT oov2p.value_id, oov2p.option_id, COUNT(DISTINCT p.product_id) AS total
FROM oc_ocfilter_option_value_to_product oov2p
LEFT JOIN oc_product_to_category p2c ON (oov2p.product_id = p2c.product_id)
LEFT JOIN oc_product p ON (oov2p.product_id = p.product_id)
WHERE p.status = '1' AND oov2p.value_id > '0' AND p2c.category_id = '122' GROUP BY oov2p.option_id, oov2p.value_id
/home/selfy/selfy.com.ua/www/catalog/model/catalog/ocfilter.php:603
19 (1.236)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'july'
/home/selfy/selfy.com.ua/www/catalog/model/setting/setting.php:6
20 (0.362)
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 = '122' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:4
21 (0.607)
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 = '122' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
22 (0.743)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product p 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 pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '122'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:645
23 (1.287)
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_to_category p2c
LEFT JOIN oc_product p 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 pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '122' GROUP BY p.product_id
ORDER BY p.quantity DESC, p.product_id DESC LIMIT 0,48
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:250
24 (0.766)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '146' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
25 (0.741)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '144' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
26 (0.730)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '147' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
27 (0.711)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '148' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
28 (0.710)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '181' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
29 (0.665)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '24' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
30 (0.720)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '158' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
31 (0.720)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '88' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
32 (0.713)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '141' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
33 (0.678)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '123' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
34 (0.702)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '101' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
35 (0.724)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '9532' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
36 (0.666)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '149' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
37 (0.666)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '125' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
38 (0.696)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '182' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
39 (0.681)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '205' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
40 (0.674)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '90' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
41 (0.641)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '87' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
42 (0.709)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '180' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
43 (0.717)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '91' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
44 (0.649)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '103' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
45 (0.654)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '121' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
46 (0.710)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 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 = '140' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:14
47 (0.206)
SELECT *
FROM oc_product_to_category
WHERE product_id = '146'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
48 (0.138)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
49 (0.131)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
50 (0.173)
SELECT *
FROM oc_product_image
WHERE product_id = '146'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
51 (0.307)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
52 (0.273)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
53 (0.456)
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 = '146' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
54 (0.545)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '146' AND pov.product_option_id = '146' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
55 (0.197)
SELECT *
FROM oc_product_image
WHERE product_id = '146'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
56 (0.214)
SELECT *
FROM oc_product_sticker
WHERE product_id = '146'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
57 (1.012)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '146' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
58 (0.964)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '146' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
59 (0.324)
SELECT *
FROM oc_product_to_category
WHERE product_id = '144'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
60 (0.208)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
61 (0.154)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
62 (0.228)
SELECT *
FROM oc_product_image
WHERE product_id = '144'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
63 (0.353)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
64 (0.291)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
65 (0.464)
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 = '144' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
66 (0.521)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '144' AND pov.product_option_id = '144' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
67 (0.243)
SELECT *
FROM oc_product_image
WHERE product_id = '144'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
68 (0.236)
SELECT *
FROM oc_product_sticker
WHERE product_id = '144'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
69 (0.910)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '144' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
70 (1.227)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '144' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
71 (0.253)
SELECT *
FROM oc_product_to_category
WHERE product_id = '147'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
72 (0.202)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
73 (0.187)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
74 (0.204)
SELECT *
FROM oc_product_image
WHERE product_id = '147'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
75 (0.371)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
76 (0.355)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
77 (0.419)
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 = '147' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
78 (0.552)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '147' AND pov.product_option_id = '147' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
79 (0.167)
SELECT *
FROM oc_product_image
WHERE product_id = '147'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
80 (0.197)
SELECT *
FROM oc_product_sticker
WHERE product_id = '147'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
81 (0.887)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '147' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
82 (0.778)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '147' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
83 (0.183)
SELECT *
FROM oc_product_to_category
WHERE product_id = '148'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
84 (0.162)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
85 (0.131)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
86 (0.165)
SELECT *
FROM oc_product_image
WHERE product_id = '148'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
87 (0.317)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
88 (0.228)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
89 (0.323)
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 = '148' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
90 (0.561)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '148' AND pov.product_option_id = '148' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
91 (0.186)
SELECT *
FROM oc_product_image
WHERE product_id = '148'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
92 (0.177)
SELECT *
FROM oc_product_sticker
WHERE product_id = '148'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
93 (0.817)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '148' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
94 (0.742)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '148' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
95 (0.202)
SELECT *
FROM oc_product_to_category
WHERE product_id = '181'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
96 (0.184)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
97 (0.154)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
98 (0.164)
SELECT *
FROM oc_product_image
WHERE product_id = '181'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
99 (0.313)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
100 (0.228)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
101 (0.308)
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 = '181' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
102 (0.460)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '181' AND pov.product_option_id = '181' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
103 (0.184)
SELECT *
FROM oc_product_image
WHERE product_id = '181'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
104 (0.235)
SELECT *
FROM oc_product_sticker
WHERE product_id = '181'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
105 (0.738)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '181' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
106 (0.781)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '181' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
107 (0.180)
SELECT *
FROM oc_product_to_category
WHERE product_id = '24'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
108 (0.121)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
109 (0.192)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
110 (0.221)
SELECT *
FROM oc_product_image
WHERE product_id = '24'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
111 (0.300)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
112 (0.284)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
113 (0.421)
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 = '24' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
114 (0.596)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '24' AND pov.product_option_id = '24' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
115 (0.214)
SELECT *
FROM oc_product_image
WHERE product_id = '24'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
116 (0.239)
SELECT *
FROM oc_product_sticker
WHERE product_id = '24'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
117 (0.868)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '24' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
118 (1.133)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '24' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
119 (0.227)
SELECT *
FROM oc_product_to_category
WHERE product_id = '158'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
120 (0.185)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
121 (0.189)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
122 (0.209)
SELECT *
FROM oc_product_image
WHERE product_id = '158'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
123 (0.345)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
124 (0.314)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
125 (0.421)
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 = '158' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
126 (0.583)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '158' AND pov.product_option_id = '158' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
127 (0.214)
SELECT *
FROM oc_product_image
WHERE product_id = '158'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
128 (0.249)
SELECT *
FROM oc_product_sticker
WHERE product_id = '158'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
129 (0.856)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '158' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
130 (1.127)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '158' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
131 (0.233)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '158'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
132 (0.301)
SELECT *
FROM oc_product_to_category
WHERE product_id = '88'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
133 (0.136)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
134 (0.130)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
135 (0.228)
SELECT *
FROM oc_product_image
WHERE product_id = '88'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
136 (0.327)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
137 (0.251)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
138 (0.383)
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 = '88' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
139 (0.593)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '88' AND pov.product_option_id = '88' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
140 (0.193)
SELECT *
FROM oc_product_image
WHERE product_id = '88'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
141 (0.202)
SELECT *
FROM oc_product_sticker
WHERE product_id = '88'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
142 (0.767)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '88' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
143 (1.251)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '88' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
144 (0.262)
SELECT *
FROM oc_product_to_category
WHERE product_id = '141'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
145 (0.186)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
146 (0.174)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '152'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
147 (0.214)
SELECT *
FROM oc_product_image
WHERE product_id = '141'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
148 (2.456)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
149 (0.341)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
150 (0.525)
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 = '141' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
151 (0.722)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '141' AND pov.product_option_id = '141' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
152 (0.238)
SELECT *
FROM oc_product_image
WHERE product_id = '141'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
153 (0.250)
SELECT *
FROM oc_product_sticker
WHERE product_id = '141'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
154 (0.925)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '141' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
155 (1.254)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '141' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
156 (0.251)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '141'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
157 (0.420)
SELECT *
FROM oc_product_to_category
WHERE product_id = '123'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
158 (0.156)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
159 (0.142)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '152'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
160 (0.176)
SELECT *
FROM oc_product_image
WHERE product_id = '123'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
161 (0.339)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
162 (0.232)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
163 (0.356)
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 = '123' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
164 (0.478)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '123' AND pov.product_option_id = '123' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
165 (0.163)
SELECT *
FROM oc_product_image
WHERE product_id = '123'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
166 (0.193)
SELECT *
FROM oc_product_sticker
WHERE product_id = '123'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
167 (0.634)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '123' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
168 (0.801)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '123' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
169 (0.182)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '123'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
170 (0.415)
SELECT *
FROM oc_product_to_category
WHERE product_id = '101'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
171 (0.174)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
172 (0.145)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '152'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
173 (0.206)
SELECT *
FROM oc_product_image
WHERE product_id = '101'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
174 (0.388)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
175 (0.270)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
176 (0.441)
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 = '101' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
177 (0.617)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '101' AND pov.product_option_id = '101' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
178 (0.243)
SELECT *
FROM oc_product_image
WHERE product_id = '101'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
179 (0.251)
SELECT *
FROM oc_product_sticker
WHERE product_id = '101'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
180 (0.887)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '101' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
181 (1.202)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '101' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
182 (0.279)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '101'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
183 (0.415)
SELECT *
FROM oc_product_to_category
WHERE product_id = '9532'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
184 (0.171)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
185 (0.162)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
186 (0.207)
SELECT *
FROM oc_product_image
WHERE product_id = '9532'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
187 (0.403)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
188 (0.289)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
189 (0.432)
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 = '9532' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
190 (0.611)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '9532' AND pov.product_option_id = '3143' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
191 (0.181)
SELECT *
FROM oc_product_image
WHERE product_id = '9532'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
192 (0.212)
SELECT *
FROM oc_product_sticker
WHERE product_id = '9532'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
193 (0.847)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '9532' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
194 (1.099)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '9532' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
195 (0.214)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '9532'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
196 (0.340)
SELECT *
FROM oc_product_to_category
WHERE product_id = '149'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
197 (0.173)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
198 (0.179)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
199 (0.291)
SELECT *
FROM oc_product_image
WHERE product_id = '149'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
200 (0.416)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
201 (0.334)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
202 (0.495)
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 = '149' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
203 (0.665)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '149' AND pov.product_option_id = '149' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
204 (0.248)
SELECT *
FROM oc_product_image
WHERE product_id = '149'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
205 (0.262)
SELECT *
FROM oc_product_sticker
WHERE product_id = '149'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
206 (0.856)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '149' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
207 (1.190)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '149' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
208 (0.270)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '149'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
209 (0.535)
SELECT *
FROM oc_product_to_category
WHERE product_id = '125'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
210 (0.179)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
211 (0.187)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '152'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
212 (0.251)
SELECT *
FROM oc_product_image
WHERE product_id = '125'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
213 (0.436)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
214 (0.333)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
215 (0.481)
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 = '125' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
216 (0.656)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '125' AND pov.product_option_id = '125' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
217 (0.220)
SELECT *
FROM oc_product_image
WHERE product_id = '125'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
218 (0.263)
SELECT *
FROM oc_product_sticker
WHERE product_id = '125'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
219 (0.864)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '125' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
220 (1.152)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '125' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
221 (0.228)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '125'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
222 (0.325)
SELECT *
FROM oc_product_to_category
WHERE product_id = '182'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
223 (0.190)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
224 (0.182)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
225 (0.221)
SELECT *
FROM oc_product_image
WHERE product_id = '182'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
226 (0.418)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
227 (1.433)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
228 (0.500)
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 = '182' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
229 (0.619)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '182' AND pov.product_option_id = '182' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
230 (0.225)
SELECT *
FROM oc_product_image
WHERE product_id = '182'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
231 (0.260)
SELECT *
FROM oc_product_sticker
WHERE product_id = '182'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
232 (0.862)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '182' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
233 (1.252)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '182' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
234 (0.226)
SELECT *
FROM oc_product_to_category
WHERE product_id = '205'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
235 (0.195)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
236 (0.172)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '123'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
237 (0.176)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '201'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
238 (0.219)
SELECT *
FROM oc_product_image
WHERE product_id = '205'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
239 (0.406)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
240 (0.316)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
241 (0.475)
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 = '205' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
242 (0.592)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '205' AND pov.product_option_id = '205' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
243 (0.217)
SELECT *
FROM oc_product_image
WHERE product_id = '205'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
244 (0.245)
SELECT *
FROM oc_product_sticker
WHERE product_id = '205'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
245 (0.218)
SELECT *
FROM oc_product_discount
WHERE product_id = '205' AND customer_group_id = '1' AND ((date_start = '0000-00-00' OR date_start < '2019-02-17 12:53:00') AND (date_end = '0000-00-00' OR date_end > '2019-02-17 12:53:00'))
ORDER BY quantity ASC, priority ASC, price ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:67
246 (0.787)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '205' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
247 (1.105)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '205' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
248 (0.225)
SELECT *
FROM oc_product_to_category
WHERE product_id = '90'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
249 (0.185)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
250 (0.169)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
251 (0.206)
SELECT *
FROM oc_product_image
WHERE product_id = '90'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
252 (0.362)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
253 (0.314)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
254 (0.461)
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 = '90' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
255 (0.645)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '90' AND pov.product_option_id = '90' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
256 (0.217)
SELECT *
FROM oc_product_image
WHERE product_id = '90'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
257 (0.237)
SELECT *
FROM oc_product_sticker
WHERE product_id = '90'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
258 (0.838)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '90' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
259 (1.130)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '90' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
260 (0.228)
SELECT *
FROM oc_product_to_category
WHERE product_id = '87'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
261 (0.190)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
262 (0.172)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
263 (0.204)
SELECT *
FROM oc_product_image
WHERE product_id = '87'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
264 (0.361)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
265 (0.296)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
266 (0.461)
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 = '87' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
267 (0.652)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '87' AND pov.product_option_id = '87' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
268 (0.228)
SELECT *
FROM oc_product_image
WHERE product_id = '87'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
269 (0.247)
SELECT *
FROM oc_product_sticker
WHERE product_id = '87'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
270 (0.899)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '87' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
271 (1.170)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '87' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
272 (0.229)
SELECT *
FROM oc_product_to_category
WHERE product_id = '180'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
273 (0.176)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
274 (0.166)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
275 (0.198)
SELECT *
FROM oc_product_image
WHERE product_id = '180'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
276 (0.369)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
277 (0.289)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
278 (0.342)
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 = '180' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
279 (0.481)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '180' AND pov.product_option_id = '180' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
280 (0.172)
SELECT *
FROM oc_product_image
WHERE product_id = '180'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
281 (0.185)
SELECT *
FROM oc_product_sticker
WHERE product_id = '180'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
282 (0.689)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '180' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
283 (0.846)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '180' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
284 (0.166)
SELECT *
FROM oc_product_to_category
WHERE product_id = '91'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
285 (0.141)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
286 (0.145)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '151'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
287 (0.157)
SELECT *
FROM oc_product_image
WHERE product_id = '91'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
288 (0.255)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
289 (0.227)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
290 (0.326)
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 = '91' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
291 (0.431)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '91' AND pov.product_option_id = '91' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
292 (0.157)
SELECT *
FROM oc_product_image
WHERE product_id = '91'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
293 (0.177)
SELECT *
FROM oc_product_sticker
WHERE product_id = '91'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
294 (0.602)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '91' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
295 (0.767)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '91' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
296 (0.174)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '91'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
297 (0.351)
SELECT *
FROM oc_product_to_category
WHERE product_id = '103'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
298 (0.161)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
299 (0.135)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '152'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
300 (0.186)
SELECT *
FROM oc_product_image
WHERE product_id = '103'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
301 (0.325)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
302 (0.226)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
303 (0.343)
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 = '103' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
304 (0.498)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '103' AND pov.product_option_id = '103' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
305 (0.153)
SELECT *
FROM oc_product_image
WHERE product_id = '103'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
306 (0.180)
SELECT *
FROM oc_product_sticker
WHERE product_id = '103'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
307 (0.607)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '103' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
308 (0.785)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '103' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
309 (0.168)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '103'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
310 (0.364)
SELECT *
FROM oc_product_to_category
WHERE product_id = '121'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
311 (0.164)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
312 (0.140)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '152'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
313 (0.200)
SELECT *
FROM oc_product_image
WHERE product_id = '121'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
314 (0.336)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
315 (0.249)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
316 (0.354)
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 = '121' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
317 (0.482)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '121' AND pov.product_option_id = '121' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
318 (0.171)
SELECT *
FROM oc_product_image
WHERE product_id = '121'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
319 (0.186)
SELECT *
FROM oc_product_sticker
WHERE product_id = '121'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
320 (0.692)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '121' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
321 (0.827)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '121' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
322 (0.175)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '121'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
323 (0.328)
SELECT *
FROM oc_product_to_category
WHERE product_id = '140'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:516
324 (0.179)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '122'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
325 (0.162)
SELECT c.allow
FROM oc_category c
WHERE c.category_id = '152'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:16
326 (0.205)
SELECT *
FROM oc_product_image
WHERE product_id = '140'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
327 (1.443)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'image'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:429
328 (0.384)
SHOW COLUMNS
FROM `oc_product_option_value` LIKE 'sku'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:431
329 (0.583)
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 = '140' AND od.language_id = '1'
ORDER BY o.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:441
330 (0.848)
SELECT *, IF(pov.image = '', ov.image, pov.image) AS image
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '140' AND pov.product_option_id = '140' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:446
331 (0.231)
SELECT *
FROM oc_product_image
WHERE product_id = '140'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:488
332 (0.232)
SELECT *
FROM oc_product_sticker
WHERE product_id = '140'
ORDER BY sort_order ASC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/july_stickers.php:5
333 (0.897)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '140' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:402
334 (1.255)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '140' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/catalog/product.php:407
335 (0.244)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '140'
ORDER BY main_category DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/controller/common/seo_pro.php:385
336 (0.224)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '122' AND store_id = '0'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:116
337 (0.214)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:16
338 (0.179)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'post_header'
ORDER BY sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:26
339 (0.153)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '122' AND store_id = '0'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:116
340 (0.303)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:16
341 (0.182)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'pre_footer'
ORDER BY sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:26
342 (0.165)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '122' AND store_id = '0'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:116
343 (0.395)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:16
344 (0.244)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:26
345 (0.371)
SELECT *
FROM oc_module
WHERE module_id = '70'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/extension/module.php:4
346 (0.551)
SELECT p.ID
FROM oc_july_blog_post p
LEFT JOIN oc_july_blog_post_description pd ON (p.ID = pd.post_id)
LEFT JOIN oc_july_blog_post_to_store p2s ON (p.ID = p2s.post_id)
WHERE pd.language_id = '1' AND p.post_status = 'publish' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.ID
ORDER BY p.date_available DESC LIMIT 0,3
/home/selfy/selfy.com.ua/www/catalog/model/blog/post.php:249
347 (0.806)
SELECT DISTINCT *, pd.title, p.post_thumb
FROM oc_july_blog_post p
LEFT JOIN oc_july_blog_post_description pd ON (p.ID = pd.post_id)
LEFT JOIN oc_july_blog_post_to_store p2s ON (p.ID = p2s.post_id)
WHERE p.ID='97' AND pd.language_id = '1' AND p.post_status = 'publish' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/catalog/model/blog/post.php:104
348 (0.181)
SELECT *
FROM oc_july_blog_postmeta pm
WHERE post_id='97' LIMIT 0,20
/home/selfy/selfy.com.ua/www/catalog/model/blog/post.php:406
349 (0.604)
SELECT DISTINCT *, pd.title, p.post_thumb
FROM oc_july_blog_post p
LEFT JOIN oc_july_blog_post_description pd ON (p.ID = pd.post_id)
LEFT JOIN oc_july_blog_post_to_store p2s ON (p.ID = p2s.post_id)
WHERE p.ID='96' AND pd.language_id = '1' AND p.post_status = 'publish' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/catalog/model/blog/post.php:104
350 (0.166)
SELECT *
FROM oc_july_blog_postmeta pm
WHERE post_id='96' LIMIT 0,20
/home/selfy/selfy.com.ua/www/catalog/model/blog/post.php:406
351 (0.549)
SELECT DISTINCT *, pd.title, p.post_thumb
FROM oc_july_blog_post p
LEFT JOIN oc_july_blog_post_description pd ON (p.ID = pd.post_id)
LEFT JOIN oc_july_blog_post_to_store p2s ON (p.ID = p2s.post_id)
WHERE p.ID='95' AND pd.language_id = '1' AND p.post_status = 'publish' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/selfy/selfy.com.ua/www/catalog/model/blog/post.php:104
352 (0.162)
SELECT *
FROM oc_july_blog_postmeta pm
WHERE post_id='95' LIMIT 0,20
/home/selfy/selfy.com.ua/www/catalog/model/blog/post.php:406
353 (0.324)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '122' AND store_id = '0'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:116
354 (0.350)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:16
355 (0.185)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:26
356 (0.174)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '122' AND store_id = '0'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:116
357 (0.300)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:16
358 (0.185)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:26
359 (0.335)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '122' AND store_id = '0'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:116
360 (0.336)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:16
361 (0.230)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:26
362 (0.170)
SELECT *
FROM oc_module
WHERE module_id = '117'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/extension/module.php:4
363 (1.374)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'july'
/home/selfy/selfy.com.ua/www/catalog/model/setting/setting.php:6
364 (16.149)
SELECT DISTINCT product_id
FROM oc_product_viewed
WHERE session_token = '' GROUP BY product_id
ORDER BY product_viewed_id DESC
/home/selfy/selfy.com.ua/www/catalog/model/catalog/ochelp_viewed.php:56
365 (0.233)
SELECT *
FROM oc_module
WHERE module_id = '115'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/extension/module.php:4
366 (1.384)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'july'
/home/selfy/selfy.com.ua/www/catalog/model/setting/setting.php:6
367 (0.352)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/selfy/selfy.com.ua/www/catalog/model/extension/extension.php:4
368 (2.151)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'july'
/home/selfy/selfy.com.ua/www/catalog/model/setting/setting.php:6
369 (0.369)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '122' AND store_id = '0'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:116
370 (0.340)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:16
371 (0.254)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'topmenu'
ORDER BY sort_order
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/design/layout.php:26
372 (0.322)
SELECT *
FROM oc_module
WHERE module_id = '83'
/home/selfy/selfy.com.ua/www/system/storage/modification/catalog/model/extension/module.php:4
373 (1.060)
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 = '124' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
374 (0.429)
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 = '124' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:4
375 (0.580)
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 = '185' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
376 (0.469)
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 = '186' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
377 (0.454)
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 = '266' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
378 (0.405)
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 = '187' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
379 (0.348)
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 = '188' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
380 (0.529)
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 = '171' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
381 (0.296)
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 = '171' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:4
382 (0.401)
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 = '283' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
383 (0.347)
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 = '198' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
384 (0.349)
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 = '196' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
385 (0.365)
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 = '197' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
386 (0.489)
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 = '275' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
387 (0.280)
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 = '275' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:4
388 (0.447)
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 = '278' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
389 (0.369)
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 = '279' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
390 (0.333)
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 = '277' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
391 (0.444)
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 = '123' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
392 (0.234)
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 = '123' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:4
393 (0.321)
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 = '199' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
394 (0.358)
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 = '201' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
395 (0.358)
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 = '202' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
396 (0.439)
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 = '232' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
397 (0.214)
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 = '232' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:4
398 (0.319)
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 = '234' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
399 (0.330)
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 = '235' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
400 (0.318)
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 = '233' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
401 (0.460)
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 = '130' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
402 (0.264)
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 = '130' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:4
403 (0.348)
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 = '209' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
404 (0.361)
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 = '210' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
405 (0.319)
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 = '211' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
406 (0.356)
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 = '212' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/selfy/selfy.com.ua/www/catalog/model/catalog/category.php:10
407 (0.473)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
408 (0.336)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
409 (0.352)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/selfy/selfy.com.ua/www/catalog/model/extension/extension.php:4
410 (0.353)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
411 (0.428)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
412 (0.364)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
413 (0.379)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
414 (0.293)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
415 (0.301)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
416 (0.246)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
417 (0.340)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'kii4cte2u3qf873qdchfdrs8j2'
/home/selfy/selfy.com.ua/www/system/storage/modification/system/library/cart.php:56
