Home
Collections
Catalog
Company
Professionals

3-Function Semi-Square ABS Hand Shower, Brushed Copper

Semi-square ABS hand shower with three functions (pulse water jet, rainwater jet, and aerated rainwater jet) includes an anti-lime system with flexible silicone nozzles. It is finished with a high-resistance brushed copper PVD treatment.

4914Q3CUC 99Z309233

Finish: Brushed Copper

Products

Here you will find the products that are compatible with this replacement

Hydrotherapy

Conjunto de ducha de pared con ducha de mano y codo con soporte, cobre cepillado

99H309926 3783Q3CUC

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 Queries34 Models111 Livewire0 Gate Session Request

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

Booting (113ms)
Application (543ms)
1 x Application (82.75%)
542.83ms
1 x Booting (17.22%)
112.97ms

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)24bladefile


__env
app
errors
product
products_related
products_suggested
classitem
spareparts
sparepartsProducts
variations
marketId
langs
__currentLoopData
variation
loop
finish_name
item
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	`item`
17	`block`
18	`route_es`
19	`route_en`
20	`route_fr`
21	`route_de`
22	`route_ca`
23	`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

34 statements were executed, 14 of which were duplicated, 20 unique. Show only duplicated125ms

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

2.19ms/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"')) = '99z309233-3-function-semi-square-abs-hand-shower-brushed-copper' limit 1

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

Metadata
Bindings	0. 99z309233-3-function-semi-square-abs-hand-shower-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 (27542)

840μ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 (27542)

400μ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` = '4914Q3' 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.56ms/app/Models/Product.php:102new_rs

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

340μ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` = 320) order by `id` desc limit 4

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

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

24.55ms/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 (22089, 22380, 22499, 26521)

3.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 `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 (22089, 22380, 22499, 26521)

1.51ms/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` = 27542

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

640μsview::pages.products.detail-accessories:441new_rs

Metadata
Bindings	0. 32821
Backtrace	21. view::pages.products.detail-accessories:441 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 `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` = '3783Q3' 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.14ms/app/Models/Product.php:102new_rs

Metadata
Bindings	0. 3783Q3 1. 1 2. es 3. 1
Backtrace	15. /app/Models/Product.php:102 16. view::pages.products.detail-accessories:454 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

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` = '3783Q3' 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.07ms/app/Models/Product.php:102new_rs

Metadata
Bindings	0. 3783Q3 1. 1 2. es 3. 1
Backtrace	15. /app/Models/Product.php:102 16. view::pages.products.detail-accessories:455 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/livewire/livewire/src/ComponentConcerns/RendersLivewireComponents.php:69

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

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

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

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

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

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

240μ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: 7
App\Models\Classification: 4
App\Models\RsCollection: 56
App\Models\Product: 24
App\Models\Market: 1

