optimizar query healthcheck

milei-sqld-1  | 2024-07-16T14:44:04.851846Z  INFO libsql_server::stats: high read (10692149) or write (0) query: select "at", (select count(*) from "db_retweets" where "id" = "scrap_id") as c from "db_scraps" where c > 0 order by "db_scraps"."at" desc limit ?

~2 seg