Bossini

Сортировать по:

Фильтр

Душевой набор Bossini D99001

Душевой набор Bossini D99001

Артикул: D99001

0 грн

3 621 грн

Шланговое подключение Bossini V00015

Шланговое подключение Bossini V00015

Артикул: V00015

0 грн

383 грн

Шланговое подключение Bossini Bos V000140022031

Шланговое подключение Bossini Bos V000140022031

Артикул: V000140022031

0 грн

801 грн

Шланговое подключение Bossini V00014

Шланговое подключение Bossini V00014

Артикул: V00014

0 грн

459 грн

Шланговое подключение Bossini Bos V00014000021031

Шланговое подключение Bossini Bos V00014000021031

Артикул: V00014000021031

0 грн

965 грн

Шланговое подключение Bossini C21000

Шланговое подключение Bossini C21000

Артикул: C21000

0 грн

385 грн

Шланг для душа 150 см Bossini A00131C113004

Шланг для душа 150 см Bossini A00131C113004

Артикул: A00131C113004

0 грн

215 грн

Шланг для душа 150 см Bossini Bos Bi-Flex A00521C102019

Шланг для душа 150 см Bossini Bos Bi-Flex A00521C102019

Артикул: A00521C102019

0 грн

253 грн

Шланг для душа 150 см Bossini A00048C0130004

Шланг для душа 150 см Bossini A00048C0130004

Артикул: A00048C0130004

0 грн

785 грн

Шланг для душа 150 см Bossini A00048C00030004

Шланг для душа 150 см Bossini A00048C00030004

Артикул: A00048C00030004

0 грн

522 грн

Шланг для душа 175 см Bossini Bos A00100D119004

Шланг для душа 175 см Bossini Bos A00100D119004

Артикул: A00100D119004

0 грн

395 грн

Шланг для душа 150 см Bossini A00048

Шланг для душа 150 см Bossini A00048

Артикул: A00048

0 грн

822 грн

Шланг для душа 150 см Bossini Doppia Aggraffatura A00053E00030004

Шланг для душа 150 см Bossini Doppia Aggraffatura A00053E00030004

Артикул: A00053E00030004

0 грн

855 грн

Быстрый заказ

Шланг для душа 175 см Bossini Bos Cromolux A00167D030004

Шланг для душа 175 см Bossini Bos Cromolux A00167D030004

Артикул: A00167D030004

0 грн

661 грн

Шланг для душа 150 см Bossini Bos A00150C142004

Шланг для душа 150 см Bossini Bos A00150C142004

Артикул: A00150C142004

0 грн

446 грн

Шланг для душа 150 см Bossini A00048 DO

Шланг для душа 150 см Bossini A00048 DO

Артикул: A00048 DO

0 грн

1 366 грн

Шланг для душа 150 см Bossini A00066

Шланг для душа 150 см Bossini A00066

Артикул: A00066

0 грн

1 101 грн

Душевая штанга Bossini D98001

Душевая штанга Bossini D98001

Артикул: D98001

0 грн

10 893 грн

Стойка для вернего душа Bossini L00100000030001

Стойка для вернего душа Bossini L00100000030001

Артикул: L00100000030001

0 грн

490 грн

Душевая штанга Bossini D87000A

Душевая штанга Bossini D87000A

Артикул: D87000A

0 грн

1 096 грн

Душевая штанга Bossini D43000A

Душевая штанга Bossini D43000A

Артикул: D43000A

0 грн

3 236 грн

Душевая штанга Bossini D96000C

Душевая штанга Bossini D96000C

Артикул: D96000C

0 грн

2 563 грн

Душевая штанга Bossini D29000F

Душевая штанга Bossini D29000F

Артикул: D29000F

0 грн

1 083 грн

Душевая штанга Bossini D89000A

Душевая штанга Bossini D89000A

Артикул: D89000A

0 грн

1 641 грн

100% гарантия качества

100% гарантия качества

