| read | no | 0 | 0.048 ms | SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://test.magazin-magii.ru/' |
| read | no | 368 | 0.354 ms | SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC |
| read | no | 1 | 0.083 ms | SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name |
| read | no | 1 | 0.071 ms | SELECT * FROM oc_currency ORDER BY title ASC |
| read | no | 0 | 0.129 ms | 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 tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '187') AND z2gz.city_id = '0' AND z2gz.district_id = '0' AND z2gz.metro_station_id = '0' ORDER BY tr1.priority ASC |
| read | no | 0 | 0.080 ms | SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| read | no | 1 | 0.063 ms | SELECT `query` FROM `oc_url_alias` WHERE keyword = 'podkova-udachi' LIMIT 1 |
| read | no | 1 | 0.741 ms | WITH ids(product_id) AS (VALUES (95)),
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 <= 1776774613) AND (pd2.date_end = 0 OR pd2.date_end >= 1776774613))
) 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 <= 1776774613) AND (ps.date_end = 0 OR ps.date_end >= 1776774613))
) 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')
JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id AND p2s.store_id = '0')
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 <= 1776774613
ORDER BY CASE p.product_id WHEN 95 THEN 0 ELSE 1 END |
| read | no | 2 | 0.050 ms | SELECT category_id FROM oc_product_to_category WHERE product_id = '95' |
| read | no | 2 | 0.072 ms | SELECT category_id, MAX(level) AS max_level FROM oc_category_path WHERE category_id IN (59,68) GROUP BY category_id |
| read | no | 2 | 0.039 ms | SELECT path_id FROM oc_category_path WHERE category_id = '68' ORDER BY level |
| read | no | 2 | 0.113 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')
LEFT JOIN oc_category_to_store c2s
ON (c.category_id = c2s.category_id AND c2s.store_id = '0')
WHERE c.category_id IN (59,68)
AND c.status = '1'
AND c2s.store_id IS NOT NULL |
| read | no | 2 | 0.054 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('category_id=59','category_id=68') |
| read | no | 0 | 0.054 ms | SELECT total_published, total_with_rating, rating_sum, last_comment_ts FROM oc_comment_stat WHERE entity_type = 'product' AND entity_id = '95' LIMIT 1 |
| read | no | 0 | 0.085 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 = 'product/product&product_id=95'
AND sp.status = '1'
AND spd.language_id = '3'
LIMIT 1 |
| read | no | 1 | 0.043 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'manufacturer_id=16' LIMIT 1 |
| read | no | 2 | 0.083 ms | SELECT * FROM oc_product_image WHERE product_id = '95' ORDER BY sort_order ASC |
| read | no | 0 | 0.103 ms | SELECT * FROM oc_product_discount WHERE product_id = '95' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = 0 OR date_start <= 1776774613) AND (date_end = 0 OR date_end >= 1776774613)) ORDER BY quantity ASC, priority ASC, price ASC |
| read | no | 0 | 0.071 ms | 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 = '95' AND od.language_id = '3' ORDER BY o.sort_order |
| read | no | 1 | 0.034 ms | SELECT is_product_group FROM oc_product WHERE product_id = '95' LIMIT 1 |
| read | no | 5 | 0.181 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 = '95' AND pa.language_id = '3'
ORDER BY ag.sort_order, agd.name, a.sort_order, ad.name |
| read | no | 1 | 0.061 ms | SELECT p.product_id FROM oc_product p JOIN oc_product_to_store p2s ON (p2s.product_id = p.product_id AND p2s.store_id = '0') WHERE p.product_id = '95' AND p.status = '1' AND p.date_available <= '1776774613' LIMIT 1 |
| read | yes | 0 | 0.003 ms | SELECT total_published, total_with_rating, rating_sum, last_comment_ts FROM oc_comment_stat WHERE entity_type = 'product' AND entity_id = '95' LIMIT 1 |
| read | no | 0 | 0.075 ms | SELECT comment_id, entity_type, entity_id, customer_id, author_name, author_email, rating, text, status, moderation_state, date_added, date_modified FROM oc_comment WHERE entity_type = 'product' AND entity_id = '95' AND status = '1' ORDER BY date_added DESC, comment_id DESC LIMIT 0,2 |
| read | no | 1 | 0.035 ms | SELECT name FROM oc_product_description WHERE product_id = '95' AND language_id = '3' LIMIT 1 |
| read | no | 0 | 0.113 ms | SELECT pra.article_id FROM oc_product_related_article pra INNER JOIN oc_blog_article a ON (pra.article_id = a.article_id) INNER JOIN oc_blog_article_to_store a2s ON (pra.article_id = a2s.article_id) WHERE pra.product_id = '95' AND a.status = '1' AND a2s.store_id = '0' ORDER BY pra.article_id ASC |
| read | no | 6 | 0.086 ms | SELECT pr.related_id 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 = '95' AND p.status = '1' AND p.date_available <= 1776774613 AND p2s.store_id = '0' |
| read | no | 6 | 0.055 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('product_id=92','product_id=93','product_id=94','product_id=96','product_id=97','product_id=98') |
| read | no | 6 | 0.600 ms | WITH ids(product_id) AS (VALUES (92),(93),(94),(96),(97),(98)),
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 <= 1776774613) AND (pd2.date_end = 0 OR pd2.date_end >= 1776774613))
) 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 <= 1776774613) AND (ps.date_end = 0 OR ps.date_end >= 1776774613))
) 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')
JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id AND p2s.store_id = '0')
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 <= 1776774613
ORDER BY CASE p.product_id WHEN 92 THEN 0 WHEN 93 THEN 1 WHEN 94 THEN 2 WHEN 96 THEN 3 WHEN 97 THEN 4 WHEN 98 THEN 5 ELSE 6 END |
| read | no | 1 | 0.072 ms | SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1 |
| read | no | 1 | 0.050 ms | SELECT * FROM oc_product_to_layout WHERE product_id = '95' AND store_id = '0' |
| read | no | 11 | 0.078 ms | SELECT * FROM oc_layout_module WHERE layout_id = '2' ORDER BY position, sort_order |
| read | no | 11 | 0.068 ms | SELECT module_id, setting FROM oc_module WHERE module_id IN (33,37,40,42,46,47,48,50,51,54,55) |
