ghgjgjg

回答问题

Mars_5887913 发布于2019-02-17 15:38:55

来自：学生作业点评视频 0分钟3秒

提交答案

Mars_5887913

做最好的自己

关注

提问

47
回答

50
粉丝

0

编辑

保存

邀请其他同学来帮你解答

帮助服务

服务热线质量监督意见反馈帮助中心隐私政策

团队简介

关于我们联系我们加入我们讲师合作

渠道合作

申请代理商

火星证书

证书

关于我们 - me.hxsd.tv

意见反馈Q群：717157554

"> ">

Messages Timeline Exceptions Views7 Route Queries30 Mails Session Request

195.72ms4MBGET course/{id}/comment/detail

Booting (46.73ms)
Application (151.96ms)

7 templates were rendered

home.comment.detail (resources/views/home/comment/detail.blade.php)8blade
Params
0
title
1
comment_info
2
comment_list
3
course_info
4
reply_list
5
auth_user_id
6
notes_list
7
video_list

Params
0	`title`
1	`comment_info`
2	`comment_list`
3	`course_info`
4	`reply_list`
5	`auth_user_id`
6	`notes_list`
7	`video_list`

home.comment.reply_list (resources/views/home/comment/reply_list.blade.php)15blade


obLevel
__env
app
errors
title
comment_info
comment_list
course_info
reply_list
auth_user_id
notes_list
video_list
__currentLoopData
item
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`title`
5	`comment_info`
6	`comment_list`
7	`course_info`
8	`reply_list`
9	`auth_user_id`
10	`notes_list`
11	`video_list`
12	`__currentLoopData`
13	`item`
14	`loop`

home.page (resources/views/home/page.blade.php)16blade


obLevel
__env
app
errors
title
comment_info
comment_list
course_info
reply_list
auth_user_id
notes_list
video_list
__currentLoopData
item
loop
pages

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`title`
5	`comment_info`
6	`comment_list`
7	`course_info`
8	`reply_list`
9	`auth_user_id`
10	`notes_list`
11	`video_list`
12	`__currentLoopData`
13	`item`
14	`loop`
15	`pages`

home.app (resources/views/home/app.blade.php)16blade


obLevel
__env
app
errors
title
comment_info
comment_list
course_info
reply_list
auth_user_id
notes_list
video_list
__currentLoopData
item
loop
k

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`title`
5	`comment_info`
6	`comment_list`
7	`course_info`
8	`reply_list`
9	`auth_user_id`
10	`notes_list`
11	`video_list`
12	`__currentLoopData`
13	`item`
14	`loop`
15	`k`

home.header (resources/views/home/header.blade.php)18blade


obLevel
__env
app
errors
defaultSettingInfo
title
comment_info
comment_list
course_info
reply_list
auth_user_id
notes_list
video_list
__currentLoopData
item
loop
k
isHeaderAd

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`defaultSettingInfo`
5	`title`
6	`comment_info`
7	`comment_list`
8	`course_info`
9	`reply_list`
10	`auth_user_id`
11	`notes_list`
12	`video_list`
13	`__currentLoopData`
14	`item`
15	`loop`
16	`k`
17	`isHeaderAd`

home.header_user_info (resources/views/home/header_user_info.blade.php)18blade


obLevel
__env
app
errors
defaultSettingInfo
title
comment_info
comment_list
course_info
reply_list
auth_user_id
notes_list
video_list
__currentLoopData
item
loop
k
isHeaderAd

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`defaultSettingInfo`
5	`title`
6	`comment_info`
7	`comment_list`
8	`course_info`
9	`reply_list`
10	`auth_user_id`
11	`notes_list`
12	`video_list`
13	`__currentLoopData`
14	`item`
15	`loop`
16	`k`
17	`isHeaderAd`

public.kfzs (resources/views/public/kfzs.blade.php)19blade


obLevel
__env
app
errors
defaultSettingInfo
title
comment_info
comment_list
course_info
reply_list
auth_user_id
notes_list
video_list
__currentLoopData
item
loop
k
isHeaderAd
kf_code

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`defaultSettingInfo`
5	`title`
6	`comment_info`
7	`comment_list`
8	`course_info`
9	`reply_list`
10	`auth_user_id`
11	`notes_list`
12	`video_list`
13	`__currentLoopData`
14	`item`
15	`loop`
16	`k`
17	`isHeaderAd`
18	`kf_code`

