Интернет магазин KMLINE:
Элитная сантехника, аксессуары
и мебель для ванной комнаты

Доставка по Москве бесплатно !!!

Наш Телефоны

 8-800-350-16-71 (бесп.)

+7(495)649-17-60

 Пн-Вс  10:00-20:00

Сделай заказ и получи скидку!!!
Поиск по товарам
Подбор товара по параметрам
  • Цвет
  • Тип
  • Страна изготовления
  • Производитель
  • Стиль
  • По установке
Распечатать
Душевая система Raindance Select Hansgrohe 27126000
  • По установке: Наружный
  • Производитель: Hansgrohe
  • Страна изготовления: Германия
  • Цвет: Хром
Характеристики продукта:
- верхний душ Raindance Select E 300 2jet
- размер душевого диска: 300 x 160 мм
- регулируемый угол верхнего душа
- тип струи: RainAir (дождевая струя, обогащенная воздухом), Rain
- удобное переключение типов струи с помощью кнопки Select
- расход воды для струи RainAir (при 3 бар): 16 л/мин
- расход воды для струи Rain (при 3 бар): 16 л/мин
- поверхность душевого диска в двух вариантах: хром или белый
- длина держателя для душа: 380 мм
- термостат ShowerTablet Select 300
- с широкой полочкой
- цвет поверхности полочки: хром или белый
- предохранительный ограничитель при 40°C
- регулируемый ограничитель температуры горячей воды
- пользовательское управление посредством кнопки Select
- вид монтажа: наружный монтаж
- для установки на соединительную резьбу G ½ необходимо использовать - комплект адаптеров 02026000
Состоит из
- Держатель Porter'S (# 28331000)
- Шланг Isiflex 1,60 м, ½’ (# 28276000)
- Ручной душ Raindance Select 120 Air 3jet, ½ (# 26520000)
Цена: 120020 руб.
Купить
Похожие товары
Каталог
Новости магазина
  • 10 октября 2018
    РАСПРОДАЖА

    Уважаемые посетители и покупатели!

    В нашем магазине до конца осени проходит акция "Лучшая цена." Сообщите нам что вас заинтересовало и мы предложим вам самую низкую цену в Москве на выбранный вами товар. Связаться с менеджерами можно по телефонам: 8-800-350-16-71  +7(495)649-17-60 

  • 11 марта 2016
    Margaroli

    В нашем магазине в продаже появились итальянские полотенцесушители  производства фирмы Margaroli

Все новости

Отзывы наших клиентов

Петр, Москва
Мне все понравилось, спасибо большое!

Иван, Москва
Быстрая доставка! Здорово!

Мария, Москва
Такой большой ассортимент!
Заказали все в одном стиле!

Петр, Москва
Мне все понравилось, спасибо большое!

Все отзывы
Читайте отзывы покупателей и оценивайте качество магазина на Яндекс.Маркете
time = 0,15369296073914
SQL_COUNT = 33
SQL_TIME = 0,12202000617981
SQL_LOG = 
memory:0,87664794921875
1 0,00011611 SET NAMES cp1251 [product]
2 0,10033011 SELECT * FROM `as_product` WHERE uri='27126000' AND visible='yes' [product]
<b>EXPLAIN</b> SELECT * FROM `as_product` WHERE uri='27126000' AND visible='yes'
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_product
    [type] => ref
    [possible_keys] => visible_isLeader,visibleNovelty
    [key] => visible_isLeader
    [key_len] => 1
    [ref] => const
    [rows] => 8402
    [Extra] => Using index condition; Using where
)

3 0,00555396 SELECT id, name, img, img_main, img_med, img_small FROM `as_product_image` WHERE product='9634' LIMIT 0,10 [product]
<b>EXPLAIN</b> SELECT id, name, img, img_main, img_med, img_small FROM `as_product_image` WHERE product='9634' LIMIT 0,10
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_product_image
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 9954
    [Extra] => Using where
)

4 0,0001049 SELECT * FROM `as_user_group_main` WHERE id = 0 [product]
<b>EXPLAIN</b> SELECT * FROM `as_user_group_main` WHERE id = 0
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => 
    [type] => 
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 
    [Extra] => Impossible WHERE noticed after reading const tables
)

5 0,0004499 SELECT isUri FROM `as_catalog` WHERE id=791 [product]
<b>EXPLAIN</b> SELECT isUri FROM `as_catalog` WHERE id=791
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => const
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 4
    [ref] => const
    [rows] => 1
    [Extra] => 
)

6 0,00272799 
	SELECT `sp`.id as p_id, `sp`.name as p_name, `sv`.id as v_id, `sv`.name as v_name
	FROM `as_product_value` as `pv`
	LEFT JOIN `as_catalog_param` as `sp` ON `sp`.id = `pv`.filter
	LEFT JOIN `as_catalog_values` as `sv` ON `pv`.value = `sv`.id
	WHERE `pv`.product = '9634' [product]
