• 具有一定规模的专注日本教育品牌
  • 专业日语教育基地,历年来培养数十万的日语人才
  • 成就学生升学、留学、梦想,深受社会、企业好评

400-882-5311

日企在华发展态势与日语人才适配性深度观察

来源:武汉平成日语 时间:05-13

日企在华发展态势与日语人才适配性深度观察

日企在华发展态势与日语人才适配性深度观察

日企在华扩张的底层驱动与规模表现

中国市场的吸引力正持续转化为日企的实际投资行动。从商务部公开数据来看,近五年日本在华新设企业数量年均增长率达8.6%,这一数字背后是中国稳定的政策环境、完善的产业配套以及消费市场的升级潜力。以长三角、珠三角为核心的经济带,日资企业已形成从汽车制造、电子科技到高端服务业的多元布局。例如上海自贸区范围内,日资贸易商社、金融机构的设立数量较十年前增长近3倍,杭州、苏州等制造业强市的日资工厂产能扩张率连续三年超过15%。

企业规模的扩张直接带动用工需求的提升。某人力资源机构2023年调研显示,在华日企员工总数较五年前增加42万,其中制造业占比45%、商贸服务业占比32%、金融科技领域占比18%。值得注意的是,这种用工增长并非简单的数量叠加,而是伴随产业升级的结构性需求变化——传统加工制造岗位需求增速放缓,而技术研发、供应链管理、跨境商务等中高端岗位需求年增幅达22%。

日企核心领域的人才需求图谱

若将日企在华业务拆解,快速消费品、先进制造、金融服务及IT技术是四大核心板块,每个板块的人才需求呈现鲜明特征:

在快速消费品领域,日企更倾向招聘具备市场洞察能力的复合型人才。以某日系美妆品牌为例,其中国区市场部岗位要求除基础营销知识外,需熟悉中日消费者行为差异,能独立完成产品推广方案的中日双语撰写。这类岗位的招聘周期通常长达2-3个月,主要瓶颈在于同时满足专业能力与语言要求的候选人稀缺。

先进制造领域的人才需求则聚焦技术实操与跨文化协作。以汽车零部件制造企业为例,工艺工程师岗位不仅需要掌握CAD/CAM等专业软件,更要求能与日本总部技术团队进行技术文档的双向翻译及现场指导。某在苏日资精密仪器企业HR负责人透露,此类岗位的离职率较普通技术岗低17%,但招聘难度高出2.3倍。

金融与贸易商社的人才需求呈现明显的区域差异。上海作为金融中心,日资银行、保险机构对具备国际金融知识、熟悉跨境结算规则的日语人才需求旺盛;而大连、青岛等贸易型城市,日资商社更看重候选人的外贸实务经验,尤其需要能独立处理信用证、装箱单等日文贸易单据的专业人员。

IT技术领域的人才缺口集中在日语+技术的复合型岗位。随着日企数字化转型加速,软件研发、系统运维等岗位对"技术+语言"双料能力的要求日益突出。某在杭日资IT企业的招聘数据显示,懂日语的软件工程师平均薪资较纯技术岗高15%-20%,且这类人才在企业内部的晋升速度普遍快于单一技能员工。

日语能力在日企招聘中的核心价值

"会日语"已从加分项演变为多数日企岗位的基础门槛。某知名人才服务机构统计显示,在华日企发布的职位中,明确要求"日语流利"的岗位占比达68%,较五年前提升21个百分点。这种变化源于日企在华运营模式的转变——从早期的"外派管理+本地执行",逐渐转向"本地团队自主运营",这意味着本地员工需要直接对接日本总部的产品研发、市场策略、财务核算等核心部门。

具体来看,日语能力的价值体现在三个层面:其一,日常沟通效率。能直接用日语与总部同事交流,可避免因翻译造成的信息损耗,尤其在技术参数、客户需求等细节传递中,这种效率优势更为明显。其二,文化理解深度。日语中包含大量体现日本职场文化的表达(如"ご苦労様"的使用场景、敬语体系的层级差异),掌握这些细节能帮助员工更快融入企业氛围,减少跨文化沟通障碍。其三,职业发展空间。数据显示,在日企中担任部门主管及以上职位的员工,92%具备流利的日语沟通能力,这一比例在基层员工中仅为37%。

