当前位置:首页>学习笔记>#学习笔记 AI4S经验之1

#学习笔记 AI4S经验之1

  • 2026-01-13 01:38:16
#学习笔记 AI4S经验之1
对最近风很大的vibe coding(用自然语言通过与AI沟通实现编程)有点上头。这两天尝试了几个不同的工具,把自己的真实经验记录在这里。首先,我是一个只自学过初级Javascript(n年前试过做网页)的编程小白,而且对不同AI工具的认识也比较浅薄,所以可以说是从头开始。
我想完成的第一个项目是一个日常科研工作。每周我都会从patentscope收到订阅的rss,一般是推送到邮箱。我大概会花1小时阅读推送的内容,通常有50条左右,包括题目,摘要。然后再花1小时左右把内容提炼成一张表格,列出每个专利的核心内容,比如:靶点,抗体形式,专利申请方以及超链接。我想尝试一下是否可以用程序或者AI帮我自动完成这个任务。
我想到的第一个工具是python,于是立即打开deepseek开始请教如何安装python编程需要的工具,例如编译器,写代码工具等等。这个过程还是比较顺利的。我装上了python编译器以及vs code和pycharm。然后我就直接让deepseek给出上面提到的任务,但是deepseek的答案是有严重问题的。首先我不知道需要预先下载哪些库,其次代码运行后出现的bug也很难修正。然后我就试着换了kimi,qwen。体验最好的没想到是我以前完全不了解的qwen。这次qwen的max模式一步步指导我安装了所需要的库,并且一次性给出了完整且可以实施的python程序!
在qwen的大力指导下,我终于可以实现从rss feed抓取推送,并将内容汇总到一张表格。但是这时候里面的一些关键内容还没有经过提炼,我自然就想到是不是可以用AI来帮助分析表格,并提炼内容。Qwen又指导我如何在程序里调用AI的API,我一时没搞懂怎么用qwen自己的API,转而试用了kimi和deepseek。最后试用下来似乎kimi的K2模型给出的结果更符合我的要求,缺点就是有点慢。我也试过k2-turbo,但是价格就有点贵了。不过好在我每次消耗的token非常少,估计充的100块钱可以用大半年。Kimi K2帮助分析了每篇专利的摘要(全文没法通过rss feed拿到,需要别的方法),然后把我需要的信息总结在了一个新的mark down表格。
最后我需要把这个整理好的表格通过邮件分享给我的同事,我就继续用qwen指导我如何把AI生成的总结表转换为html格式,这一步非常顺利,AI甚至还添油加醋地加上了颜色,高亮等等。。。我后来发现可以在提示词里把temperature调低到0.2,这样AI就老实多了,基本属于有什么答什么。
整个过程我大概花了2-3天的空闲时间,加一起估计6个小时左右。最后实现的程序每次只需要1-2分钟就能够完成原先我2-3小时才能做完的工作,而且准确度也比我自己手搓高很多。文章末尾附上代码。
# -*- coding: utf-8 -*-
import feedparser
from datetime import datetime, timedelta, timezone
import time
import csv
import os
import sys
import markdown
from openai import OpenAI
import pandas as pd
from dotenv import load_dotenv


def get_recent_entries(feed_url, days=7):
"""
获取最近N天的RSS推送(使用UTC时间,避免时区问题)    """
feed = feedparser.parse(feed_url)
if feed.bozo:
print(f"⚠️ 解析警告{feed.bozo_exception}")

使用 UTC 时间计算截止时间
cutoff_date = datetime.now(timezone.utc) - timedelta(days=days)
    recent_entries = []

