GROCER’S SHOPS

Corner.pk

Corner.pk is. made to make eCommerce trust worthy and easy. We take all the pain of fake products.

All categories
Flash Sale
Todays Deal
Request history8.3.17PHP Version614msRequest Duration9MBMemory UsageGET category/{category_slug}Route
    • Booting (31.61ms)time
    • Application (582ms)time
    • 1 x Application (94.85%)
      582ms
      1 x Booting (5.15%)
      31.61ms
      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.reclassic.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
      29 statements were executed, 7 of which were duplicates, 22 unique. Show only duplicated12.1ms
      • select * from `categories` where `slug` = 'grocer-shops' limit 1
        2.54mscornerpk_databaseSearchController.php#166
        Bindings
        • 0: grocer-shops
        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 (5)
        960μscornerpk_databaseSearchController.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`
        220μscornerpk_databaseSearchController.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, 3, 4)
        220μscornerpk_databaseSearchController.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`
        320μscornerpk_databaseSearchController.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` = 5 order by `order_level` desc
        630μscornerpk_databaseCategoryUtility.php#12
        Bindings
        • 0: 5
        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` = 5 limit 1
        300μscornerpk_databaseSearchController.php#65
        Bindings
        • 0: 5
        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 (5)
        200μscornerpk_databaseSearchController.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 (5)
        520μscornerpk_databaseSearchController.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 (5)
        630μscornerpk_databaseSearchController.php#69
        Bindings
        • 0: 5
        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
        240μscornerpk_databaseSearchController.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` = 5 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and (`added_by` = 'admin' or (`user_id` in (3)))
        810μscornerpk_databaseSearchController.php#154
        Bindings
        • 0: 5
        • 1: 1
        • 2: 1
        • 3: 0
        • 4: 0
        • 5: admin
        • 6: 3
        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
        260μscornerpk_databaseHelpers.php#1714
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • 15. app/Http/Helpers.php:1714
        • 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 min(`unit_price`) as aggregate from `products` where `approved` = '1' and `published` = 1
        220μscornerpk_databaseHelpers.php#1726
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • 15. app/Http/Helpers.php:1726
        • 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 max(`unit_price`) as aggregate from `products` where `approved` = '1' and `published` = 1
        240μscornerpk_databaseHelpers.php#1738
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • 15. app/Http/Helpers.php:1738
        • 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
        250μscornerpk_databaseHelpers.php#1661
        Bindings
        • 0: en
        Backtrace
        • 15. app/Http/Helpers.php:1661
        • 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
        320μscornerpk_databaseHelpers.php#1168
        Backtrace
        • 19. app/Http/Helpers.php:1168
        • 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` is null and `uploads`.`deleted_at` is null limit 1
        240μscornerpk_databaseHelpers.php#1168
        Backtrace
        • 19. app/Http/Helpers.php:1168
        • 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
        270μscornerpk_databaseHelpers.php#1642
        Bindings
        • 0: en
        Backtrace
        • 15. app/Http/Helpers.php:1642
        • 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
        260μscornerpk_databaseHelpers.php#1168
        Backtrace
        • 19. app/Http/Helpers.php:1168
        • 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` = '74' and `uploads`.`deleted_at` is null limit 1
        210μscornerpk_databaseHelpers.php#1168
        Bindings
        • 0: 74
        Backtrace
        • 19. app/Http/Helpers.php:1168
        • 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
        300μscornerpk_databaseHelpers.php#1990
        Bindings
        • 0: 0
        Backtrace
        • 14. app/Http/Helpers.php:1990
        • 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, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
        200μscornerpk_databaseHelpers.php#1990
        Backtrace
        • 19. app/Http/Helpers.php:1990
        • 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
        160μscornerpk_databaseHelpers.php#1990
        Backtrace
        • 19. app/Http/Helpers.php:1990
        • 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 (79, 81, 83, 85, 87, 89, 92, 95, 97, 99, 101, 108, 110) and `uploads`.`deleted_at` is null
        180μscornerpk_databaseHelpers.php#1990
        Backtrace
        • 19. app/Http/Helpers.php:1990
        • 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` = '75' and `uploads`.`deleted_at` is null limit 1
        270μscornerpk_databaseHelpers.php#1168
        Bindings
        • 0: 75
        Backtrace
        • 19. app/Http/Helpers.php:1168
        • 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
        350μscornerpk_databaseapp.blade.php#256
        Bindings
        • 0: 1
        Backtrace
        • 14. view::frontend.layouts.app:256
        • 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
        220μscornerpk_databaseapp.blade.php#297
        Bindings
        • 0: 1
        Backtrace
        • 14. view::frontend.layouts.app:297
        • 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 `countries` where `status` = '1'
        560μscornerpk_databaseHelpers.php#123
        Bindings
        • 0: 1
        Backtrace
        • 14. app/Http/Helpers.php:123
        • 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\CategoryTranslation
      30CategoryTranslation.php#?
      App\Models\Category
      15Category.php#?
      App\Models\Upload
      15Upload.php#?
      App\Models\Attribute
      4Attribute.php#?
      App\Models\AttributeTranslation
      2AttributeTranslation.php#?
      App\Models\Language
      2Language.php#?
      App\Models\Country
      1Country.php#?
          _token
          F5kNGaA3E4vSLx2Puh1HP3hMcLTriSt4WqT1y3gK
          locale
          en
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /category/grocer-shops
          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:21 [ "cf-connecting-ip" => array:1 [ 0 => "18.117.232.238" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "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" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "cf-ray" => array:1 [ 0 => "93495e31a99fc140-LHR" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "priority" => array:1 [ 0 => "u=0, i" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "x-forwarded-for" => array:1 [ 0 => "18.117.232.238" ] "host" => array:1 [ 0 => "corner.pk" ] ]
          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, 23 Apr 2025 00:50:39 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=F5kNGaA3E4vSLx2Puh1HP3hMcLTriSt4WqT1y3gK; expires=Wed, 23 Apr 2025 02:50:39 GMT; Max-Age=7200; path=/" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=F5kNGaA3E4vSLx2Puh1HP3hMcLTriSt4WqT1y3gK; expires=Wed, 23-Apr-2025 02:50:39 GMT; path=/" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "F5kNGaA3E4vSLx2Puh1HP3hMcLTriSt4WqT1y3gK" "locale" => "en" "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-23 05:50:39GET/category/grocer-shops1129212