400-888-4011

PLC的抗干扰技术

来源:常州智控教育 时间:07-27

PLC的抗干扰技术

概述

自动化系统中所使用的各种类型PLC,有的是集中安装在控制室,有的是分散安装在生产现场的各单机设备上,虽然它们大多处在强电电路和强电设备所形成的恶劣电磁环境中,但PLC是专门为工业生产环境而设计的控制装置,在设计和制造过程中采用了多层次抗干扰和精选元件措施,故具有较强的适应恶劣工业环境的能力(Ability)、运行稳定性和比较高的可靠性,因此一般不需要采取什么特殊措施就可以直接在工业环境使用,但是由于它直接和现场的I/O设备相连,外来干扰很容易通过(tōng guò)电源线 或I/O传输线侵入,从而引起控制系统的误动作。PLC受到的干扰可分为外部干扰和内部干扰。在实际的生产环境下,外部干扰是随机的,与系统结构无关,且干扰源是无法消除的,只能针对具体情况加以限制;内部干扰与系统结构有关,主要通过系统内交流主电路,模拟量输入信号等引起,可合理设计系统线路来削弱和抑制内部干扰和防止外部干扰。要提高PLC控制系统的可靠性,就要从多方面提高系统的抗干扰能力。

分析硬件电路,提出硬件抗干扰措施

1、PLC控制系统的安装和使用环境

PLC是专为工业控制设计的,一般不需要采取什么特殊(special)措施就可以直接在工业环境使用。但是在PLC控制系统中,如果环境过于恶劣,或安装(ān zhuāng)使用不当,会降低系统的可靠性。PLC使用环境温度通常在0℃ ~55℃范围内,应避免太阳光直接照射,安装位置(position )应远离发热量大的器件,同时应有足够大的散热(radiating)空间和通风条件。环境湿度(humidity)一般应小于85%,以PLC有良好的绝缘。在含有腐化侵蚀 性气体、浓雾或粉尘的场合,需将PLC封闭安装。此外,如果PLC安装位置有强烈的振动源,系统的可靠性也会降低,所以应采取相应的减振措施。 

2 、PLC的电源与接地(earthing)

PLC本身的抗干扰能力一般都很强。通常,只能将PLC的电源与系统的动力设备电源分开配线,对于电源线来的干扰,一般都有足够强的抑制能力。但是,如果遇上特殊(special)情况,电源干扰特别严重,可加接一个带屏蔽层的隔离变压器以减少设备与地之间的干扰,提高系统的可靠性。如果一个系统中含有扩展单元,则其电源必须与基本单元共用一个开关控制,也就是说,它们的上电与断电必须同时进行。良好的接地是PLC安全可靠运行的重要条件。为了抑制附加在电源及输入端、输出端的干扰,应给PLC接专用地线,并且接地点要与其它设备分开,如.1。若达不到这种要求,也可采用公共接地方式,如.1。但是禁止采用串联接地方式,如.1,因为它会使各设备间产生电位差而引入干扰。此外,接地线要足够粗,接地电阻要小,接地点应尽可能靠近PLC 。

接地的目的通常有两个,其一为了安全,其二是为了抑制干扰。完善的接地系统是PLC控制(control)系统抗干扰的重要措施之一。接地在消除干扰上起很大的作用。这里的接地是指决定系统电位的地,而不是信号系统归路的接地。在PLC控制系统中有许多悬浮的金属(Metal)架,它们是惧空中干扰的空中线,需要有决定电位的地线。交流地是PLC控制系统供电所必需的,它通过变压器中心点构成供电两条回路之一。这条回路上的电流、各种谐波电流等是个严重的干扰源。因此交流地线、直流地线、模拟地和数字地等必须分开。数字地和模拟地的共点地好置悬浮方式。地线各点之间的电位差尽可能小,尽量加粗地线,有条件可采用环形地线。系统地端子是抗干扰的中性端子,通常不需要接地,可是,当电磁干扰比较严重时,这个端子需与接大地的端子连接。 

3 、PLC的输入、输出设备

