# Manager::NeedsController#expired

- **Period:** 23 Jun 06:11 UTC – 24 Jun 06:10 UTC
- **Throughput**: 0.0 / min
- **Average:** 147.9 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/concerns/search_filters.rb:22 | 41.0 | 1.0 | 27.72% | `SELECT DISTINCT "themes".* FROM "themes" INNER JOIN "subjects" ON "subjects"."t…` |
| code | app/controllers/manager/needs_controller.rb:35 | 26.0 | 1.0 | 17.58% | `Manager::NeedsController#expired` |
| sql | app/controllers/concerns/inbox.rb:46 | 3.43 | 7.0 | 16.23% | `SELECT DISTINCT needs.*, matches.sent_at as match_sent_at FROM "needs" INNER JO…` |
| view | app/views/shared/_needs_search.haml | 8.0 | 1.0 | 5.41% |  |
| sql | app/controllers/concerns/inbox.rb:56 | 1.4 | 5.0 | 4.73% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| view | app/views/application/navbar/_app.html.haml | 5.0 | 1.0 | 3.38% |  |
| sql | app/models/subject.rb:127 | 0.19 | 16.0 | 2.03% | `SELECT ? AS one FROM "cooperations" INNER JOIN "cooperation_themes" ON "coopera…` |
| sql | app/controllers/concerns/search_filters.rb:6 | 1.0 | 2.0 | 1.35% | `SELECT "subjects".* FROM "subjects" WHERE "subjects"."theme_id" IN (?) AND "sub…` |
| view | app/views/application/_head.html.haml | 2.0 | 1.0 | 1.35% |  |

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