Poundex Associates Corporation

Messages1 Timeline Exceptions Views33 Route Queries59 Models150 Gate Session Request

8.2.27137ms4MBGET product

infolog[14:53:12] LOG.info: unauthentication data

Booting (46.12ms)
Application (91.14ms)
1 x Application (66.39%)
91.14ms
1 x Booting (33.59%)
46.12ms

33 templates were rendered

dealer-portal.product (resources/views/dealer-portal/product.blade.php)8bladefile


slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort

Params
0	`slugData`
1	`mainCategory`
2	`products`
3	`productCount`
4	`paginatedProduct`
5	`poundexSettings`
6	`companyListing`
7	`productSort`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

dealer-portal.globalSingleProductCard (resources/views/dealer-portal/globalSingleProductCard.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

pagination.custom_pagination (resources/views/pagination/custom_pagination.blade.php)3bladefile
Params
0
slug
1
paginator
2
elements

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

Params
0	`slug`
1	`paginator`
2	`elements`

layout (resources/views/layout.blade.php)17bladefile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

partials.dealerPortalAlgoliaSearch (resources/views/partials/dealerPortalAlgoliaSearch.php)17phpfile


__env
app
errors
categories
dealerGuide
__sentry_tracing_view_name
slugData
mainCategory
products
productCount
paginatedProduct
poundexSettings
companyListing
productSort
__currentLoopData
product
loop

prelogin.menus (resources/views/prelogin/menus.blade.php)2bladefile
Params
0
items
1
options
voyager::menu.default (vendor/tcg/voyager/resources/views/menu/default.blade.php)3bladefile
Params
0
items
1
options
2
alerts
voyager::menu.default (vendor/tcg/voyager/resources/views/menu/default.blade.php)3bladefile
Params
0
items
1
options
2
alerts
voyager::menu.default (vendor/tcg/voyager/resources/views/menu/default.blade.php)3bladefile
Params
0
items
1
options
2
alerts

Params
0	`__env`
1	`app`
2	`errors`
3	`categories`
4	`dealerGuide`
5	`__sentry_tracing_view_name`
6	`slugData`
7	`mainCategory`
8	`products`
9	`productCount`
10	`paginatedProduct`
11	`poundexSettings`
12	`companyListing`
13	`productSort`
14	`__currentLoopData`
15	`product`
16	`loop`

Params
0	`items`
1	`options`

Params
0	`items`
1	`options`
2	`alerts`

Params
0	`items`
1	`options`
2	`alerts`

Params
0	`items`
1	`options`
2	`alerts`

uri: GET product
middleware: web, check_two_factor, shareData
controller: App\Http\Controllers\DealerPortal\ProductController@index
namespace: App\Http\Controllers
prefix
where
as: product.index
file: app/Http/Controllers/DealerPortal/ProductController.php:39-73

59 statements were executed45.3ms

select * from `category` where (`active` = 1 and `level` = 'main') order by `order` asc

290μsmiddleware::shareData:94poundex

Metadata
Bindings	0. 1 1. main
Backtrace	15. middleware::shareData:94 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 17. middleware::check_two_factor:29 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 19. /app/Http/Middleware/TrackLinks.php:25

select * from `category` where (`active` = 1 and `level` = 'sub') order by `order` asc

360μsmiddleware::shareData:95poundex

Metadata
Bindings	0. 1 1. sub
Backtrace	15. middleware::shareData:95 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 17. middleware::check_two_factor:29 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 19. /app/Http/Middleware/TrackLinks.php:25

select * from `dealer_guides` where (`file_type` = 'Flipbook' and `active` = 1) order by `id` desc

220μsmiddleware::shareData:96poundex

Metadata
Bindings	0. Flipbook 1. 1
Backtrace	15. middleware::shareData:96 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 17. middleware::check_two_factor:29 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 19. /app/Http/Middleware/TrackLinks.php:25

select * from `poundex_settings` where `id` = 1 limit 1

730μs/app/Http/Controllers/DealerPortal/ProductController.php:47poundex

Metadata
Bindings	0. 1
Backtrace	16. /app/Http/Controllers/DealerPortal/ProductController.php:47 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 20. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

Metadata

Bindings

0. 1

Backtrace

16. /app/Http/Controllers/DealerPortal/ProductController.php:47
17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
19. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21
20. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select * from `category` where (`active` = 1 and `slug` = 'counter_height_dining') limit 1

200μs/app/Category.php:55poundex

Metadata
Bindings	0. 1 1. counter_height_dining
Backtrace	17. /app/Category.php:55 18. /app/Http/Controllers/DealerPortal/ProductController.php:49 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select * from `category` where (`active` = 1 and `level` = 'main' and `id` = 4) limit 1

190μs/app/Category.php:60poundex

Metadata
Bindings	0. 1 1. main 2. 4
Backtrace	16. /app/Category.php:60 17. /app/Http/Controllers/DealerPortal/ProductController.php:50 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select count(*) as aggregate from `products` inner join `product_boxes` on `product_boxes`.`product_id` = `products`.`id` where (`products`.`category_id` = 22 and `products`.`in_catalog` = 1 and `products`.`product_view` = 'available') and `product_boxes`.`parent_child` = 'p'

3.3ms/app/Product.php:217poundex

Metadata
Bindings	0. 22 1. 1 2. available 3. p
Backtrace	16. /app/Product.php:217 17. /app/Http/Controllers/DealerPortal/ProductController.php:53 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select distinct `products`.`id` as `product_id`, `products`.`name`, `products`.`slug`, `products`.`image`, `products`.`item_number`, `products`.`base_price`, `products`.`quantity`, `products`.`block_cart_view`, `products`.`product_view`, `products`.`in_catalog`, `products`.`unit_per_case`, CASE
WHEN "2025-04-04" >= products.discounted_start_date
AND (products.discounted_end_date IS NULL OR "2025-04-04" <= products.discounted_end_date)
THEN round(products.discounted_percentage,0)
ELSE 0
END AS discounted_percentage, CASE
WHEN "2025-04-04" >= products.discounted_start_date
AND (products.discounted_end_date IS NULL OR "2025-04-04" <= products.discounted_end_date)
AND products.discounted_price < products.base_price
THEN products.discounted_price
ELSE 0
END AS discounted_price, CASE
WHEN "2025-04-04" >= products.discounted_start_date
AND (products.discounted_end_date IS NULL OR "2025-04-04" <= products.discounted_end_date)
AND products.discounted_price < products.base_price
THEN products.discounted_price
ELSE products.base_price
END AS final_price from `products` inner join `product_boxes` on `product_boxes`.`product_id` = `products`.`id` where (`products`.`category_id` = 22 and `products`.`in_catalog` = 1 and `products`.`product_view` = 'available') and `product_boxes`.`parent_child` = 'p' order by `products`.`item_number` asc limit 30 offset 0

5.29ms/app/Product.php:217poundex

Metadata
Bindings	0. 22 1. 1 2. available 3. p
Backtrace	16. /app/Product.php:217 17. /app/Http/Controllers/DealerPortal/ProductController.php:53 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

select `created_at`, `featured` from `products` where `item_number` = 'F1809' limit 1

560μs/app/helpers.php:443poundex

Metadata
Bindings	0. F1809
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F1809' limit 1

280μs/app/helpers.php:448poundex

Metadata
Bindings	0. F1809
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F1824' limit 1

490μs/app/helpers.php:443poundex

Metadata
Bindings	0. F1824
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F1824' limit 1

260μs/app/helpers.php:448poundex

Metadata
Bindings	0. F1824
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F1837' limit 1

1.01ms/app/helpers.php:443poundex

Metadata
Bindings	0. F1837
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F1837' limit 1

710μs/app/helpers.php:448poundex

Metadata
Bindings	0. F1837
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F1876' limit 1

530μs/app/helpers.php:443poundex

Metadata
Bindings	0. F1876
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F1876' limit 1

260μs/app/helpers.php:448poundex

Metadata
Bindings	0. F1876
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F1901' limit 1

590μs/app/helpers.php:443poundex

Metadata
Bindings	0. F1901
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F1901' limit 1

810μs/app/helpers.php:448poundex

Metadata
Bindings	0. F1901
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F1902' limit 1

560μs/app/helpers.php:443poundex

Metadata
Bindings	0. F1902
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F1902' limit 1

260μs/app/helpers.php:448poundex

Metadata
Bindings	0. F1902
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2208' limit 1

1.01ms/app/helpers.php:443poundex

Metadata
Bindings	0. F2208
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2208' limit 1

280μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2208
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2238' limit 1

1ms/app/helpers.php:443poundex

Metadata
Bindings	0. F2238
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2238' limit 1

290μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2238
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2273' limit 1

620μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2273
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2273' limit 1

270μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2273
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2291' limit 1

1.61ms/app/helpers.php:443poundex

Metadata
Bindings	0. F2291
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2291' limit 1

280μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2291
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2329' limit 1

700μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2329
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2329' limit 1

310μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2329
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2339' limit 1

640μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2339
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2339' limit 1

260μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2339
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2345' limit 1

1.08ms/app/helpers.php:443poundex

Metadata
Bindings	0. F2345
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2345' limit 1

300μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2345
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2347' limit 1

670μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2347
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2347' limit 1

270μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2347
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2399' limit 1

1.55ms/app/helpers.php:443poundex

Metadata
Bindings	0. F2399
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2399' limit 1

280μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2399
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2461' limit 1

1.44ms/app/helpers.php:443poundex

Metadata
Bindings	0. F2461
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2461' limit 1

270μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2461
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2488' limit 1

760μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2488
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2488' limit 1

1.18ms/app/helpers.php:448poundex

Metadata
Bindings	0. F2488
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2495' limit 1

680μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2495
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2495' limit 1

1.19ms/app/helpers.php:448poundex

Metadata
Bindings	0. F2495
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2543' limit 1

690μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2543
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2543' limit 1

270μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2543
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2552' limit 1

2.07ms/app/helpers.php:443poundex

Metadata
Bindings	0. F2552
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2552' limit 1

150μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2552
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2568' limit 1

580μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2568
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2568' limit 1

150μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2568
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2569' limit 1

590μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2569
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2569' limit 1

170μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2569
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2579' limit 1

2.05ms/app/helpers.php:443poundex

Metadata
Bindings	0. F2579
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2579' limit 1

140μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2579
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2595' limit 1

600μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2595
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2595' limit 1

170μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2595
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `created_at`, `featured` from `products` where `item_number` = 'F2604' limit 1

590μs/app/helpers.php:443poundex

Metadata
Bindings	0. F2604
Backtrace	16. /app/helpers.php:443 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select `id` from `product_bestsellers` where `item_number` = 'F2604' limit 1

150μs/app/helpers.php:448poundex

Metadata
Bindings	0. F2604
Backtrace	16. /app/helpers.php:448 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 21. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21 22. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingRoutingDispatcher.php:19

select CASE
WHEN "2025-04-04" >= products.discounted_start_date
AND (products.discounted_end_date IS NULL OR "2025-04-04" <= products.discounted_end_date)
AND products.discounted_price < products.base_price
THEN products.discounted_price
ELSE products.base_price
END AS final_price from `products` inner join `product_boxes` on `product_boxes`.`product_id` = `products`.`id` where (`products`.`category_id` = 22 and `products`.`in_catalog` = 1 and `products`.`product_view` = 'available') and `product_boxes`.`parent_child` = 'p'

3.09ms/app/Product.php:246poundex

Metadata
Bindings	0. 22 1. 1 2. available 3. p
Backtrace	15. /app/Product.php:246 16. /app/Http/Controllers/DealerPortal/ProductController.php:58 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. /vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/Routing/TracingControllerDispatcherTracing.php:21

App\ProductBestseller: 4
App\Product: 75
App\PoundexSetting: 1
App\DealerGuide: 3
App\Category: 67

_token: KzPrfkb9r7avUMje1w09Zc35YuO08o2HD7c4cPkZ
links: array:1 [ 0 => "http://bobkonaonline.com/product?slug=counter_height_dining" ]
_previous: array:1 [ "url" => "http://bobkonaonline.com/product?slug=counter_height_dining" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

telescope

View in Telescope

path_info

/product

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "slug" => "counter_height_dining"
]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "connection" => array:1 [▶
    0 => "upgrade"
  ]
  "host" => array:1 [▶
    0 => "bobkonaonline.com"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "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"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]

request_server

  0 of 0   
array:43 [▼
  "REDIRECT_UNIQUE_ID" => "Z_BUyLogKYR5CnoB6tyl6wAAAAs"
  "REDIRECT_STATUS" => "200"
  "UNIQUE_ID" => "Z_BUyLogKYR5CnoB6tyl6wAAAAs"
  "HTTP_CONNECTION" => "upgrade"
  "HTTP_HOST" => "bobkonaonline.com"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "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_SEC_FETCH_SITE" => "none"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin"
  "SERVER_SIGNATURE" => ""
  "SERVER_SOFTWARE" => "Apache/2.4.62 () OpenSSL/1.0.2k-fips PHP/8.2.27"
  "SERVER_NAME" => "bobkonaonline.com"
  "SERVER_ADDR" => "127.0.0.1"
  "SERVER_PORT" => "80"
  "REMOTE_ADDR" => "127.0.0.1"
  "DOCUMENT_ROOT" => "/home/poundex-staging/laravel-ecommerce/public/"
  "REQUEST_SCHEME" => "http"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/home/poundex-staging/laravel-ecommerce/public/"
  "SERVER_ADMIN" => "root@localhost"
  "SCRIPT_FILENAME" => "/home/poundex-staging/laravel-ecommerce/public/index.php"
  "REMOTE_PORT" => "51802"
  "REDIRECT_URL" => "/product"
  "REDIRECT_QUERY_STRING" => "slug=counter_height_dining"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "slug=counter_height_dining"
  "REQUEST_URI" => "/product?slug=counter_height_dining"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743803592.5047
  "REQUEST_TIME" => 1743803592
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 04 Apr 2025 21:53:12 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpBeXpwMWJxRUYwdGFXcGt0bXNzL1E9PSIsInZhbHVlIjoiYzgrM0UzMytTNjJGd0p5QnV0SklPTzhBck5DemdKTXhVVTVjcEdOUGtETjhMV2pXenl4ek01UjZYRElEUmdUNTdIZWhWVTJPZ1dXRGgybElVMGNUTEsvdzFZQkprK3kxOXRFNUpsSGZvN0NRVEJhd3EvakZ2bnBveUNlRC9EcjciLCJtYWMiOiIwMWE1YzhlZGY4Zjg1NzcyYjE4OGFhZWQ1YjMwYmVhOWYxZGJkMDZiNDNkMjFlNDA0ODk1Y2NkYTY3MTMwN2QyIiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 22:08:12 GMT; Max-Age=900; path=/ ◀XSRF-TOKEN=eyJpdiI6ImpBeXpwMWJxRUYwdGFXcGt0bXNzL1E9PSIsInZhbHVlIjoiYzgrM0UzMytTNjJGd0p5QnV0SklPTzhBck5DemdKTXhVVTVjcEdOUGtETjhMV2pXenl4ek01UjZYRElEUmdUNTdIZWhWV ▶"
    1 => "poundex_associates_corporation_session=eyJpdiI6IkFBTEpETTBpVEV4R0p5ZTZYS01OR3c9PSIsInZhbHVlIjoiM0tzbU9QdDMvVUlGT0J5QjcyV0l0TnBKcm1DeFFCNlFpM0RkMTRoY0VLT21ONHhjdjBGQXpPbEg2ZkR6RlpVWWszQmZPQXB1TG8wRm01ZjdhVW54eXFRQmtjNE5CZWRzbWNseHJQN2VxeFpvNC9YUXByKzZuaHV4dkJkcDdlSmsiLCJtYWMiOiJmODdjYzNhODJkZjJhYzgyYzY5ZDRlZWJiOTVkYjMxOTQ3YjIwMTVkNzU0ZWQ4MGNiYTE3NWY1YzVlYTNkNmY1IiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 22:08:12 GMT; Max-Age=900; path=/; httponly ◀poundex_associates_corporation_session=eyJpdiI6IkFBTEpETTBpVEV4R0p5ZTZYS01OR3c9PSIsInZhbHVlIjoiM0tzbU9QdDMvVUlGT0J5QjcyV0l0TnBKcm1DeFFCNlFpM0RkMTRoY0VLT21ONHhjd ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpBeXpwMWJxRUYwdGFXcGt0bXNzL1E9PSIsInZhbHVlIjoiYzgrM0UzMytTNjJGd0p5QnV0SklPTzhBck5DemdKTXhVVTVjcEdOUGtETjhMV2pXenl4ek01UjZYRElEUmdUNTdIZWhWVTJPZ1dXRGgybElVMGNUTEsvdzFZQkprK3kxOXRFNUpsSGZvN0NRVEJhd3EvakZ2bnBveUNlRC9EcjciLCJtYWMiOiIwMWE1YzhlZGY4Zjg1NzcyYjE4OGFhZWQ1YjMwYmVhOWYxZGJkMDZiNDNkMjFlNDA0ODk1Y2NkYTY3MTMwN2QyIiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 22:08:12 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImpBeXpwMWJxRUYwdGFXcGt0bXNzL1E9PSIsInZhbHVlIjoiYzgrM0UzMytTNjJGd0p5QnV0SklPTzhBck5DemdKTXhVVTVjcEdOUGtETjhMV2pXenl4ek01UjZYRElEUmdUNTdIZWhWV ▶"
    1 => "poundex_associates_corporation_session=eyJpdiI6IkFBTEpETTBpVEV4R0p5ZTZYS01OR3c9PSIsInZhbHVlIjoiM0tzbU9QdDMvVUlGT0J5QjcyV0l0TnBKcm1DeFFCNlFpM0RkMTRoY0VLT21ONHhjdjBGQXpPbEg2ZkR6RlpVWWszQmZPQXB1TG8wRm01ZjdhVW54eXFRQmtjNE5CZWRzbWNseHJQN2VxeFpvNC9YUXByKzZuaHV4dkJkcDdlSmsiLCJtYWMiOiJmODdjYzNhODJkZjJhYzgyYzY5ZDRlZWJiOTVkYjMxOTQ3YjIwMTVkNzU0ZWQ4MGNiYTE3NWY1YzVlYTNkNmY1IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 22:08:12 GMT; path=/; httponly ◀poundex_associates_corporation_session=eyJpdiI6IkFBTEpETTBpVEV4R0p5ZTZYS01OR3c9PSIsInZhbHVlIjoiM0tzbU9QdDMvVUlGT0J5QjcyV0l0TnBKcm1DeFFCNlFpM0RkMTRoY0VLT21ONHhjd ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "KzPrfkb9r7avUMje1w09Zc35YuO08o2HD7c4cPkZ"
  "links" => array:1 [▶
    0 => "http://bobkonaonline.com/product?slug=counter_height_dining"
  ]
  "_previous" => array:1 [▶
    "url" => "http://bobkonaonline.com/product?slug=counter_height_dining"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (66.39%)	91.14ms
1 x Booting (33.59%)	46.12ms

Counter Height Dining (25 Products)