Накладки на полки

Сортировка:

Показать:

Отделка стекла передняя 49см. b4561510300

305 р.

от 1 до 5

Накладка полки холодильника Beko, передняя, 45см. 4561530300

300 р.

1 или меньше

Ожидается

Накладка стеклянной полки задняя холодильников Beko (Беко) 4561540100 зам. b4561540100, 4564180200, WM505

290 р.

1 или меньше

Ожидается

Отделка стекла задняя 49см. b4561520100

250 р.

1 или меньше

Ожидается

Передний профиль полки холодильника Beko 4841082200

90 р.

1 или меньше

Ожидается

Профиль полки холодильника задний. b4638130100

150 р.

1 или меньше

Ожидается

Показано с 1 по 6 из 6 (всего 1 страниц)

#	Query time (s)	Controller	Query
1	0.0001		SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://tumen.islzip.ru/'
2	0.0021		SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '18' ORDER BY store_id ASC
3	0.0002		SELECT * FROM `language` WHERE status = '1'
4	0.0001		SELECT * FROM currency
5	0		SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2793') ORDER BY tr1.priority ASC
6	0		SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2793') ORDER BY tr1.priority ASC
7	0		SELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '14'
8	0		SELECT * FROM length_class mc LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '14'
9	0.003		DELETE FROM cart WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 3 MONTH)
10	0		SELECT * FROM extension WHERE `type` = 'openbay'
11	0.0001		SELECT * FROM event
12	0.0001		SELECT f1.postalcode f1_postalcode, f1.offname f1_name, f1.level f1_level, f1.fias_id f1_fias_id, f1.shortname f1_shortname, CONCAT(f2.offname, ' ', f2.shortname) f2_name, f2.level f2_level, f2.fias_id f2_fias_id, CONCAT(f3.offname, ' ', f3.shortname) f3_name, f3.level f3_level, f3.fias_id f3_fias_id, CONCAT(f4.offname, ' ', f4.shortname) f4_name, f4.level f4_level, f4.fias_id f4_fias_id FROM fias f1 LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id WHERE f1.offname = 'Сиэтл' AND (f3.offname = 'США' OR f2.offname = 'США' OR f4.offname = 'США') AND (f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.'))
13	0		SELECT * FROM country c WHERE c.iso_code_2 = "US"
14	0		SELECT code FROM geoip_currency WHERE country_id = 223
15	0		SELECT * FROM geoip_rule
16	0.0001	ControllerCommonSeoPro	SELECT * FROM `mfilter_url_alias` WHERE `store_id` = 0
17	0.0001	ControllerCommonSeoPro	SELECT `value` FROM `setting` WHERE `key` = 'config_language'
18	0.0002	ControllerCommonSeoPro	SELECT * FROM language WHERE status = '1'
19	0.0001	ControllerProductCategory	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '6' AND cd.language_id = '14' AND c.status = '1'
20	0.0001	ControllerProductCategory	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '47' AND cd.language_id = '14' AND c.status = '1'
21	0.0004	ControllerProductCategory	SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '59' AND cd.language_id = '14' AND c.status = '1'
22	0.0005	ControllerProductCategory	SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '59' AND cd.language_id = '14' AND c.status = '1' ORDER BY c.sort_order, LCASE(CASE WHEN cd.menu_name <> '' THEN cd.menu_name ELSE cd.name END)
23	0.0005	ControllerProductCategory	SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW() AND cp.path_id = '59'
24	0.0009	ControllerProductCategory	SELECT p.product_id, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW() AND cp.path_id = '59' GROUP BY p.product_id ORDER BY p.quantity_18 DESC, LCASE(pd.name) ASC LIMIT 0,18
25	0.0009	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '2867' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
26	0.0007	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '5100' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
27	0.0007	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '4212' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
28	0.0007	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '2866' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
29	0.0007	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '6123' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
30	0.0007	ControllerProductCategory	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '6217' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
31	0.0003	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '2867' ORDER BY main_category DESC LIMIT 1
32	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '5100' ORDER BY main_category DESC LIMIT 1
33	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '4212' ORDER BY main_category DESC LIMIT 1
34	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '2866' ORDER BY main_category DESC LIMIT 1
35	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '6123' ORDER BY main_category DESC LIMIT 1
36	0.0002	ControllerProductCategory	SELECT category_id FROM product_to_category WHERE product_id = '6217' ORDER BY main_category DESC LIMIT 1
37	0.0002	ControllerCommonColumnLeft	SELECT * FROM category_to_layout WHERE category_id = '59'
38	0	ControllerCommonColumnLeft	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
39	0	ControllerCommonColumnLeft	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
40	0.0001	ControllerModuleMegaFilter	SELECT * FROM `mfilter_settings` WHERE `idx` = 1
41	0.0001	ControllerModuleMegaFilter	SELECT * FROM `mfilter_settings` WHERE `idx` = 1
42	0.0006	ControllerModuleMegaFilter	SELECT `a`.`attribute_id`, REPLACE(REPLACE(TRIM(pa.text), ' ', ''), ' ', '') AS `txt`, `ad`.`name`, `ad`.`mf_tooltip` AS `tooltip`, `agd`.`name` AS `gname`, `agd`.`attribute_group_id` FROM `product` AS `p` INNER JOIN `product_to_store` AS `pts` ON `p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 18 INNER JOIN `product_attribute` AS `pa` ON `p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 14 INNER JOIN `attribute` AS `a` ON `a`.`attribute_id` = `pa`.`attribute_id` INNER JOIN `attribute_description` AS `ad` ON `ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 14 INNER JOIN `attribute_group` AS `ag` ON `ag`.`attribute_group_id` = `a`.`attribute_group_id` INNER JOIN `attribute_group_description` AS `agd` ON `agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 14 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(59) GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != '' ORDER BY `txt`
43	0.0003	ControllerModuleMegaFilter	SELECT `o`.`option_id`, `ov`.`option_value_id`, `od`.`name` AS `gname`, `od`.`mf_tooltip` AS `tooltip`, `ov`.`image`, `ovd`.`name`, LOWER(REPLACE(REPLACE(REPLACE(TRIM(`ovd`.`name`), ' ', ''), ' ', ''), ' ', '-')) AS `keyword` FROM `product` AS `p` INNER JOIN `product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 18 INNER JOIN `product_option_value` AS `pov` ON `p`.`product_id` = `pov`.`product_id` INNER JOIN `option_value` AS `ov` ON `ov`.`option_value_id` = `pov`.`option_value_id` INNER JOIN `option_value_description` AS `ovd` ON `ov`.`option_value_id` = `ovd`.`option_value_id` AND `ovd`.`language_id` = 14 INNER JOIN `option` AS `o` ON `o`.`option_id` = `pov`.`option_id` INNER JOIN `option_description` AS `od` ON `od`.`option_id` = `o`.`option_id` AND `od`.`language_id` = 14 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(59) AND `o`.`type` IN('radio','checkbox','select','image','image_radio') GROUP BY `o`.`option_id`, `ov`.`option_value_id` ORDER BY `ov`.`sort_order`, `ovd`.`name`
44	0.0002	ControllerModuleMegaFilter	SELECT `fgd`.`name` AS `gname`, `fgd`.`mf_tooltip` AS `tooltip`, `f`.`filter_group_id`, `f`.`filter_id`, `fd`.`name`, LOWER(REPLACE(REPLACE(REPLACE(TRIM(`fd`.`name`), ' ', ''), ' ', ''), ' ', '-')) AS `keyword` FROM `product` AS `p` INNER JOIN `product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 18 INNER JOIN `product_filter` AS `pf` ON `p`.`product_id` = `pf`.`product_id` INNER JOIN `filter` AS `f` ON `pf`.`filter_id` = `f`.`filter_id` INNER JOIN `filter_description` AS `fd` ON `pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 14 INNER JOIN `filter_group_description` AS `fgd` ON `f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 14 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(59) GROUP BY `f`.`filter_group_id`, `f`.`filter_id` ORDER BY `f`.`sort_order`, `fd`.`name`
45	0.0002	ControllerModuleMegaFilter	SELECT category_id FROM `category_path` WHERE `path_id` = 59
46	0.0004	ControllerModuleMegaFilter	SELECT `c`.`parent_id`, `c`.`category_id`,( SELECT `keyword` FROM `url_alias` AS `ua` WHERE `query` = CONCAT( 'category_id=', `c`.`category_id` ) LIMIT 1) AS `keyword`,`cd`.`name` FROM `category` AS `c` INNER JOIN `category_description` AS `cd` ON `cd`.`category_id` = `c`.`category_id` AND `cd`.`language_id` = '14' INNER JOIN `category_to_store` AS `c2s` ON `c`.`category_id` = `c2s`.`category_id` AND `c2s`.`store_id` = '18' WHERE `c`.`status` = '1' AND `c`.`parent_id` = 59 GROUP BY `c`.`category_id` ORDER BY `c`.`sort_order` ASC, `cd`.`name` ASC
47	0.0004	ControllerModuleMegaFilter	SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT `price_tmp` AS `price` FROM( SELECT IFNULL( ( SELECT `price` FROM `product_special` AS `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1 ), IFNULL( ( SELECT `price` FROM `product_discount` AS `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` >= '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1 ), `p`.`price` ) ) AS `price_tmp` FROM `product` AS `p` INNER JOIN `product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 14 INNER JOIN `product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 18 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(59) ) AS `tmp` ) AS `tmp`
48	0.0004	ControllerModuleMegaFilter	SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT `price_tmp` AS `price` FROM( SELECT IFNULL( ( SELECT `price` FROM `product_special` AS `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1 ), IFNULL( ( SELECT `price` FROM `product_discount` AS `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` >= '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1 ), `p`.`price` ) ) AS `price_tmp` FROM `product` AS `p` INNER JOIN `product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 14 INNER JOIN `product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 18 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(59) ) AS `tmp` ) AS `tmp`
49	0.0001	ControllerModuleMegaFilter	SELECT * FROM url_alias WHERE `query` = 'category_id=6'
50	0	ControllerModuleMegaFilter	SELECT * FROM url_alias WHERE `query` = 'category_id=47'
51	0.0002	ControllerModuleMegaFilter	SELECT * FROM url_alias WHERE `query` = 'category_id=59'
52	0.0001	ControllerModuleMegaFilter	SELECT * FROM `mfilter_url_alias` WHERE `language_id` = 14 AND ( `path` = '' OR `path` = 'kupit/zapchasti-dlia-holodilnikov/nakladki-na-polki' OR `path` = 'ru-18/kupit/zapchasti-dlia-holodilnikov/nakladki-na-polki' )
53	0.0003	ControllerModuleMegaFilter	SELECT * FROM `url_alias` AS `ua` WHERE `query` IN('category_id=6','category_id=47','category_id=59')
54	0	ControllerModuleMegaFilter	SELECT * FROM module WHERE module_id = '1'
55	0	ControllerModuleMegaFilter	SELECT * FROM module WHERE module_id = '38'
56	0.0001	ControllerCommonColumnRight	SELECT * FROM category_to_layout WHERE category_id = '59'
57	0	ControllerCommonColumnRight	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
58	0	ControllerCommonColumnRight	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
59	0	ControllerCommonContentTop	SELECT * FROM category_to_layout WHERE category_id = '59'
60	0	ControllerCommonContentTop	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
61	0	ControllerCommonContentTop	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
62	0	ControllerCommonContentBottom	SELECT * FROM category_to_layout WHERE category_id = '59'
63	0	ControllerCommonContentBottom	SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
64	0	ControllerCommonContentBottom	SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
65	0.0002	ControllerCommonCart	SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'
66	0.0001	ControllerCommonCart	SELECT * FROM extension WHERE `type` = 'total'
67	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'
68	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'
69	0.0001	ControllerCommonCart	SELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'
70	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'
71	0	ControllerCommonCart	SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'
72	0.0001	ControllerCommonCart	SELECT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '14' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
73	0.0001	ControllerCommonCart	SELECT * FROM `menu` m LEFT JOIN menu_description md ON (m.menu_id = md.menu_id) LEFT JOIN menu_to_store ms ON (m.menu_id = ms.menu_id) WHERE md.language_id = '14' AND m.status = 1 ORDER BY m.sort_order
74	0	ControllerCommonCart	SELECT * FROM `menu_child` mc LEFT JOIN menu_child_description mcd ON (mc.menu_child_id = mcd.menu_child_id) LEFT JOIN menu_child_to_store mcs ON (mc.menu_child_id = mcs.menu_child_id) WHERE mcd.language_id = '14' AND mc.status = 1 ORDER BY mc.sort_order
75	0.0001	ControllerModuleGeoip	SELECT * FROM extension WHERE `type` = 'module'
76	0.0001	ControllerModuleGeoip	SELECT * FROM geoip_city ORDER BY sort, name
77	0.0001	ControllerModuleGeoip	SELECT * FROM geoip_redirect
78	0.0001	ControllerBlogMenu	SELECT * FROM blog_category c LEFT JOIN blog_category_description cd ON (c.blog_category_id = cd.blog_category_id) LEFT JOIN blog_category_to_store c2s ON (c.blog_category_id = c2s.blog_category_id) WHERE cd.language_id = '14' AND c2s.store_id = '18' AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name
79	0.0001	ControllerCommonCart	SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'
80	0	ControllerCommonCart	SELECT * FROM extension WHERE `type` = 'total'
81	0	ControllerCommonCart	SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'
82	0	ControllerCommonCart	SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'
83	0	ControllerCommonCart	SELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'
84	0	ControllerCommonCart	SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'
85	0	ControllerCommonCart	SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'
86	0.0001	ControllerCommonCart	SELECT * FROM banner WHERE header = '1' AND status = '1' AND customer_group = '0'

Query time (s)

Controller

Query

0.0001

SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://tumen.islzip.ru/'

0.0021

SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '18' ORDER BY store_id ASC

0.0002

SELECT * FROM `language` WHERE status = '1'

0.0001

SELECT * FROM currency

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2793') ORDER BY tr1.priority ASC

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2793') ORDER BY tr1.priority ASC

SELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '14'

SELECT * FROM length_class mc LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '14'

0.003

DELETE FROM cart WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 3 MONTH)

SELECT * FROM extension WHERE `type` = 'openbay'

0.0001

SELECT * FROM event

0.0001

SELECT f1.postalcode f1_postalcode, f1.offname f1_name, f1.level f1_level, f1.fias_id f1_fias_id, f1.shortname f1_shortname, CONCAT(f2.offname, ' ', f2.shortname) f2_name, f2.level f2_level, f2.fias_id f2_fias_id, CONCAT(f3.offname, ' ', f3.shortname) f3_name, f3.level f3_level, f3.fias_id f3_fias_id, CONCAT(f4.offname, ' ', f4.shortname) f4_name, f4.level f4_level, f4.fias_id f4_fias_id FROM fias f1 LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id WHERE f1.offname = 'Сиэтл' AND (f3.offname = 'США' OR f2.offname = 'США' OR f4.offname = 'США') AND (f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.'))

SELECT * FROM country c WHERE c.iso_code_2 = "US"

SELECT code FROM geoip_currency WHERE country_id = 223

SELECT * FROM geoip_rule

0.0001

ControllerCommonSeoPro

SELECT * FROM `mfilter_url_alias` WHERE `store_id` = 0

0.0001

ControllerCommonSeoPro

SELECT `value` FROM `setting` WHERE `key` = 'config_language'

0.0002

ControllerCommonSeoPro

SELECT * FROM language WHERE status = '1'

0.0001

ControllerProductCategory

SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '6' AND cd.language_id = '14' AND c.status = '1'

0.0001

ControllerProductCategory

0.0004

ControllerProductCategory

0.0005

ControllerProductCategory

SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '59' AND cd.language_id = '14' AND c.status = '1' ORDER BY c.sort_order, LCASE(CASE WHEN cd.menu_name <> '' THEN cd.menu_name ELSE cd.name END)

0.0005

ControllerProductCategory

SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW() AND cp.path_id = '59'

0.0009

ControllerProductCategory

SELECT p.product_id, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW() AND cp.path_id = '59' GROUP BY p.product_id ORDER BY p.quantity_18 DESC, LCASE(pd.name) ASC LIMIT 0,18

0.0009

ControllerProductCategory

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '2867' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()

0.0007

ControllerProductCategory

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '5100' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()

0.0007

ControllerProductCategory

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '4212' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()

0.0007

ControllerProductCategory

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '2866' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()

0.0007

ControllerProductCategory

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '6123' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()

0.0007

ControllerProductCategory

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '14') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '14') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '14') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '6217' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()

0.0003

ControllerProductCategory

SELECT category_id FROM product_to_category WHERE product_id = '2867' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerProductCategory

SELECT category_id FROM product_to_category WHERE product_id = '5100' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerProductCategory

SELECT category_id FROM product_to_category WHERE product_id = '4212' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerProductCategory

SELECT category_id FROM product_to_category WHERE product_id = '2866' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerProductCategory

SELECT category_id FROM product_to_category WHERE product_id = '6123' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerProductCategory

SELECT category_id FROM product_to_category WHERE product_id = '6217' ORDER BY main_category DESC LIMIT 1

0.0002

ControllerCommonColumnLeft

SELECT * FROM category_to_layout WHERE category_id = '59'

ControllerCommonColumnLeft

SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1

ControllerCommonColumnLeft

SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order

0.0001

ControllerModuleMegaFilter

SELECT * FROM `mfilter_settings` WHERE `idx` = 1

0.0001

ControllerModuleMegaFilter

SELECT * FROM `mfilter_settings` WHERE `idx` = 1

0.0006

ControllerModuleMegaFilter

SELECT `a`.`attribute_id`, REPLACE(REPLACE(TRIM(pa.text), ' ', ''), ' ', '') AS `txt`, `ad`.`name`, `ad`.`mf_tooltip` AS `tooltip`, `agd`.`name` AS `gname`, `agd`.`attribute_group_id` FROM `product` AS `p` INNER JOIN `product_to_store` AS `pts` ON `p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 18 INNER JOIN `product_attribute` AS `pa` ON `p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 14 INNER JOIN `attribute` AS `a` ON `a`.`attribute_id` = `pa`.`attribute_id` INNER JOIN `attribute_description` AS `ad` ON `ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 14 INNER JOIN `attribute_group` AS `ag` ON `ag`.`attribute_group_id` = `a`.`attribute_group_id` INNER JOIN `attribute_group_description` AS `agd` ON `agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 14 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(59) GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != '' ORDER BY `txt`

0.0003

ControllerModuleMegaFilter

SELECT `o`.`option_id`, `ov`.`option_value_id`, `od`.`name` AS `gname`, `od`.`mf_tooltip` AS `tooltip`, `ov`.`image`, `ovd`.`name`, LOWER(REPLACE(REPLACE(REPLACE(TRIM(`ovd`.`name`), ' ', ''), ' ', ''), ' ', '-')) AS `keyword` FROM `product` AS `p` INNER JOIN `product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 18 INNER JOIN `product_option_value` AS `pov` ON `p`.`product_id` = `pov`.`product_id` INNER JOIN `option_value` AS `ov` ON `ov`.`option_value_id` = `pov`.`option_value_id` INNER JOIN `option_value_description` AS `ovd` ON `ov`.`option_value_id` = `ovd`.`option_value_id` AND `ovd`.`language_id` = 14 INNER JOIN `option` AS `o` ON `o`.`option_id` = `pov`.`option_id` INNER JOIN `option_description` AS `od` ON `od`.`option_id` = `o`.`option_id` AND `od`.`language_id` = 14 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(59) AND `o`.`type` IN('radio','checkbox','select','image','image_radio') GROUP BY `o`.`option_id`, `ov`.`option_value_id` ORDER BY `ov`.`sort_order`, `ovd`.`name`

0.0002

ControllerModuleMegaFilter

SELECT `fgd`.`name` AS `gname`, `fgd`.`mf_tooltip` AS `tooltip`, `f`.`filter_group_id`, `f`.`filter_id`, `fd`.`name`, LOWER(REPLACE(REPLACE(REPLACE(TRIM(`fd`.`name`), ' ', ''), ' ', ''), ' ', '-')) AS `keyword` FROM `product` AS `p` INNER JOIN `product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 18 INNER JOIN `product_filter` AS `pf` ON `p`.`product_id` = `pf`.`product_id` INNER JOIN `filter` AS `f` ON `pf`.`filter_id` = `f`.`filter_id` INNER JOIN `filter_description` AS `fd` ON `pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 14 INNER JOIN `filter_group_description` AS `fgd` ON `f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 14 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(59) GROUP BY `f`.`filter_group_id`, `f`.`filter_id` ORDER BY `f`.`sort_order`, `fd`.`name`

0.0002

ControllerModuleMegaFilter

SELECT category_id FROM `category_path` WHERE `path_id` = 59

0.0004

ControllerModuleMegaFilter

SELECT `c`.`parent_id`, `c`.`category_id`,( SELECT `keyword` FROM `url_alias` AS `ua` WHERE `query` = CONCAT( 'category_id=', `c`.`category_id` ) LIMIT 1) AS `keyword`,`cd`.`name` FROM `category` AS `c` INNER JOIN `category_description` AS `cd` ON `cd`.`category_id` = `c`.`category_id` AND `cd`.`language_id` = '14' INNER JOIN `category_to_store` AS `c2s` ON `c`.`category_id` = `c2s`.`category_id` AND `c2s`.`store_id` = '18' WHERE `c`.`status` = '1' AND `c`.`parent_id` = 59 GROUP BY `c`.`category_id` ORDER BY `c`.`sort_order` ASC, `cd`.`name` ASC

0.0004

ControllerModuleMegaFilter

SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT `price_tmp` AS `price` FROM( SELECT IFNULL( ( SELECT `price` FROM `product_special` AS `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1 ), IFNULL( ( SELECT `price` FROM `product_discount` AS `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` >= '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1 ), `p`.`price` ) ) AS `price_tmp` FROM `product` AS `p` INNER JOIN `product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 14 INNER JOIN `product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 18 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(59) ) AS `tmp` ) AS `tmp`

0.0004

ControllerModuleMegaFilter

0.0001

ControllerModuleMegaFilter

SELECT * FROM url_alias WHERE `query` = 'category_id=6'

ControllerModuleMegaFilter

SELECT * FROM url_alias WHERE `query` = 'category_id=47'

0.0002

ControllerModuleMegaFilter

SELECT * FROM url_alias WHERE `query` = 'category_id=59'

0.0001

ControllerModuleMegaFilter

SELECT * FROM `mfilter_url_alias` WHERE `language_id` = 14 AND ( `path` = '' OR `path` = 'kupit/zapchasti-dlia-holodilnikov/nakladki-na-polki' OR `path` = 'ru-18/kupit/zapchasti-dlia-holodilnikov/nakladki-na-polki' )

0.0003

ControllerModuleMegaFilter

SELECT * FROM `url_alias` AS `ua` WHERE `query` IN('category_id=6','category_id=47','category_id=59')

ControllerModuleMegaFilter

SELECT * FROM module WHERE module_id = '1'

ControllerModuleMegaFilter

SELECT * FROM module WHERE module_id = '38'

0.0001

ControllerCommonColumnRight

SELECT * FROM category_to_layout WHERE category_id = '59'

ControllerCommonColumnRight

SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1

ControllerCommonColumnRight

SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order

ControllerCommonContentTop

SELECT * FROM category_to_layout WHERE category_id = '59'

ControllerCommonContentTop

SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1

ControllerCommonContentTop

SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order

ControllerCommonContentBottom

SELECT * FROM category_to_layout WHERE category_id = '59'

ControllerCommonContentBottom

SELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1

ControllerCommonContentBottom

SELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order

0.0002

ControllerCommonCart

SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'

0.0001

ControllerCommonCart

SELECT * FROM extension WHERE `type` = 'total'

0.0001

ControllerCommonCart

SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'

0.0001

ControllerCommonCart

SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'

0.0001

ControllerCommonCart

SELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'

0.0001

ControllerCommonCart

SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'

ControllerCommonCart

SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'

0.0001

ControllerCommonCart

SELECT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '14' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC

0.0001

ControllerCommonCart

SELECT * FROM `menu` m LEFT JOIN menu_description md ON (m.menu_id = md.menu_id) LEFT JOIN menu_to_store ms ON (m.menu_id = ms.menu_id) WHERE md.language_id = '14' AND m.status = 1 ORDER BY m.sort_order

ControllerCommonCart

SELECT * FROM `menu_child` mc LEFT JOIN menu_child_description mcd ON (mc.menu_child_id = mcd.menu_child_id) LEFT JOIN menu_child_to_store mcs ON (mc.menu_child_id = mcs.menu_child_id) WHERE mcd.language_id = '14' AND mc.status = 1 ORDER BY mc.sort_order

0.0001

ControllerModuleGeoip

SELECT * FROM extension WHERE `type` = 'module'

0.0001

ControllerModuleGeoip

SELECT * FROM geoip_city ORDER BY sort, name

0.0001

ControllerModuleGeoip

SELECT * FROM geoip_redirect

0.0001

ControllerBlogMenu

SELECT * FROM blog_category c LEFT JOIN blog_category_description cd ON (c.blog_category_id = cd.blog_category_id) LEFT JOIN blog_category_to_store c2s ON (c.blog_category_id = c2s.blog_category_id) WHERE cd.language_id = '14' AND c2s.store_id = '18' AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name

0.0001

ControllerCommonCart

SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'

ControllerCommonCart

SELECT * FROM extension WHERE `type` = 'total'

ControllerCommonCart

SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'

ControllerCommonCart

SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'

ControllerCommonCart

SELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'

ControllerCommonCart

SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'

ControllerCommonCart

SELECT * FROM cart WHERE customer_id = '0' AND session_id = 'fea7493efdbdda9e8459645b8517c0ac'

0.0001

ControllerCommonCart

SELECT * FROM banner WHERE header = '1' AND status = '1' AND customer_group = '0'