All products

Request history8.2.13PHP Version1.22sRequest Duration12MBMemory UsageGET searchRoute
    • Booting (47.48ms)time
    • Application (1.17s)time
    • 1 x Application (96.11%)
      1.17s
      1 x Booting (3.89%)
      47.48ms
      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 search
      middleware
      web
      controller
      App\Http\Controllers\SearchController@index
      namespace
      prefix
      where
      as
      search
      file
      app/Http/Controllers/SearchController.php:18-157
      36 statements were executed, 10 of which were duplicates, 26 unique. Show only duplicated24.51ms
      • select * from `attributes`
        1.15msshoppingcenterSearchController.php#25
        Backtrace
        • 15. app/Http/Controllers/SearchController.php:25
        • 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 `attribute_translations` where `attribute_translations`.`attribute_id` in (3, 4, 5)
        300μsshoppingcenterSearchController.php#25
        Backtrace
        • 20. app/Http/Controllers/SearchController.php:25
        • 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 `colors`
        520μsshoppingcenterSearchController.php#27
        Backtrace
        • 15. app/Http/Controllers/SearchController.php:27
        • 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 `categories` where `level` = 0 order by `order_level` desc
        590μsshoppingcenterSearchController.php#72
        Bindings
        • 0: 0
        Backtrace
        • 14. app/Http/Controllers/SearchController.php:72
        • 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
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `category_translations` where `category_translations`.`category_id` in (1, 3, 10, 11, 12, 15, 16, 35, 36, 37, 38)
        320μsshoppingcenterSearchController.php#72
        Backtrace
        • 19. app/Http/Controllers/SearchController.php:72
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `categories` where `categories`.`parent_id` in (1, 3, 10, 11, 12, 15, 16, 35, 36, 37, 38)
        320μsshoppingcenterSearchController.php#72
        Backtrace
        • 19. app/Http/Controllers/SearchController.php:72
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `category_translations` where `category_translations`.`category_id` in (17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 32)
        270μsshoppingcenterSearchController.php#72
        Backtrace
        • 24. app/Http/Controllers/SearchController.php:72
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 26. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 27. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `categories` where `categories`.`parent_id` in (17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 32)
        360μsshoppingcenterSearchController.php#72
        Backtrace
        • 24. app/Http/Controllers/SearchController.php:72
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 26. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 27. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 28. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `category_translations` where `category_translations`.`category_id` in (30, 31, 33, 34)
        250μsshoppingcenterSearchController.php#72
        Backtrace
        • 29. app/Http/Controllers/SearchController.php:72
        • 30. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 31. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 32. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 33. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `uploads` where `uploads`.`id` in (117, 118, 119, 120, 121, 122, 123, 176) and `uploads`.`deleted_at` is null
        370μsshoppingcenterSearchController.php#72
        Backtrace
        • 19. app/Http/Controllers/SearchController.php:72
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select count(*) as aggregate from `products` where `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and `added_by` = 'admin'
        1.1msshoppingcenterSearchController.php#154
        Bindings
        • 0: 1
        • 1: 1
        • 2: 0
        • 3: 0
        • 4: admin
        Backtrace
        • 15. app/Http/Controllers/SearchController.php:154
        • 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 `products` where `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and `added_by` = 'admin' order by `id` desc limit 24 offset 24
        900μsshoppingcenterSearchController.php#154
        Bindings
        • 0: 1
        • 1: 1
        • 2: 0
        • 3: 0
        • 4: admin
        Backtrace
        • 15. app/Http/Controllers/SearchController.php:154
        • 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 `product_translations` where `product_translations`.`product_id` in (1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213)
        1.33msshoppingcenterSearchController.php#154
        Backtrace
        • 20. app/Http/Controllers/SearchController.php:154
        • 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 `product_taxes` where `product_taxes`.`product_id` in (1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213)
        760μsshoppingcenterSearchController.php#154
        Backtrace
        • 20. app/Http/Controllers/SearchController.php:154
        • 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 `uploads` where `uploads`.`id` in (2160, 2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2177, 2178, 2179, 2180, 2181, 2182, 2183, 2184) and `uploads`.`deleted_at` is null
        370μsshoppingcenterSearchController.php#154
        Backtrace
        • 20. app/Http/Controllers/SearchController.php:154
        • 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 count(*) as aggregate from `products` where `approved` = '1' and `published` = 1
        820μ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
        680μ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
        630μ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 `attribute_values` where `attribute_values`.`attribute_id` = 3 and `attribute_values`.`attribute_id` is not null
        210μsshoppingcenterproduct_listing.blade.php#175
        Bindings
        • 0: 3
        Backtrace
        • 19. view::frontend.product_listing:175
        • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `attribute_values` where `attribute_values`.`attribute_id` = 4 and `attribute_values`.`attribute_id` is not null
        190μsshoppingcenterproduct_listing.blade.php#175
        Bindings
        • 0: 4
        Backtrace
        • 19. view::frontend.product_listing:175
        • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `attribute_values` where `attribute_values`.`attribute_id` = 5 and `attribute_values`.`attribute_id` is not null
        190μsshoppingcenterproduct_listing.blade.php#175
        Bindings
        • 0: 5
        Backtrace
        • 19. view::frontend.product_listing:175
        • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70
        • 24. vendor/laravel/framework/src/Illuminate/View/View.php:195
      • select * from `languages` where `code` = 'en' limit 1
        490μ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
        340μ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
        490μ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
        590μsshoppingcenterHelpers.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
        320μ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
        460μ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
        590μ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)
        410μ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
        460μ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
        370μ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
        500μ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
        480μ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
        450μ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
        430μ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'
        6.5msshoppingcenterHelpers.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\Upload
      52Upload.php#?
      App\Models\ProductTax
      48ProductTax.php#?
      App\Models\Category
      40Category.php#?
      App\Models\CategoryTranslation
      40CategoryTranslation.php#?
      App\Models\Product
      24Product.php#?
      App\Models\ProductTranslation
      24ProductTranslation.php#?
      App\Models\Attribute
      3Attribute.php#?
      App\Models\AttributeTranslation
      3AttributeTranslation.php#?
      App\Models\Language
      2Language.php#?
      App\Models\AttributeValue
      1AttributeValue.php#?
      App\Models\Country
      1Country.php#?
          _token
          06SzSQrOgf7S6W8CsJMkwAvolsSGuMpULTcQtxge
          locale
          en
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /search
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "page" => "2" ]
          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 => "Fri, 09 May 2025 08:03:32 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=06SzSQrOgf7S6W8CsJMkwAvolsSGuMpULTcQtxge; expires=Fri, 09 May 2025 10:03:33 GMT; Max-Age=7200; path=/" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=06SzSQrOgf7S6W8CsJMkwAvolsSGuMpULTcQtxge; expires=Fri, 09-May-2025 10:03:33 GMT; path=/" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "06SzSQrOgf7S6W8CsJMkwAvolsSGuMpULTcQtxge" "locale" => "en" "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-09 08:03:33GET/shoppingcentre.lk/search?page=23436381