Круглосуточно

Бандана "Вилея"

  • Производитель: Lemmex
  • Артикул: 15415
  • Модель: Бандана "Вилея"
  • Наличие: Есть в наличии

1 250.00 р.

Доступные опции

Летняя бандана "Вилея" идеальна для повседневного использования, такую модель можно надеть под любую одежду, от модного сарафана и до пляжной туники, Ваш образ станет более элегантным и запоминающимся.

Модель выполнена из качественного шифона, ножка модели изготовлена из натурального льна, обеспечивающего комфорт даже самым жарким днем.

Бандана довольно объемная и обладает хорошей воздухопроницаемостью, что понравится женщинам с укладкой волос, принт в виде летних цветков сделает Ваш образ более стильным.

Модель обладает большим хвостом из шифона, подчеркивающим Вашу природную красоту и модный образ.

Артикул
Артикул 15415
Цвет
Цвет Серый
Материал
Материал Шифон

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

Внимание: HTML не поддерживается! Используйте обычный текст!
    Плохо           Хорошо

Теги: Бандана "Вилея", Lemmex, Летняя коллекция

Рекомендуемые товары

Вы смотрели

Queries: 146, Total time: 271.066 ms [By time] [By id] [By file]
1 (0.171)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://lemmex.ru/'
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/startup.php:6
2 (2.974)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/startup.php:25
3 (1.027)
SELECT f1.postalcode f1_postalcode, f1.offname f1_name, f1.level f1_level, f1.fias_id f1_fias_id, f1.shortname f1_shortname, CONCAT(f2.offname, ' ', f2.shortname) f2_name, f2.level f2_level, f2.fias_id f2_fias_id, CONCAT(f3.offname, ' ', f3.shortname) f3_name, f3.level f3_level, f3.fias_id f3_fias_id, CONCAT(f4.offname, ' ', f4.shortname) f4_name, f4.level f4_level, f4.fias_id f4_fias_id
FROM fias f1
LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id
LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id
LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id
WHERE f1.offname = 'Сиэтл' AND (f3.offname = 'США' OR f2.offname = 'США' OR f4.offname = 'США') AND (f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.'))
/home/admin/web/lemmex.ru/public_html/catalog/model/progroman/fias.php:85
4 (0.103)
SELECT *
FROM oc_country c
WHERE c.iso_code_2 = 'US'
/home/admin/web/lemmex.ru/public_html/catalog/model/progroman/fias.php:136
5 (0.123)
SELECT *
FROM oc_currency
/home/admin/web/lemmex.ru/public_html/system/library/cart/currency.php:10
6 (0.472)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '07hs0p6m050ibhok7fmd7664e0'
/home/admin/web/lemmex.ru/public_html/catalog/controller/jetcache/jetcache.php:87
7 (0.122)
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 = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/admin/web/lemmex.ru/public_html/system/library/cart/tax.php:17
8 (0.090)
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 = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/admin/web/lemmex.ru/public_html/system/library/cart/tax.php:31
9 (0.112)
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 = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761')
ORDER BY tr1.priority ASC
/home/admin/web/lemmex.ru/public_html/system/library/cart/tax.php:45
10 (0.095)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/home/admin/web/lemmex.ru/public_html/system/library/cart/weight.php:10
11 (0.096)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/home/admin/web/lemmex.ru/public_html/system/library/cart/length.php:10
12 (0.228)
DELETE
FROM oc_cart
WHERE date_added < DATE_SUB(NOW(), INTERVAL '20' DAY)
/home/admin/web/lemmex.ru/public_html/system/storage/modification/system/library/cart/cart.php:98
13 (0.147)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `event_id` ASC
/home/admin/web/lemmex.ru/public_html/catalog/model/extension/event.php:4
14 (0.139)
SELECT *
FROM `oc_mfilter_url_alias`
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:17
15 (0.319)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2401'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
16 (0.584)
SELECT *
FROM oc_language
WHERE status = '1'
/home/admin/web/lemmex.ru/public_html/catalog/controller/common/seoblog.php:104
17 (0.205)
SELECT *
FROM oc_layout l
LEFT JOIN oc_layout_route lr ON (l.layout_id = lr.layout_id)
ORDER BY name ASC
/home/admin/web/lemmex.ru/public_html/catalog/model/design/bloglayout.php:42
18 (0.817)
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 = '150' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' LIMIT 1
/home/admin/web/lemmex.ru/public_html/catalog/model/catalog/category.php:6
19 (3.662)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2401' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
20 (0.187)
SELECT DISTINCT *, md.name AS name
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id)
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE md.language_id = '1' && m.manufacturer_id = '11' AND m2s.store_id = '0'
/home/admin/web/lemmex.ru/public_html/catalog/model/catalog/manufacturer.php:4
21 (0.538)
SELECT *
FROM oc_product_image
WHERE product_id = '2401'
ORDER BY sort_order ASC
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:638
22 (0.150)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
23 (0.190)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2401' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
24 (0.150)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
25 (0.468)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 2401
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:246
26 (0.130)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
27 (0.096)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
28 (0.428)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 5481 AND PS.option_id = PMOS.option_id
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:202
29 (1.066)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 5481
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:221
30 (0.111)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
31 (0.097)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 2401
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:246
32 (0.094)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
33 (0.091)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
34 (0.104)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 5481 AND PS.option_id = PMOS.option_id
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:202
35 (0.125)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 5481
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:221
36 (1.169)
SELECT POV.*, OV.image, OD.name option_name, OVD.name value_name
FROM oc_product_option_value POV
LEFT JOIN oc_option_description OD ON (POV.option_id = OD.option_id AND OD.language_id = 1) , oc_option_value OV
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 1)
WHERE POV.option_value_id = OV.option_value_id AND POV.product_id = 2401
ORDER BY OV.sort_order ASC
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:277
37 (0.744)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, POV.option_id, POV.option_value_id
FROM oc_poip_option_image POIP ,oc_product_option_value POV ,oc_option_value OV
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 1) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 1) ,oc_product_option PO
WHERE POIP.product_id = 2401 AND POIP.product_option_value_id = POV.product_option_value_id AND POV.option_value_id = OV.option_value_id AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND (NOT POV.subtract OR POV.quantity > 0)
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:311
38 (0.127)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 2401
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:246
39 (0.093)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
40 (0.103)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
41 (0.143)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 5481 AND PS.option_id = PMOS.option_id
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:202
42 (0.121)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 5481
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:221
43 (0.128)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
44 (0.132)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
45 (0.105)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 2401
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:246
46 (0.111)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
47 (0.109)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
48 (0.127)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 5481 AND PS.option_id = PMOS.option_id
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:202
49 (0.127)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 5481
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:221
50 (0.196)
SELECT POV.*, OV.image, OD.name option_name, OVD.name value_name
FROM oc_product_option_value POV
LEFT JOIN oc_option_description OD ON (POV.option_id = OD.option_id AND OD.language_id = 1) , oc_option_value OV
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 1)
WHERE POV.option_value_id = OV.option_value_id AND POV.product_id = 2401
ORDER BY OV.sort_order ASC
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:277
51 (0.153)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, POV.option_id, POV.option_value_id
FROM oc_poip_option_image POIP ,oc_product_option_value POV ,oc_option_value OV
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 1) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 1) ,oc_product_option PO
WHERE POIP.product_id = 2401 AND POIP.product_option_value_id = POV.product_option_value_id AND POV.option_value_id = OV.option_value_id AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND (NOT POV.subtract OR POV.quantity > 0)
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:311
52 (0.501)
SELECT *
FROM oc_product_discount
WHERE product_id = '2401' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < '2018-11-19') AND (date_end = '0000-00-00' OR date_end > '2018-11-19'))
ORDER BY quantity ASC, priority ASC, price ASC
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:632
53 (0.114)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
54 (0.096)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
55 (0.118)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 2401
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:246
56 (0.121)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
57 (0.093)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
58 (0.120)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 5481 AND PS.option_id = PMOS.option_id
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:202
59 (0.122)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 5481
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:221
60 (0.190)
SELECT POV.*, OV.image, OD.name option_name, OVD.name value_name
FROM oc_product_option_value POV
LEFT JOIN oc_option_description OD ON (POV.option_id = OD.option_id AND OD.language_id = 1) , oc_option_value OV
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 1)
WHERE POV.option_value_id = OV.option_value_id AND POV.product_id = 2401
ORDER BY OV.sort_order ASC
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:277
61 (0.495)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, POV.option_id, POV.option_value_id
FROM oc_poip_option_image POIP ,oc_product_option_value POV ,oc_option_value OV
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 1) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 1) ,oc_product_option PO
WHERE POIP.product_id = 2401 AND POIP.product_option_value_id = POV.product_option_value_id AND POV.option_value_id = OV.option_value_id AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:311
62 (0.095)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 2401
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:246
63 (0.102)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
64 (0.099)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:66
65 (0.138)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 5481 AND PS.option_id = PMOS.option_id
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:202
66 (0.124)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 5481
/home/admin/web/lemmex.ru/public_html/catalog/model/module/product_option_image_pro.php:221
67 (0.821)
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 = '2401' AND od.language_id = '1'
ORDER BY o.sort_order
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:560
68 (0.769)
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 = '2401' AND pov.product_option_id = '5481' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:565
69 (0.982)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (agd.attribute_group_id = ag.attribute_group_id)
WHERE pa.product_id = '2401' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:518
70 (0.803)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '2401' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:523
71 (0.659)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '2401' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:523
72 (0.688)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '2401' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:523
73 (2.025)
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 = '2401' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0'
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:657
74 (2.238)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2308' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
75 (1.398)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2318' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
76 (7.452)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2334' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
77 (1.955)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2349' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
78 (7.439)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2385' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
79 (1.932)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2397' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
80 (1.587)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2407' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
81 (2.319)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2409' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
82 (17.824)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2413' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
83 (9.542)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2418' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
84 (2.300)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2422' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
85 (1.667)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2424' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
86 (2.480)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2426' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
87 (7.737)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2430' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
88 (2.036)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2432' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
89 (1.700)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2440' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
90 (7.744)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2448' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
91 (1.998)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2453' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
92 (1.827)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2460' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
93 (4.445)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2463' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
94 (1.831)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2467' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
95 (2.482)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2500' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
96 (10.115)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2513' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
97 (3.799)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2536' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
98 (3.000)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2548' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
99 (4.648)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2551' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
100 (4.395)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '2561' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
101 (3.319)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '3077' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
102 (6.042)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '3090' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
103 (1.608)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '3091' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
104 (5.663)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '3102' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
105 (1.791)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '3119' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
106 (5.024)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '3141' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
107 (3.217)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1' LIMIT 1 ) AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2018-11-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-11-19'))
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 < '2018-11-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-11-19'))
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' LIMIT 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' LIMIT 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' LIMIT 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' LIMIT 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 = '3157' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2018-11-19' AND p2s.store_id = '0' LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:162
108 (0.386)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2308'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
109 (0.239)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2318'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
110 (6.220)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2334'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
111 (0.287)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2349'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
112 (3.065)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2385'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
113 (5.989)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2397'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
114 (0.255)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2407'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
115 (11.855)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2409'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
116 (1.030)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2413'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
117 (9.423)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2424'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
118 (2.385)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2426'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
119 (2.831)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2430'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
120 (2.470)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2440'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
121 (3.072)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2448'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
122 (2.367)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2453'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
123 (2.078)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2463'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
124 (2.783)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2467'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
125 (0.306)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2500'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
126 (7.267)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2513'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
127 (0.383)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2536'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
128 (0.297)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2548'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
129 (4.886)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2551'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
130 (0.262)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2561'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
131 (0.285)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '3077'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
132 (0.267)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '3090'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
133 (2.875)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '3119'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
134 (4.991)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '3157'
ORDER BY main_category DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/controller/startup/seo_pro.php:347
135 (2.536)
SELECT rd.*
FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 2401 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:804
136 (3.468)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '2401'
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:18
137 (2.001)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2401' AND store_id = '0'
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:667
138 (0.440)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/catalog/model/design/layout.php:4
139 (0.265)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/admin/web/lemmex.ru/public_html/catalog/model/agoo/design/layout.php:179
140 (6.205)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/home/admin/web/lemmex.ru/public_html/catalog/model/design/layout.php:14
141 (0.130)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '2401' AND store_id = '0'
/home/admin/web/lemmex.ru/public_html/system/storage/modification/catalog/model/catalog/product.php:667
142 (0.104)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/admin/web/lemmex.ru/public_html/catalog/model/design/layout.php:4
143 (0.093)
SELECT *
FROM oc_layout_route
WHERE layout_id='2' AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/admin/web/lemmex.ru/public_html/catalog/model/agoo/design/layout.php:179
144 (0.358)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/home/admin/web/lemmex.ru/public_html/catalog/model/design/layout.php:14
145 (3.581)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2018-11-19 08:12:12'
/home/admin/web/lemmex.ru/public_html/catalog/model/tool/online.php:4
146 (0.302)
REPLACE INTO `oc_customer_online` SET `ip` = '54.92.193.89', `customer_id` = '0', `url` = 'https://lemmex.ru/letnyaya-kollekciya/bandana-vileya.html', `referer` = '', `date_added` = '2018-11-19 09:12:12'
/home/admin/web/lemmex.ru/public_html/catalog/model/tool/online.php:6