当前位置:首页>python>MongoEngine完全指南:让Python操作MongoDB像呼吸一样自然

MongoEngine完全指南:让Python操作MongoDB像呼吸一样自然

  • 2026-01-31 19:14:26
MongoEngine完全指南:让Python操作MongoDB像呼吸一样自然

点击蓝字 关注我们

告别繁琐的PyMongo字典操作,拥抱优雅的面向对象开发体验

开篇:为什么你需要MongoEngine?

如果你正在使用Python操作MongoDB,很可能经历过这样的痛苦:

# 传统的PyMongo写法
user_data = {
"name""张三",
"email""zhangsan@example.com",
"age"25,
"created_at": datetime.now(),
"address": {
"city""北京",
"street""朝阳区"
    }
}

# 小心翼翼地插入数据
result = db.users.insert_one(user_data)
user_id = str(result.inserted_id)

# 查询时又是一堆字典操作
user = db.users.find_one({"_id": ObjectId(user_id)})
if user:
    user["last_login"] = datetime.now()
    db.users.update_one(
        {"_id": user["_id"]},
        {"$set": {"last_login": user["last_login"]}}
    )

问题显而易见:字段名硬编码、类型转换繁琐、缺乏数据验证、代码重复...

而使用MongoEngine,同样的操作变得如此优雅:

# 定义数据模型
classUser(Document):
    name = StringField(required=True)
    email = EmailField(unique=True)
    age = IntField(min_value=0)
    created_at = DateTimeField(default=datetime.now)
    address = EmbeddedDocumentField(Address)
    last_login = DateTimeField()

defupdate_login_time(self):
        self.last_login = datetime.now()
        self.save()

# 使用
user = User(name="张三", email="zhangsan@example.com", age=25)
user.save()
user.update_login_time()

第一章:MongoEngine的核心哲学

1.1 什么是MongoEngine?

MongoEngine是一个文档对象映射器(Document-Object Mapper,DOM),相当于MongoDB世界的"SQLAlchemy"。它将MongoDB文档映射为Python对象,让你能用面向对象的方式操作NoSQL数据库。

1.2 为什么选择MongoEngine?

✅ 优势:

  • Pythonic语法:像操作普通Python对象一样操作数据库
  • 数据验证:在保存前自动验证数据完整性
  • 代码复用:通过继承和混合类重用代码
  • 查询友好:链式调用、丰富的查询运算符
  • 社区活跃:GitHub 3.8k+ stars,持续维护

⚠️ 注意:

  • 有一定学习成本
  • 对于简单查询,性能略低于原生PyMongo
  • 需要适应MongoDB的文档模型思维

第二章:快速入门 - 从零到一

2.1 安装与环境配置

# 安装MongoEngine
pip install mongoengine

# 如果需要连接异步MongoDB
pip install mongoengine[async]

# 或者安装所有可选依赖
pip install mongoengine[all]

2.2 建立数据库连接

from mongoengine import connect
import os

# 方式1:最简单的连接
connect('my_database')  # 连接到本地的my_database

# 方式2:指定主机和端口
connect('my_database', host='localhost', port=27017)

# 方式3:完整的连接字符串(生产环境推荐)
connect(
    db='my_database',
    host=f"mongodb://{os.getenv('MONGO_USER')}:{os.getenv('MONGO_PASS')}"
f"@{os.getenv('MONGO_HOST')}:{os.getenv('MONGO_PORT')}/my_database"
"?authSource=admin&retryWrites=true&w=majority"
)

# 方式4:多数据库连接(微服务架构)
primary_db = connect('primary_db', alias='primary')
replica_db = connect('replica_db', alias='replica'
                     host='mongodb://replica-host:27017/')

第三章:数据建模的艺术

3.1 基础字段类型

MongoEngine提供了丰富的字段类型来映射MongoDB的数据结构:

from mongoengine import Document, EmbeddedDocument
from mongoengine.fields import (
    StringField, IntField, FloatField, BooleanField,
    DateTimeField, DateField, ListField, DictField,
    ReferenceField, ObjectIdField, DecimalField,
    URLField, EmailField, GeoPointField, FileField
)

classProduct(Document):
# 基本类型
    name = StringField(required=True, max_length=100)  # 必需字段
    description = StringField()  # 可选字段
    price = DecimalField(precision=2, min_value=0)  # 精度2位小数
    quantity = IntField(min_value=0, default=0)

# 特殊类型
    email = EmailField(unique=True)  # 邮箱验证
    website = URLField()  # URL验证
    is_active = BooleanField(default=True)

