| read | no | 375 | 0.609 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.106 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.086 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.063 ms | SELECT `trigger`, `action` FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| read | no | 1 | 0.084 ms | SELECT `query` FROM `oc_url_alias` WHERE keyword = 'larcy-zhelanij' LIMIT 1 |
| read | no | 1 | 0.117 ms | SELECT group_concat(path_id, '_') AS path FROM (SELECT path_id FROM oc_category_path WHERE category_id = '143' ORDER BY level) |
| read | no | 2 | 0.065 ms | SELECT path_id FROM oc_category_path WHERE category_id = '143' ORDER BY level |
| read | no | 2 | 0.150 ms | SELECT c.category_id, c.parent_id, c.sort_order, c.status, cd.name
FROM oc_category c
LEFT JOIN oc_category_description cd
ON (c.category_id = cd.category_id AND cd.language_id = '3')
WHERE c.category_id IN (142,143)
AND c.status = '1'
AND c.status = '1' |
| read | no | 1 | 0.039 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('category_id=142') |
| read | no | 1 | 0.109 ms | SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) WHERE c.category_id = '143' AND cd.language_id = '3' AND c.status = '1' |
| read | no | 1 | 0.056 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'product/compare' LIMIT 1 |
| read | no | 0 | 0.111 ms | SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '143' AND cd.language_id = '3' AND c.status = '1' AND c.top = '0' ORDER BY c.sort_order, LOWER(cd.name) |
| read | no | 1 | 0.143 ms | SELECT COUNT(*) AS total FROM oc_product_to_category p2c INNER JOIN oc_product p ON (p.product_id = p2c.product_id) INNER JOIN oc_product_description pd ON (pd.product_id = p.product_id AND pd.language_id = '3') WHERE p2c.category_id = '143' AND p.status = '1' AND p.date_available <= 1780698664 |
| read | no | 9 | 1.142 ms | WITH base_products AS (SELECT
p.product_id,
pd.name AS name,
pd.short_description AS short_description,
p.image,
p.price,
p.tax_class_id,
p.minimum,
p.quantity,
p.subtract,
p.is_product_group,
p.product_group_list_type,
p.sort_order,
p.date_added,
CASE WHEN p.subtract = '1' AND p.quantity <= 0 THEN 1 ELSE 0 END AS stock_bucket FROM oc_product_to_category p2c INNER JOIN oc_product p ON (p.product_id = p2c.product_id) INNER JOIN oc_product_description pd ON (pd.product_id = p.product_id AND pd.language_id = '3') WHERE p2c.category_id = '143' AND p.status = '1' AND p.date_available <= 1780698664),
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 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 <= 1780698664) AND (pd2.date_end = 0 OR pd2.date_end >= 1780698664))
) 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 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 <= 1780698664) AND (ps.date_end = 0 OR ps.date_end >= 1780698664))
) t WHERE t.rn = 1
),
priced_products AS (
SELECT
bp.*,
d.discount AS discount,
s.special AS special,
CASE WHEN s.special IS NOT NULL THEN s.special WHEN d.discount IS NOT NULL THEN d.discount ELSE bp.price END AS effective_price,
CASE WHEN bp.price > 0 AND (CASE WHEN s.special IS NOT NULL THEN s.special WHEN d.discount IS NOT NULL THEN d.discount ELSE bp.price END) < bp.price THEN ((bp.price - (CASE WHEN s.special IS NOT NULL THEN s.special WHEN d.discount IS NOT NULL THEN d.discount ELSE bp.price END)) / bp.price) ELSE 0 END AS discount_percent
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)
)
SELECT * FROM priced_products ORDER BY stock_bucket ASC, effective_price ASC, LOWER(name) ASC, product_id ASC LIMIT 0,9 |
| read | no | 9 | 0.071 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('product_id=3761','product_id=3764','product_id=3771','product_id=3762','product_id=3766','product_id=3772','product_id=3767','product_id=3768','product_id=3765') |
| read | no | 0 | 0.184 ms | SELECT cra.article_id AS blog_article_id, ad.title AS name, a.image, a.date_added AS date FROM oc_category_related_article cra INNER JOIN oc_blog_article a ON (cra.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 cra.category_id = '143' AND a.status = '1' ORDER BY cra.article_id ASC |
| read | no | 1 | 0.090 ms | SELECT layout_id FROM oc_layout_route WHERE 'product/category' LIKE route ORDER BY route DESC LIMIT 1 |
| read | no | 1 | 0.035 ms | SELECT * FROM oc_category_to_layout WHERE category_id = '143' |
| read | no | 11 | 0.087 ms | SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '3' ORDER BY position, sort_order |
| read | no | 0 | 0.105 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/category&path=142_143')
AND sp.status = '1'
AND spd.language_id = '3'
ORDER BY CASE sp.route WHEN 'product/category&path=142_143' THEN 0 ELSE 9999 END
LIMIT 1 |
Ларец желаний «Богатство»
140р.
Ларец желаний «Достижение успеха»
140р.
Ларец желаний «Женское совершенство»
140р.
Ларец желаний «Исполнение желаний»
140р.
Ларец желаний «Крепкое здоровье»
140р.
Ларец желаний «Мужское совершенство»
140р.
Ларец желаний «Притяжение любви»
140р.
Ларец желаний «Семейное благополучие»
140р.
Ларец желаний «Снятие порчи и сглаза»
140р.