for entry in feed.entries:
优先使用 published_parsed,其次 updated_parsed
pub_time = entry.get('published_parsed'or entry.get('updated_parsed')
if not pub_time:
continue  跳过无时间信息的条目
try:
 struct_time 转为 UTC datetime
pub_date = datetime(*pub_time[:6], tzinfo=timezone.utc)
except (ValueErrorTypeError):
continue  解析失败则跳过
if pub_date >= cutoff_date:
            recent_entries.append({
'title': entry.get('title''无标题'),
'link': entry.get('link'''),
'published': entry.get('published'''),
'summary': entry.get('summary''无摘要'),
'pub_date': pub_date,
'author': entry.get('author'''),
            })

return recent_entries


def export_to_csv(articles, filename=None):
"""
将文章列表导出为CSV文件    """
if not filename:
        filename = f"rss_{datetime.now().strftime('%Y-%m-%d_%H-%M-%S')}.csv"
fieldnames = ['标题''链接''作者''发布时间''摘要']

with open(filename, 'w'newline=''encoding='utf-8-sig'as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
        writer.writeheader()
for article in articles:
            writer.writerow({
'标题': article['title'],
'链接': article['link'],
'作者': article['author'],
'发布时间': article['pub_date'].strftime('%Y-%m-%d %H:%M:%S'),
'摘要': article['summary']
            })

print(f"✅ 成功导出 {len(articles)篇文章到 {filename}")
return filename


def analyze_csv_with_ai(csv_file, client, model_name):
"""使用AI模型分析RSS导出的CSV文件"""
df = pd.read_csv(csv_file, encoding='utf-8-sig')
限制输入长度(可选)
articles_sample = df.head(100)
    analysis_text = ""
for _, row in articles_sample.iterrows():
        analysis_text += f"标题{row['标题']}\n作者{row['作者']}\n链接{row['链接']}\n摘要{row['摘要']}\n\n"
prompt = f"""请分析以下RSS文章内容,并生成一个结构化的总结表格:
{analysis_text}
请提供:
1. 每个专利主要相关的靶点名称
2. 专利的作者
3. 专利描述的分子形式,例如:单克隆抗体,双特异性抗体,抗体药物偶联物,T细胞衔接器,等等
4. 每个专利的链接
5. 输出语言为英语
Markdown表格格式输出,并在表格第一列加入计数列。"""
response = client.chat.completions.create(
model=model_name,
messages=[
            {"role""system""content""你是一个专业的数据分析师,擅长从RSS订阅数据中提取洞察。"},
            {"role""user""content": prompt}
        ],
temperature=0.2,
max_tokens=50000
)
return response.choices[0].message.content


def md_to_html(md_path, html_path=None):
""" Markdown 转为自包含 HTML 文件"""
if not html_path:
        html_path = os.path.splitext(md_path)[0] + ".html"
with open(md_path, 'r'encoding='utf-8'as f:
        md_text = f.read()

    html_body = markdown.markdown(md_text, extensions=['tables'])

    full_html = f"""
    <!DOCTYPE html>
    <html>
    <head>
        <meta charset="utf-8">
        <title>WIPO 专利分析报告</title>
        <style>
            body {{ max-width: 1200px; margin: 40px auto; padding: 0 20px; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", sans-serif; }}
            table {{ width: 100%; border-collapse: collapse; margin: 20px 0; }}
            th, td {{ border: 1px solid 
#ddd; padding: 10px; text-align: left; vertical-align: top; }}
            th {{ background-color: #f8f9fa}}
            a {{ color: #0d6efd; text-decoration: none; }}
            a:hover {{ text-decoration: underline; }}
        </style>
    </head>
    <body>
{html_body}
    </body>
    </html>
    """
with open(html_path, 'w'encoding='utf-8'as f:
        f.write(full_html)

print(f" HTML 报告已生成{os.path.abspath(html_path)}")
return html_path


# =============== 主程序入口(仅此一处)===============
if __name__ == "__main__":
    url = "填入你自己的rss feed"
print("🔍 正在抓取最近7天的专利文章(RSS源)...")
    recent_articles = get_recent_entries(url, days=7)

print(f"✅ 找到 {len(recent_articles)篇最近7天的文章\n")

预览前5篇(可选)
for idx, article in enumerate(recent_articles[:5], 1):
print(f"{idx}{article['title']}")
print(f"   作者{article['author']}")
print(f"   发布时间{article['pub_date'].strftime('%Y-%m-%d %H:%M:%S %Z')}")
print(f"   摘要{article['summary'][:100]}...")
print(f"   链接{article['link']}\n")
if len(recent_articles) > 5:
print(f"... 共 {len(recent_articles)篇,仅显示前5篇预览\n")

导出 CSV(仅一次)
csv_filename = export_to_csv(recent_articles)

配置 AI 客户端
load_dotenv()
    api_key = os.getenv("KIMI_API_KEY")
if not api_key:
print("❌ 错误未设置 KIMI_API_KEY 环境变量")
        sys.exit(1)

    client = OpenAI(
api_key=api_key,
base_url="https://api.moonshot.cn/v1"
)
    MODEL_NAME = "kimi-k2-thinking-turbo"
验证 CSV 文件
if not os.path.exists(csv_filename):
print(f"❌ 文件不存在{os.path.abspath(csv_filename)}")
        sys.exit(1)

    df_test = pd.read_csv(csv_filename, encoding='utf-8-sig')
print(f" CSV读取成功,共 {len(df_test)")

调用 AI 分析
print("🤖 正在调用AI进行分析,请稍候...")
try:
        analysis_report = analyze_csv_with_ai(csv_filename, client, MODEL_NAME)

if not analysis_report or len(analysis_report.strip()) < 50:
print("⚠️ 警告:AI返回内容过短或为空")
print(f"返回内容预览{repr(analysis_report[:100])}")
            analysis_report = analysis_report or "AI未返回有效内容)"
写入 Markdown 报告
report_path = os.path.abspath('ai_analysis_report.md')
with open(report_path, 'w'encoding='utf-8'as f:
            f.write(analysis_report)

#定义 md_file
md_file = "ai_analysis_report.md"
with open(md_file, 'w'encoding='utf-8'as f:
            f.write(analysis_report)
print(f" Markdown 报告已保存{os.path.abspath(md_file)}")

✅ 调用 HTML 转换(md_file 已定义)
md_to_html(md_file)
print(f" AI分析报告已生成{report_path}")
print(f"   文件大小{os.path.getsize(report_path)字节")

except Exception as e:
print(f" AI分析过程中出错{e}")
import traceback
        traceback.print_exc()

最新文章

随机文章

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