# Conseiller::DiagnosesController#create

- **Period:** 24 Jun 07:49 UTC – 24 Jun 08:18 UTC
- **Throughput**: 0.03 / min
- **Average:** 487.9 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/conseiller/diagnoses_controller.rb:16 | 198.0 | 1.0 | 40.58% | `Conseiller::DiagnosesController#create` |
| gc | ruby/gc.c | 34.5 | 2.0 | 14.14% | `GC.start` |
| sql | app/models/expert.rb:256 | 51.0 | 1.0 | 10.45% | `SELECT "experts"."id" FROM "experts" LEFT OUTER JOIN "antennes" ON "antennes"."…` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:53 | 14.5 | 2.0 | 5.94% | `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 | 1.0 | 5.33% | `SELECT "facilities".* FROM "facilities" WHERE "facilities"."siret" = ? LIMIT ?` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:22 | 10.5 | 2.0 | 4.30% | `BEGIN SELECT "companies".* FROM "companies" WHERE "companies"."siren" = ? LIMIT…` |
| sql | app/services/diagnosis_creation/create_or_update_facility_and_company.rb:25 | 8.0 | 2.0 | 3.28% | `SELECT ? AS one FROM "companies" WHERE "companies"."siren" = ? LIMIT ? INSERT I…` |
| sql | app/models/expert.rb:247 | 10.0 | 1.0 | 2.05% | `SELECT "experts"."id" FROM "experts" INNER JOIN "territorial_zones" ON "territo…` |
| sql | app/services/diagnosis_creation/steps.rb:25 | 1.75 | 4.0 | 1.43% | `INSERT INTO "contacts" ("email", "phone_number", "company_id", "created_at", "u…` |
| sql | app/models/diagnosis.rb:134 | 0.55 | 11.0 | 1.23% | `SELECT "diagnoses".* FROM "diagnoses" INNER JOIN "solicitations" ON "solicitati…` |
| sql | app/services/diagnosis_creation/steps.rb:40 | 1.0 | 5.0 | 1.02% | `SELECT ? AS one FROM "needs" WHERE "needs"."subject_id" = ? AND "needs"."diagno…` |

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