• 综合IT教育服务提供基地
  • 推动国内IT教育行业的蓬勃发展
  • 致力于高端IT人才培养,助力万千学员成就IT梦

400-688-0112

成都WEB前端学习全攻略:从基础搭建到职业进阶的实用指南

来源:成都汇智动力 时间:04-25

成都WEB前端学习全攻略:从基础搭建到职业进阶的实用指南

成都WEB前端学习全攻略:从基础搭建到职业进阶的实用指南

一、构建扎实基础:前端知识体系的「四梁八柱」

对于成都地区想入行或提升的WEB前端学习者来说,步要解决的不是「学什么框架」,而是「如何搭建完整的知识地基」。前端技术看似更新快,但底层逻辑始终围绕HTML、CSS、JavaScript三大核心展开,这三者的掌握程度直接决定了后续技术拓展的上限。

具体来看,HTML的学习需区分基础语法与语义化应用。除了掌握HTML4的标准标签(如div、span、列表、表单),更要深入理解HTML5的新特性——语义化标签(header、nav、article)能提升SEO效果,画布(canvas)和音视频(video/audio)标签则是现代网页交互的基础。曾有成都某互联网公司前端负责人提到:「面试中最常问的不是Vue的最新语法,而是『为什么要用section而不是div?』这种基础语义问题。」

CSS部分需建立「分层思维」:CSS2的盒模型、浮动定位、继承规则是根基,CSS3的弹性布局(flex)、网格布局(grid)、动画(animation)则是解决现代响应式设计的关键。值得注意的是,预处理器(Less/Sass)并非加分项而是「必备工具」,它们通过变量管理、嵌套规则大幅提升样式代码的可维护性,成都多数互联网团队已将其纳入开发规范。

JavaScript的学习更需打破「会写简单交互」的误区。ES5的原型链、闭包、作用域是理解语言特性的核心;ES6+的模块化(import/export)、箭头函数、Promise则是现代前端开发的基础语法。数据类型(基本类型与引用类型的区别)、异步编程(回调地狱到async/await的进化)、DOM操作(事件委托与性能优化)这三个模块,几乎覆盖了90%的前端日常问题场景。

工具链的掌握同样不可忽视。从基础的代码编辑器(VS Code的常用插件配置),到构建工具Webpack的核心功能(模块打包、代码压缩、热更新),再到版本控制Git的分支管理策略,这些「开发辅助技能」直接影响开发效率。成都某教育科技公司的前端团队曾做过统计:熟练使用Webpack配置的开发者,比仅依赖默认配置的同事,项目构建速度提升40%以上。

二、拓展技术边界:深度与广度的「双轮驱动」

在成都前端圈,常听到「全栈前端」的讨论。所谓「全栈」并非要求精通后端语言,而是强调技术的横向拓展与纵向深挖能力。企业需要的不仅是「能写页面」的执行者,更是「能解决问题」的复合型人才。

技术深度方面,框架与库的选择需结合实际需求。Vue以其「低学习成本+强生态」成为成都中小型企业的首选,React凭借「函数式组件+ hooks」在中大型项目中更具优势,Angular则因「强类型+完整架构」多见于金融、医疗等对代码规范要求高的领域。以成都某电商公司的活动页开发为例:使用Vue3+Vite的组合,从需求确认到上线仅需3天,而传统jQuery开发模式则需7天以上。

技术广度方面,建议从三个方向延伸:一是UI设计基础,掌握Figma/Sketch的原型设计、色彩理论、用户体验(UX)原则,这能让你更高效地与设计师沟通;二是后端基础,了解Node.js的Express/Koa框架、数据库(MySQL/MongoDB)的基本操作,理解前后端接口设计规范(RESTful API),这对全栈发展至关重要;三是移动端适配,掌握REM/VW布局、PWA(渐进式网页应用)开发、跨端技术(uniapp/Flutter),满足企业「多端统一」的需求。

