Brass Eagle Showpieces - Majestic Home Decor

Messages Timeline Exceptions Views13 Route Queries26 Models51 Livewire1 Gate Session Request

8.2.0752ms2MBGET products/{slug}/{searchData?}

Booting (7.33ms)
Application (745ms)
1 x Application (99.02%)
744.93ms
1 x Booting (0.97%)
7.33ms

13 templates were rendered

productfilterstatic (resources/views/productfilterstatic.blade.php)4bladefile
Params
0
category
1
headers
2
count
3
wishlist_products

Params
0	`category`
1	`headers`
2	`count`
3	`wishlist_products`

livewire.sidebar (resources/views/livewire/sidebar.blade.php)19bladefile


prices
categoriesProductCount
attributes
subCategories
subcategoriesProductCount
errors
_instance
baseUrl
per_page
search
featured
selected
wishlistProducts
staticCategories
page
paginators
headers
count
wishlist_products

Params
0	`prices`
1	`categoriesProductCount`
2	`attributes`
3	`subCategories`
4	`subcategoriesProductCount`
5	`errors`
6	`_instance`
7	`baseUrl`
8	`per_page`
9	`search`
10	`featured`
11	`selected`
12	`wishlistProducts`
13	`staticCategories`
14	`page`
15	`paginators`
16	`headers`
17	`count`
18	`wishlist_products`

partials.filter (resources/views/partials/filter.blade.php)21bladefile


__env
app
errors
_instance
prices
categoriesProductCount
attributes
subCategories
subcategoriesProductCount
baseUrl
per_page
search
featured
selected
wishlistProducts
staticCategories
page
paginators
headers
count
wishlist_products

Params
0	`__env`
1	`app`
2	`errors`
3	`_instance`
4	`prices`
5	`categoriesProductCount`
6	`attributes`
7	`subCategories`
8	`subcategoriesProductCount`
9	`baseUrl`
10	`per_page`
11	`search`
12	`featured`
13	`selected`
14	`wishlistProducts`
15	`staticCategories`
16	`page`
17	`paginators`
18	`headers`
19	`count`
20	`wishlist_products`

partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)26bladefile


__env
app
errors
_instance
prices
categoriesProductCount
attributes
subCategories
subcategoriesProductCount
baseUrl
per_page
search
featured
selected
wishlistProducts
staticCategories
page
paginators
headers
count
wishlist_products
__currentLoopData
selectedCategory
loop
selectedCategoryData
product

Params
0	`__env`
1	`app`
2	`errors`
3	`_instance`
4	`prices`
5	`categoriesProductCount`
6	`attributes`
7	`subCategories`
8	`subcategoriesProductCount`
9	`baseUrl`
10	`per_page`
11	`search`
12	`featured`
13	`selected`
14	`wishlistProducts`
15	`staticCategories`
16	`page`
17	`paginators`
18	`headers`
19	`count`
20	`wishlist_products`
21	`__currentLoopData`
22	`selectedCategory`
23	`loop`
24	`selectedCategoryData`
25	`product`

filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)26bladefile


__env
app
errors
_instance
prices
categoriesProductCount
attributes
subCategories
subcategoriesProductCount
baseUrl
per_page
search
featured
selected
wishlistProducts
staticCategories
page
paginators
headers
count
wishlist_products
__currentLoopData
selectedCategory
loop
selectedCategoryData
product

Params
0	`__env`
1	`app`
2	`errors`
3	`_instance`
4	`prices`
5	`categoriesProductCount`
6	`attributes`
7	`subCategories`
8	`subcategoriesProductCount`
9	`baseUrl`
10	`per_page`
11	`search`
12	`featured`
13	`selected`
14	`wishlistProducts`
15	`staticCategories`
16	`page`
17	`paginators`
18	`headers`
19	`count`
20	`wishlist_products`
21	`__currentLoopData`
22	`selectedCategory`
23	`loop`
24	`selectedCategoryData`
25	`product`

partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)26bladefile


__env
app
errors
_instance
prices
categoriesProductCount
attributes
subCategories
subcategoriesProductCount
baseUrl
per_page
search
featured
selected
wishlistProducts
staticCategories
page
paginators
headers
count
wishlist_products
__currentLoopData
selectedCategory
loop
selectedCategoryData
product

