• 致力于为建筑行业人员提供系统、全面、高效的培训方案与课程
  • 旨在满足行业人员对各个岗位技术能力与管理水平的提升要求
  • 课程以零基础提升BIM实战技能为主,注重项目实际应用指导

400-666-4820

BIM建模效率提升全攻略:8个Revit实战技巧深度解析

来源:武汉小筑教育 时间:09-28

BIM建模效率提升全攻略:8个Revit实战技巧深度解析

BIM建模效率提升全攻略:8个Revit实战技巧深度解析

一、样板文件:建模效率的"隐形基石"

在Revit建模中,样板文件的重要性常被低估。它不仅是项目的初始框架,更是规范与效率的载体。想象一下:每次启动新项目都要重新设置字体、标注样式、视图模板,甚至反复查找并载入常用族文件——这样的重复操作会消耗大量时间。而一套定制化的样板文件,能将这些"基础工程"一次性解决。

优质样板文件应包含三大核心要素:其一,集成常用族库,如建筑专业的标准门、窗族,机电专业的管道附件族,避免建模时频繁搜索与载入;其二,统一标注规范,从文字高度、线型比例到过滤器规则,确保团队成果的一致性;其三,预设视图模板,如平面、立面、剖面的显示设置,减少后期调整视图的时间。

新手常问:"没有现成的样板怎么办?"其实可从官方标准样板或行业通用样板(如本地设计院提供的模板)入手,根据项目需求调整快捷键、工作平面设置等细节。关键是形成"一人定制,团队复用"的机制——例如某工程团队将优化后的样板共享至服务器,新成员直接调用,单项目启动时间从2小时缩短至15分钟。

二、族文件管理:构建高效的"零件仓库"

Revit模型本质是"族"的集合体,族文件管理水平直接决定建模效率。许多工程师曾陷入"重复造族"的困境:同一项目中多次创建相似族,或因族文件分类混乱导致调用时"大海捞针"。

科学的族管理需遵循"分类-分层-标签"原则。分类上,按专业(建筑/结构/机电)、类型(常规模型/系统族/内建族)划分;分层上,区分通用族(如标准尺寸的柱、梁)与专用族(如项目特有的异形装饰构件);标签上,采用"专业-类型-尺寸"命名规则(如"结构-混凝土梁-300x600"),确保见名知义。

值得注意的是,并非所有族都需自建。Revit自带的系统族(如墙、楼板)已满足基础需求,第三方平台(如族库大师、BIM部落)提供的通用族可直接调用。某市政项目团队通过整合外部族库,将自建族比例从40%降至15%,建模周期缩短20%。

三、编码与命名:让模型"会说话"

"这个视图是哪个阶段的?""这根管道的材质是什么?"建模过程中,类似的疑问常导致效率中断。而规范的编码与命名,能让模型成为"自解释"的数据库。

Revit的命名规范需覆盖四大对象:项目浏览器中的视图(如"一层平面图-方案版")、图元属性(如"柱-ZL-01-C30"表示编号01的C30混凝土柱)、材料信息(如"墙面-乳胶漆-白色")、以及工作集(如"建筑-张三-建模")。编码可参考《建筑信息模型分类和编码标准》(GB/T 51269-2017),确保与行业标准兼容。

某大型综合体项目中,因早期命名随意导致后期调整时需逐个核对图元属性,延误工期1周。此后团队引入"三段式命名法"(专业-类型-参数),问题迎刃而解——这印证了"前期多花1小时规范命名,后期节省10小时调整"的实践规律。

四、WorkSet设置:团队协作的"效率开关"

多人协作时,Revit的WorkSet(工作集)功能如同"模型权限管理器"。未合理设置时,常出现"甲修改了乙的模型"或"软件因加载过多图元卡顿"的问题。

高效的WorkSet配置需遵循"分工-隔离-权限"原则。分工上,按专业划分工作集(如"建筑-墙体"、"机电-管道");隔离上,通过"可编辑/不可编辑"权限限制,避免跨专业误操作;显示控制上,为不同角色(如设计师、审图员)设置视图可见性,减少无关图元加载。

