• 始终坚持以专业化的特色课程、高水准的教师阵容、严谨的教学态度
  • 采用创意性教学模式作为办学准则,紧密结合国内外市场动向
  • 力求做到专业知识与实践教学的完美结合

400-688-0112

网页设计进阶指南:7大用户体验优化核心技巧解析

来源:上海交大湖畔国际艺术与设计 时间:05-19

网页设计进阶指南:7大用户体验优化核心技巧解析

网页设计进阶指南:7大用户体验优化核心技巧解析

一、深度挖掘用户需求:从数据洞察到真实对话

网页设计的起点不是视觉呈现,而是对目标用户的深度理解。这里的「理解」远不止于年龄、地域等基础数据,更需触及用户的核心需求与行为阻碍。例如,某教育类网站曾通过后台数据分析发现用户注册转化率低至15%,但进一步的用户访谈揭示:超60%用户因「担心个人信息泄露」放弃注册,而非流程复杂。这一发现直接推动了隐私协议的可视化展示与加密标识的强化设计。

要实现这种深度洞察,需建立「数据+场景」的双轨研究模式。一方面通过分析工具(如热图、点击流)捕捉用户行为轨迹,定位操作瓶颈;另一方面通过1v1访谈或现场观察,记录用户真实使用时的情绪反应与口语化表达。例如,某电商平台在优化搜索功能时,不仅收集了搜索词云数据,更通过用户测试发现:「找了半天没结果」「不确定输入是否正确」是主要痛点,进而增加了搜索建议联想与「无结果时推荐热门商品」的功能模块。

二、操作预期管理:用视觉与文案消除用户焦虑

用户点击按钮前的犹豫,往往源于对操作后果的未知。某金融类APP曾因「确认支付」按钮设计模糊,导致30%用户因担心误操作而放弃交易。这提示我们:关键操作需通过「视觉语言+明确文案」双维度传递预期。

视觉层面,可运用通用符号体系与色彩心理学。如删除功能使用垃圾桶图标(识别度超90%),添加功能用加号图标;主操作按钮建议使用绿色(代表「确认/继续」),危险操作使用红色(如「永久删除」)。尺寸上,移动端关键按钮建议不小于48x48px(符合手指点击舒适区),PC端可适当缩小但需保持点击热区足够。

文案层面,需避免模糊表述。例如「提交」可优化为「提交报名信息」,「下一步」可改为「查看订单详情」;对于不可逆操作(如删除文件),需增加二次确认弹窗,文案建议:「确认删除?删除后将无法恢复」。某协作工具通过这一优化,误删投诉量下降了65%。

三、错误预防与修复:构建用户容错保护网

人非圣贤,孰能无过。优秀的设计不是杜绝错误,而是让错误「难以发生」且「易于修正」。某表单填写页面曾因未校验手机号格式,导致每月超200条无效数据;而优化后增加「实时格式校验+错误提示」(如「手机号需为11位数字」),无效数据率骤降至3%。

预防错误的核心是「前置校验」。例如电商购物车页面,当用户尝试删除商品时,可先提示「删除后该商品将移出购物车,是否继续?」;表单填写时,对必填字段用*号标注并实时检查(如邮箱格式、身份证号位数),未填写时按钮保持不可点击状态。

若错误已发生,需提供清晰的解决方案。某云存储平台的「文件删除」功能,不仅在删除时提示「可在回收站恢复」,更在删除后页面顶部显示「已删除至回收站,7天内可恢复」的提示条,同时提供「前往回收站」的快捷链接。这种「错误-提示-修复」的闭环设计,使用户找回误删文件的成功率提升了80%。

四、即时反馈机制:让用户感知操作有效性

「点击按钮没反应?」「加载卡住了?」这些场景会直接引发用户焦虑。某新闻客户端曾因加载反馈缺失,导致用户跳出率高达45%;优化后增加「加载中」动画与「内容即将呈现」的文字提示,跳出率降至18%。

反馈设计的关键是「时效性」与「明确性」。根据可用性研究,用户对延迟的容忍度为:1秒内无反馈会感到轻微等待,3秒以上开始焦虑,10秒以上则70%用户会选择离开。因此:

  • 1秒内操作(如按钮点击):用微交互(如按钮轻微缩放、颜色变化)告知「已响应」;
  • 1-10秒加载:显示轻量级动画(如旋转图标、波浪进度条),避免静态等待;
  • 10秒以上加载:需提供进度百分比(如「已加载60%」)或可选操作(如「继续等待」「返回上一页」)。

