# Conseiller::Diagnoses::StepsController#update_matches

- **Period:** 24 Jun 08:10 UTC – 24 Jun 08:24 UTC
- **Throughput**: 1.47 / min
- **Average:** 89.4 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/conseiller/diagnoses/steps_controller.rb:58 | 5.84 | 4.0 | 26.14% | `SELECT "landings".* FROM "landings" WHERE "landings"."id" = ? LIMIT ? SELECT "l…` |
| code | app/controllers/conseiller/diagnoses/steps_controller.rb:49 | 20.27 | 1.0 | 22.68% | `Conseiller::Diagnoses::StepsController#update_matches` |
| sql | app/controllers/conseiller/diagnoses/steps_controller.rb:56 | 1.78 | 6.55 | 13.07% | `BEGIN SELECT "needs".* FROM "needs" WHERE "needs"."diagnosis_id" = ? AND "needs…` |
| sql | app/models/expert.rb:316 | 6.53 | 1.36 | 9.97% | `SELECT COUNT(*) FROM (SELECT ? AS one FROM "matches" WHERE "matches"."expert_id…` |
| sql | app/models/diagnosis.rb:159 | 5.36 | 1.0 | 6.00% | `UPDATE "matches" "__active_record_update_alias" SET "sent_at" = ? FROM "matches…` |
| sql | app/models/concerns/mandatory_answers.rb:30 | 0.67 | 4.41 | 3.31% | `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ? SELECT "s…` |
| sql | app/models/need.rb:465 | 1.55 | 1.0 | 1.73% | `UPDATE "needs" SET "updated_at" = ?, "status" = ? WHERE "needs"."id" = ?` |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104 | 1.05 | 1.0 | 1.17% | `Rack::Attack` |
| queue | queue | 1.05 | 1.0 | 1.17% |  |
| sql | app/models/need.rb:466 | 0.82 | 1.27 | 1.17% | `UPDATE "diagnoses" SET "updated_at" = ? WHERE "diagnoses"."id" = ?` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/Conseiller::Diagnoses::StepsController%23update_matches?range=15m)