全部 UI设计学院 室内设计学院 游戏美术学院 IT互联网学院 影视特效学院 新媒体学院
全部 Mari Mentalray AutoCAD 3ds Max AfterEffects Photoshop Maya Illustrator Zbrush Houdini Vray Unity Cinema4d Premiere Xcode Edius Eclipse Vegas lumion Realflow Marvelous SAI Flash AS Final Cut Pro VUE Nuke Sketch Arnold Body Paint InDesign CorelDraw SketchUp CryEngine Web Storm DaVinci 其他软件 理论知识 Painter InDesign
全部 免费课 精品课 直播课 录播课
全部 初级入门 中级拔高 高级进阶
综合 热门 最新
22分17秒
中级拔高2476人 13评价
￥1000 限时优惠
06小时47分17秒
中级拔高29人 7评价
￥1000
03小时40分05秒
中级拔高2人 14评价
￥2999
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` = 'ui' and `category_academy`.`deleted_at` is null limit 1
LIMIT
ORDER BY
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`.`type` not in ('7') and `course`.`difficulty` = '3' and `course`.`is_seo` = '0' and `course`.`academy_id` = '17') 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`.`type` not in ('7') and `course`.`difficulty` = '3' and `course`.`is_seo` = '0' and `course`.`academy_id` = '17') 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 `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 ('1059', '25171', '23915') order by `course`.`created_at` desc
select * from `lecturer` where `lecturer`.`id` = '44' and `lecturer`.`deleted_at` is null limit 1
SELECT *
select sum(`course`.`learning`) as aggregate from `course` where `course`.`clan_id` = 'mi0eb' and `course`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`resource_name` = 'course' and `new_comment`.`resource_id` = '1059' and `new_comment`.`deleted_at` is null
select sum(`course`.`learning`) as aggregate from `course` where `course`.`clan_id` = 'r3v42' and `course`.`deleted_at` is null
select count(*) as aggregate from `new_comment` where `new_comment`.`resource_name` = 'course' and `new_comment`.`resource_id` = '25171' 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` = '23915' and `new_comment`.`deleted_at` is null
select `course`.`id` from `course` where `course`.`status` = '1' and `course`.`academy_id` = '17' and `course`.`deleted_at` is null
select `course_soft`.`soft_id` from `course_soft` where `course_soft`.`course_id` in ('26', '1022', '1058', '1059', '23876', '25153', '25376', '25377', '25378', '25379', '25385', '25393', '25395', '25396', '28378', '28485', '28545', '28546', '28547', '28548', '5', '1051', '1057', '23819', '23857', '25144', '25151', '25205', '25209', '25369', '25380', '25381', '25388', '25445', '10', '1029', '1045', '1046', '1048', '25198', '7', '11', '21', '25', '36', '37', '1031', '23804', '28500', '13', '22', '1023', '1024', '1027', '1028', '1044', '1056', '23813', '23887', '23915', '25171', '25224', '25226', '25227', '25419')
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')
