• 青岛朗阁在线专注于日韩语言培训,
  • 青岛朗阁在线全方位培养提高学员的语言能力,
  • 青岛朗阁在线是专业小语种雅思托福培训基地。

400-888-9073

零基础日语入门全攻略:从目标规划到五十音图的高效学习指南

来源:青岛朗阁在线 时间:07-29

零基础日语入门全攻略:从目标规划到五十音图的高效学习指南

日语入门步:明确学习方向比盲目努力更重要

接触过许多日语学习者,发现最常见的误区就是“上来就埋头背单词”,结果学了三个月连简单对话都吃力。其实,日语学习的起点不是翻开教材,而是先回答一个问题——“我为什么学日语?”这个问题的答案,直接决定了后续学习路径的选择。

如果是为了留学,需要重点关注学术场景用语,比如大学申请文书写作、课堂讨论表达,建议将目标拆解为“6个月掌握N3核心语法+1年达到N2口语流畅度”;若是出于对日剧动漫的兴趣,不妨优先培养听力和日常对话能力,可设定“3个月听懂90%生活类台词”的阶段性目标;若计划考级,更需根据目标级别倒推学习节奏,例如N1考试要求2000小时有效学习时间,可细化为“每日2小时系统学习+1小时泛听”。

关键是要让目标“可量化、可追踪”。曾有学员最初只说“想学好日语”,后来在指导下具体为“3个月内掌握500个基础词汇+完成《新标准日本语》初级上册”,后续学习效率提升了40%。这说明,清晰的目标不仅能减少迷茫,更能让每一步努力都有明确的反馈。

语言工具的正确打开方式:字典不是“应急品”而是“必修课”

学日语离不开字典,但很多人只有遇到不认识的单词才翻,这种“被动查词”的习惯会严重拖慢学习进度。实际上,字典应该成为日常学习的“伴侣”——无论是背单词还是读文章,主动查阅能帮你深度理解词汇的用法和语境。

以“行く”为例,直接记忆“いく(iku)/去”只是表面,通过字典能发现它还有“进展”(仕事が行く/工作进展顺利)、“流逝”(時間が行く/时间流逝)等延伸含义;再比如“学生”,音读是“がくせい(gakusei)”,但单独的“学”训读为“まなぶ(manabu)”,“生”训读为“いき(iki)”,这种音训差异需要通过字典反复对比才能掌握。建议选择《新日汉词典》这类权威工具书,电子版可备用“MOJi辞书”APP,支持假名、汉字、罗马字多方式检索,非常适合碎片化学习。

特别提醒:查词时不要只记释义,要重点看例句。比如“便利”除了“方便”(交通が便利/交通方便),还可表示“占便宜”(自分だけ便利にする/只图自己方便),这些用法差异在例句中一目了然。坚持“查词必看例句”,3个月后你会明显感觉到对词汇的理解更“立体”了。

沉浸式输入:从“听看”到“内化”的语言积累路径

语言学习的本质是“输入-处理-输出”的循环,而输入质量直接决定输出效果。对于日语学习者来说,最有效的输入方式就是“多听、多看、多接触真实语言环境”。

听的部分,推荐从“慢速日语”开始过渡到NHK新闻。初级阶段可以听《哆啦A梦》《樱桃小丸子》等动画,台词简单且重复率高;中级阶段尝试《半泽直树》《东京爱情故事》这类职场/生活剧,学习正式与口语化表达的区别;高阶可关注TED日语演讲或学术讲座,提升复杂句式的理解能力。需要注意的是,“泛听”和“精听”要结合——泛听培养语感(每天30分钟),精听提升细节(每周2-3次,逐句听写并对照原文)。

看的部分,除了影视,建议订阅《读卖新闻》《朝日新闻》的“简易版”专栏,或者阅读《日本语生活読本》这类生活化读物。这些材料用词贴近日常,还能同步了解日本文化背景(比如“お盆”的习俗解释),比单纯背单词更能形成“语言+文化”的双重记忆。曾有学员坚持每日读1篇日语短文,3个月后阅读速度提升了50%,写作时也能自然运用学到的句式。

