SHOW FULL COLUMNS FROM `soker_each_city_web` [ RunTime:0.001067s ]
SELECT `id`,`city_id`,`city_name`,`city_directory` FROM `soker_each_city_web` WHERE `old_city_directory` = 'sh' LIMIT 1 [ RunTime:0.000378s ]
SHOW FULL COLUMNS FROM `soker_city` [ RunTime:0.001013s ]
SELECT `id`,`city_name`,`city_pid`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'sh' AND `isTrue` = 1 AND `isShow` = 1 AND `isDelete` = 0 LIMIT 1 [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `soker_school_campus` [ RunTime:0.001037s ]
SELECT b.`id`,b.`area_name` FROM `soker_school_campus` `a` LEFT JOIN `soker_city_area` `b` ON a.`campus_areaid`=b.`id` WHERE `a`.`campus_status` = '1' AND `a`.`campus_isdelete` = '0' AND `b`.`area_pid` = '73' AND `b`.`area_isDelete` = '0' GROUP BY `b`.`id` ORDER BY `b`.`orderid` ASC,`b`.`id` DESC [ RunTime:0.010465s ]
SHOW FULL COLUMNS FROM `soker_category` [ RunTime:0.001012s ]
SELECT `id`,`cat_name`,`cat_parentid`,`cat_secondid` FROM `soker_category` WHERE `cat_directory` = 'catcourse' AND `isTrue` = 1 AND `isDelete` = 0 LIMIT 1 [ RunTime:0.000277s ]
SHOW FULL COLUMNS FROM `soker_school_campus_course` [ RunTime:0.000909s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `soker_school_campus_course` `a` LEFT JOIN `soker_school_materials` `b` ON a.`course_id`=b.`id` LEFT JOIN `soker_school_campus` `c` ON a.`campus_id`=c.`id` LEFT JOIN `soker_school` `d` ON a.`school_id`=d.`id` WHERE ( `a`.`course_status` = '1' AND `b`.`material_isdelete` = '0' AND `a`.`provinid` = '9' AND `a`.`cityid` = '73' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`campus_id` = '3939' ) GROUP BY `b`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000883s ]
SELECT b.`id`,b.`material_title`,b.`material_images`,b.`material_introduction`,b.`material_classTime`,b.`material_price`,b.`material_createTime`,b.`material_orderTime`,a.`catid_three`,a.`campus_id`,a.`school_id`,d.`school_name`,d.`school_logo` FROM `soker_school_campus_course` `a` LEFT JOIN `soker_school_materials` `b` ON a.`course_id`=b.`id` LEFT JOIN `soker_school_campus` `c` ON a.`campus_id`=c.`id` LEFT JOIN `soker_school` `d` ON a.`school_id`=d.`id` WHERE ( `a`.`course_status` = '1' AND `b`.`material_isdelete` = '0' AND `a`.`provinid` = '9' AND `a`.`cityid` = '73' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`campus_id` = '3939' ) GROUP BY `b`.`id` ORDER BY `b`.`material_orderTime` DESC,`b`.`material_orderid` ASC,`b`.`id` DESC LIMIT 128,8 [ RunTime:0.001050s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 165 LIMIT 1 [ RunTime:0.000237s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 9585 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `soker_school_course_score` [ RunTime:0.000765s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 545 AND `campus_id` = 3939 AND `course_id` = 9585 LIMIT 1 [ RunTime:0.055321s ]
SELECT `id`,`city_name`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'sh' LIMIT 1 [ RunTime:0.000281s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `cat_directory` = 'catcourse' LIMIT 1 [ RunTime:0.000232s ]
SHOW FULL COLUMNS FROM `soker_each_city_cms` [ RunTime:0.000887s ]
SELECT `id`,`cms_id`,`cms_name`,`cms_code`,`cms_pid`,`typeid`,`data_id`,`data_name` FROM `soker_each_city_cms` WHERE `data_id` = 73 AND `typeid` = 2 LIMIT 1 [ RunTime:0.000398s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `soker_school_course_score` `a` LEFT JOIN `soker_school_campus` `b` ON a.`campus_id`=b.`id` LEFT JOIN `soker_school_materials` `c` ON a.`comment_id`=c.`id` WHERE ( `b`.`campus_cityid` = '73' AND `b`.`campus_isdelete` = '0' AND `b`.`campus_status` = '1' AND `c`.`material_isdelete` = '0' ) GROUP BY `c`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.244669s ]
SELECT c.`id`, c.`material_title`, c.`material_images`, c.`material_introduction`, REPLACE(json_extract(c.`material_content`, '$.comments_mobile'), '"', '') AS `material_mobile`, c.`material_content`, c.`material_orderTime`, c.`material_createTime` FROM `soker_school_course_score` `a` LEFT JOIN `soker_school_campus` `b` ON a.`campus_id`=b.`id` LEFT JOIN `soker_school_materials` `c` ON a.`comment_id`=c.`id` WHERE ( `b`.`campus_cityid` = '73' AND `b`.`campus_isdelete` = '0' AND `b`.`campus_status` = '1' AND `c`.`material_isdelete` = '0' ) GROUP BY `c`.`id` ORDER BY `c`.`material_orderTime` DESC,`c`.`material_orderid` ASC,`c`.`id` DESC LIMIT 192,12 [ RunTime:0.622651s ]
SELECT `id`,`cat_name`,`cat_parentid`,`cat_secondid` FROM `soker_category` WHERE `cat_directory` = 'catcourse' AND `isTrue` = 1 AND `isDelete` = 0 LIMIT 1 [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `soker_system_content` [ RunTime:0.001166s ]
SELECT `id`,`con_title`,`con_images`,`con_introduction`,`con_createTime`,`con_orderTime` FROM `soker_system_content` WHERE ( `con_type` = 7 AND `con_isDelete` = 0 ) ORDER BY `con_orderTime` DESC,`con_orderid` ASC,`id` DESC LIMIT 3 [ RunTime:0.016862s ]
SELECT `invitation_box`,`invitation_box_wap`,`invitation_box_click`,`seo_title`,`seo_keywords`,`seo_description` FROM `soker_city` WHERE `id` = 73 LIMIT 1 [ RunTime:0.000295s ]
SELECT `id`,`campus_name` FROM `soker_school_campus` WHERE `id` = 3939 LIMIT 1 [ RunTime:0.000218s ]
上海非凡进修学院8个教学点
学员评论（共 1379 条评论）
***柔 (****)2021-12-11 15:34
在校区上了基础课，去了他们总部广州培训了4个半月的时间，还报了注册会计师的课程，恒企的老师都特别厉害，上课很幽默，复杂的知识点用通俗易懂的例子来讲课，现在在一边考注会一边在上班，平常培训的内容都能在工作上运用到，活到老学到老！
相*劫 (****)2021-12-11 15:26
校区的咨询老师非常专业，给我做了详细的会计学习规划，校区的环境好，老师非常厉害，不仅可以学到理论，还可以学到实操的课程，非常实用的培训！
**嫁 (****)2021-12-11 15:24
原本抱着试一试的心态报了班，发现这里的老师都特别热情，最主要给人感觉很专业。
****予 (****)2021-12-11 15:21
安老师我觉得我很幸运，在这个年龄，这个接受新事物缓慢且退化的这个年龄，遇到你，这么一个非常耐心的老师~不厌其烦的回答，各种低级愚蠢的问题，非常感谢！
长*****花 (****)2021-12-11 15:19
为了自己的职业规划,越来越觉得需要提升学历很重要。下定决心准备考研, 对比了很多家培训机构，也体验了不少课试听,感觉这家考研机构比较靠谱。教材很新颖， 素材很全面,老师上课也很生动，能让我们听进去，不会昏昏欲睡,会继续坚持下去,加油加油!
*****爱 (****)2021-12-11 15:17
学习环境很不错，教师宽敞明亮，学习的心情和状态都跟着好起来了呢！
******ら (****)2021-12-11 15:13
学了一消的课程，虽然我是零基础，很怕学不会，但跟着老师学起来还是能入门的，今年也快报考了，希望接下来的学习和考试都会顺利。
******女 (****)2021-12-11 14:46
这儿不错，推荐我身边好几个朋友来这里学日语的，他们几个都说不错的，比以前接触的培训机构要有质量多了。
萌**瞎 (****)2021-12-11 14:44
朋友介绍来的，是个很好的学校。几次接触下来我的结论就是这个学校是真心在教学员，实实在在提高学生水平，教学的水平，很优秀，很多培训学校跟他们没的比。
*鬼 (****)2021-12-11 14:41
在网上咨询他们的，客服满热情的，说话态度也非常的好，很热情，越好这个周末过去学校看看的，好的话我就准备在这里学的。
***場 (****)2021-12-11 14:38
总体感觉环境还不错，学校的老师挺热情的。师资质量比较丰富，教室挺多的。每个人都有笑容，感觉做得比较用心。
拔* (****)2021-12-11 14:31
教学质量非常好，老师都挺负责任，对待学生就像朋友一样，任课老师也非常负责任。