Empiric Laboratories Ltd.

SettingsRequest history690msRequest Duration28MBMemory Usage9.x
Laravel Version
9.52.20
PHP Version
8.1.31
Environment
local
Debug Mode
Enabled
URL
pharmacypro.com.bd
Timezone
Asia/Dhaka
Locale
en
GET brand/{brand_slug}
status
200 OK
full_url
https://pharmacypro.com.bd/brand/empiric-laboratories-ltd-305-e7
action_name
products.brand
controller_action
App\Http\Controllers\SearchController@listingByBrand
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
    status
    200 OK
    full_url
    https://pharmacypro.com.bd/brand/empiric-laboratories-ltd-305-e7
    action_name
    products.brand
    controller_action
    App\Http\Controllers\SearchController@listingByBrand
    uri
    GET brand/{brand_slug}
    controller
    App\Http\Controllers\SearchController@listingByBrand
    file
    app/Http/Controllers/SearchController.php:192-199
    middleware
    web
    duration
    691ms
    peak_memory
    28MB
    response
    text/html; charset=UTF-8
    request_format
    html
    request_query
    []
    
    request_request
    []
    
    request_headers
    0 of 0
    array:15 [ "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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "pharmacypro.com.bd" ] ]
    request_cookies
    []
    
    response_headers
    0 of 0
    array:3 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 02 May 2025 19:07:16 GMT" ] ]
    session_attributes
    0 of 0
    array:2 [ "_token" => "YvTC4eDSf3eLwSPk6TO5cRQn0gUxqHRws1xzfBCa" "locale" => "en" ]
    • Booting (61.12ms)time
    • Application (629ms)time
    • Routing (10.8ms)
    • View: frontend.product_listingviews
    • View: pagination::bootstrap-4views
    • View: frontend.layouts.appviews
    • View: frontend.inc.navviews
    • View: frontend.partials.cart.cartviews
    • View: frontend.classic.partials.category_menuviews
    • View: frontend.inc.footerviews
    • View: frontend.inc.floating_buttonsviews
    • View: frontend.partials.modalviews
    • View: frontend.partials.login_modalviews
    • View: frontend.partials.account_delete_modalviews
    • 1 x Application (91.14%)
      629ms
      1 x Booting (8.86%)
      61.12ms
      1 x Routing (1.56%)
      10.80ms
      11 x View (0%)
      0μs
      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
      35 statements were executed (17 duplicates)Show only duplicates141ms
      • SearchController.php#194webppl_db8.6msselect * from `brands` where `slug` = 'empiric-laboratories-ltd-305-e7' limit 1
        Bindings
        • 0: empiric-laboratories-ltd-305-e7
        Backtrace
        • app/Http/Controllers/SearchController.php:194
        • 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:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • SearchController.php#194webppl_db1.18msselect * from `brand_translations` where `brand_translations`.`brand_id` in (49)
        Backtrace
        • app/Http/Controllers/SearchController.php:194
        • 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:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • SearchController.php#26webppl_db1.13msselect * from `attributes`
        Backtrace
        • app/Http/Controllers/SearchController.php:26
        • app/Http/Controllers/SearchController.php:196
        • 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:260
      • SearchController.php#28webppl_db68.53msselect * from `generics`
        Backtrace
        • app/Http/Controllers/SearchController.php:28
        • app/Http/Controllers/SearchController.php:196
        • 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:260
      • SearchController.php#30webppl_db2.12msselect * from `colors`
        Backtrace
        • app/Http/Controllers/SearchController.php:30
        • app/Http/Controllers/SearchController.php:196
        • 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:260
      • SearchController.php#56webppl_db2.33msselect `name` from `brands` where `id` = 49 limit 1
        Bindings
        • 0: 49
        Backtrace
        • app/Http/Controllers/SearchController.php:56
        • app/Http/Controllers/SearchController.php:196
        • 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:260
      • SearchController.php#56webppl_db1.55msselect * from `brand_translations` where `brand_translations`.`brand_id` in (0)
        Backtrace
        • app/Http/Controllers/SearchController.php:56
        • app/Http/Controllers/SearchController.php:196
        • 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:260
      • SearchController.php#78webppl_db920μsselect * from `categories` where `level` = 0 order by `order_level` desc
        Bindings
        • 0: 0
        Backtrace
        • app/Http/Controllers/SearchController.php:78
        • app/Http/Controllers/SearchController.php:196
        • 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:260
      • SearchController.php#78webppl_db2.45msselect * from `category_translations` where `category_translations`.`category_id` in (1)
        Backtrace
        • app/Http/Controllers/SearchController.php:78
        • app/Http/Controllers/SearchController.php:196
        • 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:260
      • SearchController.php#78webppl_db1.45msselect * from `categories` where `categories`.`parent_id` in (1)
        Backtrace
        • app/Http/Controllers/SearchController.php:78
        • app/Http/Controllers/SearchController.php:196
        • 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:260
      • SearchController.php#78webppl_db2.9msselect * from `uploads` where 0 = 1 and `uploads`.`deleted_at` is null
        Backtrace
        • app/Http/Controllers/SearchController.php:78
        • app/Http/Controllers/SearchController.php:196
        • 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:260
      • SearchController.php#172webppl_db2.52msselect count(*) as aggregate from `products` where (`brand_id` = 49) and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and `added_by` = 'admin'
        Bindings
        • 0: 49
        • 1: 1
        • 2: 1
        • 3: 0
        • 4: 0
        • 5: admin
        Backtrace
        • app/Http/Controllers/SearchController.php:172
        • app/Http/Controllers/SearchController.php:196
        • 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:260
      • Helpers.php#2122webppl_db1.48msselect * from `brands` where `brands`.`id` = 49 limit 1
        Bindings
        • 0: 49
        Backtrace
        • app/Http/Helpers.php:2122
        • 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
      • Helpers.php#2122webppl_db2.56msselect * from `brand_translations` where `brand_translations`.`brand_id` in (49)
        Backtrace
        • app/Http/Helpers.php:2122
        • 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
      • Helpers.php#2122webppl_db1.66msselect * from `brands` where `brands`.`id` = 49 limit 1
        Bindings
        • 0: 49
        Backtrace
        • app/Http/Helpers.php:2122
        • 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
      • Helpers.php#2122webppl_db810μsselect * from `brand_translations` where `brand_translations`.`brand_id` in (49)
        Backtrace
        • app/Http/Helpers.php:2122
        • 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
      • Helpers.php#1845webppl_db5.35msselect count(*) as aggregate from `products` where `approved` = '1' and `published` = 1
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • app/Http/Helpers.php:1845
        • 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
      • Helpers.php#1857webppl_db1.59msselect min(`unit_price`) as aggregate from `products` where `approved` = '1' and `published` = 1
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • app/Http/Helpers.php:1857
        • 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
      • Helpers.php#1869webppl_db450μsselect max(`unit_price`) as aggregate from `products` where `approved` = '1' and `published` = 1
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • app/Http/Helpers.php:1869
        • 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
      • Helpers.php#1792webppl_db2.58msselect * from `languages` where `code` = 'en' limit 1
        Bindings
        • 0: en
        Backtrace
        • app/Http/Helpers.php:1792
        • 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
      • Helpers.php#1276webppl_db1.6msselect * from `uploads` where `uploads`.`id` = '13' and `uploads`.`deleted_at` is null limit 1
        Bindings
        • 0: 13
        Backtrace
        • app/Http/Helpers.php:1276
        • 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
      • Helpers.php#1276webppl_db2.88msselect * from `uploads` where `uploads`.`id` = '12' and `uploads`.`deleted_at` is null limit 1
        Bindings
        • 0: 12
        Backtrace
        • app/Http/Helpers.php:1276
        • 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
      • Helpers.php#1773webppl_db5.81msselect * from `languages` where `code` = 'en' limit 1
        Bindings
        • 0: en
        Backtrace
        • app/Http/Helpers.php:1773
        • 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
      • Helpers.php#1276webppl_db2.37msselect * from `uploads` where `uploads`.`id` is null and `uploads`.`deleted_at` is null limit 1
        Backtrace
        • app/Http/Helpers.php:1276
        • 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
      • Helpers.php#1783webppl_db2.55msselect * from `languages` where `status` = 1
        Bindings
        • 0: 1
        Backtrace
        • app/Http/Helpers.php:1783
        • 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
      • Helpers.php#1276webppl_db2.08msselect * from `uploads` where `uploads`.`id` = '13' and `uploads`.`deleted_at` is null limit 1
        Bindings
        • 0: 13
        Backtrace
        • app/Http/Helpers.php:1276
        • 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
      • Helpers.php#2166webppl_db1.83msselect * from `categories` where `level` = 0 order by `order_level` desc
        Bindings
        • 0: 0
        Backtrace
        • app/Http/Helpers.php:2166
        • 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
      • Helpers.php#2166webppl_db760μsselect * from `category_translations` where `category_translations`.`category_id` in (1)
        Backtrace
        • app/Http/Helpers.php:2166
        • 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
      • Helpers.php#2166webppl_db1.24msselect * from `uploads` where 0 = 1 and `uploads`.`deleted_at` is null
        Backtrace
        • app/Http/Helpers.php:2166
        • 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
      • Helpers.php#2166webppl_db650μsselect * from `uploads` where 0 = 1 and `uploads`.`deleted_at` is null
        Backtrace
        • app/Http/Helpers.php:2166
        • 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
      • Helpers.php#1276webppl_db1.58msselect * from `uploads` where `uploads`.`id` = '13' and `uploads`.`deleted_at` is null limit 1
        Bindings
        • 0: 13
        Backtrace
        • app/Http/Helpers.php:1276
        • 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
      • Helpers.php#1276webppl_db1.3msselect * from `uploads` where `uploads`.`id` = '14' and `uploads`.`deleted_at` is null limit 1
        Bindings
        • 0: 14
        Backtrace
        • app/Http/Helpers.php:1276
        • 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.blade.php#277webppl_db1.36msselect * from `custom_alerts` where `status` = 1 order by `id` desc
        Bindings
        • 0: 1
        Backtrace
        • view::frontend.layouts.app:277
        • 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.blade.php#318webppl_db1.12msselect * from `dynamic_popups` where `status` = 1 order by `id` asc
        Bindings
        • 0: 1
        Backtrace
        • view::frontend.layouts.app:318
        • 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
      • Helpers.php#122webppl_db2.12msselect * from `countries` where `status` = '1'
        Bindings
        • 0: 1
        Backtrace
        • app/Http/Helpers.php:122
        • 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\Generic
      1630Generic.php#?
      App\Models\Upload
      5Upload.php#?
      App\Models\Brand
      4Brand.php#?
      App\Models\Language
      4Language.php#?
      App\Models\Category
      2Category.php#?
      App\Models\CategoryTranslation
      2CategoryTranslation.php#?
      App\Models\Country
      1Country.php#?
          ClearShow all
          Date ↕MethodURLData
          #12025-05-03 01:07:16GET/brand/empiric-laboratories-ltd-305-e711351648