• 力求让前来提升的年轻人有所收获,成为IT教育培训领跑者
  • 全方位指导,入学即签订协议和薪资保障协议
  • 项目驱动教学,实例引入课堂,注重编程思维

400-882-1633

UI面试作品封面设计实战指南:元素搭配与风格塑造的关键技巧

来源:武汉源码时代 时间:08-07

UI面试作品封面设计实战指南:元素搭配与风格塑造的关键技巧

封面设计的核心:元素关系的底层逻辑

在UI面试场景中,作品封面的设计本质是信息的视觉化表达——既要快速传递作品核心主题,又要体现设计师的审美与排版功底。不同于普通海报或宣传页,面试封面需在有限篇幅内完成「吸引注意」与「传递价值」的双重任务,这就要求设计者精准把握图形、色彩、文字三大基础元素的关系。

从基础构成看,图形(包括人物、图标、插画等具象/抽象视觉符号)是封面的视觉锚点,负责在0.5秒内抓住视线;色彩则是情绪传递的关键,通过色调选择(如冷调显专业、暖调显亲和)影响观者心理;文字(标题、副标题等)是信息核心,需清晰传达作品主题与重点。三者的排列组合并非简单叠加,而是需要建立明确的层级关系。例如,某设计师的交互设计作品集封面,采用「大尺寸抽象图形+小面积高饱和度色块+极小字体标题」的组合,通过图形的视觉冲击吸引注意,再通过色块引导视线至标题,这种「图形引导-色彩过渡-文字聚焦」的逻辑,正是元素关系处理的典型案例。

常见的组合模式有四种:纯标题式(适合强调文字信息的极简风格)、纯图形式(依赖图形本身的设计感传递主题)、标题+图形式(最通用的组合,需注意两者比例)、标题+场景式(通过场景化图形增强故事性)。以某UI设计师的「移动端医疗APP」作品封面为例,设计师选择「标题+场景式」组合,用医疗设备图标与患者使用手机的剪影构成场景图形,搭配「智能问诊交互设计」的标题,既明确了作品方向,又通过场景增强了代入感。

从实战出发:5种高适配性封面构图方法

构图是封面设计的骨架,直接决定视觉流畅度。在面试场景中,设计师需根据作品主题选择最适配的构图方式,以下5种方法经大量面试案例验证,适用性与视觉效果兼具。

1. 十字对称构图

这是最经典的稳定型构图,核心是将主要元素(如标题与图形)沿水平/垂直中轴线对称排列。例如,某「金融类UI设计」作品封面,将「数字银行交互设计」标题置于顶部水平中轴,底部放置对称的货币图标与手机界面剪影,中间用渐变线条连接,既保持了视觉平衡,又通过对称传递出金融行业的严谨感。

2. 对角线引导构图

适合需要增强动感或故事性的封面。通过将核心元素沿对角线分布,引导视线从一端自然移动至另一端。例如,「儿童教育类APP」作品封面,设计师将卡通角色图标置于左上角,标题「趣味识字交互设计」置于右下角,中间用弯曲的彩色线条连接,模拟儿童涂鸦的视觉路径,既符合产品定位,又通过动态构图打破沉闷。

3. 中心聚焦构图

当封面需要突出单一核心元素(如一个创意图标或关键界面截图)时,可采用此方法。将核心元素放大并置于画面中心,周围用小字号文字或低饱和度色块辅助。某「智能手表UI」作品封面即采用此方式,将手表主界面截图放大至画面70%区域,仅在底部边缘放置「可穿戴设备交互设计」的极小字体,通过中心聚焦强化作品的核心亮点。

4. 分层叠加构图

适合信息密度较高但需保持视觉整洁的封面。通过不同层级的透明度或位置叠加(如上层为半透明图形,下层为文字)实现信息分层。例如,「多端适配设计」作品封面,设计师将手机/平板/PC界面截图以0.6透明度叠加排列,顶部覆盖「全端交互一致性设计」的白色粗体标题,既展示了多端内容,又通过标题明确主题,避免信息混乱。

5. 留白呼吸构图

