• 获得多家权威教育机构认证
  • 提供全球同步的国际学校课程及幼儿园课程
  • 全球化教育资源打造的“全英文儿童国际学校”

400-888-4851

汉语拼音与英语自然拼读防混淆指南:科学学习策略与场景化训练方法

来源:石家庄埃森英语 时间:06-01

汉语拼音与英语自然拼读防混淆指南:科学学习策略与场景化训练方法

汉语拼音与英语自然拼读防混淆指南:科学学习策略与场景化训练方法

自然拼读与汉语拼音:本质差异决定学习逻辑

在儿童语言启蒙过程中,汉语拼音与英语自然拼读常被家长视为"冲突体",但二者的底层逻辑实则大相径庭。要解决混淆问题,首先需明确它们的本质区别。

英语自然拼读(Phonics)是英语母语国家儿童的核心语言学习工具,通过建立字母(Letter)与发音(Sound)的直接对应关系,帮助学习者实现"见词能读、听词能写"的能力。例如遇到"Enthusiastic"(热情的)这样的长单词,掌握自然拼读规则后,可拆解为/e/、/n/、/th/、/u/、/s/、/i/、/a/、/s/、/t/、/i/、/k/等音素依次拼读。这种能力是英语语言体系的内在组成部分,如同汉语中"见字知音"的基础技能。

而汉语拼音的诞生背景与功能定位截然不同。汉语作为表意文字,汉字本身直接关联读音,拼音是近代为统一发音标准而设计的辅助工具。从1957年现行拼音方案确立至今不过60余年,相对于汉字数千年的发展历史,它更像一套"发音校准系统"。这意味着,汉语拼音并非汉语学习的必需环节——即便不掌握拼音,通过汉字与语音的直接关联也能学好汉语;但自然拼读对英语而言却是"刚需",是构建阅读能力的基础框架。

简单来说,自然拼读是英语的"语言骨架",汉语拼音是汉语的"发音标尺",二者分属不同语言体系的不同功能层级,这为后续科学学习策略的制定提供了理论依据。

混淆频发的根源:孤立学习与场景缺失

实际教学中,约60%的混淆案例并非源于两种体系本身的冲突,而是学习方式的不当。儿童认知发展具有"情境依赖"特征,当两种相似符号(如字母a)以孤立、无场景的方式输入时,大脑难以建立清晰的区分标识。

以刚接触拼音的一年级学生为例,若家长同时要求记忆英语字母发音,孩子可能将拼音"a"(啊)与英语字母音/æ/混淆。这种现象的本质是:两种符号的学习都停留在"机械记忆"层面,未与具体语言场景建立联系。就像教孩子认识"苹果",若只说"这是苹果"而不让他触摸、品尝,孩子对"苹果"的认知必然模糊。

更值得注意的是,部分孩子即使单独学习一种体系也会出现拼读错误。例如拼音中"b"(玻)与"d"(得)的混淆,或英语中"ship"(船)与"sheep"(羊)的误读,这反映出孩子对音素(Phoneme)的感知能力尚未成熟。此时若叠加另一种体系,混淆概率会呈指数级上升。

总结来看,混淆的核心诱因可归纳为两点:一是学习内容脱离具体语言场景,二是音素识别能力未充分发展。解决问题需从这两方面入手。

防混淆核心策略:场景化学习与听力先行

策略一:场景绑定,建立符号-场景的条件反射

儿童的大脑更擅长通过"情境记忆"存储信息。将自然拼读与英语场景绑定,拼音与汉语场景绑定,能有效降低混淆概率。具体可通过以下方式实现:

  • 英语场景:选择以字母为主题的动画片(如《字母积木Alphablocks》),让孩子在"字母变单词"的动画情节中,直观感受字母在具体词汇中的发音。例如看到动画中"A"变成"Apple"(苹果),孩子会自然将"A"的发音与"苹果"的英语表达关联。
  • 汉语场景:利用拼音儿歌或汉字卡片游戏,如"拼音小火车"——家长说"bà ba"(爸爸),孩子找出写有"b""a"的拼音卡并拼成"ba",同时出示"爸"字卡片。这种"拼音-汉字-生活角色"的三重关联,能强化拼音的使用场景认知。

实践数据显示,采用场景化学习的儿童,混淆率比单纯记忆发音的儿童降低约70%。当符号与具体场景深度绑定后,大脑会自动为不同符号分配"使用场景标签",混淆自然减少。

策略二:听力先行,培养音素敏感度

自然拼读的核心是"音素意识"(Phonemic Awareness),即识别、操作语言中最小发音单位的能力。这种能力的培养需从听力输入开始。

