• 郑州编玩边学致力于为7-16岁青少年提供专业的在线编程教育
  • 郑州编玩边学是国内少儿编程教育开创者
  • 郑州编玩边学始终倡导“编”玩边学、寓教于乐的教学理念

400-882-1633

小学编程启蒙怎么选?Scratch与Python学习要点全解析

来源:郑州编玩边学 时间:03-29

小学编程启蒙怎么选?Scratch与Python学习要点全解析

小学编程启蒙怎么选?Scratch与Python学习要点全解析

从"别人家的孩子"看小学阶段的学习现状

接孩子放学时,总能听到家长们的闲聊:"你家宝贝最近背了几首唐诗?""我们家在练英语短剧,下周学校汇演呢!""楼上小乐厉害,数学竞赛拿了奖,鸡兔同笼题分分钟解出来。"这些被反复提及的,大多是能直接展现的"显性成果"——背古诗的数量、英语对话的流利度、数学题的正确率,像一个个具象的标签贴在孩子身上。

但最近有位家长的话让我印象深刻:"昨天听孩子说,班里有个同学用Scratch做了个会讲故事的动画,老师还在课上展示了。"这让我意识到,编程这个曾经离小学生较远的领域,正悄悄成为新的"比较项"。不过和背古诗、解数学题不同,编程学习有其独特性——它不仅是掌握一门工具,更涉及思维方式的培养。

编程学习的双重维度:工具使用与思维构建

当家长讨论"孩子会不会用Python"时,往往关注的是"工具掌握度"。就像学钢琴要会弹音阶,学绘画要会调色,Python、Java这些编程语言确实是编程的"基础工具"。但真正决定孩子未来能走多远的,是隐藏在工具背后的"应用流程"——逻辑思维、问题拆解能力、创新设计意识。

举个简单例子:同样用Scratch做一个"小猫抓鱼"的游戏,有的孩子只是按教程拖动模块,完成基础功能;有的孩子会思考"如何让小鱼移动更自然?""增加难度关卡该怎么设计?""怎样让游戏界面更美观?"前者停留在工具使用层面,后者则在实践中锻炼了逻辑规划、用户体验设计等核心能力。

这就像学写作:认识汉字(工具)是基础,但能写出有深度的文章,靠的是观察能力、情感表达、结构布局(思维)。编程学习中,工具是"术",思维是"道",二者缺一不可。

Scratch:编程启蒙的"友好窗口"

提到编程启蒙,Scratch是绕不开的工具。它用"积木式"编程替代了复杂的代码,孩子通过拖动不同功能的模块就能完成动画、游戏、互动故事的制作。这种设计对零基础的小学生特别友好——不需要记忆复杂的语法,甚至不认识英语单词也能操作。

去年带孩子参加编程体验课,有个8岁的小女孩用Scratch做了个"妈妈的生日贺卡":点击蛋糕会播放生日歌,拖动蜡烛会改变数量,输入文字会有动态效果。她兴奋地说:"我不用求爸爸帮忙做PPT了,自己就能做会动的贺卡!"这个案例很好地体现了Scratch的价值——它让孩子快速获得成就感,建立对编程的兴趣。

更重要的是,Scratch的学习过程本身就在培养思维能力。设计一个互动故事时,孩子需要考虑"角色什么时候出现?""点击按钮后触发什么动作?""怎么让情节更有趣?"这些思考本质上是在训练逻辑顺序、条件判断和创意表达。

需要强调的是,Scratch并非"只适合小孩"。很多成年人学习编程时,也会先用Scratch理解基础概念,比如循环、分支、事件触发等。它就像一扇窗,打开后能看到编程世界的全貌。

Python:进阶学习的"实用桥梁"

当孩子对编程产生兴趣,并且掌握了基本的逻辑思维后,Python会是一个合适的进阶选择。和Scratch相比,Python需要编写代码,但它的语法简洁(比如用缩进代替大括号)、功能强大(能做数据分析、网站开发、小游戏等),被称为"最接近人类语言的编程语言"。

为什么说Python适合小学高段或初中的孩子?举个学习场景:孩子想统计班级同学的生日月份分布,用Scratch需要手动绘制图表,而用Python可以调用"matplotlib"库,几行代码就能生成美观的柱状图;想做一个自动计算数学题的小程序,Python的"input"和"print"函数能轻松实现交互。这些实际应用能让孩子更直观地感受到编程的"工具价值"。

