当前位置:首页>python>Python实现拖拽式可视化爬虫

Python实现拖拽式可视化爬虫

  • 2026-01-31 06:08:56
Python实现拖拽式可视化爬虫

tkinter 实现一个拖拽式的可视化爬虫工具,核心功能是:左侧用 Listbox 展示可拖拽排序的采集步骤,右侧用 Text 控件实时生成对应的 Scrapy 爬虫代码,并且要演示 tkinter 的拖放 API 和代码自动生成逻辑。

下面我为你实现一个完整、可运行的拖拽式可视化爬虫工具,包含步骤拖拽排序、代码实时生成、基础的 Scrapy 代码模板等核心功能:

完整实现代码

import tkinter as tk
from tkinter import ttk, messagebox

classDragDropListbox(tk.Listbox):
"""支持拖拽排序的Listbox控件"""
def__init__(self, master, **kwargs):
        super().__init__(master, **kwargs)
        self.bind('<Button-1>', self.on_start)
        self.bind('<B1-Motion>', self.on_drag)
        self.bind('<ButtonRelease-1>', self.on_drop)
        self.drag_data = {"index"None"y_offset"None}

defon_start(self, event):
"""记录拖拽起始位置"""
# 获取点击的列表项索引
        self.drag_data["index"] = self.nearest(event.y)
# 计算鼠标相对于列表项的偏移量
        self.drag_data["y_offset"] = event.y - self.bbox(self.drag_data["index"])[1]

defon_drag(self, event):
"""拖拽过程中实时显示选中效果"""
# 计算当前鼠标位置对应的列表项
        current_index = self.nearest(event.y)
# 如果拖拽到了新位置,更新选中状态
if current_index != self.drag_data["index"]:
# 先取消所有选中
            self.selection_clear(0, tk.END)
# 选中当前拖拽到的位置
            self.selection_set(current_index)

