• 北京恒企会计学校怎么样
  • 15年专注于会计职称考试培训
  • 为学生提供独特的教学服务方式,以及高品质教学课程

400-060-0103

北京恒企会计学校税务师必知:税收筹划十大实操方法论解析

来源:北京恒企会计学校 时间:05-24

北京恒企会计学校税务师必知:税收筹划十大实操方法论解析

税务师必备:北京恒企会计学校解读税收筹划十大实操方法论

税收筹划的核心价值与底层逻辑

在企业经营场景中,税务成本是影响利润的关键变量。税收筹划并非简单的"节税游戏",而是基于税法框架的专业规划行为——通过对企业战略模式、经营流程、投资决策等环节的提前设计,实现税款节约、纳税时间优化及税务风险可控三大目标。北京恒企会计学校税务师教研组指出,掌握系统的筹划方法,是税务师为企业创造价值的核心能力。

值得强调的是,所有筹划行为必须以合法性为前提。这要求税务师不仅要熟悉现行税法条文,更要关注政策动态,避免因理解偏差导致筹划方案失效。接下来,我们将从十大基础方法切入,结合恒企教学案例展开解析。

方法一:纳税人身份动态规划法

纳税人身份的选择直接影响适用税率与计税方式。以增值税为例,一般纳税人与小规模纳税人的税负差异显著。恒企会计学校在教学中常以商贸企业案例说明:某批发企业年销售额500万元(不含税),若作为一般纳税人,按13%税率计算销项税额65万元,取得进项发票40万元(13%税率),应纳税额25万元;若登记为小规模纳税人(3%征收率),应纳税额15万元,税负降低40%。

但需注意,身份选择需综合考虑下游客户需求(是否需要专票)、进项获取能力等因素。恒企教研团队建议,税务师应建立动态评估模型,根据企业经营周期(初创期/扩张期/稳定期)调整身份策略。

方法二:税基控制与分解策略

税基是计算应纳税额的基数,控制税基大小是最直接的筹划手段。以企业所得税为例,通过合理确认收入时点(如分期收款方式)、充分列支合规成本(研发费用加计扣除)、利用资产折旧政策(加速折旧)等方式,可有效降低应纳税所得额。

恒企教学中曾解析某制造企业案例:该企业通过将设备采购合同约定为"分三年验收付款",将原本需当年确认的500万元收入,调整为分三年确认(每年约167万元),结合小微企业所得税优惠(年应纳税所得额300万以下按5%税率),三年累计节税超60万元。

方法三:税率差利用与转化

我国现行税制存在多档税率(如增值税13%/9%/6%/3%,企业所得税25%/20%/15%等),利用税率差异进行业务转化是常见筹划路径。恒企会计学校税务师课程中重点讲解的"混合销售拆分"即为典型应用:某企业销售设备并提供安装服务(原按13%税率合并计税),通过成立独立安装公司(适用6%服务税率),将原1000万元收入拆分为700万设备销售(13%)+300万安装服务(6%),整体税负降低约12万元。

需注意,业务拆分需符合商业实质,避免被税务机关认定为"不合理商业安排"。恒企教研团队建议,拆分方案应同步调整合同条款、人员配置及财务核算体系,确保业务真实性。

方法四:税收优惠政策精准适用

我国针对不同行业(如高新技术企业)、区域(如西部大开发)、群体(如残疾人)出台了大量税收优惠政策。税务师的核心职责之一,就是帮助企业精准匹配适用政策。北京恒企会计学校整理的"政策适用三步骤"值得参考:

  1. 政策筛选:根据企业所属行业、规模、业务模式,建立"政策候选库";
  2. 条件匹配:逐项核对政策适用条件(如研发费用占比、人员学历要求等);
  3. 落地实施:调整企业经营行为(如增加研发投入)、完善备查资料(如知识产权证书),确保符合政策要求。

以某科技型中小企业为例,通过恒企税务师指导,成功申请"研发费用加计扣除"政策,当年加计扣除额达300万元,直接减少企业所得税75万元(按25%税率计算)。

方法五:会计政策选择与调整

会计核算方法的选择会影响税务处理结果。例如,存货计价方法(先进先出法/加权平均法)、固定资产折旧方法(直线法/双倍余额递减法)的选择,会直接影响当期成本费用,进而影响应纳税所得额。

恒企会计学校在教学中强调,会计政策选择需遵循"匹配企业经营周期"原则:处于盈利上升期的企业,可选择加速折旧法提前列支成本;处于亏损期的企业,可选择直线法平滑利润。某制造企业通过调整存货计价方法,在原材料价格上涨周期中,将原本的"先进先出法"改为"加权平均法",当年多列支成本80万元,减少企业所得税20万元。

方法六:交易模式重构与优化

