• 厦门开设计算机培训及创意美术培训课程的技能型培训机构
  • 以准确的市场定位和出色的教学水平等优势位居电脑培训行业前列
  • 机构创办25年以来,累计培养学员上10万人,合作企业上千家

400-882-1933

UI设计全流程必备工具指南:从基础到进阶的十大核心软件解析

来源:厦门中信电脑培训中心 时间:06-19

UI设计全流程必备工具指南:从基础到进阶的十大核心软件解析

UI设计全流程必备工具指南:从基础到进阶的十大核心软件解析

基础设计层:位图与矢量处理的核心工具

在UI设计的起点,位图与矢量图形处理是绕不开的基础能力。这两款工具如同设计师的"左右手",分别解决不同类型的视觉设计需求。

1. Photoshop(PS):位图处理的全能选手

提到UI设计的基础工具,Adobe家的Photoshop(简称PS)必然是绕不开的存在。作为全球普及率最高的位图设计软件,它的强大在于对图像、文字、图形的综合处理能力。从电商详情页的主图精修,到APP启动页的背景合成;从图标细节的像素级调整,到界面整体的色彩统一,PS几乎覆盖了UI设计中所有位图相关的工作场景。

值得注意的是,现代UI设计对PS的需求已从单纯的"修图"升级到"场景化设计"。例如在制作APP首页Banner时,设计师需要通过图层混合、蒙版操作和滤镜效果,将产品图、文案、装饰元素融合成视觉统一的整体,这些都需要扎实的PS功底支撑。

2. Illustrator(AI):矢量设计的精准利器

与PS的位图处理不同,Illustrator(简称AI)专注于矢量图形设计。矢量图形的优势在于无限放大不失真,这使得AI在图标设计、字体设计、2.5D立体元素制作中具有不可替代性。

以APP图标设计为例,设计师需要确保图标在16px到1024px的不同尺寸下都能保持清晰锐利,矢量工具的特性恰好满足这一需求。此外,AI的路径编辑、形状布尔运算和渐变网格功能,能帮助设计师高效完成复杂插画和品牌视觉元素的制作,这在金融类、教育类APP的界面设计中尤为常见。

交互原型层:从想法到落地的桥梁

UI设计不仅是视觉呈现,更需要考虑用户操作流程的合理性。这一阶段的工具重点在于快速验证设计逻辑,让团队成员直观看到产品雏形。

3. Axure RP:高保真原型的专业选择

作为专业的原型设计工具,Axure RP的核心价值在于"可交互的需求文档"。设计师不仅能通过它制作页面框架和流程图,还能设置按钮点击效果、页面跳转逻辑、动态数据展示等交互细节,甚至可以模拟简单的用户输入验证。

在实际项目中,Axure原型常被用作需求评审的载体。产品经理、开发工程师和设计师可以通过可点击的原型直观讨论功能逻辑,避免因文字描述不清导致的理解偏差。对于需要频繁修改的项目,Axure的元件库功能还能大幅提升设计复用效率。

4. Sketch:Mac端的移动设计神器

专为Mac系统打造的Sketch,堪称移动端界面设计的"效率工具"。相较于PS的全面性,Sketch更聚焦于移动设计的核心需求:简洁的界面布局、便捷的切图输出和强大的设计规范管理。

其符号(Symbol)功能可以实现设计元素的全局修改,这对需要保持多页面风格统一的APP设计至关重要。此外,Sketch的插件生态(如Figma的部分功能迁移)进一步扩展了其能力边界,从图标批量生成到设计稿自动标注,都能通过插件快速完成,大幅缩短设计周期。

进阶表现层:3D与动效的视觉升级

随着用户对视觉体验要求的提升,3D元素和动态效果已成为UI设计的重要加分项。这两款工具帮助设计师突破二维限制,创造更具沉浸感的交互体验。

5. CINEMA 4D(C4D):3D设计的行业新宠

近年来,C4D在UI设计中的应用呈爆发式增长。这款德国Maxon公司开发的3D建模软件,凭借相对友好的操作界面和强大的渲染能力,成为电商大促、品牌宣传类设计的"标配工具"。

从天猫双11的3D商品展示页,到银行APP的3D图标动效,C4D能轻松实现材质渲染、灯光调节和相机运镜。对于UI设计师而言,掌握C4D的基础建模(如立方体、球体变形)和简单渲染(如OC渲染器),即可为界面增加立体感和科技感,这在教育类APP的课程介绍页、金融类APP的收益可视化界面中尤为常见。

