Home
Collections
Catalog
Company
Professionals

Odisea Joya, built-in 2-way thermostatic faucet set with hand shower and Ø300 mm metal showerhead, chrome.

Built-in 2-way thermostatic faucet set with hand shower and Ø300 mm metal showerhead, high-resistance Diamond Finish chrome plating, Termostop temperature limiter system, and patented anti-corrosion system.

K5987022 59D309493

Finish: Chrome

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 Queries29 Models95 Livewire0 Gate Session Request

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

Booting (115ms)
Application (629ms)
1 x Application (84.56%)
629.30ms
1 x Booting (15.42%)
114.74ms

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

29 statements were executed, 12 of which were duplicated, 17 unique. Show only duplicated143ms

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

1.44ms/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"')) = '59d309493-odisea-joya-built-in-2-way-thermostatic-faucet-set-with-hand-shower-and-o300-mm-metal-showerhead-chrome' limit 1

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

Metadata
Bindings	0. 59d309493-odisea-joya-built-in-2-way-thermostatic-faucet-set-with-hand-shower-and-o300-mm-metal-showerhead-chrome
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 (27947)

900μ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 (27947)

440μ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` = 'K5987022' 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

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

Metadata
Bindings	0. K5987022 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` = 373) order by `id` desc limit 4

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

Metadata
Bindings	0. 373
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.88ms/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 (22168, 23504, 25281, 26360)

4.46ms/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 (22168, 23504, 25281, 26360)

