Beauty Care

Request history8.2.13PHP Version978msRequest Duration12MBMemory UsageGET category/{category_slug}Route
    • Booting (53.92ms)time
    • Application (924ms)time
    • 1 x Application (94.49%)
      924ms
      1 x Booting (5.51%)
      53.92ms
      34 templates were rendered
      • frontend.product_listingproduct_listing.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.partials.product_box_1product_box_1.blade.php#?blade
      • frontend.metro.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.cart.cartcart.blade.php#?blade
      • frontend.metro.partials.category_menucategory_menu.blade.php#?blade
      • frontend.inc.footerfooter.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
      40 statements were executed, 8 of which were duplicates, 32 unique. Show only duplicated22.51ms
      • select * from `categories` where `slug` = 'beauty-care-2g8th' limit 1
        1.34msshoppingcenterSearchController.php#166
        Bindings
        • 0: beauty-care-2g8th
        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 (11)
        380μsshoppingcenterSearchController.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`
        340μsshoppingcenterSearchController.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 (3, 4, 5)
        480μsshoppingcenterSearchController.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`
        460μsshoppingcenterSearchController.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` = 11 order by `order_level` desc
        320μsshoppingcenterCategoryUtility.php#12
        Bindings
        • 0: 11
        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 (20, 21, 22)
        240μsshoppingcenterCategoryUtility.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` = 20 order by `order_level` desc
        320μsshoppingcenterCategoryUtility.php#12
        Bindings
        • 0: 20
        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` = 21 order by `order_level` desc
        270μsshoppingcenterCategoryUtility.php#12
        Bindings
        • 0: 21
        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` = 22 order by `order_level` desc
        250μsshoppingcenterCategoryUtility.php#12
        Bindings
        • 0: 22
        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` = 11 limit 1
        240μsshoppingcenterSearchController.php#65
        Bindings
        • 0: 11
        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 (11)
        230μsshoppingcenterSearchController.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 (11)
        270μsshoppingcenterSearchController.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 (20, 21, 22)
        260μsshoppingcenterSearchController.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 (20, 21, 22)
        250μsshoppingcenterSearchController.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 (20, 21, 22, 11)
        210μsshoppingcenterSearchController.php#69
        Bindings
        • 0: 20
        • 1: 21
        • 2: 22
        • 3: 11
        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
        170μsshoppingcenterSearchController.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` = 11 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and `added_by` = 'admin'
        1.2msshoppingcenterSearchController.php#154
        Bindings
        • 0: 11
        • 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 `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` = 11 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and `added_by` = 'admin' order by `id` desc limit 24 offset 72
        1.78msshoppingcenterSearchController.php#154
        Bindings
        • 0: 11
        • 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 * from `product_translations` where `product_translations`.`product_id` in (387, 389, 391, 392, 401, 404, 409, 411, 412, 425, 426, 429, 430, 431, 434, 436, 437, 444, 446, 456, 457, 460, 499, 515)
        980μsshoppingcenterSearchController.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 (387, 389, 391, 392, 401, 404, 409, 411, 412, 425, 426, 429, 430, 431, 434, 436, 437, 444, 446, 456, 457, 460, 499, 515)
        780μsshoppingcenterSearchController.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 (1533, 1540, 1568, 1570, 1571, 1577, 1578, 1582, 1583, 1584, 1585, 1586, 1587, 1589, 1590, 1599, 1600, 1602, 1605, 1606, 1612, 1613, 1614, 1615) and `uploads`.`deleted_at` is null
        420μsshoppingcenterSearchController.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 count(*) as aggregate from `products` where `approved` = '1' and `published` = 1
        850μsshoppingcenterHelpers.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
        880μsshoppingcenterHelpers.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
        700μsshoppingcenterHelpers.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
        420μsshoppingcenterHelpers.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
        410μsshoppingcenterHelpers.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` = '50' and `uploads`.`deleted_at` is null limit 1
        430μsshoppingcenterHelpers.php#1168
        Bindings
        • 0: 50
        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
        2.75msshoppingcenterHelpers.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
        370μsshoppingcenterHelpers.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` = '2' and `uploads`.`deleted_at` is null limit 1
        500μsshoppingcenterHelpers.php#1168
        Bindings
        • 0: 2
        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
        510μsshoppingcenterHelpers.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, 3, 10, 11, 12, 15, 16, 35, 36, 37, 38)
        400μsshoppingcenterHelpers.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 (117, 118, 119, 120, 121, 122, 123, 176) and `uploads`.`deleted_at` is null
        400μsshoppingcenterHelpers.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 (56, 58, 89, 90, 91, 92, 93, 175) and `uploads`.`deleted_at` is null
        320μsshoppingcenterHelpers.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` = '51' and `uploads`.`deleted_at` is null limit 1
        490μsshoppingcenterHelpers.php#1168
        Bindings
        • 0: 51
        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` = '1699' and `uploads`.`deleted_at` is null limit 1
        490μsshoppingcenterHelpers.php#1168
        Bindings
        • 0: 1699
        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` asc
        600μsshoppingcenterapp.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
        370μsshoppingcenterapp.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'
        430μsshoppingcenterHelpers.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\ProductTax
      48ProductTax.php#?
      App\Models\Upload
      44Upload.php#?
      App\Models\Product
      24Product.php#?
      App\Models\ProductTranslation
      24ProductTranslation.php#?
      App\Models\Category
      19Category.php#?
      App\Models\CategoryTranslation
      19CategoryTranslation.php#?
      App\Models\Attribute
      3Attribute.php#?
      App\Models\AttributeTranslation
      3AttributeTranslation.php#?
      App\Models\Language
      2Language.php#?
      App\Models\Country
      1Country.php#?
          _token
          Cv6QhmAy0AGS3NEVhxIe3OkgvtHhRNAUaOvAMdDU
          locale
          en
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /category/beauty-care-2g8th
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "page" => "4" ]
          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 => "shoppingcentre.lk" ] ]
          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 => "Tue, 13 May 2025 13:21:32 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=Cv6QhmAy0AGS3NEVhxIe3OkgvtHhRNAUaOvAMdDU; expires=Tue, 13 May 2025 15:21:33 GMT; Max-Age=7200; path=/" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=Cv6QhmAy0AGS3NEVhxIe3OkgvtHhRNAUaOvAMdDU; expires=Tue, 13-May-2025 15:21:33 GMT; path=/" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "Cv6QhmAy0AGS3NEVhxIe3OkgvtHhRNAUaOvAMdDU" "locale" => "en" "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-13 13:21:33GET/category/beauty-care-2g8th?page=43440330