"> ">
270.39msRequest Duration4MBMemory UsageGET course/{id}Route
    • Booting (46.73ms)
    • Application (226.28ms)
      8 templates were rendered
      • home_v4.course.detail (resources/views/home_v4/course/detail.blade.php)30blade
        Params
        0
        video_list
        1
        curr_video
        2
        video_sum
        3
        user_course_status
        4
        course_lecturer
        5
        user_learning
        6
        similar_course
        7
        view
        8
        id
        9
        list
        10
        course_info
        11
        live_sum
        12
        course_soft
        13
        is_collect_course
        14
        learn_num
        15
        qidian_link
        16
        soft_text
        17
        prepurchaseInfo
        18
        is_manager
        19
        user_info
        20
        is_first
        21
        is_auth
        22
        is_pop
        23
        video_url
        24
        current_tab
        25
        nav_ids
        26
        show_tip
        27
        is_try
        28
        show_sign_up_btn
        29
        type_path
      • home_v4.course.detail_record_video (resources/views/home_v4/course/detail_record_video.blade.php)39blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        video_list
        6
        curr_video
        7
        video_sum
        8
        user_course_status
        9
        course_lecturer
        10
        user_learning
        11
        similar_course
        12
        view
        13
        id
        14
        list
        15
        course_info
        16
        live_sum
        17
        course_soft
        18
        is_collect_course
        19
        learn_num
        20
        qidian_link
        21
        soft_text
        22
        prepurchaseInfo
        23
        is_manager
        24
        user_info
        25
        is_first
        26
        is_auth
        27
        is_pop
        28
        video_url
        29
        current_tab
        30
        nav_ids
        31
        show_tip
        32
        is_try
        33
        show_sign_up_btn
        34
        type_path
        35
        __currentLoopData
        36
        v
        37
        k
        38
        loop
      • home_v4.course.detail_common (resources/views/home_v4/course/detail_common.blade.php)40blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        video_list
        6
        curr_video
        7
        video_sum
        8
        user_course_status
        9
        course_lecturer
        10
        user_learning
        11
        similar_course
        12
        view
        13
        id
        14
        list
        15
        course_info
        16
        live_sum
        17
        course_soft
        18
        is_collect_course
        19
        learn_num
        20
        qidian_link
        21
        soft_text
        22
        prepurchaseInfo
        23
        is_manager
        24
        user_info
        25
        is_first
        26
        is_auth
        27
        is_pop
        28
        video_url
        29
        current_tab
        30
        nav_ids
        31
        show_tip
        32
        is_try
        33
        show_sign_up_btn
        34
        type_path
        35
        __currentLoopData
        36
        v
        37
        k
        38
        loop
        39
        item
      • home_v4.course.detail_similar_course (resources/views/home_v4/course/detail_similar_course.blade.php)40blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        video_list
        6
        curr_video
        7
        video_sum
        8
        user_course_status
        9
        course_lecturer
        10
        user_learning
        11
        similar_course
        12
        view
        13
        id
        14
        list
        15
        course_info
        16
        live_sum
        17
        course_soft
        18
        is_collect_course
        19
        learn_num
        20
        qidian_link
        21
        soft_text
        22
        prepurchaseInfo
        23
        is_manager
        24
        user_info
        25
        is_first
        26
        is_auth
        27
        is_pop
        28
        video_url
        29
        current_tab
        30
        nav_ids
        31
        show_tip
        32
        is_try
        33
        show_sign_up_btn
        34
        type_path
        35
        __currentLoopData
        36
        v
        37
        k
        38
        loop
        39
        item
      • home_v4.app (resources/views/home_v4/app.blade.php)39blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        video_list
        6
        curr_video
        7
        video_sum
        8
        user_course_status
        9
        course_lecturer
        10
        user_learning
        11
        similar_course
        12
        view
        13
        id
        14
        list
        15
        course_info
        16
        live_sum
        17
        course_soft
        18
        is_collect_course
        19
        learn_num
        20
        qidian_link
        21
        soft_text
        22
        prepurchaseInfo
        23
        is_manager
        24
        user_info
        25
        is_first
        26
        is_auth
        27
        is_pop
        28
        video_url
        29
        current_tab
        30
        nav_ids
        31
        show_tip
        32
        is_try
        33
        show_sign_up_btn
        34
        type_path
        35
        __currentLoopData
        36
        v
        37
        k
        38
        loop
      • home_v4.header (resources/views/home_v4/header.blade.php)41blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        defaultSettingInfo
        6
        video_list
        7
        curr_video
        8
        video_sum
        9
        user_course_status
        10
        course_lecturer
        11
        user_learning
        12
        similar_course
        13
        view
        14
        id
        15
        list
        16
        course_info
        17
        live_sum
        18
        course_soft
        19
        is_collect_course
        20
        learn_num
        21
        qidian_link
        22
        soft_text
        23
        prepurchaseInfo
        24
        is_manager
        25
        user_info
        26
        is_first
        27
        is_auth
        28
        is_pop
        29
        video_url
        30
        current_tab
        31
        nav_ids
        32
        show_tip
        33
        is_try
        34
        show_sign_up_btn
        35
        type_path
        36
        __currentLoopData
        37
        v
        38
        k
        39
        loop
        40
        isHeaderAd
      • home_v4.header_user_info (resources/views/home_v4/header_user_info.blade.php)41blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        defaultSettingInfo
        6
        video_list
        7
        curr_video
        8
        video_sum
        9
        user_course_status
        10
        course_lecturer
        11
        user_learning
        12
        similar_course
        13
        view
        14
        id
        15
        list
        16
        course_info
        17
        live_sum
        18
        course_soft
        19
        is_collect_course
        20
        learn_num
        21
        qidian_link
        22
        soft_text
        23
        prepurchaseInfo
        24
        is_manager
        25
        user_info
        26
        is_first
        27
        is_auth
        28
        is_pop
        29
        video_url
        30
        current_tab
        31
        nav_ids
        32
        show_tip
        33
        is_try
        34
        show_sign_up_btn
        35
        type_path
        36
        __currentLoopData
        37
        v
        38
        k
        39
        loop
        40
        isHeaderAd
      • public.kfzs (resources/views/public/kfzs.blade.php)42blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        menuActive
        4
        errors
        5
        defaultSettingInfo
        6
        video_list
        7
        curr_video
        8
        video_sum
        9
        user_course_status
        10
        course_lecturer
        11
        user_learning
        12
        similar_course
        13
        view
        14
        id
        15
        list
        16
        course_info
        17
        live_sum
        18
        course_soft
        19
        is_collect_course
        20
        learn_num
        21
        qidian_link
        22
        soft_text
        23
        prepurchaseInfo
        24
        is_manager
        25
        user_info
        26
        is_first
        27
        is_auth
        28
        is_pop
        29
        video_url
        30
        current_tab
        31
        nav_ids
        32
        show_tip
        33
        is_try
        34
        show_sign_up_btn
        35
        type_path
        36
        __currentLoopData
        37
        v
        38
        k
        39
        loop
        40
        isHeaderAd
        41
        kf_code
      uri
      GET course/{id}
      middleware
      web, home_version, verify_csrf_token, mobile_browsing, promoter, sso_auto_login
      controller
      App\Http\Controllers\Home\V4\CourseController@getCourseInfo
      namespace
      App\Http\Controllers\Home\V4
      prefix
      /course
      where
      file
      app/Http/Controllers/Home/V4/CourseController.php:117-154
      27 statements were executed, 16 of which were duplicated, 11 unique129.59ms
      • 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` = '28540'17.87mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • select sum(`course`.`learning`) as aggregate from `course` where `course`.`clan_id` = 'uv177' and `course`.`deleted_at` is null3.63mshxsd_online_4_0
        Metadata
        Bindings
        • 0. uv177
      • 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`, `video`.`id`, `video`.`title`, `video`.`intro`, `video`.`filename`, `video`.`material_id`, `video`.`cover`, `video`.`duration`, `video`.`status`, `video`.`oss_path`, `video`.`aliyun_run_id`, `video`.`aliyun_media_id`, `video`.`seo_keywords`, `video`.`seo_description`, `video`.`record_type`, `video`.`created_at`, `video`.`deleted_at` from `course_video` left join `video` on `video`.`id` = `course_video`.`video_id` where `course_video`.`chapter_id` = '0' and `course_video`.`course_id` = '28540' order by `order` asc3.97mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 0
        • 1. 28540
      • select `course_soft`.`soft_id` from `course_soft` where `course_soft`.`course_id` = '28540'3.68mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • select `category_soft`.`id`, `category_soft`.`parent_id`, `category_soft`.`name`, `category_soft`.`alias`, `category_soft`.`intro`, `category_soft`.`order`, `category_soft`.`cover`, `category_soft`.`is_view`, `category_soft`.`created_at`, `category_soft`.`seo_title`, `category_soft`.`seo_keywords`, `category_soft`.`seo_description` from `category_soft` where `category_soft`.`id` = '109' and `category_soft`.`deleted_at` is null limit 13.74mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 109
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `category_soft`.`id`, `category_soft`.`parent_id`, `category_soft`.`name`, `category_soft`.`alias`, `category_soft`.`intro`, `category_soft`.`order`, `category_soft`.`cover`, `category_soft`.`is_view`, `category_soft`.`created_at`, `category_soft`.`seo_title`, `category_soft`.`seo_keywords`, `category_soft`.`seo_description` from `category_soft` where `category_soft`.`id` = '114' and `category_soft`.`deleted_at` is null limit 13.64mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 114
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `course_lecturer`.`lecturer_id` from `course_lecturer` where `course_lecturer`.`course_id` = '28540'3.6mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • 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`.`course_id` = '28540' order by `course_learning`.`updated_at` desc limit 83.72mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • 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` from `course_video` where `course_video`.`course_id` = '28540' and `course_video`.`video_id` = '130' limit 13.58mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
        • 1. 130
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `video` where `video`.`id` = '130' and `video`.`deleted_at` is null limit 13.63mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 130
        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 `user_course`.`id`, `user_course`.`user_id`, `user_course`.`course_id`, `user_course`.`created_at` from `user_course` where `user_course`.`course_id` = '28540'3.68mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • select `course_zhibo`.`id` as `course_live_id`, `course_zhibo`.`zhibo_id`, `course_zhibo`.`order`, `course_zhibo`.`course_id` from `course_zhibo` where `course_zhibo`.`course_id` = '28540' order by `course_zhibo`.`order` asc3.66mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • select `zhibo_user_record`.`id` from `zhibo_user_record` where `zhibo_user_record`.`zhibo_id` in ('1798', '1803', '1813', '1814') and `zhibo_user_record`.`type` = 'enter' limit 200004.49mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 1798
        • 1. 1803
        • 2. 1813
        • 3. 1814
        • 4. enter
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `wechat_poster`.`id`, `wechat_poster`.`classify`, `wechat_poster`.`product_type`, `wechat_poster`.`product_id`, `wechat_poster`.`text`, `wechat_poster`.`task_num`, `wechat_poster`.`end_date`, `wechat_poster`.`status`, `wechat_poster`.`option_name`, `wechat_poster`.`updated_at`, `wechat_reply_word`.`word` from `wechat_poster` left join `wechat_reply_word` on `wechat_poster`.`id` = `wechat_reply_word`.`reply_poster_id` where `product_id` = '28540' limit 13.68mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `course_zhibo`.`id` as `course_live_id`, `course_zhibo`.`zhibo_id`, `course_zhibo`.`order`, `course_zhibo`.`course_id` from `course_zhibo` where `course_zhibo`.`course_id` = '28540' order by `course_zhibo`.`order` asc3.69mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • select `course`.`id` from `course` where `course`.`type` not in ('5', '6', '7') and `course`.`status` = '1' and `course`.`academy_id` = '1' and `course`.`deleted_at` is null4.06mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 5
        • 1. 6
        • 2. 7
        • 3. 1
        • 4. 1
      • select `course`.`id`, `course`.`clan_id`, `course`.`title`, `course`.`phase`, `course`.`material_id`, `course`.`academy_id`, `course`.`profession_id`, `course`.`type`, `course`.`try_listen`, `course`.`cover_web`, `course`.`cover_app`, `course`.`web_detail_intro`, `course`.`price`, `course`.`up_shelf_time`, `course`.`down_shelf_time`, `course`.`authorized_deadline`, `course`.`authorized_status`, `course`.`status`, `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`.`apply_pass`, `course`.`is_trinity`, `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` from `course` where `course`.`type` not in ('5', '6', '7') and `course`.`status` = '1' and `course`.`academy_id` = '1' and `course`.`deleted_at` is null order by `course`.`created_at` desc limit 3 offset 011.55mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 5
        • 1. 6
        • 2. 7
        • 3. 1
        • 4. 1
      • select sum(`avg_score`) as aggregate from `user_course_comment` where `user_course_comment`.`course_id` = '28540' and `user_course_comment`.`deleted_at` is null3.78mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • select count(*) as aggregate from `user_course_comment` where `user_course_comment`.`course_id` = '28540' and `user_course_comment`.`deleted_at` is null3.59mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • 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`, `video`.`id`, `video`.`title`, `video`.`intro`, `video`.`filename`, `video`.`material_id`, `video`.`cover`, `video`.`duration`, `video`.`status`, `video`.`oss_path`, `video`.`aliyun_run_id`, `video`.`aliyun_media_id`, `video`.`seo_keywords`, `video`.`seo_description`, `video`.`record_type`, `video`.`created_at`, `video`.`deleted_at` from `course_video` left join `video` on `video`.`id` = `course_video`.`video_id` where `course_video`.`chapter_id` = '0' and `course_video`.`course_id` = '28540' order by `order` asc4.06mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 0
        • 1. 28540
      • select `course_lecturer`.`lecturer_id` from `course_lecturer` where `course_lecturer`.`course_id` = '28540'3.58mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • 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`.`course_id` = '28540' order by `course_learning`.`updated_at` desc limit 83.59mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
      • 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` from `course_video` where `course_video`.`course_id` = '28540' and `course_video`.`video_id` = '130' limit 13.66mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 28540
        • 1. 130
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `course`.`id` from `course` where `course`.`type` not in ('5', '6', '7') and `course`.`status` = '1' and `course`.`academy_id` = '1' and `course`.`deleted_at` is null3.96mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 5
        • 1. 6
        • 2. 7
        • 3. 1
        • 4. 1
      • select `course`.`id`, `course`.`clan_id`, `course`.`title`, `course`.`phase`, `course`.`material_id`, `course`.`academy_id`, `course`.`profession_id`, `course`.`type`, `course`.`try_listen`, `course`.`cover_web`, `course`.`cover_app`, `course`.`web_detail_intro`, `course`.`price`, `course`.`up_shelf_time`, `course`.`down_shelf_time`, `course`.`authorized_deadline`, `course`.`authorized_status`, `course`.`status`, `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`.`apply_pass`, `course`.`is_trinity`, `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` from `course` where `course`.`type` not in ('5', '6', '7') and `course`.`status` = '1' and `course`.`academy_id` = '1' and `course`.`deleted_at` is null order by `course`.`created_at` desc limit 3 offset 09.78mshxsd_online_4_0
        Metadata
        Bindings
        • 0. 5
        • 1. 6
        • 2. 7
        • 3. 1
        • 4. 1
      • 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.77mshxsd_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
        tidaavAFV0L2aGlYDntz3NlzhNRhUC9D9wVlsVyE
        sso_register_url
        https://id.hxsd.com//sso/reg?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fcourse%2F28540
        sso_login_url
        https://id.hxsd.com//sso/login?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fcourse%2F28540
        sso_logout_url
        https://id.hxsd.com//logout?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fcourse%2F28540
        _previous
        array:1 [ "url" => "https://hxonline.hxsd.cn/course/28540" ]
        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:23 [ "slb-id" => array:1 [ 0 => "lb-2zeauqoppardtj7h94xjp" ] "slb-ip" => array:1 [ ...
        request_server
        array:46 [ "USER" => "nginx" "HOME" => "/home/nginx" "HTTP_SLB_ID" => "lb-2zeauqoppardtj7h94xj...
        request_cookies
        []
        response_headers
        array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
        path_info
        /course/28540
        session_attributes
        array:6 [ "_token" => "tidaavAFV0L2aGlYDntz3NlzhNRhUC9D9wVlsVyE" "sso_register_url" => "https://...