1 (1.162)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://sklad-dverey.com.ua/'
/var/www/skladdve/data/www/sklad-dverey.com.ua/index.php:37
2 (5.339)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/index.php:49
3 (0.943)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/skladdve/data/www/sklad-dverey.com.ua/index.php:148
4 (11.835)
SELECT *
FROM oc_currency
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/library/currency.php:13
5 (13.383)
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 = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/library/tax.php:26
6 (1.425)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/library/tax.php:54
7 (11.087)
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/skladdve/data/www/sklad-dverey.com.ua/system/library/weight.php:9
8 (3.476)
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/skladdve/data/www/sklad-dverey.com.ua/system/library/length.php:9
9 (0.508)
DELETE
FROM oc_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:14
10 (0.368)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/library/openbay.php:117
11 (0.958)
SELECT *
FROM oc_event
/var/www/skladdve/data/www/sklad-dverey.com.ua/index.php:257
12 (33.731)
SELECT `url`
FROM `oc_language`
WHERE `language_id` = '1'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:32
13 (0.559)
SELECT *
FROM oc_language
WHERE status = '1'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:36
14 (20.944)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25887'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
15 (7.691)
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 = '63' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/catalog/category.php:4
16 (18.178)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25887' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
17 (468.237)
SELECT *
FROM oc_product_ukrcredits
WHERE product_id = '25887'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/uc/uc56.php:5
18 (16.328)
SELECT *
FROM oc_product_image
WHERE product_id = '25887'
ORDER BY sort_order ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:517
19 (9.872)
SELECT *
FROM oc_product_discount
WHERE product_id = '25887' 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/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:511
20 (80.015)
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 = '25887' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:455
21 (39.248)
SELECT *
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 = '25887' AND pov.product_option_id = '291624' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:460
22 (19.474)
SELECT ag.`attribute_group_id`, agd.`name` AS name_group, a.`attribute_id`, ad.`name`, agd.`tooltip` AS tooltip_group , ad.`tooltip`
FROM `oc_attribute_text_product` atp
LEFT JOIN `oc_attribute` a ON (atp.`attribute_id` = a.`attribute_id`)
LEFT JOIN `oc_attribute_group` ag ON (a.`attribute_group_id` = ag.`attribute_group_id`)
LEFT JOIN `oc_attribute_description` ad ON (a.`attribute_id` = ad.`attribute_id`)
LEFT JOIN `oc_attribute_group_description` agd ON (ag.`attribute_group_id` = agd.`attribute_group_id`)
WHERE atp.`product_id` = 25887 AND agd.`language_id` = 1 AND ad.`language_id` = 1 GROUP BY a.`attribute_id`
ORDER BY ag.`sort_order`, `name_group`, a.`sort_order`, ad.`name`
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:377
23 (13.527)
SELECT at.`text_id`, atl.`text`, at.`image`
FROM `oc_attribute_text_product` atp
LEFT JOIN `oc_attribute_text` at ON (atp.`text_id` = at.`text_id`)
LEFT JOIN `oc_attribute_text_lang` atl ON (at.`text_id` = atl.`text_id`)
WHERE atp.`product_id` = 25887 AND atp.`attribute_id` = 420 AND atl.`language_id` = 1 GROUP BY at.`text_id`
ORDER BY at.`sort_order`, atl.`text`
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:380
24 (10.714)
SELECT at.`text_id`, atl.`text`, at.`image`
FROM `oc_attribute_text_product` atp
LEFT JOIN `oc_attribute_text` at ON (atp.`text_id` = at.`text_id`)
LEFT JOIN `oc_attribute_text_lang` atl ON (at.`text_id` = atl.`text_id`)
WHERE atp.`product_id` = 25887 AND atp.`attribute_id` = 434 AND atl.`language_id` = 1 GROUP BY at.`text_id`
ORDER BY at.`sort_order`, atl.`text`
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:380
25 (13.093)
SELECT at.`text_id`, atl.`text`, at.`image`
FROM `oc_attribute_text_product` atp
LEFT JOIN `oc_attribute_text` at ON (atp.`text_id` = at.`text_id`)
LEFT JOIN `oc_attribute_text_lang` atl ON (at.`text_id` = atl.`text_id`)
WHERE atp.`product_id` = 25887 AND atp.`attribute_id` = 352 AND atl.`language_id` = 1 GROUP BY at.`text_id`
ORDER BY at.`sort_order`, atl.`text`
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:380
26 (62.986)
SELECT at.`text_id`, atl.`text`, at.`image`
FROM `oc_attribute_text_product` atp
LEFT JOIN `oc_attribute_text` at ON (atp.`text_id` = at.`text_id`)
LEFT JOIN `oc_attribute_text_lang` atl ON (at.`text_id` = atl.`text_id`)
WHERE atp.`product_id` = 25887 AND atp.`attribute_id` = 340 AND atl.`language_id` = 1 GROUP BY at.`text_id`
ORDER BY at.`sort_order`, atl.`text`
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:380
27 (24.346)
SELECT at.`text_id`, atl.`text`, at.`image`
FROM `oc_attribute_text_product` atp
LEFT JOIN `oc_attribute_text` at ON (atp.`text_id` = at.`text_id`)
LEFT JOIN `oc_attribute_text_lang` atl ON (at.`text_id` = atl.`text_id`)
WHERE atp.`product_id` = 25887 AND atp.`attribute_id` = 310 AND atl.`language_id` = 1 GROUP BY at.`text_id`
ORDER BY at.`sort_order`, atl.`text`
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:380
28 (9.292)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '25887'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/xdstickers.php:9
29 (6.029)
SELECT *
FROM oc_xdstickers
WHERE xdsticker_id = '4'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/xdstickers.php:4
30 (5.332)
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 = '25887' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:525
31 (1.472)
SELECT `pd`.*
FROM `oc_product_recurring` `pp` JOIN `oc_recurring_description` `pd` ON `pd`.`language_id` = 1 AND `pd`.`recurring_id` = `pp`.`recurring_id` JOIN `oc_recurring` `p` ON `p`.`recurring_id` = `pd`.`recurring_id`
WHERE `product_id` = 25887 AND `status` = 1 AND `customer_group_id` = 1
ORDER BY `sort_order` ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:691
32 (10.297)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '25887'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:4
33 (6.856)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '25887' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
34 (0.650)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:4
35 (4.156)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:14
36 (1.215)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '25887' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
37 (11.887)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:4
38 (1.553)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:14
39 (7.585)
SELECT *
FROM oc_module
WHERE module_id = '37'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/module.php:4
40 (5.849)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25887'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
41 (9.158)
SELECT *
FROM oc_product_to_category p2c
JOIN oc_product p on p.product_id=p2c.product_id
WHERE p.product_id = '25887'
AND p.status = '1'
AND p.date_available <= NOW()
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:72
42 (9.282)
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 <> '25887'
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='310' AND pa.text='Никель/хром') OR (pa.attribute_id='420' AND pa.text='600 - 2000 грн@Оплата частями') )
AND p2c.category_id in (63)
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
group by product_id
order by count(*) DESC, p.price, p.product_id
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:124
43 (21.883)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25768'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
44 (1.371)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25768' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
45 (10.535)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25835'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
46 (0.833)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25835' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
47 (1.476)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25836'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
48 (0.916)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25836' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
49 (11.906)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25838'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
50 (1.432)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25838' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
51 (3.103)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25908'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
52 (1.348)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25908' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
53 (2.831)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25909'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
54 (1.565)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25909' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
55 (2.454)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25860'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
56 (11.273)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25860' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
57 (8.774)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25885'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
58 (6.409)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25885' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
59 (2.086)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25842'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
60 (14.233)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25842' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
61 (19.263)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25861'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
62 (125.072)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25861' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
63 (105.795)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25862'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
64 (905.514)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25862' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
65 (3.733)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25874'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
66 (2.098)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25874' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
67 (8.733)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25910'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
68 (18.970)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25910' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
69 (7.163)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25766'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
70 (5.726)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25766' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
71 (3.705)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25767'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
72 (15.041)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25767' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
73 (3.071)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25817'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
74 (5.379)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25817' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
75 (5.342)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25839'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
76 (3.275)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25839' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
77 (13.682)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25840'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
78 (23.722)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25840' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
79 (12.399)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25845'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
80 (1.004)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25845' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
81 (1.703)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25847'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
82 (17.909)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25847' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
83 (1.901)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25867'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
84 (6.026)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25867' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
85 (12.855)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25876'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
86 (0.883)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25876' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
87 (1.690)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25879'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
88 (4.790)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25879' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
89 (12.630)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25884'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
90 (11.744)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25884' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
91 (2.012)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25907'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
92 (0.866)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25907' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
93 (13.476)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25915'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
94 (1.028)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25915' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
95 (1.807)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25916'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
96 (7.196)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25916' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
97 (2.297)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25920'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
98 (5.760)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25920' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
99 (2.109)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25921'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
100 (21.856)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25921' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
101 (1.648)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25844'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
102 (12.823)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25844' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
103 (12.861)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25881'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
104 (1.583)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25881' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
105 (4.993)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25893'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
106 (3.744)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25893' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
107 (12.453)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25864'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
108 (2.412)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25864' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
109 (2.071)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25865'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
110 (14.369)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25865' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
111 (2.035)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25866'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
112 (11.961)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25866' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
113 (12.352)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25900'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
114 (3.586)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25900' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
115 (1.689)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25901'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
116 (1.609)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25901' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
117 (1.914)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25918'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
118 (3.891)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25918' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
119 (13.263)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25869'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
120 (10.320)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25869' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
121 (2.169)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25873'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
122 (5.259)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25873' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
123 (22.556)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25912'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
124 (15.266)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < 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 = '25912' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
125 (10.132)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25914'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
126 (26.181)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25914' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
127 (524.048)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25928'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
128 (8.888)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25928' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
129 (2.393)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25827'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
130 (4.071)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25827' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
131 (2.076)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25895'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
132 (7.113)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25895' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
133 (2.152)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25859'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
134 (15.859)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25859' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
135 (2.817)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25922'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
136 (2.013)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25922' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
137 (2.328)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25904'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
138 (4.031)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25904' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
139 (14.190)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25905'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
140 (3.301)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25905' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
141 (2.259)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25877'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
142 (14.638)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25877' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
143 (12.412)
SELECT *
FROM oc_product_attribute pa
JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25846'
AND p.status = '1'
AND pa.language_id = '1'
AND p.date_available <= NOW()
AND pa.attribute_id not in (342,368,439,415,380,370,367,341,379,418,362,425,366,423,441,437,430,381,406,419,411,382,349,311,417,401,416,400,432,359,364,344,426,424,365,402,434,358,340,378,350,352,351,377,376,414,413,431,398,371,372,440,355,375,353,412,421,408,409,429,373,407,410,360)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
144 (0.311)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25768'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
145 (1.124)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25835'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
146 (2.811)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25836'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
147 (11.098)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25838'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
148 (0.193)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25908'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
149 (0.199)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25909'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
150 (0.333)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25860'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
151 (0.185)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25885'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
152 (0.391)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25842'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
153 (0.198)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25861'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
154 (0.183)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25862'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
155 (0.187)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25874'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
156 (148.608)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25910'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
157 (8.619)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25766'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
158 (18.235)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25767'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
159 (27.261)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25817'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
160 (91.086)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25839'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
161 (6.585)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25840'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
162 (19.487)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25845'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
163 (23.628)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25847'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
164 (196.605)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25867'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
165 (14.316)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25876'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
166 (13.829)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25879'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
167 (2.190)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25884'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
168 (12.132)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25907'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
169 (1.455)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25915'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
170 (11.896)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25916'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
171 (1.647)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25920'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
172 (0.992)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25921'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
173 (14.726)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25844'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
174 (11.958)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25881'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
175 (12.600)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25893'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
176 (32.875)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25864'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
177 (1.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25865'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
178 (0.889)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25866'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
179 (0.680)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25900'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
180 (3.497)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25901'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
181 (11.028)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25918'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
182 (0.507)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25869'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
183 (0.959)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25873'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
184 (0.767)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25912'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
185 (11.625)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25914'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
186 (0.443)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25928'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
187 (1.017)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25827'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
188 (0.589)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25895'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
189 (3.135)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25859'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
190 (0.462)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25922'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
191 (0.490)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25904'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
192 (12.139)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25905'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
193 (1.116)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '25877'
ORDER BY main_category DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/controller/common/seo_pro.php:475
194 (10.732)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '25887' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
195 (0.500)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:4
196 (0.946)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:14
197 (2.646)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '25887' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
198 (0.741)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:4
199 (3.186)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:14
200 (0.652)
SELECT *
FROM oc_module
WHERE module_id = '36'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/module.php:4
201 (3.962)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25887' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
202 (15.016)
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/skladdve/data/www/sklad-dverey.com.ua/catalog/model/catalog/information.php:10
203 (23.295)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2025-04-27 22:21:16'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/tool/online.php:4
204 (13.052)
REPLACE INTO `oc_customer_online` SET `ip` = '18.97.14.84', `customer_id` = '0', `url` = 'http://sklad-dverey.com.ua/ruchki-i-furnitura/ruchka_rich-art_nota_386_r77_%28tonkaya_rozetka%29_mwsc_matovyj_hrom', `referer` = '', `date_added` = '2025-04-27 23:21:16'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/tool/online.php:6
205 (2.227)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '25887' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:15
206 (15.438)
SELECT *
FROM oc_product_ukrcredits
WHERE product_id = '25887'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/uc/uc56.php:5
207 (3.663)
SELECT *
FROM oc_xdstickers
ORDER BY xdsticker_id ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/xdstickers.php:42
208 (0.856)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/extension.php:4
209 (4.559)
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/skladdve/data/www/sklad-dverey.com.ua/catalog/model/catalog/category.php:10
210 (2.143)
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 = '62' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/catalog/category.php:10
211 (1.362)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/catalog/category.php:10
212 (7.702)
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 = '63' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/catalog/category.php:10
213 (17.178)
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 = '137' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/catalog/category.php:10
214 (1.527)
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 = '140' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/catalog/category.php:10
215 (1.385)
SELECT *
FROM oc_language
ORDER BY sort_order, name
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/ocd_multilang.php:6
216 (3.102)
SELECT DISTINCT *
FROM oc_megamenuvh
ORDER BY sort_menu ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nsmenu.php:4
217 (21.663)
SELECT *
FROM oc_language
ORDER BY sort_order, name
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/ocd_multilang.php:6
218 (3.335)
SELECT *
FROM oc_language
ORDER BY sort_order, name
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/ocd_multilang.php:6
219 (2.299)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '25887' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
220 (2.086)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:4
221 (1.744)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_filter'
ORDER BY sort_order
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:14
222 (2.253)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '554bh5ri8bvttt36e2jm9gmml2'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40
223 (5.570)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/extension.php:4
224 (16.935)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '554bh5ri8bvttt36e2jm9gmml2'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40
225 (3.808)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '554bh5ri8bvttt36e2jm9gmml2'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40
226 (3.778)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '554bh5ri8bvttt36e2jm9gmml2'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40