| 1 | 0.621 ms | WITH ids(product_id) AS (VALUES (3792),(3794),(3795),(3793),(3798),(3799),(3797)), discounts AS ( SELECT t.product_id, t.price AS discount FROM ( SELECT pd2.product_id, pd2.price, ROW_NUMBER() OVER (PARTITION BY pd2.product_id ORDER BY pd2.priority ASC, pd2.price ASC) AS rn FROM oc_product_discount pd2 JOIN ids ON ids.product_id = pd2.product_id WHERE pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = 0 OR pd2.date_start <= 1780702509) AND (pd2.date_end = 0 OR pd2.date_end >= 1780702509)) ) t WHERE t.rn = 1 ), specials AS ( SELECT t.product_id, t.price AS special FROM ( SELECT ps.product_id, ps.price, ROW_NUMBER() OVER (PARTITION BY ps.product_id ORDER BY ps.priority ASC, ps.price ASC) AS rn FROM oc_product_special ps JOIN ids ON ids.product_id = ps.product_id WHERE ps.customer_group_id = '1' AND ((ps.date_start = 0 OR ps.date_start <= 1780702509) AND (ps.date_end = 0 OR ps.date_end >= 1780702509)) ) t WHERE t.rn = 1 ), rewards AS ( SELECT pr.product_id, pr.points AS reward FROM oc_product_reward pr JOIN ids ON ids.product_id = pr.product_id WHERE pr.customer_group_id = '1' ) SELECT p.product_id, pd.name AS name, pd.h1 AS h1, p.product_code AS product_code, pd.description AS description, pd.short_description AS short_description, pd.meta_title AS meta_title, pd.meta_description AS meta_description, pd.meta_keyword AS meta_keyword, p.quantity, ss.name AS stock_status, p.image, p.manufacturer_id, p.main_category_id, m.name AS manufacturer, p.price, d.discount AS discount, s.special AS special, rw.reward AS reward, p.points, p.tax_class_id, p.date_available, p.weight, p.weight_class_id, p.length, p.width, p.height, p.length_class_id, p.subtract, p.minimum, p.sort_order, p.status, p.date_added, p.date_modified, p.is_product_group, p.product_group_title, p.product_group_list_type FROM oc_product p JOIN ids ON ids.product_id = p.product_id JOIN oc_product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '3') LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN oc_stock_status ss ON (ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') LEFT JOIN discounts d ON (d.product_id = p.product_id) LEFT JOIN specials s ON (s.product_id = p.product_id) LEFT JOIN rewards rw ON (rw.product_id = p.product_id) WHERE p.status = '1' AND p.date_available <= 1780702509 ORDER BY CASE p.product_id WHEN 3792 THEN 0 WHEN 3794 THEN 1 WHEN 3795 THEN 2 WHEN 3793 THEN 3 WHEN 3798 THEN 4 WHEN 3799 THEN 5 WHEN 3797 THEN 6 ELSE 7 END |
| 1 | 0.617 ms | WITH base_products AS (SELECT p.product_id, pd.name AS pd_name, p.price AS base_price, p.quantity, p.sort_order, p.date_added FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= 1780702509 AND p.manufacturer_id = '19' GROUP BY p.product_id), discounts AS ( SELECT product_id, price AS discount FROM ( SELECT pd2.product_id, pd2.price, ROW_NUMBER() OVER (PARTITION BY pd2.product_id ORDER BY pd2.priority ASC, pd2.price ASC) AS rn FROM oc_product_discount pd2 JOIN base_products bp2 ON (bp2.product_id = pd2.product_id) WHERE pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = 0 OR pd2.date_start <= 1780702509) AND (pd2.date_end = 0 OR pd2.date_end >= 1780702509)) ) t WHERE t.rn = 1 ), specials AS ( SELECT product_id, price AS special FROM ( SELECT ps.product_id, ps.price, ROW_NUMBER() OVER (PARTITION BY ps.product_id ORDER BY ps.priority ASC, ps.price ASC) AS rn FROM oc_product_special ps JOIN base_products bp2 ON (bp2.product_id = ps.product_id) WHERE ps.customer_group_id = '1' AND ((ps.date_start = 0 OR ps.date_start <= 1780702509) AND (ps.date_end = 0 OR ps.date_end >= 1780702509)) ) t WHERE t.rn = 1 ) SELECT bp.product_id, d.discount AS discount, s.special AS special FROM base_products bp LEFT JOIN discounts d ON (d.product_id = bp.product_id) LEFT JOIN specials s ON (s.product_id = bp.product_id) ORDER BY (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE bp.base_price END) ASC, LOWER(bp.pd_name) ASC LIMIT 0,9 |
| 1 | 0.476 ms | SELECT `key`, `value`, serialized FROM `oc_setting` WHERE `key` NOT IN ('config_image_resize_mode','config_image_resize_filter','config_image_resize_blur','config_image_auto_orient','config_image_preserve_alpha','config_image_background_color','config_image_strip_metadata','config_image_jpeg_quality_small','config_image_jpeg_quality_medium','config_image_jpeg_quality_large','config_image_jpeg_small_max','config_image_jpeg_medium_max','config_image_jpeg_progressive','config_image_jpeg_sampling','config_image_png_compression','config_image_png_filter','config_image_png_strategy','config_image_webp_quality','config_image_avif_quality') |
| 1 | 0.261 ms | SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= 1780702509 AND p.manufacturer_id = '19' |
| 1 | 0.115 ms | SELECT DISTINCT m.*, md.name AS name, md.h1 AS h1, md.short_description AS short_description, md.description AS description, md.meta_title AS meta_title, md.meta_description AS meta_description, md.meta_keyword AS meta_keyword FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) WHERE m.manufacturer_id = '19' AND md.language_id = '3' |
| 1 | 0.104 ms | SELECT sp.seo_page_id, sp.route, sp.status, spd.name, spd.meta_title, spd.h1, spd.meta_description, spd.meta_keyword, spd.short_description, spd.description FROM oc_seo_page sp LEFT JOIN oc_seo_page_description spd ON (sp.seo_page_id = spd.seo_page_id) WHERE sp.route IN ('product/manufacturer/info&manufacturer_id=19') AND sp.status = '1' AND spd.language_id = '3' ORDER BY CASE sp.route WHEN 'product/manufacturer/info&manufacturer_id=19' THEN 0 ELSE 9999 END LIMIT 1 |
| 1 | 0.093 ms | SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '4' ORDER BY position, sort_order |
| 1 | 0.089 ms | SELECT language_id, name, code, locale, image, directory, sort_order, status, default_currency_code, url_prefix, hreflang FROM oc_language WHERE status = '1' ORDER BY sort_order, name |
| 1 | 0.083 ms | SELECT mra.article_id FROM oc_manufacturer_related_article mra INNER JOIN oc_blog_article a ON (mra.article_id = a.article_id) WHERE mra.manufacturer_id = '19' AND a.status = '1' ORDER BY mra.article_id ASC |
| 1 | 0.073 ms | SELECT `query` FROM `oc_url_alias` WHERE keyword = 'rysskie-blagovoniya' LIMIT 1 |
| 1 | 0.066 ms | SELECT currency_id, title, code, symbol_left, symbol_right, decimal_place, value, status, date_modified FROM oc_currency ORDER BY title ASC |
| 1 | 0.066 ms | SELECT layout_id FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route ORDER BY route DESC LIMIT 1 |
| 1 | 0.062 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('product_id=3792','product_id=3794','product_id=3795','product_id=3793','product_id=3798','product_id=3799','product_id=3797') |
| 1 | 0.052 ms | SELECT `trigger`, `action` FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| 1 | 0.041 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'product/manufacturer' LIMIT 1 |
| 1 | 0.037 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'product/compare' LIMIT 1 |
Русское благовоние «Даммар»
200р.
Русское благовоние «Ладан»
200р.
Русское благовоние «Ливанский кедр»
200р.
Русское благовоние «Сибирский кедр»
200р.
Русское благовоние «Смирна»
200р.
Русское благовоние «Мирра»
220р.
Русское благовоние «Северная сосна»
220р.