Корзина пуста!
Свечи восковые зеленые №80 (5 шт., маканые)
125р.
100р.
Свечи восковые красные №80 (5 шт., маканые)
125р.
100р.
full
| Метод | Маршрут | URI | Query String | Генерация | Память | Пик | Рост | Резерв PHP |
|---|---|---|---|---|---|---|---|---|
| GET | common/home | /special/page-2 | _route_=special/page-2& | 20.076 ms | 2.74 MB | 2.78 MB | 1.84 MB | 4.00 MB |
| Маршрут | Время | Дельта памяти |
|---|---|---|
| startup/startup/index | 2.302 ms | 422.81 KB |
| startup/impersonate/index | 0.003 ms | 376 B |
| startup/error/index | 0.089 ms | 72.29 KB |
| startup/event/index | 0.124 ms | 7.49 KB |
| startup/maintenance/index | 0.003 ms | 376 B |
| startup/seo_url/index | 0.182 ms | 5.15 KB |
| event/theme/index | 0.012 ms | 600 B |
| common/column_left/index | 1.620 ms | 245.30 KB |
| event/theme/index | 0.009 ms | 616 B |
| common/column_right/index | 0.077 ms | 1.70 KB |
| event/theme/index | 0.008 ms | 600 B |
| common/content_top/index | 0.063 ms | 1.54 KB |
| event/theme/index | 0.007 ms | 616 B |
| common/content_bottom/index | 0.051 ms | 1.54 KB |
| Метод | Время | Дельта памяти |
|---|---|---|
| localisation/language/getLanguages | 0.101 ms | 3.71 KB |
| localisation/currency/getCurrencies | 0.080 ms | 3.52 KB |
| extension/event/getEvents | 0.060 ms | 1.10 KB |
| catalog/product/getTotalProductSpecials | 0.147 ms | 2.09 KB |
| catalog/product/getProductSpecials | 2.190 ms | 32.35 KB |
| tool/image/resizeBatch | 0.091 ms | 2.85 KB |
| design/layout/getLayout | 0.101 ms | 1.59 KB |
| design/layout/getLayoutModulesAll | 0.102 ms | 6.93 KB |
| Шаблон | Время | Дельта памяти |
|---|---|---|
| theme_magii/template/common/column_left.tpl | 0.059 ms | 728 B |
| theme_magii/template/common/column_right.tpl | 0.032 ms | 568 B |
| theme_magii/template/common/content_top.tpl | 0.027 ms | 568 B |
| theme_magii/template/common/content_bottom.tpl | 0.024 ms | 568 B |
| Тип | Кэш | Строки | Время | SQL |
|---|---|---|---|---|
| read | no | 375 | 0.403 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.083 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.067 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.077 ms | SELECT `query` FROM `oc_url_alias` WHERE keyword = 'special' LIMIT 1 |
| read | no | 1 | 0.047 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'product/compare' LIMIT 1 |
| read | no | 1 | 0.136 ms | SELECT COUNT(DISTINCT ps.product_id) AS total FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) WHERE p.status = '1' AND p.date_available <= 1780701061 AND ps.customer_group_id = '1' AND ((ps.date_start = 0 OR ps.date_start <= 1780701061) AND (ps.date_end = 0 OR ps.date_end >= 1780701061)) |
| read | no | 2 | 1.424 ms | WITH base_products AS (SELECT ps.product_id, pd.name AS pd_name, p.sort_order, p.price AS base_price FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.status = '1' AND p.date_available <= 1780701061 AND pd.language_id = '3' AND ps.customer_group_id = '1' AND ((ps.date_start = 0 OR ps.date_start <= 1780701061) AND (ps.date_end = 0 OR ps.date_end >= 1780701061)) GROUP BY ps.product_id UNION SELECT pd2.product_id, pd.name AS pd_name, p.sort_order, p.price AS base_price FROM oc_product_discount pd2 LEFT JOIN oc_product p ON (pd2.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.status = '1' AND p.date_available <= 1780701061 AND pd.language_id = '3' AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = 0 OR pd2.date_start <= 1780701061) AND (pd2.date_end = 0 OR pd2.date_end >= 1780701061)) GROUP BY pd2.product_id), 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 <= 1780701061) AND (ps.date_end = 0 OR ps.date_end >= 1780701061)) ) t WHERE t.rn = 1 ), 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 <= 1780701061) AND (pd2.date_end = 0 OR pd2.date_end >= 1780701061)) ) t WHERE t.rn = 1 ) SELECT bp.product_id, bp.base_price, COALESCE(sp.special, dp.discount) AS special FROM base_products bp LEFT JOIN specials sp ON (sp.product_id = bp.product_id) LEFT JOIN discounts dp ON (dp.product_id = bp.product_id) ORDER BY bp.sort_order ASC, LOWER(bp.pd_name) ASC LIMIT 9,9 |
| read | no | 2 | 0.059 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('product_id=300','product_id=301') |
| read | no | 2 | 0.601 ms | WITH ids(product_id) AS (VALUES (300),(301)), 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 <= 1780701061) AND (pd2.date_end = 0 OR pd2.date_end >= 1780701061)) ) 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 <= 1780701061) AND (ps.date_end = 0 OR ps.date_end >= 1780701061)) ) 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 <= 1780701061 ORDER BY CASE p.product_id WHEN 300 THEN 0 WHEN 301 THEN 1 ELSE 2 END |
| read | no | 0 | 0.086 ms | SELECT layout_id FROM oc_layout_route WHERE 'product/special' LIKE route ORDER BY route DESC LIMIT 1 |
| read | no | 11 | 0.094 ms | SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '4' ORDER BY position, sort_order |
| read | no | 1 | 0.131 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/special','special')
AND sp.status = '1'
AND spd.language_id = '3'
ORDER BY CASE sp.route WHEN 'product/special' THEN 0 WHEN 'special' THEN 1 ELSE 9999 END
LIMIT 1 |
| Повторов | Сумма времени | SQL |
|---|---|---|
| 1 | 1.424 ms | WITH base_products AS (SELECT ps.product_id, pd.name AS pd_name, p.sort_order, p.price AS base_price FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.status = '1' AND p.date_available <= 1780701061 AND pd.language_id = '3' AND ps.customer_group_id = '1' AND ((ps.date_start = 0 OR ps.date_start <= 1780701061) AND (ps.date_end = 0 OR ps.date_end >= 1780701061)) GROUP BY ps.product_id UNION SELECT pd2.product_id, pd.name AS pd_name, p.sort_order, p.price AS base_price FROM oc_product_discount pd2 LEFT JOIN oc_product p ON (pd2.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.status = '1' AND p.date_available <= 1780701061 AND pd.language_id = '3' AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = 0 OR pd2.date_start <= 1780701061) AND (pd2.date_end = 0 OR pd2.date_end >= 1780701061)) GROUP BY pd2.product_id), 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 <= 1780701061) AND (ps.date_end = 0 OR ps.date_end >= 1780701061)) ) t WHERE t.rn = 1 ), 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 <= 1780701061) AND (pd2.date_end = 0 OR pd2.date_end >= 1780701061)) ) t WHERE t.rn = 1 ) SELECT bp.product_id, bp.base_price, COALESCE(sp.special, dp.discount) AS special FROM base_products bp LEFT JOIN specials sp ON (sp.product_id = bp.product_id) LEFT JOIN discounts dp ON (dp.product_id = bp.product_id) ORDER BY bp.sort_order ASC, LOWER(bp.pd_name) ASC LIMIT 9,9 |
| 1 | 0.601 ms | WITH ids(product_id) AS (VALUES (300),(301)), 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 <= 1780701061) AND (pd2.date_end = 0 OR pd2.date_end >= 1780701061)) ) 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 <= 1780701061) AND (ps.date_end = 0 OR ps.date_end >= 1780701061)) ) 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 <= 1780701061 ORDER BY CASE p.product_id WHEN 300 THEN 0 WHEN 301 THEN 1 ELSE 2 END |
| 1 | 0.403 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.136 ms | SELECT COUNT(DISTINCT ps.product_id) AS total FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) WHERE p.status = '1' AND p.date_available <= 1780701061 AND ps.customer_group_id = '1' AND ((ps.date_start = 0 OR ps.date_start <= 1780701061) AND (ps.date_end = 0 OR ps.date_end >= 1780701061)) |
| 1 | 0.131 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/special','special') AND sp.status = '1' AND spd.language_id = '3' ORDER BY CASE sp.route WHEN 'product/special' THEN 0 WHEN 'special' THEN 1 ELSE 9999 END LIMIT 1 |
| 1 | 0.094 ms | SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '4' ORDER BY position, sort_order |
| 1 | 0.086 ms | SELECT layout_id FROM oc_layout_route WHERE 'product/special' LIKE route ORDER BY route DESC LIMIT 1 |
| 1 | 0.083 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.077 ms | SELECT `query` FROM `oc_url_alias` WHERE keyword = 'special' LIMIT 1 |
| 1 | 0.067 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.059 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('product_id=300','product_id=301') |
| 1 | 0.052 ms | SELECT `trigger`, `action` FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| 1 | 0.047 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'product/compare' LIMIT 1 |