Messages Timeline Exceptions Views11 Route Queries37 Models243 Mails Gate Session Request

Request history8.2.28349ms7MBGET category/{category_slug}

Booting (29.4ms)time
Application (320ms)time
1 x Application (91.57%)
320ms
1 x Booting (8.43%)
29.40ms

11 templates were rendered

frontend.product_listingproduct_listing.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.classic.partials.category_menucategory_menu.blade.php#?blade
frontend.inc.footerfooter.blade.php#?blade
frontend.inc.floating_buttonsfloating_buttons.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 category/{category_slug}
middleware: web
controller: App\Http\Controllers\SearchController@listingByCategory
namespace
prefix
where
as: products.category
file: app/Http/Controllers/SearchController.php:147-154

37 statements were executed (16 duplicates)Show only duplicates29.09ms

select * from `categories` where `slug` = 'soyabean-oil-yzjvd' limit 1

1.27msu833469740_delisaleSearchController.php#149

Bindings	0: soyabean-oil-yzjvd
Backtrace	app/Http/Controllers/SearchController.php:149 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 `category_translations` where `category_translations`.`category_id` in (157)

200μsu833469740_delisaleSearchController.php#149

Backtrace

app/Http/Controllers/SearchController.php:149
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 `attributes`

210μsu833469740_delisaleSearchController.php#25

Backtrace

app/Http/Controllers/SearchController.php:25
app/Http/Controllers/SearchController.php:151
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

select * from `attribute_translations` where `attribute_translations`.`attribute_id` in (1, 2)

220μsu833469740_delisaleSearchController.php#25

Backtrace

app/Http/Controllers/SearchController.php:25
app/Http/Controllers/SearchController.php:151
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

select * from `colors`

1.08msu833469740_delisaleSearchController.php#27

Backtrace

app/Http/Controllers/SearchController.php:27
app/Http/Controllers/SearchController.php:151
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

select * from `categories` where `parent_id` = 157 order by `order_level` desc

550μsu833469740_delisaleCategoryUtility.php#12

Bindings	0: 157
Backtrace	app/Utility/CategoryUtility.php:12 app/Utility/CategoryUtility.php:34 app/Utility/CategoryUtility.php:50 app/Http/Controllers/SearchController.php:59 app/Http/Controllers/SearchController.php:151

select * from `categories` where `categories`.`id` = 157 limit 1

2msu833469740_delisaleSearchController.php#61

Bindings	0: 157
Backtrace	app/Http/Controllers/SearchController.php:61 app/Http/Controllers/SearchController.php:151 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

select * from `category_translations` where `category_translations`.`category_id` in (157)

310μsu833469740_delisaleSearchController.php#61

Backtrace

app/Http/Controllers/SearchController.php:61
app/Http/Controllers/SearchController.php:151
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

select * from `categories` where `categories`.`parent_id` in (157)

3.39msu833469740_delisaleSearchController.php#61

Backtrace

app/Http/Controllers/SearchController.php:61
app/Http/Controllers/SearchController.php:151
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

select `attribute_id` from `attribute_category` where `category_id` in (157)

290μsu833469740_delisaleSearchController.php#65

Bindings	0: 157
Backtrace	app/Http/Controllers/SearchController.php:65 app/Http/Controllers/SearchController.php:151 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

select * from `attributes` where 0 = 1

170μsu833469740_delisaleSearchController.php#66

Backtrace

app/Http/Controllers/SearchController.php:66
app/Http/Controllers/SearchController.php:151
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

select count(*) as aggregate from `products` inner join `product_categories` on `products`.`id` = `product_categories`.`product_id` where `product_categories`.`category_id` = 157 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and (`added_by` = 'admin' or (0 = 1))

510μsu833469740_delisaleSearchController.php#137

Bindings	0: 157 1: 1 2: 1 3: 0 4: 0 5: admin
Backtrace	app/Http/Controllers/SearchController.php:137 app/Http/Controllers/SearchController.php:151 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

select * from `categories` where `categories`.`id` = 33 limit 1

330μsu833469740_delisaleHelpers.php#1972

Bindings	0: 33
Backtrace	app/Http/Helpers.php:1972 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 (33)

660μsu833469740_delisaleHelpers.php#1972

Backtrace

app/Http/Helpers.php:1972
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 (12446) and `uploads`.`deleted_at` is null

450μsu833469740_delisaleHelpers.php#1972

Backtrace

app/Http/Helpers.php:1972
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 `categories`.`id` = 33 limit 1

640μsu833469740_delisaleHelpers.php#1972

Bindings	0: 33
Backtrace	app/Http/Helpers.php:1972 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 (33)

410μsu833469740_delisaleHelpers.php#1972

Backtrace

app/Http/Helpers.php:1972
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 (12446) and `uploads`.`deleted_at` is null

