# CompaniesController#needs

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

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/views/application/navbar/_app.html.haml:5 | 17.0 | 1.0 | 12.55% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| sql | app/views/application/navbar/_app.html.haml:4 | 14.0 | 1.0 | 10.34% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| code | app/controllers/companies_controller.rb:31 | 13.0 | 1.0 | 9.60% | `CompaniesController#needs` |
| sql | app/views/application/navbar/_app.html.haml:6 | 11.0 | 1.0 | 8.12% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| view | app/views/application/navbar/_app.html.haml | 10.0 | 1.0 | 7.39% |  |
| sql | app/views/companies/needs.html.haml:19 | 4.0 | 2.0 | 5.91% | `SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "nee…` |
| view | app/views/companies/needs.html.haml | 8.0 | 1.0 | 5.91% |  |
| view | app/views/companies/_need.haml | 4.0 | 2.0 | 5.91% |  |
| sql | app/controllers/companies_controller.rb:45 | 7.0 | 1.0 | 5.17% | `SELECT "needs"."id" FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_i…` |
| sql | app/views/companies/_need.haml:9 | 1.0 | 2.0 | 1.48% | `SELECT "matches".* FROM "matches" INNER JOIN "experts" ON "matches"."expert_id"…` |
| sql | app/controllers/companies_controller.rb:49 | 2.0 | 1.0 | 1.48% | `SELECT "needs"."id" FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_i…` |
| sql | app/policies/facility_policy.rb:6 | 2.0 | 1.0 | 1.48% | `SELECT ? AS one FROM "needs" INNER JOIN "matches" ON "needs"."id" = "matches"."…` |

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