# Conseiller::SharedSatisfactionsController#unseen

- **Period:** 24 Jun 05:20 UTC – 24 Jun 08:19 UTC
- **Throughput**: 0.13 / min
- **Average:** 236.7 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/views/conseiller/shared_satisfactions/index.html.haml:10 | 51.03 | 1.74 | 37.49% | `SELECT DISTINCT "needs"."created_at" AS alias_0, "needs"."id" FROM "needs" INNE…` |
| view | app/views/conseiller/shared_satisfactions/index.html.haml | 27.57 | 1.0 | 11.65% |  |
| sql | app/controllers/concerns/search_filters.rb:22 | 24.35 | 1.0 | 10.29% | `SELECT DISTINCT "themes".* FROM "themes" INNER JOIN "subjects" ON "subjects"."t…` |
| view | app/views/conseiller/shared_satisfactions/_need.haml | 0.93 | 11.17 | 4.41% |  |
| code | app/controllers/conseiller/shared_satisfactions_controller.rb:17 | 10.04 | 1.0 | 4.24% | `Conseiller::SharedSatisfactionsController#unseen` |
| gc | ruby/gc.c | 11.53 | 0.65 | 3.18% | `GC.start` |
| sql | app/views/conseiller/shared_satisfactions/_need.haml:1 | 0.65 | 11.17 | 3.05% | `SELECT "shared_satisfactions".* FROM "shared_satisfactions" INNER JOIN "company…` |
| view | app/views/application/navbar/_app.html.haml | 6.91 | 1.0 | 2.92% |  |
| redis | app/views/conseiller/shared_satisfactions/_need.haml:1 | 0.5 | 11.39 | 2.39% | `get` |
| sql | app/controllers/conseiller/shared_satisfactions_controller.rb:77 | 2.0 | 2.0 | 1.69% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "company_satisfacti…` |
| sql | app/views/application/navbar/_app.html.haml:4 | 3.74 | 1.0 | 1.58% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |

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