SHOW FULL COLUMNS FROM `soker_each_city_web` [ RunTime:0.001249s ]
SELECT `id`,`city_id`,`city_name`,`city_directory` FROM `soker_each_city_web` WHERE `old_city_directory` = 'liaocheng' LIMIT 1 [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `soker_city` [ RunTime:0.001436s ]
SELECT `id`,`city_name`,`city_pid`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'liaocheng' AND `isTrue` = 1 AND `isShow` = 1 AND `isDelete` = 0 LIMIT 1 [ RunTime:0.000326s ]
SHOW FULL COLUMNS FROM `soker_school_campus` [ RunTime:0.001244s ]
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` = '147' AND `b`.`area_isDelete` = '0' GROUP BY `b`.`id` ORDER BY `b`.`orderid` ASC,`b`.`id` DESC [ RunTime:0.010600s ]
SHOW FULL COLUMNS FROM `soker_category` [ RunTime:0.001397s ]
SELECT `id`,`cat_name`,`cat_parentid`,`cat_secondid` FROM `soker_category` WHERE `cat_directory` = 'ithlw' AND `isTrue` = 1 AND `isDelete` = 0 LIMIT 1 [ RunTime:0.000365s ]
SHOW FULL COLUMNS FROM `soker_school_campus_course` [ RunTime:0.001316s ]
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` = '15' AND `a`.`cityid` = '147' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`catid_one` = '337' AND `a`.`catid_two` = '338' AND ( FIND_IN_SET('全日制', b.material_classTime) ) ) GROUP BY `b`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.234264s ]
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` = '15' AND `a`.`cityid` = '147' AND `c`.`campus_status` = '1' AND `c`.`campus_isdelete` = '0' AND `d`.`isDelete` = '0' AND `a`.`catid_one` = '337' AND `a`.`catid_two` = '338' 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 16,8 [ RunTime:0.245148s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 343 LIMIT 1 [ RunTime:0.000290s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 18542 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `soker_school_course_score` [ RunTime:0.001087s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 209 LIMIT 1 [ RunTime:0.000289s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 343 LIMIT 1 [ RunTime:0.000223s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 18541 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000290s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 209 LIMIT 1 [ RunTime:0.000264s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `id` = 343 LIMIT 1 [ RunTime:0.000197s ]
SELECT COUNT(DISTINCT `campus_id`) AS think_count FROM `soker_school_campus_course` WHERE `course_id` = 18539 AND `course_status` = 1 LIMIT 1 [ RunTime:0.000284s ]
SELECT COUNT(id) AS `num`, AVG(score) AS `score` FROM `soker_school_course_score` WHERE `school_id` = 209 LIMIT 1 [ RunTime:0.000235s ]
SELECT `id`,`city_name`,`city_directory` FROM `soker_city` WHERE `city_directory` = 'liaocheng' LIMIT 1 [ RunTime:0.000205s ]
SELECT `id`,`cat_name`,`cat_directory` FROM `soker_category` WHERE `cat_directory` = 'ithlw' LIMIT 1 [ RunTime:0.000217s ]
SHOW FULL COLUMNS FROM `soker_each_category_cms` [ RunTime:0.001028s ]
SELECT `id`,`cms_id`,`cms_name`,`typeid`,`data_id`,`data_name` FROM `soker_each_category_cms` WHERE `data_id` = 338 LIMIT 1 [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `soker_each_city_cms` [ RunTime:0.001059s ]
SELECT `id`,`cms_id`,`cms_name`,`cms_code`,`cms_pid`,`typeid`,`data_id`,`data_name` FROM `soker_each_city_cms` WHERE `data_id` = 147 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` = '147' 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.006143s ]
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` = '147' 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 24,12 [ RunTime:0.007231s ]
SELECT `id`,`cat_name`,`cat_parentid`,`cat_secondid` FROM `soker_category` WHERE `cat_directory` = 'ithlw' AND `isTrue` = 1 AND `isDelete` = 0 LIMIT 1 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `soker_system_content` [ RunTime:0.001264s ]
SELECT `id`,`con_title`,`con_images`,`con_introduction`,`con_createTime`,`con_orderTime` FROM `soker_system_content` WHERE ( `con_type` = 7 AND `con_isDelete` = 0 AND `catid_one` = 337 AND `catid_two` = 338 ) ORDER BY `con_orderTime` DESC,`con_orderid` ASC,`id` DESC LIMIT 3 [ RunTime:0.025570s ]
SELECT `invitation_box`,`invitation_box_wap`,`invitation_box_click`,`seo_title`,`seo_keywords`,`seo_description` FROM `soker_city` WHERE `id` = 147 LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`cat_name`,`cat_directory`,`seo_title`,`seo_keywords`,`seo_description`,`invitation_box`,`invitation_box_click` FROM `soker_category` WHERE `cat_directory` = 'ithlw' LIMIT 1 [ RunTime:0.000285s ]
SELECT `id`,`cat_name`,`cat_directory`,`seo_title`,`seo_keywords`,`seo_description`,`invitation_box`,`invitation_box_click` FROM `soker_category` WHERE `cat_directory` = 'ithlw' LIMIT 1 [ RunTime:0.000289s ]
学员评论(共 132 条评论)
***铃 (****)2021-12-07 16:22
一建建筑考了好几年了 一直都是92 93分 去年报了优路的课程 总算是考过了 哈哈哈哈 想想就很开心 现在继续在优路学习造价的课程 祝我尽快通过吧 啦啦啦啦。
梦**你 (****)2021-12-07 16:21
优路不错啊 我今天去上了消防的课程 老师讲的很不错 有很多地方讲的都比一般老师更专业,一看就是专门从事消防相关的,不是那种学院派 今年很有信心考过。
***朝 (****)2021-12-07 16:19
优路教育还是很靠谱的 老师还会时常监督我学习 学习问题也有及时帮助我解答 跟上进度学习 希望今年可以一次考过一级消防。
**猫 (****)2021-12-07 16:18
单位的同事报名优路的一建学习去年通过了,介绍我来这里报,打了个咨询电话 ,老师给讲解的很详细,也很耐心 ,果断的选择了同事报的班级,目前正在听着课程,班主任老师还会经常督促学习,了解学习情况。总之很贴心的感觉 ,没有选错地儿,希望自己今年能一次通过!
呆* (****)2021-12-07 16:14
还有几个多月就考试了 今年报了造价的辅导 优路的 面授 之前一建考过了 希望自己加油考过 同时也感谢班主任对我的提醒以及帮助。
*哩 (****)2021-12-07 16:11
去年听朋友说他考消防报的优路通过了,也推荐给我了,本来我还有点担心难度和培训效果,结果果然没让我失望,面授课程开的也比较及时,在线答疑果然好用,有问题直接老师就给回复了。只是有的时候回复的额不是很及时,及时些就更好了,希望自己也可以考过!
*姬 (****)2021-12-06 17:05
听朋友说的消防工程师,今年工作不忙有时间学,就自己买的教材,看教材有赠送网络课程就看了一下,之后优路的联系到了我这边,还算详细的给我解答了一消的这些问题,说是有面授课能试听,就去听了,听了一天觉得效果很好,比自己看书有效率的多,就报了个班。现在一直在看课程,就目前来讲觉得还是可以的,不明白的地方给留言,回复的也还算快。总之这钱,我觉得花的不亏,希望今年能一次考过吧。
兔**了 (****)2021-12-06 17:04
我是听一个同事说他是在优路报的一建,好像还可以,反正去年在那里报的,过了。 然后我今年也在那里报了,服务挺好的,经常会打电话督促学习,询问学习情况,希望今年自己能过2-3科。
*妓 (****)2021-12-06 17:02
上次问朋友消防哪一家的辅导好一些 朋友推荐的优路的说他们请的老师都是行业内的老师 本周我要去上课 才报的班 明天建筑防火专题课程 听说老师是来头不小 希望明天有个好的收获 今年考试有个好的结果
***笑 (****)2021-12-06 17:01
上个周末在优路的课堂上学习了两天,好久没有这种埋头学习了,环境不错 服务也到位。老师很棒 声情并茂,哈哈~!给努力学习的自己点赞,给优路教育点赞。
杯***和 (****)2021-12-06 16:59
我是去年参加的一建考试,开始自己学,感觉很难,后来优路的老师介绍了优路的课程,试听了一次,感觉不错,就报了班,没想到对我的帮助还很大,一次性通过了考试,很开心!感谢优路教育!
温**猫 (****)2021-12-06 16:55
一开始选择辅导班时候犹豫过,也有很多家机构联系我,最后综合各方面考虑报了优路教育的辅导课程,虽然一开始他们老师说一直跟踪学习,但是也没有太多时间关注我,我也理解,也许是学员多了,忙不过来,建议大家多联系他们,这样他们服务也不敢推脱。不过课程内容是真的挺好的,我这边前后看了两三遍,都低分飘过了,所以相信教育同时,自己的努力也很重要,也算是相信了优路,我这边才顺利通过考试吧,大家还是根据自己的判断,去