SHOW FULL COLUMNS FROM `soker_each_city_web` [ RunTime:0.001248s ]
SELECT `id`,`city_id`,`city_name`,`city_directory` FROM `soker_each_city_web` WHERE `old_city_directory` = 'lz' LIMIT 1 [ RunTime:0.000456s ]
SHOW FULL COLUMNS FROM `soker_city` [ RunTime:0.001383s ]
SELECT `id`,`city_name`,`city_pid`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'lz' AND `isTrue` = 1 AND `isShow` = 1 AND `isDelete` = 0 LIMIT 1 [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `soker_school_campus` [ RunTime:0.001385s ]
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` = '278' AND `b`.`area_isDelete` = '0' GROUP BY `b`.`id` ORDER BY `b`.`orderid` ASC,`b`.`id` DESC [ RunTime:0.016495s ]
SHOW FULL COLUMNS FROM `soker_category` [ RunTime:0.001079s ]
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.000256s ]
SHOW FULL COLUMNS FROM `soker_school_campus_course` [ RunTime:0.000927s ]
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` = '28' AND `a`.`cityid` = '278' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`campus_id` = '5839' ) GROUP BY `b`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000548s ]
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` = '28' AND `a`.`cityid` = '278' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`campus_id` = '5839' ) GROUP BY `b`.`id` ORDER BY `b`.`material_orderTime` DESC,`b`.`material_orderid` ASC,`b`.`id` DESC LIMIT 32,8 [ RunTime:0.000590s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 342 LIMIT 1 [ RunTime:0.000196s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 1840 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000343s ]
SHOW FULL COLUMNS FROM `soker_school_course_score` [ RunTime:0.000734s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 408 AND `campus_id` = 5839 AND `course_id` = 1840 LIMIT 1 [ RunTime:0.054793s ]
SELECT `id`,`city_name`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'lz' LIMIT 1 [ RunTime:0.000223s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `cat_directory` = 'catcourse' LIMIT 1 [ RunTime:0.000178s ]
SHOW FULL COLUMNS FROM `soker_each_city_cms` [ RunTime:0.000745s ]
SELECT `id`,`cms_id`,`cms_name`,`cms_code`,`cms_pid`,`typeid`,`data_id`,`data_name` FROM `soker_each_city_cms` WHERE `data_id` = 278 AND `typeid` = 2 LIMIT 1 [ RunTime:0.000348s ]
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` = '278' 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.226276s ]
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` = '278' 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 48,12 [ RunTime:0.546729s ]
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.000301s ]
SHOW FULL COLUMNS FROM `soker_system_content` [ RunTime:0.000972s ]
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.016129s ]
SELECT `invitation_box`,`invitation_box_wap`,`invitation_box_click`,`seo_title`,`seo_keywords`,`seo_description` FROM `soker_city` WHERE `id` = 278 LIMIT 1 [ RunTime:0.000229s ]
SELECT `id`,`campus_name` FROM `soker_school_campus` WHERE `id` = 5839 LIMIT 1 [ RunTime:0.000174s ]
兰州达内教育76个教学点
学员评论（共 561 条评论）
橘* (****)2022-01-14 15:46
我们孩子说他们班一个同学在这里学习的成绩提高了，也要一起过来，虽然以前没听说过这个机构，后来网上查询了一下他们，也是全国连锁的品牌，应该可以信赖，孩子听了一节课觉得还不错，我平常也没时间或能力辅导孩子，孩子愿意学就给他报了，求个心安，希望可以提升。
橪* (****)2022-01-14 15:43
课程非常的好，完全的针对学生个人情况安排课程，并且课后班主任老师也会继续跟进学习情况。每天都会有明确的学习任务，并且练习很全面。老师非常负责，随时会为学生解决问题。学习质量和学习效率都非常高，进步很快。
*吻 (****)2022-01-13 16:33
老师很优秀，讲课很详细，在这里给孩子报的美术课。正式课学习中，期待孩子好的进步！
*****持 (****)2022-01-13 16:31
来君翰学习一段时间了，老师讲课幽默，不生硬。是同学推荐来的，真的很满意，没有让我失望！
绿******a (****)2022-01-13 16:28
是孩子同班同学家长介绍过来找的老师，刚开始上了一个体验课，课前先跟孩子沟通了学习情况，了解孩子学习情况，薄弱点，针对性的给孩子提出了学习建议，孩子很喜欢来这里上课，课后老师还会进行辅导，校区环境也非常好。还有自习室内学习氛围非常棒，平时没课的时候孩子也可以过来上自习比在家有效率。
*******子 (****)2022-01-13 16:25
环境不错，前台接待的老师很热情，课堂气氛活跃老师讲课不生硬很快- -节课到时间了。
***他 (****)2022-01-12 16:22
校区位置挺好的，附近公交车站点也挺多的，朋友的孩子也在这边上课，几个孩子每次来上课都有伴，要是孩子们都喜欢在校区上课,老师很负责。
***海 (****)2022-01-12 16:11
君翰教育的口碑不错，朋友的孩子在那上的说挺不错，而且价格优势是同级别教育机构无法超越的，所以我放心给孩子在这里报了小学托班课，课程安排非常好。
软******Q (****)2022-01-12 16:07
我们家孩子在这边上了几年课程了，孩子特别喜欢君翰的老师，孩子也特别爱学习。
*岷 (****)2022-01-12 16:01
几天在这里试听了一节语文课，老师的教学很认真，也很有耐心的解答学生的疑问，总体感觉很不错。环境也很好，决定报君翰的语文课。
**诺 (****)2022-01-11 16:20
君翰教育非常棒，老师很专业，风趣幽默，都是很有经验的，课程设计也非常适合孩子。
梦* (****)2022-01-11 16:18
校区环境看着不错，教室也很干净，老师上课很有风格，孩子很愿意跟着上课。会监督孩子作业打卡，有不会的私下问老师，老师也很耐心。大品牌还是值得信任的！