全部 UI设计学院 室内设计学院 游戏美术学院 IT互联网学院 影视特效学院 新媒体学院
全部 Mentalray Photoshop CorelDraw CryEngine
全部 免费课 精品课 直播课 录播课
全部 初级入门 中级拔高 高级进阶
综合 热门 最新
01小时08分19秒
初级入门341人 11评价
¥0.02
03分45秒
974人 20评价
免费
59分32秒
初级入门54人 13评价
course_list
pages
title
seo_keywords
seo_description
academy_list
profession_list
soft_list
tags
difficulty
show_help
params
pageUrl
cooperate
obLevel
__env
app
menuActive
errors
__currentLoopData
v
loop
k
p
defaultSettingInfo
isHeaderAd
kf_code
select `category_academy`.`id`, `category_academy`.`name`, `category_academy`.`alias`, `category_academy`.`intro`, `category_academy`.`order`, `category_academy`.`cover`, `category_academy`.`icon`, `category_academy`.`created_at` from `category_academy` where `category_academy`.`alias` = 'snsj' and `category_academy`.`deleted_at` is null limit 1
LIMIT
ORDER BY
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`.`alias` = 'CryEngine' and `category_soft`.`deleted_at` is null limit 1
select `course_soft`.`course_id` from `course_soft` inner join `course` on `course`.`id` = `course_soft`.`course_id` where `course_soft`.`soft_id` = '13' and `course`.`status` = '1'
select count(*) as aggregate from `course` where (`course`.`status` = '1' and (`course`.`is_trinity` not in ('1', '3', '4') and `course`.`type` != '3' or `course`.`is_trinity` is null or (`course`.`type` = '3' and `course`.`is_trinity` not in ('0', '1', '3', '4'))) and `course`.`id` in ('30', '35', '1029', '1039', '23817', '1026', '29', '23874', '25203', '25200', '25388', '25396') and `course`.`type` not in ('7') and `course`.`is_seo` = '0' and `course`.`academy_id` = '28') and `course`.`deleted_at` is null
!=
<>
select `course`.`id`, `course`.`clan_id`, `course`.`title`, `course`.`new_title`, `course`.`phase`, `course`.`material_id`, `course`.`academy_id`, `course`.`profession_id`, `course`.`type`, `course`.`free_baidu`, `course`.`seo_tdk_title`, `course`.`seo_tdk_keywords`, `course`.`seo_tdk_description`, `course`.`seo_intro`, `course`.`try_listen`, `course`.`cover_web`, `course`.`cover_app`, `course`.`web_detail_intro`, `course`.`seo_detail_intro`, `course`.`price`, `course`.`up_shelf_time`, `course`.`task_stage`, `course`.`down_shelf_time`, `course`.`authorized_deadline`, `course`.`authorized_status`, `course`.`status`, `course`.`begin_time`, `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`.`recommend_job`, `course`.`recommend_job_learning_time`, `course`.`recommend_job_limit_time`, `course`.`agreement`, `course`.`agreement_detail`, `course`.`apply_pass`, `course`.`is_trinity`, `course`.`teacher_id`, `course`.`cover_poster`, `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`, `course`.`updated_at`, `course`.`created_at`, `course`.`sections`, `course`.`show_video`, `course`.`show_video_mp4`, `course`.`category_id`, `course`.`push_validity`, `course`.`pushed_at`, `course`.`seo_edited_at`, `course`.`is_seo`, `course`.`cloudclass_address` from `course` where (`course`.`status` = '1' and (`course`.`is_trinity` not in ('1', '3', '4') and `course`.`type` != '3' or `course`.`is_trinity` is null or (`course`.`type` = '3' and `course`.`is_trinity` not in ('0', '1', '3', '4'))) and `course`.`id` in ('30', '35', '1029', '1039', '23817', '1026', '29', '23874', '25203', '25200', '25388', '25396') and `course`.`type` not in ('7') and `course`.`is_seo` = '0' and `course`.`academy_id` = '28') and `course`.`deleted_at` is null order by `course`.`recommend_status` desc, `course`.`recommend_time` desc, `course`.`weight_order` desc limit 20 offset 0
select * from `attachment` where `attachment`.`id` = '417' limit 1
SELECT *
select `course_lecturer`.`course_id`, `course_lecturer`.`lecturer_id` from `course_lecturer` inner join `course` on `course_lecturer`.`course_id` = `course`.`id` where `course`.`deleted_at` is null and `course_lecturer`.`course_id` in ('30', '23817', '35') order by `course`.`created_at` desc
select sum(`course`.`learning`) as aggregate from `course` where `course`.`clan_id` = '5pq4q' and `course`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`resource_name` = 'course' and `new_comment`.`resource_id` = '30' and `new_comment`.`deleted_at` is null
select sum(`course`.`learning`) as aggregate from `course` where `course`.`clan_id` = 'ta5aj' and `course`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`resource_name` = 'course' and `new_comment`.`resource_id` = '23817' and `new_comment`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`resource_name` = 'course' and `new_comment`.`resource_id` = '35' and `new_comment`.`deleted_at` is null
select `course`.`id` from `course` where `course`.`status` = '1' and `course`.`academy_id` = '28' and `course`.`deleted_at` is null
select `course_soft`.`soft_id` from `course_soft` where `course_soft`.`course_id` in ('20', '23', '23817', '23820', '25201', '23808', '25216', '30', '35')
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`.`parent_id` = '0' and `category_soft`.`deleted_at` is null order by `category_soft`.`order` asc
select `category_academy`.`id`, `category_academy`.`parent_id`, `category_academy`.`name`, `category_academy`.`alias`, `category_academy`.`intro`, `category_academy`.`order`, `category_academy`.`cover`, `category_academy`.`is_view`, `category_academy`.`seo_title`, `category_academy`.`seo_keywords`, `category_academy`.`seo_description`, `category_academy`.`created_at` from `category_academy` where `is_view` = '1' and `category_academy`.`deleted_at` is null order by `order` asc
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')