6. After Effects(AE):动效设计的万能引擎

作为Adobe家族的动效制作工具,AE的强大在于对复杂动效的精准控制。从界面元素的淡入淡出,到交互动效的路径跟踪;从MG动画的图形变换,到视频转场的特效合成,AE几乎能实现所有类型的动态视觉效果。

在UI设计中,AE常与PS、AI配合使用。例如,先在AI中绘制矢量图形,导入PS进行色彩调整,最后在AE中添加位移、缩放、旋转等动画,配合关键帧设置和缓动函数,就能制作出符合用户操作习惯的流畅动效。对于需要输出交互动效规范的项目,AE的表达式功能还能实现动效参数的批量调整,提升设计一致性。

协作输出层:设计落地的最后保障

设计最终要落地为可运行的产品,这一阶段的工具重点解决"设计-开发"的信息同步问题,确保视觉效果在代码中精准呈现。

7. PxCook(像素大厨):高效的标注切图工具

完成界面设计后,设计师需要向开发团队交付包含尺寸、颜色、字体等信息的标注文件,以及可用于代码开发的切图素材。PxCook(像素大厨)正是解决这一痛点的专业工具。

它支持自动识别设计稿中的元素尺寸、色值(包括HEX、RGB、HSL等格式)、字体属性(字号、字重、字间距),并生成清晰的标注图。同时,PxCook的智能切图功能可以批量导出不同尺寸(@1x、@2x、@3x)的PNG、SVG素材,避免了手动切图的繁琐操作,大幅提升设计交付效率。

8. 蓝湖:全流程的团队协作平台

在多人协作的项目中,设计稿的实时同步、版本管理和意见反馈是常见痛点。蓝湖作为一款专注设计协作的平台,通过云端存储和权限管理,实现了设计稿、原型、标注的共享与协同。

设计师可以将PSD、Sketch文件导入蓝湖,自动生成可交互的在线原型;开发人员可以直接在蓝湖查看标注数据和切图素材,无需依赖设计软件;产品经理可以在设计稿上添加评论,所有团队成员实时接收反馈。这种"一站式"协作模式,有效减少了信息传递误差,缩短了项目开发周期。

补充工具:拓展设计边界的辅助利器

除了上述核心工具,还有两款软件能帮助设计师提升思维效率和动效表现,值得重点关注。

9. XMind:设计思维的梳理助手

在设计初期,理清产品结构和用户需求是关键。XMind作为思维导图工具,能帮助设计师以可视化的方式梳理信息架构。从用户旅程图的绘制,到功能模块的分类;从设计目标的拆解,到创意灵感的发散,XMind的树状结构和主题关联功能,能有效避免思维混乱,确保设计方向的准确性。

10. Flinto:轻量级的动效展示工具

对于需要快速展示页面跳转和简单动效的场景,Flinto提供了更轻量化的解决方案。它支持直接导入Sketch或PS设计稿,通过拖拽设置页面过渡效果(如滑动、淡入、缩放)和元素动效(如按钮点击反馈),生成可在手机上预览的交互原型。相较于AE的复杂操作,Flinto更适合在需求确认阶段快速验证动效创意。

注:实际设计工作中,工具选择需结合项目需求和个人操作习惯。建议新手从PS、Sketch、Axure等基础工具入手,逐步拓展至C4D、AE等进阶软件,最终形成适合自己的工具使用体系。

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-06-19 15:43:10 HTTP/1.1 GET : http://www.edufv.com/s/305/n/15365.html
  2. 运行时间 : 0.011864s [ 吞吐率:84.29req/s ] 内存消耗:398.54kb 文件加载: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.000405s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001104s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '305' AND `site_id` = 6 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000306s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000610s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 305 [ RunTime:0.000216s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000621s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 305 [ RunTime:0.000217s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000678s ]
  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` = 305 AND `a`.`content_id` = '15365' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000852s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '305' and content_id < '15365' and site_id <= '6' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '305' and content_id > '15365' and site_id <= '6' order by content_id asc limit 1) [ RunTime:0.000407s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000720s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 305 AND `site_id` = 6 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000317s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 305 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000176s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 305 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000189s ]
  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` = '6' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 15365 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.001461s ]
0.012186s