# Annuaire::UsersController#create_territorial_coverage

- **Period:** 24 Jun 07:19 UTC – 24 Jun 08:18 UTC
- **Throughput**: 0.02 / min
- **Average:** 70.9 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/annuaire/users_controller.rb:66 | 31.0 | 1.0 | 43.70% | `Annuaire::UsersController#create_territorial_coverage` |
| sql | app/models/concerns/with_territorial_zones.rb:27 | 2.0 | 2.0 | 5.64% | `SELECT "territorial_zones"."id" FROM "territorial_zones" WHERE "territorial_zon…` |
| sql | app/controllers/annuaire/users_controller.rb:148 | 0.75 | 4.0 | 4.23% | `SELECT experts.*, antennes.name as antenne_name FROM "experts" INNER JOIN "ante…` |
| sql | app/services/create_territorial_coverage.rb:54 | 0.5 | 4.0 | 2.82% | `SELECT "experts".* FROM "experts" INNER JOIN "experts_subjects" ON "experts"."i…` |
| sql | app/controllers/annuaire/users_controller.rb:99 | 0.5 | 4.0 | 2.82% | `SELECT ? AS one FROM "experts" INNER JOIN "experts_users" ON "experts"."id" = "…` |
| sql | app/services/create_territorial_coverage.rb:32 | 0.5 | 2.0 | 1.41% | `SELECT DISTINCT "experts".* FROM "experts" INNER JOIN "experts_subjects" ON "ex…` |
| sql | app/services/create_territorial_coverage.rb:73 | 1.0 | 1.0 | 1.41% | `SELECT "experts"."id" AS t0_r0, "experts"."email" AS t0_r1, "experts"."phone_nu…` |
| redis | app/models/concerns/with_territorial_zones.rb:29 | 0.33 | 3.0 | 1.41% | `get` |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/rack-timeout-0.7.0/lib/rack/timeout/core.rb:90 | 1.0 | 1.0 | 1.41% | `Rack::Timeout` |
| sql | app/models/expert.rb:147 | 1.0 | 1.0 | 1.41% | `SELECT "experts"."id" FROM "experts" INNER JOIN "experts_subjects" ON "experts"…` |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/appsignal-4.8.4/lib/appsignal/rack/abstract_middleware.rb:26 | 1.0 | 1.0 | 1.41% | `Appsignal::Rack::RailsInstrumentation` |
| sql | app/services/create_territorial_coverage.rb:290 | 0.5 | 2.0 | 1.41% | `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ? SELECT ? …` |
| sql | vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158 | 1.0 | 1.0 | 1.41% | `SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC …` |
| sql | app/controllers/annuaire/users_controller.rb:98 | 1.0 | 1.0 | 1.41% | `SELECT DISTINCT "users".* FROM "users" INNER JOIN "user_rights" ON "users"."id"…` |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104 | 1.0 | 1.0 | 1.41% | `Rack::Attack` |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/conditional_get.rb:28 | 1.0 | 1.0 | 1.41% | `Rack::ConditionalGet` |
| redis | app/controllers/annuaire/users_controller.rb:68 | 0.5 | 2.0 | 1.41% | `get` |
| sql | app/services/create_territorial_coverage.rb:23 | 0.5 | 2.0 | 1.41% | `SELECT "themes".* FROM "themes" INNER JOIN "subjects" ON "themes"."id" = "subje…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/Annuaire::UsersController%23create_territorial_coverage?range=1h)