Home
Collections
Catalog
Company
Professionals

Odisea, built-in single-lever shower mixer, 2-way, with 300mm metal showerhead, matte black.

Single-lever 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 matte black finish due to its electrostatic treatment over galvanizing.

K3915122NM 39D309471

Finish: Matte Black

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.32680ms5MBGET en/product/accessories-spare-parts/{slug}/{accessory?}

Booting (109ms)
Application (570ms)
1 x Application (83.89%)
570.31ms
1 x Booting (16.08%)
109.33ms

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 duplicated133ms

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

1.35ms/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"')) = '39d309471-odisea-built-in-single-lever-shower-mixer-2-way-with-300mm-metal-showerhead-matte-black' limit 1

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

Metadata
Bindings	0. 39d309471-odisea-built-in-single-lever-shower-mixer-2-way-with-300mm-metal-showerhead-matte-black
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 (27879)

610μ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 (27879)

350μ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` = 'K3915122' 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.35ms/app/Models/Product.php:102new_rs

Metadata
Bindings	0. K3915122 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

300μ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

420μ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

19.36ms/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 (21867, 22349, 25850, 26189)

3.09ms/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 (21867, 22349, 25850, 26189)

1.53ms/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` = 27879

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

Metadata
Bindings	0. 27879
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` = 27879

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

Metadata
Bindings	0. 27879
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` = 27879

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

Metadata
Bindings	0. 27879
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` = 27880

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

Metadata
Bindings	0. 27880
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` = 27879

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

Metadata
Bindings	0. 27879
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` = 27878

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

Metadata
Bindings	0. 27878
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` = 27877

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

Metadata
Bindings	0. 27877
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` = 27879) as `exists`

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

Metadata
Bindings	0. 27879
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` = 27879) as `exists`

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

Metadata
Bindings	0. 27879
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

280μ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

230μ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

320μ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

260μ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

330μ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

320μ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

310μ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

340μ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

390μ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

340μ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

370μ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: RXeDqfhXkLQtCv9tqrxOuM2BfjBOSl52ssBdqoHo
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/39d309471-odisea-built-in-single-lever-shower-mixer-2-way-with-300mm-metal-showerhead-matte-black

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:19 [▼
  "cookie" => array:1 [▶
    0 => "client_id=fa562901-9006-46ad-9a8e-7d8b910e23c5-1744099406558; XSRF-TOKEN=eyJpdiI6InpwWXprVU9HWWpPdkNNZk5waUJHVXc9PSIsInZhbHVlIjoiRWx6MkhuMStubUQ1THBWQUFKSjU2L0JIMFVVeFlDOXBFUjJWR2FKZkFsN0VJSElrajVuRlhqTXhPR3dEN2o3d2xDVUM1cFlTYmwwOUdSa2d3VWVuZ0RSUi8yckFTeXlCWFQrd0cwTktzRmUzUnR1RHlaOGtDb2xRSGNWUGF6eVciLCJtYWMiOiIxYTQzM2I0M2Y3YTVlOWE3NGYzMzM4NDJjOGE3MGY4ODRlNmVhZmJkZTA5ODAzY2Q4MjExNzQ2OGI4MWM5YWI3IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IjZ3cmNzYWZBdHJHRzFTU282ODNibnc9PSIsInZhbHVlIjoidEpSdTYzRXJmK3lwZTJkNDZLSkdZRXIzTGdJeEJHU09RQmU1NEZqem5wd1FUbzMrYTYvWWNDVjNLYk12ODhJMWxZb1E1YmFxUUhBeDhoMzE4a3dxMzBqbkNKU3NMbVR3T3o2dm9ZR2ViQS9uTms1ajhpUm9yaWYrRmc1d2RBRWQiLCJtYWMiOiI1YzBlNTQ4ZDA1MWRjY2I5NTNhYTY3NWI1YjBhYjU3YmRlMzhiZjUwMTQ0NjI5ZmEwYWI4NjU5ZmYzMTRiNzVhIiwidGFnIjoiIn0%3D ◀client_id=fa562901-9006-46ad-9a8e-7d8b910e23c5-1744099406558; XSRF-TOKEN=eyJpdiI6InpwWXprVU9HWWpPdkNNZk5waUJHVXc9PSIsInZhbHVlIjoiRWx6MkhuMStubUQ1THBWQUFKSjU2L0J ▶"
  ]
  "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 => "3.134.83.74"
  ]
  "host" => array:1 [▶
    0 => "ramonsoler.ipanemacomunicacion.com"
  ]
]

