1 (0.550)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/saufer/data/www/pinky-shop.com.ua/system/library/openbay.php:117
2 (0.311)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://pinky-shop.com.ua/'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/controller/startup/startup.php:6
3 (10.241)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/controller/startup/startup.php:25
4 (0.421)
SELECT *
FROM oc_currency
/var/www/saufer/data/www/pinky-shop.com.ua/system/library/cart/currency.php:10
5 (5.297)
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 = '300001' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/saufer/data/www/pinky-shop.com.ua/system/library/cart/tax.php:17
6 (3.147)
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 = '300001' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/saufer/data/www/pinky-shop.com.ua/system/library/cart/tax.php:45
7 (0.415)
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'
/var/www/saufer/data/www/pinky-shop.com.ua/system/library/cart/weight.php:10
8 (0.384)
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'
/var/www/saufer/data/www/pinky-shop.com.ua/system/library/cart/length.php:10
9 (0.366)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 14 DAY)
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/system/library/cart/cart.php:22
10 (0.334)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/saufer/data/www/pinky-shop.com.ua/system/library/openbay.php:117
11 (0.402)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `event_id` ASC
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/event.php:4
12 (7.198)
SELECT
GROUP_CONCAT(REPLACE(`query`, 'category_id=', '')
ORDER BY FIELD(keyword, 'bodistoking-bs050-black.html') SEPARATOR '_') AS path,
GROUP_CONCAT(`keyword`
ORDER BY FIELD(keyword, 'bodistoking-bs050-black.html') SEPARATOR '/') AS keywords
FROM oc_url_alias
WHERE `query` LIKE 'category_id=%' AND (keyword = 'bodistoking-bs050-black.html')
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/catalog/ocfilter.php:149
13 (0.629)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '1522'
ORDER BY main_category DESC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/controller/startup/seo_pro.php:267
14 (0.301)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/controller/common/seoblog.php:77
15 (0.273)
SELECT *
FROM oc_url_alias_blog
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/controller/common/seoblog.php:101
16 (0.331)
SELECT blog_id, design, path
FROM oc_blog
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/controller/common/seoblog.php:113
17 (0.622)
SELECT *
FROM oc_layout l
LEFT JOIN oc_layout_route lr ON (l.layout_id = lr.layout_id)
ORDER BY name ASC
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/bloglayout.php:42
18 (2.488)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'coloring'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/setting/setting.php:6
19 (0.525)
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 = '120' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/catalog/category.php:4
20 (1.739)
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 = '1522' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
21 (0.295)
SELECT canonical_product_id
FROM oc_prduct_canonical
WHERE product_id = '1522'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:248
22 (0.603)
SELECT *
FROM oc_product_image
WHERE product_id = '1522'
ORDER BY sort_order ASC
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:434
23 (0.721)
SELECT *
FROM oc_product_discount
WHERE product_id = '1522' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:428
24 (14.163)
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 = '1522' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:387
25 (3.849)
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 = '1522' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:359
26 (9.222)
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 = '1522' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:364
27 (0.753)
SELECT *
FROM oc_product_related pr
LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '1522' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:442
28 (2.889)
SELECT rd.*
FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 1522 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:598
29 (0.680)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '1522'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:4
30 (2.806)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'coloring'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/setting/setting.php:6
31 (0.990)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1522' AND store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:452
32 (0.434)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:4
33 (0.397)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/agoo/design/layout.php:124
34 (0.465)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:14
35 (0.340)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1522' AND store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:452
36 (0.365)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:4
37 (0.427)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/agoo/design/layout.php:124
38 (2.796)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'coloring'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/setting/setting.php:6
39 (0.379)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1522' AND store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:452
40 (0.381)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:4
41 (0.412)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/agoo/design/layout.php:124
42 (0.359)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:14
43 (0.329)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1522' AND store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:452
44 (0.362)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:4
45 (0.457)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/agoo/design/layout.php:124
46 (0.396)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1522' AND store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:452
47 (0.527)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:4
48 (0.471)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/agoo/design/layout.php:124
49 (0.418)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:14
50 (0.347)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1522' AND store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:452
51 (0.340)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:4
52 (0.378)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/agoo/design/layout.php:124
53 (0.490)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1522' AND store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:452
54 (0.500)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:4
55 (0.417)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/agoo/design/layout.php:124
56 (0.357)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:14
57 (0.288)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '1522' AND store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:452
58 (0.421)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/layout.php:4
59 (0.366)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/agoo/design/layout.php:124
60 (0.284)
SELECT *
FROM oc_module
WHERE module_id = '45'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module.php:4
61 (2.501)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'coloring'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/setting/setting.php:6
62 (1.570)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '1522'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
63 (0.503)
SELECT *
FROM oc_product_to_category p2c
JOIN oc_product p on p.product_id=p2c.product_id
WHERE p.product_id = '1522'
AND p.status = '1'
AND p.date_available <= NOW()
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:72
64 (21.842)
SELECT p.product_id
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
JOIN oc_product_to_category p2c on p.product_id=p2c.product_id
WHERE p.product_id <> '1522'
AND p.status = '1'
AND p.date_available <= NOW()
AND p.quantity>0
AND p.price>0
AND pa.language_id = '1'
AND ( (pa.attribute_id='3' AND pa.text='Passion') )
AND p2c.category_id in (120,124)
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
group by product_id
order by count(*) DESC, p.price, p.product_id
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:124
65 (1.489)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '528'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
66 (1.690)
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 = '528' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
67 (1.353)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '532'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
68 (1.563)
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 = '532' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
69 (1.359)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '537'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
70 (1.534)
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 = '537' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
71 (1.395)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '540'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
72 (1.536)
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 = '540' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
73 (1.374)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '547'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
74 (1.513)
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 = '547' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
75 (1.476)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '550'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
76 (1.497)
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 = '550' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
77 (1.367)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '552'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
78 (1.501)
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 = '552' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
79 (1.366)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '563'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
80 (1.533)
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 = '563' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
81 (1.367)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '565'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
82 (1.540)
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 = '565' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
83 (1.385)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '566'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
84 (1.567)
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 = '566' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
85 (1.471)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '574'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
86 (1.518)
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 = '574' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
87 (1.388)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '578'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
88 (1.520)
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 = '578' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
89 (1.365)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '579'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
90 (1.527)
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 = '579' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
91 (1.415)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '609'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
92 (1.477)
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 = '609' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
93 (1.371)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '611'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
94 (1.548)
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 = '611' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
95 (1.345)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '615'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
96 (1.535)
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 = '615' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
97 (1.466)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '749'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
98 (1.533)
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 = '749' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
99 (1.376)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '1540'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
100 (1.527)
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 = '1540' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
101 (1.372)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '10402'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
102 (1.570)
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 = '10402' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
103 (1.409)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '10412'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
104 (1.554)
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 = '10412' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/catalog/model/catalog/product.php:8
105 (1.386)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '1312'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (30,15,23,29,5,33,21,34,22,35,16,24,26,12,17,27,2,1,13,7,25,8,28,10,31,6,14,11,19,4,32,9,20)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module/nkf_similar_products.php:23
106 (0.380)
SELECT date_end
FROM oc_product_special
WHERE product_id ='528' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
107 (0.457)
SELECT date_end
FROM oc_product_special
WHERE product_id ='532' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
108 (0.348)
SELECT date_end
FROM oc_product_special
WHERE product_id ='537' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
109 (0.372)
SELECT date_end
FROM oc_product_special
WHERE product_id ='540' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
110 (0.336)
SELECT date_end
FROM oc_product_special
WHERE product_id ='547' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
111 (0.341)
SELECT date_end
FROM oc_product_special
WHERE product_id ='550' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
112 (0.468)
SELECT date_end
FROM oc_product_special
WHERE product_id ='552' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
113 (0.343)
SELECT date_end
FROM oc_product_special
WHERE product_id ='563' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
114 (0.341)
SELECT date_end
FROM oc_product_special
WHERE product_id ='565' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
115 (0.338)
SELECT date_end
FROM oc_product_special
WHERE product_id ='566' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
116 (0.404)
SELECT date_end
FROM oc_product_special
WHERE product_id ='574' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
117 (0.353)
SELECT date_end
FROM oc_product_special
WHERE product_id ='578' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
118 (0.379)
SELECT date_end
FROM oc_product_special
WHERE product_id ='579' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
119 (0.361)
SELECT date_end
FROM oc_product_special
WHERE product_id ='609' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
120 (0.345)
SELECT date_end
FROM oc_product_special
WHERE product_id ='611' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
121 (0.337)
SELECT date_end
FROM oc_product_special
WHERE product_id ='615' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
122 (0.337)
SELECT date_end
FROM oc_product_special
WHERE product_id ='749' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
123 (0.355)
SELECT date_end
FROM oc_product_special
WHERE product_id ='1540' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
124 (0.340)
SELECT date_end
FROM oc_product_special
WHERE product_id ='10402' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
125 (0.348)
SELECT date_end
FROM oc_product_special
WHERE product_id ='10412' AND date_start <= NOW() AND date_end >= NOW()
ORDER BY priority LIMIT 0,1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/coloring/coloring.php:18
126 (0.476)
SELECT *
FROM oc_module
WHERE module_id = '42'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/module.php:4
127 (2.555)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'coloring'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/setting/setting.php:6
128 (0.814)
SELECT m.*,
(SELECT description
FROM oc_multi_modal_translate
WHERE `key` = 'title' AND modal_id = m.id AND lang_id = '1') AS title,
(SELECT description
FROM oc_multi_modal_translate
WHERE `key` = 'content' AND modal_id = m.id AND lang_id = '1') AS content
FROM oc_multi_modals m
WHERE m.status = 1
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/catalog/multimodal.php:10
129 (2.534)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'coloring'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/setting/setting.php:6
130 (2.389)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'coloring'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/setting/setting.php:6
131 (0.536)
SELECT *
FROM oc_banner b
LEFT JOIN oc_banner_image bi ON (b.banner_id = bi.banner_id)
WHERE b.banner_id = '9' AND b.status = '1' AND bi.language_id = '1'
ORDER BY bi.sort_order ASC
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/design/banner.php:4
132 (10.786)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/catalog/information.php:10
133 (0.556)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/extension.php:4
134 (2.602)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'coloring'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/setting/setting.php:6
135 (18.101)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/catalog/category.php:10
136 (0.459)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'pdfgn7kaak8v7meoip1q7po0l2'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/system/library/cart/cart.php:50
137 (0.407)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/saufer/data/www/pinky-shop.com.ua/catalog/model/extension/extension.php:4
138 (0.398)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'pdfgn7kaak8v7meoip1q7po0l2'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/system/library/cart/cart.php:50
139 (0.483)
SELECT SUM(quantity) as total
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'pdfgn7kaak8v7meoip1q7po0l2'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/system/library/cart/cart.php:443
140 (0.393)
SELECT SUM(quantity) as total
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'pdfgn7kaak8v7meoip1q7po0l2'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/system/library/cart/cart.php:443
141 (0.341)
SELECT SUM(quantity) as total
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'pdfgn7kaak8v7meoip1q7po0l2'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/system/library/cart/cart.php:443
142 (0.312)
SELECT SUM(quantity) as total
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'pdfgn7kaak8v7meoip1q7po0l2'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/system/library/cart/cart.php:443
143 (0.383)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'pdfgn7kaak8v7meoip1q7po0l2'
/var/www/saufer/data/www/pinky-shop.com.ua/system/storage/modification/system/library/cart/cart.php:50