Category Products

Messages Timeline Exceptions Views13 Route Queries17 Models2 Mails Gate Session Request

Request history8.2.24416ms8MBGET products

Booting (219ms)time
Application (197ms)time
1 x Booting (52.57%)
219ms
1 x Application (47.43%)
197ms

13 templates were rendered

web-views.products.viewview.blade.php#?blade
web-views.products._ajax-products_ajax-products.blade.php#?blade
layouts.front-end.appapp.blade.php#?blade
web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
layouts.front-end.partials._modals_modals.blade.php#?blade
layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
layouts.front-end.partials._header_header.blade.php#?blade
layouts.front-end.partials._cart_cart.blade.php#?blade
layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
layouts.front-end.partials._footer_footer.blade.php#?blade
layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
layouts.front-end.partials._firebase-script_firebase-script.blade.php#?blade

uri: GET products
middleware: web, maintenance_mode, guestCheck
controller: App\Http\Controllers\Web\ProductListController@products
namespace: App\Http\Controllers\Web
prefix
where
as: products
file: app/Http/Controllers/Web/ProductListController.php:43-52

17 statements were executed (8 duplicates)Show only duplicates41.69ms

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('18.222.89.230', '2025-04-20 14:08:45', '2025-04-20 14:08:45')
920μsahtashambasheerGuestMiddleware.php#24
Bindings
Backtrace
select * from `categories` where `categories`.`id` = 11 limit 1
1msahtashambasheerProductListController.php#77
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (11) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
1.99msahtashambasheerProductListController.php#77
Bindings
Backtrace
select `publishing_houses`.*, (select count(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical'))) as `publishing_house_products_count` from `publishing_houses` where exists (select * from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` and exists (select * from `products` where `digital_product_publishing_houses`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')))
2.24msahtashambasheerproduct-manager.php#1854
Bindings
Backtrace
select `id` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`product_type` = 'digital') and 1 = 1
7.7msahtashambasheerproduct-manager.php#1863
Bindings
Backtrace
select `authors`.*, (select count(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` and exists (select * from `products` where `digital_product_authors`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical'))) as `digital_product_author_count` from `authors`
1.16msahtashambasheerproduct-manager.php#1869
Bindings
Backtrace
select `id` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and (`product_type` = 'digital') and 1 = 1
6.85msahtashambasheerproduct-manager.php#1877
Bindings
Backtrace
select * from `categories` where `id` in ('11')
860μsahtashambasheerproduct-manager.php#1920
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (11) and `translations`.`translationable_type` = 'App\\Models\\Category' and `locale` = 'en'
1.17msahtashambasheerproduct-manager.php#1920
Bindings
Backtrace
select * from `categories` where `id` in (null)
540μsahtashambasheerproduct-manager.php#1921
Bindings
Backtrace
select * from `categories` where `id` in (null)
460μsahtashambasheerproduct-manager.php#1922
Bindings
Backtrace
select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select sum(`order_details`.`qty`) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_sum_qty`, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `category_id` in (11) or (`category_id` in (11) and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) or (0 = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) or (0 = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical')) order by `order_details_count` desc
12.65msahtashambasheerproduct-manager.php#1305
Bindings
Backtrace
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and (`customer_id` = 106013 and `is_guest` = 1) group by `cart_group_id`
1.36msahtashambasheercart-manager.php#100
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and 0 = 1
690μsahtashambasheercart-manager.php#65
Bindings
Backtrace
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and (`customer_id` = 106013 and `is_guest` = 1) group by `cart_group_id`
830μsahtashambasheercart-manager.php#100
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('digital', 'physical') and `status` = 1) and 0 = 1 and (`is_checked` = 1)
520μsahtashambasheercart-manager.php#65
Bindings
Backtrace
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-20' and date(`end_date`) >= '2025-04-20' limit 1
750μsahtashambasheer_footer.blade.php#109
Bindings
Backtrace

App\Models\Category: 2Category.php#?

system_default_currency_info: App\Models\Currency {#1766 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: THB
currency_symbol: ฿
currency_exchange_rate: 1
usd: 1
_token: nLwCBr6PySaAEWj2ejprBqJfupVEr3Iert9iZya1
guest_id: 106013
local: en
direction: ltr
_previous: array:1 [ "url" => "https://ahtashambasheer.com/products?category_id=11&data_from=category&page=1"...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/products

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:3 [▼
  "category_id" => "11"
  "data_from" => "category"
  "page" => "1"
]

request_request

[]

request_headers

  0 of 0   
array:19 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.222.89.230"
  ]
  "x-real-ip" => array:1 [▶
    0 => "18.222.89.230"
  ]
  "x-forwarded-host" => array:1 [▶
    0 => "ahtashambasheer.com"
  ]
  "host" => array:1 [▶
    0 => "ahtashambasheer.com"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "private, must-revalidate"
  ]
  "date" => array:1 [▶
    0 => "Sun, 20 Apr 2025 07:08:45 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IldFcVAvL2dudWNBa21NQmczalRzUEE9PSIsInZhbHVlIjoiTlFtSUYwSEVCN3FXWHBpdWdrN3p5ck1CVmtoSTZ6Z3Fyd3QzM1AzaHBKQm9OL3RBamM4ZGtsTHQ1OVYvaUtkQXhQODVoS0NpdG8rdlZ4TVYzZVh1N3JDM1ZXVTU3WllxSTFFMFhramVmTkEyR081U1VYcXV5MHVwRW1NNGI5NXciLCJtYWMiOiIyNTJmZTY5ODcyN2E0M2Y1OWM2NjQ1YjU4YzI3Mjg1OTlkMTg3Yjg0MzYxNTc1NzA4ZjUzMTViODhjMzczOGE4IiwidGFnIjoiIn0%3D; expires=Sun, 20 Apr 2025 08:08:45 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IldFcVAvL2dudWNBa21NQmczalRzUEE9PSIsInZhbHVlIjoiTlFtSUYwSEVCN3FXWHBpdWdrN3p5ck1CVmtoSTZ6Z3Fyd3QzM1AzaHBKQm9OL3RBamM4ZGtsTHQ1OVYvaUtkQXhQODVoS ▶"
    1 => "6valley1733596657_session=eyJpdiI6IkJlZk9XWDR1cDFGOTFabXVVK2RnRFE9PSIsInZhbHVlIjoiSk90TlU2SnhwUjF3WGpIcU03SlVmcXY0WWtHTU9acjNVcTR6VVNjMC9LUWhXM1YrMzhtb3oxeTB6d0tlR2R6M2liUG5DQ2FOZHQ2MEdCTEVGUW1rSDMxYlBrbHhDV0l6a1RWeHpyUjRXOUh5WUd6Njd6YXY1UWdkbWdTZmFYZ1QiLCJtYWMiOiIwMjc0MTg0M2FmY2FkOWVmMjk1NmY4NmFlYTkxM2E3NDI1M2VlYTMyNzQ5OGViNmIzMGE2MmY5NDk3NTM3NjdmIiwidGFnIjoiIn0%3D; expires=Sun, 20 Apr 2025 08:08:45 GMT; Max-Age=3600; path=/; httponly ◀6valley1733596657_session=eyJpdiI6IkJlZk9XWDR1cDFGOTFabXVVK2RnRFE9PSIsInZhbHVlIjoiSk90TlU2SnhwUjF3WGpIcU03SlVmcXY0WWtHTU9acjNVcTR6VVNjMC9LUWhXM1YrMzhtb3oxeTB6d0 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IldFcVAvL2dudWNBa21NQmczalRzUEE9PSIsInZhbHVlIjoiTlFtSUYwSEVCN3FXWHBpdWdrN3p5ck1CVmtoSTZ6Z3Fyd3QzM1AzaHBKQm9OL3RBamM4ZGtsTHQ1OVYvaUtkQXhQODVoS0NpdG8rdlZ4TVYzZVh1N3JDM1ZXVTU3WllxSTFFMFhramVmTkEyR081U1VYcXV5MHVwRW1NNGI5NXciLCJtYWMiOiIyNTJmZTY5ODcyN2E0M2Y1OWM2NjQ1YjU4YzI3Mjg1OTlkMTg3Yjg0MzYxNTc1NzA4ZjUzMTViODhjMzczOGE4IiwidGFnIjoiIn0%3D; expires=Sun, 20-Apr-2025 08:08:45 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IldFcVAvL2dudWNBa21NQmczalRzUEE9PSIsInZhbHVlIjoiTlFtSUYwSEVCN3FXWHBpdWdrN3p5ck1CVmtoSTZ6Z3Fyd3QzM1AzaHBKQm9OL3RBamM4ZGtsTHQ1OVYvaUtkQXhQODVoS ▶"
    1 => "6valley1733596657_session=eyJpdiI6IkJlZk9XWDR1cDFGOTFabXVVK2RnRFE9PSIsInZhbHVlIjoiSk90TlU2SnhwUjF3WGpIcU03SlVmcXY0WWtHTU9acjNVcTR6VVNjMC9LUWhXM1YrMzhtb3oxeTB6d0tlR2R6M2liUG5DQ2FOZHQ2MEdCTEVGUW1rSDMxYlBrbHhDV0l6a1RWeHpyUjRXOUh5WUd6Njd6YXY1UWdkbWdTZmFYZ1QiLCJtYWMiOiIwMjc0MTg0M2FmY2FkOWVmMjk1NmY4NmFlYTkxM2E3NDI1M2VlYTMyNzQ5OGViNmIzMGE2MmY5NDk3NTM3NjdmIiwidGFnIjoiIn0%3D; expires=Sun, 20-Apr-2025 08:08:45 GMT; path=/; httponly ◀6valley1733596657_session=eyJpdiI6IkJlZk9XWDR1cDFGOTFabXVVK2RnRFE9PSIsInZhbHVlIjoiSk90TlU2SnhwUjF3WGpIcU03SlVmcXY0WWtHTU9acjNVcTR6VVNjMC9LUWhXM1YrMzhtb3oxeTB6d0 ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "system_default_currency_info" => App\Models\Currency {#1766 ▶
    #connection: "mysql"
    #table: "currencies"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    +preventsLazyLoading: false
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #escapeWhenCastingToString: false
    #attributes: array:8 [▶
      "id" => 9
      "name" => "Thai Baht"
      "symbol" => "฿"
      "code" => "THB"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2025-02-24 22:16:31"
      "updated_at" => "2025-02-24 22:16:41"
    ]
    #original: array:8 [▶
      "id" => 9
      "name" => "Thai Baht"
      "symbol" => "฿"
      "code" => "THB"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2025-02-24 22:16:31"
      "updated_at" => "2025-02-24 22:16:41"
    ]
    #changes: []
    #casts: array:4 [▶
      "id" => "integer"
      "status" => "boolean"
      "created_at" => "datetime"
      "updated_at" => "datetime"
    ]
    #classCastCache: []
    #attributeCastCache: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    +timestamps: true
    +usesUniqueIds: false
    #hidden: []
    #visible: []
    #fillable: array:5 [▶
      0 => "name"
      1 => "symbol"
      2 => "code"
      3 => "exchange_rate"
      4 => "status"
    ]
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "currency_code" => "THB"
  "currency_symbol" => "฿"
  "currency_exchange_rate" => "1"
  "usd" => 1
  "_token" => "nLwCBr6PySaAEWj2ejprBqJfupVEr3Iert9iZya1"
  "guest_id" => 106013
  "local" => "en"
  "direction" => "ltr"
  "_previous" => array:1 [▶
    "url" => "https://ahtashambasheer.com/products?category_id=11&data_from=category&page=1"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-20 14:08:45	GET	/products?category_id=11&data_from=category&page=1	13 17 2

No product found

Special

Account & shipping info

Newsletter

1 x Booting (52.57%)	219ms
1 x Application (47.43%)	197ms

Bindings
Backtrace

Bindings
Backtrace

Bindings
Backtrace

Shopping cart

Category Products (Sports & Outdoors)

No product found

Out of stock

Product added to wishlist

Please Sign in

Delete this address?