Params
0	`__env`
1	`app`
2	`errors`
3	`_instance`
4	`prices`
5	`categoriesProductCount`
6	`attributes`
7	`subCategories`
8	`subcategoriesProductCount`
9	`baseUrl`
10	`per_page`
11	`search`
12	`featured`
13	`selected`
14	`wishlistProducts`
15	`staticCategories`
16	`page`
17	`paginators`
18	`headers`
19	`count`
20	`wishlist_products`
21	`__currentLoopData`
22	`selectedCategory`
23	`loop`
24	`selectedCategoryData`
25	`product`

filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)26bladefile


__env
app
errors
_instance
prices
categoriesProductCount
attributes
subCategories
subcategoriesProductCount
baseUrl
per_page
search
featured
selected
wishlistProducts
staticCategories
page
paginators
headers
count
wishlist_products
__currentLoopData
selectedCategory
loop
selectedCategoryData
product

Params
0	`__env`
1	`app`
2	`errors`
3	`_instance`
4	`prices`
5	`categoriesProductCount`
6	`attributes`
7	`subCategories`
8	`subcategoriesProductCount`
9	`baseUrl`
10	`per_page`
11	`search`
12	`featured`
13	`selected`
14	`wishlistProducts`
15	`staticCategories`
16	`page`
17	`paginators`
18	`headers`
19	`count`
20	`wishlist_products`
21	`__currentLoopData`
22	`selectedCategory`
23	`loop`
24	`selectedCategoryData`
25	`product`

partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)26bladefile


__env
app
errors
_instance
prices
categoriesProductCount
attributes
subCategories
subcategoriesProductCount
baseUrl
per_page
search
featured
selected
wishlistProducts
staticCategories
page
paginators
headers
count
wishlist_products
__currentLoopData
selectedCategory
loop
selectedCategoryData
product

Params
0	`__env`
1	`app`
2	`errors`
3	`_instance`
4	`prices`
5	`categoriesProductCount`
6	`attributes`
7	`subCategories`
8	`subcategoriesProductCount`
9	`baseUrl`
10	`per_page`
11	`search`
12	`featured`
13	`selected`
14	`wishlistProducts`
15	`staticCategories`
16	`page`
17	`paginators`
18	`headers`
19	`count`
20	`wishlist_products`
21	`__currentLoopData`
22	`selectedCategory`
23	`loop`
24	`selectedCategoryData`
25	`product`

filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)26bladefile


__env
app
errors
_instance
prices
categoriesProductCount
attributes
subCategories
subcategoriesProductCount
baseUrl
per_page
search
featured
selected
wishlistProducts
staticCategories
page
paginators
headers
count
wishlist_products
__currentLoopData
selectedCategory
loop
selectedCategoryData
product

Params
0	`__env`
1	`app`
2	`errors`
3	`_instance`
4	`prices`
5	`categoriesProductCount`
6	`attributes`
7	`subCategories`
8	`subcategoriesProductCount`
9	`baseUrl`
10	`per_page`
11	`search`
12	`featured`
13	`selected`
14	`wishlistProducts`
15	`staticCategories`
16	`page`
17	`paginators`
18	`headers`
19	`count`
20	`wishlist_products`
21	`__currentLoopData`
22	`selectedCategory`
23	`loop`
24	`selectedCategoryData`
25	`product`

partials.filterproductlisting (resources/views/partials/filterproductlisting.blade.php)26bladefile


__env
app
errors
_instance
prices
categoriesProductCount
attributes
subCategories
subcategoriesProductCount
baseUrl
per_page
search
featured
selected
wishlistProducts
staticCategories
page
paginators
headers
count
wishlist_products
__currentLoopData
selectedCategory
loop
selectedCategoryData
product

Params
0	`__env`
1	`app`
2	`errors`
3	`_instance`
4	`prices`
5	`categoriesProductCount`
6	`attributes`
7	`subCategories`
8	`subcategoriesProductCount`
9	`baseUrl`
10	`per_page`
11	`search`
12	`featured`
13	`selected`
14	`wishlistProducts`
15	`staticCategories`
16	`page`
17	`paginators`
18	`headers`
19	`count`
20	`wishlist_products`
21	`__currentLoopData`
22	`selectedCategory`
23	`loop`
24	`selectedCategoryData`
25	`product`

filterbarcode-wishlist (resources/views/filterbarcode-wishlist.blade.php)26bladefile


