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

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

Наш Телефоны

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

+7(495)649-17-60

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

Сделай заказ и получи скидку!!!
Поиск по товарам
Подбор товара по параметрам

По заданным критериям товаров нет. Попробуйте другие комбинации.

  • Цвет
  • Тип
  • Страна изготовления
  • Производитель
  • Стиль
  • По установке

Смесители Bravat

Bravat

С 1873 года сантехника компании Bravat радует и восхищает клиентов высоким качеством продукции. Дизайн лаконичный, практичный и при этом надежный.
Немного истории Bravat — бренд сантехнической продукции для ванной и кухни, основан в Германии. В 1873 году, в Шварцвальде было создано небольшое производство.  Внимательный подход к нуждам потребителя, хорошее чувство вкуса, и, конечно же, высокие требования к качеству выпускаемой продукции привели небольшой завод к успеху. Компания стала вторым крупнейшим производителем смесителей в мире, а в 2000 году открыли свою производственную базу в Китае, где наладили выпуск продукции под собственной маркой, так и под брендами заказчиков.

Каталог
Новости магазина
  • 10 октября 2018
    РАСПРОДАЖА

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

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

  • 11 марта 2016
    Margaroli

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

Все новости

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

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

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

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

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

Все отзывы
Читайте отзывы покупателей и оценивайте качество магазина на Яндекс.Маркете
time = 0,026702880859375
SQL_COUNT = 31
SQL_TIME = 0,01004958152771
SQL_LOG = 
memory:0,876708984375
1 0,00016403 SET NAMES cp1251 [section]
2 0,00104904 SELECT id, name, parent, path, isUri, content, title, keywords, description FROM `as_catalog` WHERE isUri='smesiteli_dlja_vannoj/smesiteli_bravat' AND visible='yes' [section]
<b>EXPLAIN</b> SELECT id, name, parent, path, isUri, content, title, keywords, description FROM `as_catalog` WHERE isUri='smesiteli_dlja_vannoj/smesiteli_bravat' AND visible='yes'
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 1100
    [Extra] => Using where
)

3 0,00031304 SELECT * FROM `as_user_group_main` WHERE id = 0 [section]
<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
)

4 0,00208306 SELECT SQL_CALC_FOUND_ROWS id, name, uri, img_med, price, notice, brand FROM `as_product` WHERE section = 1136 AND visible='yes' ORDER BY pos LIMIT 0,100 [section]
<b>EXPLAIN</b> SELECT SQL_CALC_FOUND_ROWS id, name, uri, img_med, price, notice, brand FROM `as_product` WHERE section = 1136 AND visible='yes' ORDER BY pos LIMIT 0,100
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_product
    [type] => ref
    [possible_keys] => visible_isLeader,section,visibleNovelty
    [key] => section
    [key_len] => 2
    [ref] => const
    [rows] => 1
    [Extra] => Using where; Using filesort
)

5 0,000139 SELECT FOUND_ROWS() [section]
<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
)

6 0,00089192 SELECT id, name, isUri, notice, image FROM `as_catalog` WHERE parent=1136 AND visible = 'yes' ORDER BY pos [section]
<b>EXPLAIN</b> SELECT id, name, isUri, notice, image FROM `as_catalog` WHERE parent=1136 AND visible = 'yes' ORDER BY pos
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 1100
    [Extra] => Using where; Using filesort
)

7 0,00065613 SELECT brand FROM `as_product` WHERE section = 1136 AND visible='yes' [section]
<b>EXPLAIN</b> SELECT brand FROM `as_product` WHERE section = 1136 AND visible='yes'
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_product
    [type] => ref
    [possible_keys] => visible_isLeader,section,visibleNovelty
    [key] => section
    [key_len] => 2
    [ref] => const
    [rows] => 1
    [Extra] => Using where
)

8 0,00010204 SELECT id, name FROM `as_catalog_brand` WHERE id IN(-1)  [section]
<b>EXPLAIN</b> SELECT id, name FROM `as_catalog_brand` WHERE id IN(-1) 
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => 
    [type] => 
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 
    [Extra] => Impossible WHERE noticed after reading const tables
)

9 0,000108 SELECT * FROM `as_catalog_param` WHERE section = 10 [section]
<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] => 
)

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

11 0,00010705 SELECT isUri FROM `as_catalog` WHERE id = 10 [section]
<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] => 
)

12 0,00024605 SELECT id, name, isUri, isProduct FROM `as_catalog` WHERE id IN('10') ORDER BY `level` [section]
<b>EXPLAIN</b> SELECT id, name, isUri, isProduct FROM `as_catalog` WHERE id IN('10') ORDER BY `level`
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => const
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 4
    [ref] => const
    [rows] => 1
    [Extra] => 
)

13 0,00013304 SELECT `uri`, `title`, `keywords`, `description` FROM as_seo_title WHERE `uri` IN('default', 'section') [_header]
<b>EXPLAIN</b> SELECT `uri`, `title`, `keywords`, `description` FROM as_seo_title WHERE `uri` IN('default', 'section')
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
)

14 0,00014997 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
)

15 0,0001061 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
)

16 0,00010204 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
)

17 0,00020194 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
)

18 0,0001142 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
)

19 0,00013089 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
)

20 0,00011396 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] => 
)

21 0,00086713 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[/section/smesiteli_dlja_vannoj/smesiteli_bravat/]%' 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 '%[/section/smesiteli_dlja_vannoj/smesiteli_bravat/]%' 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
)

22 0,00064993 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
)

23 0,00028801 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[/section/smesiteli_dlja_vannoj/smesiteli_bravat/]%' LIMIT 0,2 [_right_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[/section/smesiteli_dlja_vannoj/smesiteli_bravat/]%' 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
)

24 0,000103 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
)

25 0,00012612 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
)

26 0,0001111 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] => 
)

27 0,00011086 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
)

28 0,00010109 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
)

29 0,00010204 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
)

30 9,68E-5 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
)

31 0,00010204 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,0089797973633
PHP_ERROR_LOG = 
8 Notice /home/kmline/kmline.ru/docs/_phtml/main/product/section.phtml => 4: Undefined variable: _post [section] => [section] uri=/section/smesiteli_dlja_vannoj/smesiteli_bravat/