另外,日语歌曲也是很好的输入素材。像米津玄师的《Lemon》、中岛美嘉的《僕が死のうと思ったのは》,歌词优美且发音清晰,跟着唱既能练习发音,又能记忆高频词汇。建议选择“平假名标注版”歌词,边唱边对照,效果更佳。

五十音图:绕不开的“日语地基”,如何高效突破?

几乎所有日语学习者都会卡在五十音图,但这也是最不该“卡”的环节——它就像学英语的26个字母,是后续学习的基础。然而,很多人用错了方法:要么死记硬背表格,要么只记平假名忽略片假名,结果后面学单词时频繁“卡壳”。

正确的学习路径应该是“三维同步”:平假名、片假名、罗马字同时记忆。比如“あ(a)”对应片假名“ア”,“い(i)”对应“イ”,每天用卡片随机抽取测试,直到能3秒内反应出三者对应关系。这里分享一个小技巧:将五十音图分成5行(あ行、か行…),每行用1天集中突破,先读准发音(可参考NHK发音教程),再抄写10遍,最后打乱顺序默写。坚持5天完成基础记忆,第6天开始混合测试,巩固记忆。

关于“是否要完全掌握再前进”的问题,我的建议是:优先攻克,但允许“阶段性补漏”。如果时间充裕,用1-2周彻底掌握五十音图的转换和行段关系(比如あ行包括あ、い、う、え、お),这样后续学动词变形(ます形、て形)时会非常顺畅;如果急于开始对话,可先掌握前3行(あ行、か行、さ行),边学单词边补剩下的,但要注意每天留出10分钟复习已学部分,避免“学新忘旧”。曾有学员选择后者,结果学了20个单词后发现50%的假名不熟悉,不得不回头重新学习,反而多花了时间。

最后强调:五十音图的“行段”概念比单个假名更重要。比如看到“た”要立刻反应它属于た行あ段(た、ち、つ、て、と),这对记忆动词变化(如“書く”→“書きます”)、形容词变形(如“高い”→“高かった”)至关重要。可以通过“行段表”贴在书桌前,每天看3遍,强化记忆。

学习习惯:比方法更重要的“长期主义”

见过太多学习者“三分钟热度”:前两周每天学3小时,后面逐渐变成“想起来才学”,最后不了了之。其实,日语学习不需要“爆发式努力”,更需要“持续性投入”。

建议制定“每日最小学习量”:比如每天20分钟背单词+10分钟听日语播客+5分钟复习五十音图。这个量很小,几乎不会占用太多时间,但能帮你保持学习惯性。研究表明,持续30天的微小习惯,大脑会形成“学习反射”,到点就会想打开课本。

另外,定期复盘很重要。每周日花10分钟总结:本周掌握了多少新单词?哪些语法点没理解?听力能听懂多少内容?记录下来并调整下周计划。比如发现“て形”总是搞错,下周就重点练习10个动词的て形变化;如果听力进步明显,可尝试增加10分钟精听时间。这种“反馈-调整”的循环,能让学习效率呈指数级提升。

最后想说,日语学习没有“捷径”,但有“正确的路”。从明确目标到用好工具,从输入积累到夯实基础,每一步都需要耐心和坚持。当你能流畅看懂日文字幕、用日语和朋友简单交流时,会发现所有的努力都值得——因为你不仅掌握了一门语言,更打开了了解另一种文化的大门。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 15:00:45 HTTP/1.1 GET : http://www.aabrh.com/s/2720/n/16841.html
  2. 运行时间 : 0.019967s [ 吞吐率:50.08req/s ] 内存消耗:401.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.000361s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001174s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '2720' AND `site_id` = 20 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000332s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000780s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 2720 [ RunTime:0.000307s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000861s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 2720 [ RunTime:0.000300s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000923s ]
  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` = 2720 AND `a`.`content_id` = '16841' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000988s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '2720' and content_id < '16841' and site_id <= '20' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '2720' and content_id > '16841' and site_id <= '20' order by content_id asc limit 1) [ RunTime:0.000872s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000955s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2720 AND `site_id` = 20 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000747s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2720 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000435s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 2720 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000234s ]
  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` = '20' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 16841 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.005832s ]
0.020327s