2.4ms/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` = 27947

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

360μ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: 4
App\Models\Classification: 4
App\Models\RsCollection: 55
App\Models\Product: 12
App\Models\Market: 1

_token: UV0Z0cnhOx3RKxzTtl6ATrDo3UHCwBMa1vpWpiEV
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/59d309493-odisea-joya-built-in-2-way-thermostatic-faucet-set-with-hand-shower-and-o300-mm-metal-showerhead-chrome

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=1c60d208-96a9-4e45-aaa9-2603a31af905-1744075750918; XSRF-TOKEN=eyJpdiI6InZnMWRabWFYWXBtS3p5V1gxMGRaa1E9PSIsInZhbHVlIjoiV3RXWCthTXp4K2duc3FlQjdhMWVBNXpOOEhpWW5nNGhDTEQ3YUJEbERHeTJzY3NzVlVHZnUrMVBqaXA5Nm0vM3BEaHoxRFJLWkRTaW54TkRlYjEyZTJLR1JWQk52cCtEWWp0djFlakhlTm9qbk5SNDBncEVGOTJBeXJCUEZsakMiLCJtYWMiOiJhMmRhOGViYzBjNzMwYzJiYjc3NzYwMDJiMzY4OTQ0OTE3Nzc4NjMzZTVjZTc0M2ViYTE4MDYyMTM2NzFmNTJmIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Inh3MEgxUUZRWjc0ZTA4cm0xUnNaR3c9PSIsInZhbHVlIjoiNjhML2VMYUx1bnh6a0YydGY3eUxacEdVb094K2kvM244dU96WXVGMmtLb2NjazNvM1dHMEltMGNJTHdkbWRvODNyUjd6ZFkvdDBoWDltU3VpODE2VmUzYVhoYjdBeDNieTV0TzdoaEcveUVzT04yYmV2RFR1MXNNZEtmeFFZaUIiLCJtYWMiOiI5OTQyMzdhOGZhNTRiNDI2NzQyZTc5OTJmNWIxZWVjODc4NmI5YTQ4ZmI0NGU4ZmI2OWQ4MTA3YzE5ZjI3ZTdjIiwidGFnIjoiIn0%3D ◀client_id=1c60d208-96a9-4e45-aaa9-2603a31af905-1744075750918; XSRF-TOKEN=eyJpdiI6InZnMWRabWFYWXBtS3p5V1gxMGRaa1E9PSIsInZhbHVlIjoiV3RXWCthTXp4K2duc3FlQjdhMWVBNXp ▶"
  ]
  "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.188.115.61"
  ]
  "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/59d309493-odisea-joya-built-in-2-way-thermostatic-faucet-set-with-hand-shower-and-o300-mm-metal-showerhead-chrome"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/en/product/accessories-spare-parts/59d309493-odisea-joya-built-in-2-way-thermostatic-faucet-set-with-hand-shower-and-o300-mm-metal-showerhead-chrome"
  "REMOTE_PORT" => "47554"
  "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.188.115.61"
  "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=1c60d208-96a9-4e45-aaa9-2603a31af905-1744075750918; XSRF-TOKEN=eyJpdiI6InZnMWRabWFYWXBtS3p5V1gxMGRaa1E9PSIsInZhbHVlIjoiV3RXWCthTXp4K2duc3FlQjdhMWVBNXpOOEhpWW5nNGhDTEQ3YUJEbERHeTJzY3NzVlVHZnUrMVBqaXA5Nm0vM3BEaHoxRFJLWkRTaW54TkRlYjEyZTJLR1JWQk52cCtEWWp0djFlakhlTm9qbk5SNDBncEVGOTJBeXJCUEZsakMiLCJtYWMiOiJhMmRhOGViYzBjNzMwYzJiYjc3NzYwMDJiMzY4OTQ0OTE3Nzc4NjMzZTVjZTc0M2ViYTE4MDYyMTM2NzFmNTJmIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6Inh3MEgxUUZRWjc0ZTA4cm0xUnNaR3c9PSIsInZhbHVlIjoiNjhML2VMYUx1bnh6a0YydGY3eUxacEdVb094K2kvM244dU96WXVGMmtLb2NjazNvM1dHMEltMGNJTHdkbWRvODNyUjd6ZFkvdDBoWDltU3VpODE2VmUzYVhoYjdBeDNieTV0TzdoaEcveUVzT04yYmV2RFR1MXNNZEtmeFFZaUIiLCJtYWMiOiI5OTQyMzdhOGZhNTRiNDI2NzQyZTc5OTJmNWIxZWVjODc4NmI5YTQ4ZmI0NGU4ZmI2OWQ4MTA3YzE5ZjI3ZTdjIiwidGFnIjoiIn0%3D ◀client_id=1c60d208-96a9-4e45-aaa9-2603a31af905-1744075750918; XSRF-TOKEN=eyJpdiI6InZnMWRabWFYWXBtS3p5V1gxMGRaa1E9PSIsInZhbHVlIjoiV3RXWCthTXp4K2duc3FlQjdhMWVBNXp ▶"
  "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.188.115.61"
  "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" => 1744075753.4057
  "REQUEST_TIME" => 1744075753
]

request_cookies

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

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 01:29:14 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImQ0ZEZnbnlja3VqekE2U3AxQndNa3c9PSIsInZhbHVlIjoiOGZObnF0QngycUY0cE96T0ZyRVpjQ0svSjNiTGVvdDkwUEJZUmkrbEd6M3IxbStuOWZDQTBwZ3p5U0pXaVBDWDZhN21WRGNqZit2aFVqNnIvWVpyUXZWN2lGaVBuNUZ6WkREMGZhalc5azFCWlNvVDNJeUJjdEZiaVpMLzMwY3EiLCJtYWMiOiJjNzIxMmJiOTQ2MmQyYmI5NGQzYjYzNmUxY2VhNmZkYzNlYTM5MDg3OGVhNzRmNjhkNzhjMzMyMjRkYTRjNjk0IiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 03:29:14 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImQ0ZEZnbnlja3VqekE2U3AxQndNa3c9PSIsInZhbHVlIjoiOGZObnF0QngycUY0cE96T0ZyRVpjQ0svSjNiTGVvdDkwUEJZUmkrbEd6M3IxbStuOWZDQTBwZ3p5U0pXaVBDWDZhN21WR ▶"
    1 => "laravel_session=eyJpdiI6IkNXK2hCV1pkVDNtbzlsTUU1b0ovRkE9PSIsInZhbHVlIjoiU0Fab2FHdGM4cW90UmVodlRmcVhlV01ldXJVTTFCcXlRUlZiWG5uZFpxOEJBcm5VZ1VQQ0dXdXRaRzNOQ1lpbUN5WU5ZTWtXV2dNZ3AzdmtIRzNyeHNGbjV2NlJpMTJDM2kzR3V5M1ZzSU54NmZLQ1M2MU5tdEhEU0kwL2daRFIiLCJtYWMiOiJmMjM1ZDA2M2U0NTk3MWJhYTdhYTIwYjU4NWQzMzcwMWU3NjZkYTNkNTI0NDgyZTFjZWQzYmMyYTVlOWRmMjA1IiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 03:29:14 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkNXK2hCV1pkVDNtbzlsTUU1b0ovRkE9PSIsInZhbHVlIjoiU0Fab2FHdGM4cW90UmVodlRmcVhlV01ldXJVTTFCcXlRUlZiWG5uZFpxOEJBcm5VZ1VQQ0dXdXRaRzNOQ1lpbUN5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImQ0ZEZnbnlja3VqekE2U3AxQndNa3c9PSIsInZhbHVlIjoiOGZObnF0QngycUY0cE96T0ZyRVpjQ0svSjNiTGVvdDkwUEJZUmkrbEd6M3IxbStuOWZDQTBwZ3p5U0pXaVBDWDZhN21WRGNqZit2aFVqNnIvWVpyUXZWN2lGaVBuNUZ6WkREMGZhalc5azFCWlNvVDNJeUJjdEZiaVpMLzMwY3EiLCJtYWMiOiJjNzIxMmJiOTQ2MmQyYmI5NGQzYjYzNmUxY2VhNmZkYzNlYTM5MDg3OGVhNzRmNjhkNzhjMzMyMjRkYTRjNjk0IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 03:29:14 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImQ0ZEZnbnlja3VqekE2U3AxQndNa3c9PSIsInZhbHVlIjoiOGZObnF0QngycUY0cE96T0ZyRVpjQ0svSjNiTGVvdDkwUEJZUmkrbEd6M3IxbStuOWZDQTBwZ3p5U0pXaVBDWDZhN21WR ▶"
    1 => "laravel_session=eyJpdiI6IkNXK2hCV1pkVDNtbzlsTUU1b0ovRkE9PSIsInZhbHVlIjoiU0Fab2FHdGM4cW90UmVodlRmcVhlV01ldXJVTTFCcXlRUlZiWG5uZFpxOEJBcm5VZ1VQQ0dXdXRaRzNOQ1lpbUN5WU5ZTWtXV2dNZ3AzdmtIRzNyeHNGbjV2NlJpMTJDM2kzR3V5M1ZzSU54NmZLQ1M2MU5tdEhEU0kwL2daRFIiLCJtYWMiOiJmMjM1ZDA2M2U0NTk3MWJhYTdhYTIwYjU4NWQzMzcwMWU3NjZkYTNkNTI0NDgyZTFjZWQzYmMyYTVlOWRmMjA1IiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 03:29:14 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkNXK2hCV1pkVDNtbzlsTUU1b0ovRkE9PSIsInZhbHVlIjoiU0Fab2FHdGM4cW90UmVodlRmcVhlV01ldXJVTTFCcXlRUlZiWG5uZFpxOEJBcm5VZ1VQQ0dXdXRaRzNOQ1lpbUN5 ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "_token" => "UV0Z0cnhOx3RKxzTtl6ATrDo3UHCwBMa1vpWpiEV"
  "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/59d309493-odisea-joya-built-in-2-way-thermostatic-faucet-set-with-hand-shower-and-o300-mm-metal-showerhead-chrome ◀https://ramonsoler.ipanemacomunicacion.com/en/product/accessories-spare-parts/59d309493-odisea-joya-built-in-2-way-thermostatic-faucet-set-with-hand-shower-and- ▶"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (84.56%)	629.30ms
1 x Booting (15.42%)	114.74ms

Odisea Joya, built-in 2-way thermostatic faucet set with hand shower and Ø300 mm metal showerhead, chrome.

Características técnicas

Accessories and Spare Parts

Can We Help You?