__env
app
errors
_instance
prices
categoriesProductCount
attributes
subCategories
subcategoriesProductCount
baseUrl
per_page
search
featured
selected
wishlistProducts
staticCategories
page
paginators
headers
count
wishlist_products
__currentLoopData
selectedCategory
loop
selectedCategoryData
product

pagination (resources/views/pagination.blade.php)5bladefile
Params
0
paginator
1
elements
2
headers
3
count
4
wishlist_products
layouts.master (resources/views/layouts/master.blade.php)10bladefile
Params
0
__env
1
app
2
errors
3
category
4
headers
5
count
6
wishlist_products
7
header
8
name
9
html

Params
0	`__env`
1	`app`
2	`errors`
3	`_instance`
4	`prices`
5	`categoriesProductCount`
6	`attributes`
7	`subCategories`
8	`subcategoriesProductCount`
9	`baseUrl`
10	`per_page`
11	`search`
12	`featured`
13	`selected`
14	`wishlistProducts`
15	`staticCategories`
16	`page`
17	`paginators`
18	`headers`
19	`count`
20	`wishlist_products`
21	`__currentLoopData`
22	`selectedCategory`
23	`loop`
24	`selectedCategoryData`
25	`product`

Params
0	`paginator`
1	`elements`
2	`headers`
3	`count`
4	`wishlist_products`

Params
0	`__env`
1	`app`
2	`errors`
3	`category`
4	`headers`
5	`count`
6	`wishlist_products`
7	`header`
8	`name`
9	`html`

uri: GET products/{slug}/{searchData?}
middleware: web, debug
controller: App\Http\Controllers\ProductController@index
namespace
prefix
where
as: products.index
file: app/Http/Controllers/ProductController.php:22-234

26 statements were executed, 2 of which were duplicated, 24 unique. Show only duplicated722ms

select * from `categories` where `slug` = 'eagle' limit 1

490μs/app/Http/Controllers/ProductController.php:24kapasi

Metadata
Bindings	0. eagle
Backtrace	15. /app/Http/Controllers/ProductController.php:24 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:259 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `categories` where `slug` = 'eagle' limit 1

390μs/app/Http/Livewire/Sidebar.php:59kapasi

Metadata
Bindings	0. eagle
Backtrace	15. /app/Http/Livewire/Sidebar.php:59 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 17. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 18. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

select `name`, `id` from `categories` where `top_cat_id` is null

460μs/app/Http/Livewire/Sidebar.php:87kapasi

Metadata
Backtrace	13. /app/Http/Livewire/Sidebar.php:87 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 15. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

