当前位置:首页>python>一天一个Python知识点——Day 163:文本预处理实战

一天一个Python知识点——Day 163:文本预处理实战

  • 2026-03-20 14:46:27
一天一个Python知识点——Day 163:文本预处理实战

一、开篇:为什么80%的时间都在洗数据?

“在真实世界的NLP项目中,80%的时间花在数据清洗上,剩下的20%才是建模和调参。”

这是每一个NLP从业者的血泪教训。

昨天你用spaCy完成了流畅的文本分析,但那是在干净的英文例句上。如果你面对的是这样的数据:

"RT @user: This is SOOOO exciting!!! Can't wait for the #event 😍😍😍 http://t.co/xyz"
或者这样的数据:
"这家店的东西质量很好!!!服务态度也超赞的~~但是价格有点小贵……下次还会来💯"

你会发现,模型根本无法直接处理

今天的目标:掌握一套完整的文本预处理流水线,让任何原始文本都能变成模型可以理解的结构化数据。

二、文本预处理的核心目标

目标
说明
去噪
移除与任务无关的噪声(HTML标签、URL、特殊符号)
统一化
将不同形式的相同语义归一化(大小写、简繁、数字)
分词
将文本切成模型能处理的最小单元
降维
移除无信息量的词(停用词),减少特征空间
还原
将单词变体还原为原形,减少词汇表大小

三、预处理步骤详解(附代码)

3.1 数据清洗——铲除噪音

任务:移除HTML标签、URL、@提及、特殊符号、多余空白。

import redef clean_text(text):    """基础清洗函数"""    # 移除HTML标签    text = re.sub(r'<[^>]+>''', text)    # 移除URL    text = re.sub(r'http[s]?://(?:[a-zA-Z]|[0-9]|[$-_@.&+])+''', text)    # 移除@提及    text = re.sub(r'@\w+''', text)    # 移除特殊符号(保留字母、数字、中文、基本标点)    text = re.sub(r'[^\w\s\u4e00-\u9fff。,!?、]''', text)    # 合并多余空白    text = re.sub(r'\s+'' ', text).strip()    return text# 示例dirty_text = "<p>RT @user: This is SOOOO exciting!!! Can't wait for the #event 😍😍😍 http://t.co/xyz</p>"clean = clean_text(dirty_text)print("清洗后:", clean)# 输出:RT This is SOOOO exciting Cant wait for the event

3.2 统一化——把“苹果”和“Apple”归一

任务:统一大小写、处理表情符号、数字占位符。

def normalize_text(text):    """文本统一化"""    # 转为小写(英文)    text = text.lower()    # 将数字替换为占位符    text = re.sub(r'\d+''<NUM>', text)    # 将连续重复字母缩减(如 soooo → so)    text = re.sub(r'(.)\1{2,}'r'\1', text)    return text# 示例text = "This is SOOOO AMAZING!!! 12345"norm = normalize_text(text)print("统一后:", norm)# 输出:this is so amazing!!! <NUM>

3.3 分词——切出最小语义单元

任务:将文本切分为单词、标点等。中文分词需要专用工具。

import jiebaimport spacyfrom nltk.tokenize import word_tokenize# 英文分词(spaCy)nlp_en = spacy.load("en_core_web_sm")def tokenize_english(text):    doc = nlp_en(text)    return [token.text for token in doc]# 中文分词(jieba)def tokenize_chinese(text):    return list(jieba.cut(text))# 示例en_text = "I can't believe it!"ch_text = "我不相信这是真的!"print("英文分词:", tokenize_english(en_text))print("中文分词:", tokenize_chinese(ch_text))

3.4 去除停用词——删除无意义的词

任务:移除“的”、“是”、“a”、“the”等高频但对分析无用的词。