输入电路(Electric circuit)是PLC接受开关量、模拟量等输入信号的端口,其元器件质量的优劣、接线方式及是否牢靠也是影响控制系统可靠性的重要因素。plc培训存储器是具有记忆功能的半导体电路,它的作用是存放系统程序、用户程序、逻辑变量和其他一些信息。其中系统程序是控制PLC实现各种功能的程序,由PLC生产厂家编写,并固化到只读存储器中,用户不能访问。以开关量输入为例,按钮、行程开关的触点接触要保持在良好状态,接线要牢固可靠。机械限位开关是容易产生故障的元件,设计时,应尽量选用可靠性高的接近开关代替机械限位开关。此外,按钮触点的选择也影响到系统的可靠性。在设计电路时,应尽量选用可靠性高的元器件,对于模拟量输入信号来说,常用的有4~20mA、0~20mA直流电流信号;0~5V、0~10V直流电压信号,电源为直流24V。plc培训存储器是具有记忆功能的半导体电路,它的作用是存放系统程序、用户程序、逻辑变量和其他一些信息。其中系统程序是控制PLC实现各种功能的程序,由PLC生产厂家编写,并固化到只读存储器中,用户不能访问。对于开关量输出来说,PLC的输出有继电器输出、晶闸管输出、晶体管输出三种形式,具体选择哪种形式的输出应根据负载要求来决定,选择不当会使系统可靠性降低,严重时导致系统不能正常工作。如晶闸管输出只能用于交流负载,晶体管输出只能用于直流负载。此外,PLC的输出端子带负载能力是有限的,如果超过了规定的大限值,必须外接继电器或接触器,才能正常工作。外接继电器、接触器、电磁阀等执行元件的质量,是影响系统可靠性的重要因素。常见的故障有线圈短路、机械故障造成触点不动或接触不良。这一方面可以通过选用高质量的元器件来提高可靠性,另一方面,在对系统可靠性及智能化要求较高的场合,可以根据电路中电流异常的情况对输出单元的一些重点部位进行诊断,当检测到异常信号时,系统按程序自动转入故障处理,从而提高系统工作的可靠性。若PLC输出端子接有感性元件,则应采取相应的保护措施,以保护PLC的输出触点。 

为了防止或减少外部配线的干扰,交流输入、输出信号与直流输入、输出应分别使用各自的电缆;对于集成电路或晶体管设备的输入、输出信号线、必须使用屏蔽电缆,屏蔽电缆在输入、输出侧悬空,而在控制侧接地,其处理方式如.2。软件(Software)抗干扰措施

硬件抗干扰措施(指针对问题的解决办法)的目的是尽可能地切断干扰进入控制(control)系统,但由于干扰存在的随机性,尤其是在工业生产环境下,硬件抗干扰措施并不能将各种干扰完全拒之门外,这时,可以发挥软件的灵活性与硬件措施相结合来提高系统的抗干扰能力。

1、利用"看门狗"方法对系统的运动状态进行监控

PLC内部具有丰富的软元件,如定时器、计数器(jì shù qì)、辅助继电器等,利用它们来设计一些程序,可以屏蔽输入元件的误信号,防止输出元件的误动作。在设计应用程序时,可以利用"看门狗"方法实现对系统各组成部分运行状态的监控。如用PLC控制某一运动部件时,编程时可定义一个定时器作"看门狗"用,对运动部件的工作状态进行监视。定时器的设定值,为运动部件所需要的大可能时间。在发出该部件的动作指令时,同时启动"看门狗"定时器。若运动部件在规定时间内达到指定位置,发出一个动作完成信号,使定时器清零,说明监控对象工作正常;否则,说明监控对象工作不正常,发出报警或停止工作信号。 

2 、消抖

在振动环境中,行程开关或按钮常常会因为抖动而发出误信号,一般的抖动时间都比较短,针对抖动时间短的特点,可用PLC内部计时器经过一定时间的延时,得到消除抖动后的可靠有效信号,从而达到抗干扰的目的。

3 、用软件数字滤波的方法提高输入信号的信噪比

为了提高输(shū)入信号的信噪比,常采用软件数字滤波来提高有用信号真实性。对于有大幅度随机干扰的系统,采用程序限幅法,即连续采样五次,若某一次采样值远远大于其它几次采样的幅值,那么就舍去之。对于流量、压力、液面、位移等参数,往往会在一定范围(fàn wéi)内频繁波动,则采用算术平均法。即用n次采样的平均值来代替当前值。一般认为:流量n= 12,压力n=4合适。对于缓慢变化信号如温度参数,可连续三次采样,选取居中的采样值作为有效信号。对于具有积分器A/D转换来说,采样时间应取工频周期的整数倍。实践证明其抑制工频干扰能力超过单纯积分器的效果。 

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-05-25 06:17:50 HTTP/1.1 GET : http://www.aabqt.com/s/16972/n/122765.html
  2. 运行时间 : 0.024555s [ 吞吐率:40.72req/s ] 内存消耗:382.49kb 文件加载: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.000309s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000776s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '16972' AND `site_id` = 16 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000251s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000530s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 16972 [ RunTime:0.000205s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000620s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 16972 [ RunTime:0.000214s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000634s ]
  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` = 16972 AND `a`.`content_id` = '122765' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000589s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '16972' and content_id < '122765' and site_id <= '16' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '16972' and content_id > '122765' and site_id <= '16' order by content_id asc limit 1) [ RunTime:0.000637s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000735s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 16972 AND `site_id` = 16 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000387s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 16972 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000241s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 16972 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000175s ]
  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` = '16' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 122765 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.015073s ]
0.024831s