# Conseiller::DiagnosesController#create

- **Period:** 23 Jun 06:15 UTC – 24 Jun 06:14 UTC
- **Throughput**: 0.0 / min
- **Average:** 415.3 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/conseiller/diagnoses_controller.rb:16 | 167.0 | 1.0 | 40.22% | `Conseiller::DiagnosesController#create` |
| sql | app/models/expert.rb:256 | 61.0 | 1.0 | 14.69% | `SELECT "experts"."id" FROM "experts" LEFT OUTER JOIN "antennes" ON "antennes"."…` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:50 | 38.0 | 1.0 | 9.15% | `SELECT "facilities".* FROM "facilities" WHERE "facilities"."siret" = ? LIMIT ?` |
| gc | ruby/gc.c | 28.0 | 1.0 | 6.74% | `GC.start` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:53 | 13.0 | 2.0 | 6.26% | `SELECT ? AS one FROM "facilities" WHERE "facilities"."siret" = ? LIMIT ? INSERT…` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:22 | 7.5 | 2.0 | 3.61% | `BEGIN SELECT "companies".* FROM "companies" WHERE "companies"."siren" = ? LIMIT…` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:25 | 7.5 | 2.0 | 3.61% | `SELECT ? AS one FROM "companies" WHERE "companies"."siren" = ? LIMIT ? INSERT I…` |
| sql | app/services/diagnosis_creation/steps.rb:25 | 2.5 | 4.0 | 2.41% | `INSERT INTO "contacts" ("email", "phone_number", "company_id", "created_at", "u…` |
| sql | app/models/diagnosis.rb:134 | 0.82 | 11.0 | 2.17% | `SELECT "diagnoses".* FROM "diagnoses" INNER JOIN "solicitations" ON "solicitati…` |

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