# Conseiller::SharedSatisfactionsController#unseen

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

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/views/conseiller/shared_satisfactions/index.html.haml:10 | 30.38 | 1.64 | 26.10% | `SELECT DISTINCT "needs"."created_at" AS alias_0, "needs"."id" FROM "needs" INNE…` |
| sql | app/controllers/concerns/search_filters.rb:22 | 22.38 | 1.0 | 11.73% | `SELECT DISTINCT "themes".* FROM "themes" INNER JOIN "subjects" ON "subjects"."t…` |
| view | app/views/conseiller/shared_satisfactions/index.html.haml | 13.42 | 1.0 | 7.03% |  |
| code | app/controllers/conseiller/shared_satisfactions_controller.rb:17 | 10.98 | 1.0 | 5.75% | `Conseiller::SharedSatisfactionsController#unseen` |
| view | app/views/conseiller/shared_satisfactions/_need.haml | 1.26 | 7.08 | 4.66% |  |
| sql | app/views/conseiller/shared_satisfactions/_need_card.haml:14 | 5.16 | 1.46 | 3.95% | `SELECT "contacts".* FROM "contacts" INNER JOIN "diagnoses" ON "contacts"."id" =…` |
| view | app/views/application/navbar/_app.html.haml | 7.08 | 1.0 | 3.71% |  |
| gc | ruby/gc.c | 8.29 | 0.7 | 3.04% | `GC.start` |
| sql | app/views/conseiller/shared_satisfactions/_need.haml:1 | 0.77 | 7.08 | 2.84% | `SELECT "shared_satisfactions".* FROM "shared_satisfactions" INNER JOIN "company…` |
| redis | app/views/conseiller/shared_satisfactions/_need.haml:1 | 0.63 | 8.54 | 2.80% | `get` |
| sql | app/models/need.rb:470 | 3.25 | 1.46 | 2.48% | `SELECT "solicitations".* FROM "solicitations" INNER JOIN "diagnoses" ON "solici…` |
| sql | app/controllers/conseiller/shared_satisfactions_controller.rb:77 | 2.09 | 2.0 | 2.19% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "company_satisfacti…` |
| sql | app/views/application/navbar/_app.html.haml:4 | 4.13 | 0.94 | 2.03% | `SELECT COUNT(DISTINCT "needs"."id") FROM "needs" INNER JOIN "matches" ON "needs…` |
| view | app/views/conseiller/shared_satisfactions/_need_card.haml | 2.44 | 1.46 | 1.87% |  |

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