niahofsdfs

回答问题

Mars_5887913 发布于2018-09-10 19:01:50

来自：测试版测试 4分钟21秒

提交答案

Mars_5887913

做最好的自己

关注

提问

47
回答

50
粉丝

0

编辑

保存

邀请其他同学来帮你解答

帮助服务

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

团队简介

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

渠道合作

申请代理商

火星证书

证书

关于我们 - me.hxsd.tv

意见反馈Q群：717157554

"> ">

Messages Timeline Exceptions Views7 Route Queries27 Mails Session Request

176.03ms4MBGET course/{id}/comment/detail

Booting (44.66ms)
Application (134.15ms)

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

27 statements were executed, 4 of which were duplicated, 23 unique90.19ms

select `id`, `user_id`, `comment_id`, `attachment_id`, `seek_time`, `created_at` from `comment_attachment` where `comment_attachment`.`comment_id` = '485' and `comment_attachment`.`deleted_at` is null13.36mshxsd_online_4_0
Metadata
Bindings
0. 485
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.05mshxsd_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 null2.98mshxsd_online_4_0
Metadata
Bindings
0. 372295
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '485' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.12mshxsd_online_4_0
Metadata
Bindings
0. 485
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` = '30'2.71mshxsd_online_4_0
Metadata
Bindings
0. 30
select `course`.`id` from `course` where `course`.`clan_id` = '5pq4q' and `course`.`deleted_at` is null2.72mshxsd_online_4_0
Metadata
Bindings
0. 5pq4q
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` = '35'2.65mshxsd_online_4_0
Metadata
Bindings
0. 35
select `id`, `user_id`, `comment_id`, `attachment_id`, `seek_time`, `created_at` from `comment_attachment` where `comment_attachment`.`comment_id` = '485' and `comment_attachment`.`deleted_at` is null2.62mshxsd_online_4_0
Metadata
Bindings
0. 485
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 ('57')2.95mshxsd_online_4_0
Metadata
Bindings
0. 57

Metadata
Bindings	0. 485

Metadata
Bindings	0. 372295 1. video

Metadata
Bindings	0. 372295 1. comment

Metadata
Bindings	0. 485 1. comment

Metadata
Bindings	0. 30

Metadata
Bindings	0. 5pq4q

Metadata
Bindings	0. 35

Metadata
Bindings	0. 485

Metadata
Bindings	0. 57

select count(*) as aggregate from `new_comment` where `resource_id` in ('20', '46', '56', '71', '1890', '1933', '1940', '1950', '1966', '1974', '1985', '2017', '2064', '2113', '2181', '2221', '2226', '2231', '2236', '2243', '2293', '2307', '2316', '2323', '2587', '2674', '2685', '2791', '2803', '2815', '2827', '2842', '2885', '2898', '2955', '3039', '3640', '3641', '4704', '4800', '4930') and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null

3mshxsd_online_4_0

Metadata
Bindings	0. 20 1. 46 2. 56 3. 71 4. 1890 5. 1933 6. 1940 7. 1950 8. 1966 9. 1974 10. 1985 11. 2017 12. 2064 13. 2113 14. 2181 15. 2221 16. 2226 17. 2231 18. 2236 19. 2243 20. 2293 21. 2307 22. 2316 23. 2323 24. 2587 25. 2674 26. 2685 27. 2791 28. 2803 29. 2815 30. 2827 31. 2842 32. 2885 33. 2898 34. 2955 35. 3039 36. 3640 37. 3641 38. 4704 39. 4800 40. 4930 41. 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 ('20', '46', '56', '71', '1890', '1933', '1940', '1950', '1966', '1974', '1985', '2017', '2064', '2113', '2181', '2221', '2226', '2231', '2236', '2243', '2293', '2307', '2316', '2323', '2587', '2674', '2685', '2791', '2803', '2815', '2827', '2842', '2885', '2898', '2955', '3039', '3640', '3641', '4704', '4800', '4930') and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null order by `created_at` desc limit 11 offset 0

3.25mshxsd_online_4_0

Metadata
Bindings	0. 20 1. 46 2. 56 3. 71 4. 1890 5. 1933 6. 1940 7. 1950 8. 1966 9. 1974 10. 1985 11. 2017 12. 2064 13. 2113 14. 2181 15. 2221 16. 2226 17. 2231 18. 2236 19. 2243 20. 2293 21. 2307 22. 2316 23. 2323 24. 2587 25. 2674 26. 2685 27. 2791 28. 2803 29. 2815 30. 2827 31. 2842 32. 2885 33. 2898 34. 2955 35. 3039 36. 3640 37. 3641 38. 4704 39. 4800 40. 4930 41. video

select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '692' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null2.97mshxsd_online_4_0
Metadata
Bindings
0. 692
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '693' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.01mshxsd_online_4_0
Metadata
Bindings
0. 693
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '755' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.02mshxsd_online_4_0
Metadata
Bindings
0. 755
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '504' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null2.95mshxsd_online_4_0
Metadata
Bindings
0. 504
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '503' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null2.96mshxsd_online_4_0
Metadata
Bindings
0. 503
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '501' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null2.93mshxsd_online_4_0
Metadata
Bindings
0. 501
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '500' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null2.95mshxsd_online_4_0
Metadata
Bindings
0. 500
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '499' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null2.92mshxsd_online_4_0
Metadata
Bindings
0. 499
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '498' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null3.64mshxsd_online_4_0
Metadata
Bindings
0. 498
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '479' and `new_comment`.`resource_name` = 'comment' and `new_comment`.`deleted_at` is null2.91mshxsd_online_4_0
Metadata
Bindings
0. 479
1. comment
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '485' and `new_comment`.`deleted_at` is null3.04mshxsd_online_4_0
Metadata
Bindings
0. 485
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` = '56' group by `course_notes_content`.`course_notes_id`2.84mshxsd_online_4_0
Metadata
Bindings
0. 1
1. 56
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` = '56' group by `course_notes_content`.`course_notes_id` order by `course_notes_content`.`id` asc limit 5 offset 03.01mshxsd_online_4_0
Metadata
Bindings
0. 1
1. 56
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` = '30' order by `order` asc2.97mshxsd_online_4_0
Metadata
Bindings
0. 0
1. 30

Metadata
Bindings	0. 692 1. comment

Metadata
Bindings	0. 693 1. comment

Metadata
Bindings	0. 755 1. comment

Metadata
Bindings	0. 504 1. comment

Metadata
Bindings	0. 503 1. comment

Metadata
Bindings	0. 501 1. comment

Metadata
Bindings	0. 500 1. comment

Metadata
Bindings	0. 499 1. comment

Metadata
Bindings	0. 498 1. comment

Metadata
Bindings	0. 479 1. comment

Metadata
Bindings	0. 485

Metadata
Bindings	0. 1 1. 56

Metadata
Bindings	0. 1 1. 56

Metadata
Bindings	0. 0 1. 30

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.83mshxsd_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')