全部 UI设计学院 室内设计学院 游戏美术学院 IT互联网学院 影视特效学院 新媒体学院
全部 Mentalray Photoshop CorelDraw CryEngine
全部 免费课 精品课 直播课 录播课
全部 初级入门 中级拔高 高级进阶
综合 热门 最新
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` = '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`.`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`.`is_seo` = '0' and `course`.`type` = '8' and `course`.`academy_id` = '28' and `course`.`template` = '1') and `course`.`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')