_token: eO6tq0iTNgig9XEibnBCh9zTcwwTE4Ir0hpCjwFP
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/99z309233-3-function-semi-square-abs-hand-shower-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:19 [▼
  "cookie" => array:1 [▶
    0 => "client_id=cd0aea60-29e6-4d04-b9b4-03e3f48d75ad-1744185632005; XSRF-TOKEN=eyJpdiI6Imw1SDhvWmw2cFNWMFBxRlJtT1dTL1E9PSIsInZhbHVlIjoiRThjVHc3SXBxbzl3M1N5WHVQVVNtSHVOS2FORXQ5UWo0bTA2a3JqdGQ4dFhnNXYxNFhpb05aRFdLMnVST3M3VnF6dyswcUJFMHkrM0QvZTdXcFZ4dWdQcWNxbGtjeUd4bUVIdUpyZmRyam1BdXA2elBaMzM4Z0xIcEtzNXlQKzkiLCJtYWMiOiJhMDY1Yjk5YzVlMzcwMTk1ZTU0ZWQ2YzJiZTQwZjE3YTk4YWIxZDkzNmQ5NmJhOWUyN2RkNDkwMTRhNDA2NGZhIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IkVLam50RTY0aGE1VENBU1kraXlOOXc9PSIsInZhbHVlIjoiOVRRZ1dnVDZPRys2SkM4dmJtOVNMTTJPVjBzWVFCVDJZNW41eFpBNkw0Qm9YOGJFZHBRUng4VVVrSjg4WUVqc3dSZHJ0b28zRk5ndkxKUDZFYVhOWDYreFpGNS96QmtLdFBZUUFORHhIb1RjZWZMemdTUlJJSi9YQUxSMVo1TkgiLCJtYWMiOiJiZDY2MzMxOGFlYzJiMGJmNGM3YzAxYTBiZWRiMjhlZDEwNmMxMWEwYmYzNTVkYWQzYjUyNDM1YTY4OWRkN2NiIiwidGFnIjoiIn0%3D ◀client_id=cd0aea60-29e6-4d04-b9b4-03e3f48d75ad-1744185632005; XSRF-TOKEN=eyJpdiI6Imw1SDhvWmw2cFNWMFBxRlJtT1dTL1E9PSIsInZhbHVlIjoiRThjVHc3SXBxbzl3M1N5WHVQVVNtSHV ▶"
  ]
  "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.18.103.165"
  ]
  "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/99z309233-3-function-semi-square-abs-hand-shower-brushed-copper"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/en/product/accessories-spare-parts/99z309233-3-function-semi-square-abs-hand-shower-brushed-copper"
  "REMOTE_PORT" => "33142"
  "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.18.103.165"
  "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=cd0aea60-29e6-4d04-b9b4-03e3f48d75ad-1744185632005; XSRF-TOKEN=eyJpdiI6Imw1SDhvWmw2cFNWMFBxRlJtT1dTL1E9PSIsInZhbHVlIjoiRThjVHc3SXBxbzl3M1N5WHVQVVNtSHVOS2FORXQ5UWo0bTA2a3JqdGQ4dFhnNXYxNFhpb05aRFdLMnVST3M3VnF6dyswcUJFMHkrM0QvZTdXcFZ4dWdQcWNxbGtjeUd4bUVIdUpyZmRyam1BdXA2elBaMzM4Z0xIcEtzNXlQKzkiLCJtYWMiOiJhMDY1Yjk5YzVlMzcwMTk1ZTU0ZWQ2YzJiZTQwZjE3YTk4YWIxZDkzNmQ5NmJhOWUyN2RkNDkwMTRhNDA2NGZhIiwidGFnIjoiIn0%3D; laravel_session=eyJpdiI6IkVLam50RTY0aGE1VENBU1kraXlOOXc9PSIsInZhbHVlIjoiOVRRZ1dnVDZPRys2SkM4dmJtOVNMTTJPVjBzWVFCVDJZNW41eFpBNkw0Qm9YOGJFZHBRUng4VVVrSjg4WUVqc3dSZHJ0b28zRk5ndkxKUDZFYVhOWDYreFpGNS96QmtLdFBZUUFORHhIb1RjZWZMemdTUlJJSi9YQUxSMVo1TkgiLCJtYWMiOiJiZDY2MzMxOGFlYzJiMGJmNGM3YzAxYTBiZWRiMjhlZDEwNmMxMWEwYmYzNTVkYWQzYjUyNDM1YTY4OWRkN2NiIiwidGFnIjoiIn0%3D ◀client_id=cd0aea60-29e6-4d04-b9b4-03e3f48d75ad-1744185632005; XSRF-TOKEN=eyJpdiI6Imw1SDhvWmw2cFNWMFBxRlJtT1dTL1E9PSIsInZhbHVlIjoiRThjVHc3SXBxbzl3M1N5WHVQVVNtSHV ▶"
  "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.18.103.165"
  "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" => 1744185651.5266
  "REQUEST_TIME" => 1744185651
]

request_cookies

  0 of 0   