某BIM咨询公司的实践显示:通过WorkSet优化,团队协作时的软件卡顿率下降60%,模型冲突导致的返工量减少45%。关键在于前期与团队成员充分沟通,明确各工作集的职责边界。

五、工具活用:让重复操作"一键完成"

Revit内置的"成组"、"阵列"等工具,是解决重复建模的"利器"。例如,创建一排等距排列的窗户时,使用"线性阵列"功能可一次性完成,比逐个放置节省70%时间;对于复杂节点(如幕墙分格),"成组"后复制到不同位置,修改时只需调整组内单个图元,其他实例自动更新。

需注意工具的适用场景:"成组"适合固定模式的重复构件,"阵列"更适合规则排列的图元。某厂房项目中,工程师通过"路径阵列"快速完成200根钢柱布置,原本需2天的工作仅用4小时完成,充分体现工具活用的价值。

六、图元选择与过滤:精准操作的"导航仪"

"想修改所有一层的柱高,却误选了其他楼层的柱"——这类操作失误在建模中屡见不鲜。掌握图元选择与过滤技巧,能让修改操作更精准高效。

基础技巧包括:窗选(选中矩形区域内的图元)、交叉窗选(选中与矩形区域相交的图元)、选择全部实例(按类型或视图范围选择相似图元)。进阶应用是结合过滤器:例如在平面视图中,通过"类别=结构柱"+"视图范围=一层"的过滤条件,可一次性选中所有目标柱,批量调整高度属性。

某高校实验室项目中,工程师需调整300根不同楼层的柱高。通过"选择全部实例(整个项目)+过滤器(结构柱)",5分钟内完成批量修改,较传统逐个选择节省2小时。

七、模型瘦身:让软件运行"轻装上阵"

随着建模深入,Revit文件常因冗余内容(未使用的视图、过期族、重复CAD链接)变得臃肿,导致软件卡顿甚至崩溃。定期"模型瘦身"是保持效率的必要操作。

具体步骤包括:1.使用"管理-清理未使用的项"功能,移除未使用的视图、族、材质;2.限制复杂族的使用——参数化族虽灵活,但过度嵌套会显著增加计算量;3.减少CAD图元载入,改用"链接CAD"代替"导入CAD",避免图元重复存储;4.定期备份项目文件,防止清理操作导致数据丢失。

某超高层项目中,因未及时清理冗余内容,模型文件从200MB增至1.2GB,软件操作延迟达5秒/次。通过系统瘦身,文件大小降至450MB,操作响应速度恢复至1秒内,建模效率提升30%。

八、插件辅助:突破原生功能的"效率天花板"

尽管Revit功能强大,仍存在部分操作繁琐的场景(如管道翻弯、复杂节点创建)。此时,合理使用插件能大幅提升效率。

市场主流插件各有侧重:红瓦科技的"红瓦插件"在机电管线综合中表现突出,支持一键翻弯、快速打断;橄榄山快模专注于建筑建模,可自动生成楼梯、幕墙等复杂构件;鸿业BIMSpace则集成了建筑、结构、机电全专业工具,适合综合项目。某地铁项目团队使用插件后,管线综合时间从7天缩短至2天,效率提升71%。

需注意插件选择需匹配项目需求——小型项目可选轻量级插件(如"族库大师"),大型复杂项目则需功能全面的插件包。同时,插件安装后需测试兼容性,避免与Revit版本冲突导致崩溃。

结语:效率提升的本质是"系统化优化"

BIM建模效率的提升,并非依赖单一技巧,而是需要从基础设置(样板、族库)、操作规范(编码、命名)到工具应用(原生功能、插件)的系统化优化。本文梳理的8个技巧,覆盖建模全流程,既适用于个人提升,也可作为团队BIM标准的构建参考。

