# Conseiller::OptimisationController#quo_matches

- **Period:** 24 Jun 07:53 UTC – 24 Jun 08:22 UTC
- **Throughput**: 0.1 / min
- **Average:** 790.2 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/models/expert.rb:271 | 16.66 | 20.67 | 43.57% | `SELECT "reminders_registers".* FROM "reminders_registers" WHERE "reminders_regi…` |
| sql | app/helpers/page_infos_helper.rb:13 | 12.33 | 13.0 | 20.29% | `SELECT "needs".* FROM "needs" WHERE "needs"."id" IN (?)))) AND "needs"."status"…` |
| view | app/views/needs/_admin_need.html.haml | 2.35 | 25.0 | 7.42% |  |
| sql | app/controllers/conseiller/optimisation_controller.rb:78 | 57.67 | 1.0 | 7.30% | `SELECT COUNT(*) FROM "needs" WHERE "needs"."id" IN (?)))) AND "needs"."status" …` |
| sql | app/controllers/conseiller/optimisation_controller.rb:80 | 20.33 | 1.0 | 2.57% | `SELECT COUNT(*) FROM "needs" WHERE "needs"."starred_at" IS NOT NULL AND "needs"…` |
| view | app/views/conseiller/optimisation/_filters.html.haml | 18.67 | 1.0 | 2.36% |  |
| sql | app/views/needs/_admin_need.html.haml:1 | 0.69 | 25.0 | 2.19% | `SELECT DISTINCT "experts"."updated_at" FROM "experts" INNER JOIN "matches" ON "…` |
| gc | ruby/gc.c | 17.33 | 1.0 | 2.19% | `GC.start` |
| redis | app/views/needs/_admin_need.html.haml:1 | 0.59 | 29.33 | 2.19% | `get` |
| sql | app/views/needs/_admin_need.html.haml:20 | 0.69 | 13.0 | 1.14% | `SELECT "matches".* FROM "matches" WHERE "matches"."need_id" = ? ORDER BY "match…` |
| code | app/controllers/conseiller/optimisation_controller.rb:16 | 8.0 | 1.0 | 1.01% | `Conseiller::OptimisationController#quo_matches` |

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