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

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

Наш Телефоны

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

+7(495)649-17-60

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

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

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

Ванны KALDEWEI

Kaldewei.

Компания применяет собственные технологии в производстве уникального натурального материала - металла, для своих стальных ванн и раковин. Заявленное название производителем - сталь-эмаль Калдевей. Материал обладает рядом преимуществ: устойчивость к царапинам, ударопрочность, отсутствие выцветания со временем, гигиеничность, экологичность и др.

Вся продукция выпускается в Германии, что исключает нарушение технологии производства и возможность купить подделку.

Производитель предоставляет гарантию, при соблюдении правил эксплуатации, 30 лет. Что, в свою очередь, говорит о безупречном качестве.

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

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

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

  • 11 марта 2016
    Margaroli

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

Все новости

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

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

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

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

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

Все отзывы
Читайте отзывы покупателей и оценивайте качество магазина на Яндекс.Маркете
time = 0,025589942932129
SQL_COUNT = 31
SQL_TIME = 0,010340929031372
SQL_LOG = 
memory:0,87665557861328
1 0,00015402 SET NAMES cp1251 [section]
2 0,00132298 SELECT id, name, parent, path, isUri, content, title, keywords, description FROM `as_catalog` WHERE isUri='vanny/vanny_kaldewei' AND visible='yes' [section]
<b>EXPLAIN</b> SELECT id, name, parent, path, isUri, content, title, keywords, description FROM `as_catalog` WHERE isUri='vanny/vanny_kaldewei' 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,00011086 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,00076699 SELECT SQL_CALC_FOUND_ROWS id, name, uri, img_med, price, notice, brand FROM `as_product` WHERE section = 1123 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 = 1123 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,00014901 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,00123 SELECT id, name, isUri, notice, image FROM `as_catalog` WHERE parent=1123 AND visible = 'yes' ORDER BY pos [section]
<b>EXPLAIN</b> SELECT id, name, isUri, notice, image FROM `as_catalog` WHERE parent=1123 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,00054789 SELECT brand FROM `as_product` WHERE section = 1123 AND visible='yes' [section]
<b>EXPLAIN</b> SELECT brand FROM `as_product` WHERE section = 1123 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,00024199 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,00033402 SELECT * FROM `as_catalog_param` WHERE section = 763 [section]
<b>EXPLAIN</b> SELECT * FROM `as_catalog_param` WHERE section = 763
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog_param
    [type] => ref
    [possible_keys] => section
    [key] => section
    [key_len] => 2
    [ref] => const
    [rows] => 4
    [Extra] => 
)

10 0,00044203 SELECT * FROM `as_catalog_values` WHERE filter IN('47', '48', '49', '50') ORDER BY pos [section]
<b>EXPLAIN</b> SELECT * FROM `as_catalog_values` WHERE filter IN('47', '48', '49', '50') 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,00023603 SELECT isUri FROM `as_catalog` WHERE id = 763 [section]
<b>EXPLAIN</b> SELECT isUri FROM `as_catalog` WHERE id = 763
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,00058079 SELECT id, name, isUri, isProduct FROM `as_catalog` WHERE id IN('763') ORDER BY `level` [section]
<b>EXPLAIN</b> SELECT id, name, isUri, isProduct FROM `as_catalog` WHERE id IN('763') 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,00051999 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 9,513E-5 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 9,298E-5 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 9,012E-5 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,00014806 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,00010085 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,00011492 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 9,799E-5 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,00097609 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[/section/vanny/vanny_kaldewei/]%' 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/vanny/vanny_kaldewei/]%' 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,00062799 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,00039887 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[/section/vanny/vanny_kaldewei/]%' LIMIT 0,2 [_right_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[/section/vanny/vanny_kaldewei/]%' 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 9,608E-5 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,00011301 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 9,894E-5 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,0001061 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,00010419 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,00011301 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 0,00023198 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 9,799E-5 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:0,9990234375
PHP_ERROR_LOG = 
8 Notice /home/kmline/kmline.ru/docs/_phtml/main/product/section.phtml => 4: Undefined variable: _post [section] => [section] uri=/section/vanny/vanny_kaldewei/