Home
Collections
Catalog
Company
Professionals

Odisea, thermostatic built-in shower mixer, 2-way, with 300mm metal showerhead, brushed copper.

Thermostatic built-in shower mixer, 2-way, with 300mm round metal showerhead and handheld shower. S2 water-saving system with 50% savings and temperature limiter. High-resistance brushed copper finish with corrosion protection system using sacrificial anode.

K3987022CUC 39D309482

Finish: Brushed Copper

Currently we cannot show the spare parts available but contact us and a technical advisor will help you with the products you need.

Request assistance with technical advice

Find your nearest distributor or commercial agent

Dealer Locator

Can We Help You?

You may not know exactly what product you need, or you may want advice on design trends, water saving, etc. Whatever your situation, at Ramonsoler, we provide advice based on your needs, preferences, and budget.

Shall we talk?

Messages Timeline Exceptions Views2 Route Queries30 Models97 Livewire0 Gate Session Request

8.1.32617ms5MBGET en/product/accessories-spare-parts/{slug}/{accessory?}

Booting (103ms)
Application (513ms)
1 x Application (83.23%)
513.42ms
1 x Booting (16.73%)
103.23ms

2 templates were rendered

pages.products.detail-accessories (resources/views/pages/products/detail-accessories.blade.php)8bladefile
Params
0
product
1
products_related
2
products_suggested
3
classitem
4
spareparts
5
sparepartsProducts
6
variations
7
marketId

Params
0	`product`
1	`products_related`
2	`products_suggested`
3	`classitem`
4	`spareparts`
5	`sparepartsProducts`
6	`variations`
7	`marketId`

layouts.general (resources/views/layouts/general.blade.php)23bladefile


__env
app
errors
product
products_related
products_suggested
classitem
spareparts
sparepartsProducts
variations
marketId
langs
__currentLoopData
variation
loop
finish_name
block
route_es
route_en
route_fr
route_de
route_ca
route_mx

Params
0	`__env`
1	`app`
2	`errors`
3	`product`
4	`products_related`
5	`products_suggested`
6	`classitem`
7	`spareparts`
8	`sparepartsProducts`
9	`variations`
10	`marketId`
11	`langs`
12	`__currentLoopData`
13	`variation`
14	`loop`
15	`finish_name`
16	`block`
17	`route_es`
18	`route_en`
19	`route_fr`
20	`route_de`
21	`route_ca`
22	`route_mx`

uri: GET en/product/accessories-spare-parts/{slug}/{accessory?}
middleware: web, setLocale
locale: en
controller: App\Http\Controllers\AccessoriesController@view
as: en.products.accessories.view
namespace
where
prefix: en
file: app/Http/Controllers/AccessoriesController.php:152-179

30 statements were executed, 12 of which were duplicated, 18 unique. Show only duplicated130ms

select * from `markets` where `name` = 'ES' limit 1

1.46ms/app/Http/Controllers/AccessoriesController.php:34new_rs

Metadata
Bindings	0. ES
Backtrace	16. /app/Http/Controllers/AccessoriesController.php:34 17. /app/Http/Controllers/AccessoriesController.php:155 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `products` where json_unquote(json_extract(`slug`, '$."en"')) = '39d309482-odisea-thermostatic-built-in-shower-mixer-2-way-with-300mm-metal-showerhead-brushed-copper' limit 1

30.29ms/app/Http/Controllers/AccessoriesController.php:158new_rs

Metadata
Bindings	0. 39d309482-odisea-thermostatic-built-in-shower-mixer-2-way-with-300mm-metal-showerhead-brushed-copper
Backtrace	17. /app/Http/Controllers/AccessoriesController.php:158 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `rs_collections`.*, `product_rs_collection`.`product_id` as `pivot_product_id`, `product_rs_collection`.`rs_collection_id` as `pivot_rs_collection_id` from `rs_collections` inner join `product_rs_collection` on `rs_collections`.`id` = `product_rs_collection`.`rs_collection_id` where `product_rs_collection`.`product_id` in (27957)

650μs/app/Http/Controllers/AccessoriesController.php:158new_rs

