# NeedsController#expired

- **Period:** 23 Jun 10:09 UTC – 23 Jun 13:28 UTC
- **Throughput**: 0.01 / min
- **Average:** 336.3 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/concerns/inbox.rb:28 | 18.43 | 7.0 | 38.36% | `SELECT DISTINCT needs.*, matches.sent_at as match_sent_at FROM "needs" INNER JO…` |
| sql | app/controllers/concerns/search_filters.rb:22 | 89.0 | 1.0 | 26.46% | `SELECT DISTINCT "themes".* FROM "themes" INNER JOIN "subjects" ON "subjects"."t…` |
| sql | app/controllers/concerns/inbox.rb:51 | 4.0 | 5.0 | 5.95% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| code | app/controllers/needs_controller.rb:45 | 18.0 | 1.0 | 5.35% | `NeedsController#expired` |
| redis | app/views/application/navbar/_app.html.haml:4 | 7.0 | 1.0 | 2.08% | `get` |
| view | app/views/application/navbar/_app.html.haml | 7.0 | 1.0 | 2.08% |  |
| sql | app/views/application/navbar/_app.html.haml:4 | 6.0 | 1.0 | 1.78% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| sql | app/models/user.rb:326 | 0.5 | 8.0 | 1.19% | `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_…` |
| sql | app/views/application/navbar/_app.html.haml:2 | 4.0 | 1.0 | 1.19% | `SELECT "experts".* FROM "experts" INNER JOIN "experts_users" ON "experts"."id" …` |
| redis | app/views/needs/_received_needs.haml:4 | 4.0 | 1.0 | 1.19% | `mget` |
| sql | app/policies/need_policy.rb:13 | 4.0 | 1.0 | 1.19% | `SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?` |
| sql | app/models/user.rb:318 | 4.0 | 1.0 | 1.19% | `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_…` |
| sql | app/models/user.rb:310 | 1.0 | 4.0 | 1.19% | `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_…` |
| sql | app/models/user.rb:314 | 2.0 | 2.0 | 1.19% | `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_…` |

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