uri: GET course/{id}/comment/detail
middleware: web, home_version, verify_csrf_token, mobile_browsing, promoter, sso_auto_login
controller: App\Http\Controllers\Home\CommentController@commentDetail
namespace: App\Http\Controllers\Home
prefix: /course
where
file: app/Http/Controllers/Home/CommentController.php:222-256

30 statements were executed, 4 of which were duplicated, 26 unique104.01ms

select * from `new_comment` where `new_comment`.`id` = '608' and `new_comment`.`deleted_at` is null limit 115.64mshxsd_online_4_0
Metadata
Bindings
0. 608
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 `id`, `user_id`, `comment_id`, `attachment_id`, `seek_time`, `created_at` from `comment_attachment` where `comment_attachment`.`comment_id` = '608' and `comment_attachment`.`deleted_at` is null2.85mshxsd_online_4_0
Metadata
Bindings
0. 608
select * from `attachment` where `attachment`.`id` = '3712' limit 12.9mshxsd_online_4_0
Metadata
Bindings
0. 3712
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 `course_video` where `course_video`.`id` = '2944' limit 12.86mshxsd_online_4_0
Metadata
Bindings
0. 2944
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 count(*) as aggregate from `new_comment` where `new_comment`.`user_id` = '372295' and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null3.19mshxsd_online_4_0
Metadata
Bindings
0. 372295
1. video
select count(*) as aggregate from `new_comment` where `new_comment`.`user_id` = '372295' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.1mshxsd_online_4_0
Metadata
Bindings
0. 372295
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '608' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.08mshxsd_online_4_0
Metadata
Bindings
0. 608
1. comment
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` = '1059'2.89mshxsd_online_4_0
Metadata
Bindings
0. 1059
select `course`.`id` from `course` where `course`.`clan_id` = 'mi0eb' and `course`.`deleted_at` is null2.81mshxsd_online_4_0
Metadata
Bindings
0. mi0eb
select `id`, `user_id`, `comment_id`, `attachment_id`, `seek_time`, `created_at` from `comment_attachment` where `comment_attachment`.`comment_id` = '608' and `comment_attachment`.`deleted_at` is null2.8mshxsd_online_4_0
Metadata
Bindings
0. 608
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 `video_id` in ('77')3.07mshxsd_online_4_0
Metadata
Bindings
0. 77

Metadata
Bindings	0. 608
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

Metadata
Bindings	0. 608

Metadata
Bindings	0. 3712
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

Metadata
Bindings	0. 2944
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

Metadata
Bindings	0. 372295 1. video

Metadata
Bindings	0. 372295 1. comment

Metadata
Bindings	0. 608 1. comment

Metadata
Bindings	0. 1059

Metadata
Bindings	0. mi0eb

Metadata
Bindings	0. 608

Metadata
Bindings	0. 77

select count(*) as aggregate from `new_comment` where `resource_id` in ('61', '1895', '1967', '2021', '2068', '2185', '2244', '2253', '2318', '2591', '2690', '2903', '2944', '2960', '3019', '3084', '3126', '3166', '3206', '3256', '3285', '3325', '3391', '3751', '3795', '3839', '3883', '3927', '3971', '4015', '4059', '4103', '4147', '4191', '4235', '4279', '4323', '4367', '4411', '4455', '4499', '4543', '4587', '4956') and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null

3.12mshxsd_online_4_0

Metadata
Bindings	0. 61 1. 1895 2. 1967 3. 2021 4. 2068 5. 2185 6. 2244 7. 2253 8. 2318 9. 2591 10. 2690 11. 2903 12. 2944 13. 2960 14. 3019 15. 3084 16. 3126 17. 3166 18. 3206 19. 3256 20. 3285 21. 3325 22. 3391 23. 3751 24. 3795 25. 3839 26. 3883 27. 3927 28. 3971 29. 4015 30. 4059 31. 4103 32. 4147 33. 4191 34. 4235 35. 4279 36. 4323 37. 4367 38. 4411 39. 4455 40. 4499 41. 4543 42. 4587 43. 4956 44. 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`.`seek_time`, `new_comment`.`depth`, `new_comment`.`favour`, `new_comment`.`status`, `new_comment`.`profession_id`, `new_comment`.`created_at` from `new_comment` where `resource_id` in ('61', '1895', '1967', '2021', '2068', '2185', '2244', '2253', '2318', '2591', '2690', '2903', '2944', '2960', '3019', '3084', '3126', '3166', '3206', '3256', '3285', '3325', '3391', '3751', '3795', '3839', '3883', '3927', '3971', '4015', '4059', '4103', '4147', '4191', '4235', '4279', '4323', '4367', '4411', '4455', '4499', '4543', '4587', '4956') and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null order by `created_at` desc limit 11 offset 0