职业发展路径的选择也需提前规划。成都人才市场数据显示:「偏UI的前端工程师」平均薪资12-18k,「懂后端的全栈前端」可达18-25k,「前端架构师」则普遍在30k以上。如果倾向于用户体验方向,可深耕CSS性能优化、动效设计;若对技术架构感兴趣,需研究前端工程化(CI/CD、自动化测试)、微前端等前沿技术。

三、高效学习策略:让努力「事半功倍」的关键

在成都接触过数百位前端学习者后发现,「学不会」的核心原因往往不是「不够努力」,而是「方法不对」。技术学习是「输入-消化-输出」的闭环,任何一个环节缺失都会导致效果打折。

输入阶段要选择「系统性资源」。推荐先通过MDN( Mozilla开发者网络)掌握官方文档,再结合《JavaScript高级程序设计》《CSS权威指南》等经典书籍打基础。在线课程方面,成都本地IT培训机构的「实战项目课」更贴近企业需求(如电商平台开发、管理系统搭建),比纯理论课程更易上手。需注意避免「收藏焦虑」——关注3-5个优质技术公众号(如「前端早读课」「奇舞周刊」)即可,信息过载反而影响学习效率。

消化阶段要重视「动手实践」。每学一个知识点(如Vue的组件通信),立即做一个小项目(如TODO清单、简易博客);每掌握一个框架(如React),尝试重构之前用jQuery写的旧项目。成都某大厂前端导师的经验是:「真正掌握一个技术的标志,是能给刚入行的新人讲明白。」因此,建议定期在技术社区(掘金、SegmentFault)输出博客,或加入本地前端沙龙(如成都前端开发者大会)分享经验,这既能检验学习成果,又能拓展人脉。

输出阶段要关注「企业需求」。成都地区的招聘JD中,「项目经验」「解决问题能力」「团队协作」是高频关键词。建议从「仿站」开始(如模仿某电商首页),逐步参与开源项目(GitHub上搜索「前端」相关仓库),最后尝试独立完成完整项目(如搭建个人博客系统)。在简历中,需突出「技术难点解决」(如「通过Webpack优化,项目打包时间从80s缩短至30s」)而非单纯罗列技能点。

持续学习的「源动力」同样重要。前端技术的更新周期约为6-12个月(如Vue3发布、Vite替代Webpack),需建立「每日学习30分钟」的习惯:早晨花10分钟浏览技术新闻,午休用15分钟看文档片段,晚上20分钟做代码练习。成都某95后前端工程师的经验是:「坚持在GitHub上每日提交代码,一年后技术提升远超预期。」

总结:前端学习的「长期主义」

在成都这样的新一线城市,WEB前端岗位需求持续增长(据2023年智联招聘数据,成都前端岗位同比增加27%),但企业对「高质量前端」的要求也越来越高。学习前端没有「速成秘诀」,但通过「扎实基础+技术拓展+高效方法」的组合,完全可以在6-12个月内达到初级工程师水平,2-3年成长为能独当一面的技术骨干。

最后想对成都的学习者说:技术的本质是解决问题,保持对「为什么这样做」的追问,比单纯追求「学了多少框架」更有价值。当你能站在用户体验、项目性能、团队协作的角度思考问题时,就是从「代码执行者」向「技术决策者」蜕变的开始。

课程导航
校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 23:26:56 HTTP/1.1 GET : http://www.educw.com/s/5566/n/32556.html
  2. 运行时间 : 0.016110s [ 吞吐率:62.07req/s ] 内存消耗:379.10kb 文件加载: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.000355s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001136s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '5566' AND `site_id` = 8 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000298s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000590s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 5566 [ RunTime:0.000240s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000598s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 5566 [ RunTime:0.000230s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000635s ]
  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` = 5566 AND `a`.`content_id` = '32556' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000656s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '5566' and content_id < '32556' 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 = '5566' and content_id > '32556' and site_id <= '8' order by content_id asc limit 1) [ RunTime:0.000575s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000715s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 5566 AND `site_id` = 8 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000444s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 5566 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000199s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 5566 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000190s ]
  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` < 32556 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.005467s ]
0.016409s