select
CASE
WHEN price < 500 THEN "Less than 500"
WHEN price BETWEEN 500 AND 5000 THEN "500 - 5000"
WHEN price BETWEEN 5000 AND 10000 THEN "5000 - 10000"
WHEN price BETWEEN 10000 AND 20000 THEN "10000 - 20000"
ELSE "More than 20000"
END AS price_range,
COUNT(products.id) as products_count
from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(205, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1 group by `price_range`

52.63ms/app/Services/PriceService.php:65kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	14. /app/Services/PriceService.php:65 15. /app/Services/PriceService.php:36 16. /app/Http/Livewire/Sidebar.php:110 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41

select * from `categories` where `top_cat_id` in (46) and `active` = 1 order by `name` asc

1.3ms/app/Http/Livewire/Sidebar.php:120kapasi

Metadata
Bindings	0. 46 1. 1
Backtrace	14. /app/Http/Livewire/Sidebar.php:120 15. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 16. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93 18. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(203, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

32.07ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(210, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

26.58ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(198, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

42.66ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(211, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

26.89ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(200, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

27.7ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(205, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

26.44ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(194, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

29.57ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(209, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

26.77ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(202, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

35.4ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(197, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

28.39ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(214, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

27ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(213, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

27.34ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(206, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

27.99ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(196, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

27.1ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(199, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

27.79ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(212, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

26.99ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select count(distinct `products`.`id`) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(195, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

27.76ms/app/Models/Category.php:50kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Models/Category.php:50 16. /app/Http/Livewire/Sidebar.php:154 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 18. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93

select `attribute_name`, TRIM(value) as value, COUNT(distinct(product_id)) as product_count from `products_filter_attribute` where `active` = 1 and exists (select * from `products` where `products_filter_attribute`.`product_id` = `products`.`id` and exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(205, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1 and `active` = 1) group by `attribute_name`, `value` order by CASE
WHEN attribute_name = 'Material' THEN 1
WHEN attribute_name = 'Size' THEN 2
WHEN attribute_name = 'Finishing / Polishing' THEN 3
WHEN attribute_name = 'Availability' THEN 4
WHEN attribute_name = 'Occasion' THEN 5
WHEN attribute_name = 'Special features' THEN 6
ELSE 7 END

77.99ms/app/Http/Livewire/Sidebar.php:196kapasi

Metadata
Bindings	0. 1 1. 1 2. 3. 4. 1 5. 1
Backtrace	14. /app/Http/Livewire/Sidebar.php:196 15. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 16. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 17. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93 18. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

select `id` from `categories` where `top_cat_id` = 46

510μs/app/Http/Livewire/Sidebar.php:240kapasi

Metadata
Bindings	0. 46
Backtrace	13. /app/Http/Livewire/Sidebar.php:240 14. /app/Http/Livewire/Sidebar.php:246 15. /app/Http/Livewire/Sidebar.php:203 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 17. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41

select count(*) as aggregate from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(205, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1

27.03ms/app/Http/Livewire/Sidebar.php:232kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Http/Livewire/Sidebar.php:232 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 17. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 18. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

select distinct * from `products` where exists (select * from `products_filter_attribute` where `products`.`id` = `products_filter_attribute`.`product_id` and (FIND_IN_SET(205, categories_ids)) and `active` = 1) and `products`.`name` != '' and `products`.`slug` != '' and `products`.`active` = 1 order by `audit_created_date` desc, `id` desc limit 12 offset 0

66.86ms/app/Http/Livewire/Sidebar.php:232kapasi

Metadata
Bindings	0. 1 1. 2. 3. 1
Backtrace	15. /app/Http/Livewire/Sidebar.php:232 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 17. /vendor/laravel/framework/src/Illuminate/Container/Util.php:41 18. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93 19. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

App\Models\ProductsFilterAttribute: 5
App\Models\Product: 6
App\Models\Category: 40

sidebar #RGyw6az2m5xL854G1S9j: array:5 [ "data" => array:9 [ "baseUrl" => "https://kapasi-com-new.webmavens.com/products/eagl...

_token: gCb58jsBAHuHgtCVUMeWSnudqhkFZidQyGkmhbgB
_previous: array:1 [ "url" => "https://kapasi-com-new.webmavens.com/products/eagle/1" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/products/eagle/1

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:17 [▼
  "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"
  ]
  "host" => array:1 [▶
    0 => "kapasi-com-new.webmavens.com"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]

request_server

  0 of 0   
array:40 [▼
  "USER" => "forge"
  "HOME" => "/home/forge"
  "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_HOST" => "kapasi-com-new.webmavens.com"
  "REDIRECT_STATUS" => "200"
  "HTTPS" => "on"
  "SERVER_NAME" => "kapasi-com-new.webmavens.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "161.35.1.11"
  "REMOTE_PORT" => "13435"
  "REMOTE_ADDR" => "13.59.18.177"
  "SERVER_SOFTWARE" => "nginx/1.18.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "DOCUMENT_ROOT" => "/home/forge/kapasi-com-new.webmavens.com/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/products/eagle/1"
  "SCRIPT_NAME" => "/index.php"
  "SCRIPT_FILENAME" => "/home/forge/kapasi-com-new.webmavens.com/public/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743851156.7048
  "REQUEST_TIME" => 1743851156
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "max-age=0, must-revalidate, no-cache, no-store, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 05 Apr 2025 11:05:56 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "Fri, 01 Jan 1990 00:00:00 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImYyRmVrUUdwN1lnYUZhUE9qODlXTXc9PSIsInZhbHVlIjoiSlZsR29EbWdGUWU1ODQ1Z3BEeEVKcElsS2JsNTVnaGtIVDR2NVJwblhGN0dKT2J1M09oU3h0cGRWUVJOdWJsZWYwRjNTK0hGSUdKc3dIZ1ROdFpXRndvTElFMWlMbHo2RDY5VGxSN1BVeXl0enhkSGxCSVlGb212UGhkZjhobjYiLCJtYWMiOiJiNjAwYmIyYWEyYWNjMWM1ZGMxMmM1OGViYTM3NGJhODQ2MGE5OTZhNTk4NGNkMGRhM2U3NDNmZmRjZTE2YWEyIiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 13:05:57 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImYyRmVrUUdwN1lnYUZhUE9qODlXTXc9PSIsInZhbHVlIjoiSlZsR29EbWdGUWU1ODQ1Z3BEeEVKcElsS2JsNTVnaGtIVDR2NVJwblhGN0dKT2J1M09oU3h0cGRWUVJOdWJsZWYwRjNTK ▶"
    1 => "kapasi_session=eyJpdiI6IitQY0E0NDNIRzdPMVFEQVFGSXNSQnc9PSIsInZhbHVlIjoiMjdkQnpSWEsyVWIzWitpRFdveG5sZTBRWTk0Vk1zV2V2UC9Jazh5UWcyOElHT0lXcFpGVTJWelNMVElQZGR4NWljcFpoTnZYNFptT2czVVozVmtVNjlGSnpYQ1ludUNNcjkwVUoxTUNIMjNpbDRyNUZGOVY4ekhTVnlXWElGREwiLCJtYWMiOiJmM2E0ZjYxZmM3NjExMTM4ZDI3OWRiMGM5OGRhMDY5MTc3YjBiZWRiYWZiOTc5ZDljZTFmYzMwN2MxMjgxMzU1IiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 13:05:57 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀kapasi_session=eyJpdiI6IitQY0E0NDNIRzdPMVFEQVFGSXNSQnc9PSIsInZhbHVlIjoiMjdkQnpSWEsyVWIzWitpRFdveG5sZTBRWTk0Vk1zV2V2UC9Jazh5UWcyOElHT0lXcFpGVTJWelNMVElQZGR4NWljc ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImYyRmVrUUdwN1lnYUZhUE9qODlXTXc9PSIsInZhbHVlIjoiSlZsR29EbWdGUWU1ODQ1Z3BEeEVKcElsS2JsNTVnaGtIVDR2NVJwblhGN0dKT2J1M09oU3h0cGRWUVJOdWJsZWYwRjNTK0hGSUdKc3dIZ1ROdFpXRndvTElFMWlMbHo2RDY5VGxSN1BVeXl0enhkSGxCSVlGb212UGhkZjhobjYiLCJtYWMiOiJiNjAwYmIyYWEyYWNjMWM1ZGMxMmM1OGViYTM3NGJhODQ2MGE5OTZhNTk4NGNkMGRhM2U3NDNmZmRjZTE2YWEyIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 13:05:57 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImYyRmVrUUdwN1lnYUZhUE9qODlXTXc9PSIsInZhbHVlIjoiSlZsR29EbWdGUWU1ODQ1Z3BEeEVKcElsS2JsNTVnaGtIVDR2NVJwblhGN0dKT2J1M09oU3h0cGRWUVJOdWJsZWYwRjNTK ▶"
    1 => "kapasi_session=eyJpdiI6IitQY0E0NDNIRzdPMVFEQVFGSXNSQnc9PSIsInZhbHVlIjoiMjdkQnpSWEsyVWIzWitpRFdveG5sZTBRWTk0Vk1zV2V2UC9Jazh5UWcyOElHT0lXcFpGVTJWelNMVElQZGR4NWljcFpoTnZYNFptT2czVVozVmtVNjlGSnpYQ1ludUNNcjkwVUoxTUNIMjNpbDRyNUZGOVY4ekhTVnlXWElGREwiLCJtYWMiOiJmM2E0ZjYxZmM3NjExMTM4ZDI3OWRiMGM5OGRhMDY5MTc3YjBiZWRiYWZiOTc5ZDljZTFmYzMwN2MxMjgxMzU1IiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 13:05:57 GMT; path=/; httponly ◀kapasi_session=eyJpdiI6IitQY0E0NDNIRzdPMVFEQVFGSXNSQnc9PSIsInZhbHVlIjoiMjdkQnpSWEsyVWIzWitpRFdveG5sZTBRWTk0Vk1zV2V2UC9Jazh5UWcyOElHT0lXcFpGVTJWelNMVElQZGR4NWljc ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "gCb58jsBAHuHgtCVUMeWSnudqhkFZidQyGkmhbgB"
  "_previous" => array:1 [▶
    "url" => "https://kapasi-com-new.webmavens.com/products/eagle/1"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (99.02%)	744.93ms
1 x Booting (0.97%)	7.33ms