尹睿暄
4234
SD高级商用设计课
走近PR攻略
测试H5课程投放
live_list
curr_live
course_lecturer
user_learning
similar_course
view
id
list
course_info
video_sum
live_sum
curr_video
course_soft
is_collect_course
learn_num
qidian_link
soft_text
user_course_status
prepurchaseInfo
is_manager
user_info
is_first
is_auth
is_pop
video_url
current_tab
nav_ids
show_tip
is_try
show_sign_up_btn
type_path
obLevel
__env
app
menuActive
errors
__currentLoopData
v
k
loop
live
defaultSettingInfo
isHeaderAd
kf_code
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` = '25466'
select count(*) as aggregate from `user_course` where `course_id` = '25466' and `user_course`.`is_transed` = '0'
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` = '25466' order by `order` asc
select `course_soft`.`soft_id` from `course_soft` where `course_soft`.`course_id` = '25466'
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` = '28' and `category_soft`.`deleted_at` is null limit 1
LIMIT
ORDER BY
select `course_lecturer`.`lecturer_id` from `course_lecturer` where `course_lecturer`.`course_id` = '25466'
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` = '25466' order by `course_learning`.`updated_at` desc limit 8
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` = '25466' and `course_video`.`video_id` = '105589' limit 1
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` = '25466' limit 1
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` = '25466' order by `course_zhibo`.`order` asc
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 null
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 0
select sum(`avg_score`) as aggregate from `user_course_comment` where `user_course_comment`.`course_id` = '25466' and `user_course_comment`.`deleted_at` is null
select count(*) as aggregate from `user_course_comment` where `user_course_comment`.`course_id` = '25466' and `user_course_comment`.`deleted_at` is null
select `course_zhibo`.`id` as `course_live_id`, `course_zhibo`.`zhibo_id`, `course_zhibo`.`order`, `course_zhibo`.`course_id` from `course_zhibo` left join `zhibo` on `course_zhibo`.`zhibo_id` = `zhibo`.`id` where `course_zhibo`.`course_id` = '25466' order by `course_zhibo`.`order` asc
select `zhibo_learning`.`id`, `zhibo_learning`.`user_id`, `zhibo_learning`.`zhibo_id`, `zhibo_learning`.`total_learn`, `zhibo_learning`.`zhibo_duration`, `zhibo_learning`.`status`, `zhibo_learning`.`created_at`, `zhibo_learning`.`updated_at` from `zhibo_learning` where `zhibo_learning`.`zhibo_id` = '1738' and `zhibo_learning`.`user_id` is null limit 1
select `zhibo_learning`.`id`, `zhibo_learning`.`user_id`, `zhibo_learning`.`zhibo_id`, `zhibo_learning`.`total_learn`, `zhibo_learning`.`zhibo_duration`, `zhibo_learning`.`status`, `zhibo_learning`.`created_at`, `zhibo_learning`.`updated_at` from `zhibo_learning` where `zhibo_learning`.`zhibo_id` = '1772' and `zhibo_learning`.`user_id` is null limit 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')
