# Conseiller::SolicitationsController#update_badges

- **Period:** 24 Jun 05:20 UTC – 24 Jun 08:19 UTC
- **Throughput**: 0.02 / min
- **Average:** 57.6 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/conseiller/solicitations_controller.rb:68 | 18.0 | 1.0 | 31.23% | `Conseiller::SolicitationsController#update_badges` |
| sql | app/models/solicitation.rb:245 | 12.0 | 1.0 | 20.82% | `UPDATE "solicitations" SET "updated_at" = ? WHERE "solicitations"."id" = ?` |
| sql | app/controllers/conseiller/solicitations_controller.rb:71 | 1.06 | 6.0 | 10.99% | `BEGIN SELECT "badges".* FROM "badges" WHERE "badges"."id" = ? SELECT "badges".*…` |
| view | app/views/conseiller/solicitations/update_badges.js.haml | 3.33 | 1.0 | 5.78% |  |
| sql | app/models/concerns/mandatory_answers.rb:30 | 0.47 | 5.0 | 4.05% | `SELECT "subjects".* FROM "subjects" INNER JOIN "landing_subjects" ON "subjects"…` |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28 | 1.33 | 1.0 | 2.31% | `ActiveSupport::Cache::Strategy::LocalCache::Middleware` |
| queue | queue | 1.33 | 1.0 | 2.31% |  |
| rack | /app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104 | 1.0 | 1.0 | 1.74% | `Rack::Attack` |
| sql | vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158 | 1.0 | 1.0 | 1.74% | `SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC …` |
| sql | app/controllers/conseiller/solicitations_controller.rb:70 | 0.43 | 2.33 | 1.74% | `SELECT "subject_answers".* FROM "subject_answers" WHERE "subject_answers"."type…` |
| gc | ruby/gc.c | 1.0 | 0.67 | 1.16% | `GC.start` |
| sql | app/models/concerns/mandatory_answers.rb:17 | 0.2 | 3.33 | 1.16% | `SELECT ? AS one FROM "subject_questions" WHERE "subject_questions"."subject_id"…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135976/requests/Conseiller::SolicitationsController%23update_badges?range=3h)