# CompaniesController#needs

- **Period:** 23 Jun 06:08 UTC – 24 Jun 06:07 UTC
- **Throughput**: 0.01 / min
- **Average:** 63.8 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/views/companies/needs.html.haml:19 | 4.6 | 1.9 | 13.74% | `SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "nee…` |
| code | app/controllers/companies_controller.rb:31 | 6.95 | 1.0 | 10.90% | `CompaniesController#needs` |
| view | app/views/companies/_need.haml | 3.14 | 1.38 | 6.80% |  |
| sql | app/models/need.rb:470 | 3.07 | 1.38 | 6.65% | `SELECT "solicitations".* FROM "solicitations" INNER JOIN "diagnoses" ON "solici…` |
| view | app/views/companies/needs.html.haml | 2.9 | 0.95 | 4.33% |  |
| sql | app/views/companies/_need.haml:9 | 1.76 | 1.38 | 3.81% | `SELECT "matches".* FROM "matches" INNER JOIN "experts" ON "matches"."expert_id"…` |
| sql | app/views/application/navbar/_app.html.haml:4 | 11.0 | 0.14 | 2.46% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| sql | app/controllers/companies_controller.rb:41 | 0.75 | 1.9 | 2.24% | `SELECT "companies".* FROM "companies" WHERE "companies"."id" = ? LIMIT ? SELECT…` |
| sql | app/policies/facility_policy.rb:4 | 1.76 | 0.81 | 2.24% | `SELECT ? AS one FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_id" =…` |
| sql | app/views/application/navbar/_app.html.haml:5 | 14.5 | 0.1 | 2.17% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| view | app/views/application/navbar/_app.html.haml | 9.33 | 0.14 | 2.09% |  |
| queue | queue | 1.19 | 1.0 | 1.87% |  |
| view | app/views/application/_head.html.haml | 1.25 | 0.95 | 1.87% |  |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104 | 0.95 | 1.0 | 1.49% | `Rack::Attack` |
| sql | app/views/application/navbar/_app.html.haml:6 | 9.5 | 0.1 | 1.42% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| view | app/views/application/_navbar.html.haml | 0.9 | 0.95 | 1.34% |  |
| sql | vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158 | 0.9 | 0.95 | 1.34% | `SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC …` |
| view | app/views/application/navbar/_admin.html.haml | 1.0 | 0.81 | 1.27% |  |
| sql | app/controllers/companies_controller.rb:49 | 0.85 | 0.95 | 1.27% | `SELECT "needs"."id" FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_i…` |
| sql | app/controllers/companies_controller.rb:45 | 0.8 | 0.95 | 1.19% | `SELECT "needs"."id" FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_i…` |

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