0585.79.8888 - 0584.81.8888
MessagesTimelineExceptionsViews5RouteQueries7MailsAuthGateSessionRequest
145.33msRequest Duration16MBMemory UsageGET san-pham/{categorySlug}/{slug}/{id}/chi-tietRouteAuth status
    • Booting (104.53ms)
    • Application (77.49ms)
      5 templates were rendered
      • frontend.includes.productDetail (resources/views/frontend/includes/productDetail.blade.php)5blade
        Params
        0
        aboutList
        1
        productCategories
        2
        newsCategories
        3
        post
        4
        randomPosts
      • frontend.includes.header (resources/views/frontend/includes/header.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        aboutList
        5
        productCategories
        6
        newsCategories
        7
        post
        8
        randomPosts
        9
        logged_in_user
        10
        title
        11
        description
        12
        image
      • frontend.includes.menu (resources/views/frontend/includes/menu.blade.php)10blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        aboutList
        5
        productCategories
        6
        newsCategories
        7
        post
        8
        randomPosts
        9
        logged_in_user
      • frontend.includes.footer (resources/views/frontend/includes/footer.blade.php)10blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        aboutList
        5
        productCategories
        6
        newsCategories
        7
        post
        8
        randomPosts
        9
        logged_in_user
      • frontend.includes.js (resources/views/frontend/includes/js.blade.php)10blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        aboutList
        5
        productCategories
        6
        newsCategories
        7
        post
        8
        randomPosts
        9
        logged_in_user
      uri
      GET san-pham/{categorySlug}/{slug}/{id}/chi-tiet
      middleware
      web
      controller
      App\Http\Controllers\Frontend\HomeController@showProductDetail
      as
      frontend.product.show
      namespace
      App\Http\Controllers\Frontend
      prefix
      null
      where
      file
      app/Http/Controllers/Frontend/HomeController.php:211-227
      7 statements were executed8.49ms
      kamel_db
      • select * from `news` where `category_id` = '1' and `hidden` is null order by `created_at` desc limit 104.14ms/app/Repositories/Backend/News/NewsRepository.php:46kamel_db
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Repositories/Backend/News/NewsRepository.php:46
        • 13. /app/Http/Controllers/Frontend/HomeController.php:214
        • 21. /app/Http/Middleware/LocaleMiddleware.php:69
        • 66. /public/index.php:52
      • - EXPLAIN #1: `news` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tablenews
        typeref
        possible_keyscategory_id
        keycategory_id
        key_len5
        refconst
        rows1
        ExtraUsing where; Using filesort
      • select * from `product_categories` where `parent_id` is null710μs/app/Repositories/Backend/ProductCategory/ProductCategoryRepository.php:54kamel_db
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Repositories/Backend/ProductCategory/ProductCategoryRepository.php:54
        • 13. /app/Http/Controllers/Frontend/HomeController.php:215
        • 21. /app/Http/Middleware/LocaleMiddleware.php:69
        • 66. /public/index.php:52
      • - EXPLAIN #1: `product_categories` (SIMPLE)41
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_categories
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows4
        ExtraUsing where
      • select * from `categories` where `id` = '2' or `id` = '3' or `id` = '4'850μs/app/Repositories/Backend/Category/CategoryRepository.php:16kamel_db
        Metadata
        Bindings
        • 0. 2
        • 1. 3
        • 2. 4
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Repositories/Backend/Category/CategoryRepository.php:16
        • 13. /app/Http/Controllers/Frontend/HomeController.php:216
        • 21. /app/Http/Middleware/LocaleMiddleware.php:69
        • 66. /public/index.php:52
      • - EXPLAIN #1: `categories` (SIMPLE)31
        Metadata
        id1
        select_typeSIMPLE
        tablecategories
        typerange
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refnull
        rows3
        ExtraUsing where
      • select * from `products` where `id` = '3' and `products`.`deleted_at` is null limit 1820μs/app/Repositories/Backend/Product/ProductRepository.php:76kamel_db
        Metadata
        Bindings
        • 0. 3
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Repositories/Backend/Product/ProductRepository.php:76
        • 14. /app/Http/Controllers/Frontend/HomeController.php:217
        • 22. /app/Http/Middleware/LocaleMiddleware.php:69
        • 67. /public/index.php:52
      • - EXPLAIN #1: `products` (SIMPLE)11
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        typeconst
        possible_keysPRIMARY
        keyPRIMARY
        key_len4
        refconst
        rows1
        Extra
      • select * from `products` where (`category_id` = '4' and `id` != '3') and `products`.`deleted_at` is null order by RAND() limit 41.13ms/app/Repositories/Backend/Product/ProductRepository.php:133kamel_db
        Metadata
        Bindings
        • 0. 4
        • 1. 3
        Hints
        • Use SELECT * only if you need all columns from table
        • ORDER BY RAND() is slow, try to avoid if you can. You can read this or this
        • The != operator is not standard. Use the <> operator to test for inequality instead.
        Backtrace
        • 12. /app/Repositories/Backend/Product/ProductRepository.php:133
        • 13. /app/Http/Controllers/Frontend/HomeController.php:218
        • 21. /app/Http/Middleware/LocaleMiddleware.php:69
        • 66. /public/index.php:52
      • - EXPLAIN #1: `products` (SIMPLE)51
        Metadata
        id1
        select_typeSIMPLE
        tableproducts
        typeref
        possible_keysPRIMARY,frk_cat_id
        keyfrk_cat_id
        key_len4
        refconst
        rows5
        ExtraUsing index condition; Using where; Using temporary; Using filesort
      • select * from `product_categories` where `product_categories`.`parent_id` = '1' and `product_categories`.`parent_id` is not null520μsview::frontend.includes.menu:68kamel_db
        Metadata
        Bindings
        • 0. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 17. view::frontend.includes.menu:68
        • 23. view::frontend.includes.productDetail:11
        • 30. /vendor/symfony/http-foundation/Response.php:200
        • 34. /app/Http/Middleware/LocaleMiddleware.php:69
        • 79. /public/index.php:52
      • - EXPLAIN #1: `product_categories` (SIMPLE)41
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_categories
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows4
        ExtraUsing where
      • select * from `product_categories` where `product_categories`.`parent_id` = '2' and `product_categories`.`parent_id` is not null320μsview::frontend.includes.menu:68kamel_db
        Metadata
        Bindings
        • 0. 2
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 17. view::frontend.includes.menu:68
        • 23. view::frontend.includes.productDetail:11
        • 30. /vendor/symfony/http-foundation/Response.php:200
        • 34. /app/Http/Middleware/LocaleMiddleware.php:69
        • 79. /public/index.php:52
      • - EXPLAIN #1: `product_categories` (SIMPLE)41
        Metadata
        id1
        select_typeSIMPLE
        tableproduct_categories
        typeALL
        possible_keysnull
        keynull
        key_lennull
        refnull
        rows4
        ExtraUsing where
        web
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
        api
        array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
          lang-rtl
          true
          _token
          ZpUA7LsD9WmrnLx8GxHxIHtAMlaEShOlK4FgWCwr
          _previous
          array:1 [ "url" => "https://kamel.vn/san-pham/noi-bat/cleanser-normal-skin-sua-rua-mat-da-hon-hop-...
          PHPDEBUGBAR_STACK_DATA
          []
          format
          html
          content_type
          text/html; charset=UTF-8
          status_text
          OK
          status_code
          200
          request_query
          []
          request_request
          []
          request_headers
          array:19 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 =>...
          request_server
          array:55 [ "USER" => "kamel" "HOME" => "/home/kamel" "SCRIPT_NAME" => "/public/index.php" "R...
          request_cookies
          []
          response_headers
          array:7 [ "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1...
          path_info
          /san-pham/noi-bat/cleanser-normal-skin-sua-rua-mat-da-hon-hop-kho/3/chi-tiet
          session_attributes
          array:4 [ "lang-rtl" => true "_token" => "ZpUA7LsD9WmrnLx8GxHxIHtAMlaEShOlK4FgWCwr" "_previous...