当前位置:首页>python>基于Python代码实现批量提取栅格数据

基于Python代码实现批量提取栅格数据

  • 2026-03-14 20:02:16
基于Python代码实现批量提取栅格数据

一、前言

Arcgis中很多空间分析在具体分析过程中基本是重复进行的,所以批量操作可以极大提高效率,所以今天带来源码用于Arcgis批量提取栅格数据,提取栅格数据分为两种常见场景,一是按掩膜提取(矢量边界裁剪);二是按照属性提取(栅格值筛选)两种常见场景,栅格数据主要包含tif和img两种格式,举个例子,手上有全国2000-2025年的夜光数据(tif),想要提取广东省的夜间灯光数据,这种情景下就很适用。或者手里面有全国2000-2025年的夜光数据(tif),想要提取出DN大于20的夜间灯光范围,以上举的两种案例均非常适用。

二、具体代码

-- coding: cp1252 -- # ArcGIS 10.3 Python2.7 专属编码声明,解决中文乱码

import arcpy
import os
import sys
import traceback

= 第一步:ArcGIS 10.3 环境初始化(批量提取核心配置)=

def init_arcgis_env(output_folder, scratch_folder=None):
"""
初始化ArcGIS 10.3运行环境,解决批量提取常见问题
:param output_folder: 提取结果输出文件夹
:param scratch_folder: 临时文件存储路径(可选)
:return: 环境配置成功返回True,失败返回False
"""
try:

核心环境参数(批量提取必设)

arcpy.env.overwriteOutput = True

允许覆盖重复结果,避免批量中断

arcpy.env.addOutputsToMap = False

关闭自动加载图层,提升提取速度

arcpy.env.workspace = output_folder

设置默认工作空间

arcpy.env.scratchWorkspace = scratch_folder if scratch_folder else arcpy.env.scratchWorkspace
arcpy.env.parallelProcessingFactor = "100%"

启用多核并行,加快批量提取

授权空间分析扩展(栅格提取必备)

if arcpy.CheckExtension("Spatial") == "Available":
arcpy.CheckOutExtension("Spatial")
print(u"✅ 空间分析扩展模块授权成功")
else:
raise Exception(u"❌ 空间分析扩展未授权,请检查ArcGIS 10.3许可")

Python2.7 中文编码修复(ArcGIS 10.3 关键)

reload(sys)
sys.setdefaultencoding('utf-8')

创建输出/临时文件夹(避免路径不存在报错)

if not os.path.exists(output_folder):
os.makedirs(output_folder)
if scratch_folder and not os.path.exists(scratch_folder):
os.makedirs(scratch_folder)
print(u"✅ ArcGIS 10.3 环境初始化完成")
return True
except Exception as e:
print(u"❌ 环境初始化失败:{}".format(str(e)))
traceback.print_exc()
return False

=第二步:批量栅格提取核心函数 =

def batch_extract_raster(
input_raster_folder,

待提取栅格文件夹

extract_type,

提取类型:"mask"(掩膜提取)/"attribute"(属性提取)

output_folder,

结果输出文件夹

mask_shp=None,

掩膜提取用的矢量边界(extract_type="mask"时必填)

raster_value=None,

属性提取的栅格值(extract_type="attribute"时必填,如">15")

scratch_folder=None

临时文件路径

):
"""
ArcGIS 10.3 批量提取栅格数据(支持掩膜/属性两种提取方式)
:param input_raster_folder: 待提取栅格文件夹(支持tif/img/bil等格式)
:param extract_type: 提取类型,可选 "mask" 或 "attribute"
:param output_folder: 结果输出文件夹
:param mask_shp: 掩膜矢量边界路径(如.shp),mask模式必填
:param raster_value: 属性提取的栅格值条件(如">15"、"==1"),attribute模式必填
:param scratch_folder: 临时文件路径(可选)
"""

先初始化环境

if not init_arcgis_env(output_folder, scratch_folder):
sys.exit(1)
try:

1. 筛选文件夹内所有栅格数据(ArcGIS 10.3 支持的栅格格式)

