0分0秒
1
1212
46546
老师在收到您的提问之后,会在第一时间为您解答! 如果需要补充图片或者编辑提问,请前往社区补充提问。
解锁本节需要消耗3积分
提问成功!邀请其他同学来帮你解答
title
video_info
course_info
experience_value
video_list
user_course_status
seek_time
dot_list
user_info
type
course_comment
course_notes
answer_list
progress
isTrySeeTwo
is_auto_play
obLevel
__env
app
errors
__currentLoopData
v
loop
defaultSettingInfo
item
pages
isHeaderAd
kf_code
select * from `course_video` where `course_video`.`id` = '2304' limit 1
SELECT *
LIMIT
ORDER BY
select * from `course` where `course`.`id` = '23814' and `course`.`deleted_at` is null limit 1
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` = '23814'
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` = '23814' order by `order` asc
select `video_learn_point`.`id`, `video_learn_point`.`title`, `video_learn_point`.`video_id`, `video_learn_point`.`seek_time`, `video_learn_point`.`type`, `video_learn_point`.`cover`, `video_learn_point`.`content`, `video_learn_point`.`created_at`, `video_learn_point`.`pos_top`, `video_learn_point`.`pos_left`, `video_learn_point`.`video_width`, `video_learn_point`.`video_height` from `video_learn_point` where `video_learn_point`.`video_id` = '2' and `video_learn_point`.`deleted_at` is null order by `video_learn_point`.`id` desc
select distinct `course`.`title` from `course` where `course`.`id` = '23814' and `course`.`deleted_at` is null order by `course`.`id` desc
select `course`.`id` from `course` where `course`.`title` = 'AE基础入门课程' and `course`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`resource_id` in ('23814') and `new_comment`.`resource_name` = 'course' and `new_comment`.`deleted_at` is null
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` in ('23814') and `new_comment`.`resource_name` = 'course' and `new_comment`.`deleted_at` is null order by `created_at` desc limit 10 offset 0
select count(*) as aggregate from `course_notes` where `course_notes`.`course_id` in ('23814') and `course_notes`.`deleted_at` is null
select `course_notes`.`id`, `course_notes`.`user_id`, `course_notes`.`course_id`, `course_notes`.`head_pic`, `course_notes`.`title`, `course_notes`.`updated_at`, `course_notes`.`created_at` from `course_notes` where `course_notes`.`course_id` in ('23814') and `course_notes`.`deleted_at` is null order by `course_notes`.`created_at` desc limit 20 offset 0
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` from `course_notes_content` where `course_notes_content`.`course_notes_id` = '18' order by `course_notes_content`.`screen_shot_time` asc
select count(*) as aggregate from `new_comment` where `new_comment`.`resource_id` = '2304' and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null
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` = '2304' and `new_comment`.`resource_name` = 'video' and `new_comment`.`deleted_at` is null order by `created_at` desc limit 10 offset 0
select * from `user` where `user`.`id` = '370559' limit 1
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '226' and `new_comment`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '220' and `new_comment`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '216' and `new_comment`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '211' and `new_comment`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '208' and `new_comment`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '207' and `new_comment`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '206' and `new_comment`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '204' and `new_comment`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '203' and `new_comment`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`comment_id` = '200' and `new_comment`.`deleted_at` is null
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')
1
6年前1212
6年前46546
6年前