KORFAD VLD-01 дуб браш стекло черное

  • 4290 грн


  • АКЦИЯ

    при покупке двух дверей

    Бесплатная доставка
    Акция + Подарок

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

-
+

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



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

Акции Бесплатная доставка
Цена до 4000 грн, 4000 - 5500 грн, Оплата частями
Сроки 5-7 дней
Коллекция Valentino
Модель Valentino VLD-01
Назначение Ванная, Вторая входная, Дача, Детская, Кабинет, Комната, Коридор, Кухня, Офис, Санузел, Спальня
Гладкая / с фактурой Гладкая
Толщина полотна 40 мм
Обычные / раздвижные Обычные, Раздвижные
Одинарные / двойные Одинарные, Полуторные, Двойные
Конструкция Сборные
Цвет Натуральный
Декор Дуб браш
Материал покрытия CLPL Sincrolam (Италия)
Однотонная / с текстурой С текстурой дерева
Глухая / со стеклом / зеркалом Минимум стекла
Расположение стекла / зеркала Вертикальное и горизонтальное
Цвет стекла / зеркала Сатин черный
Рисунок на стекле Без рисунка
Торец Обычный торец
Ширина полотна (стандарт) 400 мм, 600 мм, 700 мм, 800 мм, 900 мм
Ширина полотна (нестандарт) 375 - 1000 мм
Высота полотна (стандарт) 2000 мм
Высота полотна (нестандарт) 1800 - 1990 мм, 2010 - 2200 мм
Материал полотна Брус / МДФ / МДФ
Тип коробки и наличников Телескопический
Материал коробки Дерево

Отзывы (0)

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

Теги: корфад, korfad, Valentino

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