最后提醒:所有技巧需结合具体项目需求灵活运用——例如小型项目可简化样板设置,大型项目则需强化WorkSet协作。唯有将"标准化"与"灵活性"结合,才能真正实现BIM建模的高效与精准。

课程导航
校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-05 05:00:05 HTTP/1.1 GET : http://www.aabqn.com/s/6201/n/34996.html
  2. 运行时间 : 0.017717s [ 吞吐率:56.44req/s ] 内存消耗:390.94kb 文件加载:137
  3. 缓存信息 : 0 reads,0 writes
  1. /data/web/baijiao_branch_collect/public/index.php ( 0.79 KB )
  2. /data/web/baijiao_branch_collect/vendor/autoload.php ( 0.75 KB )
  3. /data/web/baijiao_branch_collect/vendor/composer/autoload_real.php ( 1.63 KB )
  4. /data/web/baijiao_branch_collect/vendor/composer/platform_check.php ( 0.90 KB )
  5. /data/web/baijiao_branch_collect/vendor/composer/ClassLoader.php ( 15.99 KB )
  6. /data/web/baijiao_branch_collect/vendor/composer/autoload_static.php ( 4.26 KB )
  7. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  8. /data/web/baijiao_branch_collect/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
  9. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/helper.php ( 1.47 KB )
  10. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  11. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  12. /data/web/baijiao_branch_collect/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
  13. /data/web/baijiao_branch_collect/vendor/symfony/deprecation-contracts/function.php ( 0.99 KB )
  14. /data/web/baijiao_branch_collect/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
  15. /data/web/baijiao_branch_collect/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.78 KB )
  16. /data/web/baijiao_branch_collect/vendor/symfony/var-dumper/Resources/functions/dump.php ( 1.49 KB )
  17. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/App.php ( 15.30 KB )
  18. /data/web/baijiao_branch_collect/vendor/topthink/think-container/src/Container.php ( 15.76 KB )
  19. /data/web/baijiao_branch_collect/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  20. /data/web/baijiao_branch_collect/app/provider.php ( 0.19 KB )
  21. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Http.php ( 6.04 KB )
  22. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  23. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
  24. /data/web/baijiao_branch_collect/app/common.php ( 10.83 KB )
  25. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/helper.php ( 18.78 KB )
  26. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Config.php ( 5.54 KB )
  27. /data/web/baijiao_branch_collect/config/app.php ( 1.29 KB )
  28. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  29. /data/web/baijiao_branch_collect/config/cache.php ( 1.22 KB )
  30. /data/web/baijiao_branch_collect/config/config.php ( 0.26 KB )
  31. /data/web/baijiao_branch_collect/config/console.php ( 0.29 KB )
  32. /data/web/baijiao_branch_collect/config/cookie.php ( 0.56 KB )
  33. /data/web/baijiao_branch_collect/config/database.php ( 2.29 KB )
  34. /data/web/baijiao_branch_collect/config/filesystem.php ( 0.63 KB )
  35. /data/web/baijiao_branch_collect/config/lang.php ( 0.81 KB )
  36. /data/web/baijiao_branch_collect/config/log.php ( 1.37 KB )
  37. /data/web/baijiao_branch_collect/config/middleware.php ( 0.19 KB )
  38. /data/web/baijiao_branch_collect/config/route.php ( 1.54 KB )
  39. /data/web/baijiao_branch_collect/config/session.php ( 0.57 KB )
  40. /data/web/baijiao_branch_collect/config/trace.php ( 0.34 KB )
  41. /data/web/baijiao_branch_collect/config/view.php ( 0.81 KB )
  42. /data/web/baijiao_branch_collect/app/event.php ( 0.25 KB )
  43. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Event.php ( 7.67 KB )
  44. /data/web/baijiao_branch_collect/app/service.php ( 0.13 KB )
  45. /data/web/baijiao_branch_collect/app/AppService.php ( 0.26 KB )
  46. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  47. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  48. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  49. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  50. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  51. /data/web/baijiao_branch_collect/vendor/services.php ( 0.14 KB )
  52. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  53. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  54. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  55. /data/web/baijiao_branch_collect/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  56. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  57. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  58. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  59. /data/web/baijiao_branch_collect/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  60. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  61. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  62. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.20 KB )
  63. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.75 KB )
  64. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  65. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  66. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.30 KB )
  67. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  68. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  69. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  70. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  71. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  72. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  73. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  74. /data/web/baijiao_branch_collect/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  75. /data/web/baijiao_branch_collect/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  76. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  77. /data/web/baijiao_branch_collect/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  78. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  79. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/cache/driver/Redis.php ( 6.94 KB )
  80. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/cache/Driver.php ( 9.03 KB )
  81. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  82. /data/web/baijiao_branch_collect/app/Request.php ( 0.09 KB )
  83. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Request.php ( 55.78 KB )
  84. /data/web/baijiao_branch_collect/app/middleware.php ( 0.26 KB )
  85. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  86. /data/web/baijiao_branch_collect/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  87. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  88. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/RuleName.php ( 5.75 KB )
  89. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  90. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.43 KB )
  91. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Rule.php ( 26.95 KB )
  92. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  93. /data/web/baijiao_branch_collect/route/app.php ( 3.05 KB )
  94. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  95. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  96. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Dispatch.php ( 10.44 KB )
  97. /data/web/baijiao_branch_collect/app/controller/Index.php ( 33.26 KB )
  98. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Request.php ( 9.20 KB )
  99. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Url.php ( 14.07 KB )
  100. /data/web/baijiao_branch_collect/app/model/IndexModel.php ( 19.95 KB )
  101. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
  102. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Cache.php ( 2.06 KB )
  103. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  104. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.73 KB )
  105. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/PDOConnection.php ( 53.74 KB )
  106. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  107. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  108. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  109. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/Builder.php ( 24.07 KB )
  110. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  111. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/Query.php ( 15.97 KB )
  112. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  113. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  114. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  115. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  116. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  117. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  118. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  119. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  120. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  121. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  122. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/log/driver/File.php ( 5.96 KB )
  123. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  124. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  125. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  126. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  127. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Response.php ( 8.81 KB )
  128. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/response/View.php ( 3.29 KB )
  129. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  130. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  131. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/view/driver/Php.php ( 6.44 KB )
  132. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  133. /data/web/baijiao_branch_collect/view/index/pc/school_news_details.php ( 2.39 KB )
  134. /data/web/baijiao_branch_collect/view/index/pc/school_top.php ( 5.76 KB )
  135. /data/web/baijiao_branch_collect/view/index/pc/school_right.php ( 2.17 KB )
  136. /data/web/baijiao_branch_collect/view/index/pc/school_bottom.php ( 1.16 KB )
  137. /data/web/baijiao_branch_collect/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. CONNECT:[ UseTime:0.000243s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000839s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '6201' AND `site_id` = 18 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000255s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000556s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 6201 [ RunTime:0.000207s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000597s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 6201 [ RunTime:0.000237s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000633s ]
  9. SELECT `a`.*,`content` FROM `fqi_school_news` `a` LEFT JOIN `fqi_school_news_content` `b` ON `b`.`content_id`=`a`.`content_id` WHERE `school_id` = 6201 AND `a`.`content_id` = '34996' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000565s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '6201' and content_id < '34996' and site_id <= '18' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '6201' and content_id > '34996' and site_id <= '18' order by content_id asc limit 1) [ RunTime:0.000478s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000678s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 6201 AND `site_id` = 18 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000455s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 6201 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000215s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 6201 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000193s ]
  15. SELECT `content_id`,`news_name`,`a`.`school_id`,`b`.`school_name` FROM `fqi_school_news` `a` LEFT JOIN `fqi_school` `b` ON `b`.`school_id`=`a`.`school_id` WHERE `a`.`site_id` = '18' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 34996 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.007621s ]
0.018011s