230μsu833469740_delisaleHelpers.php#1972

Backtrace

app/Http/Helpers.php:1972
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 `approved` = '1' and `published` = 1

3.05msu833469740_delisaleHelpers.php#1714

Bindings	0: 1 1: 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 min(`unit_price`) as aggregate from `products` where `approved` = '1' and `published` = 1

2.07msu833469740_delisaleHelpers.php#1726

Bindings	0: 1 1: 1
Backtrace	app/Http/Helpers.php:1726 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 max(`unit_price`) as aggregate from `products` where `approved` = '1' and `published` = 1

2.15msu833469740_delisaleHelpers.php#1738

Bindings	0: 1 1: 1
Backtrace	app/Http/Helpers.php:1738 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

220μsu833469740_delisaleHelpers.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` = '18144' and `uploads`.`deleted_at` is null limit 1

260μsu833469740_delisaleHelpers.php#1168

Bindings	0: 18144
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` = '18144' and `uploads`.`deleted_at` is null limit 1

620μsu833469740_delisaleHelpers.php#1168

Bindings	0: 18144
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

290μsu833469740_delisaleHelpers.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

850μsu833469740_delisaleHelpers.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

280μsu833469740_delisaleHelpers.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 `uploads` where `uploads`.`id` = '18141' and `uploads`.`deleted_at` is null limit 1

2.03msu833469740_delisaleHelpers.php#1168

Bindings	0: 18141
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 `categories` where `level` = 0 order by `order_level` desc

590μsu833469740_delisaleHelpers.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 (1, 4, 5, 6, 8, 17, 40, 83, 86, 90, 118, 134, 137, 201, 234, 241)

280μsu833469740_delisaleHelpers.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 (12473, 13021, 13022, 13023, 13027, 13028, 13031, 13032, 14987, 15263, 15264, 16719, 18122, 18123, 18124, 18518) and `uploads`.`deleted_at` is null

330μsu833469740_delisaleHelpers.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 (12473, 13021, 13022, 13023, 13027, 13028, 13031, 13032, 14987, 15263, 15264, 16719, 18122, 18123, 18124, 18518) and `uploads`.`deleted_at` is null

890μsu833469740_delisaleHelpers.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` = '18142' and `uploads`.`deleted_at` is null limit 1

500μsu833469740_delisaleHelpers.php#1168

Bindings	0: 18142
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 `custom_alerts` where `status` = 1 order by `id` desc

900μsu833469740_delisaleapp.blade.php#256

Bindings	0: 1
Backtrace	view::frontend.layouts.app:256 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

400μsu833469740_delisaleapp.blade.php#297

Bindings	0: 1
Backtrace	view::frontend.layouts.app:297 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

180μsu833469740_delisaleHelpers.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 `countries` where `status` = '1'

280μsu833469740_delisaleHelpers.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\Color: 143Color.php#?
App\Models\CategoryTranslation: 36CategoryTranslation.php#?
App\Models\Upload: 36Upload.php#?
App\Models\Category: 20Category.php#?
App\Models\Language: 4Language.php#?
App\Models\Attribute: 2Attribute.php#?
App\Models\CustomAlert: 1CustomAlert.php#?
App\Models\DynamicPopup: 1DynamicPopup.php#?

_token: i6CYF62QrnQgqpiSKL4sVSkiJyGoV2oax33hEsdC
locale: en

path_info

/category/soyabean-oil-yzjvd

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "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, br, zstd"
  ]
  "host" => array:1 [▶
    0 => "www.delisale.com.bd"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "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"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
]

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, 21 May 2025 11:18:19 GMT"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=i6CYF62QrnQgqpiSKL4sVSkiJyGoV2oax33hEsdC; expires=Wed, 21-May-2025 13:18:19 GMT; Max-Age=7200; path=/"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=i6CYF62QrnQgqpiSKL4sVSkiJyGoV2oax33hEsdC; expires=Wed, 21-May-2025 13:18:19 GMT; path=/"
  ]
]

session_attributes

  0 of 0   
array:2 [▼
  "_token" => "i6CYF62QrnQgqpiSKL4sVSkiJyGoV2oax33hEsdC"
  "locale" => "en"
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-21 17:18:19	GET	/category/soyabean-oil-yzjvd	11 37 243

Terms & conditions

Return Policy

Support Policy

Privacy Policy

Subscribe to our newsletter for regular updates about Offers, Coupons & more

Follow Us

Contacts

My Account

Seller Zone

1 x Application (91.57%)	320ms
1 x Booting (8.43%)	29.40ms

Filters

Soyabean Oil

Terms & conditions

Return Policy

Support Policy

Privacy Policy

Subscribe to our newsletter for regular updates about Offers, Coupons & more

Follow Us

Contacts

My Account

Seller Zone

Subscribe to Our Newsletter