14 дней на возврат товара

14 дней на возврат товара

Доставка по всей стране

Доставка по всей стране

Самовывоз из магазина

Самовывоз из магазина

1) 0.00032901763916016: perform SET NAMES 'utf8mb4' ------------------------------------------------------------------------------------------------------------------------------------------------------ 2) 0.00024199485778809: perform SET SESSION SQL_MODE = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" ------------------------------------------------------------------------------------------------------------------------------------------------------ 3) 0.00031590461730957: perform SELECT * FROM `ok_languages` ORDER BY position ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 4) 0.00032806396484375: perform SELECT id, vendor, module_name, enabled FROM `ok_modules` ORDER BY position ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 5) 0.0003659725189209: perform SELECT param, value FROM `ok_settings` ------------------------------------------------------------------------------------------------------------------------------------------------------ 6) 0.00023484230041504: perform SELECT id FROM `ok_languages` WHERE id=0 LIMIT 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ 7) 0.00028300285339355: perform SELECT * FROM `ok_settings_lang` WHERE lang_id=:action_object_lang_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 8) 0.00038504600524902: perform SELECT `c`.`id`, `c`.`parent_id`, `c`.`url`, `c`.`image`, `c`.`position`, `c`.`visible`, `c`.`external_id`, `c`.`level_depth`, `c`.`last_modify`, `c`.`created`, `r`.`slug_url`, `l`.`name`, `l`.`name_h1`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`annotation`, `l`.`description` FROM `ok_blog_categories` AS `c` LEFT JOIN `ok_lang_blog_categories` AS `l` ON `l`.`category_id` = `c`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`c`.`url` AND `r`.`type`="category" ORDER BY `c`.`parent_id`, `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 9) 0.00027203559875488: perform SELECT category_id FROM `ok_blog_categories_relation` GROUP BY category_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 10) 0.00057005882263184: perform SELECT id, parent_id, url FROM `ok_blog_categories` WHERE url IN(:urls) ------------------------------------------------------------------------------------------------------------------------------------------------------ 11) 0.00023198127746582: perform SELECT DISTINCT SQL_CACHE `le`.`id`, `le`.`label`, `le`.`href_lang`, `le`.`enabled`, `le`.`position`, `l`.`name` FROM `ok_languages` AS `le` LEFT JOIN `ok_lang_languages` AS `l` ON `l`.`language_id` = `le`.`id` AND `l`.`lang_id` = 1 ORDER BY `le`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 12) 0.00026106834411621: perform SELECT DISTINCT SQL_CACHE `m`.`vendor`, `m`.`module_name` FROM `ok_modules` AS `m` ORDER BY `m`.`position` DESC ------------------------------------------------------------------------------------------------------------------------------------------------------ 13) 0.00058794021606445: perform SELECT `p`.`id`, `p`.`url`, `p`.`visible`, `p`.`position`, `p`.`last_modify`, `l`.`name`, `l`.`name_h1`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`description` FROM `ok_pages` AS `p` LEFT JOIN `ok_lang_pages` AS `l` ON `l`.`page_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`url` = :magic_filter_url ORDER BY `p`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 14) 0.00032806396484375: perform SELECT DISTINCT SQL_CACHE `c`.`id`, `c`.`code`, `c`.`rate_from`, `c`.`rate_to`, `c`.`cents`, `c`.`position`, `c`.`enabled`, `l`.`name`, `l`.`sign` FROM `ok_currencies` AS `c` LEFT JOIN `ok_lang_currencies` AS `l` ON `l`.`currency_id` = `c`.`id` AND `l`.`lang_id` = 1 ORDER BY `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 15) 0.00033712387084961: perform SELECT `p`.`id`, `p`.`url`, `p`.`visible`, `p`.`position`, `p`.`last_modify`, `l`.`name`, `l`.`name_h1`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`description` FROM `ok_pages` AS `p` LEFT JOIN `ok_lang_pages` AS `l` ON `l`.`page_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`url` = :magic_filter_url ORDER BY `p`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 16) 0.00021886825561523: perform SELECT DISTINCT SQL_CACHE `c`.`id`, `c`.`code`, `c`.`rate_from`, `c`.`rate_to`, `c`.`cents`, `c`.`position`, `c`.`enabled`, `l`.`name`, `l`.`sign` FROM `ok_currencies` AS `c` LEFT JOIN `ok_lang_currencies` AS `l` ON `l`.`currency_id` = `c`.`id` AND `l`.`lang_id` = 1 WHERE `c`.`enabled` = :magic_filter_enabled ORDER BY `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 17) 0.00053000450134277: perform SELECT DISTINCT SQL_CACHE `p`.`id`, `p`.`url`, `p`.`visible`, `p`.`position`, `p`.`last_modify`, `l`.`name`, `l`.`name_h1`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`description` FROM `ok_pages` AS `p` LEFT JOIN `ok_lang_pages` AS `l` ON `l`.`page_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`visible` = :magic_filter_visible ORDER BY `p`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 18) 0.00038790702819824: perform SELECT DISTINCT SQL_CACHE `p`.`id`, `p`.`module`, `p`.`currency_id`, `p`.`settings`, `p`.`enabled`, `p`.`position`, `p`.`image`, `l`.`name`, `l`.`description` FROM `ok_payment_methods` AS `p` LEFT JOIN `ok_lang_payment_methods` AS `l` ON `l`.`payment_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`enabled` = :magic_filter_enabled ORDER BY `p`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 19) 0.0046341419219971: perform SELECT `c`.`id`, `c`.`parent_id`, `c`.`url`, `c`.`image`, `c`.`position`, `c`.`visible`, `c`.`external_id`, `c`.`level_depth`, `c`.`last_modify`, `c`.`created`, `r`.`slug_url`, `l`.`name`, `l`.`name_h1`, `l`.`auto_h1`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`annotation`, `l`.`description`, `l`.`auto_meta_title`, `l`.`auto_meta_keywords`, `l`.`auto_meta_desc`, `l`.`auto_description` FROM `ok_categories` AS `c` LEFT JOIN `ok_lang_categories` AS `l` ON `l`.`category_id` = `c`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`c`.`url` AND `r`.`type`="category" ORDER BY `c`.`parent_id`, `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 20) 0.00030398368835449: perform SELECT category_id FROM `ok_products_categories` GROUP BY category_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 21) 0.00027799606323242: perform SELECT DISTINCT SQL_CACHE `m`.`id`, `m`.`group_id`, `m`.`name`, `m`.`visible`, `m`.`position` FROM `ok_menu` AS `m` WHERE `m`.`visible` = :magic_filter_visible ORDER BY `m`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 22) 0.00029206275939941: perform SELECT DISTINCT SQL_CACHE `it`.`id`, `it`.`menu_id`, `it`.`parent_id`, `it`.`url`, `it`.`is_target_blank`, `it`.`visible`, `it`.`position`, `l`.`name` FROM `ok_menu_items` AS `it` LEFT JOIN `ok_lang_menu_items` AS `l` ON `l`.`menu_item_id` = `it`.`id` AND `l`.`lang_id` = 1 ORDER BY `it`.`parent_id`, `it`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 23) 0.00044798851013184: perform SELECT DISTINCT SQL_CACHE `a`.`id`, `a`.`filename`, `a`.`position`, `l`.`text` FROM `ok_advantages` AS `a` LEFT JOIN `ok_lang_advantages` AS `l` ON `l`.`advantage_id` = `a`.`id` AND `l`.`lang_id` = 1 ORDER BY `a`.`position` ASC ------------------------------------------------------------------------------------------------------------------------------------------------------ 24) 0.00024104118347168: perform SELECT `b`.`id`, `b`.`url`, `b`.`image`, `b`.`last_modify`, `b`.`visible`, `b`.`position`, `l`.`name`, `l`.`meta_title`, `l`.`meta_keywords`, `l`.`meta_description`, `l`.`annotation`, `l`.`description` FROM `ok_brands` AS `b` LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1 WHERE `b`.`url` = :magic_filter_url ORDER BY `b`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 25) 0.0043370723724365: perform SELECT `pc`.`category_id` FROM `ok_products_categories` AS `pc` INNER JOIN `ok_products` `p` ON `p`.`id`=`pc`.`product_id` AND `p`.`brand_id` in (:brands_ids) AND `p`.`visible`=1 LEFT JOIN `ok_categories` `c` ON `c`.`id`=`pc`.`category_id` WHERE `c`.`visible`=:visible GROUP BY `pc`.`category_id` ORDER BY `c`.`parent_id`, `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 26) 0.0044548511505127: perform SELECT DISTINCT COUNT( DISTINCT `p`.`id`) AS `count` FROM `ok_products` AS `p` LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id` WHERE `p`.`visible` = :magic_filter_visible AND `p`.`brand_id` = :magic_filter_brand_id AND ((SELECT 1 FROM ok_variants pv WHERE `pv`.`product_id`=`p`.`id` AND `pv`.`compare_price`>0 LIMIT 1) = 1) ------------------------------------------------------------------------------------------------------------------------------------------------------ 27) 0.00057816505432129: perform SELECT DISTINCT COUNT( DISTINCT `p`.`id`) AS `count` FROM `ok_products` AS `p` LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id` WHERE `p`.`visible` = :magic_filter_visible AND `p`.`brand_id` = :magic_filter_brand_id AND (`p`.`featured`=1) ------------------------------------------------------------------------------------------------------------------------------------------------------ 28) 0.0048530101776123: perform SELECT floor(min(IF(`pv`.`currency_id`=0 OR `c`.`id` is null,`pv`.`price`, `pv`.`price`*`c`.`rate_to`/`c`.`rate_from`)*1)) AS `min`, floor(max(IF(`pv`.`currency_id`=0 OR `c`.`id` is null,`pv`.`price`, `pv`.`price`*`c`.`rate_to`/`c`.`rate_from`)*1)) AS `max` FROM `ok_products` AS `p` LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id` WHERE `p`.`visible` = :magic_filter_visible AND `p`.`brand_id` = :magic_filter_brand_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 29) 0.0065820217132568: perform SELECT DISTINCT COUNT( DISTINCT `p`.`id`) AS `count` FROM `ok_products` AS `p` LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id` WHERE `p`.`visible` = :magic_filter_visible AND `p`.`brand_id` = :magic_filter_brand_id ------------------------------------------------------------------------------------------------------------------------------------------------------ 30) 0.0041689872741699: perform SELECT DISTINCT SQL_CACHE `p`.`id`, `p`.`url`, `p`.`brand_id`, `p`.`visible`, `p`.`position`, `p`.`created`, `p`.`featured`, `p`.`external_id`, `p`.`rating`, `p`.`votes`, `p`.`last_modify`, `p`.`main_category_id`, `p`.`main_image_id`, `r`.`slug_url`, `l`.`name`, `l`.`annotation`, `l`.`special` FROM `ok_products` AS `p` LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product" LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id` WHERE `p`.`visible` = :magic_filter_visible AND `p`.`brand_id` = :magic_filter_brand_id ORDER BY ((SELECT count(`pv`.`id`) FROM ok_variants pv WHERE (`pv`.`stock` IS NULL OR `pv`.`stock`>0) AND `p`.`id` = `pv`.`product_id`)>0) DESC, `p`.`position` DESC LIMIT 24 ------------------------------------------------------------------------------------------------------------------------------------------------------ 31) 0.00095915794372559: perform SELECT DISTINCT SQL_CACHE `v`.`id`, `v`.`product_id`, `v`.`sku`, `v`.`weight`, `v`.`price`, `v`.`compare_price`, `v`.`stock`, `v`.`position`, `v`.`external_id`, `v`.`currency_id`, (`v`.`stock` IS NULL) AS `infinity`, `c`.`rate_from`, `c`.`rate_to`, `l`.`name`, `l`.`units` FROM `ok_variants` AS `v` LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`v`.`currency_id` LEFT JOIN `ok_lang_variants` AS `l` ON `l`.`variant_id` = `v`.`id` AND `l`.`lang_id` = 1 WHERE `v`.`product_id` IN (:magic_filter_product_id) ORDER BY IF(stock=0, 0, 1) DESC, `v`.`position`, `v`.`id` ------------------------------------------------------------------------------------------------------------------------------------------------------ 32) 0.00029087066650391: perform SELECT DISTINCT SQL_CACHE `c`.`id`, `c`.`code`, `c`.`rate_from`, `c`.`rate_to`, `c`.`cents`, `c`.`position`, `c`.`enabled`, `l`.`name`, `l`.`sign` FROM `ok_currencies` AS `c` LEFT JOIN `ok_lang_currencies` AS `l` ON `l`.`currency_id` = `c`.`id` AND `l`.`lang_id` = 1 ORDER BY `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 33) 0.00048995018005371: perform SELECT DISTINCT SQL_CACHE `i`.`id`, `i`.`name`, `i`.`product_id`, `i`.`filename`, `i`.`position` FROM `ok_images` AS `i` WHERE `i`.`id` IN (:magic_filter_id) ORDER BY `i`.`product_id`, `i`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 34) 0.00071501731872559: perform SELECT DISTINCT SQL_CACHE `p`.`last_modify` FROM `ok_products` AS `p` LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product" LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`brand_id` = :magic_filter_brand_id ORDER BY `p`.`last_modify` DESC LIMIT 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ 35) 0.00060296058654785: perform SELECT DISTINCT SQL_CACHE `b`.`id`, `b`.`name`, `b`.`group_name`, `b`.`position`, `b`.`visible`, `b`.`show_all_pages`, `b`.`categories`, `b`.`pages`, `b`.`brands`, `b`.`as_individual_shortcode`, `b`.`settings`, `b`.`show_all_products` FROM `ok_okaycms__banners` AS `b` WHERE `b`.`visible` = :magic_filter_visible AND (brands regexp '[[:<:]](234)[[:>:]]' OR show_all_pages=1) ORDER BY `b`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------ 36) 0.00030994415283203: perform SELECT DISTINCT SQL_CACHE `p`.`id`, `p`.`url`, `p`.`brand_id`, `p`.`visible`, `p`.`position`, `p`.`created`, `p`.`featured`, `p`.`external_id`, `p`.`rating`, `p`.`votes`, `p`.`last_modify`, `p`.`main_category_id`, `p`.`main_image_id`, `r`.`slug_url`, `l`.`name`, `l`.`annotation`, `l`.`special` FROM `ok_products` AS `p` LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product" LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1 WHERE `p`.`id` IN (:magic_filter_id) ORDER BY ((SELECT count(`pv`.`id`) FROM ok_variants pv WHERE (`pv`.`stock` IS NULL OR `pv`.`stock`>0) AND `p`.`id` = `pv`.`product_id`)>0) DESC, `p`.`position` DESC ------------------------------------------------------------------------------------------------------------------------------------------------------ 37) 0.00035881996154785: perform SELECT `c`.`id`, `c`.`code`, `c`.`rate_from`, `c`.`rate_to`, `c`.`cents`, `c`.`position`, `c`.`enabled`, `l`.`name`, `l`.`sign` FROM `ok_currencies` AS `c` LEFT JOIN `ok_lang_currencies` AS `l` ON `l`.`currency_id` = `c`.`id` AND `l`.`lang_id` = 1 WHERE `c`.`id` = :magic_filter_id ORDER BY `c`.`position` ------------------------------------------------------------------------------------------------------------------------------------------------------