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

    Ручка селектора



    Ручка выбора програм для стиральной машины Ariston. 270192
    Ручка выбора программ стиральных машин Indesit (Индезит), Ariston (Аристон), Whirlpool (Вирпул) C00310970, 481241458306
    Ручка выбора температуры стиральных машин Indesit, Ariston 064512
    Ручка дисплея, селектор стиральных машин Indesit/Ariston/Hotpoint 292884, зам. 288240, 273045, 272632
    Ручка селектора Ariston C00119385
    Ручка селектора программ стиральных машин Ariston 267555
    Ручка селектора стиральной машины Bosch, Siemens 602804
    Суппорт ручки таймера Electrolux 1247420001
    Показано с 1 по 8 из 8 (всего 1 страниц)
    

    Total time: 0.0561 s | Queries: 82 | Slow queries (>0.003 s): 0

    #Query time (s)ControllerQuery
    10.0001 SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://tumen.islzip.ru/'
    20.0019 SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '18' ORDER BY store_id ASC
    30.0003 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.003 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.0008 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.0004 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.0001 ControllerCommonSeoProSELECT `value` FROM `setting` WHERE `key` = 'config_language'
    180.0002 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 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 = '17' 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 = '211' 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 = '211' 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.0007 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 = '211'
    240.0009 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 = '211' GROUP BY p.product_id ORDER BY p.quantity_18 DESC, LCASE(pd.name) ASC LIMIT 0,18
    250.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 = '6359' 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 = '4279' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    270.0006 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 = '5290' 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 = '3698' 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 = '2966' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    300.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 = '2965' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    310.0006 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 = '6135' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    320.0006 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 = '3017' AND pd.language_id = '14' AND p.status = '1' AND p.date_available <= NOW()
    330.0002 ControllerCommonColumnLeftSELECT * FROM category_to_layout WHERE category_id = '211'
    340 ControllerCommonColumnLeftSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
    350 ControllerCommonColumnLeftSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
    360.0001 ControllerModuleMegaFilterSELECT * FROM `mfilter_settings` WHERE `idx` = 1
    370.0001 ControllerModuleMegaFilterSELECT * FROM `mfilter_settings` WHERE `idx` = 1
    380.0005 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(211) GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != '' ORDER BY `txt`
    390.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(211) 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`
    400.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(211) GROUP BY `f`.`filter_group_id`, `f`.`filter_id` ORDER BY `f`.`sort_order`, `fd`.`name`
    410.0001 ControllerModuleMegaFilterSELECT category_id FROM `category_path` WHERE `path_id` = 211
    420.0005 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` = 211 GROUP BY `c`.`category_id` ORDER BY `c`.`sort_order` ASC, `cd`.`name` ASC
    430.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(211) ) AS `tmp` ) AS `tmp`
    440.0003 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(211) ) AS `tmp` ) AS `tmp`
    450 ControllerModuleMegaFilterSELECT * FROM url_alias WHERE `query` = 'category_id=6'
    460 ControllerModuleMegaFilterSELECT * FROM url_alias WHERE `query` = 'category_id=17'
    470.0003 ControllerModuleMegaFilterSELECT * FROM url_alias WHERE `query` = 'category_id=211'
    480.0001 ControllerModuleMegaFilter SELECT * FROM `mfilter_url_alias` WHERE `language_id` = 14 AND ( `path` = '' OR `path` = 'kupit/zapchasti-dlia-stiralnih-mashin/ruchka-selektora' OR `path` = 'ru-18/kupit/zapchasti-dlia-stiralnih-mashin/ruchka-selektora' )
    490.0003 ControllerModuleMegaFilterSELECT * FROM `url_alias` AS `ua` WHERE `query` IN('category_id=6','category_id=17','category_id=211')
    500.0001 ControllerModuleMegaFilterSELECT * FROM module WHERE module_id = '1'
    510 ControllerModuleMegaFilterSELECT * FROM module WHERE module_id = '38'
    520 ControllerCommonColumnRightSELECT * FROM category_to_layout WHERE category_id = '211'
    530 ControllerCommonColumnRightSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
    540 ControllerCommonColumnRightSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
    550 ControllerCommonContentTopSELECT * FROM category_to_layout WHERE category_id = '211'
    560 ControllerCommonContentTopSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
    570 ControllerCommonContentTopSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
    580 ControllerCommonContentBottomSELECT * FROM category_to_layout WHERE category_id = '211'
    590.0001 ControllerCommonContentBottomSELECT * FROM layout_route WHERE 'product/category' LIKE route AND store_id = '18' ORDER BY route DESC LIMIT 1
    600.0004 ControllerCommonContentBottomSELECT * FROM layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
    610.0002 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = '2c28f13c97db4fa02c33556307b54e77'
    620 ControllerCommonCartSELECT * FROM extension WHERE `type` = 'total'
    630 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = '2c28f13c97db4fa02c33556307b54e77'
    640 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = '2c28f13c97db4fa02c33556307b54e77'
    650 ControllerCommonCartSELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'
    660 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = '2c28f13c97db4fa02c33556307b54e77'
    670 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = '2c28f13c97db4fa02c33556307b54e77'
    680.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
    690 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
    700 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
    710.0001 ControllerModuleGeoipSELECT * FROM extension WHERE `type` = 'module'
    720.0001 ControllerModuleGeoipSELECT * FROM geoip_city ORDER BY sort, name
    730.0001 ControllerModuleGeoipSELECT * FROM geoip_redirect
    740.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
    750.0001 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = '2c28f13c97db4fa02c33556307b54e77'
    760 ControllerCommonCartSELECT * FROM extension WHERE `type` = 'total'
    770 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = '2c28f13c97db4fa02c33556307b54e77'
    780 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = '2c28f13c97db4fa02c33556307b54e77'
    790 ControllerCommonCartSELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'
    800 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = '2c28f13c97db4fa02c33556307b54e77'
    810 ControllerCommonCartSELECT * FROM cart WHERE customer_id = '0' AND session_id = '2c28f13c97db4fa02c33556307b54e77'
    820.0001 ControllerCommonCartSELECT * FROM banner WHERE header = '1' AND status = '1' AND customer_group = '0'