SHOW FULL COLUMNS FROM `soker_each_city_web` [ RunTime:0.000991s ]
SELECT `id`,`city_id`,`city_name`,`city_directory` FROM `soker_each_city_web` WHERE `old_city_directory` = 'xa' LIMIT 1 [ RunTime:0.000327s ]
SHOW FULL COLUMNS FROM `soker_city` [ RunTime:0.000982s ]
SELECT `id`,`city_name`,`city_pid`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'xa' AND `isTrue` = 1 AND `isShow` = 1 AND `isDelete` = 0 LIMIT 1 [ RunTime:0.000267s ]
SHOW FULL COLUMNS FROM `soker_school_campus` [ RunTime:0.001048s ]
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` = '268' AND `b`.`area_isDelete` = '0' GROUP BY `b`.`id` ORDER BY `b`.`orderid` ASC,`b`.`id` DESC [ RunTime:0.009689s ]
SHOW FULL COLUMNS FROM `soker_category` [ RunTime:0.000949s ]
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.000255s ]
SHOW FULL COLUMNS FROM `soker_school_campus_course` [ RunTime:0.000918s ]
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` = '27' AND `a`.`cityid` = '268' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`campus_id` = '8151' ) GROUP BY `b`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000501s ]
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` = '27' AND `a`.`cityid` = '268' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`campus_id` = '8151' ) GROUP BY `b`.`id` ORDER BY `b`.`material_orderTime` DESC,`b`.`material_orderid` ASC,`b`.`id` DESC LIMIT 24,8 [ RunTime:0.000527s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000241s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 23747 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `soker_school_course_score` [ RunTime:0.000717s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 1066 AND `campus_id` = 8151 AND `course_id` = 23747 LIMIT 1 [ RunTime:0.055691s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000241s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 23746 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000281s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 1066 AND `campus_id` = 8151 AND `course_id` = 23746 LIMIT 1 [ RunTime:0.053747s ]
SELECT `id`,`city_name`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'xa' LIMIT 1 [ RunTime:0.000236s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `cat_directory` = 'catcourse' LIMIT 1 [ RunTime:0.000189s ]
SHOW FULL COLUMNS FROM `soker_each_city_cms` [ RunTime:0.000912s ]
SELECT `id`,`cms_id`,`cms_name`,`cms_code`,`cms_pid`,`typeid`,`data_id`,`data_name` FROM `soker_each_city_cms` WHERE `data_id` = 268 AND `typeid` = 2 LIMIT 1 [ RunTime:0.000358s ]
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` = '268' 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.236639s ]
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` = '268' 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 36,12 [ RunTime:0.605924s ]
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.000306s ]
SHOW FULL COLUMNS FROM `soker_system_content` [ RunTime:0.001002s ]
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.016547s ]
SELECT `invitation_box`,`invitation_box_wap`,`invitation_box_click`,`seo_title`,`seo_keywords`,`seo_description` FROM `soker_city` WHERE `id` = 268 LIMIT 1 [ RunTime:0.000251s ]
SELECT `id`,`campus_name` FROM `soker_school_campus` WHERE `id` = 8151 LIMIT 1 [ RunTime:0.000178s ]
西安西安新东方国际教育5个教学点
学员评论（共 1268 条评论）
千**余 (****)2022-11-28 14:47
真的很好啊，老师都是十几年的老师，而且不会阶段性换老师，我之前在其他地方上，都换呢，在环雅剑盟，顾问就给我说，她们没有年轻老师，就真的说到做到，而且整个氛围都很好，员工都很nice，一个多月，真的很开心！超级推荐~
墨* (****)2022-11-28 14:32
11月底在网上了解到环雅剑盟被规划老师盛情邀请过来试听，整个过程相当的流畅，老师的授课功底很强，规划老师的服务也很到位，上完课才了解到试听的老师是有着十年以上授课经验的名师二话不说就报名了环雅剑盟的十人班。上课的同学都很认真老师也很负责，正在观望的同学们也可以来试试哦！
卿**我 (****)2022-11-28 14:31
这次屠鸭成功告别雅思真的特别要感谢环雅剑盟的老师们，帮助我从原来的5.5冲到了6.5终于可以去到我的Dream school了！ 顾问老师推荐的课程也很适合我的情况，老师们丰富的经验更加有针对性的解决了我的英语问题，校区环境也很高大上总之会推荐给所有烤鸭们！
蜡**新 (****)2022-11-28 14:28
位置在小寨地铁口出来往北走一点，交通非常方便。 老师超级好，非常有耐心而且很专业！在这里学习学到了很多有用的。 上课氛围很好，教室环境干净整洁。强烈推荐
优**生 (****)2022-11-28 14:28
老师很负责呢，每个都很细心，很耐心，赞赞的
与**瓜 (****)2022-11-28 14:27
环境不错，都是小班，几个人跟老师交流起来也很方便，老师超级负责，也特别耐心，成绩嘛不光靠老师也要自己努力啦！很温馨的一个集体，还不错哦~
湘* (****)2022-11-28 14:27
为了考雅思才了解这类培训机构，对比了很久，环雅剑盟的老师get到了我，喜欢冰冰老师，璐璐老师，还有帅帅的袁老师，课程安排很紧凑，有什么问题都能及时沟通，希望能尽快取得好成绩！
香**殒 (****)2022-11-28 14:26
环雅剑盟真是良心机构，之前了解过很多雅思机构，都不如环雅，老师专业负责，课前课后跟进紧凑，不懂不会的问题老师会很耐心的解答，而且课堂氛围也特别有趣，太喜欢这里的一切，选择剑盟是一个正确的选择！
L (****)2022-11-09 09:35
我是七月在哈尔滨学习的学员，第一次见到斯文老师，苗老师，姜老师，觉得特别佩服她们，每天早起晚归，技术也都特别厉害，尽管再累都是细心教导每一个学员，感觉每个老师也好看，当时就想自己能不能成为这样的人，当时感觉信心满满，等回家以后，朋友又一起去玩，也不会拖客，就想放弃了，但是斯文老师姜老师一直鼓励我，给我方案，给我规划，让我做活动，逼着我练手，每次我做顾客之前都一次次问老师，发微信，打电话………老师们
榴* (****)2022-11-09 09:35
朋友也是在雪容姿这家学校学的，后面直接就从事了整形美容这行。做得挺好工资也很高。有些心动，于是就听了朋友的意见也来这家学习，一开始还担心自己学不会。正式开始上课后，总算体会了朋友说的专业和仔细。授课老师他们都是拥有非常专业的技能手法和理论知识的。课堂上的氛围每天都是生动活泼的。一点都不会沉闷乏味。目前还在学习进行中，相信在如此认真的老师的指导下，一定可以学有所得！
波* (****)2022-11-09 09:35
身边的人都在学手艺，我也不能落下，刚开始我决定学注射项目，也都尝试了操作，在老师的指导下解决了我审美设计下手重的问题，学校的费用也不高，没有任何隐形消费，都是纯技术的教学，最主要的是在这里学习，感觉自己收获很大，不仅仅是技术方面一些成长方向，也都能给我提供建议。
原* (****)2022-11-09 09:34
来雪容姿这次学习收货收获满满，在雪容姿学习微整形还结交了一些朋友，学到了很多东西。仿佛回到了曾经在学校的日子。也终于明白了，为什么很多人来雪容姿学习微整形课程。真的很适合一个零基础学员学习的学员，来雪容姿学习微整形不枉此行，一切值得，专业的整形专家教授级别专家授课教学，感谢雪容姿教育所有老师辛苦的负责教学