Metadata
Backtrace	21. /app/Http/Controllers/AccessoriesController.php:158 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `classifications`.*, `classification_product`.`product_id` as `pivot_product_id`, `classification_product`.`classification_id` as `pivot_classification_id` from `classifications` inner join `classification_product` on `classifications`.`id` = `classification_product`.`classification_id` where `classification_product`.`product_id` in (27957)

320μs/app/Http/Controllers/AccessoriesController.php:158new_rs

Metadata
Backtrace	21. /app/Http/Controllers/AccessoriesController.php:158 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `products`.*, `finishes`.`name` as `finish_name`, `finishes`.`order` as `finish_order` from `products` inner join `finish_product` on `products`.`id` = `finish_product`.`product_id` inner join `finishes` on `finish_product`.`finish_id` = `finishes`.`id` where `group` = 'K3987022' and `products`.`active` = 1 and (exists (select * from `markets` inner join `market_product` on `markets`.`id` = `market_product`.`market_id` where `products`.`id` = `market_product`.`product_id` and `id` = 'es') or `is_generic` = 1) order by `finish_order` asc

1.11ms/app/Models/Product.php:102new_rs

Metadata
Bindings	0. K3987022 1. 1 2. es 3. 1
Backtrace	15. /app/Models/Product.php:102 16. /app/Http/Controllers/AccessoriesController.php:159 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `classifications` where (json_extract(`slug`, '$."es"') is null OR json_type(json_extract(`slug`, '$."es"')) = 'NULL') limit 1

220μs/app/Http/Controllers/AccessoriesController.php:166new_rs

Metadata
Backtrace	16. /app/Http/Controllers/AccessoriesController.php:166 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `products` where `photo_p0` is not null and exists (select * from `rs_collections` inner join `product_rs_collection` on `rs_collections`.`id` = `product_rs_collection`.`rs_collection_id` where `products`.`id` = `product_rs_collection`.`product_id` and `id` = 330) order by `id` desc limit 4

770μs/app/Http/Controllers/AccessoriesController.php:170new_rs

Metadata
Bindings	0. 330
Backtrace	15. /app/Http/Controllers/AccessoriesController.php:170 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `products` where `photo_p0` is not null and exists (select * from `classifications` inner join `classification_product` on `classifications`.`id` = `classification_product`.`classification_id` where `products`.`id` = `classification_product`.`product_id` and `id` = 33) order by RAND() limit 4

13.64ms/app/Http/Controllers/AccessoriesController.php:171new_rs

Metadata
Bindings	0. 33
Backtrace	15. /app/Http/Controllers/AccessoriesController.php:171 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `rs_collections`.*, `product_rs_collection`.`product_id` as `pivot_product_id`, `product_rs_collection`.`rs_collection_id` as `pivot_rs_collection_id` from `rs_collections` inner join `product_rs_collection` on `rs_collections`.`id` = `product_rs_collection`.`rs_collection_id` where `product_rs_collection`.`product_id` in (22085, 24388, 24606, 25398)

3.36ms/app/Http/Controllers/AccessoriesController.php:171new_rs

Metadata
Backtrace	19. /app/Http/Controllers/AccessoriesController.php:171 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `classifications`.*, `classification_product`.`product_id` as `pivot_product_id`, `classification_product`.`classification_id` as `pivot_classification_id` from `classifications` inner join `classification_product` on `classifications`.`id` = `classification_product`.`classification_id` where `classification_product`.`product_id` in (22085, 24388, 24606, 25398)

1.5ms/app/Http/Controllers/AccessoriesController.php:171new_rs

Metadata
Backtrace	19. /app/Http/Controllers/AccessoriesController.php:171 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `products`.*, `product_sparepart`.`sparepart_id` as `pivot_sparepart_id`, `product_sparepart`.`product_id` as `pivot_product_id` from `products` inner join `product_sparepart` on `products`.`id` = `product_sparepart`.`product_id` where `product_sparepart`.`sparepart_id` = 27957

51.67ms/app/Http/Controllers/AccessoriesController.php:174new_rs

Metadata
Bindings	0. 27957
Backtrace	15. /app/Http/Controllers/AccessoriesController.php:174 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `products`.*, `product_sparepart`.`product_id` as `pivot_product_id`, `product_sparepart`.`sparepart_id` as `pivot_sparepart_id` from `products` inner join `product_sparepart` on `products`.`id` = `product_sparepart`.`sparepart_id` where `product_sparepart`.`product_id` = 27957

