# Stats::TeamController#load_data

- **Period:** 23 Jun 13:28 UTC – 24 Jun 10:28 UTC
- **Throughput**: 0.06 / min
- **Average:** 3263.1 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| queue | queue | 685.13 | 1.0 | 21.00% |  |
| sql | app/services/stats/acquisitions/by_new_companies.rb:28 | 12784.0 | 0.04 | 15.67% | `SELECT COUNT(*) FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| sql | app/services/stats/needs/concerns/response_time.rb:18 | 398.71 | 0.84 | 10.26% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "match…` |
| sql | app/helpers/seo/data_preparation.rb:31 | 10959.0 | 0.03 | 8.96% | `SELECT "institutions".* FROM "institutions" INNER JOIN "logos" ON "logos"."logo…` |
| sql | app/services/stats/acquisitions/by_new_companies.rb:25 | 5853.67 | 0.04 | 7.18% | `SELECT COUNT(*) FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| sql | app/services/stats/base_stats.rb:177 | 683.9 | 0.27 | 5.59% | `SELECT COUNT(DISTINCT "companies"."id") AS "count_companies_id", DATE_TRUNC(?, …` |
| sql | app/services/stats/acquisitions/base.rb:22 | 146.79 | 1.2 | 5.40% | `SELECT COUNT(*) FROM "solicitations" WHERE "solicitations"."status" IN (?) AND …` |
| sql | app/services/stats/base_stats.rb:87 | 1509.8 | 0.07 | 3.08% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "diagnoses" ON "dia…` |
| sql | app/services/stats/acquisitions/base.rb:26 | 68.37 | 1.2 | 2.51% | `SELECT COUNT(*) FROM "solicitations" WHERE "solicitations"."status" IN (?) AND …` |
| sql | app/services/stats/acquisitions/base.rb:23 | 66.69 | 1.2 | 2.45% | `SELECT COUNT(*) FROM "solicitations" WHERE "solicitations"."status" IN (?) AND …` |
| sql | app/services/stats/matches/taking_care_time.rb:22 | 105.97 | 0.51 | 1.65% | `SELECT COUNT(*) FROM "matches" INNER JOIN "needs" ON "needs"."id" = "matches"."…` |
| sql | app/services/stats/acquisitions/base.rb:24 | 33.89 | 1.2 | 1.25% | `SELECT COUNT(*) FROM "solicitations" INNER JOIN "landings" ON "landings"."id" =…` |
| sql | app/services/stats/acquisitions/base.rb:32 | 66.4 | 0.6 | 1.22% | `SELECT COUNT(*) FROM "solicitations" WHERE "solicitations"."status" IN (?) AND …` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/Stats::TeamController%23load_data?range=2026-06-23+13%3A28%3A11+UTC..2026-06-24+13%3A28%3A11+UTC)