# 时间类型
    created_at = DateTimeField(default=datetime.now)
    published_date = DateField()

# 复杂类型
    tags = ListField(StringField(max_length=20))
    attributes = DictField()  # 灵活存储额外属性
    location = GeoPointField()  # 地理位置 [经度, 纬度]

# 文件存储(实际文件存储在GridFS)
    thumbnail = FileField()

3.2 嵌套文档 - MongoDB的核心优势

from mongoengine import EmbeddedDocument, EmbeddedDocumentField

classAddress(EmbeddedDocument):
"""嵌套文档:地址信息"""
    street = StringField(required=True)
    city = StringField(required=True)
    postal_code = StringField(regex=r'^\d{6}$')  # 正则验证
    country = StringField(default="中国")

    @property
deffull_address(self):
returnf"{self.country}{self.city}{self.street}"

classContact(EmbeddedDocument):
"""嵌套文档:联系方式"""
    phone = StringField(regex=r'^1[3-9]\d{9}$')  # 手机号验证
    wechat = StringField()
    emergency_contact = StringField()

classUserProfile(EmbeddedDocument):
"""嵌套文档:用户资料"""
    bio = StringField(max_length=500)
    avatar_url = URLField()
    social_links = DictField()

classUser(Document):
"""主文档:用户"""
    username = StringField(required=True, unique=True, min_length=3)
    addresses = ListField(EmbeddedDocumentField(Address))  # 多个地址
    contact = EmbeddedDocumentField(Contact)  # 单个联系方式
    profile = EmbeddedDocumentField(UserProfile)  # 用户资料

# 使用示例
defadd_address(self, street, city, postal_code):
"""添加新地址"""
        new_address = Address(
            street=street,
            city=city,
            postal_code=postal_code
        )
        self.addresses.append(new_address)
        self.save()

