POUNDEX SELLS EXCLUSIVELY TO BUSINESS PARTNERS, NOT THE GENERAL PUBLIC.

Mirror (38 Products)

8.2.27PHP Version83.64msRequest Duration4MBMemory UsageGET productRoute
  • infolog[09:26:59] LOG.info: unauthentication data
  • Booting (31.48ms)
  • Application (52.12ms)
  • 1 x Application (62.31%)
    52.12ms
    1 x Booting (37.64%)
    31.48ms
    16 templates were rendered
    • dealer-portal.product (resources/views/dealer-portal/product.blade.php)8bladefile
      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
      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
      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
      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
      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
      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
      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
      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
      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
    • pagination.custom_pagination (resources/views/pagination/custom_pagination.blade.php)3bladefile
      Params
      0
      slug
      1
      paginator
      2
      elements
    • layout (resources/views/layout.blade.php)17bladefile
      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
      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
    • 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
    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
    25 statements were executed24.19ms
    • select * from `category` where (`active` = 1 and `level` = 'main') order by `order` asc
      280μ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
      320μ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
      190μ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
      190μ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
    • select * from `category` where (`active` = 1 and `slug` = 'mirror') limit 1
      190μs/app/Category.php:55poundex
      Metadata
      Bindings
      • 0. 1
      • 1. mirror
      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` = 6) limit 1
      160μs/app/Category.php:60poundex
      Metadata
      Bindings
      • 0. 1
      • 1. main
      • 2. 6
      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` = 33 and `products`.`in_catalog` = 1 and `products`.`product_view` = 'available') and `product_boxes`.`parent_child` = 'p'
      3.77ms/app/Product.php:217poundex
      Metadata
      Bindings
      • 0. 33
      • 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-09" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-09" <= products.discounted_end_date) THEN round(products.discounted_percentage,0) ELSE 0 END AS discounted_percentage, CASE WHEN "2025-04-09" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-09" <= 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-09" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-09" <= 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` = 33 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 30
      5.43ms/app/Product.php:217poundex
      Metadata
      Bindings
      • 0. 33
      • 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` = 'F5482' limit 1
      930μs/app/helpers.php:443poundex
      Metadata
      Bindings
      • 0. F5482
      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` = 'F5482' limit 1
      150μs/app/helpers.php:448poundex
      Metadata
      Bindings
      • 0. F5482
      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` = 'F5487' limit 1
      1.84ms/app/helpers.php:443poundex
      Metadata
      Bindings
      • 0. F5487
      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` = 'F5487' limit 1
      150μs/app/helpers.php:448poundex
      Metadata
      Bindings
      • 0. F5487
      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` = 'F5492' limit 1
      910μs/app/helpers.php:443poundex
      Metadata
      Bindings
      • 0. F5492
      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` = 'F5492' limit 1
      140μs/app/helpers.php:448poundex
      Metadata
      Bindings
      • 0. F5492
      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` = 'F5497' limit 1
      890μs/app/helpers.php:443poundex
      Metadata
      Bindings
      • 0. F5497
      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` = 'F5497' limit 1
      160μs/app/helpers.php:448poundex
      Metadata
      Bindings
      • 0. F5497
      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` = 'F5502' limit 1
      1.35ms/app/helpers.php:443poundex
      Metadata
      Bindings
      • 0. F5502
      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` = 'F5502' limit 1
      140μs/app/helpers.php:448poundex
      Metadata
      Bindings
      • 0. F5502
      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` = 'F5507' limit 1
      910μs/app/helpers.php:443poundex
      Metadata
      Bindings
      • 0. F5507
      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` = 'F5507' limit 1
      140μs/app/helpers.php:448poundex
      Metadata
      Bindings
      • 0. F5507
      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` = 'F5512' limit 1
      960μs/app/helpers.php:443poundex
      Metadata
      Bindings
      • 0. F5512
      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` = 'F5512' limit 1
      160μs/app/helpers.php:448poundex
      Metadata
      Bindings
      • 0. F5512
      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` = 'F5517' limit 1
      930μs/app/helpers.php:443poundex
      Metadata
      Bindings
      • 0. F5517
      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` = 'F5517' limit 1
      170μs/app/helpers.php:448poundex
      Metadata
      Bindings
      • 0. F5517
      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-09" >= products.discounted_start_date AND (products.discounted_end_date IS NULL OR "2025-04-09" <= 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` = 33 and `products`.`in_catalog` = 1 and `products`.`product_view` = 'available') and `product_boxes`.`parent_child` = 'p'
      3.73ms/app/Product.php:246poundex
      Metadata
      Bindings
      • 0. 33
      • 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\Product
    54
    App\PoundexSetting
    1
    App\DealerGuide
    3
    App\Category
    67
      _token
      uM0Fj7rR2I1yLNAeVK1dKGkynBdgDfo3aNQcugKF
      links
      array:1 [ 0 => "http://bobkonaonline.com/product?page=2&slug=mirror" ]
      _previous
      array:1 [ "url" => "http://bobkonaonline.com/product?page=2&slug=mirror" ]
      _flash
      array:2 [ "old" => [] "new" => [] ]
      PHPDEBUGBAR_STACK_DATA
      []
      telescope
      View in Telescope
      path_info
      /product
      status_code
      200
      
      status_text
      OK
      format
      html
      content_type
      text/html; charset=UTF-8
      request_query
      0 of 0
      array:2 [ "page" => "2" "slug" => "mirror" ]
      request_request
      []
      
      request_headers
      0 of 0
      array:8 [ "host" => array:1 [ 0 => "bobkonaonline.com" ] "connection" => array:1 [ 0 => "keep-alive" ] "pragma" => array:1 [ 0 => "no-cache" ] "cache-control" => array:1 [ 0 => "no-cache" ] "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" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] ]
      request_server
      0 of 0
      array:36 [ "REDIRECT_UNIQUE_ID" => "Z_af04hqpF9Cx26H7XIQHwAAACQ" "REDIRECT_STATUS" => "200" "UNIQUE_ID" => "Z_af04hqpF9Cx26H7XIQHwAAACQ" "HTTP_HOST" => "bobkonaonline.com" "HTTP_CONNECTION" => "keep-alive" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "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_ACCEPT_ENCODING" => "gzip, deflate" "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" => "172.31.7.4" "SERVER_PORT" => "80" "REMOTE_ADDR" => "13.58.68.83" "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" => "21087" "REDIRECT_URL" => "/product" "REDIRECT_QUERY_STRING" => "page=2&slug=mirror" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "page=2&slug=mirror" "REQUEST_URI" => "/product?page=2&slug=mirror" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744216019.2526 "REQUEST_TIME" => 1744216019 ]
      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 => "Wed, 09 Apr 2025 16:26:59 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlU0QXltVW9yNHh4OHFHK1JQQktWSWc9PSIsInZhbHVlIjoiRkx6dkZFV1ErYnMrMERSaGRDVjFvd1lxS0tKbGhUMlNjZExqN3h1RWdmR1ZqdFFwMGJ2am1XWXlaak5HTmdzMzF1TnRKQkpEWUJHN3Y0ck1zOHpPdUFmVG91amNnaWFxaWIzNkNXODVhZDFxeEtvWUVsVjQ0SGRvajRpZmxNaFciLCJtYWMiOiJhMWY0NGZiYzMyZGVlMTUyZmIxYzIyNjUyYmY2NmFiMjRhNjA4MDcyOTEyYmQ1ZGZmMDE4MjdlNGY0M2JkOTU0IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 16:41:59 GMT; Max-Age=900; path=/XSRF-TOKEN=eyJpdiI6IlU0QXltVW9yNHh4OHFHK1JQQktWSWc9PSIsInZhbHVlIjoiRkx6dkZFV1ErYnMrMERSaGRDVjFvd1lxS0tKbGhUMlNjZExqN3h1RWdmR1ZqdFFwMGJ2am1XWXlaak5HTmdzMzF1TnRKQ" 1 => "poundex_associates_corporation_session=eyJpdiI6IlQzMEJmZHlUTzZsbnBoZkVnVjFpQnc9PSIsInZhbHVlIjoiN0Z1bDQxTXpIeGdQZ2VHWVo3ZGM3bEZuNFpDbEM5RDM2aC95SDJiMmlkZzhqeDVWZ2pOV2ltWnVPYmdlejk0cVgwTTZWNWhhYkdGUkUyelpSQ05NcHRqQlVScW1FMFc0a3FIY3FWRXkyK1BSV09lQUVGNVZaeHZ5VXl0SUNIQ0EiLCJtYWMiOiI0ZTdkNGE5NDA4ZGVjODE1YTgwZWExM2MwMWZjZTRmMmYxZDYxNTVhMThlNTM0MmFkOGY4YWQxNTcwZTQwNTJhIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 16:41:59 GMT; Max-Age=900; path=/; httponlypoundex_associates_corporation_session=eyJpdiI6IlQzMEJmZHlUTzZsbnBoZkVnVjFpQnc9PSIsInZhbHVlIjoiN0Z1bDQxTXpIeGdQZ2VHWVo3ZGM3bEZuNFpDbEM5RDM2aC95SDJiMmlkZzhqeDVWZ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlU0QXltVW9yNHh4OHFHK1JQQktWSWc9PSIsInZhbHVlIjoiRkx6dkZFV1ErYnMrMERSaGRDVjFvd1lxS0tKbGhUMlNjZExqN3h1RWdmR1ZqdFFwMGJ2am1XWXlaak5HTmdzMzF1TnRKQkpEWUJHN3Y0ck1zOHpPdUFmVG91amNnaWFxaWIzNkNXODVhZDFxeEtvWUVsVjQ0SGRvajRpZmxNaFciLCJtYWMiOiJhMWY0NGZiYzMyZGVlMTUyZmIxYzIyNjUyYmY2NmFiMjRhNjA4MDcyOTEyYmQ1ZGZmMDE4MjdlNGY0M2JkOTU0IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 16:41:59 GMT; path=/XSRF-TOKEN=eyJpdiI6IlU0QXltVW9yNHh4OHFHK1JQQktWSWc9PSIsInZhbHVlIjoiRkx6dkZFV1ErYnMrMERSaGRDVjFvd1lxS0tKbGhUMlNjZExqN3h1RWdmR1ZqdFFwMGJ2am1XWXlaak5HTmdzMzF1TnRKQ" 1 => "poundex_associates_corporation_session=eyJpdiI6IlQzMEJmZHlUTzZsbnBoZkVnVjFpQnc9PSIsInZhbHVlIjoiN0Z1bDQxTXpIeGdQZ2VHWVo3ZGM3bEZuNFpDbEM5RDM2aC95SDJiMmlkZzhqeDVWZ2pOV2ltWnVPYmdlejk0cVgwTTZWNWhhYkdGUkUyelpSQ05NcHRqQlVScW1FMFc0a3FIY3FWRXkyK1BSV09lQUVGNVZaeHZ5VXl0SUNIQ0EiLCJtYWMiOiI0ZTdkNGE5NDA4ZGVjODE1YTgwZWExM2MwMWZjZTRmMmYxZDYxNTVhMThlNTM0MmFkOGY4YWQxNTcwZTQwNTJhIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 16:41:59 GMT; path=/; httponlypoundex_associates_corporation_session=eyJpdiI6IlQzMEJmZHlUTzZsbnBoZkVnVjFpQnc9PSIsInZhbHVlIjoiN0Z1bDQxTXpIeGdQZ2VHWVo3ZGM3bEZuNFpDbEM5RDM2aC95SDJiMmlkZzhqeDVWZ" ] ]
      session_attributes
      0 of 0
      array:5 [ "_token" => "uM0Fj7rR2I1yLNAeVK1dKGkynBdgDfo3aNQcugKF" "links" => array:1 [ 0 => "http://bobkonaonline.com/product?page=2&slug=mirror" ] "_previous" => array:1 [ "url" => "http://bobkonaonline.com/product?page=2&slug=mirror" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]