array:3 [▼
  "client_id" => null
  "XSRF-TOKEN" => "eO6tq0iTNgig9XEibnBCh9zTcwwTE4Ir0hpCjwFP"
  "laravel_session" => "2eNhAMuMRIdXcWmW62q9LkSr8yLr2Fvg3VETiJaM"
]

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 08:00:52 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpwZ1NkaEVrdHJVbm9KNzJoQjNYK0E9PSIsInZhbHVlIjoiVEZ1NS85dE9TenQzOGVNbWtJUFRNdHgyeDhldTAvdUNsVi9zWG05MDEvYTduN0pGbHFJZlRXc29FRGxXVWQwRXVud3BYN25LV0puQTVOR0p5UVJtR0t1UkpMTUNpZ0w3OU1NR0dmM0Vqc1NvdFVwRXBlbDJPc1B6TzY2QzIyU04iLCJtYWMiOiIxNDA4Y2M2OGY5MTdiYWQ2N2NjNDVkMzE2YjdkNWY5YWUwMTg2NzAzNDFiYjIyOTZjYTZhZDQyZDk3M2Q4NTU2IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 10:00:52 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImpwZ1NkaEVrdHJVbm9KNzJoQjNYK0E9PSIsInZhbHVlIjoiVEZ1NS85dE9TenQzOGVNbWtJUFRNdHgyeDhldTAvdUNsVi9zWG05MDEvYTduN0pGbHFJZlRXc29FRGxXVWQwRXVud3BYN ▶"
    1 => "laravel_session=eyJpdiI6IjlORm55OFVaSTdEeERKcmdmSzlyQ0E9PSIsInZhbHVlIjoiMnlWdDNkTUtnN29FNElpTTlOQjRiUDU1ZDg3ZTBlRGlFMkc0VkhlR3pIbktRa0xTZklyUjlVaUQzZ2FGNzBWZE84ZVd0WmpBejFTTHVNempIcnQ2aFZSREo1S2xKODNsOTFvZUJPRU91cGlUS3JaUld6dTVHSnZQcnZVUVh6UWgiLCJtYWMiOiI0MzNiNTJiNWNkOTRiOTNhMGM3OGJlZDlmMzIyMzYyYTRjNzA2OWJmNjJmZTRkZjgxZjEyNWYyMGE0ZDU2NWQzIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 10:00:52 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjlORm55OFVaSTdEeERKcmdmSzlyQ0E9PSIsInZhbHVlIjoiMnlWdDNkTUtnN29FNElpTTlOQjRiUDU1ZDg3ZTBlRGlFMkc0VkhlR3pIbktRa0xTZklyUjlVaUQzZ2FGNzBWZE84 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpwZ1NkaEVrdHJVbm9KNzJoQjNYK0E9PSIsInZhbHVlIjoiVEZ1NS85dE9TenQzOGVNbWtJUFRNdHgyeDhldTAvdUNsVi9zWG05MDEvYTduN0pGbHFJZlRXc29FRGxXVWQwRXVud3BYN25LV0puQTVOR0p5UVJtR0t1UkpMTUNpZ0w3OU1NR0dmM0Vqc1NvdFVwRXBlbDJPc1B6TzY2QzIyU04iLCJtYWMiOiIxNDA4Y2M2OGY5MTdiYWQ2N2NjNDVkMzE2YjdkNWY5YWUwMTg2NzAzNDFiYjIyOTZjYTZhZDQyZDk3M2Q4NTU2IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 10:00:52 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImpwZ1NkaEVrdHJVbm9KNzJoQjNYK0E9PSIsInZhbHVlIjoiVEZ1NS85dE9TenQzOGVNbWtJUFRNdHgyeDhldTAvdUNsVi9zWG05MDEvYTduN0pGbHFJZlRXc29FRGxXVWQwRXVud3BYN ▶"
    1 => "laravel_session=eyJpdiI6IjlORm55OFVaSTdEeERKcmdmSzlyQ0E9PSIsInZhbHVlIjoiMnlWdDNkTUtnN29FNElpTTlOQjRiUDU1ZDg3ZTBlRGlFMkc0VkhlR3pIbktRa0xTZklyUjlVaUQzZ2FGNzBWZE84ZVd0WmpBejFTTHVNempIcnQ2aFZSREo1S2xKODNsOTFvZUJPRU91cGlUS3JaUld6dTVHSnZQcnZVUVh6UWgiLCJtYWMiOiI0MzNiNTJiNWNkOTRiOTNhMGM3OGJlZDlmMzIyMzYyYTRjNzA2OWJmNjJmZTRkZjgxZjEyNWYyMGE0ZDU2NWQzIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 10:00:52 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjlORm55OFVaSTdEeERKcmdmSzlyQ0E9PSIsInZhbHVlIjoiMnlWdDNkTUtnN29FNElpTTlOQjRiUDU1ZDg3ZTBlRGlFMkc0VkhlR3pIbktRa0xTZklyUjlVaUQzZ2FGNzBWZE84 ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "_token" => "eO6tq0iTNgig9XEibnBCh9zTcwwTE4Ir0hpCjwFP"
  "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/99z309233-3-function-semi-square-abs-hand-shower-brushed-copper"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (82.75%)	542.83ms
1 x Booting (17.22%)	112.97ms

3-Function Semi-Square ABS Hand Shower, Brushed Copper

Características técnicas

Products

Can We Help You?