Messages3 Timeline Exceptions Views10 Route Queries29 Models428 Mails Gate Session Request

Request history8.3.15879ms7MBGET shop/{slug}/{type}

infolog[14:54:55] LOG.info: IP-API Location: { "status": "success", "country": "United States", ...
infolog[14:54:55] LOG.info: Determined Currency Code: [ "USD" ]
infolog[14:54:55] LOG.info: Currency and country set in session: [ "USD", "United States" ]

Booting (71.12ms)time
Application (808ms)time
1 x Application (91.91%)
808ms
1 x Booting (8.09%)
71.12ms

10 templates were rendered

frontend.seller_shopseller_shop.blade.php#?blade
pagination::bootstrap-4bootstrap-4.blade.php#?blade
frontend.layouts.appapp.blade.php#?blade
frontend.inc.navnav.blade.php#?blade
frontend.partials.cart.cartcart.blade.php#?blade
frontend.megamart.partials.category_menucategory_menu.blade.php#?blade
frontend.inc.footerfooter.blade.php#?blade
frontend.partials.modalmodal.blade.php#?blade
frontend.partials.login_modallogin_modal.blade.php#?blade
frontend.partials.account_delete_modalaccount_delete_modal.blade.php#?blade

uri: GET shop/{slug}/{type}
middleware: web
controller: App\Http\Controllers\HomeController@filter_shop
namespace
prefix
where
as: shop.visit.type
file: app/Http/Controllers/HomeController.php:509-576

29 statements were executed (11 duplicates)Show only duplicates30.57ms

select * from `currencies` where `code` = 'USD' limit 1

2.83mspharmacyAutoCurrencyMiddleware.php#138

Bindings	0: USD
Backtrace	app/Http/Middleware/AutoCurrencyMiddleware.php:138 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 app/Http/Middleware/HttpsProtocol.php:20 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180 middleware::app_language:35

select * from `shops` where `slug` = 'Bashir-Mala-and-Sons-Global-Ventures-' limit 1

1.17mspharmacyHomeController.php#514

Bindings	0: Bashir-Mala-and-Sons-Global-Ventures-
Backtrace	app/Http/Controllers/HomeController.php:514 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `users` where `users`.`id` in (97)

2mspharmacyHomeController.php#514

Backtrace

app/Http/Controllers/HomeController.php:514
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `products` where (`user_id` = 97 and `published` = 1 and `approved` = 1)

1.32mspharmacyHomeController.php#568

Bindings	0: 97 1: 1 2: 1
Backtrace	app/Http/Controllers/HomeController.php:568 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

430μspharmacyHelpers.php#1168

Backtrace

app/Http/Helpers.php:1168
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

430μspharmacyHelpers.php#1168

Backtrace

app/Http/Helpers.php:1168
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

480μspharmacyHelpers.php#1168

Backtrace

app/Http/Helpers.php:1168
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

410μspharmacyHelpers.php#1168

Backtrace

app/Http/Helpers.php:1168
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `follow_sellers` where `follow_sellers`.`shop_id` = 32 and `follow_sellers`.`shop_id` is not null

810μspharmacyseller_shop.blade.php#176

Bindings	0: 32
Backtrace	view::frontend.seller_shop:176 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select `category_id` from `products` where `user_id` = 97 and `approved` = '1' and `published` = 1

1.12mspharmacyHelpers.php#1990

Bindings	0: 97 1: 1 2: 1
Backtrace	app/Http/Helpers.php:1990 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `categories` where 0 = 1

510μspharmacyHelpers.php#1993

Backtrace

app/Http/Helpers.php:1993
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
vendor/laravel/framework/src/Illuminate/View/View.php:195

select count(*) as aggregate from `products` where `user_id` = 97 and `approved` = '1' and `published` = 1

950μspharmacyHelpers.php#1714

Bindings	0: 97 1: 1 2: 1
Backtrace	app/Http/Helpers.php:1714 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select count(*) as aggregate from `products` where `user_id` = 97 and `approved` = '1' and `published` = 1

1.16mspharmacyHelpers.php#1714

Bindings	0: 97 1: 1 2: 1
Backtrace	app/Http/Helpers.php:1714 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select `brand_id` from `products` where `user_id` = 97 and `approved` = '1' and `published` = 1 and `brand_id` is not null

1.56mspharmacyHelpers.php#1946

Bindings	0: 97 1: 1 2: 1
Backtrace	app/Http/Helpers.php:1946 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `brands` where 0 = 1

720μspharmacyHelpers.php#1949

Backtrace

app/Http/Helpers.php:1949
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `languages` where `code` = 'en' limit 1

1.2mspharmacyHelpers.php#1661

Bindings	0: en
Backtrace	app/Http/Helpers.php:1661 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `uploads` where `uploads`.`id` = '22131' and `uploads`.`deleted_at` is null limit 1

890μspharmacyHelpers.php#1168

Bindings	0: 22131
Backtrace	app/Http/Helpers.php:1168 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `languages` where `code` = 'en' limit 1

950μspharmacyHelpers.php#1642

Bindings	0: en
Backtrace	app/Http/Helpers.php:1642 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1

680μspharmacyHelpers.php#1168

Backtrace

app/Http/Helpers.php:1168
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `languages` where `status` = 1

950μspharmacyHelpers.php#1652

Bindings	0: 1
Backtrace	app/Http/Helpers.php:1652 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `currencies` where `code` = 'USD' limit 1

960μspharmacyHelpers.php#1675

Bindings	0: USD
Backtrace	app/Http/Helpers.php:1675 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `currencies` where `status` = 1

1.29mspharmacyHelpers.php#1685

Bindings	0: 1
Backtrace	app/Http/Helpers.php:1685 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `categories` where `level` = 0 order by `order_level` desc

1.71mspharmacyHelpers.php#1981

Bindings	0: 0
Backtrace	app/Http/Helpers.php:1981 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `category_translations` where `category_translations`.`category_id` in (253, 254, 255, 256, 257, 258, 259, 260, 261, 264, 270, 300, 354, 355, 393, 419, 424, 428, 435, 438)

840μspharmacyHelpers.php#1981

Backtrace

app/Http/Helpers.php:1981
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `uploads` where `uploads`.`id` in (52, 625, 1944, 24879, 25038, 25039, 25040, 25042, 25046, 25047, 25048, 25049, 25050, 57601, 61322) and `uploads`.`deleted_at` is null

770μspharmacyHelpers.php#1981

Backtrace

app/Http/Helpers.php:1981
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `uploads` where `uploads`.`id` in (5, 7, 8, 9, 10, 11, 12, 13, 14, 17, 1932, 2680, 3024, 4620, 9774) and `uploads`.`deleted_at` is null

680μspharmacyHelpers.php#1981

Backtrace

app/Http/Helpers.php:1981
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `custom_alerts` where `status` = 1 order by `id` desc

610μspharmacyapp.blade.php#288

Bindings	0: 1
Backtrace	view::frontend.layouts.app:288 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `dynamic_popups` where `status` = 1 order by `id` asc

570μspharmacyapp.blade.php#329

Bindings	0: 1
Backtrace	view::frontend.layouts.app:329 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `countries` where `status` = '1'

2.57mspharmacyHelpers.php#123

Bindings	0: 1
Backtrace	app/Http/Helpers.php:123 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 vendor/laravel/framework/src/Illuminate/View/View.php:195

App\Models\Country: 246Country.php#?
App\Models\Currency: 104Currency.php#?
App\Models\Upload: 29Upload.php#?
App\Models\Category: 20Category.php#?
App\Models\CategoryTranslation: 19CategoryTranslation.php#?
App\Models\Language: 5Language.php#?
App\Models\FollowSeller: 3FollowSeller.php#?
App\Models\Shop: 1Shop.php#?
App\Models\User: 1User.php#?

_token: GJdNV1eqEJk76b5VUNSCeQt4W2yyNQvdiZNH0Vvo
locale: en
currency_code: USD
currency_symbol: $
currency_exchange_rate: 1.00000
country: United States

path_info

/shop/Bashir-Mala-and-Sons-Global-Ventures-/all-products

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "kanemtrade.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "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_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, 14 Mar 2025 14:54:55 GMT"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=GJdNV1eqEJk76b5VUNSCeQt4W2yyNQvdiZNH0Vvo; expires=Fri, 14-Mar-2025 16:54:55 GMT; Max-Age=7200; path=/"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=GJdNV1eqEJk76b5VUNSCeQt4W2yyNQvdiZNH0Vvo; expires=Fri, 14-Mar-2025 16:54:55 GMT; path=/"
  ]
]

session_attributes

  0 of 0   
array:6 [▼
  "_token" => "GJdNV1eqEJk76b5VUNSCeQt4W2yyNQvdiZNH0Vvo"
  "locale" => "en"
  "currency_code" => "USD"
  "currency_symbol" => "$"
  "currency_exchange_rate" => "1.00000"
  "country" => "United States"
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-03-14 14:54:55	GET	/shop/Bashir-Mala-and-Sons-Global-Ventures-/all-products	3 10 29 428

1 x Application (91.91%)	808ms
1 x Booting (8.09%)	71.12ms

Filters

All products