# CompaniesController#needs

- **Period:** 23 Jun 13:28 UTC – 24 Jun 13:03 UTC
- **Throughput**: 0.01 / min
- **Average:** 109.3 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/views/companies/needs.html.haml:19 | 20.81 | 2.0 | 38.07% | `SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "nee…` |
| code | app/controllers/companies_controller.rb:31 | 8.29 | 1.0 | 7.58% | `CompaniesController#needs` |
| view | app/views/companies/_need.haml | 3.15 | 1.57 | 4.53% |  |
| view | app/views/companies/needs.html.haml | 4.57 | 1.0 | 4.18% |  |
| sql | app/models/need.rb:470 | 2.88 | 1.57 | 4.14% | `SELECT "solicitations".* FROM "solicitations" INNER JOIN "diagnoses" ON "solici…` |
| sql | app/views/companies/_need.haml:9 | 2.3 | 1.57 | 3.31% | `SELECT "matches".* FROM "matches" INNER JOIN "experts" ON "matches"."expert_id"…` |
| sql | app/views/application/navbar/_app.html.haml:4 | 14.0 | 0.24 | 3.05% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| sql | app/controllers/companies_controller.rb:41 | 1.05 | 2.0 | 1.92% | `SELECT "companies".* FROM "companies" WHERE "companies"."id" = ? LIMIT ? SELECT…` |
| gc | ruby/gc.c | 2.93 | 0.67 | 1.79% | `GC.start` |
| sql | app/policies/facility_policy.rb:4 | 2.5 | 0.76 | 1.74% | `SELECT ? AS one FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_id" =…` |
| view | app/views/application/navbar/_app.html.haml | 7.6 | 0.24 | 1.66% |  |
| view | app/views/application/_head.html.haml | 1.48 | 1.0 | 1.35% |  |
| sql | app/views/application/navbar/_app.html.haml:5 | 13.0 | 0.1 | 1.13% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |

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