• 西安AF国际艺术教育是一家专注提供“作品集全程辅导”的机构
  • 已成功帮助学员斩获1000+英美艺术名校Offer
  • 西安AF国际艺术教育专注作品集辅导,拥有多年实战教学经验

400-666-4820

交互设计人性化实践全解析:从原则落地到用户体验提升

来源:西安AF国际艺术教育 时间:04-15

交互设计人性化实践全解析:从原则落地到用户体验提升

交互设计示意图

交互设计的核心:以用户需求为原点

设计的本质是解决问题,而交互设计的终极目标是让用户与产品的对话更自然、更高效。所谓人性化设计,并非简单的界面美化,而是从用户的认知习惯、操作场景、情感需求出发,构建符合其心理预期的交互逻辑。当设计者过度追求视觉冲击或技术实现时,往往会偏离「用户为中心」的根本,导致界面复杂、操作卡顿等体验问题。因此,理解并实践人性化原则,是交互设计的关键突破口。

四大核心原则:构建用户友好的交互系统

1. 简易性:降低用户理解成本

优秀的交互设计应让用户「无需学习即可上手」。界面结构需具备清晰的信息层级——核心功能应出现在用户视线的黄金区域(如移动端屏幕中上部),次要功能通过折叠或分类菜单隐藏;操作流程需符合用户的直觉习惯,例如文件删除前的二次确认、表单填写的分步引导。以某办公软件的「保存」功能为例,其将「自动保存」设为默认选项,同时保留「手动保存」入口,既减少用户主动操作,又满足特殊场景需求,正是简易性原则的典型应用。

在视觉呈现上,元素的可识别性至关重要。图标需与实际功能强关联(如「返回」用左箭头而非抽象图形),文字说明要简洁明确(避免「确认」「提交」等模糊表述,改用「删除文件」「完成订单」)。通过这些细节设计,用户能快速理解界面意图,降低误操作概率。

2. 记忆负担最小化:让系统记住用户

人类的工作记忆容量有限(通常为7±2个信息块),要求用户记住复杂操作步骤或参数设置,无疑会增加使用门槛。人性化设计的关键是「替用户记忆」:例如购物车自动保留30天内的商品,表单填写时自动填充历史地址,搜索框记忆最近5次查询记录。某旅行APP的「常用乘客」功能,用户首次添加信息后,后续预订时可直接选择,无需重复输入,显著提升了购票效率。

此外,状态提示的连续性也能减轻记忆压力。当用户在多页面间跳转时,系统需明确标注当前位置(如面包屑导航);操作中断后恢复时,应保留已填写内容(如编辑文档时意外关闭,重新打开可恢复未保存部分)。这些设计细节能让用户更专注于核心任务,而非记忆操作状态。

3. 用户熟悉度:尊重既有认知习惯

用户对界面的操作习惯往往基于长期使用其他产品形成的「心智模型」。例如,大多数用户已习惯「左滑返回上一页」「右上角菜单」「底部标签栏导航」等交互方式。若设计者强行打破这些习惯(如将「返回」按钮置于屏幕右侧),用户需重新学习操作逻辑,容易产生挫败感。

功能优先级的设定也需以用户需求为导向。通过用户调研明确核心场景(如社交软件的「发消息」「看动态」),将高频功能前置;低频功能(如「隐私设置」「账号注销」)则放入次级菜单。某视频APP曾将「播放倍速」功能从设置页移至播放界面底部,因用户调研显示78%的用户会在观看时调整倍速,这一改动使操作效率提升40%,充分体现了「用户熟悉度」原则的价值。

4. 安全性:让用户掌控操作

交互设计中的安全性不仅指数据安全,更包括操作的「可撤销性」和「可干预性」。用户应能自由选择操作路径,且关键操作需提供反悔机会。例如删除文件前的二次确认弹窗、邮件发送前的「延迟发送」功能(允许30秒内撤销)。某云存储软件曾因未设置删除确认,导致用户误删文件后无法恢复,引发大量投诉;改进后增加「回收站」和「30天内恢复」功能,用户满意度提升62%。

对于高风险操作(如支付、权限修改),系统需主动干预。例如支付时要求输入密码或指纹验证,修改敏感信息时发送短信验证码。这些设计并非限制用户,而是通过明确的风险提示,让用户在知情的情况下做出选择,增强操作的安全感。

从原则到落地:界面设计的两大实操方向

1. 布局设计:信息架构的清晰化

界面布局的核心是「信息分层」——通过视觉元素(如大小、间距、颜色)区分内容的重要程度。主信息区(如新闻APP的头条)应使用更大字号、更高对比度;辅助信息(如发布时间、作者)则用较小字号、低饱和度颜色。某阅读类APP将「当前阅读进度」「下一章预览」置于屏幕底部固定位置,「目录」「设置」隐藏于侧边栏,既核心功能可见,又避免界面冗余。

操作路径的简洁性同样关键。用户完成目标任务的点击次数应控制在3次以内(移动端建议2次)。例如电商APP的「立即购买」按钮,从商品详情页到支付页仅需选择规格、确认地址两步,减少中间跳转,降低用户流失率。

2. 色彩运用:传递信息的隐性语言

色彩是交互设计中最直观的视觉元素,其核心作用是「引导注意力」而非单纯装饰。界面主色应控制在2-3种(如蓝色代表专业、绿色代表安全),辅助色用于区分功能模块(如红色提示警告、橙色标注活动)。某金融类APP以蓝色为主色传递可靠感,用绿色标注「收益到账」、红色提示「逾期还款」,用户对关键信息的识别速度提升35%。

需避免高饱和度色彩的大面积使用(如纯红色背景),易造成视觉疲劳。可通过调整透明度(如红色透明度50%)或加入灰度(如灰蓝色)降低刺激度,同时保留信息提示功能。此外,色彩搭配需考虑色盲用户(约8%的男性存在色觉障碍),重要信息应同时使用文字和图标标注(如「完成」用绿色对勾+「已提交」文字),确保信息传递的普适性。

总结:人性化设计的本质是「用户共情」

交互设计的人性化实践,最终落脚于对用户需求的深度理解。无论是简易性原则的落地,还是色彩布局的优化,其核心都是「站在用户视角思考」。设计者需通过用户调研、行为数据分析、可用性测试等方法,持续迭代设计方案,让产品真正成为用户「顺手」的工具。当交互设计与用户需求同频时,产品的价值才能得到化释放。

课程导航
校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-05 16:16:35 HTTP/1.1 GET : http://www.aabqn.com/s/1981/n/5532.html
  2. 运行时间 : 0.011713s [ 吞吐率:85.38req/s ] 内存消耗:395.20kb 文件加载: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.000356s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001037s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1981' AND `site_id` = 18 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000296s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000598s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1981 [ RunTime:0.000215s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000621s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1981 [ RunTime:0.000224s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000637s ]
  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` = 1981 AND `a`.`content_id` = '5532' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000584s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '1981' and content_id < '5532' 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 = '1981' and content_id > '5532' and site_id <= '18' order by content_id asc limit 1) [ RunTime:0.000517s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000711s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1981 AND `site_id` = 18 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000458s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1981 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000260s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 1981 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000167s ]
  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` < 5532 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.001642s ]
0.012039s