"> ">
308.61msRequest Duration6MBMemory UsageGET videomap/{course_video_id}Route
    • Booting (54.54ms)
    • Application (258.57ms)
      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
      42 statements were executed, 4 of which were duplicated, 38 unique170.73ms
      • select * from `course_video` where `course_video`.`id` = '4320' limit 117.09mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 4320
        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` = '99' and `course_learning`.`course_id` = '25487'4.12mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 99
        • 1. 25487
      • 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` = '25487'3.44mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25487
      • select `course`.`id` from `course` where `course`.`clan_id` = 'prhrf' and `course`.`deleted_at` is null3.5mshxsd_online_4_0
        Metadata
        Bindings
        • 0. prhrf
      • 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` = '25368'3.43mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25368
      • 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` = '25473'3.39mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25473
      • 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` = '25474'3.36mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25474
      • 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` = '25475'3.37mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25475
      • 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` = '25476'3.36mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25476
      • 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` = '25477'3.42mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25477
      • 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` = '25478'3.42mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25478
      • 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` = '25479'3.41mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25479
      • 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` = '25480'4.35mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25480
      • 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` = '25481'3.66mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25481
      • 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` = '25482'3.45mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25482
      • 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` = '25483'3.44mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25483
      • 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` = '25484'3.37mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25484
      • 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` = '25485'3.7mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25485
      • 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` = '25486'3.9mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25486
      • 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` = '25488'3.39mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25488
      • 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` = '25489'3.37mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25489
      • 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` = '25490'3.4mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25490
      • 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` = '25491'3.43mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25491
      • 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` = '25493'3.41mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25493
      • 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` = '25494'3.47mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25494
      • select * from `category_academy` where `category_academy`.`id` = '8' and `category_academy`.`deleted_at` is null limit 13.42mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 8
        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` = '99' and `course_learning`.`course_id` = '25487' limit 83.5mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 99
        • 1. 25487
        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` = '25487'3.44mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 25487
      • 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 ('25487') and `course`.`profession_id` = '24') and `course`.`deleted_at` is null order by `course`.`created_at` desc6.25mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 1
        • 1. 25487
        • 2. 24
      • 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 ('28441', '28403', '25494', '25493', '25491', '25490', '25489', '25488', '25486', '25485', '25484', '25483', '25482', '25481', '25480', '25479', '25478', '25477', '25476', '25475', '25474', '25473', '25231', '25217', '25197', '23909', '23907', '23905', '1017', '1016', '1001', '33', '19', '25368') and `course_video`.`chapter_id` = '0' group by `course_video`.`video_id` order by `course_video`.`id` desc limit 810.78mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 1
        • 1. 28441
        • 2. 28403
        • 3. 25494
        • 4. 25493
        • 5. 25491
        • 6. 25490
        • 7. 25489
        • 8. 25488
        • 9. 25486
        • 10. 25485
        • 11. 25484
        • 12. 25483
        • 13. 25482
        • 14. 25481
        • 15. 25480
        • 16. 25479
        • 17. 25478
        • 18. 25477
        • 19. 25476
        • 20. 25475
        • 21. 25474
        • 22. 25473
        • 23. 25231
        • 24. 25217
        • 25. 25197
        • 26. 23909
        • 27. 23907
        • 28. 23905
        • 29. 1017
        • 30. 1016
        • 31. 1001
        • 32. 33
        • 33. 19
        • 34. 25368
        • 35. 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` = '54' and `course_learning`.`course_id` = '28441'3.56mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 54
        • 1. 28441
      • 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` = '53' and `course_learning`.`course_id` = '28403'3.41mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 53
        • 1. 28403
      • 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` = '105620' and `course_learning`.`course_id` = '25217'3.4mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 105620
        • 1. 25217
      • 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` = '132' and `course_learning`.`course_id` = '25368'3.32mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 132
        • 1. 25368
      • 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` = '317' and `course_learning`.`course_id` = '25368'3.5mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 317
        • 1. 25368
      • 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` = '98' and `course_learning`.`course_id` = '25368'3.38mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 98
        • 1. 25368
      • 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` = '25368'3.45mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 58
        • 1. 25368
      • 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` = '115' and `course_learning`.`course_id` = '25368'3.46mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 115
        • 1. 25368
      • 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` = '4320' group by `course_notes_content`.`course_notes_id`3.48mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 1
        • 1. 4320
      • select count(*) as aggregate from `new_comment` where `new_comment`.`resource_id` = '4320' and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null3.52mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 4320
        • 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.67mshxsd_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.54mshxsd_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
        ySc29490MMeUdrD61RNmblceiNmN66T2QMTjagwK
        sso_register_url
        https://id.hxsd.com//sso/reg?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fvideomap%2F4320
        sso_login_url
        https://id.hxsd.com//sso/login?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fvideomap%2F4320
        sso_logout_url
        https://id.hxsd.com//logout?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fvideomap%2F4320
        _previous
        array:1 [ "url" => "https://hxonline.hxsd.cn/videomap/4320" ]
        _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" => "ySc29490MMeUdrD61RNmblceiNmN66T2QMTjagwK" "hxsd_online_4_0" => "O86rU...
        response_headers
        array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
        path_info
        /videomap/4320
        session_attributes
        array:6 [ "_token" => "ySc29490MMeUdrD61RNmblceiNmN66T2QMTjagwK" "sso_register_url" => "https://...