# Stats::TeamController#needs

- **Period:** 23 Jun 10:09 UTC – 23 Jun 13:28 UTC
- **Throughput**: 0.01 / min
- **Average:** 466.1 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/stats/team_controller.rb:100 | 357.5 | 1.0 | 76.70% | `SELECT ? AS one FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| gc | ruby/gc.c | 19.0 | 1.0 | 4.08% | `GC.start` |
| sql | app/views/stats/team/_stats_params.haml:57 | 9.5 | 1.0 | 2.04% | `SELECT "landings".* FROM "landings" WHERE "landings"."integration" = ? AND "lan…` |
| code | app/controllers/stats/team_controller.rb:54 | 9.5 | 1.0 | 2.04% | `Stats::TeamController#needs` |
| view | app/views/stats/team/_stats_params.haml | 7.5 | 1.0 | 1.61% |  |
| sql | app/views/stats/team/_stats_params.haml:22 | 7.0 | 1.0 | 1.50% | `SELECT "institutions".* FROM "institutions" INNER JOIN "categories_institutions…` |
| view | app/views/stats/team/_tab.html.haml | 1.63 | 4.0 | 1.39% |  |
| sql | app/views/stats/team/_stats_params.haml:40 | 5.5 | 1.0 | 1.18% | `SELECT "subjects".* FROM "subjects" LEFT OUTER JOIN "themes" ON "themes"."id" =…` |
| sql | app/views/stats/team/_stats_params.haml:63 | 5.5 | 1.0 | 1.18% | `SELECT "landings".* FROM "landings" WHERE "landings"."integration" = ? AND "lan…` |

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