| read | no | 375 | 0.441 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.093 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.074 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.052 ms | SELECT `trigger`, `action` FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| read | no | 1 | 0.062 ms | SELECT `query` FROM `oc_url_alias` WHERE keyword = 'blagovonie-chandan-sandal-1' LIMIT 1 |
| read | no | 1 | 0.695 ms | WITH ids(product_id) AS (VALUES (3820)),
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 <= 1780705232) AND (pd2.date_end = 0 OR pd2.date_end >= 1780705232))
) 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 <= 1780705232) AND (ps.date_end = 0 OR ps.date_end >= 1780705232))
) 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 <= 1780705232
ORDER BY CASE p.product_id WHEN 3820 THEN 0 ELSE 1 END |
| read | no | 3 | 0.617 ms | WITH display AS (
SELECT ptc.category_id
FROM oc_product_to_category ptc
INNER JOIN oc_category c0 ON (c0.category_id = ptc.category_id AND c0.status = '1')
WHERE ptc.product_id = '3820'
), chosen AS (
SELECT CASE
WHEN '0' > 0 AND EXISTS (SELECT 1 FROM display WHERE category_id = '0') THEN '0'
WHEN EXISTS (SELECT 1 FROM display) THEN (
SELECT d.category_id
FROM display d
LEFT JOIN (SELECT category_id, MAX(level) AS max_level FROM oc_category_path GROUP BY category_id) depth ON (depth.category_id = d.category_id)
ORDER BY COALESCE(depth.max_level, 0) DESC, d.category_id ASC
LIMIT 1
)
WHEN '0' > 0 THEN '0'
ELSE 0
END AS category_id
), path_rows AS (
SELECT cp.path_id AS category_id, cp.level AS level
FROM oc_category_path cp
INNER JOIN chosen ch ON (ch.category_id = cp.category_id)
WHERE ch.category_id > 0
UNION ALL
SELECT ch.category_id AS category_id, 0 AS level
FROM chosen ch
WHERE ch.category_id > 0
AND NOT EXISTS (SELECT 1 FROM oc_category_path cp2 WHERE cp2.category_id = ch.category_id)
)
SELECT c.category_id, c.parent_id, c.sort_order, cd.name, ua.keyword
FROM path_rows pr
INNER JOIN oc_category c ON (c.category_id = pr.category_id AND c.status = '1')
LEFT JOIN oc_category_description cd ON (cd.category_id = c.category_id AND cd.language_id = '3')
LEFT JOIN oc_url_alias ua ON (ua.`query` = ('category_id=' || c.category_id))
ORDER BY pr.level ASC, c.category_id ASC |
| read | no | 0 | 0.047 ms | SELECT total_published, total_with_rating, rating_sum, last_comment_ts FROM oc_comment_stat WHERE entity_type = 'product' AND entity_id = '3820' LIMIT 1 |
| read | no | 0 | 0.107 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/product&product_id=3820')
AND sp.status = '1'
AND spd.language_id = '3'
ORDER BY CASE sp.route WHEN 'product/product&product_id=3820' THEN 0 ELSE 9999 END
LIMIT 1 |
| read | no | 1 | 0.045 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'manufacturer_id=15' LIMIT 1 |
| read | no | 0 | 0.049 ms | SELECT product_image_id, product_id, image, sort_order FROM oc_product_image WHERE product_id = '3820' ORDER BY sort_order ASC |
| read | no | 0 | 0.077 ms | SELECT product_discount_id, product_id, customer_group_id, quantity, priority, price, date_start, date_end FROM oc_product_discount WHERE product_id = '3820' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = 0 OR date_start <= 1780705232) AND (date_end = 0 OR date_end >= 1780705232)) ORDER BY quantity ASC, priority ASC, price ASC |
| read | no | 0 | 0.071 ms | SELECT po.product_option_id, po.product_id, po.option_id, po.value, po.required, o.type, o.sort_order, od.name 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 = '3820' AND od.language_id = '3' ORDER BY o.sort_order |
| read | no | 4 | 0.168 ms | SELECT ag.attribute_group_id, agd.name AS attribute_group_name, a.attribute_id, ad.name AS attribute_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 AND ad.language_id = '3')
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id AND agd.language_id = '3')
WHERE pa.product_id = '3820' AND pa.language_id = '3'
ORDER BY ag.sort_order, agd.name, a.sort_order, ad.name |
| read | no | 0 | 0.191 ms | SELECT pra.article_id AS blog_article_id, ad.title AS name, a.image, a.date_added AS date FROM oc_product_related_article pra INNER JOIN oc_blog_article a ON (pra.article_id = a.article_id) INNER JOIN oc_blog_article_description ad ON (a.article_id = ad.article_id AND ad.language_id = '3') WHERE pra.product_id = '3820' AND a.status = '1' ORDER BY pra.article_id ASC |
| read | no | 6 | 0.472 ms | WITH related(product_id, ord) AS (
SELECT pr.related_id, ROW_NUMBER() OVER (ORDER BY pr.related_id ASC) AS ord
FROM oc_product_related pr
WHERE pr.product_id = '3820'
),
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 related r ON r.product_id = pd2.product_id
WHERE pd2.customer_group_id = '1'
AND pd2.quantity = '1'
AND ((pd2.date_start = 0 OR pd2.date_start <= 1780705232) AND (pd2.date_end = 0 OR pd2.date_end >= 1780705232))
) t WHERE 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 related r ON r.product_id = ps.product_id
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = 0 OR ps.date_start <= 1780705232) AND (ps.date_end = 0 OR ps.date_end >= 1780705232))
) t WHERE rn = 1
)
SELECT
p.product_id,
pd.name,
p.image,
p.price AS base_price,
COALESCE(d.discount, 0) AS discount,
CASE WHEN COALESCE(d.discount, 0) > 0 THEN d.discount ELSE p.price END AS price,
COALESCE(s.special, 0) AS special,
p.tax_class_id,
p.minimum,
p.quantity,
p.subtract,
p.is_product_group,
p.product_group_list_type, pd.short_description AS description
FROM related r
INNER JOIN oc_product p ON (p.product_id = r.product_id AND p.status = '1' AND p.date_available <= 1780705232)
INNER JOIN oc_product_description pd ON (pd.product_id = p.product_id AND pd.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)
ORDER BY r.ord ASC |
| read | no | 6 | 0.062 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('product_id=3816','product_id=3817','product_id=3818','product_id=3821','product_id=3822','product_id=3823') |
| read | no | 1 | 0.073 ms | SELECT layout_id FROM oc_layout_route WHERE 'product/product' LIKE route ORDER BY route DESC LIMIT 1 |
| read | no | 1 | 0.034 ms | SELECT * FROM oc_product_to_layout WHERE product_id = '3820' |
| read | no | 11 | 0.096 ms | SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '2' ORDER BY position, sort_order |
Благовоние «Лаванда фенхель»
45р.
Благовоние «Можжевельник»
45р.
Благовоние «Пачули»
45р.
Благовоние «Уверенность» (Жасмин)
75р.
Благовоние «Защита» (Эвкалипт)
75р.
Благовоние «Мудрость» (Ландыш)
75р.