• 企业级项目实训,入职能够 具有良好的操作能力
  • 职业培训课程与IT行业岗位要求 高度匹配,受到企业一致好评
  • 随时提供终身服务,挑战 高薪!

400-018-6228

Python新手必学基础技能:5大高效工具与技巧详解

来源:石家庄北大青鸟 时间:06-01

Python新手必学基础技能:5大高效工具与技巧详解

数据结构快速构建:字典与集合推导式

提到Python的列表推导式,多数开发者并不陌生——这种简洁的语法能让代码量减少30%以上。但你知道吗?自Python 3.1(甚至更早的Python 2.7版本)起,同样的语法逻辑已扩展到集合(Set)和字典(Dictionary)的创建中,这为数据结构的初始化提供了更高效的解决方案。

以列表推导式为基础,集合推导式的核心优势在于自动去重。例如,给定一个包含重复元素的列表some_list = [1,2,3,4,5,2,5,1,4,8],若想从中提取所有偶数并生成无重复的集合,只需一行代码:even_set = {x for x in some_list if x%2 == 0},最终得到的集合结果会是{2,4,8}。这种方式比先通过列表推导生成列表再转换为集合更直接,且执行效率更高。

字典推导式的应用场景则更灵活。假设需要生成一个键为1-10的整数,值为该整数是否为偶数的布尔型字典,传统循环方式需要至少3行代码,而字典推导式仅需:d = {x: x%2 == 0 for x in range(1,11)},执行后得到的字典结构清晰,键值对应关系一目了然。值得注意的是,Python 3.7+版本中字典会保持插入顺序,这为需要按顺序处理键值对的场景提供了额外便利。

此外,集合的字面量表示法(如my_set = {1,2,1,2,3,4})会自动去重并生成集合对象,无需再调用内置函数set()。这种语法简化了代码书写,也让集合的初始化更符合直觉。

数据统计利器:Counter计数对象的实战应用

在文本分析、日志统计等场景中,统计元素出现次数是高频操作。尽管可以通过手动遍历列表+字典计数实现,但Python标准库中的collections.Counter提供了更简洁的解决方案。

Counter是字典的子类,其构造函数可直接接收可迭代对象(如字符串、列表等),并自动统计各元素的出现次数。例如,对字符串'hello world'进行统计时,只需from collections import Counter后执行c = Counter('hello world'),即可得到结果:Counter({'l': 3, 'o': 2, ' ': 1, 'e': 1, 'd': 1, 'h': 1, 'r': 1, 'w': 1})。这种方式避免了手动处理重复元素和计数逻辑,代码可读性显著提升。

若需要获取出现频率最高的元素,most_common(n)方法可直接返回前n个高频元素的列表。例如,c.most_common(2)会返回[('l', 3), ('o', 2)],这在词频统计、用户行为分析等场景中尤为实用。此外,Counter还支持加减运算,可用于合并或对比两组统计结果,进一步扩展了其应用范围。

JSON数据可视化:让调试更高效的格式化输出

JSON作为API数据交互的标准格式,在前后端开发中广泛使用。但原始JSON字符串在未格式化时通常表现为一长串无换行的字符,人工阅读和调试极为困难。Python内置的json模块提供了简单的解决方案——通过indent参数实现JSON的可视化输出。

默认情况下,json.dumps(data)会输出紧凑格式的JSON字符串,例如:
{ "status": "OK", "count": 2, "results": [{"age": 27, "name": "Oz", "lactose_intolerant": true}, {"age": 29, "name": "Joe", "lactose_intolerant": false}] }
当数据量增大时,这种格式难以快速定位关键信息。而添加indent=2参数后(如json.dumps(data, indent=2)),输出会自动添加换行和缩进:
{
  "status": "OK",
  "count": 2,
  "results": [
    {
      "age": 27,
      "name": "Oz",
      "lactose_intolerant": true
    },
    {
      "age": 29,
      "name": "Joe",
      "lactose_intolerant": false
    }
  ]
}

这种格式化后的输出极大提升了可读性,尤其在调试接口返回数据或记录日志时,能帮助开发者快速定位问题。

若需要格式化其他类型的数据(如嵌套字典、列表等),Python的pprint模块同样值得推荐。pprint.pprint()方法会根据数据结构自动调整缩进和换行,确保复杂对象的输出清晰易读。

简易服务搭建:用Python快速实现轻量RPC交互

在内部测试或小型项目中,有时需要快速实现两台机器间的简单通信。Python的SimpleXMLRPCServer模块提供了轻量级的解决方案,无需复杂配置即可搭建RPC(远程过程调用)服务。

以文件读取服务为例,服务端代码仅需以下步骤:首先导入模块from xmlrpc.server import SimpleXMLRPCServer,定义需要暴露的函数(如读取文件内容的file_reader),然后创建服务器实例并注册函数。具体代码如下:
from xmlrpc.server import SimpleXMLRPCServer
def file_reader(file_name):
  with open(file_name, 'r') as f:
    return f.read()
server = SimpleXMLRPCServer(('localhost', 8000))
server.register_introspection_functions()
server.register_function(file_reader)
server.serve_forever()

客户端通过xmlrpc.client.ServerProxy连接服务端,调用远程函数:
import xmlrpc.client
proxy = xmlrpc.client.ServerProxy('http://localhost:8000/')
content = proxy.file_reader('/tmp/secret.txt')

需要注意的是,这种方式仅适用于内部测试环境,因未包含安全验证机制,生产环境中需额外添加身份认证、数据加密等防护措施。

Python生态的核心动力:强大的开源社区支持

本文提及的技巧均来自Python标准库,但Python的真正魅力在于其庞大的开源社区。从数据分析到机器学习,从Web开发到游戏制作,几乎所有领域都有成熟的第三方库支持。

选择优质第三方库时,可参考以下标准:
1. **清晰的许可协议**:确保库的使用场景符合许可要求(如MIT、Apache等常见协议);
2. **活跃的维护状态**:通过GitHub等平台查看最近提交记录,避免使用长期无人维护的库;
3. **便捷的安装方式**:支持通过pip install直接安装,降低部署复杂度;
4. **完善的测试覆盖**:测试用例能覆盖主要功能,减少生产环境中的潜在bug。

对于新手而言,参与开源项目是提升编程能力的有效途径。即使是简单的文档完善、测试用例补充,也能为项目发展贡献力量。多数开源社区欢迎新手参与,通过提交Issue或Pull Request,可快速积累实战经验。

例如,数据处理领域的pandas、科学计算的numpy、Web开发的FlaskDjango,均是社区维护的优质库。这些库不仅功能强大,还提供详细的文档和示例,极大降低了开发者的学习成本。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 00:44:34 HTTP/1.1 GET : http://www.aabqj.com/s/1146/n/12866.html
  2. 运行时间 : 0.014454s [ 吞吐率:69.18req/s ] 内存消耗:401.36kb 文件加载: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.000357s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001042s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1146' AND `site_id` = 17 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000290s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000620s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1146 [ RunTime:0.000235s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000632s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1146 [ RunTime:0.000207s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000649s ]
  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` = 1146 AND `a`.`content_id` = '12866' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000930s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '1146' and content_id < '12866' and site_id <= '17' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '1146' and content_id > '12866' and site_id <= '17' order by content_id asc limit 1) [ RunTime:0.000725s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000697s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1146 AND `site_id` = 17 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000347s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1146 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000247s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 1146 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000207s ]
  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` = '17' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 12866 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.002965s ]
0.014759s