Queries: 204, Total time: 332.728 ms [By time] [By id] [By file]
1 (0.305)
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.006)
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.259)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/skladdve/data/www/sklad-dverey.com.ua/index.php:148
4 (0.207)
SELECT *
FROM oc_currency
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/library/currency.php:13
5 (0.754)
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.376)
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.274)
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.287)
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.291)
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.197)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/library/openbay.php:117
11 (0.226)
SELECT *
FROM oc_event
/var/www/skladdve/data/www/sklad-dverey.com.ua/index.php:257
12 (0.386)
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.209)
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 (0.605)
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 = '59' 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
15 (1.551)
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 = '19893' 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
16 (0.309)
SELECT *
FROM oc_product_ukrcredits
WHERE product_id = '19893'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/uc/uc56.php:5
17 (0.982)
SELECT *
FROM oc_product_image
WHERE product_id = '19893'
ORDER BY sort_order ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:517
18 (0.510)
SELECT *
FROM oc_product_discount
WHERE product_id = '19893' 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
19 (2.876)
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 = '19893' 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
20 (5.371)
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 = '19893' AND pov.product_option_id = '307099' 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
21 (0.750)
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 = '19893' AND pov.product_option_id = '307096' 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 (0.663)
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 = '19893' AND pov.product_option_id = '307098' 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
23 (0.818)
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 = '19893' AND pov.product_option_id = '307097' 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
24 (0.767)
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 = '19893' AND pov.product_option_id = '307100' 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
25 (0.825)
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 = '19893' AND pov.product_option_id = '307101' 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
26 (1.545)
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` = 19893 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
27 (0.887)
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` = 19893 AND atp.`attribute_id` = 358 AND atl.`language_id` = 1 GROUP BY at.`text_id`
ORDER BY at.`sort_order`, atl.`text`
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:380
28 (1.023)
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` = 19893 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
29 (0.816)
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` = 19893 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
30 (0.802)
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` = 19893 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
31 (0.773)
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` = 19893 AND atp.`attribute_id` = 378 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
32 (0.794)
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` = 19893 AND atp.`attribute_id` = 350 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
33 (0.857)
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` = 19893 AND atp.`attribute_id` = 365 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
34 (0.731)
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` = 19893 AND atp.`attribute_id` = 355 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
35 (1.014)
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` = 19893 AND atp.`attribute_id` = 341 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
36 (1.167)
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` = 19893 AND atp.`attribute_id` = 342 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
37 (0.769)
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` = 19893 AND atp.`attribute_id` = 343 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
38 (0.833)
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` = 19893 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
39 (0.766)
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` = 19893 AND atp.`attribute_id` = 311 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
40 (0.943)
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` = 19893 AND atp.`attribute_id` = 359 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
41 (0.778)
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` = 19893 AND atp.`attribute_id` = 363 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
42 (0.754)
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` = 19893 AND atp.`attribute_id` = 346 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
43 (0.727)
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` = 19893 AND atp.`attribute_id` = 347 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
44 (0.789)
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` = 19893 AND atp.`attribute_id` = 348 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
45 (0.830)
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` = 19893 AND atp.`attribute_id` = 381 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
46 (0.793)
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` = 19893 AND atp.`attribute_id` = 382 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
47 (1.185)
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` = 19893 AND atp.`attribute_id` = 353 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
48 (0.741)
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` = 19893 AND atp.`attribute_id` = 412 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
49 (0.794)
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` = 19893 AND atp.`attribute_id` = 414 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
50 (0.982)
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` = 19893 AND atp.`attribute_id` = 413 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
51 (0.792)
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` = 19893 AND atp.`attribute_id` = 366 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
52 (0.954)
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` = 19893 AND atp.`attribute_id` = 367 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
53 (0.893)
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` = 19893 AND atp.`attribute_id` = 368 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
54 (3.774)
SELECT `xdsticker_id`
FROM oc_xdstickers_product
WHERE product_id = '19893'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/xdstickers.php:9
55 (0.392)
SELECT *
FROM oc_xdstickers
WHERE xdsticker_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/xdstickers.php:4
56 (0.197)
SELECT *
FROM oc_xdstickers
WHERE xdsticker_id = '9'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/xdstickers.php:4
57 (0.382)
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 = '19893' 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
58 (0.346)
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` = 19893 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
59 (0.316)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '19893'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:4
60 (0.372)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '19893' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
61 (0.303)
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
62 (0.232)
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
63 (0.165)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '19893' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
64 (0.209)
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
65 (0.212)
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
66 (0.214)
SELECT *
FROM oc_module
WHERE module_id = '37'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/module.php:4
67 (3.756)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19893' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
68 (0.424)
SELECT *
FROM oc_product_to_category p2c JOIN oc_product p on p.product_id=p2c.product_id
WHERE p.product_id = '19893' 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
69 (0.259)
SELECT *
FROM oc_product p
WHERE p.product_id = '19893' 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
70 (119.389)
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 <> '19893' 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='340' AND pa.text='Valentino') OR (pa.attribute_id='341' AND pa.text='Обычные@Раздвижные') OR (pa.attribute_id='342' AND pa.text='Двойные@Одинарные@Полуторные') OR (pa.attribute_id='346' AND pa.text='Минимум стекла') OR (pa.attribute_id='378' AND pa.text='Valentino VLD-01') ) AND p2c.category_id in (59) AND p.manufacturer_id = 15 AND pa.attribute_id not in (358,377,425,379,376,413,414,365,311,417,401,416,400,421,408,429,409,374,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,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
71 (2.458)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19816' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
72 (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 = '19816' 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.807)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19817' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
74 (1.108)
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 = '19817' 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.945)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19818' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
76 (0.815)
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 = '19818' 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.729)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19819' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
78 (0.903)
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 = '19819' 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.725)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19820' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
80 (0.810)
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 = '19820' 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.805)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19821' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
82 (0.867)
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 = '19821' 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.785)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19822' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
84 (0.784)
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 = '19822' 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.631)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19823' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
86 (0.803)
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 = '19823' 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.679)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19824' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
88 (0.776)
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 = '19824' 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.628)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19825' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
90 (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 = '19825' 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.600)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19826' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
92 (0.901)
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 = '19826' 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.626)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19827' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
94 (0.805)
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 = '19827' 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 (2.036)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19828' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
96 (0.880)
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 = '19828' 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.985)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19829' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
98 (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 = '19829' 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.910)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19830' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
100 (1.222)
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 = '19830' 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 (2.443)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19877' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
102 (1.020)
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 = '19877' 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 (2.241)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19878' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
104 (0.978)
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 = '19878' 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 (2.050)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19879' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
106 (0.993)
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 = '19879' 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.926)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19880' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
108 (0.974)
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 = '19880' 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.880)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19881' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
110 (0.937)
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 = '19881' 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.906)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19882' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
112 (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 = '19882' 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 (2.143)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19883' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
114 (0.965)
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 = '19883' 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 (2.404)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19884' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
116 (1.197)
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 = '19884' 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 (2.353)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19885' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
118 (1.034)
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 = '19885' 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 (2.077)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19886' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
120 (1.015)
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 = '19886' 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.895)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19887' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
122 (0.953)
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 = '19887' 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.947)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19888' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
124 (0.777)
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 = '19888' 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.670)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19889' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
126 (0.860)
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 = '19889' 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 (1.624)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19890' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
128 (0.795)
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 = '19890' 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.603)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19891' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
130 (0.841)
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 = '19891' 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.614)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19892' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
132 (0.784)
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 = '19892' 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.620)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19894' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
134 (0.785)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '19894' 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.616)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19895' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
136 (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 = '19895' 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.719)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19896' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
138 (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 = '19896' 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.628)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19897' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
140 (0.812)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '19897' 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.645)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19898' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
142 (0.785)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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 = '19898' 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.677)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19899' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
144 (0.784)
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 = '19899' 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
145 (2.008)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19900' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
146 (1.425)
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 = '19900' 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
147 (2.132)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19901' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
148 (1.141)
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 = '19901' 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
149 (1.947)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19902' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
150 (0.973)
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 = '19902' 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
151 (2.061)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19903' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
152 (1.060)
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 = '19903' 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
153 (1.980)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19904' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
154 (1.021)
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 = '19904' 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
155 (1.838)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19905' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
156 (0.819)
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 = '19905' 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
157 (1.694)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '19906' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
158 (0.800)
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 = '19906' 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
159 (1.800)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '22723' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
160 (0.929)
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 = '22723' 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
161 (1.687)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '22724' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
162 (0.810)
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 = '22724' 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
163 (1.674)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '22726' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
164 (0.792)
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 = '22726' 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
165 (1.685)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '22727' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
166 (0.838)
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 = '22727' 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
167 (1.819)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '22728' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
168 (0.842)
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 = '22728' 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
169 (1.718)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '22737' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
170 (0.805)
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 = '22737' 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
171 (1.716)
SELECT *
FROM oc_product_attribute pa JOIN oc_product p on p.product_id=pa.product_id
WHERE p.product_id = '22738' 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,343,372,362,368,359,366,364,415,350,404,430,406,427,431,399,363,380,373,344,426,424,398,347,381,360,423,352,403,351,419,370,411,367,407,371,355,382,349,418,432,410,310,402,433,348,428,420,375,412,353)
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/nkf_similar_products.php:23
172 (0.544)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '19893' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
173 (0.334)
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
174 (0.222)
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
175 (0.165)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '19893' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
176 (0.190)
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
177 (0.220)
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
178 (0.204)
SELECT *
FROM oc_module
WHERE module_id = '36'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/module.php:4
179 (1.049)
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 = '19893' 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
180 (1.283)
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
181 (1.384)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2024-04-24 04:57:46'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/tool/online.php:4
182 (0.209)
REPLACE INTO `oc_customer_online` SET `ip` = '44.210.99.209', `customer_id` = '0', `url` = 'http://sklad-dverey.com.ua/mejkomnatnye-dveri/vld-01-dub-brash-steklo-chernoe', `referer` = '', `date_added` = '2024-04-24 05:57:46'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/tool/online.php:6
183 (1.114)
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 = '19893' 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
184 (0.179)
SELECT *
FROM oc_product_ukrcredits
WHERE product_id = '19893'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/uc/uc56.php:5
185 (0.367)
SELECT *
FROM oc_xdstickers
ORDER BY xdsticker_id ASC
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/module/xdstickers.php:42
186 (0.179)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/extension.php:4
187 (0.840)
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
188 (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 = '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
189 (0.532)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '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
190 (0.452)
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
191 (0.441)
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
192 (0.440)
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
193 (0.202)
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
194 (0.694)
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
195 (0.225)
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
196 (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
197 (0.198)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '19893' AND store_id = '0'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/catalog/model/catalog/product.php:535
198 (0.207)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/design/layout.php:4
199 (0.181)
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
200 (0.322)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'f9tr2sfposr5iqje0v5s4hr5g2'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40
201 (0.183)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/skladdve/data/www/sklad-dverey.com.ua/catalog/model/extension/extension.php:4
202 (0.224)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'f9tr2sfposr5iqje0v5s4hr5g2'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40
203 (0.200)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'f9tr2sfposr5iqje0v5s4hr5g2'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40
204 (0.249)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = 'f9tr2sfposr5iqje0v5s4hr5g2'
/var/www/skladdve/data/www/sklad-dverey.com.ua/system/storage/modification/system/library/cart.php:40