"> ">
204.43msRequest Duration4MBMemory UsageGET videomap/{course_video_id}Route
    • Booting (45.6ms)
    • Application (161.69ms)
      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
      24 statements were executed, 4 of which were duplicated, 20 unique101.94ms
      • select * from `video` where `video`.`id` = '351' and `video`.`deleted_at` is null limit 116.45mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 351
        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` = '351' and `course_learning`.`course_id` = '23812'3.3mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 351
        • 1. 23812
      • select * from `course` where `course`.`id` = '23812' and `course`.`deleted_at` is null limit 13.69mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 23812
        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_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` = '23812'3.28mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 23812
      • select `course`.`id` from `course` where `course`.`clan_id` = 'u0suu' and `course`.`deleted_at` is null3.23mshxsd_online_4_0
        Metadata
        Bindings
        • 0. u0suu
      • 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` = '351' and `course_learning`.`course_id` = '23812' limit 83.36mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 351
        • 1. 23812
        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` = '23812'3.27mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 23812
      • 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 ('23812') and `course`.`profession_id` = '2') and `course`.`deleted_at` is null order by `course`.`created_at` desc10.91mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 1
        • 1. 23812
        • 2. 2
      • 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 ('28544', '28539', '28526', '28487', '28447', '28394', '28391', '28381', '28369', '28355', '25495', '25471', '25469', '25467', '25466', '25433', '25424', '25401', '25215', '25173', '25166', '25156', '25143', '25135', '23914', '25123', '23902', '23900', '23883', '23874', '23872', '23871', '23870', '23855', '23854', '23853', '23850', '23838', '23835', '23833', '29', '15', '8', '6') and `course_video`.`chapter_id` = '0' group by `course_video`.`video_id` order by `course_video`.`id` desc limit 85.6mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 1
        • 1. 28544
        • 2. 28539
        • 3. 28526
        • 4. 28487
        • 5. 28447
        • 6. 28394
        • 7. 28391
        • 8. 28381
        • 9. 28369
        • 10. 28355
        • 11. 25495
        • 12. 25471
        • 13. 25469
        • 14. 25467
        • 15. 25466
        • 16. 25433
        • 17. 25424
        • 18. 25401
        • 19. 25215
        • 20. 25173
        • 21. 25166
        • 22. 25156
        • 23. 25143
        • 24. 25135
        • 25. 23914
        • 26. 25123
        • 27. 23902
        • 28. 23900
        • 29. 23883
        • 30. 23874
        • 31. 23872
        • 32. 23871
        • 33. 23870
        • 34. 23855
        • 35. 23854
        • 36. 23853
        • 37. 23850
        • 38. 23838
        • 39. 23835
        • 40. 23833
        • 41. 29
        • 42. 15
        • 43. 8
        • 44. 6
        • 45. 0
      • 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` = '95' and `course_learning`.`course_id` = '28526'3.29mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 95
        • 1. 28526
      • 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` = '28391'3.22mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 96
        • 1. 28391
      • 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` = '105625' and `course_learning`.`course_id` = '25469'3.2mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 105625
        • 1. 25469
      • 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` = '105622' and `course_learning`.`course_id` = '28369'3.19mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 105622
        • 1. 28369
      • 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` = '121' and `course_learning`.`course_id` = '25467'3.26mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 121
        • 1. 25467
      • 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` = '105589' and `course_learning`.`course_id` = '25466'3.22mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 105589
        • 1. 25466
      • 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` = '105555' and `course_learning`.`course_id` = '25424'3.19mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 105555
        • 1. 25424
      • 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` = '693' and `course_learning`.`course_id` = '25401'3.25mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 693
        • 1. 25401
      • 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` = '2300' group by `course_notes_content`.`course_notes_id`3.27mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 1
        • 1. 2300
      • select count(*) as aggregate from `new_comment` where `new_comment`.`resource_id` = '2300' and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null3.23mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 2300
        • 1. video
      • select `new_comment`.`id`, `new_comment`.`resource_id`, `new_comment`.`resource_name`, `new_comment`.`video_title`, `new_comment`.`user_id`, `new_comment`.`comment_id`, `new_comment`.`title`, `new_comment`.`content`, `new_comment`.`depth`, `new_comment`.`favour`, `new_comment`.`status`, `new_comment`.`profession_id`, `new_comment`.`delete_user`, `new_comment`.`created_at`, `new_comment`.`deleted_at` from `new_comment` where `new_comment`.`resource_id` = '2300' and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null order by `created_at` desc limit 8 offset 03.4mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 2300
        • 1. video
      • select `id`, `user_id`, `comment_id`, `attachment_id`, `seek_time`, `created_at` from `comment_attachment` where `comment_attachment`.`comment_id` = '149' and `comment_attachment`.`deleted_at` is null3.18mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 149
      • select `id`, `user_id`, `comment_id`, `attachment_id`, `seek_time`, `created_at` from `comment_attachment` where `comment_attachment`.`comment_id` = '140' and `comment_attachment`.`deleted_at` is null3.24mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 140
      • 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.3mshxsd_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.41mshxsd_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
        4fSxNI6xZUQPInI8CnxfClEuFpYQNAPHb6zApjl1
        sso_register_url
        https://id.hxsd.com//sso/reg?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fvideomap%2F2300
        sso_login_url
        https://id.hxsd.com//sso/login?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fvideomap%2F2300
        sso_logout_url
        https://id.hxsd.com//logout?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fvideomap%2F2300
        _previous
        array:1 [ "url" => "https://hxonline.hxsd.cn/videomap/2300" ]
        _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" => "4fSxNI6xZUQPInI8CnxfClEuFpYQNAPHb6zApjl1" "hxsd_online_4_0" => "vKFYt...
        response_headers
        array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
        path_info
        /videomap/2300
        session_attributes
        array:6 [ "_token" => "4fSxNI6xZUQPInI8CnxfClEuFpYQNAPHb6zApjl1" "sso_register_url" => "https://...