3.39mshxsd_online_4_0

Metadata
Bindings	0. 61 1. 1895 2. 1967 3. 2021 4. 2068 5. 2185 6. 2244 7. 2253 8. 2318 9. 2591 10. 2690 11. 2903 12. 2944 13. 2960 14. 3019 15. 3084 16. 3126 17. 3166 18. 3206 19. 3256 20. 3285 21. 3325 22. 3391 23. 3751 24. 3795 25. 3839 26. 3883 27. 3927 28. 3971 29. 4015 30. 4059 31. 4103 32. 4147 33. 4191 34. 4235 35. 4279 36. 4323 37. 4367 38. 4411 39. 4455 40. 4499 41. 4543 42. 4587 43. 4956 44. video

select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '654' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.12mshxsd_online_4_0
Metadata
Bindings
0. 654
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '633' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.07mshxsd_online_4_0
Metadata
Bindings
0. 633
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '624' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.19mshxsd_online_4_0
Metadata
Bindings
0. 624
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '623' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.11mshxsd_online_4_0
Metadata
Bindings
0. 623
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '622' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.08mshxsd_online_4_0
Metadata
Bindings
0. 622
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '621' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.14mshxsd_online_4_0
Metadata
Bindings
0. 621
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '620' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.02mshxsd_online_4_0
Metadata
Bindings
0. 620
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '619' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.1mshxsd_online_4_0
Metadata
Bindings
0. 619
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '618' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.13mshxsd_online_4_0
Metadata
Bindings
0. 618
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '617' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.06mshxsd_online_4_0
Metadata
Bindings
0. 617
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '616' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.11mshxsd_online_4_0
Metadata
Bindings
0. 616
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '608' and `new_comment`.`deleted_at` is null3.12mshxsd_online_4_0
Metadata
Bindings
0. 608
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` = '2944' group by `course_notes_content`.`course_notes_id`2.96mshxsd_online_4_0
Metadata
Bindings
0. 1
1. 2944
select `course_notes_content`.`id`, `course_notes_content`.`course_notes_id`, `course_notes_content`.`type`, `course_notes_content`.`app_id`, `course_notes_content`.`picture`, `course_notes_content`.`screen_shot_time`, `course_notes_content`.`intro`, `course_notes_content`.`updated_at`, `course_notes_content`.`created_at`, `course_notes`.`title` as `course_notes_title` 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` = '2944' group by `course_notes_content`.`course_notes_id` order by `course_notes_content`.`id` asc limit 5 offset 03.14mshxsd_online_4_0
Metadata
Bindings
0. 1
1. 2944
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` = '1059' order by `order` asc3.11mshxsd_online_4_0
Metadata
Bindings
0. 0
1. 1059

Metadata
Bindings	0. 654 1. comment

Metadata
Bindings	0. 633 1. comment

Metadata
Bindings	0. 624 1. comment

Metadata
Bindings	0. 623 1. comment

Metadata
Bindings	0. 622 1. comment

Metadata
Bindings	0. 621 1. comment

Metadata
Bindings	0. 620 1. comment

Metadata
Bindings	0. 619 1. comment

Metadata
Bindings	0. 618 1. comment

Metadata
Bindings	0. 617 1. comment

Metadata
Bindings	0. 616 1. comment

Metadata
Bindings	0. 608

Metadata
Bindings	0. 1 1. 2944

Metadata
Bindings	0. 1 1. 2944

Metadata
Bindings	0. 0 1. 1059

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')

2.97mshxsd_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')

2.88mshxsd_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: gYAP3x9hvJIP5nyEk745ofVxActJTqUvGaeTfB6o
sso_register_url: https://id.hxsd.com//sso/reg?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fcourse%2F608%2Fcomment%2Fde...
sso_login_url: https://id.hxsd.com//sso/login?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fcourse%2F608%2Fcomment%2F...
sso_logout_url: https://id.hxsd.com//logout?return_url=https%3A%2F%2Fhxonline.hxsd.cn%2Fcourse%2F608%2Fcomment%2Fdet...
_previous: array:1 [ "url" => "https://hxonline.hxsd.cn/course/608/comment/detail" ]
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/608/comment/detail
session_attributes: array:6 [ "_token" => "gYAP3x9hvJIP5nyEk745ofVxActJTqUvGaeTfB6o" "sso_register_url" => "https://...