在极简风格盛行的当下,留白构图能有效提升封面的高级感。通过大面积留白突出少量关键元素,适用于强调「设计减法」能力的面试场景。例如,某「高端品牌官网UI」作品封面,仅在画面右下角放置品牌LOGO与「官网视觉升级设计」的极小字体,其余区域为纯净的浅灰色,通过留白传递出「简洁即高级」的设计理念,同时考验设计师对「少而精」的把控能力。

风格塑造:如何用元素打造个人设计辨识度?

在面试作品同质化的背景下,「个人风格」是设计师脱颖而出的关键。封面作为印象载体,需通过元素选择与组合传递独特的设计语言。这里的「个人化」并非刻意求异,而是基于设计师的审美偏好与擅长领域,形成可识别的视觉符号体系。

首先,图形语言的个性化。有的设计师擅长扁平化插画,可在封面中固定使用自研的IP形象或几何图形;有的设计师精于3D建模,则可通过低多边形风格的3D元素形成记忆点。例如,设计师A长期使用「圆润线条+软萌配色」的插画风格,其所有作品封面均以自研的「小圆球」IP作为图形核心,这种一致性让面试官在看到封面时就能联想到其设计特点。

其次,色彩体系的个人化。色彩偏好往往能反映设计师的审美倾向,固定的主色调+辅助色组合可形成风格标签。如设计师B偏好「莫兰迪绿+米白」的配色方案,其所有封面均以此为基础调整明度/饱和度,即使内容不同,观者也能通过色彩快速识别出自其手。

最后,排版逻辑的独特性。排版不仅是元素的位置安排,更是设计师思维路径的可视化。有的设计师习惯「从右到左」的阅读引导,有的则偏好「上重下轻」的重心分布,这些固定的排版逻辑能形成差异化的视觉语言。例如,设计师C的所有封面均采用「标题居右+图形居左」的非对称排版,这种打破常规的布局方式反而成为其个人风格的重要标识。

避坑指南:面试封面设计的3大常见误区

在实际设计中,许多设计师因过度追求「吸睛」或忽视面试场景特性,导致封面效果适得其反。以下3个误区需重点规避:

  • 元素堆砌:为展示「设计能力」而加入过多图形、色彩或文字,导致视觉焦点分散。正确做法是根据作品核心主题筛选2-3个关键元素,其余作为辅助。
  • 风格跳脱:同一作品集内不同封面风格差异过大(如前一个封面是极简风,后一个是波普风),削弱整体专业性。建议确定1-2种主风格,通过细节调整保持统一。
  • 信息模糊:标题表述笼统(如仅写「UI设计作品」)或文字过小难以识别。标题需明确作品方向(如「社交APP消息提醒交互优化设计」),文字字号建议不小于14pt(印刷尺寸)或16px(屏幕尺寸)。

总结:用设计逻辑为面试加分

UI面试作品封面的设计,本质是「设计思维」的前置展示。从元素关系的梳理到构图方法的选择,再到个人风格的塑造,每一步都需基于「目标用户(面试官)的信息接收习惯」进行设计决策。记住,优秀的封面不是「最复杂的设计」,而是「最精准传递设计价值」的视觉载体——当面试官看到封面时,能快速理解作品核心,同时感受到设计师的专业与用心,这便是成功的封面设计。

课程导航
校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-06 09:56:21 HTTP/1.1 GET : http://www.edujk.com/s/6002/n/34246.html
  2. 运行时间 : 0.039204s [ 吞吐率:25.51req/s ] 内存消耗:393.38kb 文件加载: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.000340s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001227s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '6002' AND `site_id` = 4 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000323s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000834s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 6002 [ RunTime:0.000339s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000880s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 6002 [ RunTime:0.000371s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.001083s ]
  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` = 6002 AND `a`.`content_id` = '34246' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.012126s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '6002' and content_id < '34246' and site_id <= '4' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '6002' and content_id > '34246' and site_id <= '4' order by content_id asc limit 1) [ RunTime:0.002225s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.001320s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 6002 AND `site_id` = 4 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000591s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 6002 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000364s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 6002 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000287s ]
  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` = '4' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 34246 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.011985s ]
0.039580s