# NeedsController#show

- **Period:** 24 Jun 03:14 UTC – 24 Jun 06:13 UTC
- **Throughput**: 1.71 / min
- **Average:** 57.6 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/views/application/navbar/_app.html.haml:4 | 13.86 | 0.45 | 10.82% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| view | app/views/needs/show.html.haml | 9.57 | 0.45 | 7.47% |  |
| code | app/controllers/needs_controller.rb:52 | 4.05 | 1.0 | 7.03% | `NeedsController#show` |
| gc | ruby/gc.c | 3.78 | 0.66 | 4.32% | `GC.start` |
| view | app/views/matches/_match.haml | 3.15 | 0.78 | 4.27% |  |
| sql | app/views/needs/show.html.haml:75 | 5.99 | 0.39 | 4.07% | `SELECT ? AS one FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| view | app/views/application/navbar/_app.html.haml | 5.1 | 0.45 | 3.98% |  |
| queue | queue | 2.15 | 1.0 | 3.74% |  |
| sql | app/views/needs/show.html.haml:73 | 2.85 | 0.45 | 2.22% | `SELECT ? AS one FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_id" =…` |
| sql | app/policies/need_policy.rb:20 | 2.81 | 0.45 | 2.19% | `SELECT ? AS one FROM "needs" INNER JOIN "matches" ON "needs"."id" = "matches"."…` |
| sql | app/views/needs/show.html.haml:115 | 2.56 | 0.45 | 2.00% | `SELECT "feedbacks".* FROM "feedbacks" WHERE "feedbacks"."feedbackable_id" = ? A…` |
| sql | app/controllers/needs_controller.rb:65 | 1.28 | 0.9 | 1.99% | `SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ? SELECT…` |
| sql | app/models/expert.rb:295 | 1.4 | 0.78 | 1.90% | `SELECT COUNT(*) FROM "users" INNER JOIN "experts_users" ON "users"."id" = "expe…` |
| sql | app/models/user.rb:326 | 0.12 | 8.19 | 1.67% | `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_…` |
| view | app/views/needs/_match_actions.html.haml | 2.14 | 0.45 | 1.67% |  |
| sql | app/helpers/experts_helper.rb:11 | 1.18 | 0.78 | 1.60% | `SELECT "users".* FROM "users" INNER JOIN "experts_users" ON "users"."id" = "exp…` |
| sql | app/views/needs/show.html.haml:16 | 1.66 | 0.45 | 1.30% | `SELECT ? AS one FROM "subject_answers" WHERE "subject_answers"."type" = ? AND "…` |
| sql | app/policies/need_policy.rb:19 | 0.78 | 0.9 | 1.21% | `SELECT "antennes".* FROM "antennes" INNER JOIN "users" ON "antennes"."id" = "us…` |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104 | 0.68 | 1.0 | 1.18% | `Rack::Attack` |

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