defget_primary_address(self):
"""获取主要地址(第一个地址)"""
return self.addresses[0if self.addresses elseNone

3.3 文档关联 - 灵活的数据关系

classAuthor(Document):
    name = StringField(required=True)
    bio = StringField()
    nationality = StringField()

classPublisher(Document):
    name = StringField(required=True)
    address = StringField()

classBook(Document):
    title = StringField(required=True)
    isbn = StringField(unique=True, regex=r'^\d{13}$')

# 一对多关联:一本书一个作者
    author = ReferenceField(Author)

# 多对多关联:多本书可以有多个出版社
    publishers = ListField(ReferenceField(Publisher))

# 反向引用:通过book参数建立双向关系
    reviews = ListField(ReferenceField('Review'))

# 查询方法
defbooks_by_author(cls, author_name):
return cls.objects(author__name=author_name)

defadd_review(self, review):
"""添加书评并建立双向关联"""
        self.reviews.append(review)
        self.save()
        review.book = self
        review.save()

classReview(Document):
    content = StringField(required=True)
    rating = IntField(min_value=1, max_value=5)
    book = ReferenceField(Book, reverse_delete_rule=CASCADE)

# 级联删除:删除书时自动删除评论

第四章:查询的艺术

4.1 基础查询方法

# 创建查询
users = User.objects()  # 所有用户

# 过滤查询
active_users = User.objects(is_active=True)
adult_users = User.objects(age__gte=18)  # 年龄大于等于18

# 常用查询运算符
"""
exact / iexact - 精确匹配 / 不区分大小写
contains / icontains - 包含
startswith / istartswith - 以...开头
endswith / iendswith - 以...结尾
in - 在列表中
nin - 不在列表中
lt / lte / gt / gte - 小于 / 小于等于 / 大于 / 大于等于
ne - 不等于
exists - 字段存在
mod - 取模运算
"""


# 复杂查询
from mongoengine.queryset.visitor import Q

# 使用Q对象进行复杂逻辑查询
users = User.objects(
    Q(age__gte=18) &  # AND
    (Q(city="北京") | Q(city="上海"))  # OR
).exclude(is_banned=True)  # 排除被封禁的用户

4.2 链式查询与排序

# 链式调用 - 非常Pythonic的写法
recent_vip_users = (User.objects
                    .filter(level="vip")  # 筛选VIP用户
                    .filter(created_at__gte=one_month_ago)  # 最近一个月
                    .exclude(is_deleted=True)  # 排除已删除
                    .order_by('-created_at')  # 按创建时间倒序
                    .limit(20)  # 限制20条
                    .skip(10))  # 跳过前10条

# 执行查询
for user in recent_vip_users:
    print(user.username, user.created_at)

# 获取单个对象
try:
    user = User.objects.get(email="admin@example.com")  # get()只返回一个
except User.DoesNotExist:
    print("用户不存在")
except User.MultipleObjectsReturned:
    print("找到多个用户")

# 计数和存在性检查
user_count = User.objects.count()
has_admins = User.objects(role="admin").exists()

4.3 聚合查询

from mongoengine import Document
import pprint

classOrder(Document):
    user_id = ObjectIdField(required=True)
    amount = FloatField(min_value=0)
    status = StringField(choices=["pending""paid""shipped""completed"])
    created_at = DateTimeField(default=datetime.now)

# 使用原生聚合管道
pipeline = [
    {
"$match": {
"status""completed",
"created_at": {"$gte": datetime(202411)}
        }
    },
    {
"$group": {
"_id""$user_id",
"total_spent": {"$sum""$amount"},
"order_count": {"$sum"1},
"avg_order_value": {"$avg""$amount"}
        }
    },
    {
"$sort": {"total_spent"-1}
    },
    {
"$limit"10
    }
]

# 执行聚合查询
results = Order.objects.aggregate(pipeline)
for result in results:
    pprint.pprint(result)

第五章:高级特性

5.1 索引优化

classBlogPost(Document):
    title = StringField(required=True)
    content = StringField()
    author = ReferenceField(User)
    tags = ListField(StringField())
    views = IntField(default=0)
    created_at = DateTimeField(default=datetime.now)
    updated_at = DateTimeField()

    meta = {
"collection""blog_posts",

# 单字段索引
"indexes": [
"title",  # 简单索引
"created_at",  # 按时间排序
"author",  # 外键查询优化

# 复合索引
            {
"fields": ["author""-created_at"],  # 作者和时间
"name""author_created_idx"
            },

# 全文索引
            {
"fields": ["$title""$content"],  # 文本搜索
"default_language""english",
"weights": {"title"10"content"2}
            },

# 唯一索引
            {
"fields": ["slug"],
"unique"True,
"sparse"True# 允许空值
            },

# TTL索引 - 自动过期
            {
"fields": ["created_at"],
"expireAfterSeconds"30 * 24 * 3600# 30天后自动删除
            }
        ],

# 查询优化
"auto_create_index"True,  # 自动创建索引
"index_background"True,  # 后台创建索引
"index_cls"False# 不创建_id索引(特殊情况)
    }

5.2 信号系统

from mongoengine import signals
import hashlib

classUser(Document):
    username = StringField(required=True)
    password = StringField(required=True)
    email = StringField(unique=True)
    last_login = DateTimeField()

    @classmethod
defpre_save(cls, sender, document, **kwargs):
"""保存前的信号处理"""
if document.password andnot document.password.startswith('hash_'):
# 密码加密
            document.password = 'hash_' + hashlib.sha256(
                document.password.encode()
            ).hexdigest()

# 更新时间戳
        document.updated_at = datetime.now()

    @classmethod
defpost_save(cls, sender, document, **kwargs):
"""保存后的信号处理"""
        print(f"用户 {document.username} 已保存")
if kwargs.get('created'):
            print("这是新用户")

# 可以在这里触发其他业务逻辑
# 如发送欢迎邮件、更新缓存等

    @classmethod
defpre_delete(cls, sender, document, **kwargs):
"""删除前的信号处理"""
        print(f"即将删除用户 {document.username}")

# 可以在这里进行清理操作
# 如删除关联数据、清理文件等

# 连接信号
signals.pre_save.connect(User.pre_save, sender=User)
signals.post_save.connect(User.post_save, sender=User)
signals.pre_delete.connect(User.pre_delete, sender=User)

5.3 继承与多态

classBaseContent(Document):
    title = StringField(required=True)
    author = ReferenceField(User)
    created_at = DateTimeField(default=datetime.now)

    meta = {
"abstract"True,  # 抽象基类,不会创建集合
"allow_inheritance"True
    }

defdisplay_title(self):
returnf"{self.title} - by {self.author.username}"

classArticle(BaseContent):
"""文章"""
    content = StringField()
    tags = ListField(StringField())

    meta = {
"collection""articles"
    }

classVideo(BaseContent):
"""视频"""
    url = URLField(required=True)
    duration = IntField(min_value=0)  # 时长(秒)

    meta = {
"collection""videos"
    }

defdisplay_title(self):
# 重写父类方法
returnf"[视频] {self.title} ({self.duration}秒)"

classPodcast(BaseContent):
"""播客"""
    audio_url = URLField(required=True)
    transcript = StringField()  # 文字稿

    meta = {
"collection""podcasts"
    }

# 多态查询
# 查询所有内容(文章、视频、播客)
all_contents = BaseContent.objects()
for content in all_contents:
    print(content.display_title())  # 多态调用

第六章:实战项目 - 博客系统

from datetime import datetime
from mongoengine import *
from mongoengine.errors import ValidationError

classUser(Document):
    username = StringField(required=True, unique=True, min_length=3)
    email = EmailField(required=True, unique=True)
    password_hash = StringField(required=True)
    role = StringField(choices=["user""author""admin"], default="user")
    created_at = DateTimeField(default=datetime.now)
    last_login = DateTimeField()

    meta = {
"collection""users",
"indexes": [
"username",
"email",
            ("role""-created_at")
        ]
    }

defis_admin(self):
return self.role == "admin"

defupdate_login_time(self):
        self.last_login = datetime.now()
        self.save()

classCategory(Document):
    name = StringField(required=True, unique=True)
    slug = StringField(required=True, unique=True)
    description = StringField()

    meta = {
"collection""categories",
"indexes": ["slug"]
    }

classTag(Document):
    name = StringField(required=True, unique=True)
    slug = StringField(required=True, unique=True)

    meta = {
"collection""tags",
"indexes": ["slug"]
    }

classComment(EmbeddedDocument):
    author = ReferenceField(User, required=True)
    content = StringField(required=True, max_length=1000)
    created_at = DateTimeField(default=datetime.now)
    is_approved = BooleanField(default=False)

    @property
defauthor_name(self):
return self.author.username if self.author else"匿名"

classPost(Document):
    title = StringField(required=True)
    slug = StringField(required=True, unique=True)
    excerpt = StringField(max_length=200)
    content = StringField(required=True)

    author = ReferenceField(User, required=True)
    category = ReferenceField(Category)
    tags = ListField(ReferenceField(Tag))

    status = StringField(
        choices=["draft""pending""published""archived"],
        default="draft"
    )

# 统计字段
    views = IntField(default=0)
    likes = IntField(default=0)
    comment_count = IntField(default=0)

# 时间字段
    created_at = DateTimeField(default=datetime.now)
    published_at = DateTimeField()
    updated_at = DateTimeField(default=datetime.now)

# 嵌套文档
    comments = ListField(EmbeddedDocumentField(Comment))
    metadata = DictField()  # 扩展元数据

    meta = {
"collection""posts",
"indexes": [
"slug",
            ("author""-created_at"),
            ("category""-published_at"),
"tags",
            {
"fields": ["$title""$content""$excerpt"],
"default_language""chinese",
"weights": {"title"10"excerpt"5"content"1}
            },
            {
"fields": ["published_at"],
"expireAfterSeconds"365 * 24 * 3600# 一年后归档
            }
        ],
"ordering": ["-published_at"]
    }

defincrease_view(self):
"""增加阅读量"""
        self.views += 1
        self.save()

defadd_comment(self, user, content):
"""添加评论"""
        comment = Comment(author=user, content=content)
        self.comments.append(comment)
        self.comment_count += 1
        self.save()
return comment

defpublish(self):
"""发布文章"""
if self.status != "published":
            self.status = "published"
            self.published_at = datetime.now()
            self.save()

    @classmethod
defget_published_posts(cls, category_slug=None, tag_slug=None, page=1, per_page=10):
"""获取已发布的文章"""
        query = cls.objects(status="published")

if category_slug:
            query = query.filter(category__slug=category_slug)

if tag_slug:
            query = query.filter(tags__slug=tag_slug)

        skip = (page - 1) * per_page
return query.order_by("-published_at").skip(skip).limit(per_page)

    @classmethod
defsearch_posts(cls, keyword):
"""全文搜索"""
return cls.objects.search_text(keyword).order_by("$text_score")

第七章:性能优化

7.1 查询优化技巧

# 1. 使用only()选择需要的字段(避免查询整个文档)
users = User.objects.only("username""email")  # 只查询用户名和邮箱

# 2. 使用aggregate()进行复杂计算
# 3. 合理使用索引
# 4. 批量操作减少数据库往返

# 批量插入
users = [User(username=f"user{i}"for i in range(1000)]
User.objects.insert(users)

# 批量更新
User.objects(age__lt=18).update(set__category="minor")

7.2 错误处理

from mongoengine import NotUniqueError, ValidationError
from mongoengine.errors import DoesNotExist

try:
    user = User.objects.get(email="test@example.com")
except DoesNotExist:
    print("用户不存在")
except MultipleObjectsReturned:
    print("找到多个用户")
except ValidationError as e:
    print(f"数据验证失败: {e}")
except NotUniqueError:
    print("邮箱已存在")
except Exception as e:
    print(f"未知错误: {e}")

7.3 与其他库集成

# 与FastAPI集成
from fastapi import FastAPI, HTTPException
from pydantic import BaseModel
from typing import Optional

app = FastAPI()

classUserCreate(BaseModel):
    username: str
    email: str
    password: str

classUserResponse(BaseModel):
    id: str
    username: str
    email: str

classConfig:
        from_attributes = True

@app.post("/users/", response_model=UserResponse)
asyncdefcreate_user(user_data: UserCreate):
try:
        user = User(**user_data.dict())
        user.save()
return UserResponse(
            id=str(user.id),
            username=user.username,
            email=user.email
        )
except NotUniqueError:
raise HTTPException(status_code=400, detail="用户已存在")
except ValidationError as e:
raise HTTPException(status_code=422, detail=str(e))

# 与Celery集成(异步任务)
from celery import Celery

celery_app = Celery('tasks')

@celery_app.task
defupdate_user_statistics(user_id):
    user = User.objects.get(id=user_id)
# 异步处理统计逻辑
# ...
    user.save()

第八章:常见问题解答

Q1: MongoEngine和原生PyMongo哪个更快?A: 简单查询PyMongo更快,复杂业务逻辑MongoEngine更优。MongoEngine的额外开销在大多数应用中可接受。

Q2: 如何迁移现有的PyMongo代码?A: 逐步迁移。先在新模块中使用MongoEngine,逐渐替换旧代码。可使用适配器模式过渡。

Q3: MongoEngine支持异步吗?A: 有限支持。推荐使用motor处理异步操作,MongoEngine负责数据建模。

Q4: 如何处理复杂的事务?A: MongoEngine 0.20+支持MongoDB 4.0+的事务。对于复杂事务,建议配合原生PyMongo。

Q5: 字段验证会影响性能吗?A: 验证发生在应用层,对性能影响很小,但能防止脏数据入库。

结语:拥抱面向对象的MongoDB开发

MongoEngine不是万能钥匙,但它是连接Python面向对象编程和MongoDB文档数据库的优雅桥梁。通过学习MongoEngine,你不仅掌握了一个工具,更学会了如何用面向对象的思维设计文档数据库应用。

END

资料领取

关注公众号,后台回复“资料领取”或点击“资料领取”菜单即可免费获取“软件测试”、“Python开发”相关资料~

请在微信客户端打开

最新文章

随机文章

基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-02-07 20:15:51 HTTP/2.0 GET : https://f.mffb.com.cn/a/469814.html
  2. 运行时间 : 0.132476s [ 吞吐率:7.55req/s ] 内存消耗:4,745.84kb 文件加载:140
  3. 缓存信息 : 0 reads,0 writes
  4. 会话信息 : SESSION_ID=72cba7639e544e708f05d73ee1c314c4
  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.000985s ] mysql:host=127.0.0.1;port=3306;dbname=f_mffb;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001443s ]
  3. SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.001598s ]
  4. SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000668s ]
  5. SHOW FULL COLUMNS FROM `set` [ RunTime:0.001185s ]
  6. SELECT * FROM `set` [ RunTime:0.003671s ]
  7. SHOW FULL COLUMNS FROM `article` [ RunTime:0.001520s ]
  8. SELECT * FROM `article` WHERE `id` = 469814 LIMIT 1 [ RunTime:0.003062s ]
  9. UPDATE `article` SET `lasttime` = 1770466551 WHERE `id` = 469814 [ RunTime:0.002266s ]
  10. SELECT * FROM `fenlei` WHERE `id` = 66 LIMIT 1 [ RunTime:0.001636s ]
  11. SELECT * FROM `article` WHERE `id` < 469814 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004874s ]
  12. SELECT * FROM `article` WHERE `id` > 469814 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002624s ]
  13. SELECT * FROM `article` WHERE `id` < 469814 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.006920s ]
  14. SELECT * FROM `article` WHERE `id` < 469814 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.003571s ]
  15. SELECT * FROM `article` WHERE `id` < 469814 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.009042s ]
0.136275s