400μs/app/Http/Controllers/AccessoriesController.php:175new_rs

Metadata
Bindings	0. 27957
Backtrace	15. /app/Http/Controllers/AccessoriesController.php:175 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `finishes`.*, `finish_product`.`product_id` as `pivot_product_id`, `finish_product`.`finish_id` as `pivot_finish_id` from `finishes` inner join `finish_product` on `finishes`.`id` = `finish_product`.`finish_id` where `finish_product`.`product_id` = 27957

350μsview::pages.products.detail-accessories:102new_rs

Metadata
Bindings	0. 27957
Backtrace	21. view::pages.products.detail-accessories:102 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `finishes`.*, `finish_product`.`product_id` as `pivot_product_id`, `finish_product`.`finish_id` as `pivot_finish_id` from `finishes` inner join `finish_product` on `finishes`.`id` = `finish_product`.`finish_id` where `finish_product`.`product_id` = 27960

330μsview::pages.products.detail-accessories:116new_rs

Metadata
Bindings	0. 27960
Backtrace	20. view::pages.products.detail-accessories:116 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `finishes`.*, `finish_product`.`product_id` as `pivot_product_id`, `finish_product`.`finish_id` as `pivot_finish_id` from `finishes` inner join `finish_product` on `finishes`.`id` = `finish_product`.`finish_id` where `finish_product`.`product_id` = 27959

340μsview::pages.products.detail-accessories:116new_rs

Metadata
Bindings	0. 27959
Backtrace	20. view::pages.products.detail-accessories:116 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `finishes`.*, `finish_product`.`product_id` as `pivot_product_id`, `finish_product`.`finish_id` as `pivot_finish_id` from `finishes` inner join `finish_product` on `finishes`.`id` = `finish_product`.`finish_id` where `finish_product`.`product_id` = 27958

340μsview::pages.products.detail-accessories:116new_rs

Metadata
Bindings	0. 27958
Backtrace	20. view::pages.products.detail-accessories:116 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `finishes`.*, `finish_product`.`product_id` as `pivot_product_id`, `finish_product`.`finish_id` as `pivot_finish_id` from `finishes` inner join `finish_product` on `finishes`.`id` = `finish_product`.`finish_id` where `finish_product`.`product_id` = 27957

210μsview::pages.products.detail-accessories:116new_rs

Metadata
Bindings	0. 27957
Backtrace	20. view::pages.products.detail-accessories:116 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select exists(select * from `products` inner join `product_sparepart` on `products`.`id` = `product_sparepart`.`product_id` where `product_sparepart`.`sparepart_id` = 27957) as `exists`

19.93msview::pages.products.detail-accessories:297new_rs

Metadata
Bindings	0. 27957
Backtrace	14. view::pages.products.detail-accessories:297 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 18. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select exists(select * from `products` inner join `product_sparepart` on `products`.`id` = `product_sparepart`.`sparepart_id` where `product_sparepart`.`product_id` = 27957) as `exists`

280μsview::pages.products.detail-accessories:297new_rs

Metadata
Bindings	0. 27957
Backtrace	14. view::pages.products.detail-accessories:297 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 18. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `page_blocks` where `id` = 4

200μsview::pages.products.detail-accessories:538new_rs

Metadata
Bindings	0. 4
Backtrace	15. view::pages.products.detail-accessories:538 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `styles` order by `order` asc

210μsview::layouts.general:302new_rs

Metadata
Backtrace	15. view::layouts.general:302 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `rs_collections`.*, `rs_collection_style`.`style_id` as `pivot_style_id`, `rs_collection_style`.`rs_collection_id` as `pivot_rs_collection_id`, `rs_collection_style`.`order` as `pivot_order` from `rs_collections` inner join `rs_collection_style` on `rs_collections`.`id` = `rs_collection_style`.`rs_collection_id` where `rs_collection_style`.`style_id` = 1 order by `rs_collection_style`.`order` asc

240μsview::layouts.general:321new_rs

Metadata
Bindings	0. 1
Backtrace	20. view::layouts.general:321 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `rs_collections`.*, `rs_collection_style`.`style_id` as `pivot_style_id`, `rs_collection_style`.`rs_collection_id` as `pivot_rs_collection_id`, `rs_collection_style`.`order` as `pivot_order` from `rs_collections` inner join `rs_collection_style` on `rs_collections`.`id` = `rs_collection_style`.`rs_collection_id` where `rs_collection_style`.`style_id` = 4 order by `rs_collection_style`.`order` asc

