# Conseiller::Diagnoses::StepsController#add_match

- **Period:** 23 Jun 06:18 UTC – 24 Jun 06:17 UTC
- **Throughput**: 0.0 / min
- **Average:** 335.7 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| view | app/views/conseiller/diagnoses/steps/matches.html.haml | 140.5 | 1.0 | 41.86% |  |
| sql | app/models/expert.rb:256 | 54.5 | 1.0 | 16.24% | `SELECT "experts"."id" FROM "experts" LEFT OUTER JOIN "antennes" ON "antennes"."…` |
| gc | ruby/gc.c | 41.0 | 1.0 | 12.21% | `GC.start` |
| code | app/controllers/conseiller/diagnoses/steps_controller.rb:67 | 14.25 | 1.0 | 4.25% | `Conseiller::Diagnoses::StepsController#add_match` |
| sql | app/controllers/conseiller/diagnoses/steps_controller.rb:71 | 1.16 | 8.0 | 2.76% | `BEGIN SELECT ? AS one FROM "matches" WHERE "matches"."expert_id" = ? AND "match…` |
| sql | app/services/diagnosis_creation/find_relevant_expert_subjects.rb:36 | 9.25 | 1.0 | 2.76% | `SELECT "experts_subjects".* FROM "experts_subjects" INNER JOIN "experts" ON "ex…` |
| view | app/views/conseiller/diagnoses/steps/_expert_content.html.haml | 2.36 | 2.75 | 1.94% |  |
| sql | app/models/expert_subject.rb:99 | 0.58 | 9.0 | 1.56% | `SELECT "match_filters".* FROM "match_filters" INNER JOIN "experts" ON "match_fi…` |
| sql | app/services/diagnosis_creation/find_relevant_expert_subjects.rb:31 | 0.94 | 4.5 | 1.27% | `SELECT ? AS one FROM "subject_answer_groupings" INNER JOIN "subject_answers" ON…` |
| sql | app/services/diagnosis_creation/find_relevant_expert_subjects.rb:30 | 0.67 | 6.0 | 1.19% | `SELECT "experts".* FROM "experts" WHERE "experts"."id" = ? LIMIT ? SELECT "inst…` |
| sql | app/models/expert.rb:247 | 4.0 | 1.0 | 1.19% | `SELECT "experts"."id" FROM "experts" INNER JOIN "territorial_zones" ON "territo…` |
| view | app/views/conseiller/diagnoses/steps/_expert_subject_checkboxes.html.haml | 3.75 | 1.0 | 1.12% |  |

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