# CompaniesController#needs

- **Period:** 24 Jun 02:06 UTC – 24 Jun 08:05 UTC
- **Throughput**: 0.02 / min
- **Average:** 206.6 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/views/companies/needs.html.haml:19 | 64.17 | 2.0 | 62.12% | `SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "nee…` |
| code | app/controllers/companies_controller.rb:31 | 9.33 | 1.0 | 4.52% | `CompaniesController#needs` |
| view | app/views/companies/needs.html.haml | 8.5 | 1.0 | 4.11% |  |
| sql | app/models/need.rb:470 | 4.2 | 1.67 | 3.39% | `SELECT "solicitations".* FROM "solicitations" INNER JOIN "diagnoses" ON "solici…` |
| view | app/views/companies/_need.haml | 3.1 | 1.67 | 2.50% |  |
| sql | app/views/application/navbar/_app.html.haml:4 | 13.5 | 0.33 | 2.18% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| sql | app/controllers/companies_controller.rb:41 | 1.67 | 2.0 | 1.61% | `SELECT "companies".* FROM "companies" WHERE "companies"."id" = ? LIMIT ? SELECT…` |
| sql | app/views/companies/_need.haml:9 | 1.8 | 1.67 | 1.45% | `SELECT "matches".* FROM "matches" INNER JOIN "experts" ON "matches"."expert_id"…` |
| view | app/views/application/navbar/_app.html.haml | 6.5 | 0.33 | 1.05% |  |

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