230μsview::layouts.general:353new_rs

Metadata
Bindings	0. 4
Backtrace	20. view::layouts.general:353 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `rs_collections`.*, `rs_collection_style`.`style_id` as `pivot_style_id`, `rs_collection_style`.`rs_collection_id` as `pivot_rs_collection_id`, `rs_collection_style`.`order` as `pivot_order` from `rs_collections` inner join `rs_collection_style` on `rs_collections`.`id` = `rs_collection_style`.`rs_collection_id` where `rs_collection_style`.`style_id` = 3 order by `rs_collection_style`.`order` asc

240μsview::layouts.general:416new_rs

Metadata
Bindings	0. 3
Backtrace	20. view::layouts.general:416 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `rs_collections`.*, `rs_collection_style`.`style_id` as `pivot_style_id`, `rs_collection_style`.`rs_collection_id` as `pivot_rs_collection_id`, `rs_collection_style`.`order` as `pivot_order` from `rs_collections` inner join `rs_collection_style` on `rs_collections`.`id` = `rs_collection_style`.`rs_collection_id` where `rs_collection_style`.`style_id` = 8 order by `rs_collection_style`.`order` asc

230μsview::layouts.general:385new_rs

Metadata
Bindings	0. 8
Backtrace	20. view::layouts.general:385 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `styles` order by `order` asc

200μsview::layouts.general:1028new_rs

Metadata
Backtrace	15. view::layouts.general:1028 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `rs_collections`.*, `rs_collection_style`.`style_id` as `pivot_style_id`, `rs_collection_style`.`rs_collection_id` as `pivot_rs_collection_id`, `rs_collection_style`.`order` as `pivot_order` from `rs_collections` inner join `rs_collection_style` on `rs_collections`.`id` = `rs_collection_style`.`rs_collection_id` where `rs_collection_style`.`style_id` = 1 order by `rs_collection_style`.`order` asc

230μsview::layouts.general:1039new_rs

Metadata
Bindings	0. 1
Backtrace	20. view::layouts.general:1039 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `rs_collections`.*, `rs_collection_style`.`style_id` as `pivot_style_id`, `rs_collection_style`.`rs_collection_id` as `pivot_rs_collection_id`, `rs_collection_style`.`order` as `pivot_order` from `rs_collections` inner join `rs_collection_style` on `rs_collections`.`id` = `rs_collection_style`.`rs_collection_id` where `rs_collection_style`.`style_id` = 4 order by `rs_collection_style`.`order` asc

230μsview::layouts.general:1064new_rs

Metadata
Bindings	0. 4
Backtrace	20. view::layouts.general:1064 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `rs_collections`.*, `rs_collection_style`.`style_id` as `pivot_style_id`, `rs_collection_style`.`rs_collection_id` as `pivot_rs_collection_id`, `rs_collection_style`.`order` as `pivot_order` from `rs_collections` inner join `rs_collection_style` on `rs_collections`.`id` = `rs_collection_style`.`rs_collection_id` where `rs_collection_style`.`style_id` = 3 order by `rs_collection_style`.`order` asc

240μsview::layouts.general:1117new_rs

Metadata
Bindings	0. 3
Backtrace	20. view::layouts.general:1117 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select `rs_collections`.*, `rs_collection_style`.`style_id` as `pivot_style_id`, `rs_collection_style`.`rs_collection_id` as `pivot_rs_collection_id`, `rs_collection_style`.`order` as `pivot_order` from `rs_collections` inner join `rs_collection_style` on `rs_collections`.`id` = `rs_collection_style`.`rs_collection_id` where `rs_collection_style`.`style_id` = 8 order by `rs_collection_style`.`order` asc

230μsview::layouts.general:1094new_rs

Metadata
Bindings	0. 8
Backtrace	20. view::layouts.general:1094 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

App\Models\Style: 18
App\Models\PageBlock: 1
App\Models\Finish: 5
App\Models\Classification: 4
App\Models\RsCollection: 55
App\Models\Product: 13
App\Models\Market: 1