request_server

  0 of 0   
array:54 [▼
  "USER" => "ipanema"
  "HOME" => "/var/www/vhosts/ipanemacomunicacion.com"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/en/product/accessories-spare-parts/39d309471-odisea-built-in-single-lever-shower-mixer-2-way-with-300mm-metal-showerhead-matte-black"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/en/product/accessories-spare-parts/39d309471-odisea-built-in-single-lever-shower-mixer-2-way-with-300mm-metal-showerhead-matte-black"
  "REMOTE_PORT" => "34488"
  "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" => "3.134.83.74"
  "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_COOKIE" => "client_id=fa562901-9006-46ad-9a8e-7d8b910e23c5-1744099406558; XSRF-TOKEN=eyJpdiI6InpwWXprVU9HWWpPdkNNZk5waUJHVXc9PSIsInZhbHVlIjoiRWx6MkhuMStubUQ1THBWQUFKSjU2L0JIMFVVeFlDOXBFUjJWR2FKZkFsN0VJSElrajVuRlhqTXhPR3dEN2o3d2xDVUM1cFlTYmwwOUdSa2d3VWVuZ0RSUi8yckFTeXlCWFQrd0cwTktzRmUzUnR1RHlaOGtDb2xRSGNWUGF6eVciLCJtYWMiOiIxYTQzM2I0M2Y3YTVlOWE3NGYzMzM4NDJjOGE3MGY4ODRlNmVhZmJkZTA5ODAzY2Q4MjExNzQ2OGI4MWM5YWI3IiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IjZ3cmNzYWZBdHJHRzFTU282ODNibnc9PSIsInZhbHVlIjoidEpSdTYzRXJmK3lwZTJkNDZLSkdZRXIzTGdJeEJHU09RQmU1NEZqem5wd1FUbzMrYTYvWWNDVjNLYk12ODhJMWxZb1E1YmFxUUhBeDhoMzE4a3dxMzBqbkNKU3NMbVR3T3o2dm9ZR2ViQS9uTms1ajhpUm9yaWYrRmc1d2RBRWQiLCJtYWMiOiI1YzBlNTQ4ZDA1MWRjY2I5NTNhYTY3NWI1YjBhYjU3YmRlMzhiZjUwMTQ0NjI5ZmEwYWI4NjU5ZmYzMTRiNzVhIiwidGFnIjoiIn0%3D ◀client_id=fa562901-9006-46ad-9a8e-7d8b910e23c5-1744099406558; XSRF-TOKEN=eyJpdiI6InpwWXprVU9HWWpPdkNNZk5waUJHVXc9PSIsInZhbHVlIjoiRWx6MkhuMStubUQ1THBWQUFKSjU2L0J ▶"
  "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" => "3.134.83.74"
  "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" => 1744099417.1609
  "REQUEST_TIME" => 1744099417
]

request_cookies

  0 of 0   
