300 additional queries since week of 11th May

[nickvergessen]

• 4 May: 8.585 https://github.com/nextcloud/notifications/actions/runs/14817199027/job/41599628195 and 🆗
• 11 May: 8.900 https://github.com/nextcloud/notifications/actions/runs/14951759565/job/42002334603 and 😱 bot posted: [master] Update nextcloud/ocp dependency #2343 (comment)

Originally posted by @nickvergessen in #2352 (comment)

[nickvergessen]

--- .../Downloads/query-list.txt/query.log
+++ .../Downloads/query-list.txt(1)/query.log
@@ -47,6 +47,7 @@
  primary  0 SELECT "class", "entity", "events" AS "events" FROM "oc_flow_operations" WHERE "events" <> :dcValue1 GROUP BY "class", "entity", "events"
  primary  0 SELECT "appid", "configkey", "configvalue", "type", "lazy" FROM "oc_appconfig"
  primary  0 SELECT COUNT(*) AS "attempts" FROM "oc_bruteforce_attempts" WHERE ("occurred" > :dcValue1) AND ("subnet" = :dcValue2) AND ("action" = :dcValue3)
+ primary  0 SELECT COUNT(*) AS "attempts" FROM "oc_bruteforce_attempts" WHERE ("occurred" > :dcValue1) AND ("subnet" = :dcValue2) AND ("action" = :dcValue3)
  primary  0 SELECT "uid", "displayname", "password" FROM "oc_users" WHERE "uid_lower" = :dcValue1
  primary  0 SELECT "provider_id", "enabled" FROM "oc_twofactor_providers" WHERE "uid" = :dcValue1
  primary  0 SELECT "id", "user_id", "code", "used" FROM "oc_twofactor_backupcodes" WHERE "user_id" = :dcValue1
@@ -85,6 +86,7 @@
  primary  0 SELECT "class", "entity", "events" AS "events" FROM "oc_flow_operations" WHERE "events" <> :dcValue1 GROUP BY "class", "entity", "events"
  primary  0 SELECT "appid", "configkey", "configvalue", "type", "lazy" FROM "oc_appconfig"
  primary  0 SELECT COUNT(*) AS "attempts" FROM "oc_bruteforce_attempts" WHERE ("occurred" > :dcValue1) AND ("subnet" = :dcValue2) AND ("action" = :dcValue3)
+ primary  0 SELECT COUNT(*) AS "attempts" FROM "oc_bruteforce_attempts" WHERE ("occurred" > :dcValue1) AND ("subnet" = :dcValue2) AND ("action" = :dcValue3)
  primary  0 SELECT "uid", "displayname", "password" FROM "oc_users" WHERE "uid_lower" = :dcValue1
  primary  0 SELECT "provider_id", "enabled" FROM "oc_twofactor_providers" WHERE "uid" = :dcValue1
  primary  0 SELECT "appid", "configkey", "configvalue", "type", "flags" FROM "oc_preferences" WHERE ("userid" = :dcValue1) AND ("lazy" = :dcValue2)

And so on, caused by https://github.com/nextcloud/server/pull/52586/files Throttler lines 209 and 220

the $maxAttempts should be extracted and then 209-218 be moved inside of the other if