Cà phê lon

480,000 VNĐ
Request history8.2.23PHP Version96.32msRequest Duration8MBMemory UsageGET all-productsRoute
    • Booting (23.62ms)time
    • Application (72.69ms)time
    • 1 x Application (75.47%)
      72.69ms
      1 x Booting (24.52%)
      23.62ms
      2 templates were rendered
      • frontend.bemor.partials.product_ajax_listingproduct_ajax_listing.blade.php#?blade
      • frontend.bemor.partials.product_box_1product_box_1.blade.php#?blade
      uri
      GET all-products
      middleware
      web
      controller
      App\Http\Controllers\SearchController@allProducts
      namespace
      prefix
      where
      as
      products.all
      file
      app/Http/Controllers/SearchController.php:153-161
      22 statements were executed, 6 of which were duplicates, 16 unique. Show only duplicated26.27ms
      • select * from `attributes`
        2.9msbemor_liveSearchController.php#25
        Backtrace
        • 15. app/Http/Controllers/SearchController.php:25
        • 16. app/Http/Controllers/SearchController.php:160
        • 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)
        530μsbemor_liveSearchController.php#25
        Backtrace
        • 20. app/Http/Controllers/SearchController.php:25
        • 21. app/Http/Controllers/SearchController.php:160
        • 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`
        750μsbemor_liveSearchController.php#27
        Backtrace
        • 15. app/Http/Controllers/SearchController.php:27
        • 16. app/Http/Controllers/SearchController.php:160
        • 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` = '6' order by `order_level` desc
        660μsbemor_liveCategoryUtility.php#12
        Bindings
        • 0: 6
        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:48
        • 18. app/Http/Controllers/SearchController.php:160
      • select * from `categories` where `categories`.`id` = '6' limit 1
        440μsbemor_liveSearchController.php#50
        Bindings
        • 0: 6
        Backtrace
        • 16. app/Http/Controllers/SearchController.php:50
        • 17. app/Http/Controllers/SearchController.php:160
        • 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 (6)
        450μsbemor_liveSearchController.php#50
        Backtrace
        • 21. app/Http/Controllers/SearchController.php:50
        • 22. app/Http/Controllers/SearchController.php:160
        • 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 (6)
        480μsbemor_liveSearchController.php#50
        Backtrace
        • 21. app/Http/Controllers/SearchController.php:50
        • 22. app/Http/Controllers/SearchController.php:160
        • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select `attribute_id` from `attribute_category` where `category_id` in ('6')
        650μsbemor_liveSearchController.php#54
        Bindings
        • 0: 6
        Backtrace
        • 13. app/Http/Controllers/SearchController.php:54
        • 14. app/Http/Controllers/SearchController.php:160
        • 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
        340μsbemor_liveSearchController.php#55
        Backtrace
        • 14. app/Http/Controllers/SearchController.php:55
        • 15. app/Http/Controllers/SearchController.php:160
        • 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 * from `categories` where `level` = 0 order by `order_level` desc
        480μsbemor_liveSearchController.php#72
        Bindings
        • 0: 0
        Backtrace
        • 14. app/Http/Controllers/SearchController.php:72
        • 15. app/Http/Controllers/SearchController.php:160
        • 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 * from `category_translations` where `category_translations`.`category_id` in (1, 2, 3, 4, 5, 6)
        420μsbemor_liveSearchController.php#72
        Backtrace
        • 19. app/Http/Controllers/SearchController.php:72
        • 20. app/Http/Controllers/SearchController.php:160
        • 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
      • select * from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6)
        320μsbemor_liveSearchController.php#72
        Backtrace
        • 19. app/Http/Controllers/SearchController.php:72
        • 20. app/Http/Controllers/SearchController.php:160
        • 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
      • select * from `uploads` where 0 = 1 and `uploads`.`deleted_at` is null
        340μsbemor_liveSearchController.php#72
        Backtrace
        • 19. app/Http/Controllers/SearchController.php:72
        • 20. app/Http/Controllers/SearchController.php:160
        • 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
      • 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` = 6 and `featured` = '1' order by `id` desc limit 3
        4.99msbemor_liveSearchController.php#142
        Bindings
        • 0: 6
        • 1: 1
        Backtrace
        • 14. app/Http/Controllers/SearchController.php:142
        • 15. app/Http/Controllers/SearchController.php:160
        • 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 * from `product_translations` where `product_translations`.`product_id` in (9)
        5.79msbemor_liveSearchController.php#142
        Backtrace
        • 19. app/Http/Controllers/SearchController.php:142
        • 20. app/Http/Controllers/SearchController.php:160
        • 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
      • select * from `product_taxes` where `product_taxes`.`product_id` in (9)
        440μsbemor_liveSearchController.php#142
        Backtrace
        • 19. app/Http/Controllers/SearchController.php:142
        • 20. app/Http/Controllers/SearchController.php:160
        • 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
      • select * from `uploads` where `uploads`.`id` in (207) and `uploads`.`deleted_at` is null
        400μsbemor_liveSearchController.php#142
        Backtrace
        • 19. app/Http/Controllers/SearchController.php:142
        • 20. app/Http/Controllers/SearchController.php:160
        • 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
      • select count(*) as aggregate from `products` inner join `product_categories` on `products`.`id` = `product_categories`.`product_id` where `product_categories`.`category_id` = 6 and `approved` = '1' and `published` = 1 and `auction_product` = 0 and `wholesale_product` = 0 and `added_by` = 'admin'
        470μsbemor_liveSearchController.php#144
        Bindings
        • 0: 6
        • 1: 1
        • 2: 1
        • 3: 0
        • 4: 0
        • 5: admin
        Backtrace
        • 16. app/Http/Controllers/SearchController.php:144
        • 17. app/Http/Controllers/SearchController.php:160
        • 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` = 6 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 0
        1.8msbemor_liveSearchController.php#144
        Bindings
        • 0: 6
        • 1: 1
        • 2: 1
        • 3: 0
        • 4: 0
        • 5: admin
        Backtrace
        • 16. app/Http/Controllers/SearchController.php:144
        • 17. app/Http/Controllers/SearchController.php:160
        • 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 (9)
        2.9msbemor_liveSearchController.php#144
        Backtrace
        • 21. app/Http/Controllers/SearchController.php:144
        • 22. app/Http/Controllers/SearchController.php:160
        • 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 (9)
        340μsbemor_liveSearchController.php#144
        Backtrace
        • 21. app/Http/Controllers/SearchController.php:144
        • 22. app/Http/Controllers/SearchController.php:160
        • 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 (207) and `uploads`.`deleted_at` is null
        380μsbemor_liveSearchController.php#144
        Backtrace
        • 21. app/Http/Controllers/SearchController.php:144
        • 22. app/Http/Controllers/SearchController.php:160
        • 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
      App\Models\Color
      143Color.php#?
      App\Models\CategoryTranslation
      14CategoryTranslation.php#?
      App\Models\Category
      7Category.php#?
      App\Models\AttributeTranslation
      6AttributeTranslation.php#?
      App\Models\ProductTranslation
      4ProductTranslation.php#?
      App\Models\Attribute
      3Attribute.php#?
      App\Models\Product
      2Product.php#?
      App\Models\ProductTax
      2ProductTax.php#?
      App\Models\Upload
      2Upload.php#?
          _token
          dHoarb6IsdT4FDhPMK3KHcUsgOI0y0O9XAv7HBnv
          locale
          vn
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /all-products
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:2 [ "category_id" => "6" "is_ajax" => "1" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:17 [ "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 => "bemor.acstech.vn" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
          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, 02 Jun 2025 12:18:42 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=dHoarb6IsdT4FDhPMK3KHcUsgOI0y0O9XAv7HBnv; expires=Mon, 02-Jun-2025 14:18:42 GMT; Max-Age=7200; path=/" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=dHoarb6IsdT4FDhPMK3KHcUsgOI0y0O9XAv7HBnv; expires=Mon, 02-Jun-2025 14:18:42 GMT; path=/" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "dHoarb6IsdT4FDhPMK3KHcUsgOI0y0O9XAv7HBnv" "locale" => "vn" "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-06-02 19:18:42GET/all-products?category_id=6&is_ajax=1222183