Ручка Rich-Art Мерида 437 R77 (тонкая розетка) MSN/CP матовый никель/хром

  • Производитель: Rich-Art
  • Артикул: 25877
  • 1400 грн


  • АКЦИЯ
    На складе

    акция закончится через

-
+

Цена за комплект: 1400 грн



Характеристики

Цена 600 - 2000 грн, Оплата частями
Сроки На складе
Коллекция Премиум
Цвет Никель/хром

Отзывы (0)

Написать отзыв

Недавно просмотренные

Queries: 176, Total time: 194.511 ms [By time] [By id] [By file]
1 (0.279)
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 (3.080)
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.196)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/skladdve/data/www/sklad-dverey.com.ua/index.php:148
4 (0.211)
SELECT *
FROM oc_currency
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/library/currency.php:13
5 (4.827)
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 (0.402)
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 (0.283)
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 (0.299)
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.295)
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.202)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/library/openbay.php:117
11 (0.195)
SELECT *
FROM oc_event
/var/www/skladdve/data/www/sklad-dverey.com.ua/index.php:257
12 (0.299)
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.189)
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 (1.814)
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:433
15 (3.214)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '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 (10.115)
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
17 (0.327)
SELECT *
FROM oc_product_ukrcredits
WHERE product_id = '25877'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/uc/uc56.php:5
18 (0.422)
SELECT *
FROM oc_product_image
WHERE product_id = '25877'
ORDER BY sort_order ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:517
19 (0.341)
SELECT *
FROM oc_product_discount
WHERE product_id = '25877' 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 (0.717)
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 = '25877' 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 (0.998)
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 = '25877' AND pov.product_option_id = '291614' 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 (1.058)
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` = 25877 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 (0.740)
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` = 25877 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 (1.588)
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` = 25877 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
25 (1.573)
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` = 25877 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
26 (1.935)
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` = 25877 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
27 (3.597)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '25877'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/xdstickers.php:9
28 (0.190)
SELECT *
FROM oc_xdstickers
WHERE xdsticker_id = '4'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/xdstickers.php:4
29 (0.274)
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 = '25877' 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
30 (0.249)
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` = 25877 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
31 (1.366)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '25877'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:4
32 (0.186)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '25877' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
33 (0.240)
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
34 (0.227)
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
35 (0.162)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '25877' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
36 (0.310)
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
37 (0.201)
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
38 (0.184)
SELECT *
FROM oc_module
WHERE module_id = '37'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/module.php:4
39 (2.977)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
40 (0.317)
SELECT *
FROM oc_product_to_category p2c JOIN oc_product p on p.product_id=p2c.product_id
WHERE p.product_id = '25877' 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
41 (0.258)
SELECT *
FROM oc_product p
WHERE p.product_id = '25877' 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:86
42 (3.162)
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 <> '25877' 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='Никель/хром') ) AND p2c.category_id in (63) AND p.manufacturer_id = 30 AND pa.attribute_id not in (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353) 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 (1.737)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25934' AND p.status = '1' AND pa.language_id = '1' AND p.date_available <= NOW() AND pa.attribute_id not in (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
44 (1.362)
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 = '25934' 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 (1.635)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '25935' AND p.status = '1' AND pa.language_id = '1' AND p.date_available <= NOW() AND pa.attribute_id not in (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
46 (0.821)
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 = '25935' 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.577)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
48 (1.236)
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
49 (1.583)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
50 (1.083)
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
51 (2.153)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
52 (0.858)
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
53 (1.717)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
54 (0.854)
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
55 (1.787)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
56 (0.900)
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
57 (1.599)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
58 (0.837)
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
59 (1.673)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
60 (0.872)
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
61 (1.567)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
62 (1.109)
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
63 (1.645)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
64 (0.863)
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
65 (1.617)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
66 (0.849)
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
67 (1.560)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
68 (0.954)
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
69 (1.576)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
70 (1.023)
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
71 (1.835)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
72 (0.801)
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
73 (1.500)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
74 (0.847)
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
75 (1.687)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
76 (0.977)
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
77 (1.696)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
78 (1.006)
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
79 (1.563)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
80 (0.786)
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
81 (1.632)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
82 (0.873)
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
83 (1.703)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
84 (0.873)
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
85 (1.623)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
86 (1.539)
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
87 (1.653)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
88 (0.904)
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
89 (1.932)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
90 (1.330)
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
91 (1.829)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
92 (0.811)
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
93 (1.554)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
94 (1.284)
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
95 (1.782)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
96 (0.964)
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
97 (1.621)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
98 (0.791)
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
99 (1.599)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
100 (0.881)
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
101 (1.595)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
102 (0.956)
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
103 (1.628)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
104 (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 = '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
105 (1.657)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
106 (0.834)
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
107 (1.773)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
108 (1.038)
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
109 (1.488)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
110 (0.907)
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
111 (1.576)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
112 (0.807)
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
113 (1.558)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
114 (0.829)
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
115 (1.590)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
116 (0.832)
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
117 (1.612)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
118 (0.865)
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
119 (1.468)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
120 (0.779)
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
121 (1.638)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
122 (0.861)
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
123 (1.600)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
124 (0.808)
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
125 (1.592)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
126 (0.946)
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
127 (2.340)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
128 (1.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 = '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
129 (1.685)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
130 (0.804)
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
131 (1.856)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
132 (0.950)
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
133 (1.871)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
134 (0.919)
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
135 (1.794)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
136 (0.851)
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
137 (1.559)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
138 (0.824)
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
139 (1.602)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
140 (0.877)
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
141 (1.608)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
142 (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 = '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
143 (1.680)
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 (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,340,372,362,368,359,366,364,378,415,350,404,430,406,427,431,341,342,399,380,373,344,426,424,398,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,402,433,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
144 (0.309)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '25877' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
145 (0.266)
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
146 (0.184)
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
147 (0.181)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '25877' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
148 (0.206)
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
149 (0.178)
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
150 (0.148)
SELECT *
FROM oc_module
WHERE module_id = '36'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/module.php:4
151 (0.926)
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
152 (1.187)
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
153 (1.017)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2024-05-21 21:25:26'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/tool/online.php:4
154 (0.254)
REPLACE INTO `oc_customer_online` SET `ip` = '44.221.70.232', `customer_id` = '0', `url` = 'http://sklad-dverey.com.ua/ruchki-i-furnitura/ruchka_rich-art_merida_437_r77_%28tonkaya_rozetka%29_msn-cp_matovyj_nikel-hrom', `referer` = '', `date_added` = '2024-05-21 22:25:26'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/tool/online.php:6
155 (1.051)
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
156 (0.171)
SELECT *
FROM oc_product_ukrcredits
WHERE product_id = '25877'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/uc/uc56.php:5
157 (0.317)
SELECT *
FROM oc_xdstickers
ORDER BY xdsticker_id ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/xdstickers.php:42
158 (0.185)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/extension.php:4
159 (0.812)
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
160 (0.488)
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
161 (0.504)
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
162 (0.531)
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
163 (0.599)
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
164 (0.502)
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
165 (0.186)
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
166 (0.480)
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
167 (0.181)
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
168 (0.198)
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
169 (0.152)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '25877' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
170 (0.216)
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
171 (0.254)
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
172 (0.210)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'dmpmjavtpees0aevucqaoevv53'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40
173 (0.187)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/extension.php:4
174 (0.238)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'dmpmjavtpees0aevucqaoevv53'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40
175 (0.253)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'dmpmjavtpees0aevucqaoevv53'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40
176 (0.284)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'dmpmjavtpees0aevucqaoevv53'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40