_token: Mm5o4YBjEeERceNgnL8KLTwb8J2alWZAIzeChd1e
countryName: United States
codeMarketClient: US
countryMarketCodeUser: ES
countryLangUser: es
locale: en
market: ES
countryMarketDefineUserCodeUser: null
_previous: array:1 [ "url" => "https://ramonsoler.ipanemacomunicacion.com/en/product/accessories-spare-parts/...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/en/product/accessories-spare-parts/39d309482-odisea-thermostatic-built-in-shower-mixer-2-way-with-300mm-metal-showerhead-brushed-copper

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:18 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-real-ip" => array:1 [▶
    0 => "18.219.85.34"
  ]
  "host" => array:1 [▶
    0 => "ramonsoler.ipanemacomunicacion.com"
  ]
]

request_server

  0 of 0   
array:53 [▼
  "USER" => "ipanema"
  "HOME" => "/var/www/vhosts/ipanemacomunicacion.com"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/en/product/accessories-spare-parts/39d309482-odisea-thermostatic-built-in-shower-mixer-2-way-with-300mm-metal-showerhead-brushed-copper"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/en/product/accessories-spare-parts/39d309482-odisea-thermostatic-built-in-shower-mixer-2-way-with-300mm-metal-showerhead-brushed-copper"
  "REMOTE_PORT" => "47962"
  "SCRIPT_FILENAME" => "/var/www/vhosts/ipanemacomunicacion.com/ramonsoler.ipanemacomunicacion.com/public/index.php"
  "SERVER_ADMIN" => "[no address given]"
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/vhosts/ipanemacomunicacion.com/ramonsoler.ipanemacomunicacion.com/public"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/var/www/vhosts/ipanemacomunicacion.com/ramonsoler.ipanemacomunicacion.com/public"
  "REMOTE_ADDR" => "18.219.85.34"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "198.20.86.74"
  "SERVER_NAME" => "ramonsoler.ipanemacomunicacion.com"
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_SIGNATURE" => "<address>Apache Server at ramonsoler.ipanemacomunicacion.com Port 443</address>\n"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "close"
  "HTTP_X_ACCEL_INTERNAL" => "/internal-nginx-static-location"
  "HTTP_X_REAL_IP" => "18.219.85.34"
  "HTTP_HOST" => "ramonsoler.ipanemacomunicacion.com"
  "proxy-nokeepalive" => "1"
  "HTTPS" => "on"
  "PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY" => "0"
  "PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY" => "0"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY" => "0"
  "REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY" => "0"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744169835.2162
  "REQUEST_TIME" => 1744169835
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "private, must-revalidate"
  ]
  "date" => array:1 [▶
    0 => "Wed, 09 Apr 2025 03:37:15 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBkS2E5VTQwNmFYVENpMkV4YkQ0R3c9PSIsInZhbHVlIjoiLzU2QnhvbCt2VmhES0F2aENReG5FMzVHR2g4Z1Y1cWh4Y3hwZjdpaEJSWlN0V1h3YzNJUEEvS3crd01DWUpFWWtHK2dkWWdPdjRHNVBtZXpvejljOWowbG1rUXVsNWNONUxXeUdRYWhtblF6b2hCTExoNTJGQ1NGRXh5TjJSYnoiLCJtYWMiOiIzNDVmOWQxYjcwMzVmMTkzZWMwYmNjOTMyMzJiYzlhNjEyYThhYTVlZGFiNGFiM2FjNDU3MjkwY2FmOWE5NTQ0IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 05:37:15 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InBkS2E5VTQwNmFYVENpMkV4YkQ0R3c9PSIsInZhbHVlIjoiLzU2QnhvbCt2VmhES0F2aENReG5FMzVHR2g4Z1Y1cWh4Y3hwZjdpaEJSWlN0V1h3YzNJUEEvS3crd01DWUpFWWtHK2dkW ▶"
    1 => "laravel_session=eyJpdiI6IjZReCs2cTJiRHkzcEFRM2tKRGlmZUE9PSIsInZhbHVlIjoiMTRHbWdiMVVqeGE5b2NXODY0d3dZK25pd25xaVdCV09Od3A0WWhubnhYZUVvUk1FcEEwd0F3Rmh1ZFNXVXkzaFc1bVZYZUxLSXVYL2RqNmdGa3MrVFJrNlk1UW4xb3FoOFJpOFpZQW5wTUlpb2ltY0xxL3Rldm01WWpNS2tSMVIiLCJtYWMiOiIzYWMzOWEwYWRkNjBiZmVjYWI4ODA3OTE5NmYzNDhkNTg0YmQ5ZDVhYjFkOTE0YWExYWUwMzA3Njk3OGI4OWE4IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 05:37:15 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjZReCs2cTJiRHkzcEFRM2tKRGlmZUE9PSIsInZhbHVlIjoiMTRHbWdiMVVqeGE5b2NXODY0d3dZK25pd25xaVdCV09Od3A0WWhubnhYZUVvUk1FcEEwd0F3Rmh1ZFNXVXkzaFc1 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBkS2E5VTQwNmFYVENpMkV4YkQ0R3c9PSIsInZhbHVlIjoiLzU2QnhvbCt2VmhES0F2aENReG5FMzVHR2g4Z1Y1cWh4Y3hwZjdpaEJSWlN0V1h3YzNJUEEvS3crd01DWUpFWWtHK2dkWWdPdjRHNVBtZXpvejljOWowbG1rUXVsNWNONUxXeUdRYWhtblF6b2hCTExoNTJGQ1NGRXh5TjJSYnoiLCJtYWMiOiIzNDVmOWQxYjcwMzVmMTkzZWMwYmNjOTMyMzJiYzlhNjEyYThhYTVlZGFiNGFiM2FjNDU3MjkwY2FmOWE5NTQ0IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 05:37:15 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InBkS2E5VTQwNmFYVENpMkV4YkQ0R3c9PSIsInZhbHVlIjoiLzU2QnhvbCt2VmhES0F2aENReG5FMzVHR2g4Z1Y1cWh4Y3hwZjdpaEJSWlN0V1h3YzNJUEEvS3crd01DWUpFWWtHK2dkW ▶"
    1 => "laravel_session=eyJpdiI6IjZReCs2cTJiRHkzcEFRM2tKRGlmZUE9PSIsInZhbHVlIjoiMTRHbWdiMVVqeGE5b2NXODY0d3dZK25pd25xaVdCV09Od3A0WWhubnhYZUVvUk1FcEEwd0F3Rmh1ZFNXVXkzaFc1bVZYZUxLSXVYL2RqNmdGa3MrVFJrNlk1UW4xb3FoOFJpOFpZQW5wTUlpb2ltY0xxL3Rldm01WWpNS2tSMVIiLCJtYWMiOiIzYWMzOWEwYWRkNjBiZmVjYWI4ODA3OTE5NmYzNDhkNTg0YmQ5ZDVhYjFkOTE0YWExYWUwMzA3Njk3OGI4OWE4IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 05:37:15 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjZReCs2cTJiRHkzcEFRM2tKRGlmZUE9PSIsInZhbHVlIjoiMTRHbWdiMVVqeGE5b2NXODY0d3dZK25pd25xaVdCV09Od3A0WWhubnhYZUVvUk1FcEEwd0F3Rmh1ZFNXVXkzaFc1 ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "_token" => "Mm5o4YBjEeERceNgnL8KLTwb8J2alWZAIzeChd1e"
  "countryName" => "United States"
  "codeMarketClient" => "US"
  "countryMarketCodeUser" => "ES"
  "countryLangUser" => "es"
  "locale" => "en"
  "market" => "ES"
  "countryMarketDefineUserCodeUser" => null
  "_previous" => array:1 [▶
    "url" => "https://ramonsoler.ipanemacomunicacion.com/en/product/accessories-spare-parts/39d309482-odisea-thermostatic-built-in-shower-mixer-2-way-with-300mm-metal-showerhead-brushed-copper ◀https://ramonsoler.ipanemacomunicacion.com/en/product/accessories-spare-parts/39d309482-odisea-thermostatic-built-in-shower-mixer-2-way-with-300mm-metal-showerh ▶"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (83.23%)	513.42ms
1 x Booting (16.73%)	103.23ms

Odisea, thermostatic built-in shower mixer, 2-way, with 300mm metal showerhead, brushed copper.

Características técnicas

Accessories and Spare Parts

Can We Help You?