array:3 [▼
  "client_id" => null
  "XSRF-TOKEN" => "RXeDqfhXkLQtCv9tqrxOuM2BfjBOSl52ssBdqoHo"
  "laravel_session" => "mOAThaX1o0Fi6LIO2sIgHNsd77TzBNRSQMTsH0Ka"
]

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 => "Tue, 08 Apr 2025 08:03:37 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFtVjZiblgwZDdiQXIvWHFsbzQwd3c9PSIsInZhbHVlIjoiWEk3M0FFMnRtdjV5YThLZk92c1I3cGgrK1pJVVdZbHVZYVdkTEJUbGo2NEV2S3BUTmNRY2hnNmpRK1ZkRyt3L1R1eE1BR1RRRTBVRDRQc29MeVVQcUZTcloxdlZkMzJqejE1TG1UKzdrMUNTbmNON204NUh6UlRWbnAyMHFKL0ciLCJtYWMiOiJlYjQzOWYxNDEzYWRiMzYyY2Y2MmFhNjNiOTJjMTBiNGY5NjU3MzFiZmFiZDNhYzY3MjQ1NGE2ODliZTkxYjAzIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 10:03:37 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlFtVjZiblgwZDdiQXIvWHFsbzQwd3c9PSIsInZhbHVlIjoiWEk3M0FFMnRtdjV5YThLZk92c1I3cGgrK1pJVVdZbHVZYVdkTEJUbGo2NEV2S3BUTmNRY2hnNmpRK1ZkRyt3L1R1eE1BR ▶"
    1 => "laravel_session=eyJpdiI6Ing1RTM1aGlXamhQaXNZSTE2RjRIQ1E9PSIsInZhbHVlIjoiTGxnYkZVNENodktpWGU4L1FHMFJudmJpT2ZEUjNxUzNtelJzOVhDN0E3K3N4eS9RL1NtNTExVFM2ZEs3MklMbHdzekdTSXljQ0pCUUIyR2JmYnp3Tm41M3NiVXpLNFArNGFrZXZqNko2ZmZrQjhjYWQ1UTRlWkZkQlM0MlFsMmYiLCJtYWMiOiI4ZWJlMWQwNDA4YzI5ZmQzZmUzMGQ0YjQ3MjM1NTg3OWZlNTUxZWY2MmFkMWJmNmFhNTBiYjllMTViMGVjMDFiIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 10:03:37 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ing1RTM1aGlXamhQaXNZSTE2RjRIQ1E9PSIsInZhbHVlIjoiTGxnYkZVNENodktpWGU4L1FHMFJudmJpT2ZEUjNxUzNtelJzOVhDN0E3K3N4eS9RL1NtNTExVFM2ZEs3MklMbHdz ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFtVjZiblgwZDdiQXIvWHFsbzQwd3c9PSIsInZhbHVlIjoiWEk3M0FFMnRtdjV5YThLZk92c1I3cGgrK1pJVVdZbHVZYVdkTEJUbGo2NEV2S3BUTmNRY2hnNmpRK1ZkRyt3L1R1eE1BR1RRRTBVRDRQc29MeVVQcUZTcloxdlZkMzJqejE1TG1UKzdrMUNTbmNON204NUh6UlRWbnAyMHFKL0ciLCJtYWMiOiJlYjQzOWYxNDEzYWRiMzYyY2Y2MmFhNjNiOTJjMTBiNGY5NjU3MzFiZmFiZDNhYzY3MjQ1NGE2ODliZTkxYjAzIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:03:37 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlFtVjZiblgwZDdiQXIvWHFsbzQwd3c9PSIsInZhbHVlIjoiWEk3M0FFMnRtdjV5YThLZk92c1I3cGgrK1pJVVdZbHVZYVdkTEJUbGo2NEV2S3BUTmNRY2hnNmpRK1ZkRyt3L1R1eE1BR ▶"
    1 => "laravel_session=eyJpdiI6Ing1RTM1aGlXamhQaXNZSTE2RjRIQ1E9PSIsInZhbHVlIjoiTGxnYkZVNENodktpWGU4L1FHMFJudmJpT2ZEUjNxUzNtelJzOVhDN0E3K3N4eS9RL1NtNTExVFM2ZEs3MklMbHdzekdTSXljQ0pCUUIyR2JmYnp3Tm41M3NiVXpLNFArNGFrZXZqNko2ZmZrQjhjYWQ1UTRlWkZkQlM0MlFsMmYiLCJtYWMiOiI4ZWJlMWQwNDA4YzI5ZmQzZmUzMGQ0YjQ3MjM1NTg3OWZlNTUxZWY2MmFkMWJmNmFhNTBiYjllMTViMGVjMDFiIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 10:03:37 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ing1RTM1aGlXamhQaXNZSTE2RjRIQ1E9PSIsInZhbHVlIjoiTGxnYkZVNENodktpWGU4L1FHMFJudmJpT2ZEUjNxUzNtelJzOVhDN0E3K3N4eS9RL1NtNTExVFM2ZEs3MklMbHdz ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "_token" => "RXeDqfhXkLQtCv9tqrxOuM2BfjBOSl52ssBdqoHo"
  "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/39d309471-odisea-built-in-single-lever-shower-mixer-2-way-with-300mm-metal-showerhead-matte-black ◀https://ramonsoler.ipanemacomunicacion.com/en/product/accessories-spare-parts/39d309471-odisea-built-in-single-lever-shower-mixer-2-way-with-300mm-metal-showerh ▶"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (83.89%)	570.31ms
1 x Booting (16.08%)	109.33ms

Odisea, built-in single-lever shower mixer, 2-way, with 300mm metal showerhead, matte black.

Características técnicas

Accessories and Spare Parts

Can We Help You?