• 专业从事无人机研发、生产、销售、服务应用于一体
  • 设有办公楼,训练场地,实训场地等设施
  • 20余种机型取得专利,得到了专业部门的一致认可

400-666-4820

低空无人机航空摄影全流程操作指南:从前期筹备到成果交付详解

来源:石家庄翼龙航空 时间:10-24

低空无人机航空摄影全流程操作指南:从前期筹备到成果交付详解

低空无人机航空摄影全流程操作指南:从前期筹备到成果交付详解

一、项目启动阶段的核心筹备工作

项目合同签订后,技术团队需完成两项关键筹备任务。首项是深入对接甲方需求,开展现场技术交底。技术人员需实地踏勘测区,全面掌握人文地理环境、气候特征、交通条件及地物复杂程度等基础信息。在此过程中,需与用户明确坐标系统选择(包括中央子午线、投影面高程)、高程系统标准、基本等高距参数、图幅分幅规则及数据格式要求,特别注意记录规范外的特殊需求,如特定地物标注精度等。

第二项任务是资料收集与技术设计。需向用户获取1:10000至1:50000比例尺的测区地形图、范围边界数据及已有平面/高程控制点成果(含点之记)。这些资料将作为技术设计书编制的基础依据。航摄技术设计书需结合测区特点选择适配的摄影设备与比例尺,确保获取符合要求的航摄影像;航测内外业技术设计则需统筹施工方案,优先完成外业设计以保障外业队尽早进场作业,内业设计可在外业启动前完成。

二、无人机航飞实施的关键步骤

无人机航飞作业通常由2-3人小组执行,从天气预判到数据导出需严格把控每个环节。航飞前需重点关注气象条件,包括云层厚度、光照强度及能见度,确保满足设备作业要求。确认天气适宜后,携带无人机、地面站电脑等设备前往预先考察的起飞点——要求场地平坦无遮挡(避开电线、高层建筑),并提前规划好架次顺序。

到达现场后,需实测风速并确认低于设备抗风阈值,同时记录当日风速、天气状况及起降坐标等日志信息。航线规划是航飞的核心环节,需依次完成以下验证:

  • 确认作业区域无飞行限制(如机场禁飞区、军事管理区);
  • 通过区域高差与地貌分析确定安全飞行高度及重叠度(山区需提高重叠度保障数据覆盖);
  • 设定基准面海拔(平坦区域取作业面海拔,山区取平均海拔);
  • 选择适配的地面分辨率(单像素对应实际距离需满足成图精度要求);
  • 检查航线周边安全(外扩区域需避开山体、高建筑);
  • 调整飞行角度(优先顺逆风方向减少能耗)。

飞行过程中需实时监测航高、航速及轨迹,同步监控发动机转速与空/地速,确保照片拍摄数量达标。航飞结束后,无人机需降落在无水域、高建筑及高压线的指定区域,手动操作手需待命应对突发状况。最后完成照片数据导出与设备状态检查,为后续处理奠定基础。

三、航飞数据质量的系统性检查

航飞数据需通过快视拼图制作与检查确保质量。利用pix4D、PhotoScan等软件自动生成快拼图后,需重点核查以下指标:

影像质量方面,观察是否存在阴影、云层覆盖及纹理异常,对云层遮挡区域需确认是否有补飞影像;重叠度要求航向重叠60%-65%(最低53%),旁向重叠30%(最低15%),严禁出现航线漏洞。姿态参数方面,旋偏角宜≤2°(≤4°),连续3片以上超限需补飞;航线弯曲度≤3%,单航线航高差≤30%,分区实际航高与预定值偏差≤5%。

四、控制点布设与测量的技术规范

控制点布设直接影响后期数据处理精度,需遵循“规范、严格、均匀”原则。以六旋翼无人机P560H为例,1:1000比例尺0.3平方公里区域建议布设5个像控点,采用区域网法(航向间隔4条基线)分布。选点需满足:视野开阔通视、土质坚实不易损毁、区域边缘无缺漏,优先利用影像清晰的地物点(如斑马线、人行道)。

野外布设前需准备油性喷漆、标靶板(木板/硬纸板),结合影像图与电子地图确定大致位置(如测区四角及中心)。控制点选择需避开斜坡、高楼阴影区,若选楼顶点需确保航拍无遮挡;测点位置需与内业人员核对,优先选择影像边角清晰处。

外业测量包含基础控制、像片控制、碎部测量及像片调绘。基础控制需加密高等级控制点(采用GPS静态或光电导线法),确保精度符合规范;像片控制测量(平高点、平面点、高程点)可选用GPS静态、RTK或光电导线法,需检查选刺质量与限差;碎部测量重点补测隐蔽/新增地物,常与调绘同步进行;像片调绘需识别航片地物性质,补测未显示的重要元素(如检修井、路碑),并用标准图例标注,最终检查调绘质量。

五、内业数据处理的自动化与精细化

内业处理依托智能化软件实现自动化流程,主要包括空三加密、数据采集、编辑、DEM/DOM制作及质检交付。

空三加密需将测区影像输入计算机,基于外业控制点增测平面/高程点,为测图提供定向点与立体模型。数据采集分“先调绘后测图”与“先采集后调绘”两种模式:前者以内业定位为主,参照外业调绘成果修正;后者要求作业员具备外业经验,直接判读模型并标注待补调区域。

内业编辑需将外业调绘内容按图式规范标注(名称注记、层色线型等),确保数据符合入库要求。DEM可通过DLG提取或软件匹配后人工编辑;DOM则利用DEM完成影像纠正、镶嵌与裁切。最终通过15%抽查质检,整改不合格项后完成数据转换与光盘刻录,提交用户验收并根据反馈完善成果。

课程导航
校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-05-02 06:31:38 HTTP/1.1 GET : http://www.eduej.com/s/3047/n/18782.html
  2. 运行时间 : 0.016604s [ 吞吐率:60.23req/s ] 内存消耗:365.45kb 文件加载: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.000297s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000989s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '3047' AND `site_id` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000288s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000613s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 3047 [ RunTime:0.000246s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000602s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 3047 [ RunTime:0.000234s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000699s ]
  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` = 3047 AND `a`.`content_id` = '18782' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000299s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '3047' and content_id < '18782' and site_id <= '1' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '3047' and content_id > '18782' and site_id <= '1' order by content_id asc limit 1) [ RunTime:0.000762s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000936s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 3047 AND `site_id` = 1 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000539s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 3047 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000222s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 3047 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000150s ]
  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` = '1' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 18782 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.004821s ]
0.017092s