Demo category 3

All categories
Flash Sale
Todays Deal
Request history8.3.19PHP Version999msRequest Duration7MBMemory UsageGET category/{category_slug}Route
    • Booting (99.95ms)time
    • Application (899ms)time
    • 1 x Application (89.99%)
      899ms
      1 x Booting (10%)
      99.95ms
      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:164-171
      27 statements were executed, 7 of which were duplicates, 20 unique. Show only duplicated128ms
      • select * from `categories` where `slug` = 'Demo-category-3' limit 1
        21.67msadmin_orecto_pkSearchController.php#166
        Bindings
        • 0: Demo-category-3
        Backtrace
        • 15. app/Http/Controllers/SearchController.php:166
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `category_translations` where `category_translations`.`category_id` in (3)
        1.4msadmin_orecto_pkSearchController.php#166
        Backtrace
        • 20. app/Http/Controllers/SearchController.php:166
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `attributes`
        3.37msadmin_orecto_pkSearchController.php#25
        Backtrace
        • 15. app/Http/Controllers/SearchController.php:25
        • 16. app/Http/Controllers/SearchController.php:168
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `attribute_translations` where `attribute_translations`.`attribute_id` in (1, 2)
        5.62msadmin_orecto_pkSearchController.php#25
        Backtrace
        • 20. app/Http/Controllers/SearchController.php:25
        • 21. app/Http/Controllers/SearchController.php:168
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `colors`
        19.48msadmin_orecto_pkSearchController.php#27
        Backtrace
        • 15. app/Http/Controllers/SearchController.php:27
        • 16. app/Http/Controllers/SearchController.php:168
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `categories` where `parent_id` = 3 order by `order_level` desc
        2.48msadmin_orecto_pkCategoryUtility.php#12
        Bindings
        • 0: 3
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:50
        • 17. app/Http/Controllers/SearchController.php:63
        • 18. app/Http/Controllers/SearchController.php:168
      • select * from `categories` where `categories`.`id` = 3 limit 1
        2.67msadmin_orecto_pkSearchController.php#65
        Bindings
        • 0: 3
        Backtrace
        • 16. app/Http/Controllers/SearchController.php:65
        • 17. app/Http/Controllers/SearchController.php:168
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `category_translations` where `category_translations`.`category_id` in (3)
        1.54msadmin_orecto_pkSearchController.php#65
        Backtrace
        • 21. app/Http/Controllers/SearchController.php:65
        • 22. app/Http/Controllers/SearchController.php:168
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `categories` where `categories`.`parent_id` in (3)
        2.5msadmin_orecto_pkSearchController.php#65
        Backtrace
        • 21. app/Http/Controllers/SearchController.php:65
        • 22. app/Http/Controllers/SearchController.php:168
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select `attribute_id` from `attribute_category` where `category_id` in (3)
        13.83msadmin_orecto_pkSearchController.php#69
        Bindings
        • 0: 3
        Backtrace
        • 13. app/Http/Controllers/SearchController.php:69
        • 14. app/Http/Controllers/SearchController.php:168
        • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `attributes` where 0 = 1
        1.21msadmin_orecto_pkSearchController.php#70
        Backtrace
        • 14. app/Http/Controllers/SearchController.php:70
        • 15. app/Http/Controllers/SearchController.php:168
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. 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` = 3 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and (`added_by` = 'admin' or (0 = 1))
        3.11msadmin_orecto_pkSearchController.php#154
        Bindings
        • 0: 3
        • 1: 1
        • 2: 1
        • 3: 0
        • 4: 0
        • 5: admin
        Backtrace
        • 16. app/Http/Controllers/SearchController.php:154
        • 17. app/Http/Controllers/SearchController.php:168
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select count(*) as aggregate from `products` where `approved` = '1' and `published` = 1
        5msadmin_orecto_pkHelpers.php#1706
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • 15. app/Http/Helpers.php:1706
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 21. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `languages` where `code` = 'en' limit 1
        1.08msadmin_orecto_pkHelpers.php#1653
        Bindings
        • 0: en
        Backtrace
        • 15. app/Http/Helpers.php:1653
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 21. 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
        3.08msadmin_orecto_pkHelpers.php#1166
        Backtrace
        • 19. app/Http/Helpers.php:1166
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` = '4' and `uploads`.`deleted_at` is null limit 1
        1.39msadmin_orecto_pkHelpers.php#1166
        Bindings
        • 0: 4
        Backtrace
        • 19. app/Http/Helpers.php:1166
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `languages` where `code` = 'en' limit 1
        2.67msadmin_orecto_pkHelpers.php#1634
        Bindings
        • 0: en
        Backtrace
        • 15. app/Http/Helpers.php:1634
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 21. 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
        2.81msadmin_orecto_pkHelpers.php#1166
        Backtrace
        • 19. app/Http/Helpers.php:1166
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` = '3' and `uploads`.`deleted_at` is null limit 1
        5.07msadmin_orecto_pkHelpers.php#1166
        Bindings
        • 0: 3
        Backtrace
        • 19. app/Http/Helpers.php:1166
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `level` = 0 order by `order_level` desc
        1.22msadmin_orecto_pkHelpers.php#1982
        Bindings
        • 0: 0
        Backtrace
        • 14. app/Http/Helpers.php:1982
        • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 20. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (1, 2, 3)
        3.8msadmin_orecto_pkHelpers.php#1982
        Backtrace
        • 19. app/Http/Helpers.php:1982
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where 0 = 1 and `uploads`.`deleted_at` is null
        4.69msadmin_orecto_pkHelpers.php#1982
        Backtrace
        • 19. app/Http/Helpers.php:1982
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where `uploads`.`id` in (0, 0, 0) and `uploads`.`deleted_at` is null
        3.19msadmin_orecto_pkHelpers.php#1982
        Backtrace
        • 19. app/Http/Helpers.php:1982
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `custom_alerts` where `status` = 1 order by `id` desc
        6.94msadmin_orecto_pkapp.blade.php#258
        Bindings
        • 0: 1
        Backtrace
        • 14. view::frontend.layouts.app:258
        • 16. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `dynamic_popups` where `status` = 1 order by `id` asc
        4.43msadmin_orecto_pkapp.blade.php#299
        Bindings
        • 0: 1
        Backtrace
        • 14. view::frontend.layouts.app:299
        • 16. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 17. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 18. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 19. 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
        1.68msadmin_orecto_pkHelpers.php#1166
        Backtrace
        • 19. app/Http/Helpers.php:1166
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `countries` where `status` = '1'
        1.61msadmin_orecto_pkHelpers.php#121
        Bindings
        • 0: 1
        Backtrace
        • 14. app/Http/Helpers.php:121
        • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 20. vendor/laravel/framework/src/Illuminate/View/View.php:195
      App\Models\Color
      143Color.php#?
      App\Models\Category
      5Category.php#?
      App\Models\Attribute
      2Attribute.php#?
      App\Models\Language
      2Language.php#?
      App\Models\Upload
      2Upload.php#?
      App\Models\CustomAlert
      1CustomAlert.php#?
      App\Models\DynamicPopup
      1DynamicPopup.php#?
          _token
          62bX1qh0U9Mi806zIOGuHwzEbayxSk0txioVOmNV
          locale
          en
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /category/Demo-category-3
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:18 [ "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-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-real-ip" => array:1 [ 0 => "3.144.87.79" ] "host" => array:1 [ 0 => "orecto.pk" ] ]
          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 => "Fri, 04 Apr 2025 15:31:23 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=62bX1qh0U9Mi806zIOGuHwzEbayxSk0txioVOmNV; expires=Fri, 04-Apr-2025 17:31:24 GMT; Max-Age=7200; path=/" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=62bX1qh0U9Mi806zIOGuHwzEbayxSk0txioVOmNV; expires=Fri, 04-Apr-2025 17:31:24 GMT; path=/" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "62bX1qh0U9Mi806zIOGuHwzEbayxSk0txioVOmNV" "locale" => "en" "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-04 20:31:24GET/category/Demo-category-31127156