# CompaniesController#needs

- **Period:** 24 Jun 07:07 UTC – 24 Jun 08:06 UTC
- **Throughput**: 0.07 / min
- **Average:** 56.5 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/views/companies/needs.html.haml:19 | 3.38 | 2.0 | 11.95% | `SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "nee…` |
| code | app/controllers/companies_controller.rb:31 | 6.25 | 1.0 | 11.06% | `CompaniesController#needs` |
| sql | app/models/need.rb:470 | 5.0 | 1.0 | 8.85% | `SELECT "solicitations".* FROM "solicitations" INNER JOIN "diagnoses" ON "solici…` |
| view | app/views/companies/_need.haml | 3.5 | 1.0 | 6.19% |  |
| sql | app/policies/facility_policy.rb:4 | 3.0 | 1.0 | 5.31% | `SELECT ? AS one FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_id" =…` |
| sql | app/views/companies/_need.haml:9 | 3.0 | 1.0 | 5.31% | `SELECT "matches".* FROM "matches" INNER JOIN "experts" ON "matches"."expert_id"…` |
| view | app/views/companies/needs.html.haml | 2.25 | 1.0 | 3.98% |  |
| sql | app/views/companies/_need.haml:5 | 1.25 | 1.0 | 2.21% | `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?` |
| sql | app/views/companies/needs.html.haml:9 | 1.25 | 1.0 | 2.21% | `SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_id" …` |
| view | app/views/application/_head.html.haml | 1.25 | 1.0 | 2.21% |  |
| sql | app/controllers/companies_controller.rb:32 | 1.25 | 1.0 | 2.21% | `SELECT "facilities".* FROM "facilities" WHERE "facilities"."id" = ? LIMIT ?` |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104 | 1.0 | 1.0 | 1.77% | `Rack::Attack` |
| sql | app/controllers/companies_controller.rb:41 | 0.5 | 2.0 | 1.77% | `SELECT "companies".* FROM "companies" WHERE "companies"."id" = ? LIMIT ? SELECT…` |
| view | app/views/application/navbar/_admin.html.haml | 1.0 | 1.0 | 1.77% |  |
| gc | ruby/gc.c | 1.0 | 0.75 | 1.33% | `GC.start` |
| queue | queue | 0.75 | 1.0 | 1.33% |  |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/rack/logger.rb:20 | 0.75 | 1.0 | 1.33% | `Rails::Rack::Logger` |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/executor.rb:13 | 0.75 | 1.0 | 1.33% | `ActionDispatch::Executor` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/CompaniesController%23needs?range=1h)