arcpy.env.workspace = input_raster_folder

切换到输入文件夹

raster_list = arcpy.ListRasters()

自动识别所有栅格格式,比手动遍历更适配ArcGIS

if not raster_list:
raise Exception(u"❌ 输入文件夹{}中未找到栅格数据".format(input_raster_folder))
total_count = len(raster_list)
print(u"\n📌 共检测到{}个栅格数据,开始批量提取...".format(total_count))

2. 批量处理每个栅格

for idx, raster_name in enumerate(raster_list):

拼接完整路径

input_raster = os.path.join(input_raster_folder, raster_name)

输出文件名(保留原名称+提取类型后缀)

raster_base = os.path.splitext(raster_name)[0]
output_raster = os.path.join(output_folder, u"{}_{}_extract.tif".format(raster_base, extract_type))
print(u"\n🔍 正在处理 {}/{}:{}".format(idx+1, total_count, raster_name))

3. 按提取类型执行操作

if extract_type == "mask":

掩膜提取(矢量边界裁剪栅格)

if not mask_shp or not os.path.exists(mask_shp):
raise Exception(u"❌ mask模式必须指定有效的矢量边界文件")
arcpy.gp.ExtractByMask_sa(input_raster, mask_shp, output_raster)
elif extract_type == "attribute":

属性提取(按栅格值筛选)

if not raster_value:
raise Exception(u"❌ attribute模式必须指定栅格值条件(如'>15')")

构建提取条件(ArcGIS 10.3 ExtractByAttributes 语法)

where_clause = u"VALUE {}".format(raster_value)
arcpy.gp.ExtractByAttributes_sa(input_raster, where_clause, output_raster)
else:
raise Exception(u"❌ 不支持的提取类型{},仅支持mask/attribute".format(extract_type))
print(u"✅ 提取完成:{}".format(output_raster))
print(u"\n🎉 所有栅格提取完成!结果保存至:{}".format(output_folder))
except Exception as e:
print(u"❌ 批量提取失败:{}".format(str(e)))
traceback.print_exc()

打印详细报错堆栈,便于排查ArcGIS 10.3专属问题

finally:

释放扩展模块(ArcGIS 10.3 必须手动释放,否则会占用许可)

arcpy.CheckInExtension("Spatial")
print(u"\n🔍 空间分析扩展模块已释放")

=第三步:主函数(参数配置)=

if __name__ == "__main__":

-------------------------- 请根据需求修改以下参数 --------------------------

基础参数

INPUT_RASTER_FOLDER = r"E:\data\night_light"

待提取栅格文件夹(如夜光数据)

OUTPUT_FOLDER = r"E:\data\extract_result"

提取结果输出文件夹

SCRATCH_FOLDER = r"E:\data\scratch"

临时文件文件夹(可选)

提取类型配置(二选一,注释掉不用的)

【选项1:掩膜提取(矢量裁剪)】

EXTRACT_TYPE = "mask"
MASK_SHP = r"E:\data\city_boundary.shp"

城市边界矢量(掩膜用)

RASTER_VALUE = None

mask模式无需设置

【选项2:属性提取(栅格值筛选)】

EXTRACT_TYPE = "attribute"

MASK_SHP = None # attribute模式无需设置

RASTER_VALUE = ">15" # 筛选栅格值>15的区域(如夜光数据提取建成区)

-------------------------------------------------------------------

执行批量提取

batch_extract_raster(
input_raster_folder=INPUT_RASTER_FOLDER,
extract_type=EXTRACT_TYPE,
output_folder=OUTPUT_FOLDER,
mask_shp=MASK_SHP,
raster_value=RASTER_VALUE,
scratch_folder=SCRATCH_FOLDER
)

三、代码关键说明

环境适配:
开头

-- coding: cp1252 --是 ArcGIS 10.3 Python 2.7 的专属编码声明,解决中文乱码;

