# Conseiller::OptimisationController#quo_matches

- **Period:** 24 Jun 02:14 UTC – 24 Jun 08:13 UTC
- **Throughput**: 0.01 / min
- **Average:** 1029.8 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/models/expert.rb:271 | 16.66 | 31.0 | 50.15% | `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_regi…` |
| sql | app/helpers/page_infos_helper.rb:13 | 14.04 | 13.0 | 17.72% | `SELECT "needs".* FROM "needs" WHERE "needs"."id" IN (?)))) AND "needs"."status"…` |
| view | app/views/needs/_admin_need.html.haml | 3.04 | 25.0 | 7.38% |  |
| sql | app/controllers/conseiller/optimisation_controller.rb:78 | 59.0 | 1.0 | 5.73% | `SELECT COUNT(*) FROM "needs" WHERE "needs"."id" IN (?)))) AND "needs"."status" …` |
| gc | ruby/gc.c | 23.0 | 1.0 | 2.23% | `GC.start` |
| sql | app/controllers/conseiller/optimisation_controller.rb:80 | 21.0 | 1.0 | 2.04% | `SELECT COUNT(*) FROM "needs" WHERE "needs"."starred_at" IS NOT NULL AND "needs"…` |
| view | app/views/conseiller/optimisation/_filters.html.haml | 20.0 | 1.0 | 1.94% |  |
| redis | app/views/needs/_admin_need.html.haml:1 | 0.62 | 31.5 | 1.89% | `get` |
| sql | app/views/needs/_admin_need.html.haml:1 | 0.74 | 25.0 | 1.80% | `SELECT DISTINCT "experts"."updated_at" FROM "experts" INNER JOIN "matches" ON "…` |
| sql | app/views/needs/_admin_need.html.haml:20 | 0.69 | 19.5 | 1.31% | `SELECT "matches".* FROM "matches" WHERE "matches"."need_id" = ? ORDER BY "match…` |
| view | app/views/reminders/_needs_badges.html.haml | 1.77 | 6.5 | 1.12% |  |

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