7 0,00544596 SELECT * FROM `as_product` WHERE section = 791 AND id <> 9634 ORDER BY RAND() [product]
<b>EXPLAIN</b> SELECT * FROM `as_product` WHERE section = 791 AND id <> 9634 ORDER BY RAND()
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_product
    [type] => ref
    [possible_keys] => PRIMARY,section
    [key] => section
    [key_len] => 2
    [ref] => const
    [rows] => 35
    [Extra] => Using where; Using temporary; Using filesort
)

8 0,00035095 SELECT SQL_CALC_FOUND_ROWS * FROM `as_opinion` WHERE status = 'pub' AND product = 9634 LIMIT 0,2 [product]
<b>EXPLAIN</b> SELECT SQL_CALC_FOUND_ROWS * FROM `as_opinion` WHERE status = 'pub' AND product = 9634 LIMIT 0,2
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_opinion
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 8
    [Extra] => Using where
)

9 0,00018001 SELECT FOUND_ROWS() [product]
<b>EXPLAIN</b> SELECT FOUND_ROWS()
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => 
    [type] => 
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 
    [Extra] => No tables used
)

10 0,00047803 SELECT id,name, path, isUri FROM `as_catalog` WHERE id = '791' [product]
<b>EXPLAIN</b> SELECT id,name, path, isUri FROM `as_catalog` WHERE id = '791'
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => const
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 4
    [ref] => const
    [rows] => 1
    [Extra] => 
)

11 0,00015593 SELECT id, name, isUri, isProduct FROM `as_catalog` WHERE id IN('10', '772') ORDER BY `level` [product]
<b>EXPLAIN</b> SELECT id, name, isUri, isProduct FROM `as_catalog` WHERE id IN('10', '772') ORDER BY `level`
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => range
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 4
    [ref] => 
    [rows] => 2
    [Extra] => Using index condition; Using filesort
)

12 0,00016093 SELECT * FROM `as_catalog_param` WHERE section = 10 [product]
<b>EXPLAIN</b> SELECT * FROM `as_catalog_param` WHERE section = 10
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog_param
    [type] => ref
    [possible_keys] => section
    [key] => section
    [key_len] => 2
    [ref] => const
    [rows] => 6
    [Extra] => 
)

13 0,00018501 SELECT * FROM `as_catalog_values` WHERE filter IN('3', '10', '11', '12', '13', '14') [product]
<b>EXPLAIN</b> SELECT * FROM `as_catalog_values` WHERE filter IN('3', '10', '11', '12', '13', '14')
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog_values
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 255
    [Extra] => Using where
)

14 0,00015712 SELECT isUri FROM `as_catalog` WHERE id = 10 [product]
<b>EXPLAIN</b> SELECT isUri FROM `as_catalog` WHERE id = 10
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => const
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 4
    [ref] => const
    [rows] => 1
    [Extra] => 
)

15 0,00016809 SELECT `uri`, `title`, `keywords`, `description` FROM as_seo_title WHERE `uri` IN('default', 'product') [_header]
<b>EXPLAIN</b> SELECT `uri`, `title`, `keywords`, `description` FROM as_seo_title WHERE `uri` IN('default', 'product')
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_seo_title
    [type] => range
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 102
    [ref] => 
    [rows] => 2
    [Extra] => Using index condition
)

16 0,00016117 SELECT * FROM `as_static` WHERE name = "Шапка: контакты" LIMIT 0,1 [_header]
<b>EXPLAIN</b> SELECT * FROM `as_static` WHERE name = "Шапка: контакты" LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_static
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 5
    [Extra] => Using where
)

17 0,00015903 SELECT email FROM `as_mail_list` WHERE header = 'yes' LIMIT 0,1 [_header]
<b>EXPLAIN</b> SELECT email FROM `as_mail_list` WHERE header = 'yes' LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_mail_list
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 6
    [Extra] => Using where
)

18 0,00014806 SELECT name, uri FROM `as_menu1` ORDER BY pos [_header]
<b>EXPLAIN</b> SELECT name, uri FROM `as_menu1` ORDER BY pos
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_menu1
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 7
    [Extra] => Using filesort
)

19 0,00018597 SELECT id, name, isUri, parent FROM `as_catalog` WHERE isVisible='yes' AND level < 2 ORDER BY `parent` ASC , `pos` ASC [_letf_menu]
<b>EXPLAIN</b> SELECT id, name, isUri, parent FROM `as_catalog` WHERE isVisible='yes' AND level < 2 ORDER BY `parent` ASC , `pos` ASC
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => ref
    [possible_keys] => isMenu_isVisible_pos,isVisible
    [key] => isVisible
    [key_len] => 1
    [ref] => const
    [rows] => 840
    [Extra] => Using index condition; Using where; Using filesort
)

20 0,00016689 SELECT id, header, notice, date FROM `as_news` WHERE visible='yes' ORDER BY date DESC LIMIT 0,2 [_letf_menu]
<b>EXPLAIN</b> SELECT id, header, notice, date FROM `as_news` WHERE visible='yes' ORDER BY date DESC LIMIT 0,2
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_news
    [type] => ref
    [possible_keys] => visible_date
    [key] => visible_date
    [key_len] => 1
    [ref] => const
    [rows] => 2
    [Extra] => Using where
)