arcpy.ListRasters()替代手动遍历文件夹,更适配 ArcGIS 10.3 支持的栅格格式(如 img/bil 等);
强制释放Spatial扩展模块,避免 ArcGIS 10.3 许可被占用。
核心功能:
掩膜提取(mask):通过矢量边界(如城市 shp)裁剪栅格,适合按行政边界提取区域栅格;
属性提取(attribute):按栅格值筛选(如夜光数据 > 15 的像素),适合提取建成区、碳排放相关栅格。
参数说明:
RASTER_VALUE支持的条件:>15(大于 15)、<10(小于 10)、==1(等于 1)、>=5(大于等于 5),符合 ArcGIS 10.3 栅格计算器语法;
输入文件夹支持多格式栅格(tif/img/bil 等),无需手动筛选。

四、ArcGIS 10.3 运行步骤(快速落地)

修改参数:将代码中INPUT_RASTER_FOLDER、OUTPUT_FOLDER等路径替换为本地实际路径;
选择提取模式:注释 / 取消注释EXTRACT_TYPE,配置对应参数(mask 模式填矢量路径,attribute 模式填栅格值条件);
运行脚本:按之前教的 ArcGIS 10.3 运行方式(Python 窗口 / IDLE/CMD),以管理员身份执行;
查看结果:输出文件夹中会生成「原文件名_提取类型_extract.tif」格式的栅格,可直接在 ArcMap 中加载验证。

五、常见问题解决(ArcGIS 10.3 专属)

问题现象
解决方法
提示 “ExtractByMask_sa 不存在”
未授权 Spatial 扩展,手动在 ArcMap 中勾选「自定义→扩展模块→Spatial Analyst」
中文路径提取结果乱码
确保脚本开头编码声明正确,输出文件夹路径用英文,避免空格 / 特殊字符
批量提取卡死
关闭 ArcMap 中多余图层,设置arcpy.env.addOutputsToMap = False,清理临时文件夹
提示 “栅格格式不支持”
arcpy.ListRasters()替代手动遍历(代码已内置),避免识别非 ArcGIS 支持的栅格

最新文章