from nltk.corpus import stopwords# 下载停用词(若未下载)# nltk.download('stopwords')stop_words_en = set(stopwords.words('english'))stop_words_zh = set(["的""了""在""是""我""你""他""她""它"])  # 示例def remove_stopwords(tokens, lang='en'):    if lang == 'en':        return [t for t in tokens if t.lower() not in stop_words_en]    elif lang == 'zh':        return [t for t in tokens if t not in stop_words_zh]    return tokens# 示例tokens = ['I''love''natural''language''processing']filtered = remove_stopwords(tokens, 'en')print("去除停用词后:", filtered)# 输出:['love', 'natural', 'language', 'processing']

3.5 词干提取 vs 词形还原——让词归一

任务:将单词的不同形式归并。

  • 词干提取:粗暴砍掉后缀(running → run,但可能不是单词)

  • 词形还原:根据词典还原(running → run,肯定是单词)

from nltk.stem import PorterStemmer, WordNetLemmatizerstemmer = PorterStemmer()lemmatizer = WordNetLemmatizer()words = ['running''runs''better''geese']print("词干提取:", [stemmer.stem(w) for w in words])print("词形还原:", [lemmatizer.lemmatize(w, pos='v'for w in words])# 输出:# 词干提取: ['run''run''better''gees']# 词形还原: ['run''run''better''geese']

四、构建一个完整的预处理流水线

将以上步骤封装成一个可复用的流水线。

import reimport jiebaimport spacyfrom nltk.corpus import stopwordsfrom nltk.stem import WordNetLemmatizerclass TextPreprocessor:    """文本预处理流水线"""    def __init__(self, lang='en', use_lemmatization=True):        self.lang = lang        self.use_lemmatization = use_lemmatization        if lang == 'en':            self.nlp = spacy.load("en_core_web_sm", disable=["parser""ner"])            self.stopwords = set(stopwords.words('english'))            if use_lemmatization:                self.lemmatizer = WordNetLemmatizer()        elif lang == 'zh':            # 中文无需spaCy,用jieba            self.stopwords = set(["的""了""在""是""我""你""他""她""它""我们""你们""他们"])            # 可加载更大的中文停用词表        else:            raise ValueError("lang must be 'en' or 'zh'")    def clean(self, text):        """清洗"""        # 移除HTML        text = re.sub(r'<[^>]+>''', text)        # 移除URL        text = re.sub(r'http[s]?://\S+''', text)        # 移除@提及        text = re.sub(r'@\w+''', text)        # 保留基本字符        if self.lang == 'en':            text = re.sub(r'[^a-zA-Z\s\.\,\!\?]''', text)        else:            text = re.sub(r'[^\w\s\u4e00-\u9fff。,!?、]''', text)        # 合并空格        text = re.sub(r'\s+'' ', text).strip()        return text    def tokenize(self, text):        """分词"""        if self.lang == 'en':            doc = self.nlp(text)            return [token.text for token in doc]        else:            return list(jieba.cut(text))    def normalize_token(self, token):        """对单个token归一化"""        # 转为小写(英文)        if self.lang == 'en':            token = token.lower()        # 词形还原        if self.lang == 'en' and self.use_lemmatization:            token = self.lemmatizer.lemmatize(token)        return token    def process(self, text):        """完整流水线"""        # 清洗        text = self.clean(text)        # 分词        tokens = self.tokenize(text)        # 去除停用词、归一化        processed = []        for token in tokens:            norm = self.normalize_token(token)            if norm not in self.stopwords and len(norm) > 1:  # 过滤单字符                processed.append(norm)        return processed# 测试英文prep_en = TextPreprocessor(lang='en')text_en = "<p>I absolutely LOVED the movie!!! It was soooo amazing 😍 http://example.com</p>"result_en = prep_en.process(text_en)print("英文预处理结果:", result_en)# 测试中文prep_zh = TextPreprocessor(lang='zh')text_zh = "<p>这家店的奶茶真的超级好喝!!!服务态度也超赞的~~下次还会来💯</p>"result_zh = prep_zh.process(text_zh)print("中文预处理结果:", result_zh)

五、实战案例:社交媒体评论情感分析预处理

场景:对Twitter评论进行预处理,为情感分析准备数据。

def preprocess_tweet(tweet):    """针对Twitter的专用预处理"""    # 移除RT(转发标记)    tweet = re.sub(r'^RT ''', tweet)    # 移除话题标签的#号,但保留文字    tweet = re.sub(r'#(\w+)'r'\1', tweet)    # 统一表情符号    tweet = tweet.replace('😍'' heart_eyes ').replace('😂'' laughing ')    # 调用通用预处理    return prep_en.process(tweet)tweets = [    "RT @user: I can't believe how good this movie is!!! #awesome",    "Worst service ever 😤😤😤 @company",    "Just bought the new iPhone. Loving it! 😍😍😍"]for tweet in tweets:    processed = preprocess_tweet(tweet)    print(f"原始: {tweet}")    print(f"处理后: {processed}\n")

输出

原始: RT @user: I can't believe how good this movie is!!! #awesome处理后: ['believe', 'good', 'movie', 'awesome']原始: Worst service ever 😤😤😤 @company处理后: ['worst', 'service', 'ever']原始: Just bought the new iPhone. Loving it! 😍😍😍处理后: ['bought', 'new', 'iphone', 'loving', 'heart_eyes']

六、预处理前后的效果对比

原始文本

"I absolutely LOVED the movie!!! It was soooo amazing 😍😍😍 #mustwatch"

经过清洗+分词+停用词+词形还原

['absolutely''love''movie''amazing''mustwatch']

差异

  • 大小写统一

  • 重复字母缩减(soooo → so,进一步被停用词移除?实际上“so”是停用词?需要调整)

  • 表情符号转为文字

  • 词形还原(loved → love)

对模型的影响

  • 词汇表大小从 8 降到 5

  • 无用信息(it, was, the)被移除

  • 核心情感词保留

七、结语:干净的数据是模型的上限

“垃圾进,垃圾出” —— 在NLP领域,这句话尤其真实。

今天你掌握了从原始文本到干净语料的完整流程,学会了:

  • 清洗噪音(HTML、URL、特殊符号)

  • 统一化和标准化

  • 分词与停用词过滤

  • 词干提取与词形还原

  • 构建可复用的预处理流水线

这些技能将是你所有NLP项目的共同起点——无论你是做情感分析、主题建模还是问答系统,预处理都是绕不开的第一步。

最新文章

随机文章

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-03-27 12:58:02 HTTP/2.0 GET : https://f.mffb.com.cn/a/479646.html
  2. 运行时间 : 0.217930s [ 吞吐率:4.59req/s ] 内存消耗:4,607.23kb 文件加载:140
  3. 缓存信息 : 0 reads,0 writes
  4. 会话信息 : SESSION_ID=35c9d2690588bce9a6303c64e303a690
  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.000462s ] mysql:host=127.0.0.1;port=3306;dbname=f_mffb;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000594s ]
  3. SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000295s ]
  4. SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000315s ]
  5. SHOW FULL COLUMNS FROM `set` [ RunTime:0.000546s ]
  6. SELECT * FROM `set` [ RunTime:0.000289s ]
  7. SHOW FULL COLUMNS FROM `article` [ RunTime:0.000516s ]
  8. SELECT * FROM `article` WHERE `id` = 479646 LIMIT 1 [ RunTime:0.001255s ]
  9. UPDATE `article` SET `lasttime` = 1774587482 WHERE `id` = 479646 [ RunTime:0.002353s ]
  10. SELECT * FROM `fenlei` WHERE `id` = 66 LIMIT 1 [ RunTime:0.000328s ]
  11. SELECT * FROM `article` WHERE `id` < 479646 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006271s ]
  12. SELECT * FROM `article` WHERE `id` > 479646 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011650s ]
  13. SELECT * FROM `article` WHERE `id` < 479646 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.012120s ]
  14. SELECT * FROM `article` WHERE `id` < 479646 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.013630s ]
  15. SELECT * FROM `article` WHERE `id` < 479646 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.007194s ]
0.220435s