# 为什么没有记录谁添加或删除了慢速模式？

**URL:** <https://meta.discourse.org/t/why-is-there-no-record-of-who-added-or-removed-slow-mode/316354>\
**Category:** Feature\
**Tags:** completed, slow-mode\
**Created:** [2024年七月15日 15:54 UTC](https://meta.discourse.org/t/why-is-there-no-record-of-who-added-or-removed-slow-mode/316354 "2024-07-15T15:54:20Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Lilly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lilly/32/575047_2.png) [@Lilly](https://meta.discourse.org/u/Lilly)\
**Post date:** [2024年七月15日 17:46 UTC](https://meta.discourse.org/t/why-is-there-no-record-of-who-added-or-removed-slow-mode/316354/2 "2024-07-15T17:46:38Z")

</div>

您可以使用 [Data Explorer](https://meta.discourse.org/t/32566?silent=true) 查询此信息。我认为这应该可行——您需要指定开始和结束日期。它应该返回主题、慢速模式的秒数、主题慢速模式的更新时间和执行者：

```sql
-- [params]
-- date :start_date
-- date :end_date

SELECT 
    t.id AS topic_id,
    t.title,
    t.slow_mode_seconds,
    t.updated_at,
    u.id AS user_id,
    u.username
FROM 
    topics t
JOIN 
    users u ON t.user_id = u.id
WHERE 
    t.slow_mode_seconds > 0
    AND t.updated_at BETWEEN :start_date AND :end_date
ORDER BY 
    t.updated_at DESC

```

---

_[View the full topic](https://meta.discourse.org/t/why-is-there-no-record-of-who-added-or-removed-slow-mode/316354)._