随机文章

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-03-27 18:24:17 HTTP/2.0 GET : https://f.mffb.com.cn/a/480156.html
  2. 运行时间 : 0.212726s [ 吞吐率:4.70req/s ] 内存消耗:4,513.66kb 文件加载:140
  3. 缓存信息 : 0 reads,0 writes
  4. 会话信息 : SESSION_ID=e7cfb2cdd7ded1d9aed57383f64579c2
  1. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/public/index.php ( 0.79 KB )
  2. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/autoload.php ( 0.17 KB )
  3. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/composer/autoload_real.php ( 2.49 KB )
  4. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/composer/platform_check.php ( 0.90 KB )
  5. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/composer/ClassLoader.php ( 14.03 KB )
  6. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/composer/autoload_static.php ( 4.90 KB )
  7. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  8. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
  9. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/helper.php ( 1.47 KB )
  10. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  11. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  12. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
  13. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/symfony/deprecation-contracts/function.php ( 0.99 KB )
  14. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
  15. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.78 KB )
  16. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/symfony/var-dumper/Resources/functions/dump.php ( 1.49 KB )
  17. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-dumper/src/helper.php ( 0.18 KB )
  18. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/symfony/var-dumper/VarDumper.php ( 4.30 KB )
  19. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/App.php ( 15.30 KB )
  20. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-container/src/Container.php ( 15.76 KB )
  21. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  22. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/provider.php ( 0.19 KB )
  23. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Http.php ( 6.04 KB )
  24. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  25. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
  26. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/common.php ( 0.03 KB )
  27. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/helper.php ( 18.78 KB )
  28. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Config.php ( 5.54 KB )
  29. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/app.php ( 0.95 KB )
  30. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/cache.php ( 0.78 KB )
  31. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/console.php ( 0.23 KB )
  32. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/cookie.php ( 0.56 KB )
  33. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/database.php ( 2.48 KB )
  34. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  35. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/filesystem.php ( 0.61 KB )
  36. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/lang.php ( 0.91 KB )
  37. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/log.php ( 1.35 KB )
  38. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/middleware.php ( 0.19 KB )
  39. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/route.php ( 1.89 KB )
  40. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/session.php ( 0.57 KB )
  41. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/trace.php ( 0.34 KB )
  42. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/config/view.php ( 0.82 KB )
  43. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/event.php ( 0.25 KB )
  44. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Event.php ( 7.67 KB )
  45. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/service.php ( 0.13 KB )
  46. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/AppService.php ( 0.26 KB )
  47. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  48. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  49. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  50. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  51. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  52. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/services.php ( 0.14 KB )
  53. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  54. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  55. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  56. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  57. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  58. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  59. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  60. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  61. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  62. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  63. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.21 KB )
  64. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.44 KB )
  65. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  66. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  67. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.29 KB )
  68. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  69. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  70. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  71. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  72. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  73. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  74. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  75. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  76. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  77. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  78. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  79. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/helper/Arr.php ( 16.63 KB )
  80. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.84 KB )
  81. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/cache/Driver.php ( 9.03 KB )
  82. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  83. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/Request.php ( 0.09 KB )
  84. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Request.php ( 55.78 KB )
  85. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/middleware.php ( 0.25 KB )
  86. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  87. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  88. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 1.94 KB )
  89. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
  90. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/session/driver/File.php ( 6.27 KB )
  91. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
  92. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/session/Store.php ( 7.12 KB )
  93. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  94. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/RuleName.php ( 5.75 KB )
  95. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  96. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.43 KB )
  97. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/Rule.php ( 26.95 KB )
  98. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  99. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/route/app.php ( 1.72 KB )
  100. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  101. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  102. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/route/Dispatch.php ( 10.44 KB )
  103. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/controller/Index.php ( 4.81 KB )
  104. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/app/BaseController.php ( 2.05 KB )
  105. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  106. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.44 KB )
  107. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/PDOConnection.php ( 52.47 KB )
  108. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  109. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  110. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  111. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/Builder.php ( 24.06 KB )
  112. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  113. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/Query.php ( 15.71 KB )
  114. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  115. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  116. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  117. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  118. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  119. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  120. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  121. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  122. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  123. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  124. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/log/driver/File.php ( 5.96 KB )
  125. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  126. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  127. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  128. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  129. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/facade/View.php ( 1.70 KB )
  130. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  131. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Response.php ( 8.81 KB )
  132. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/response/View.php ( 3.29 KB )
  133. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  134. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-view/src/Think.php ( 8.38 KB )
  135. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  136. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-template/src/Template.php ( 46.61 KB )
  137. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-template/src/template/driver/File.php ( 2.41 KB )
  138. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-template/src/template/contract/DriverInterface.php ( 0.86 KB )
  139. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/runtime/temp/067d451b9a0c665040f3f1bdd3293d68.php ( 11.98 KB )
  140. /yingpanguazai/ssd/ssd1/www/f.mffb.com.cn/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. CONNECT:[ UseTime:0.001237s ] mysql:host=127.0.0.1;port=3306;dbname=f_mffb;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001670s ]
  3. SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000697s ]
  4. SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000685s ]
  5. SHOW FULL COLUMNS FROM `set` [ RunTime:0.001363s ]
  6. SELECT * FROM `set` [ RunTime:0.000613s ]
  7. SHOW FULL COLUMNS FROM `article` [ RunTime:0.001501s ]
  8. SELECT * FROM `article` WHERE `id` = 480156 LIMIT 1 [ RunTime:0.005804s ]
  9. UPDATE `article` SET `lasttime` = 1774607057 WHERE `id` = 480156 [ RunTime:0.011559s ]
  10. SELECT * FROM `fenlei` WHERE `id` = 66 LIMIT 1 [ RunTime:0.000843s ]
  11. SELECT * FROM `article` WHERE `id` < 480156 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001154s ]
  12. SELECT * FROM `article` WHERE `id` > 480156 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001107s ]
  13. SELECT * FROM `article` WHERE `id` < 480156 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.004197s ]
  14. SELECT * FROM `article` WHERE `id` < 480156 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.004534s ]
  15. SELECT * FROM `article` WHERE `id` < 480156 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.013210s ]
0.216608s