# Conseiller::DiagnosesController#create

- **Period:** 23 Jun 13:28 UTC – 24 Jun 13:06 UTC
- **Throughput**: 0.0 / min
- **Average:** 505.8 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/conseiller/diagnoses_controller.rb:16 | 233.0 | 1.0 | 46.07% | `Conseiller::DiagnosesController#create` |
| gc | ruby/gc.c | 42.33 | 1.5 | 12.55% | `GC.start` |
| sql | app/models/expert.rb:256 | 51.0 | 1.0 | 10.08% | `SELECT "experts"."id" FROM "experts" LEFT OUTER JOIN "antennes" ON "antennes"."…` |
| sql | app/services/diagnosis_creation/steps.rb:45 | 2.67 | 6.0 | 3.16% | `SELECT "subject_questions".* FROM "subject_questions" WHERE "subject_questions"…` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:53 | 14.5 | 1.0 | 2.87% | `SELECT ? AS one FROM "facilities" WHERE "facilities"."siret" = ? LIMIT ? INSERT…` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:50 | 26.0 | 0.5 | 2.57% | `SELECT "facilities".* FROM "facilities" WHERE "facilities"."siret" = ? LIMIT ?` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:22 | 10.5 | 1.0 | 2.08% | `BEGIN SELECT "companies".* FROM "companies" WHERE "companies"."siren" = ? LIMIT…` |
| sql | app/services/diagnosis_creation/create_matches.rb:16 | 1.0 | 9.0 | 1.78% | `BEGIN SELECT ? AS one FROM "matches" WHERE "matches"."expert_id" = ? AND "match…` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:25 | 8.0 | 1.0 | 1.58% | `SELECT ? AS one FROM "companies" WHERE "companies"."siren" = ? LIMIT ? INSERT I…` |
| sql | app/models/expert.rb:247 | 8.0 | 1.0 | 1.58% | `SELECT "experts"."id" FROM "experts" INNER JOIN "territorial_zones" ON "territo…` |
| sql | app/services/diagnosis_creation/find_relevant_expert_subjects.rb:36 | 7.0 | 1.0 | 1.38% | `SELECT "experts_subjects".* FROM "experts_subjects" INNER JOIN "experts" ON "ex…` |
| sql | app/models/expert_subject.rb:99 | 0.72 | 9.0 | 1.29% | `SELECT "match_filters".* FROM "match_filters" INNER JOIN "experts" ON "match_fi…` |
| sql | app/models/diagnosis.rb:134 | 0.48 | 12.5 | 1.19% | `SELECT "diagnoses".* FROM "diagnoses" INNER JOIN "solicitations" ON "solicitati…` |

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