defon_drop(self, event):
"""释放鼠标完成拖拽排序"""
if self.drag_data["index"isNone:
return

# 获取释放位置的索引
        drop_index = self.nearest(event.y)

# 如果拖拽到了不同位置,执行排序
if drop_index != self.drag_data["index"]:
# 获取拖拽项的文本
            item_text = self.get(self.drag_data["index"])
# 删除原位置的项
            self.delete(self.drag_data["index"])
# 插入到新位置
            self.insert(drop_index, item_text)
# 选中新位置的项
            self.selection_set(drop_index)

# 重置拖拽数据
        self.drag_data["index"] = None
        self.drag_data["y_offset"] = None

classVisualScrapyGenerator:
"""可视化Scrapy代码生成器"""
def__init__(self, root):
        self.root = root
        self.root.title("拖拽式可视化爬虫生成器")
        self.root.geometry("1000x600")

# 初始化采集步骤列表
        self.crawl_steps = [
"设置爬虫名称: example_spider",
"设置起始URL: https://example.com",
"解析列表页: 提取标题和链接",
"解析详情页: 提取内容和发布时间",
"设置数据保存字段: title, content, publish_time",
"设置请求延迟: 2秒",
"设置User-Agent: Mozilla/5.0",
"启用Cookies: True"
        ]

        self.setup_ui()
# 初始生成代码
        self.generate_scrapy_code()

defsetup_ui(self):
"""设置界面布局"""
# 创建主容器
        main_frame = ttk.Frame(self.root, padding="10")
        main_frame.pack(fill=tk.BOTH, expand=True)

# 左侧步骤面板
        left_frame = ttk.LabelFrame(main_frame, text="采集步骤 (拖拽排序)", padding="10")
        left_frame.pack(side=tk.LEFT, fill=tk.BOTH, expand=True, padx=(010))

# 拖拽Listbox
        self.step_listbox = DragDropListbox(
            left_frame, 
            font=("Consolas"10),
            selectmode=tk.SINGLE,
            activestyle=tk.NONE
        )
        self.step_listbox.pack(fill=tk.BOTH, expand=True)

# 填充初始步骤
for step in self.crawl_steps:
            self.step_listbox.insert(tk.END, step)

# 绑定列表项变化事件
        self.step_listbox.bind('<<ListboxSelect>>', self.on_step_change)
# 绑定拖拽完成后的代码更新
        self.step_listbox.bind('<ButtonRelease-1>'lambda e: self.generate_scrapy_code())

# 右侧代码面板
        right_frame = ttk.LabelFrame(main_frame, text="生成的Scrapy代码", padding="10")
        right_frame.pack(side=tk.RIGHT, fill=tk.BOTH, expand=True)

# 代码显示区域
        self.code_text = tk.Text(
            right_frame,
            font=("Consolas"10),
            wrap=tk.NONE,
            bg="
#f8f8f8"
        )
        self.code_text.pack(fill=tk.BOTH, expand=True)

# 添加滚动条
        code_scroll_x = ttk.Scrollbar(right_frame, orient=tk.HORIZONTAL, command=self.code_text.xview)
        code_scroll_y = ttk.Scrollbar(right_frame, orient=tk.VERTICAL, command=self.code_text.yview)
        self.code_text.configure(xscrollcommand=code_scroll_x.set, yscrollcommand=code_scroll_y.set)
        code_scroll_x.pack(side=tk.BOTTOM, fill=tk.X)
        code_scroll_y.pack(side=tk.RIGHT, fill=tk.Y)

# 底部按钮
        btn_frame = ttk.Frame(main_frame)
        btn_frame.pack(side=tk.BOTTOM, fill=tk.X, pady=10)

# 重置按钮
        reset_btn = ttk.Button(btn_frame, text="重置步骤", command=self.reset_steps)
        reset_btn.pack(side=tk.LEFT, padx=5)

# 复制代码按钮
        copy_btn = ttk.Button(btn_frame, text="复制代码", command=self.copy_code)
        copy_btn.pack(side=tk.LEFT, padx=5)

defon_step_change(self, event):
"""步骤列表变化时更新代码"""
        self.generate_scrapy_code()

defparse_step(self, step_text):
"""解析单步配置,提取关键信息"""
        key = None
        value = None

if"设置爬虫名称:"in step_text:
            key = "spider_name"
            value = step_text.split(":"1)[1].strip()
elif"设置起始URL:"in step_text:
            key = "start_urls"
            value = step_text.split(":"1)[1].strip()
elif"设置请求延迟:"in step_text:
            key = "download_delay"
            value = step_text.split(":"1)[1].strip().replace("秒""")
elif"设置User-Agent:"in step_text:
            key = "user_agent"
            value = step_text.split(":"1)[1].strip()
elif"启用Cookies:"in step_text:
            key = "cookies_enabled"
            value = step_text.split(":"1)[1].strip()

return key, value

defgenerate_scrapy_code(self):
"""根据步骤生成Scrapy代码"""
# 获取当前排序后的步骤
        current_steps = [self.step_listbox.get(i) for i in range(self.step_listbox.size())]

# 解析配置
        config = {
"spider_name""example_spider",
"start_urls""https://example.com",
"download_delay"2,
"user_agent""Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36",
"cookies_enabled"True
        }

for step in current_steps:
            key, value = self.parse_step(step)
if key and value:
if key in ["download_delay"]:
                    config[key] = float(value)
elif key in ["cookies_enabled"]:
                    config[key] = eval(value)
else:
                    config[key] = value

# 生成Scrapy代码模板
        scrapy_code = f'''# 自动生成的Scrapy爬虫代码
# 采集步骤: {", ".join([s[:20] + "..."if len(s) > 20else s for s in current_steps])}
import scrapy

class {config["spider_name"].capitalize()}Spider(scrapy.Spider):
    # 爬虫名称
    name = "{config["spider_name"]}"
    # 允许的域名(可根据实际情况修改)
    allowed_domains = ["{config["start_urls"].split("//")[1].split("/")[0]}"]
    # 起始URL
    start_urls = ["{config["start_urls"]}"]

    # 爬虫配置
    custom_settings = {{
        "DOWNLOAD_DELAY": {config["download_delay"]},
        "USER_AGENT": "{config["user_agent"]}",
        "COOKIES_ENABLED": {config["cookies_enabled"]},
        "DEFAULT_REQUEST_HEADERS": {{
            "Accept": "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8",
            "Accept-Language": "zh-CN,zh;q=0.9,en;q=0.8",
        }}
    }}

    def parse(self, response):
        """
        列表页解析函数 - 对应步骤: {[s for s in current_steps if"解析列表页"in s][0if any("解析列表页"in s for s in current_steps) else"默认解析逻辑"}
        """
        # 示例:提取所有链接(请根据实际页面结构修改XPath/CSS选择器)
        for href in response.css("a::attr(href)").extract():
            # 拼接完整URL
            full_url = response.urljoin(href)
            # 请求详情页
            yield scrapy.Request(full_url, callback=self.parse_detail)

    def parse_detail(self, response):
        """
        详情页解析函数 - 对应步骤: {[s for s in current_steps if"解析详情页"in s][0if any("解析详情页"in s for s in current_steps) else"默认解析逻辑"}
        """
        # 提取数据字段(请根据实际页面结构修改XPath/CSS选择器)
        item = {{
            # 标题
            "title": response.css("h1::text").extract_first(),
            # 内容
            "content": response.css(".content::text").extract(),
            # 发布时间
            "publish_time": response.css(".publish-time::text").extract_first(),
        }}

        # 返回数据项
        yield item

# 运行爬虫的命令:
# scrapy crawl {config["spider_name"]} -o output.json
'''


# 清空并插入新代码
        self.code_text.delete(1.0, tk.END)
        self.code_text.insert(1.0, scrapy_code)
# 设置代码区域为只读(保留复制功能)
        self.code_text.config(state=tk.DISABLED)

defreset_steps(self):
"""重置步骤列表"""
        self.step_listbox.delete(0, tk.END)
for step in self.crawl_steps:
            self.step_listbox.insert(tk.END, step)
        self.generate_scrapy_code()

defcopy_code(self):
"""复制生成的代码到剪贴板"""
# 临时启用编辑状态
        self.code_text.config(state=tk.NORMAL)
# 选中所有内容
        self.code_text.tag_add(tk.SEL, 1.0, tk.END)
# 复制到剪贴板
        self.root.clipboard_clear()
        self.root.clipboard_append(self.code_text.get(1.0, tk.END))
# 恢复只读状态
        self.code_text.config(state=tk.DISABLED)
# 提示复制成功
        messagebox.showinfo("提示""代码已复制到剪贴板!")

if __name__ == "__main__":
    root = tk.Tk()
    app = VisualScrapyGenerator(root)
    root.mainloop()

代码核心功能解释

  1. 拖拽Listbox实现DragDropListbox类):

    • 重写了 Button-1(鼠标左键按下)、B1-Motion(鼠标拖拽)、ButtonRelease-1(鼠标释放)三个事件
    • on_start:记录拖拽起始位置和偏移量
    • on_drag:拖拽过程中实时高亮显示目标位置
    • on_drop:释放鼠标时完成列表项的删除和重新插入,实现排序
  2. 代码生成逻辑generate_scrapy_code方法):

    • 读取当前Listbox中排序后的所有步骤
    • 解析每个步骤中的配置项(爬虫名称、起始URL、延迟等)
    • 根据解析出的配置动态生成完整的Scrapy爬虫代码
    • 代码模板包含了标准的Spider类、列表页解析、详情页解析、自定义配置等核心部分
  3. 界面交互功能

    • 重置按钮:恢复初始步骤顺序
    • 复制按钮:将生成的代码复制到剪贴板
    • 代码区域:使用等宽字体,支持横向/纵向滚动,设置为只读防止误修改

