• 童程童美专注于中国3-18岁青少儿编程教育
  • 少儿编程教育3-18岁解决方案
  • 覆盖幼儿园、小学、初中、高中全年龄段的全部课程

400-882-6911

职场人掌握编程技能的三大核心价值:效率跃迁与思维升级全解析

来源:广州童程童美 时间:05-17

职场人掌握编程技能的三大核心价值:效率跃迁与思维升级全解析

职场突围新利器:编程能力的隐性价值

在管理咨询、投资分析、产品运营等多个岗位的辗转经历中,有一项技能始终被我视为职场「秘密武器」——并非科班出身的编程能力。不同于专业程序员的深度开发,普通人掌握的基础编程技巧,往往能在具体工作场景中产生「四两拨千斤」的效果。无论是用脚本自动处理重复任务,还是通过数据挖掘发现业务痛点,这些看似微小的技术应用,正在悄然重构职场竞争力的评价体系。

效率革命:用代码解放重复劳动

职场中最消耗精力的往往不是复杂决策,而是大量机械重复的基础操作。我曾在某互联网公司负责业务运营时,需要每日汇总12个业务线的核心数据,涉及Excel跨表取数、PPT图表更新、邮件批量发送等流程。初期每天需花费2-3小时完成这些工作,随着业务线扩展,这个时间逐渐攀升至4小时以上。

转机出现在用Python编写了一套自动化脚本后:通过Pandas库实现Excel数据自动抓取与清洗,利用Win32com控制PPT动态生成图表,结合SMTP协议完成邮件批量发送。原本需要4小时的工作,现在仅需10分钟触发脚本即可完成。更重要的是,这套工具可以随着业务需求快速迭代——当新增业务线时,只需调整数据接口参数;当报表格式变更时,修改模板文件即可。

类似的场景在办公软件优化中尤为常见。曾为某咨询团队开发Word文档自动生成工具:将客户信息、行业数据、分析结论等模块预先结构化,输入关键参数后自动生成符合格式要求的咨询报告。团队成员反馈,原本需要3天完成的报告撰写,现在仅需半天就能输出初稿,剩余时间可专注于内容深度优化。

设备集群管理也是编程提效的典型场景。此前负责广东区域工厂宿舍网络维护时,需要定期检查分布在5个城市的200余台路由器状态。通过树莓派搭建监控系统,用Python脚本定时ping测试设备连通性,异常状态自动触发短信告警,同时支持远程重启等基础操作。原本每月需要2人/周的现场维护,现在仅需1名运维人员远程处理即可,年节省差旅成本超15万元。

思维升维:数据驱动的决策优势

编程带来的不仅是效率提升,更重要的是思维方式的转变。传统职场决策往往依赖经验判断或抽样调研,而掌握编程能力后,「用数据说话」的思维会渗透到工作的每个环节。

在咨询公司参与呼叫中心优化项目时,传统方法是通过用户问卷和深度访谈收集反馈,不仅周期长(通常需要4-6周),样本量也受限(有效样本约200-300份)。而我们的团队选择用编程实现用户行为全埋点:在呼叫系统中植入数据采集脚本,记录用户每次按键选择、等待时长、转接次数等行为数据。通过分析百万级用户行为日志,快速定位到「三级菜单跳转率异常」「夜间服务响应延迟」等核心问题,仅用2周就完成了传统方法需要3个月、投入50万调研费用的工作。

这种数据驱动思维在产品运营中同样关键。某电商产品优化用户注册流程时,传统思路是通过A/B测试对比不同页面设计的转化率。而我们通过编写爬虫脚本,获取行业内100+同类产品的注册流程数据,结合自身用户行为日志,发现「短信验证码等待时间」是影响转化率的关键变量。针对性优化短信通道后,注册转化率提升27%,远高于常规页面设计调整的效果。

更值得关注的是,编程能力培养的「问题拆解思维」。当遇到复杂业务问题时,具备编程基础的职场人会更自然地将问题拆解为「输入-处理-输出」的模块化结构,通过分步验证快速定位瓶颈。这种思维方式不仅适用于技术问题,在跨部门协作、项目管理等场景中同样有效——将复杂任务分解为可执行的子任务,明确每个环节的输入输出,能显著提升团队协作效率。

个人品牌:技术赋能的职场差异化

在职场中,「能解决别人解决不了的问题」是建立个人品牌的核心。当团队遇到「如何快速合并1000个Excel文件」「怎样自动生成周报」等技术型问题时,具备编程能力的职场人往往能成为「问题解决者」。这种角色定位不仅能快速获得同事信任,更能在上级面前建立「复合型人才」的印象。

曾有一段经历令人印象深刻:某季度部门需要向集团汇报18个月的业务数据,涉及12个维度的趋势分析。当其他同事还在手动整理图表时,我用Python编写了数据可视化脚本,输入原始数据后自动生成包含折线图、柱状图、热力图的汇报PPT。最终汇报因数据呈现清晰、分析维度全面,获得集团高层特别表扬。这次经历让我在部门内获得「技术型业务骨干」的标签,后续重要项目的参与机会显著增加。

需要强调的是,普通人学习编程无需达到专业开发水平。掌握Python、VBA等基础脚本语言,熟悉Excel函数、SQL查询等工具,就能覆盖80%以上的职场应用场景。关键在于培养「用技术解决问题」的意识——遇到重复任务时思考「能否自动化」,面对数据难题时考虑「能否用代码挖掘」,这种意识的转变比技术本身更重要。

总结来看,普通人掌握编程技能的价值远超「多会一项技术」的表层认知:它是提升效率的「加速器」,是开拓思路的「望远镜」,更是构建职场差异化竞争力的「护城河」。在数字化转型的大背景下,这种「技术+业务」的复合能力,正在成为职场人突破发展瓶颈的关键支点。

课程导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 18:05:40 HTTP/1.1 GET : http://www.edubq.com/s/1594/n/9306.html
  2. 运行时间 : 0.012042s [ 吞吐率:83.04req/s ] 内存消耗:386.42kb 文件加载: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.000291s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000922s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1594' AND `site_id` = 5 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000240s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000603s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1594 [ RunTime:0.000201s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000649s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1594 [ RunTime:0.000239s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000721s ]
  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` = 1594 AND `a`.`content_id` = '9306' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000620s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '1594' and content_id < '9306' and site_id <= '5' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '1594' and content_id > '9306' and site_id <= '5' order by content_id asc limit 1) [ RunTime:0.000580s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000725s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1594 AND `site_id` = 5 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000382s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1594 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000232s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 1594 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000181s ]
  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` = '5' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 9306 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.001881s ]
0.012367s