"> ">
207.29msRequest Duration4MBMemory UsageGET videomap/{course_video_id}Route
    • Booting (45.83ms)
    • Application (164.29ms)
      5 templates were rendered
      • home.course.video_detail (resources/views/home/course/video_detail.blade.php)6blade
        Params
        0
        course_info
        1
        learn_user_list
        2
        video_info
        3
        course_video_list
        4
        note_list
        5
        comment_list
      • home.app (resources/views/home/app.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        course_info
        6
        learn_user_list
        7
        video_info
        8
        course_video_list
        9
        note_list
        10
        comment_list
        11
        __currentLoopData
        12
        v
        13
        loop
      • home.header (resources/views/home/header.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        defaultSettingInfo
        6
        course_info
        7
        learn_user_list
        8
        video_info
        9
        course_video_list
        10
        note_list
        11
        comment_list
        12
        __currentLoopData
        13
        v
        14
        loop
        15
        isHeaderAd
      • home.header_user_info (resources/views/home/header_user_info.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        defaultSettingInfo
        6
        course_info
        7
        learn_user_list
        8
        video_info
        9
        course_video_list
        10
        note_list
        11
        comment_list
        12
        __currentLoopData
        13
        v
        14
        loop
        15
        isHeaderAd
      • public.kfzs (resources/views/public/kfzs.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        defaultSettingInfo
        6
        course_info
        7
        learn_user_list
        8
        video_info
        9
        course_video_list
        10
        note_list
        11
        comment_list
        12
        __currentLoopData
        13
        v
        14
        loop
        15
        isHeaderAd
        16
        kf_code
      uri
      GET videomap/{course_video_id}
      middleware
      web, home_version, verify_csrf_token, mobile_browsing, promoter, sso_auto_login
      controller
      App\Http\Controllers\Home\CourseController@getCourseVideoDetail
      namespace
      App\Http\Controllers\Home
      prefix
      null
      where
      file
      app/Http/Controllers/Home/CourseController.php:515-552
      21 statements were executed, 4 of which were duplicated, 17 unique103.02ms
      • select `course_learning`.`id`, `course_learning`.`user_id`, `course_learning`.`course_id`, `course_learning`.`video_id`, `course_learning`.`progress`, `course_learning`.`status`, `course_learning`.`created_at`, `course_learning`.`updated_at` from `course_learning` where `course_learning`.`video_id` = '96' and `course_learning`.`course_id` = '28500'20.11mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 96
        • 1. 28500
      • select `course_soft`.`soft_id`, `category_soft`.`name` from `course_soft` inner join `category_soft` on `category_soft`.`id` = `course_soft`.`soft_id` where `course_soft`.`course_id` = '28500'3.9mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28500
      • select `course`.`id` from `course` where `course`.`clan_id` = 'mmlu9' and `course`.`deleted_at` is null3.91mshxsd_online_4_0
        Metadata
        Bindings
        • 0. mmlu9
      • select `course_soft`.`soft_id`, `category_soft`.`name` from `course_soft` inner join `category_soft` on `category_soft`.`id` = `course_soft`.`soft_id` where `course_soft`.`course_id` = '21'3.93mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 21
      • select `course_learning`.`id`, `course_learning`.`user_id`, `course_learning`.`course_id`, `course_learning`.`video_id`, `course_learning`.`progress`, `course_learning`.`status`, `course_learning`.`created_at`, `course_learning`.`updated_at` from `course_learning` where `course_learning`.`video_id` = '96' and `course_learning`.`course_id` = '28500' limit 84.14mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 96
        • 1. 28500
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `course_soft`.`soft_id`, `category_soft`.`name` from `course_soft` inner join `category_soft` on `category_soft`.`id` = `course_soft`.`soft_id` where `course_soft`.`course_id` = '28500'4.03mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28500
      • select `course`.`id`, `course`.`clan_id`, `course`.`title`, `course`.`new_title`, `course`.`phase`, `course`.`material_id`, `course`.`academy_id`, `course`.`profession_id`, `course`.`type`, `course`.`free_baidu`, `course`.`seo_tdk_title`, `course`.`seo_tdk_keywords`, `course`.`seo_tdk_description`, `course`.`seo_intro`, `course`.`try_listen`, `course`.`cover_web`, `course`.`cover_app`, `course`.`web_detail_intro`, `course`.`seo_detail_intro`, `course`.`price`, `course`.`up_shelf_time`, `course`.`task_stage`, `course`.`down_shelf_time`, `course`.`authorized_deadline`, `course`.`authorized_status`, `course`.`status`, `course`.`begin_time`, `course`.`homework_submit_nums`, `course`.`serial`, `course`.`serial_time`, `course`.`duration`, `course`.`start_time`, `course`.`follow`, `course`.`learning`, `course`.`play_nums`, `course`.`seo_title`, `course`.`seo_keywords`, `course`.`seo_description`, `course`.`recommend_status`, `course`.`recommend_time`, `course`.`weight_order`, `course`.`vip_free`, `course`.`difficulty`, `course`.`created_at`, `course`.`app_detail_intro`, `course`.`intro`, `course`.`share_live`, `course`.`template`, `course`.`recommend_job`, `course`.`recommend_job_learning_time`, `course`.`recommend_job_limit_time`, `course`.`agreement`, `course`.`agreement_detail`, `course`.`apply_pass`, `course`.`is_trinity`, `course`.`teacher_id`, `course`.`cover_poster`, `course`.`service_weeks`, `course`.`task_mode`, `course`.`compulsory_status`, `course`.`limit_view`, `course`.`is_sign`, `course`.`contract_stencil_id`, `course`.`is_send`, `course`.`limit_discount`, `course`.`nav_id`, `course`.`show_type`, `course`.`dingding_qr`, `course`.`updated_at`, `course`.`created_at`, `course`.`sections`, `course`.`show_video`, `course`.`show_video_mp4`, `course`.`category_id`, `course`.`push_validity`, `course`.`pushed_at`, `course`.`seo_edited_at`, `course`.`is_seo`, `course`.`cloudclass_address` from `course` where (`course`.`status` = '1' and `course`.`id` not in ('28500') and `course`.`profession_id` = '22') and `course`.`deleted_at` is null order by `course`.`created_at` desc5.27mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 1
        • 1. 28500
        • 2. 22
      • select `course_video`.`id` as `course_video_id`, `course_video`.`course_id`, `course_video`.`video_id`, `course_video`.`order`, `course_video`.`is_try_see`, `course_video`.`unlock_integral`, `course_video`.`chapter_id`, `course_video`.`created_at`, `course_video`.`updated_at`, `video`.`title` as `video_title`, `video`.`intro` as `video_intro`, `video`.`cover` as `video_cover`, `video`.`duration` as `video_duration`, `video`.`record_type` from `course_video` left join `video` on `video`.`id` = `course_video`.`video_id` where `video`.`record_type` = '1' and `course_video`.`course_id` in ('23804', '1031', '37', '36', '25', '21', '11', '7') and `course_video`.`chapter_id` = '0' group by `course_video`.`video_id` order by `course_video`.`id` desc limit 85.86mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 1
        • 1. 23804
        • 2. 1031
        • 3. 37
        • 4. 36
        • 5. 25
        • 6. 21
        • 7. 11
        • 8. 7
        • 9. 0
      • select * from `video` where `video`.`id` = '126' and `video`.`deleted_at` is null limit 14.1mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 126
        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
      • select * from `video` where `video`.`id` = '125' and `video`.`deleted_at` is null limit 13.93mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 125
        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
      • select `course_learning`.`id`, `course_learning`.`user_id`, `course_learning`.`course_id`, `course_learning`.`video_id`, `course_learning`.`progress`, `course_learning`.`status`, `course_learning`.`created_at`, `course_learning`.`updated_at` from `course_learning` where `course_learning`.`video_id` = '20' and `course_learning`.`course_id` = '23804'3.96mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 20
        • 1. 23804
      • select `course_learning`.`id`, `course_learning`.`user_id`, `course_learning`.`course_id`, `course_learning`.`video_id`, `course_learning`.`progress`, `course_learning`.`status`, `course_learning`.`created_at`, `course_learning`.`updated_at` from `course_learning` where `course_learning`.`video_id` = '19' and `course_learning`.`course_id` = '1031'3.95mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 19
        • 1. 1031
      • select `course_learning`.`id`, `course_learning`.`user_id`, `course_learning`.`course_id`, `course_learning`.`video_id`, `course_learning`.`progress`, `course_learning`.`status`, `course_learning`.`created_at`, `course_learning`.`updated_at` from `course_learning` where `course_learning`.`video_id` = '125' and `course_learning`.`course_id` = '36'3.89mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 125
        • 1. 36
      • select `course_learning`.`id`, `course_learning`.`user_id`, `course_learning`.`course_id`, `course_learning`.`video_id`, `course_learning`.`progress`, `course_learning`.`status`, `course_learning`.`created_at`, `course_learning`.`updated_at` from `course_learning` where `course_learning`.`video_id` = '54' and `course_learning`.`course_id` = '36'3.96mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 54
        • 1. 36
      • select `course_learning`.`id`, `course_learning`.`user_id`, `course_learning`.`course_id`, `course_learning`.`video_id`, `course_learning`.`progress`, `course_learning`.`status`, `course_learning`.`created_at`, `course_learning`.`updated_at` from `course_learning` where `course_learning`.`video_id` = '97' and `course_learning`.`course_id` = '21'4.02mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 97
        • 1. 21
      • select `course_learning`.`id`, `course_learning`.`user_id`, `course_learning`.`course_id`, `course_learning`.`video_id`, `course_learning`.`progress`, `course_learning`.`status`, `course_learning`.`created_at`, `course_learning`.`updated_at` from `course_learning` where `course_learning`.`video_id` = '96' and `course_learning`.`course_id` = '21'4.15mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 96
        • 1. 21
      • select `course_learning`.`id`, `course_learning`.`user_id`, `course_learning`.`course_id`, `course_learning`.`video_id`, `course_learning`.`progress`, `course_learning`.`status`, `course_learning`.`created_at`, `course_learning`.`updated_at` from `course_learning` where `course_learning`.`video_id` = '58' and `course_learning`.`course_id` = '11'3.92mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 58
        • 1. 11
      • select count(*) as aggregate from `course_notes_content` left join `course_notes` on `course_notes_content`.`course_notes_id` = `course_notes`.`id` where `course_notes_content`.`type` = '1' and `course_notes_content`.`app_id` = '4779' group by `course_notes_content`.`course_notes_id`4.14mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 1
        • 1. 4779
      • select count(*) as aggregate from `new_comment` where `new_comment`.`resource_id` = '4779' and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null3.91mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 4779
        • 1. video
      • select `setting`.`id`, `setting`.`name`, `setting`.`value`, `setting`.`created_at` from `setting` where `setting`.`name` in ('webname', 'logo', 'copyright', 'baiduanalytics', 'cnzzanalytics', 'seokeywords', 'seodescription', 'iphone_send_status', 'iphone_free_version', 'ipad_send_status', 'ipad_free_version')3.99mshxsd_online_4_0
        Metadata
        Bindings
        • 0. webname
        • 1. logo
        • 2. copyright
        • 3. baiduanalytics
        • 4. cnzzanalytics
        • 5. seokeywords
        • 6. seodescription
        • 7. iphone_send_status
        • 8. iphone_free_version
        • 9. ipad_send_status
        • 10. ipad_free_version
      • select `setting`.`id`, `setting`.`name`, `setting`.`value`, `setting`.`created_at` from `setting` where `setting`.`name` in ('webname', 'logo', 'copyright', 'baiduanalytics', 'cnzzanalytics', 'seokeywords', 'seodescription', 'iphone_send_status', 'iphone_free_version', 'ipad_send_status', 'ipad_free_version')3.95mshxsd_online_4_0
        Metadata
        Bindings
        • 0. webname
        • 1. logo
        • 2. copyright
        • 3. baiduanalytics
        • 4. cnzzanalytics
        • 5. seokeywords
        • 6. seodescription
        • 7. iphone_send_status
        • 8. iphone_free_version
        • 9. ipad_send_status
        • 10. ipad_free_version
        _token
        Kg8LmMffj2tApbn2kvIxkaFN5Q6rXjbbJrE5khgQ
        sso_register_url
        https://id.hxsd.com//sso/reg?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fvideomap%2F4779
        sso_login_url
        https://id.hxsd.com//sso/login?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fvideomap%2F4779
        sso_logout_url
        https://id.hxsd.com//logout?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fvideomap%2F4779
        _previous
        array:1 [ "url" => "https://hxonline.hxsd.cn/videomap/4779" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        format
        html
        content_type
        text/html; charset=UTF-8
        status_text
        OK
        status_code
        200
        request_query
        []
        request_request
        []
        request_headers
        array:24 [ "slb-id" => array:1 [ 0 => "lb-2zeauqoppardtj7h94xjp" ] "slb-ip" => array:1 [ ...
        request_server
        array:47 [ "USER" => "nginx" "HOME" => "/home/nginx" "HTTP_SLB_ID" => "lb-2zeauqoppardtj7h94xj...
        request_cookies
        array:2 [ "XSRF-TOKEN" => "Kg8LmMffj2tApbn2kvIxkaFN5Q6rXjbbJrE5khgQ" "hxsd_online_4_0" => "A6HyN...
        response_headers
        array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
        path_info
        /videomap/4779
        session_attributes
        array:6 [ "_token" => "Kg8LmMffj2tApbn2kvIxkaFN5Q6rXjbbJrE5khgQ" "sso_register_url" => "https://...