使用说明

  1. 环境要求:只需Python内置的tkinter库(Python 3.x 默认自带),无需额外安装依赖
  2. 操作步骤
    • 运行代码后,左侧Listbox显示预设的采集步骤
    • 用鼠标左键按住任意步骤项,拖拽到目标位置后释放,即可完成排序
    • 排序后右侧会实时生成对应的Scrapy代码
    • 点击"重置步骤"可恢复初始顺序
    • 点击"复制代码"可将生成的代码复制到剪贴板,直接用于Scrapy项目

总结

  1. 核心实现:通过重写tkinter Listbox的鼠标事件,实现了拖拽排序功能,这是可视化交互的基础
  2. 代码生成:基于排序后的采集步骤,动态解析配置并生成结构化的Scrapy代码,实现了可视化到代码的转换
  3. 交互体验:提供了重置、复制等辅助功能,代码区域采用只读模式保证安全性,同时保留复制功能

这个工具可以作为基础版本,你还可以扩展更多功能,比如:添加自定义步骤、支持更多Scrapy配置项、实时预览爬虫效果、导出为py文件等。

最新文章

随机文章

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-02-09 04:05:09 HTTP/2.0 GET : https://f.mffb.com.cn/a/460339.html
  2. 运行时间 : 0.191043s [ 吞吐率:5.23req/s ] 内存消耗:4,546.67kb 文件加载:140
  3. 缓存信息 : 0 reads,0 writes
  4. 会话信息 : SESSION_ID=c4ea7387dd1f75ee74d2624fb90ec3a0
  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.000461s ] mysql:host=127.0.0.1;port=3306;dbname=f_mffb;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000736s ]
  3. SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.002670s ]
  4. SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.003382s ]
  5. SHOW FULL COLUMNS FROM `set` [ RunTime:0.000540s ]
  6. SELECT * FROM `set` [ RunTime:0.011543s ]
  7. SHOW FULL COLUMNS FROM `article` [ RunTime:0.000681s ]
  8. SELECT * FROM `article` WHERE `id` = 460339 LIMIT 1 [ RunTime:0.004265s ]
  9. UPDATE `article` SET `lasttime` = 1770581109 WHERE `id` = 460339 [ RunTime:0.022377s ]
  10. SELECT * FROM `fenlei` WHERE `id` = 66 LIMIT 1 [ RunTime:0.002356s ]
  11. SELECT * FROM `article` WHERE `id` < 460339 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008188s ]
  12. SELECT * FROM `article` WHERE `id` > 460339 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.003674s ]
  13. SELECT * FROM `article` WHERE `id` < 460339 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.004029s ]
  14. SELECT * FROM `article` WHERE `id` < 460339 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.004236s ]
  15. SELECT * FROM `article` WHERE `id` < 460339 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.057483s ]
0.193054s