Slow SQL Query on CheckRepoStats

[lunny]

Description

models/repo.go:215:CheckRepoStats() [W] [Slow SQL Query] SELECT repo.id FROM `repository` repo WHERE repo.num_watches!=(SELECT COUNT(*) FROM `watch` WHERE repo_id=repo.id AND mode<>2) [] - 6m40.204114759s

models/repo.go:215:CheckRepoStats() [W] [Slow SQL Query] SELECT label.id FROM `label` WHERE label.num_issues!=(SELECT COUNT(*) FROM `issue_label` WHERE label_id=label.id) [] - 6m31.342495533s

Gitea Version

main

Can you reproduce the bug on the Gitea demo site?

Yes

Log Gist

No response

Screenshots

No response

Git Version

No response

Operating System

No response

How are you running Gitea?

production server

Database

None