值得关注的是,日语能力的要求正从"日常对话"向"专业场景应用"升级。以制造业为例,除了口语交流,能熟练阅读日文技术文档(如规格书、作业指导书)、撰写日文工作报告(如进度汇报、问题分析)已成为多数技术岗位的必备技能。某日资机械制造企业的培训资料显示,新入职员工需在3个月内通过"技术日语"考核,内容涵盖机械专业术语、图纸标注规范、故障报告模板等实际工作场景。

日企偏爱的复合型人才画像

通过对50家在华日企HR负责人的深度访谈,我们总结出企业对人才的核心要求可概括为"1+1+N"模式:即"日语能力+专业技能+职业素养"的综合匹配。

"1"是基础的日语能力。这里的"基础"并非简单的N3/N4水平,而是能满足工作场景需求的实用能力。以销售岗位为例,需要具备商务日语沟通能力(如客户拜访、合同谈判);技术岗位需要具备技术日语读写能力(如资料翻译、报告撰写);管理岗位则需要具备日语公文处理能力(如邮件往来、会议记录)。

另一个"1"是扎实的专业技能。日企普遍重视"能说会做"的实战型人才,尤其在制造业、IT业等技术密集型领域,专业技能的重要性甚至高于学历背景。某日资电子企业的招聘标准明确注明:"优先考虑有2年以上同岗位实操经验者,日语能力可放宽至N2水平"。这种用人导向背后,是日企对"即插即用"型人才的迫切需求。

"N"则是多元的职业素养。日企特别看重员工的"职场基础力",包括:工作态度上的细致严谨(如数据核对的准确性、文件归档的规范性);团队协作中的配合意识(如跨部门沟通的主动性、任务交接的完整性);职业形象的管理能力(如商务场合的着装规范、接待客户的礼仪细节)。某日企HR经理提到:"我们曾拒绝过一位日语N1、专业能力突出的候选人,原因是他在面试中迟到15分钟且未提前说明,这种缺乏时间观念的表现与企业价值观不符。"

日语人才供给与日企需求的现实差距

尽管近年来学习日语的人数持续增加,但市场供给与日企需求仍存在明显错配。据教育部统计,全国高校日语专业年毕业生约3.2万人,其中进入日企的比例不足40%。这种现象的背后,是"数量充足但质量不匹配"的结构性矛盾。

一方面,部分日语学习者的"应用能力"不足。许多毕业生具备较强的语法知识和应试能力(如JLPT高分),但在实际工作中却难以完成日文邮件撰写、商务谈判等任务。某日企培训主管表示:"我们每年为新员工提供的日语强化培训费用,平均每人达8000元,主要用于纠正'考试日语'与'商务日语'的使用偏差。"

另一方面,"专业+日语"的复合型人才短缺。纯日语专业毕业生在技术、金融等领域的专业知识储备不足,而理工科、商科学生的日语能力普遍较弱。这种"两张皮"现象导致日企在招聘时往往面临"选专业还是选语言"的两难选择。以IT行业为例,既懂软件开发又能熟练使用日语的人才,其市场供需比仅为1:4.7,远低于其他岗位的平均水平。

面对这一现状,部分日企已开始探索校企合作的培养模式。例如某日系汽车企业与国内高校共建"日语+汽车工程"双专业方向,企业参与课程设计并提供实习岗位;某日资银行则推出"管培生计划",选拔商科背景的学生进行系统的日语培训。这些尝试为解决人才供需矛盾提供了新的思路。

课程导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-05 23:45:26 HTTP/1.1 GET : http://www.edumq.com/s/2342/n/8327.html
  2. 运行时间 : 0.014030s [ 吞吐率:71.28req/s ] 内存消耗:392.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.000368s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000971s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '2342' AND `site_id` = 11 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000254s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000558s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 2342 [ RunTime:0.000244s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000596s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 2342 [ RunTime:0.000278s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000643s ]
  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` = 2342 AND `a`.`content_id` = '8327' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000636s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '2342' and content_id < '8327' and site_id <= '11' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '2342' and content_id > '8327' and site_id <= '11' order by content_id asc limit 1) [ RunTime:0.000497s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000675s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2342 AND `site_id` = 11 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000339s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 2342 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000176s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 2342 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000187s ]
  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` = '11' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 8327 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.002514s ]
0.014551s