Написать руководителю
Информация
Вход для партнеров
  • Вход
    • доставка по РФ и Казахстан
    Тюмень, ул. Республики, 83, офис №103:8 (345) 256 84 72
    Заказать звонок
    Запчасти для:

    Крепление стекла духовки



    Верхнее левое крепление стекла духовки Hansa (Ханса) 8028449
    Держатель стекла двери духовки, правый, Hansa (Ханса) 8028450
    Крепление стекла духовки Hansa (Ханса) левое верхнее 8026850
    Крепление стекла духовки Hansa (Ханса) левое нижнее 8051132
    Крепление стекла духовки Hansa (Ханса) правое верхнее 8026851
    Крепление стекла духовки Hansa (Ханса) правое нижнее 8051131
    Показано с 1 по 6 из 6 (всего 1 страниц)
    

    Total time: 0.0623 s | Queries: 80 | Slow queries (>0.003 s): 1

    #Query time (s)ControllerQuery
    10.0001 SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://tumen.islzip.ru/'
    20.002 SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '18' ORDER BY store_id ASC
    30.0002 SELECT * FROM `language` WHERE status = '1'
    40.0001 SELECT * FROM currency
    50 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
    60 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
    70 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'
    80 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'
    90.0031 DELETE FROM cart WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 3 MONTH)
    100 SELECT * FROM extension WHERE `type` = 'openbay'
    110.0001 SELECT * FROM event
    120.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 = 'г.'))
    130 SELECT * FROM country c WHERE c.iso_code_2 = "US"
    140 SELECT code FROM geoip_currency WHERE country_id = 223
    150 SELECT * FROM geoip_rule
    160.0001 ControllerCommonSeoProSELECT * FROM `mfilter_url_alias` WHERE `store_id` = 0
    170.0002 ControllerCommonSeoProSELECT `value` FROM `setting` WHERE `key` = 'config_language'
    180.0004 ControllerCommonSeoProSELECT * FROM language WHERE status = '1'
    190.0001 ControllerProductCategorySELECT 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'
    200.0004 ControllerProductCategorySELECT 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 = '63' AND cd.language_id = '14' AND c.status = '1'
    210.0004 ControllerProductCategorySELECT 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 = '207' AND cd.language_id = '14' AND c.status = '1'
    220.0004 ControllerProductCategorySELECT * 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 = '207' 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)
    230.0008 ControllerProductCategorySELECT 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 = '207'
    240.0008 ControllerProductCategorySELECT 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 = '207' GROUP BY p.product_id ORDER BY p.quantity_18 DESC, LCASE(pd.name) ASC LIMIT 0,18
    250.0009 ControllerProductCategorySELECT 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 = '4682' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    260.0007 ControllerProductCategorySELECT 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 = '4395' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    270.0007 ControllerProductCategorySELECT 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 = '4317' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    280.0007 ControllerProductCategorySELECT 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 = '4316' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    290.0007 ControllerProductCategorySELECT 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 = '4314' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    300.0008 ControllerProductCategorySELECT 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 = '4315' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    310.0003 ControllerCommonColumnLeftSELECT * FROM category_to_layout WHERE category_id = '207'
    320.0003 ControllerCommonColumnLeftSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
    330 ControllerCommonColumnLeftSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
    340.0001 ControllerModuleMegaFilterSELECT * FROM `mfilter_settings` WHERE `idx` = 1
    350.0001 ControllerModuleMegaFilterSELECT * FROM `mfilter_settings` WHERE `idx` = 1
    360.0008 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(207) GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != '' ORDER BY `txt`
    370.0004 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(207) 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`
    380.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(207) GROUP BY `f`.`filter_group_id`, `f`.`filter_id` ORDER BY `f`.`sort_order`, `fd`.`name`
    390.0001 ControllerModuleMegaFilterSELECT category_id FROM `category_path` WHERE `path_id` = 207
    400.0003 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` = 207 GROUP BY `c`.`category_id` ORDER BY `c`.`sort_order` ASC, `cd`.`name` ASC
    410.0004 ControllerModuleMegaFilterSELECT 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(207) ) AS `tmp` ) AS `tmp`
    420.0004 ControllerModuleMegaFilterSELECT 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(207) ) AS `tmp` ) AS `tmp`
    430.0001 ControllerModuleMegaFilterSELECT * FROM url_alias WHERE `query` = 'category_id=6'
    440.0003 ControllerModuleMegaFilterSELECT * FROM url_alias WHERE `query` = 'category_id=63'
    450.0002 ControllerModuleMegaFilterSELECT * FROM url_alias WHERE `query` = 'category_id=207'
    460.0001 ControllerModuleMegaFilter SELECT * FROM `mfilter_url_alias` WHERE `language_id` = 14 AND ( `path` = '' OR `path` = 'kupit/zapchasti-dlia-elektroplit/kreplenie-stekla-duhovki' OR `path` = 'ru-18/kupit/zapchasti-dlia-elektroplit/kreplenie-stekla-duhovki' )
    470.0004 ControllerModuleMegaFilterSELECT * FROM `url_alias` AS `ua` WHERE `query` IN('category_id=6','category_id=63','category_id=207')
    480.0001 ControllerModuleMegaFilterSELECT * FROM module WHERE module_id = '1'
    490 ControllerModuleMegaFilterSELECT * FROM module WHERE module_id = '38'
    500 ControllerCommonColumnRightSELECT * FROM category_to_layout WHERE category_id = '207'
    510 ControllerCommonColumnRightSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
    520 ControllerCommonColumnRightSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
    530 ControllerCommonContentTopSELECT * FROM category_to_layout WHERE category_id = '207'
    540 ControllerCommonContentTopSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
    550 ControllerCommonContentTopSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
    560 ControllerCommonContentBottomSELECT * FROM category_to_layout WHERE category_id = '207'
    570 ControllerCommonContentBottomSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
    580 ControllerCommonContentBottomSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
    590.0002 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = 'e14c9eb4d3b18479dc6ab7dbb10da095'
    600.0002 ControllerCommonCartSELECT * FROM extension WHERE `type` = 'total'
    610 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = 'e14c9eb4d3b18479dc6ab7dbb10da095'
    620 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = 'e14c9eb4d3b18479dc6ab7dbb10da095'
    630.0001 ControllerCommonCartSELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'
    640 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = 'e14c9eb4d3b18479dc6ab7dbb10da095'
    650 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = 'e14c9eb4d3b18479dc6ab7dbb10da095'
    660.0001 ControllerCommonCartSELECT * 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
    670 ControllerCommonCartSELECT * 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
    680 ControllerCommonCartSELECT * 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
    690.0001 ControllerModuleGeoipSELECT * FROM extension WHERE `type` = 'module'
    700.0001 ControllerModuleGeoipSELECT * FROM geoip_city ORDER BY sort, name
    710.0001 ControllerModuleGeoipSELECT * FROM geoip_redirect
    720.0001 ControllerBlogMenuSELECT * 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
    730.0003 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = 'e14c9eb4d3b18479dc6ab7dbb10da095'
    740 ControllerCommonCartSELECT * FROM extension WHERE `type` = 'total'
    750 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = 'e14c9eb4d3b18479dc6ab7dbb10da095'
    760 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = 'e14c9eb4d3b18479dc6ab7dbb10da095'
    770 ControllerCommonCartSELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'
    780 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = 'e14c9eb4d3b18479dc6ab7dbb10da095'
    790 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = 'e14c9eb4d3b18479dc6ab7dbb10da095'
    800.0001 ControllerCommonCartSELECT * FROM banner WHERE header = '1' AND status = '1' AND customer_group = '0'