SHOW FULL COLUMNS FROM `soker_each_city_web` [ RunTime:0.001072s ]
SELECT `id`,`city_id`,`city_name`,`city_directory` FROM `soker_each_city_web` WHERE `old_city_directory` = 'yangzhou' LIMIT 1 [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `soker_city` [ RunTime:0.000994s ]
SELECT `id`,`city_name`,`city_pid`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'yangzhou' AND `isTrue` = 1 AND `isShow` = 1 AND `isDelete` = 0 LIMIT 1 [ RunTime:0.000285s ]
SHOW FULL COLUMNS FROM `soker_school_campus` [ RunTime:0.000973s ]
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` = '83' AND `b`.`area_isDelete` = '0' GROUP BY `b`.`id` ORDER BY `b`.`orderid` ASC,`b`.`id` DESC [ RunTime:0.009566s ]
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.000258s ]
SHOW FULL COLUMNS FROM `soker_school_campus_course` [ RunTime:0.000897s ]
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` = '10' AND `a`.`cityid` = '83' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`campus_id` = '1278' ) GROUP BY `b`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000554s ]
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` = '10' AND `a`.`cityid` = '83' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`campus_id` = '1278' ) GROUP BY `b`.`id` ORDER BY `b`.`material_orderTime` DESC,`b`.`material_orderid` ASC,`b`.`id` DESC LIMIT 24,8 [ RunTime:0.000591s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 99 LIMIT 1 [ RunTime:0.000209s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 2095 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `soker_school_course_score` [ RunTime:0.000733s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 398 AND `campus_id` = 1278 AND `course_id` = 2095 LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 98 LIMIT 1 [ RunTime:0.000191s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 2097 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000241s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 398 AND `campus_id` = 1278 AND `course_id` = 2097 LIMIT 1 [ RunTime:0.000286s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 95 LIMIT 1 [ RunTime:0.000177s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 2100 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000227s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 398 AND `campus_id` = 1278 AND `course_id` = 2100 LIMIT 1 [ RunTime:0.000274s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 103 LIMIT 1 [ RunTime:0.000174s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 2051 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000230s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 398 AND `campus_id` = 1278 AND `course_id` = 2051 LIMIT 1 [ RunTime:0.000282s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 94 LIMIT 1 [ RunTime:0.000152s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 2102 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000223s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 398 AND `campus_id` = 1278 AND `course_id` = 2102 LIMIT 1 [ RunTime:0.000275s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 92 LIMIT 1 [ RunTime:0.000151s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 2104 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000234s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 398 AND `campus_id` = 1278 AND `course_id` = 2104 LIMIT 1 [ RunTime:0.000268s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 123 LIMIT 1 [ RunTime:0.000149s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 2108 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000239s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 398 AND `campus_id` = 1278 AND `course_id` = 2108 LIMIT 1 [ RunTime:0.000265s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 111 LIMIT 1 [ RunTime:0.000150s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 2112 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000227s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 398 AND `campus_id` = 1278 AND `course_id` = 2112 LIMIT 1 [ RunTime:0.000264s ]
SELECT `id`,`city_name`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'yangzhou' LIMIT 1 [ RunTime:0.000159s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `cat_directory` = 'catcourse' LIMIT 1 [ RunTime:0.000151s ]
SHOW FULL COLUMNS FROM `soker_each_city_cms` [ RunTime:0.000743s ]
SELECT `id`,`cms_id`,`cms_name`,`cms_code`,`cms_pid`,`typeid`,`data_id`,`data_name` FROM `soker_each_city_cms` WHERE `data_id` = 83 AND `typeid` = 2 LIMIT 1 [ RunTime:0.000277s ]
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` = '83' 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.005345s ]
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` = '83' 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.005838s ]
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_system_content` [ RunTime:0.000901s ]
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.015110s ]
SELECT `invitation_box`,`invitation_box_wap`,`invitation_box_click`,`seo_title`,`seo_keywords`,`seo_description` FROM `soker_city` WHERE `id` = 83 LIMIT 1 [ RunTime:0.000222s ]
SELECT `id`,`campus_name` FROM `soker_school_campus` WHERE `id` = 1278 LIMIT 1 [ RunTime:0.000179s ]
学员评论(共 223 条评论)
****. (****)2021-12-05 17:16
最开始看他们的官网,就感觉机构不错,全国做的挺大的,老师讲课条理很清晰。一级建造师的课程我已经报了,身边的朋友也有想要考的,我都给他推荐那,就是觉得挺靠谱的。
满***x (****)2021-12-05 17:14
这个机构的老师不错,很幽默,知识点讲解很清楚,我在这里学习2年了,考下了2个证书,谢谢这里的老师,很负责。
*****忧 (****)2021-12-05 17:11
考一建的时候朋友推荐过优路教育买了 一套优路的辅导书 叫四周通关 还不错哦 有考点还有模拟题 感觉还是要一边看书一边做题的。
***長 (****)2021-12-05 17:08
朋友推荐的,老师客服都很好,资料很齐全,课程只要周末有时间就可以去听。让我顺利的通过考试。哦,我考得是建造师,他们的建筑类的很出名。
枫* (****)2021-12-05 17:06
之前就想考个证书,一开始自己看书了,可是实在学不进去,考试没去考,后来网上看到有团购的,打电话咨询了下,到他们校区现场了解了下,感觉挺专业的,试听课程也现场看了,差不多能接受,考虑了下就报名了,希望在老师的教导下能顺利拿到证书。
******软 (****)2021-12-03 16:05
工作的原因了解到消防工程师资格证目前市场前景很好,趁着现在对于专业没有特别要求,自己也想试一下。自从有了这个想法后,一直在咨询各家培训机构,看得我眼花缭乱。有次和朋友聊天说到这个事情,他给我推荐了优路教育,他说自己之前报一建考试时就是在优路报了个白金卡班,没想到一年就通过了。前段时间朋友陪我一起去优路教育详细解下。初一看到教材,真是有点想打退堂鼓,3本书加起来有1200多页。课程老师仔细的给我解答
无***别 (****)2021-12-03 16:03
一家做到上市的培训机构 ,也是业内最好的培训机构,为什么这么说?因为我去过很多报名学一建的培训机构,也在网上查询了各大培训机构,整体来看优路教育最好,而且学员也都给了很高的评价,所以我也选择了优路教育,去了之后果然很不错,无论是老师讲的,还是服务都很好,让作为学员的我很舒服。我也会告诉我的同事朋友,选培训机构还是选放心、可靠、有实力的优路教育!我们用通过率来说话。
***人 (****)2021-12-03 16:00
优路教育老师的回访电话,给了我耐心的解答,并听见了他们的试听课程,感觉老师讲的很细致,自己也能听懂了就报他们的班学习了,在学习过程中经常会接到老师的督促电话,提醒我学习,我感觉服务真的不错,我会好好学习,争取一次性通过。
痴**戏 (****)2021-12-03 15:45
自己工资收入一般般,就想考个证提升自己,换个好一点的工作,就在网上咨询了下,优路教育的老师就给我打电话,才晓得有一个含金量比较高的证书,叫消防工程师,自己是文科专业的,感觉自己学习起来会很难,后来经过那个老师的建议就去优路教育官网上试听了一节课程,感觉难度还能接受,但是自己没接触过就还是图方便报了一个辅导班,自己也跑了几家机构,还是觉得优路靠谱,不是那种卷钱就跑的加盟机构,最大的收获就是课程里面竟
***沙 (****)2021-12-03 15:43
优路教育挺不错的,他们的培训老师都是业内大腕名师,并且通过率很高,平时工作忙,优路教育的网络视频挺不错的,资料权威。
千**尽 (****)2021-12-02 16:30
优路教育的建筑类培训做的特别火,我去年在哪里报了一个二级建造师的班次,联系他们的时候态度特别友好,毕竟做了十年的教育机构,确实不一样,师资力量,教材精华上都是屈指可数的。
冰**瑰 (****)2021-12-02 16:27
他们的服务态度还不错,而且通过率很高,老师的讲课风格我很喜欢,课后老师按时询问我的学习进度让我劲头更足了,去年的时候我就在他家学习的,一次就考过了!