21 0,0001781 SELECT * FROM `as_biblio` WHERE visible = 'yes' ORDER BY pos [_letf_menu]
<b>EXPLAIN</b> SELECT * FROM `as_biblio` WHERE visible = 'yes' ORDER BY pos
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_biblio
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 4
    [Extra] => Using where; Using filesort
)

22 0,00014591 SELECT * FROM `as_menu_catalog` WHERE id='93' [_letf_menu]
<b>EXPLAIN</b> SELECT * FROM `as_menu_catalog` WHERE id='93'
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_menu_catalog
    [type] => const
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 1
    [ref] => const
    [rows] => 1
    [Extra] => 
)

23 0,0013721 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[/product/27126000/]%' ORDER BY RAND() LIMIT 0,1 [_letf_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[/product/27126000/]%' ORDER BY RAND() LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_seo_reklama
    [type] => ref
    [possible_keys] => vis_type
    [key] => vis_type
    [key_len] => 2
    [ref] => const,const
    [rows] => 2
    [Extra] => Using index condition; Using where; Using temporary; Using filesort
)

24 0,00117302 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[all]%' ORDER BY RAND() LIMIT 0,1 [_letf_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[all]%' ORDER BY RAND() LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_seo_reklama
    [type] => ref
    [possible_keys] => vis_type
    [key] => vis_type
    [key_len] => 2
    [ref] => const,const
    [rows] => 2
    [Extra] => Using index condition; Using where; Using temporary; Using filesort
)

25 0,0005579 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[/product/27126000/]%' LIMIT 0,2 [_right_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[/product/27126000/]%' LIMIT 0,2
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_seo_reklama
    [type] => ref
    [possible_keys] => vis_type
    [key] => vis_type
    [key_len] => 2
    [ref] => const,const
    [rows] => 1
    [Extra] => Using index condition; Using where
)

26 0,000144 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[all]%' ORDER BY pos LIMIT 0,2 [_right_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[all]%' ORDER BY pos LIMIT 0,2
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_seo_reklama
    [type] => ref
    [possible_keys] => vis_type
    [key] => vis_type
    [key_len] => 2
    [ref] => const,const
    [rows] => 1
    [Extra] => Using index condition; Using where; Using filesort
)

27 0,000175 SELECT id, name, uri FROM `as_catalog_brand` WHERE visible = "yes" [_right_menu]
<b>EXPLAIN</b> SELECT id, name, uri FROM `as_catalog_brand` WHERE visible = "yes"
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog_brand
    [type] => ref
    [possible_keys] => visible
    [key] => visible
    [key_len] => 1
    [ref] => const
    [rows] => 59
    [Extra] => Using index condition
)

28 0,00015497 SELECT id, header, uri, date, notice, img_small FROM `as_article` WHERE visible='yes' ORDER BY date DESC LIMIT 0,1 [_right_menu]
<b>EXPLAIN</b> SELECT id, header, uri, date, notice, img_small FROM `as_article` WHERE visible='yes' ORDER BY date DESC LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_article
    [type] => system
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 1
    [Extra] => 
)

29 0,00015807 SELECT id, name FROM `as_opros` WHERE visible='yes' LIMIT 0,1 [_right_menu]
<b>EXPLAIN</b> SELECT id, name FROM `as_opros` WHERE visible='yes' LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => 
    [type] => 
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 
    [Extra] => Impossible WHERE noticed after reading const tables
)

30 0,00015283 SELECT * FROM `as_opros_quest` WHERE category = 0 ORDER BY pos [_right_menu]
<b>EXPLAIN</b> SELECT * FROM `as_opros_quest` WHERE category = 0 ORDER BY pos
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_opros_quest
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 4
    [Extra] => Using where; Using filesort
)

31 0,00014997 SELECT content FROM `as_static` WHERE name = "Подвал: блок слева" AND visible = 'yes' LIMIT 0,1 [_footer]
<b>EXPLAIN</b> SELECT content FROM `as_static` WHERE name = "Подвал: блок слева" AND visible = 'yes' LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_static
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 5
    [Extra] => Using where
)

32 0,00012994 SELECT content FROM `as_static` WHERE name = "Подвал: copyright" AND visible = 'yes' LIMIT 0,1 [_footer]
<b>EXPLAIN</b> SELECT content FROM `as_static` WHERE name = "Подвал: copyright" AND visible = 'yes' LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_static
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 5
    [Extra] => Using where
)

33 0,0001421 SELECT content FROM `as_static` WHERE name = "Подвал: центральный блок" AND visible = 'yes' LIMIT 0,1 [_footer]
<b>EXPLAIN</b> SELECT content FROM `as_static` WHERE name = "Подвал: центральный блок" AND visible = 'yes' LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_static
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 5
    [Extra] => Using where
)

memory:1,0691299438477
PHP_ERROR_LOG = 
8 Notice /home/kmline/kmline.ru/docs/_phtml/main/product/product.phtml => 18: Undefined variable: this_url [product] => [product] uri=/product/27126000/