当前位置:首页>Linux>Bulk RNA-Seq Linux上游分析 + R语言下游分析完整流程

Bulk RNA-Seq Linux上游分析 + R语言下游分析完整流程

  • 2026-07-01 17:08:56
Bulk RNA-Seq Linux上游分析 + R语言下游分析完整流程
一、分析流程概览
一文打通从 SRA 原始数据到差异表达及功能富集的全流程,具体概括如下:

SRA下载(prefetch) → 格式转换(fasterq-dump) → 质控(fastqc multiqc) → 去接头/低质量(trim_galore) → 基因组比对(hisat2) → BAM处理(samtools) → 定量计数(featureCounts) → 差异分析(limma) → 可视化(ggplot2) → 功能富集(clusterProfiler)

二、Linux上游分析
2.1 环境准备与目录构建
# 下载 Miniconda 安装脚本wget https://repo.anaconda.com/miniconda/Miniconda3-latest-Linux-x86_64.sh# 执行安装(按提示操作,建议安装到 ~/miniconda3)bash Miniconda3-latest-Linux-x86_64.sh# 初始化 shell(安装后重启终端或执行)source ~/.bashrc# 验证安装conda --version# 创建新环境(指定 Python 3.10,兼容性较好)conda create -n rna python=3.10 -y# 激活环境conda activate rna# 配置国内镜像(加速下载)conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/free/conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/main/conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/cloud/conda-forge/conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/cloud/bioconda/conda config --set show_channel_urls yes# 安装 SRA 工具包(下载 SRA 数据)conda install -c bioconda sra-tools -y# 安装 FastQC(质控)conda install -c bioconda fastqc -y# 安装 MultiQC(质控报告汇总)conda install -c bioconda multiqc -y# 安装 Trim Galore(去接头和低质量,会自动安装 cutadapt 和 fastqc)conda install -c bioconda trim-galore -y# 安装 Hisat2(比对)conda install -c bioconda hisat2 -y# 安装 Samtools(BAM 处理)conda install -c bioconda samtools -y# 安装 Subread(包含 featureCounts)conda install -c bioconda subread -y# 安装 pigz(多线程压缩,可选但推荐)conda install -c conda-forge pigz -y# 安装 parallel(并行处理,可选)conda install -c conda-forge parallel -y# 检查所有工具版本fastqc --versionmultiqc --versiontrim_galore --versionhisat2 --versionsamtools --versionfeatureCounts -vfasterq-dump --version# 激活 conda 环境(需提前安装好所需软件)conda activate rna# 设置项目名并创建目录结构projectName='GSE50177'mkdir -p ${projectName}/{sra,fastq,reports,clean,aligned,reference}cd ${projectName}
2.2 SRA数据下载
cd sra# 从 NCBI SRA Run Selector 下载 SRR_Acc_List.txt# 链接:https://www.ncbi.nlm.nih.gov/Traces/study/?acc=PRJNA217298# 批量下载(单线程,稳定但慢)cat SRR_Acc_List.txt | while read iddo    prefetch ${id}done# 整理文件:将分散在子文件夹的 .sra 文件移出cat SRR_Acc_List.txt | while read iddo    mv -f ${id}/${id}.sra ./    rm -rf ${id}done
2.3 SRA转FASTQ
cd ../fastq# 双端数据拆分(--split-3 会自动识别单端/双端)for sra_file in ../sra/*.sra; do    fasterq-dump --split-3 ${sra_file} -O ./done# 压缩节省空间(可选)pigz -p 4 *.fastq
2.4 质控与报告
# FastQC 单样本质控ls *.fastq.gz | xargs fastqc -t 4 -O ../reports/# MultiQC 汇总报告cd ../reportsmultiqc ./ -o ./# 查看 multiqc_report.html,重点关注:# - Per base sequence quality(Q30 > 80%)# - Adapter Content(是否有接头残留)
2.5 数据清洗(去接头 + 低质量碱基)
# 双端数据处理cd ../clean# 生成配置文件(两列:R1路径 R2路径)ls ../fastq/*_R1_*.fastq.gz > r1.txtls ../fastq/*_R2_*.fastq.gz > r2.txtpaste r1.txt r2.txt > config.txt# 批量运行 trim_galorecat config.txt | while read r1 r2; do    trim_galore \        -q 25 \              # Phred quality cutoff        --phred33 \          # 质量值编码格式        --length 36 \        # 丢弃短于36bp的reads        --stringency 3 \     # 接头匹配严格度        --paired \           # 双端模式        --cores 4 \          # 线程数(trim_galore v0.6.0+)        -o ./ \        ${r1} ${r2}done
# 单端数据处理ls ../fastq/*.fastq.gz | while read fq; do    trim_galore -q 25 --phred33 --length 36 -o ./ ${fq}done
2.6 基因组比对
cd ../reference# 人类基因组 GRCh38 + GENCODE v46wget https://ftp.ebi.ac.uk/pub/databases/gencode/Gencode_human/release_46/GRCh38.p14.genome.fa.gzgunzip GRCh38.p14.genome.fa.gzwget https://ftp.ebi.ac.uk/pub/databases/gencode/Gencode_human/release_46/gencode.v46.annotation.gtf.gzgunzip gencode.v46.annotation.gtf.gz# 构建 Hisat2 索引(约30分钟,4线程)hisat2-build -p 4 GRCh38.p14.genome.fa GRCh38_index
cd ../clean# 双端比对ls *_val_1.fq.gz | sed 's/_val_1.fq.gz//' | while read prefix; do    hisat2 -p 10 \        -x ../reference/GRCh38_index \        -1 ${prefix}_val_1.fq.gz \        -2 ${prefix}_val_2.fq.gz \        -S ../aligned/${prefix}.sam \        2> ../aligned/${prefix}.align.logdone
2.7 SAM转BAM并建立索引
cd ../aligned# 排序并转BAM(按坐标排序,去除SAM节省空间)ls *.sam | while read sam; do    base=$(basename ${sam} .sam)    samtools sort -O bam -@ 5 -o ${base}.bam ${sam}    rm ${sam}  # 删除SAM释放空间done# 建立索引(IGV等可视化工具需要)ls *.bam | xargs -P 4 -i samtools index {}# 比对统计ls *.bam | while read bam; do    samtools flagstat -@ 2 ${bam} > $(basename ${bam} .bam).flagstatdone# 检查比对率:Unique mapped reads > 70% 为合格grep "mapped (" *.flagstat | head
2.8 基因水平定量
# 使用 featureCounts 计算 reads 数gtf="../reference/gencode.v46.annotation.gtf"nohup featureCounts \    -T 5 \              # 线程数    -p \                # 双端模式(单端去掉)    -t exon \           # 特征类型    -g gene_id \        # 分组依据    -a ${gtf} \    -o all.id.txt \    *.bam \    1>counts.log 2>&1 &# 输出文件说明:# all.id.txt        # 主结果(含注释信息和计数矩阵)# all.id.txt.summary # 汇总统计
三、R语言下游分析
3.1 环境配置与包安装
# 设置国内镜像加速下载options(repos = c(CRAN = "https://mirrors.tuna.tsinghua.edu.cn/CRAN/"))options(Bioc_mirror = "https://mirrors.ustc.edu.cn/bioc/")# 安装 BiocManager(Bioconductor 官方安装器)if (!require("BiocManager", quietly = TRUE))    install.packages("BiocManager")# 定义所需包列表biocPackages <- c(  "GEOquery""limma",           # 数据获取与差异分析  "ggplot2""pheatmap",         # 可视化  "clusterProfiler""org.Hs.eg.db""enrichplot",  # 富集分析  "FactoMineR""factoextra"     # PCA分析)# 批量安装(跳过已安装的包)BiocManager::install(biocPackages, ask = FALSE, update = FALSE)
3.2 数据预处理
rm(list = ls())options(stringsAsFactors = FALSE)# 读取 featureCounts 输出(跳过前1行注释)gset <- read.table("all.id.txt", header = TRUE, skip = 1)# 提取 counts 矩阵(第7列后为样本数据,根据实际列数调整)counts_cols <- grep(".bam$"colnames(gset))gene.datExpr <- log2(gset[, counts_cols] + 1)# ENSEMBL ID 去版本号(如 ENSG00000139629.15 → ENSG00000139629)library(stringr)gene.datExpr$ENSEMBL <- str_split_fixed(gset$Geneid"\\."2)[, 1]# 过滤低表达基因(中位数 > 0)gene.datExpr$median <- apply(gene.datExpr[, 1:(ncol(gene.datExpr)-1)], 1, median)gene.datExpr <- gene.datExpr[gene.datExpr$median 0, ]# 去重复:保留每个 ENSEMBL ID 中表达量最高的记录gene.datExpr <- gene.datExpr[order(gene.datExpr$ENSEMBL                                    gene.datExpr$median                                    decreasing = TRUE), ]gene.datExpr <- gene.datExpr[!duplicated(gene.datExpr$ENSEMBL), ]# 设置行名并清理rownames(gene.datExpr) <- gene.datExpr$ENSEMBLgene.datExpr <- gene.datExpr[, 1:(ncol(gene.datExpr)-2)]  # 去除辅助列# 定义分组(根据实际实验设计修改)group_list <- c("control""control""siSUZ""siSUZ")save(gene.datExpr, group_list, file = "ready.data.Rdata")
3.3 样本聚类与PCA质控
load("ready.data.Rdata")dir.create("export", showWarnings = FALSE)# 层次聚类library(stringr)colnames(gene.datExpr) <- paste(group_list,                                  str_split_fixed(colnames(gene.datExpr), "\\."3)[, 1],                                  sep = "_")hc <- hclust(dist(t(gene.datExpr)))pdf("export/hclust.pdf", width = 8, height = 6)plot(as.dendrogram(hc), horiz = TRUE)dev.off()# PCA 分析library(FactoMineR)library(factoextra)dat.pca <- PCA(t(gene.datExpr), graph = FALSE)pdf("export/sample_PCA.pdf", width = 8, height = 6)fviz_pca_ind(dat.pca,             geom.ind = "point",             col.ind = group_list,             addEllipses = TRUE,             legend.title = "Groups")dev.off()
3.4 差异表达分析(limma)
library(limma)# 构建设计矩阵(无截距模型)design <- model.matrix(~ 0 + factor(group_list))colnames(design) <- levels(factor(group_list))rownames(design) <- colnames(gene.datExpr)# 构建对比矩阵contrast.matrix <- makeContrasts(siSUZ - control, levels = design)# 线性模型拟合fit <- lmFit(gene.datExpr, design)fit2 <- contrasts.fit(fit, contrast.matrix)fit2 <- eBayes(fit2)# 提取结果nrDEG <- topTable(fit2, coef = 1, number = Inf, sort.by = "P")head(nrDEG)# 保存结果save(nrDEG, file = "data/nrDEG.Rdata")write.table(nrDEG, file = "data/nrDEG.txt", sep = "\t", quote = FALSE)
3.5 可视化
# 火山图library(ggplot2)# 设定阈值(教学建议固定 |logFC| > 1,而非动态计算)logFC_cutoff <- 1pval_cutoff <- 0.05nrDEG$change <- ifelse(  nrDEG$P.Value < pval_cutoff & abs(nrDEG$logFC) > logFC_cutoff,  ifelse(nrDEG$logFC > logFC_cutoff, "UP""DOWN"),  "NOT")# 统计差异基因数table(nrDEG$change)this_title <- paste0(  "Cutoff: |log2FC| > ", logFC_cutoff, ", P < ", pval_cutoff,  "\nUP: "sum(nrDEG$change == "UP"),  " | DOWN: "sum(nrDEG$change == "DOWN"))ggplot(nrDEG, aes(x = logFC, y = -log10(P.Value), color = change)) +  geom_point(alpha = 0.4, size = 1.5) +  theme_bw() +  scale_color_manual(values = c("DOWN" = "#2E86AB"                                 "NOT" = "grey50"                                 "UP" = "#F24236")) +  labs(x = "log2 Fold Change"       y = "-log10 P-value",       title = this_title) +  theme(plot.title = element_text(hjust = 0.5))ggsave("export/volcano.pdf", width = 8, height = 7)
# 热图library(pheatmap)# 筛选差异基因deg_genes <- rownames(nrDEG[nrDEG$change %in% c("UP""DOWN"), ])choose_matrix <- gene.datExpr[deg_genes, ]# Z-score 标准化并截断极值mat_scaled <- t(scale(t(choose_matrix)))mat_scaled[mat_scaled > 2] <- 2mat_scaled[mat_scaled < -2] <- -2# 样本注释annotation_col <- data.frame(Group = group_list)rownames(annotation_col) <- colnames(gene.datExpr)# 绘制热图pheatmap(mat_scaled,         annotation_col = annotation_col,         cluster_cols = TRUE,         show_rownames = FALSE,         show_colnames = FALSE,         color = colorRampPalette(c("#2166AC""white""#B2182B"))(100),         filename = "export/heatmap_DEGs.pdf",         width = 8, height = 10)
3.6 功能富集分析
library(clusterProfiler)library(org.Hs.eg.db)# ID 转换:ENSEMBL → SYMBOL → ENTREZIDdf <- bitr(rownames(nrDEG),            fromType = "ENSEMBL",           toType = c("SYMBOL""ENTREZID"),            OrgDb = org.Hs.eg.db)nrDEG$ENSEMBL <- rownames(nrDEG)nrDEG <- merge(nrDEG, df, by = "ENSEMBL", all.x = TRUE)# 提取上下调基因(过滤NA)gene_up <- na.omit(nrDEG[nrDEG$change == "UP""ENTREZID"])gene_down <- na.omit(nrDEG[nrDEG$change == "DOWN""ENTREZID"])# GO 富集分析(上调基因示例)if (length(gene_up) >= 10) {  ego_up <- enrichGO(    gene = gene_up,    OrgDb = org.Hs.eg.db,    ont = "ALL",           # BP/MF/CC 三合一    pAdjustMethod = "BH",    pvalueCutoff = 0.05,    qvalueCutoff = 0.2,    readable = TRUE  )  # 条形图  pdf("export/GO_UP_barplot.pdf", width = 10, height = 8)  print(barplot(ego_up, split = "ONTOLOGY") +           facet_grid(ONTOLOGY ~ ., scales = "free"))  dev.off()}# KEGG 富集(需联网)if (length(gene_up) >= 10) {  kk_up <- enrichKEGG(    gene = gene_up,    organism = "hsa",      # hsa = human    pvalueCutoff = 0.05  )  dotplot(kk_up)  ggsave("export/KEGG_UP_dotplot.pdf")}

