SHOW FULL COLUMNS FROM `soker_each_city_web` [ RunTime:0.000839s ]
SELECT `id`,`city_id`,`city_name`,`city_directory` FROM `soker_each_city_web` WHERE `old_city_directory` = 'nd' LIMIT 1 [ RunTime:0.000316s ]
SHOW FULL COLUMNS FROM `soker_city` [ RunTime:0.000939s ]
SELECT `id`,`city_name`,`city_pid`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'nd' AND `isTrue` = 1 AND `isShow` = 1 AND `isDelete` = 0 LIMIT 1 [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `soker_school_campus` [ RunTime:0.000944s ]
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` = '122' AND `b`.`area_isDelete` = '0' GROUP BY `b`.`id` ORDER BY `b`.`orderid` ASC,`b`.`id` DESC [ RunTime:0.009495s ]
SHOW FULL COLUMNS FROM `soker_category` [ RunTime:0.000930s ]
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.000239s ]
SHOW FULL COLUMNS FROM `soker_city_area` [ RunTime:0.000746s ]
SELECT `id`,`area_name` FROM `soker_city_area` WHERE `id` = 1096 LIMIT 1 [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `soker_school_campus_course` [ RunTime:0.000956s ]
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` = '13' AND `a`.`cityid` = '122' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`areaid` = '1096' AND ( FIND_IN_SET('周末班', b.material_classTime) ) ) GROUP BY `b`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.136530s ]
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` = '13' AND `a`.`cityid` = '122' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`areaid` = '1096' AND ( FIND_IN_SET('周末班', b.material_classTime) ) ) GROUP BY `b`.`id` ORDER BY `b`.`material_orderTime` DESC,`b`.`material_orderid` ASC,`b`.`id` DESC LIMIT 64,8 [ RunTime:0.127658s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 303 LIMIT 1 [ RunTime:0.000298s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 13707 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `soker_school_course_score` [ RunTime:0.000893s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 591 AND `campus_id` = 5580 AND `course_id` = 13707 LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 311 LIMIT 1 [ RunTime:0.000190s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 13446 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000296s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 591 AND `campus_id` = 5580 AND `course_id` = 13446 LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`city_name`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'nd' LIMIT 1 [ RunTime:0.000184s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `cat_directory` = 'catcourse' LIMIT 1 [ RunTime:0.000165s ]
SHOW FULL COLUMNS FROM `soker_each_city_cms` [ RunTime:0.000817s ]
SELECT `id`,`cms_id`,`cms_name`,`cms_code`,`cms_pid`,`typeid`,`data_id`,`data_name` FROM `soker_each_city_cms` WHERE `data_id` = 122 AND `typeid` = 2 LIMIT 1 [ RunTime:0.000294s ]
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` = '122' 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.004319s ]
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` = '122' 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 96,12 [ RunTime:0.004845s ]
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.000254s ]
SHOW FULL COLUMNS FROM `soker_system_content` [ RunTime:0.000947s ]
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.015179s ]
SELECT `invitation_box`,`invitation_box_wap`,`invitation_box_click`,`seo_title`,`seo_keywords`,`seo_description` FROM `soker_city` WHERE `id` = 122 LIMIT 1 [ RunTime:0.000241s ]
SELECT `id`,`area_name` FROM `soker_city_area` WHERE `id` = 1096 LIMIT 1 [ RunTime:0.000171s ]
学员评论(共 128 条评论)
坠**渊 (****)2021-11-25 13:34
在家休息期间想报考了二建,朋友推荐了优路网校,不仅书寄的快,印刷特别清晰,而且网课也讲的非常全面,听说还有很多名师授课,天气这么热,在家还能学习确实方便了许多!省时省力!客服态度也非常的好!
你*****人 (****)2021-11-24 15:54
又到了快要考一建的时候了,你们真的可以来试试保定优路教育的课程,每一次学习都会给我带来很多的指导,帮助我梳理知识点,让我在复习的时候有更加明确的而目标。
烟* (****)2021-11-24 15:50
自己去年报考一级建造师市政实物未通过考试,今年报名优路教育面授课程,已经学习两个多月,班主任认真负责督促学习,给制度合理学习计划。老师讲课从基础精讲到冲刺、密训,剖析教材,深层锁定考试考点,点题结合,便于理解和记忆。优路实行网络+面授授课方式,随时随地都能学习,希望今年一次性通过!
游*氯 (****)2021-11-24 15:43
去年在优路报名学的造价师,一次过四科,感谢优路的老师和工作人员,今年又报了一建,不仅老师讲得好,而且还有专业老师答疑和教学服务,我觉周计划很好,给优路点赞。
若**士 (****)2021-11-24 15:40
优路教育非常好,课程很完善和非常系统化,学习起来比较轻松,大大提高了学习效率,后期服务更是非常温馨,很喜欢。
贰*! (****)2021-11-24 15:36
造价考了两年都没过,案例分析挂了两次,非常郁闷,后来听朋友们说他去年是在优路报的班,班主任老师很尽心尽责。他把老师电话给我,我就试着打过去咨询了一下,为了保险起见,我还打电话咨询了其他的一些培训机构,但都觉得不太理想,毕竟报名费好几大千,要慎重一些。但优路给人的感觉比其他机构更专业,我在网站上留言的一些难题,24小时内都有老师给解答,咨询的这位老师给我的感觉也很亲切,报名、教材、资料等等都给耐心解
加**! (159****4562)2021-10-21 10:14
优路教育还是非常不错的,尤其是我的班主任老师态度服务方面都是特别好,有问题都是随时能帮我解决,课程讲的也不错,感觉报了他们的培训还是非常值得的。
赏****i (159****5289)2021-10-21 10:13
今天遇到消防给排水上面的问题,他们老师解答的好快啊,非常不错,有朋友问我学习的情况,我就直接推荐了优路。
高*夫 (154****3256)2021-10-21 10:12
通过一个同事介绍的优路教育,当时有人给我打电话,觉得介绍的挺到位的。去年我要考一建,问了很多相关问题,服务特别好,有给一一解答了。后期又比较了一下价格,觉得有点高。但是看看课程模块,和上面授的时间,还要师资力量,在网上查了一下都还比较好。所以就报名了,课程讲的不错。跟着老师一起反正是比自己学的好。
天* (154****4529)2021-10-21 10:11
刚到校区!整体的环境都很不错!老师的服务态度也很好!很热情,一直都在线上跟老师沟通!现在来到线下感觉还是不错的,不犹豫了,犹豫了也是浪费自己的时间,决定在这报了,平时自己刷题也是稀里糊涂,很多都不懂,在优路听了课,感觉老师比较好,有啥不懂的老师也都给解决了!很不错!希望我能够上岸!
香* (156****8266)2021-10-21 10:10
第一次来到优路教育,前台小姐姐非常热情,并及时对接了相关老师,给我讲解不懂的地方。老师非常专业,非常负责。这一次收货很大,以后还会继续关注优路教育。
小*子 (152****8213)2021-10-21 10:08
在优路报了网络课程,老师讲解比较详细,对考试重点也进行了强调,感觉还可以,也没有强行推销,都是根据我的个人情况推荐适合的班型,位置也很好找,学校环境还可以,老师们的态度特别好,非常专业,希望再优路能让自己得到提升。