当然,学习Python不意味着要成为"代码高手"。对于小学生来说,重点是通过解决具体问题(比如整理家庭开支、生成读书打卡表),深化逻辑思维和问题解决能力。就像学骑自行车,掌握平衡后,换不同类型的车(山地车、公路车)会更轻松——Scratch培养的是"平衡感",Python则是让孩子体验"不同车型"的驾驶乐趣。

给家长的启蒙路径建议

经常有家长问:"孩子6岁能不能学编程?""直接学Python是不是更快?"其实编程启蒙没有固定的"时间表",关键是要符合孩子的认知发展规律。结合教育心理学和实际教学经验,这里给出几点参考:

1-2年级(6-8岁):以兴趣激发为主 这个阶段的孩子形象思维占主导,可以通过Scratch的动画、小游戏制作,让他们感受"编程=创造"的乐趣。比如用Scratch讲一个《小红帽》的互动故事,比单纯讲解编程概念更有效。

3-4年级(8-10岁):强化思维训练 随着逻辑思维的发展,可以引导孩子完成稍复杂的项目,比如"垃圾分类小游戏"(需要设计判断条件)、"家庭天气播报器"(涉及顺序执行)。这时候Scratch的学习重点从"完成作品"转向"优化作品"。

5-6年级(10-12岁):尝试工具进阶 有了Scratch的基础,孩子对编程逻辑有了一定理解,这时候可以引入Python的简单应用(如数据整理、自动化小工具)。不需要深入学习语法,而是让孩子体验"用代码解决实际问题"的成就感。

需要注意的是,无论选择哪种工具,都要避免"填鸭式教学"。编程学习的核心是"解决问题",家长和老师应该多提问:"你觉得这个功能怎么实现?""如果这样改,会出现什么结果?"引导孩子主动思考。

成习网:为编程学习提供专业支撑

在编程启蒙的道路上,优质的学习资源能起到关键作用。成习网专注编程教育多年,针对不同年龄段孩子设计了体系化课程:

  • 低龄段课程以Scratch为载体,通过"故事创作""游戏设计"等主题,培养逻辑思维和创新能力;
  • 高龄段课程引入Python,结合数学、科学等学科知识,让孩子用编程解决实际问题;
  • 所有课程均采用"项目制学习"模式,每个阶段有明确的作品目标(如动画短片、数据报表),让学习成果可视化;
  • 专业教研团队定期更新课程内容,紧跟编程教育发展趋势,确保教学内容的实用性和前沿性。

更重要的是,成习网的老师不仅教授编程知识,更注重思维引导。在课堂上,老师会鼓励孩子"试错-调整-优化",培养他们面对问题的韧性和创造力。很多家长反馈:"孩子学了编程后,做数学题更有条理了,写作文也会设计情节了。"这正是编程思维迁移到其他学科的体现。

写在最后:编程不是"另一种才艺",而是思维的升级

回到最初的话题:当我们讨论孩子学编程时,真正应该关注的不是"会不会用Python",而是"能不能用编程思维解决问题"。Scratch和Python是工具,更是载体——通过它们,孩子学会拆解复杂问题、验证假设、优化方案,这些能力将让他们受益终身。

如果您也想让孩子在编程学习中收获思维的成长,不妨关注成习网,和我们一起探索编程世界的无限可能。

课程导航
校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-05 20:16:19 HTTP/1.1 GET : http://www.edujk.com/s/2151/n/5795.html
  2. 运行时间 : 0.013199s [ 吞吐率:75.76req/s ] 内存消耗:388.77kb 文件加载: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.000267s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000901s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '2151' AND `site_id` = 4 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000263s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000618s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 2151 [ RunTime:0.000212s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000652s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 2151 [ RunTime:0.000217s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000704s ]
  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` = 2151 AND `a`.`content_id` = '5795' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.001113s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '2151' and content_id < '5795' 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 = '2151' and content_id > '5795' and site_id <= '4' order by content_id asc limit 1) [ RunTime:0.000773s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000740s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2151 AND `site_id` = 4 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000376s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2151 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000226s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 2151 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000201s ]
  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` < 5795 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.001755s ]
0.013493s