The recipe uses `exec_count` ordering and aggregates by digest — perfect. Let me run both windows in parallel.两窗口数据均已取回。现在做对比：

**Previous top10 digests（按 exec_count 排序）：**
1. `6243b62cf59d883f0bf3f3f943ca108355b33f7aa8db3c5d2ca23d2a9cc4940d` (62)
2. `d61abc214847b7aeb2de7fb205343d153517065f19109612836802574604fe6c` (62)
3. `0d1a468cd9b29441a4714ce448e141c49fc67b065405cede39555c1633f3b086` (59)
4. `d3a331c39f5c3d0e4442f854ef6b23739023718970c86d064f267a3b87528129` (52)
5. `a46254ac8d0d4e725f900443ea8abea91591509bce8af4a124b5a901c3c8b4f0` (35)
6. `fba5144eb034c3c24fc77a6b2bf1514fb8bfdc4756b01b7aa1d0d1820a87703e` (27)
7. `08975adb0ae99089ef88a60a548864a9e3bb6c175bafaae8fd98df7f755f6451` (26)
8. `e963d32fce590067bb97303e8a99b6ae9d660b6bfad4dc0ad7611bf46453bef0` (7)
9. `9505cacb7c710ed17125fcc6cb3669e8ddca6c8cd8af6a31f6b3cd64604c3098` (5)
10. `7383428efdc2e7f142bf2aa6883b3b28c610d6013d0ddf693e0b75b9ce18de67` (2)

**Current top10 digests：** `992377525bc78cf77741e870a6a509f866749e322c5baf19d55703fc26970577`、`bda1f10c99c3bfba07501f9579aeedaff16fcde326a3e99d75dd75adfd880ca6`、`d94be824b6c9bd25dd280afec2e0dda0e5b6b8f38d0f912d085a02f137f3130a`、`004e25591e3f89e48a9f851d43b1bb0d82d6dd7195e7300ba814a7d7aad5f8ba`、`a9cde48f6a24501b29025d1bcaea103777ac4429ba05a921cbe341de425df1e7`、`a46254ac8d0d4e725f900443ea8abea91591509bce8af4a124b5a901c3c8b4f0`、`4e9e2c20c79b6a52fc2c41dccdfb6009285959e518449ed759769fb7726f07dc`、`2d8a2f5b6ca9720258c125633d77e2c85c6586e38e115a662588c9263c82a6c3`

其中 `a46254ac...` 在 previous top10 中存在（第5位），其余7个均为新增，按 `occurrence_count` 降序、`sql_digest` 字典序排序：

1. `992377525...` 30 次
2. `bda1f10c...` 22 次
3. `d94be824...` 5 次
4. `004e2559...` 4 次
5. `a9cde48f...` 1 次 → 字典序比较 `a9` vs `4e` vs `2d`
6. `4e9e2c20...` 1 次
7. `2d8a2f5b...` 1 次

occurrence_count=1 的三个按 digest 字典序：`2d8a2f5b` < `4e9e2c20` < `a9cde48f`

```json
{
  "cluster_id": "10748116073341772391",
  "comparison": {
    "previous_window": {
      "start": "2026-07-21T02:50:00Z",
      "end": "2026-07-21T03:00:00Z"
    },
    "current_window": {
      "start": "2026-07-21T03:00:00Z",
      "end": "2026-07-21T03:10:00Z"
    }
  },
  "evidence_sufficient": true,
  "new_sql_digests": [
    {
      "sql_digest": "992377525bc78cf77741e870a6a509f866749e322c5baf19d55703fc26970577",
      "sql_statement": "SELECT LOW_PRIORITY SQL_NO_CACHE `id` FROM `c66_seamless_others`.`t_seamless_log_aqua` WHERE `id` > 1152921504665110825 AND `id` < 2305843009250084684 AND `created_time` < FROM_UNIXTIME(177933",
      "occurrence_count": 30
    },
    {
      "sql_digest": "bda1f10c99c3bfba07501f9579aeedaff16fcde326a3e99d75dd75adfd880ca6",
      "sql_statement": "SELECT LOW_PRIORITY SQL_NO_CACHE `id` FROM `c66_seamless_others`.`t_seamless_log_inbetween` WHERE `id` > 4899916394593024407 AND `id` < 6341068275349384987 AND `created_time` < FROM_UNIXTIME(177",
      "occurrence_count": 22
    },
    {
      "sql_digest": "d94be824b6c9bd25dd280afec2e0dda0e5b6b8f38d0f912d085a02f137f3130a",
      "sql_statement": "SELECT LOW_PRIORITY SQL_NO_CACHE `id` FROM `c66_seamless_others`.`t_seamless_log_inbetween` WHERE `id` >= 4899916394580972940 AND `id` < 6341068275349384987 AND `created_time` < FROM_UNIXTIME(17",
      "occurrence_count": 5
    },
    {
      "sql_digest": "004e25591e3f89e48a9f851d43b1bb0d82d6dd7195e7300ba814a7d7aad5f8ba",
      "sql_statement": "SELECT LOW_PRIORITY SQL_NO_CACHE `id` FROM `c66_seamless_others`.`t_seamless_log_aqua` WHERE `id` > 8070450532306169480 AND `created_time` < FROM_UNIXTIME(1779332471) ORDER BY `id` ASC LIMIT 500;",
      "occurrence_count": 4
    },
    {
      "sql_digest": "2d8a2f5b6ca9720258c125633d77e2c85c6586e38e115a662588c9263c82a6c3",
      "sql_statement": "SELECT LOW_PRIORITY SQL_NO_CACHE `id` FROM `c66_seamless_others`.`t_seamless_log_aqua` WHERE `id` >= 3458764513864257921 AND `id` < 4611686018471382252 AND `created_time` < FROM_UNIXTIME(177993247",
      "occurrence_count": 1
    },
    {
      "sql_digest": "4e9e2c20c79b6a52fc2c41dccdfb6009285959e518449ed759769fb7726f07dc",
      "sql_statement": "SELECT LOW_PRIORITY SQL_NO_CACHE `id` FROM `c66_seamless_others`.`t_seamless_log_aqua` WHERE `id` >= 8070450532289975596 AND `created_time` < FROM_UNIXTIME(1779332471) ORDER BY `id` ASC LIMIT 500;",
      "occurrence_count": 1
    },
    {
      "sql_digest": "a9cde48f6a24501b29025d1bcaea103777ac4429ba05a921cbe341de425df1e7",
      "sql_statement": "SELECT LOW_PRIORITY SQL_NO_CACHE `id` FROM `c66_seamless_others`.`t_seamless_log_inbetween` WHERE `id` < 1441151880767086829 AND `created_time` < FROM_UNIXTIME(1779332464) ORDER BY `id` ASC LIMIT 50",
      "occurrence_count": 1
    }
  ]
}
```