| read | no | 375 | 0.409 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') |
| read | no | 1 | 0.104 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 |
| read | no | 1 | 0.085 ms | SELECT currency_id, title, code, symbol_left, symbol_right, decimal_place, value, status, date_modified FROM oc_currency ORDER BY title ASC |
| read | no | 0 | 0.056 ms | SELECT `trigger`, `action` FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| read | no | 1 | 0.069 ms | SELECT `query` FROM `oc_url_alias` WHERE keyword = 'masterskaja' LIMIT 1 |
| read | no | 0 | 0.094 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'product/manufacturer' LIMIT 1 |
| read | no | 1 | 0.119 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 = '14' AND md.language_id = '3' |
| read | no | 1 | 0.039 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'product/compare' LIMIT 1 |
| read | no | 1 | 0.257 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 <= 1780702142 AND p.manufacturer_id = '14' |
| read | no | 9 | 1.027 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 <= 1780702142 AND p.manufacturer_id = '14' 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 <= 1780702142) AND (pd2.date_end = 0 OR pd2.date_end >= 1780702142))
) 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 <= 1780702142) AND (ps.date_end = 0 OR ps.date_end >= 1780702142))
) 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 |
| read | no | 9 | 0.088 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('product_id=3731','product_id=300','product_id=301','product_id=3713','product_id=299','product_id=3804','product_id=3717','product_id=3720','product_id=3782') |
| read | no | 9 | 0.806 ms | WITH ids(product_id) AS (VALUES (3731),(300),(301),(3713),(299),(3804),(3717),(3720),(3782)),
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 <= 1780702142) AND (pd2.date_end = 0 OR pd2.date_end >= 1780702142))
) 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 <= 1780702142) AND (ps.date_end = 0 OR ps.date_end >= 1780702142))
) 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 <= 1780702142
ORDER BY CASE p.product_id WHEN 3731 THEN 0 WHEN 300 THEN 1 WHEN 301 THEN 2 WHEN 3713 THEN 3 WHEN 299 THEN 4 WHEN 3804 THEN 5 WHEN 3717 THEN 6 WHEN 3720 THEN 7 WHEN 3782 THEN 8 ELSE 9 END |
| read | no | 0 | 0.090 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 = '14' AND a.status = '1' ORDER BY mra.article_id ASC |
| read | no | 0 | 0.066 ms | SELECT layout_id FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route ORDER BY route DESC LIMIT 1 |
| read | no | 11 | 0.091 ms | SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '4' ORDER BY position, sort_order |
| read | no | 0 | 0.119 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=14')
AND sp.status = '1'
AND spd.language_id = '3'
ORDER BY CASE sp.route WHEN 'product/manufacturer/info&manufacturer_id=14' THEN 0 ELSE 9999 END
LIMIT 1 |
Свечи восковые желтые №80 (5 шт., маканые)
125р.
100р.
Свечи восковые зеленые №80 (5 шт., маканые)
125р.
100р.
Свечи восковые красные №80 (5 шт., маканые)
125р.
100р.
Свечи восковые синие №80 (5 шт., маканые)
125р.
100р.
Свечи восковые черные №80 (5 шт., маканые)
125р.
100р.
Свечи восковые коричневые №80 (5 шт., маканые)
125р.
Желтый воск
140р.
Зеленый воск
150р.
Изумрудный воск
150р.