# Conseiller::OptimisationController#index

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

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/conseiller/optimisation_controller.rb:78 | 632.0 | 1.0 | 86.66% | `SELECT COUNT(*) FROM "needs" WHERE "needs"."id" IN (?)))) AND "needs"."status" …` |
| sql | app/controllers/conseiller/optimisation_controller.rb:80 | 65.0 | 1.0 | 8.91% | `SELECT COUNT(*) FROM "needs" WHERE "needs"."starred_at" IS NOT NULL AND "needs"…` |
| code | app/controllers/conseiller/optimisation_controller.rb:12 | 8.5 | 1.0 | 1.17% | `Conseiller::OptimisationController#index` |
| sql | app/controllers/conseiller/optimisation_controller.rb:79 | 8.0 | 1.0 | 1.10% | `SELECT DISTINCT "experts".* FROM "experts" INNER JOIN "matches" ON "matches"."s…` |

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