最新文章

随机文章

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-07-04 09:37:30 HTTP/2.0 GET : https://f.mffb.com.cn/a/488727.html
  2. 运行时间 : 0.253629s [ 吞吐率:3.94req/s ] 内存消耗:4,948.55kb 文件加载:140
  3. 缓存信息 : 0 reads,0 writes
  4. 会话信息 : SESSION_ID=cd3c28248311b33f283767cecc6251fb
  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.001046s ] mysql:host=127.0.0.1;port=3306;dbname=f_mffb;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001437s ]
  3. SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000730s ]
  4. SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000693s ]
  5. SHOW FULL COLUMNS FROM `set` [ RunTime:0.001302s ]
  6. SELECT * FROM `set` [ RunTime:0.000598s ]
  7. SHOW FULL COLUMNS FROM `article` [ RunTime:0.001528s ]
  8. SELECT * FROM `article` WHERE `id` = 488727 LIMIT 1 [ RunTime:0.002080s ]
  9. UPDATE `article` SET `lasttime` = 1783129050 WHERE `id` = 488727 [ RunTime:0.001767s ]
  10. SELECT * FROM `fenlei` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000581s ]
  11. SELECT * FROM `article` WHERE `id` < 488727 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001134s ]
  12. SELECT * FROM `article` WHERE `id` > 488727 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002373s ]
  13. SELECT * FROM `article` WHERE `id` < 488727 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.002487s ]
  14. SELECT * FROM `article` WHERE `id` < 488727 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.017470s ]
  15. SELECT * FROM `article` WHERE `id` < 488727 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.038964s ]
0.257691s