交易模式的设计决定了纳税义务的发生时点与计税方式。恒企会计学校通过大量企业咨询案例总结出,常见的交易模式优化包括:

  • 销售模式调整:将"买断式销售"改为"代销模式",延迟收入确认时间;
  • 结算方式变更:将"现款现货"改为"分期付款",分散纳税义务;
  • 交易主体转换:通过设立中间控股公司,利用股息红利免税政策降低股权转让税负。

某房地产企业曾因项目销售集中,导致单月增值税税负高达18%。通过恒企税务师建议,将部分房源改为"委托代销"模式,约定代销方完成客户签约后再结算款项,成功将税负分摊至多个纳税期,单月最高税负降至8%。

方法七:跨期分摊与递延纳税

递延纳税相当于获得一笔"无息贷款",对企业现金流管理具有重要意义。恒企会计学校税务师课程中重点讲解的"企业重组特殊性税务处理"即为典型应用:符合条件的企业合并、分立业务,可选择暂不确认资产转让所得,将纳税义务递延至后续环节。

某集团公司实施子公司合并时,通过适用特殊性税务处理,将原需当期缴纳的1200万元企业所得税,递延至未来5年分期缴纳,有效缓解了重组期的资金压力。需注意,递延纳税需满足严格的条件(如股权支付比例不低于85%),税务师需提前规划交易结构。

方法八:国际税收筹划策略

随着企业国际化进程加速,国际税收筹划成为税务师的重要能力领域。北京恒企会计学校总结的"三要素模型"包括:

1. 税收协定利用:通过在与我国签订税收协定的国家(地区)设立中间公司,降低股息、利息、特许权使用费的预提所得税;

2. 转移定价调整:在关联企业间合理制定交易价格,避免被税务机关认定为"不合理转移利润";

3. 受控外国企业(CFC)规则应对:通过合理设计境外公司架构,避免触发CFC规则导致的利润视同分配纳税。

某跨境电商企业通过在香港设立采购中心(适用内地与香港税收安排,股息预提税率5%),较直接从境外采购(预提税率10%)每年节约税款超50万元。

方法九:税务风险防控与合规

税收筹划的终极目标是"在合规中创造价值"。恒企会计学校强调,税务师需建立"筹划-执行-监控"的全流程风控体系:

筹划阶段:通过"税法适用性分析+商业合理性论证"双维度评估方案可行性;

执行阶段:同步完善合同、凭证、资金流等支撑材料,确保业务链条完整;

监控阶段:定期进行税务健康检查,对政策变动、企业经营调整等因素及时响应。

某企业曾因忽视"关联交易独立交易原则",被税务机关调增应纳税所得额800万元,补税及滞纳金合计超300万元。通过恒企税务师介入,建立关联交易定价模型并完善同期资料,后续年度成功避免类似风险。

方法十:案例复盘与经验迭代

税收筹划是实践性极强的专业领域。北京恒企会计学校建议税务师建立"案例库",定期对成功/失败案例进行复盘:

成功案例:总结关键策略、政策适用条件、执行要点,形成可复制的方法论;

失败案例:分析风险点(如政策理解偏差、业务实质缺失),建立"负面清单"。

恒企教研团队通过100+企业咨询案例的复盘,提炼出"筹划方案可行性评估表",包含政策匹配度(30%)、商业合理性(40%)、操作复杂度(20%)、风险等级(10%)等评估维度,为税务师提供标准化工具。

结语:专业能力是税收筹划的核心竞争力

从本文解析的十大方法可见,税收筹划绝非"简单套用模板",而是需要税务师具备扎实的税法知识、敏锐的政策洞察力、丰富的实践经验。北京恒企会计学校作为专注财税培训的专业机构,始终以"培养懂政策、会实操、能风控的复合型税务师"为目标,通过案例教学、政策解读、模拟实操等多元教学形式,助力学员系统掌握税收筹划核心技能。

对于正在备考或已执业的税务师而言,持续学习与经验积累是提升专业能力的关键。恒企会计学校愿与广大税务师共同成长,为企业税务优化、财税行业发展贡献专业力量。

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 18:36:05 HTTP/1.1 GET : http://www.eduml.com/s/721/n/11058.html
  2. 运行时间 : 0.014854s [ 吞吐率:67.32req/s ] 内存消耗:400.80kb 文件加载: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.000284s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000889s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '721' AND `site_id` = 7 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000285s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000577s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 721 [ RunTime:0.000225s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000605s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 721 [ RunTime:0.000243s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000650s ]
  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` = 721 AND `a`.`content_id` = '11058' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.001098s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '721' and content_id < '11058' and site_id <= '7' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '721' and content_id > '11058' and site_id <= '7' order by content_id asc limit 1) [ RunTime:0.001040s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000723s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 721 AND `site_id` = 7 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000475s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 721 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000213s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 721 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000168s ]
  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` = '7' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 11058 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.003625s ]
0.015165s