# NeedsController#show

- **Period:** 23 Jun 06:12 UTC – 24 Jun 06:11 UTC
- **Throughput**: 5.39 / min
- **Average:** 73.5 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/views/application/navbar/_app.html.haml:4 | 13.3 | 0.48 | 8.67% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| view | app/views/needs/show.html.haml | 9.63 | 0.5 | 6.61% |  |
| code | app/controllers/needs_controller.rb:52 | 4.72 | 1.0 | 6.43% | `NeedsController#show` |
| queue | queue | 4.65 | 1.0 | 6.32% |  |
| view | app/views/matches/_match.haml | 3.45 | 1.26 | 5.90% |  |
| sql | app/views/needs/show.html.haml:75 | 6.62 | 0.48 | 4.29% | `SELECT ? AS one FROM "needs" INNER JOIN "diagnoses" ON "diagnoses"."id" = "need…` |
| gc | ruby/gc.c | 5.03 | 0.58 | 3.97% | `GC.start` |
| view | app/views/application/navbar/_app.html.haml | 5.4 | 0.49 | 3.61% |  |
| sql | app/models/expert.rb:295 | 1.85 | 1.26 | 3.16% | `SELECT COUNT(*) FROM "users" INNER JOIN "experts_users" ON "users"."id" = "expe…` |
| sql | app/views/needs/show.html.haml:73 | 3.61 | 0.5 | 2.48% | `SELECT ? AS one FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_id" =…` |
| sql | app/views/needs/show.html.haml:115 | 3.32 | 0.5 | 2.28% | `SELECT "feedbacks".* FROM "feedbacks" WHERE "feedbacks"."feedbackable_id" = ? A…` |
| sql | app/helpers/experts_helper.rb:11 | 1.16 | 1.26 | 1.98% | `SELECT "users".* FROM "users" INNER JOIN "experts_users" ON "users"."id" = "exp…` |
| sql | vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158 | 2.09 | 0.66 | 1.88% | `SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC …` |
| sql | app/policies/need_policy.rb:20 | 2.58 | 0.49 | 1.73% | `SELECT ? AS one FROM "needs" INNER JOIN "matches" ON "needs"."id" = "matches"."…` |
| sql | app/controllers/needs_controller.rb:65 | 1.22 | 1.01 | 1.68% | `SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ? SELECT…` |
| sql | app/models/user.rb:326 | 0.11 | 10.31 | 1.60% | `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_…` |
| sql | app/views/needs/show.html.haml:16 | 2.28 | 0.5 | 1.56% | `SELECT ? AS one FROM "subject_answers" WHERE "subject_answers"."type" = ? AND "…` |
| sql | app/views/application/navbar/_app.html.haml:13 | 2.1 | 0.49 | 1.40% | `SELECT COUNT(*) FROM "shared_satisfactions" WHERE "shared_satisfactions"."user_…` |
| view | app/views/feedbacks/_feedback.haml | 1.4 | 0.64 | 1.22% |  |
| sql | app/views/matches/_match.haml:1 | 0.69 | 1.26 | 1.17% | `SELECT "experts".* FROM "experts" WHERE "experts"."id" = ? LIMIT ?` |
| sql | app/models/need.rb:470 | 1.52 | 0.5 | 1.04% | `SELECT "solicitations".* FROM "solicitations" INNER JOIN "diagnoses" ON "solici…` |
| view | app/views/application/_person_modal.html.haml | 0.32 | 2.4 | 1.04% |  |

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