[release-2.13] fix: query mismatch with non-intersecting OR and neste…

…d AND condition (halo-dev#5455)

This is an automated cherry-pick of halo-dev#5452

/assign guqing

```release-note
None
```

chore: bump preset plugins version (halo-dev#5423)

#### What type of PR is this?

/area core
/milestone 2.13.0
/kind improvement

#### What this PR does / why we need it:

更新预设插件的版本。

#### Does this PR introduce a user-facing change?

```release-note
None
```

refactor: optimize notification and subscription query using index (h…

…alo-dev#5414)

### What type of PR is this?
/kind improvement
/area core
/milestone 2.13.x

### What this PR does / why we need it:
使用索引机制优化通知和订阅查询以提高性能

how to test it
测试通知列表不报错即可

### Does this PR introduce a user-facing change?

```release-note
使用索引机制优化通知和订阅查询以提高性能
```

[release-2.12] Fix the problem of being unable to login when 2FA was …

…enabled but TOTP was not configured (halo-dev#5401)

This is an automated cherry-pick of halo-dev#5400

/assign JohnNiang

```release-note
修复开启两步验证但未配置 TOTP 可能无法登录的问题
```

fix: resolve the issue of text editing not being effective before the…

… table (halo-dev#5365)

#### What type of PR is this?

/kind bug
/area editor
/area console

#### What this PR does / why we need it:

在 halo-dev#5191 中对表格新增了如果可以左右滚动时，则显示阴影的特性。而根据 `prosemirror` 的数据流处理策略，在 `decorations` 中，state 是 new EditorState，但通过 `this.editor.view` 获取到的 view 为 old EditorView，进而导致使用了最新的坐标，并且使用其坐标通过旧版本的 view 中获取 DOM 而产生的错误。

本 PR 使用 `NodeView` 而不是 `decorations` 来重新处理表格阴影。

#### How to test it?

在默认富文本编辑器中新建一个表格。在表格前使用拼音输入文本，查看此文本能否被输入。
同时查看表格阴影是否存在

#### Which issue(s) this PR fixes:

Fixes halo-dev#5352

#### Does this PR introduce a user-facing change?
```release-note
解决默认富文本编辑器表格前字符无法被编辑的问题。
```

[release-2.12] chore: remove unnecessary indices build process for lu…

…cene on startup (halo-dev#5333)

This is an automated cherry-pick of halo-dev#5332

/assign guqing

```release-note
移除启动时不必要的搜索引擎索引构建步骤
```

[release-2.12] Compatible with negative page number and size (halo-de…

…v#5313)

This is an automated cherry-pick of halo-dev#5311

/assign JohnNiang

```release-note
修复因限制分页参数导致部分主题页面无法正常渲染的问题。
```

feat: add supports for ui permissions of notification reason type (ha…

…lo-dev#5286)

#### What type of PR is this?

/kind feature
/area core
/area console
/milestone 2.12.x

#### What this PR does / why we need it:

为通知类型设置添加 UI 权限判断。

#### Which issue(s) this PR fixes:

Fixes halo-dev#4728

#### Special notes for your reviewer:

#### Does this PR introduce a user-facing change?

```release-note
为通知类型设置添加 UI 权限判断。
```

feat: add supports for ui permissions of notification reason type (ha…

…lo-dev#5286)

#### What type of PR is this?

/kind feature
/area core
/area console
/milestone 2.12.x

#### What this PR does / why we need it:

为通知类型设置添加 UI 权限判断。

#### Which issue(s) this PR fixes:

Fixes halo-dev#4728

#### Special notes for your reviewer:

#### Does this PR introduce a user-facing change?

```release-note
为通知类型设置添加 UI 权限判断。
```

Merge pull request halo-dev#5282 from JohnNiang/chore/remove-sonar-sc…

…aning

Remove analyzing code step in test job