KHÓA HỌC CHO DOANH NGHIỆP
0
7.2.34PHP Version1.09sRequest Duration11MBMemory UsageGET coursesRoute
    • Booting (813ms)
    • Application (276ms)
    • 1 x Booting (74.66%)
      812.92ms
      1 x Application (25.3%)
      275.51ms
      8 templates were rendered
      • courses.index (resources/views/courses/index.blade.php)7blade
        Params
        0
        teachers
        1
        categories
        2
        cateSearch
        3
        skill
        4
        license
        5
        courses
        6
        idCourse
      • courses.search (resources/views/courses/search.blade.php)11blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        teachers
        5
        categories
        6
        cateSearch
        7
        skill
        8
        license
        9
        courses
        10
        idCourse
      • pagination::bootstrap-4 (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/bootstrap-4.blade.php)2blade
        Params
        0
        paginator
        1
        elements
      • layouts.v4.home (resources/views/layouts/v4/home.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        teachers
        5
        categories
        6
        cateSearch
        7
        skill
        8
        license
        9
        courses
        10
        idCourse
        11
        __currentLoopData
        12
        row
        13
        loop
      • banner (resources/views/banner.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        teachers
        5
        categories
        6
        cateSearch
        7
        skill
        8
        license
        9
        courses
        10
        idCourse
        11
        __currentLoopData
        12
        row
        13
        loop
        14
        BANNER
        15
        POPUP
      • popup (resources/views/popup.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        teachers
        5
        categories
        6
        cateSearch
        7
        skill
        8
        license
        9
        courses
        10
        idCourse
        11
        __currentLoopData
        12
        row
        13
        loop
        14
        BANNER
        15
        POPUP
      • layouts.v4.header (resources/views/layouts/v4/header.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        teachers
        5
        categories
        6
        cateSearch
        7
        skill
        8
        license
        9
        courses
        10
        idCourse
        11
        __currentLoopData
        12
        row
        13
        loop
      • layouts.v4.footer (resources/views/layouts/v4/footer.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        teachers
        5
        categories
        6
        cateSearch
        7
        skill
        8
        license
        9
        courses
        10
        idCourse
        11
        __currentLoopData
        12
        row
        13
        loop
      uri
      GET courses
      middleware
      web, redirect_subdomain_to_login
      controller
      App\Http\Controllers\CourseController@index
      namespace
      App\Http\Controllers
      prefix
      /courses
      where
      as
      courseAll.index
      file
      app/Http/Controllers/CourseController.php:30-70
      12 statements were executed, 4 of which were duplicated, 8 unique36.2ms
      • select `fullname`, `id` from `teacher_profile` where `teacher_profile`.`deleted_at` is null7.38ms/app/Http/Controllers/CourseController.php:32acabiz_staging_db
        Metadata
        Backtrace
        • 13. /app/Http/Controllers/CourseController.php:32
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select `cate_name`, `id` from `course_category` where `status` = 1 and `type` = 2019 and `course_category`.`deleted_at` is null1.25ms/app/Http/Controllers/CourseController.php:36acabiz_staging_db
        Metadata
        Bindings
        • 0. 1
        • 1. 2019
        Backtrace
        • 13. /app/Http/Controllers/CourseController.php:36
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select `course_category`.`id`, `course_category`.`cate_name`, COUNT(course.id) AS nCourse from `course_category` inner join `course` on `course`.`cate_id` = `course_category`.`id` where `course`.`status` <> -1 and `course_category`.`status` = 1 and `course_category`.`type` = 2019 and `course_category`.`deleted_at` is null group by `course_category`.`id` order by `nCourse` desc limit 128.29ms/app/Http/Controllers/CourseController.php:46acabiz_staging_db
        Metadata
        Bindings
        • 0. -1
        • 1. 1
        • 2. 2019
        Backtrace
        • 14. /app/Http/Controllers/CourseController.php:46
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select `skill_name`, `id` from `course_skills` where `company_id` = 0 and `status` = 1 and `course_skills`.`deleted_at` is null2.2ms/app/Http/Controllers/CourseController.php:51acabiz_staging_db
        Metadata
        Bindings
        • 0. 0
        • 1. 1
        Backtrace
        • 13. /app/Http/Controllers/CourseController.php:51
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select count(*) as aggregate from `course` inner join `course_category` on `course_category`.`id` = `course`.`cate_id` inner join `teacher_profile` on `teacher_profile`.`id` = `course`.`teacher_id` where `course`.`id` not in (141, 99, 121, 114, 417) and `course`.`cate_id` in ('105') and `course`.`status` <> -1 and `course`.`cate_id` in (29, 35, 36, 39, 40, 55, 104, 105) and `course`.`deleted_at` is null4.37ms/app/Http/Controllers/CourseController.php:65acabiz_staging_db
        Metadata
        Bindings
        • 0. 141
        • 1. 99
        • 2. 121
        • 3. 114
        • 4. 417
        • 5. 105
        • 6. -1
        • 7. 29
        • 8. 35
        • 9. 36
        • 10. 39
        • 11. 40
        • 12. 55
        • 13. 104
        • 14. 105
        Backtrace
        • 15. /app/Http/Controllers/CourseController.php:65
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select `course_slug`, `course`.`views`, `course`.`id`, `course`.`course_name`, `course`.`image`, `teacher_profile`.`fullname`, `teacher_profile`.`image` as `image_teacher` from `course` inner join `course_category` on `course_category`.`id` = `course`.`cate_id` inner join `teacher_profile` on `teacher_profile`.`id` = `course`.`teacher_id` where `course`.`id` not in (141, 99, 121, 114, 417) and `course`.`cate_id` in ('105') and `course`.`status` <> -1 and `course`.`cate_id` in (29, 35, 36, 39, 40, 55, 104, 105) and `course`.`deleted_at` is null limit 30 offset 02.44ms/app/Http/Controllers/CourseController.php:65acabiz_staging_db
        Metadata
        Bindings
        • 0. 141
        • 1. 99
        • 2. 121
        • 3. 114
        • 4. 417
        • 5. 105
        • 6. -1
        • 7. 29
        • 8. 35
        • 9. 36
        • 10. 39
        • 11. 40
        • 12. 55
        • 13. 104
        • 14. 105
        Backtrace
        • 15. /app/Http/Controllers/CourseController.php:65
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select `course_slug`, `course`.`views`, `course`.`id`, `course`.`course_name`, `course`.`image`, `teacher_profile`.`fullname`, `teacher_profile`.`image` as `image_teacher` from `course` inner join `course_category` on `course_category`.`id` = `course`.`cate_id` inner join `teacher_profile` on `teacher_profile`.`id` = `course`.`teacher_id` where `course`.`id` not in (141, 99, 121, 114, 417) and `course`.`cate_id` in ('105') and `course`.`status` <> -1 and `course`.`cate_id` in (29, 35, 36, 39, 40, 55, 104, 105) and `course`.`deleted_at` is null5.13ms/app/Http/Controllers/CourseController.php:66acabiz_staging_db
        Metadata
        Bindings
        • 0. 141
        • 1. 99
        • 2. 121
        • 3. 114
        • 4. 417
        • 5. 105
        • 6. -1
        • 7. 29
        • 8. 35
        • 9. 36
        • 10. 39
        • 11. 40
        • 12. 55
        • 13. 104
        • 14. 105
        Backtrace
        • 13. /app/Http/Controllers/CourseController.php:66
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
      • select * from `company` where `website` = 'staging.acabiz.vn' and `company`.`deleted_at` is null limit 11.32ms/app/Helpers/Helper.php:483acabiz_staging_db
        Metadata
        Bindings
        • 0. staging.acabiz.vn
        Backtrace
        • 15. /app/Helpers/Helper.php:483
        • 16. view::layouts.v4.home:15
        • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:125
      • select * from `banners` where `type` = 1 and `status` = 1 and `banners`.`deleted_at` is null limit 11ms/app/Http/ViewComposers/BannerComposer.php:18acabiz_staging_db
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 15. /app/Http/ViewComposers/BannerComposer.php:18
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 23. view::layouts.v4.home:126
      • select * from `banners` where `type` = 2 and `status` = 1 and `banners`.`deleted_at` is null limit 1910μs/app/Http/ViewComposers/BannerComposer.php:24acabiz_staging_db
        Metadata
        Bindings
        • 0. 2
        • 1. 1
        Backtrace
        • 15. /app/Http/ViewComposers/BannerComposer.php:24
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 23. view::layouts.v4.home:126
      • select * from `banners` where `type` = 1 and `status` = 1 and `banners`.`deleted_at` is null limit 1980μs/app/Http/ViewComposers/BannerComposer.php:18acabiz_staging_db
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        Backtrace
        • 15. /app/Http/ViewComposers/BannerComposer.php:18
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 23. view::layouts.v4.home:127
      • select * from `banners` where `type` = 2 and `status` = 1 and `banners`.`deleted_at` is null limit 1930μs/app/Http/ViewComposers/BannerComposer.php:24acabiz_staging_db
        Metadata
        Bindings
        • 0. 2
        • 1. 1
        Backtrace
        • 15. /app/Http/ViewComposers/BannerComposer.php:24
        • 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:123
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:90
        • 23. view::layouts.v4.home:127
      App\Models\Course
      30
      App\Models\CourseCategory
      8
          _token
          tpaCk1ZcMCU99FXO8T9LpiRbTVVElC4n4yoDiXw7
          _previous
          array:1 [ "url" => "https://staging.acabiz.vn/courses?category%5B0%5D=105" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /courses
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "category" => array:1 [ 0 => "105" ] ]
          request_request
          0 of 0
          array:1 [ "category" => array:1 [ 0 => "105" ] ]
          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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "staging.acabiz.vn" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
          request_server
          0 of 0
          array:41 [ "USER" => "acabiz" "HOME" => "/home/acabiz" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "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" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "HTTP_HOST" => "staging.acabiz.vn" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "staging.acabiz.vn" "SERVER_PORT" => "443" "SERVER_ADDR" => "14.225.18.29" "REMOTE_PORT" => "1095" "REMOTE_ADDR" => "3.133.94.82" "SERVER_SOFTWARE" => "nginx/1.27.4" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/home/acabiz/staging/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/courses?category%5B0%5D=105" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "category%5B0%5D=105" "SCRIPT_FILENAME" => "/home/acabiz/staging/public/index.php" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744983445.4398 "REQUEST_TIME" => 1744983445 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 18 Apr 2025 13:37:26 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkdiOFd3MTdWOVwvNnd5WXppZTRFVEpBPT0iLCJ2YWx1ZSI6IjZ2WVVxVkp6eDZpMG9JbUpSTktPYm9hSHpWYURHblZLSUl3azY3XC9zclwvWmdlb0l3bHVkVFJBaGdOblhWTjd0biIsIm1hYyI6IjEyYjYxMjZkYjI1OTgxZGEzYWRlZmEzZThkMTI0MzA1NzI4ZWQzMGRkMWY1OTBlZDAwZTk5MTlkNWRkODZmZGYifQ%3D%3D; expires=Sat, 26-Apr-2025 21:37:26 GMT; Max-Age=720000; path=/XSRF-TOKEN=eyJpdiI6IkdiOFd3MTdWOVwvNnd5WXppZTRFVEpBPT0iLCJ2YWx1ZSI6IjZ2WVVxVkp6eDZpMG9JbUpSTktPYm9hSHpWYURHblZLSUl3azY3XC9zclwvWmdlb0l3bHVkVFJBaGdOblhWTjd0biIsI" 1 => "acabiz_session=eyJpdiI6ImlzSHdNNkRXWDNJaStNTVNPdGZYVEE9PSIsInZhbHVlIjoicWhGdnc1N3Ztb2loejFwcE1jREFJVjZJa2dZSDhrU1pZdGRETkhFYnV6UG5UaVIzUHQxcjBwMDRyaHY1Y3NLbCIsIm1hYyI6IjhjNzcwNzFhMGRkNDdiOTE0ZjFlYjEzNmQ2Y2ZlMTEwMTkxYzFkNjgxYzU3YjM1MjU4OWUzMTg5ZjFlMmVlZGEifQ%3D%3D; expires=Sat, 26-Apr-2025 21:37:26 GMT; Max-Age=720000; path=/; httponlyacabiz_session=eyJpdiI6ImlzSHdNNkRXWDNJaStNTVNPdGZYVEE9PSIsInZhbHVlIjoicWhGdnc1N3Ztb2loejFwcE1jREFJVjZJa2dZSDhrU1pZdGRETkhFYnV6UG5UaVIzUHQxcjBwMDRyaHY1Y3NLbCIsI" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkdiOFd3MTdWOVwvNnd5WXppZTRFVEpBPT0iLCJ2YWx1ZSI6IjZ2WVVxVkp6eDZpMG9JbUpSTktPYm9hSHpWYURHblZLSUl3azY3XC9zclwvWmdlb0l3bHVkVFJBaGdOblhWTjd0biIsIm1hYyI6IjEyYjYxMjZkYjI1OTgxZGEzYWRlZmEzZThkMTI0MzA1NzI4ZWQzMGRkMWY1OTBlZDAwZTk5MTlkNWRkODZmZGYifQ%3D%3D; expires=Sat, 26-Apr-2025 21:37:26 GMT; path=/XSRF-TOKEN=eyJpdiI6IkdiOFd3MTdWOVwvNnd5WXppZTRFVEpBPT0iLCJ2YWx1ZSI6IjZ2WVVxVkp6eDZpMG9JbUpSTktPYm9hSHpWYURHblZLSUl3azY3XC9zclwvWmdlb0l3bHVkVFJBaGdOblhWTjd0biIsI" 1 => "acabiz_session=eyJpdiI6ImlzSHdNNkRXWDNJaStNTVNPdGZYVEE9PSIsInZhbHVlIjoicWhGdnc1N3Ztb2loejFwcE1jREFJVjZJa2dZSDhrU1pZdGRETkhFYnV6UG5UaVIzUHQxcjBwMDRyaHY1Y3NLbCIsIm1hYyI6IjhjNzcwNzFhMGRkNDdiOTE0ZjFlYjEzNmQ2Y2ZlMTEwMTkxYzFkNjgxYzU3YjM1MjU4OWUzMTg5ZjFlMmVlZGEifQ%3D%3D; expires=Sat, 26-Apr-2025 21:37:26 GMT; path=/; httponlyacabiz_session=eyJpdiI6ImlzSHdNNkRXWDNJaStNTVNPdGZYVEE9PSIsInZhbHVlIjoicWhGdnc1N3Ztb2loejFwcE1jREFJVjZJa2dZSDhrU1pZdGRETkhFYnV6UG5UaVIzUHQxcjBwMDRyaHY1Y3NLbCIsI" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "tpaCk1ZcMCU99FXO8T9LpiRbTVVElC4n4yoDiXw7" "_previous" => array:1 [ "url" => "https://staging.acabiz.vn/courses?category%5B0%5D=105" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]