需注意的是,5秒内的加载不建议使用进度条——研究表明,静态进度条会让用户感知的等待时间延长30%。此时推荐使用无进度暗示的动态图标(如Mac的「旋转齿轮」),降低用户对时间的敏感度。

五、元素布局法则:基于菲茨定律的交互优化

菲茨定律(Fitts' Law)指出:目标的获取时间与目标距离成正比,与目标大小成反比。这一原则直接指导界面元素的布局策略。例如某外卖APP将「立即下单」按钮固定在页面底部(距离用户当前操作区近),并设计为48px高的绿色按钮(尺寸大、颜色突出),点击率比原设计提升了22%。

具体实践中需关注三点:

  1. 关键操作按钮「大而近」:移动端主按钮建议最小48x48px,位置靠近用户常用操作区(如页面底部或右侧);
  2. 高频功能「显而稳」:导航栏、搜索框等高频模块建议固定在屏幕边缘(顶部/底部),减少用户定位时间;
  3. 特殊交互「明提示」:若需水平滚动(如商品轮播图),需在区域两端添加箭头图标或文字提示(如「左滑查看更多」),避免用户因未察觉而流失。

六、界面易学习性:降低用户认知负荷

用户对新界面的接受度,很大程度取决于「学习成本」。某企业管理系统曾因功能菜单层级过深(需点击4次进入核心功能),导致新员工上手时间长达1周;优化后采用「核心功能首页直达+次级功能分类折叠」的设计,上手时间缩短至2小时。

降低学习成本的关键是「信息分块」与「渐进式展示」:

信息分块:将复杂功能拆解为可独立理解的模块。例如电商平台的「我的账户」页面,可分为「订单管理」「地址设置」「账户安全」等区块,每个区块内仅展示核心操作(如「查看最近订单」「新增收货地址」)。

渐进式展示:隐藏高级功能,仅在用户需要时呈现。例如设计工具的「基础模式」仅保留常用功能,用户点击「高级设置」后才展开专业选项;新闻客户端的「个性化推荐」功能,首次使用时通过引导提示(如「点击这里定制你的阅读偏好」)逐步引导用户探索。

需避免的是模糊链接文案。「了解更多」这类表述无法传递具体价值,建议改为「查看会员权益详情」「了解课程大纲」等明确描述,既提升用户点击意愿,也便于屏幕阅读器用户理解。

七、数据驱动迭代:让设计效果可量化

设计不是一次性工程,而是持续优化的过程。某旅游网站曾凭借「高颜值首页」获得设计奖项,但若用户停留时长仅12秒、转化率不足5%,这样的设计显然未达目标。这提示我们:设计需以数据为导向,用结果验证效果。

建议通过「分析工具+A/B测试」双轨监测:

分析工具选择:Google Analytics适合追踪整体流量(如来源、页面停留时长),Mixpanel更擅长事件分析(如按钮点击路径、功能使用深度)。某教育类平台通过Mixpanel发现,「免费试听」按钮的点击量仅为「立即报名」的1/3,进一步分析显示:用户更倾向先体验再付费,于是调整按钮文案为「免费试听→满意再报名」,点击量提升了40%。

A/B测试应用:对关键设计(如按钮颜色、文案、位置)同时推出两个版本,通过数据对比选择效果更优的方案。例如某电商平台测试「立即购买」按钮的绿色与橙色版本,发现橙色按钮在移动端的点击率高12%,最终选择橙色作为主色调。

需注意的是,数据分析需定期进行(建议每周/每月),并结合用户反馈(如问卷调查、客服记录)综合判断,避免陷入「唯数据论」的误区。

总结来看,优秀的网页设计是「用户需求」与「交互逻辑」的深度融合。从需求洞察到数据验证,每个环节都需围绕「提升用户体验」展开。掌握这7大核心技巧,不仅能让界面更易用,更能通过设计传递品牌价值,最终实现用户留存与业务增长的双赢。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 08:46:45 HTTP/1.1 GET : http://www.educw.com/s/1808/n/9691.html
  2. 运行时间 : 0.013905s [ 吞吐率:71.92req/s ] 内存消耗:389.30kb 文件加载: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.000454s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001191s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1808' AND `site_id` = 8 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000310s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000659s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1808 [ RunTime:0.000221s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000611s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1808 [ RunTime:0.000226s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000733s ]
  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` = 1808 AND `a`.`content_id` = '9691' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000659s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '1808' and content_id < '9691' and site_id <= '8' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '1808' and content_id > '9691' and site_id <= '8' order by content_id asc limit 1) [ RunTime:0.000559s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000747s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1808 AND `site_id` = 8 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000463s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1808 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000200s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 1808 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000166s ]
  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` = '8' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 9691 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.002540s ]
0.014235s