All categories
Flash Sale
Todays Deal
Request history8.2.24PHP Version3.9sRequest Duration30MBMemory UsageGET category/{category_slug}Route
    • Booting (428ms)time
    • Application (3.47s)time
    • 1 x Application (89.01%)
      3.47s
      1 x Booting (10.99%)
      428ms
      37 templates were rendered
      • frontend.product_listingproduct_listing.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.megamart.partials.product_box_1product_box_1.blade.php#?blade
      • pagination::bootstrap-4bootstrap-4.blade.php#?blade
      • frontend.layouts.appapp.blade.php#?blade
      • frontend.inc.navnav.blade.php#?blade
      • frontend.partials.comparecompare.blade.php#?blade
      • frontend.partials.wishlistwishlist.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.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
      66 statements were executed, 17 of which were duplicates, 49 unique. Show only duplicated303ms
      • select * from `categories` where `slug` = 'Alarm-OFhKB' limit 1
        10.39mscore_ecommerceSearchController.php#166
        Bindings
        • 0: Alarm-OFhKB
        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 (17)
        6.24mscore_ecommerceSearchController.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`
        13.84mscore_ecommerceSearchController.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)
        8.3mscore_ecommerceSearchController.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`
        13.6mscore_ecommerceSearchController.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` = 17 order by `order_level` desc
        11.64mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 17
        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 `category_translations` where `category_translations`.`category_id` in (29, 30, 31, 32, 73, 74, 75, 76, 117, 118, 119, 120, 161, 162, 163, 164, 205, 206, 207, 208, 249, 250, 251, 252)
        1.38mscore_ecommerceCategoryUtility.php#12
        Backtrace
        • 19. app/Utility/CategoryUtility.php:12
        • 20. app/Utility/CategoryUtility.php:34
        • 21. app/Utility/CategoryUtility.php:50
        • 22. app/Http/Controllers/SearchController.php:63
        • 23. app/Http/Controllers/SearchController.php:168
      • select * from `categories` where `parent_id` = 161 order by `order_level` desc
        1.95mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 161
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 252 order by `order_level` desc
        2.94mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 252
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 251 order by `order_level` desc
        1.71mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 251
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 250 order by `order_level` desc
        2.41mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 250
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 249 order by `order_level` desc
        1.75mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 249
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 208 order by `order_level` desc
        1.59mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 208
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 207 order by `order_level` desc
        2.14mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 207
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 206 order by `order_level` desc
        1.37mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 206
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 205 order by `order_level` desc
        1.66mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 205
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 164 order by `order_level` desc
        5.23mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 164
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 163 order by `order_level` desc
        2.45mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 163
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 162 order by `order_level` desc
        3.8mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 162
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 29 order by `order_level` desc
        2.6mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 29
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 120 order by `order_level` desc
        1.78mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 120
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 119 order by `order_level` desc
        1.85mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 119
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 118 order by `order_level` desc
        2.55mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 118
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 117 order by `order_level` desc
        1.68mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 117
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 76 order by `order_level` desc
        1.62mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 76
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 75 order by `order_level` desc
        3.85mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 75
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 74 order by `order_level` desc
        1.81mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 74
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 73 order by `order_level` desc
        1.92mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 73
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 32 order by `order_level` desc
        15.49mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 32
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 31 order by `order_level` desc
        7.67mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 31
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `parent_id` = 30 order by `order_level` desc
        1.88mscore_ecommerceCategoryUtility.php#12
        Bindings
        • 0: 30
        Backtrace
        • 14. app/Utility/CategoryUtility.php:12
        • 15. app/Utility/CategoryUtility.php:34
        • 16. app/Utility/CategoryUtility.php:40
        • 17. app/Utility/CategoryUtility.php:50
        • 18. app/Http/Controllers/SearchController.php:63
      • select * from `categories` where `categories`.`id` = 17 limit 1
        1.24mscore_ecommerceSearchController.php#65
        Bindings
        • 0: 17
        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 (17)
        1.01mscore_ecommerceSearchController.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 (17)
        1.77mscore_ecommerceSearchController.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 `category_translations` where `category_translations`.`category_id` in (29, 30, 31, 32, 73, 74, 75, 76, 117, 118, 119, 120, 161, 162, 163, 164, 205, 206, 207, 208, 249, 250, 251, 252)
        970μscore_ecommerceSearchController.php#65
        Backtrace
        • 26. app/Http/Controllers/SearchController.php:65
        • 27. app/Http/Controllers/SearchController.php:168
        • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 30. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `categories` where `categories`.`parent_id` in (29, 30, 31, 32, 73, 74, 75, 76, 117, 118, 119, 120, 161, 162, 163, 164, 205, 206, 207, 208, 249, 250, 251, 252)
        1.53mscore_ecommerceSearchController.php#65
        Backtrace
        • 26. app/Http/Controllers/SearchController.php:65
        • 27. app/Http/Controllers/SearchController.php:168
        • 28. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 30. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select `attribute_id` from `attribute_category` where `category_id` in (161, 252, 251, 250, 249, 208, 207, 206, 205, 164, 163, 162, 29, 120, 119, 118, 117, 76, 75, 74, 73, 32, 31, 30, 17)
        3.04mscore_ecommerceSearchController.php#69
        Bindings
        • 0: 161
        • 1: 252
        • 2: 251
        • 3: 250
        • 4: 249
        • 5: 208
        • 6: 207
        • 7: 206
        • 8: 205
        • 9: 164
        • 10: 163
        • 11: 162
        • 12: 29
        • 13: 120
        • 14: 119
        • 15: 118
        • 16: 117
        • 17: 76
        • 18: 75
        • 19: 74
        • 20: 73
        • 21: 32
        • 22: 31
        • 23: 30
        • 24: 17
        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
        660μscore_ecommerceSearchController.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` = 17 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and (`added_by` = 'admin' or (`user_id` in (11, 12, 13, 14)))
        9.74mscore_ecommerceSearchController.php#154
        Bindings
        • 0: 17
        • 1: 1
        • 2: 1
        • 3: 0
        • 4: 0
        • 5: admin
        • 6: 11
        • 7: 12
        • 8: 13
        • 9: 14
        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 `products`.*, `product_categories`.`category_id` as `pivot_category_id`, `product_categories`.`product_id` as `pivot_product_id` from `products` inner join `product_categories` on `products`.`id` = `product_categories`.`product_id` where `product_categories`.`category_id` = 17 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and (`added_by` = 'admin' or (`user_id` in (11, 12, 13, 14))) order by `id` desc limit 24 offset 0
        7.86mscore_ecommerceSearchController.php#154
        Bindings
        • 0: 17
        • 1: 1
        • 2: 1
        • 3: 0
        • 4: 0
        • 5: admin
        • 6: 11
        • 7: 12
        • 8: 13
        • 9: 14
        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 * from `product_translations` where `product_translations`.`product_id` in (8, 9, 21, 22)
        13.09mscore_ecommerceSearchController.php#154
        Backtrace
        • 21. app/Http/Controllers/SearchController.php:154
        • 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 `product_taxes` where `product_taxes`.`product_id` in (8, 9, 21, 22)
        23.67mscore_ecommerceSearchController.php#154
        Backtrace
        • 21. app/Http/Controllers/SearchController.php:154
        • 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 `uploads` where `uploads`.`id` in (73, 89, 95, 102) and `uploads`.`deleted_at` is null
        12.98mscore_ecommerceSearchController.php#154
        Backtrace
        • 21. app/Http/Controllers/SearchController.php:154
        • 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`.`id` = 3 limit 1
        9.48mscore_ecommerceHelpers.php#1974
        Bindings
        • 0: 3
        Backtrace
        • 16. app/Http/Helpers.php:1974
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (3)
        1.05mscore_ecommerceHelpers.php#1974
        Backtrace
        • 21. app/Http/Helpers.php:1974
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 27. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where 0 = 1 and `uploads`.`deleted_at` is null
        1.11mscore_ecommerceHelpers.php#1974
        Backtrace
        • 21. app/Http/Helpers.php:1974
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 27. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `categories` where `categories`.`id` = 3 limit 1
        7.95mscore_ecommerceHelpers.php#1974
        Bindings
        • 0: 3
        Backtrace
        • 16. app/Http/Helpers.php:1974
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `category_translations` where `category_translations`.`category_id` in (3)
        1.11mscore_ecommerceHelpers.php#1974
        Backtrace
        • 21. app/Http/Helpers.php:1974
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 27. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `uploads` where 0 = 1 and `uploads`.`deleted_at` is null
        1.16mscore_ecommerceHelpers.php#1974
        Backtrace
        • 21. app/Http/Helpers.php:1974
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 27. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select count(*) as aggregate from `products` where `approved` = '1' and `published` = 1
        1.72mscore_ecommerceHelpers.php#1707
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • 15. app/Http/Helpers.php:1707
        • 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
        2.09mscore_ecommerceHelpers.php#1719
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • 15. app/Http/Helpers.php:1719
        • 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
        1.32mscore_ecommerceHelpers.php#1731
        Bindings
        • 0: 1
        • 1: 1
        Backtrace
        • 15. app/Http/Helpers.php:1731
        • 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
        2.45mscore_ecommerceHelpers.php#1654
        Bindings
        • 0: en
        Backtrace
        • 15. app/Http/Helpers.php:1654
        • 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
        8.33mscore_ecommerceHelpers.php#1167
        Backtrace
        • 19. app/Http/Helpers.php:1167
        • 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` = '987' and `uploads`.`deleted_at` is null limit 1
        6.04mscore_ecommerceHelpers.php#1167
        Bindings
        • 0: 987
        Backtrace
        • 19. app/Http/Helpers.php:1167
        • 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
        1.52mscore_ecommerceHelpers.php#1635
        Bindings
        • 0: en
        Backtrace
        • 15. app/Http/Helpers.php:1635
        • 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
        1.06mscore_ecommerceHelpers.php#1167
        Backtrace
        • 19. app/Http/Helpers.php:1167
        • 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` = '987' and `uploads`.`deleted_at` is null limit 1
        3.88mscore_ecommerceHelpers.php#1167
        Bindings
        • 0: 987
        Backtrace
        • 19. app/Http/Helpers.php:1167
        • 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
        14.49mscore_ecommerceHelpers.php#1983
        Bindings
        • 0: 0
        Backtrace
        • 14. app/Http/Helpers.php:1983
        • 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, 19, 20, 21, 22, 23, 24, 25, 48, 49, 50, 51, 52, 63, 64, 65, 66, 67, 68, 69, 92, 93, 94, 95, 96, 107, 108, 109, 110, 111, 112, 113, 136, 137, 138, 139, 140, 151, 152, 153, 154, 155, 156, 157, 180, 181, 182, 183, 184, 195, 196, 197, 198, 199, 200, 201, 224, 225, 226, 227, 228, 239, 240, 241, 242, 243, 244, 245)
        1.19mscore_ecommerceHelpers.php#1983
        Backtrace
        • 19. app/Http/Helpers.php:1983
        • 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 (116, 120, 123, 155, 156) and `uploads`.`deleted_at` is null
        3.64mscore_ecommerceHelpers.php#1983
        Backtrace
        • 19. app/Http/Helpers.php:1983
        • 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 (32, 33, 117, 119, 122, 157, 158, 159, 160, 161, 162, 163, 0, 0, 0) and `uploads`.`deleted_at` is null
        1.36mscore_ecommerceHelpers.php#1983
        Backtrace
        • 19. app/Http/Helpers.php:1983
        • 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.73mscore_ecommerceapp.blade.php#263
        Bindings
        • 0: 1
        Backtrace
        • 14. view::frontend.layouts.app:263
        • 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` desc
        4.58mscore_ecommerceapp.blade.php#306
        Bindings
        • 0: 1
        Backtrace
        • 14. view::frontend.layouts.app:306
        • 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.31mscore_ecommerceHelpers.php#1167
        Backtrace
        • 19. app/Http/Helpers.php:1167
        • 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'
        2.67mscore_ecommerceHelpers.php#122
        Bindings
        • 0: 1
        Backtrace
        • 14. app/Http/Helpers.php:122
        • 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
      127Category.php#?
      App\Models\Product
      24Product.php#?
      App\Models\ProductTranslation
      24ProductTranslation.php#?
      App\Models\ProductTax
      24ProductTax.php#?
      App\Models\Upload
      21Upload.php#?
      App\Models\Attribute
      2Attribute.php#?
      App\Models\Language
      2Language.php#?
      App\Models\CustomAlert
      1CustomAlert.php#?
      App\Models\DynamicPopup
      1DynamicPopup.php#?
          _token
          sGa15RggQileWuQuyd7vl9GyEWxJp41ys33G7lGz
          locale
          en
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /category/Alarm-OFhKB
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "page" => "1" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "host" => array:1 [ 0 => "oyik.co.in" ] "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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
          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 => "Mon, 04 Aug 2025 20:44:14 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=sGa15RggQileWuQuyd7vl9GyEWxJp41ys33G7lGz; expires=Mon, 04-Aug-2025 22:44:17 GMT; Max-Age=7200; path=/" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=sGa15RggQileWuQuyd7vl9GyEWxJp41ys33G7lGz; expires=Mon, 04-Aug-2025 22:44:17 GMT; path=/" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "sGa15RggQileWuQuyd7vl9GyEWxJp41ys33G7lGz" "locale" => "en" "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-08-04 20:44:17GET/category/Alarm-OFhKB?page=13766369