在正式学习自然拼读前,建议通过3-6个月的"磨耳朵"阶段,让孩子接触大量英语语音素材。素材选择需遵循"可理解性输入"原则:优先选择语速缓慢、重复率高的儿歌(如《Bingo》)或简单对话类动画(如《小鼠波波Maisy》)。当孩子能熟练辨别"cat"(猫)与"bat"(蝙蝠)的发音差异时,再引入自然拼读规则,学习效率会提升3倍以上。

汉语拼音的学习同样需要听力基础。家长可通过"听字辨音"游戏(如说"马"和"妈",让孩子区分声调),帮助孩子建立声调、声母、韵母的听力感知。当孩子能准确听辨"dī"(低)与"dí"(敌)的区别时,拼音学习会更顺畅。

策略三:允许"短期混淆",通过积累实现内化

需要明确的是,儿童在学习初期出现短暂混淆是正常现象。这恰恰说明孩子在尝试关联两种符号系统,是思维发展的积极信号。家长无需过度焦虑,更不应因混淆而中断某一体系的学习。

正确的做法是增加有效输入量。例如每天安排15分钟英语动画时间+10分钟拼音儿歌时间,通过重复刺激强化记忆。就像成年人学驾照初期会混淆油门刹车,经过足够练习后自然形成肌肉记忆。儿童的语言学习同理——当某一符号在特定场景中出现20次以上时,大脑会自动将其归类为"固定知识模块"。

一位家长的实践案例颇具参考价值:孩子4岁开始接触英语自然拼读,5岁学习汉语拼音初期常将"o"的拼音发音(哦)与英语/əʊ/混淆。家长未强行纠正,而是每天陪孩子读1本英语字母书+1首拼音儿歌。3个月后,孩子能自主区分:"妈妈,读'菠萝'的时候用拼音o(哦),读'boat'(小船)的时候用英语o(欧)!"这正是输入积累带来的内化结果。

学习时机选择:是否需要刻意错开?

关于"是否要错开汉语拼音与自然拼读的学习时间",需结合儿童的实际认知负荷综合判断。

以一年级学生为例,学校会在开学1-2个月集中教授汉语拼音,这对刚适应小学生活的孩子而言已是较大挑战(需掌握23个声母、24个韵母、16个整体认读音节)。此时若在家庭中额外增加自然拼读学习,可能导致孩子因认知过载而产生抵触情绪。建议这一阶段以"英语听力输入"为主(如每天10分钟英语儿歌),暂不涉及字母拼读规则,待拼音学习巩固后(约3个月)再正式引入自然拼读。

对于学龄前儿童(4-6岁),由于尚未接触拼音,可优先进行自然拼读启蒙。通过动画、游戏等轻松形式让孩子熟悉字母发音,为后续拼音学习打下"符号识别基础"。待孩子6岁左右开始拼音学习时,已能区分"字母在英语/拼音中的不同用途",混淆概率会显著降低。

简言之,学习时机的选择需遵循"认知负荷最小化"原则:当某一体系的学习已占用孩子主要精力时,另一体系宜以"渗透式输入"为主;当孩子对单一体系已形成稳定认知时,可逐步引入另一体系,通过场景区分实现协同发展。

结语:混淆不可怕,科学引导是关键

汉语拼音与英语自然拼读的混淆问题,本质是儿童在语言学习过程中对相似符号的"认知调试"。只要遵循"场景绑定、听力先行、允许内化"的科学策略,混淆不仅不会阻碍学习,反而能成为孩子发展"多语言认知能力"的契机。

家长需牢记:语言学习的核心是"使用"而非"记忆"。当孩子能在英语绘本中流畅拼读单词,在语文课本中准确标注拼音时,曾经的混淆早已转化为更强大的语言运用能力。

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-03 16:19:19 HTTP/1.1 GET : http://www.aabrd.com/s/1148/n/12853.html
  2. 运行时间 : 0.014466s [ 吞吐率:69.13req/s ] 内存消耗:410.34kb 文件加载: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.000293s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001082s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1148' AND `site_id` = 19 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000277s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000758s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1148 [ RunTime:0.000208s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000699s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1148 [ RunTime:0.000309s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000706s ]
  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` = 1148 AND `a`.`content_id` = '12853' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000891s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '1148' and content_id < '12853' and site_id <= '19' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '1148' and content_id > '12853' and site_id <= '19' order by content_id asc limit 1) [ RunTime:0.000642s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000737s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1148 AND `site_id` = 19 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000397s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1148 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000221s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 1148 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000215s ]
  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` = '19' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 12853 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.002953s ]
0.014790s