全部 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
全部 免费课 精品课 直播课 录播课
全部 初级入门 中级拔高 高级进阶
综合 热门 最新
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 `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` = 'Mentalray' 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` = '109' 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 ('25396', '23870', '25424', '25460', '25407', '25462', '25463', '25464', '25467', '25445', '25455', '15', '5', '25447', '25418', '25454', '25470', '25492', '25472', '28353', '25450', '28349', '25405', '28355', '28356', '25459', '28357', '28362', '28363', '28359', '28366', '28367', '28371', '28372', '25471', '28373', '28374', '28375', '28376', '28377', '28380', '28381', '28383', '28389', '25495', '28391', '25496', '28393', '28379', '28396', '28397', '28398', '28399', '28401', '28400', '28382', '28402', '28404', '28365', '28405', '28406', '28407', '28408', '28409', '28410', '28411', '28378', '28403', '28442', '28443', '28446', '28456', '28459', '28452', '28460', '28466', '28473', '28484', '28458', '28455', '23816', '28454', '28395', '28493', '28496', '28494', '28499', '28449', '25468', '28527', '25465', '28361', '28525', '20', '28526') and `course`.`type` not in ('7') and `course`.`difficulty` in ('1', '2') and `course`.`is_seo` = '0' and `course`.`academy_id` = '17' and `course`.`template` = '1') and `course`.`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')
