Place des Entreprises Prod

.MD

Api::V1::SolicitationsController#create

…

Most impactful sections

code87%
sql9%
unknown1%
rack<1%
gc<1%
redis<1%
queue<1%
cache<1%


code app/controllers/api/v1/solicitations_controller.rb:2	87%
Average Self 474ms Average calls 1x Total Self 474ms Total Children 59ms Total runtime 533ms `Api::V1::SolicitationsController#create`
sql app/controllers/api/v1/solicitations_controller.rb:6	8%
Average Self 10ms Average calls 4x Total Self 43ms Total Children 0ms Total runtime 43ms SELECT "landings".* FROM "landings" WHERE "landings"."id" = ? LIMIT ? SELECT "landing_subjects".* FROM "landing_subjects" WHERE "landing_subjects"."id" = ? LIMIT ? INSERT INTO "solicitations" ("description", "email", "phone_number", "form_info", "created_at", "updated_at", "siret", "full_name", "landing_slug", "prepare_diagnosis_errors_details", "requested_help_amount", "location", "code_region", "landing_id", "landing_subject_id", "status", "uuid", "completed_at", "cooperation_id", "provenance_detail", "insee_code") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING "id" COMMIT
gc ruby/gc.c	<1%
Average Self 6.1ms Average calls 0.71x Total Self 4.4ms Total Children 0ms Total runtime 4.4ms `GC.start`
sql app/models/institution.rb:167	<1%
Average Self 0.94ms Average calls 2.4x Total Self 2.3ms Total Children 0ms Total runtime 2.3ms `SELECT ? AS one FROM "categories" INNER JOIN "categories_institutions" ON "categories"."id" = "categories_institutions"."category_id" WHERE "categories_institutions"."institution_id" = ? AND "categories"."id" = ? LIMIT ?`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104	<1%
Average Self 2.2ms Average calls 1x Total Self 2.2ms Total Children 533ms Total runtime 535ms `Rack::Attack`
redis app/services/api.rb:14	<1%
Average Self 0.75ms Average calls 2x Total Self 1.5ms Total Children 0ms Total runtime 1.5ms `get`
sql app/models/solicitation.rb:702	<1%
Average Self 0.64ms Average calls 2x Total Self 1.3ms Total Children 0.07ms Total runtime 1.4ms `BEGIN SELECT "spams".* FROM "spams" WHERE "spams"."email" = ? LIMIT ?`
sql app/serializers/api/v1/solicitation_logo_serializer.rb:7	<1%
Average Self 1.1ms Average calls 1x Total Self 1.1ms Total Children 0ms Total runtime 1.1ms SELECT ? AS one FROM "institutions" INNER JOIN "institutions_subjects" ON "institutions"."id" = "institutions_subjects"."institution_id" INNER JOIN "subjects" ON "institutions_subjects"."subject_id" = "subjects"."id" INNER JOIN "categories_institutions" ON "categories_institutions"."institution_id" = "institutions"."id" INNER JOIN "categories" ON "categories"."id" = "categories_institutions"."category_id" WHERE "subjects"."id" = ? AND "institutions"."deleted_at" IS NULL AND "institutions"."deleted_at" IS NULL AND "categories"."label" = ? LIMIT ?
sql app/serializers/api/v1/solicitation_logo_serializer.rb:5	<1%
Average Self 1.1ms Average calls 1x Total Self 1.1ms Total Children 0ms Total runtime 1.1ms `SELECT ? AS one FROM "institutions" INNER JOIN "institutions_subjects" ON "institutions"."id" = "institutions_subjects"."institution_id" INNER JOIN "subjects" ON "institutions_subjects"."subject_id" = "subjects"."id" INNER JOIN "logos" ON "logos"."logoable_type" = ? AND "logos"."logoable_id" = "institutions"."id" WHERE "subjects"."id" = ? AND "institutions"."deleted_at" IS NULL AND "institutions"."deleted_at" IS NULL AND "institutions"."display_logo_in_partner_list" = ? LIMIT ?`
queue queue	<1%
Average Self 1ms Average calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms
sql app/models/concerns/mandatory_answers.rb:30	<1%
Average Self 0.46ms Average calls 2x Total Self 0.93ms Total Children 0ms Total runtime 0.93ms `SELECT "subjects".* FROM "subjects" INNER JOIN "landing_subjects" ON "subjects"."id" = "landing_subjects"."subject_id" WHERE "landing_subjects"."id" = ? LIMIT ? SELECT "subject_questions"."id" FROM "subject_questions" WHERE "subject_questions"."subject_id" = ?`
sql app/models/institution.rb:166	<1%
Average Self 0.26ms Average calls 2.4x Total Self 0.64ms Total Children 0ms Total runtime 0.64ms `SELECT "categories".* FROM "categories" WHERE "categories"."label" = ? LIMIT ?`
rack /app/vendor/bundle/ruby/4.0.0/gems/warden-1.2.9/lib/warden/manager.rb:30	<1%
Average Self 0.29ms Average calls 1x Total Self 0.29ms Total Children 535ms Total runtime 535ms `Warden::Manager`
rack /app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/rack/logger.rb:20	<1%
Average Self 0.29ms Average calls 1x Total Self 0.29ms Total Children 537ms Total runtime 537ms `Rails::Rack::Logger`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/callbacks.rb:28	<1%
Average Self 0.21ms Average calls 1x Total Self 0.21ms Total Children 536ms Total runtime 536ms `ActionDispatch::Callbacks`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-session-2.1.2/lib/rack/session/abstract/id.rb:267	<1%
Average Self 0.21ms Average calls 1x Total Self 0.21ms Total Children 536ms Total runtime 536ms `ActionDispatch::Session::CookieStore`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/http/content_security_policy.rb:37	<1%
Average Self 0.21ms Average calls 1x Total Self 0.21ms Total Children 536ms Total runtime 536ms `ActionDispatch::ContentSecurityPolicy::Middleware`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-timeout-0.7.0/lib/rack/timeout/core.rb:90	<1%
Average Self 0.21ms Average calls 1x Total Self 0.21ms Total Children 537ms Total runtime 537ms `Rack::Timeout`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/request_id.rb:31	<1%
Average Self 0.14ms Average calls 1x Total Self 0.14ms Total Children 537ms Total runtime 538ms `ActionDispatch::RequestId`
code /app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/engine.rb:532	<1%
Average Self 0.14ms Average calls 1x Total Self 0.14ms Total Children 538ms Total runtime 538ms `Rails::Engine#call`
rack ActionDispatch::Flash	<1%
Average Self 0.14ms Average calls 1x Total Self 0.14ms Total Children 536ms Total runtime 536ms
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/executor.rb:13	<1%
Average Self 0.14ms Average calls 1x Total Self 0.14ms Total Children 538ms Total runtime 538ms `ActionDispatch::Executor`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/show_exceptions.rb:31	<1%
Average Self 0.14ms Average calls 1x Total Self 0.14ms Total Children 536ms Total runtime 537ms `ActionDispatch::ShowExceptions`
cache app/services/api.rb:14	<1%
Average Self 0.07ms Average calls 2x Total Self 0.14ms Total Children 1.5ms Total runtime 1.6ms `read write`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/remote_ip.rb:95	<1%
Average Self 0.14ms Average calls 1x Total Self 0.14ms Total Children 537ms Total runtime 537ms `ActionDispatch::RemoteIp`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/etag.rb:28	<1%
Average Self 0.14ms Average calls 1x Total Self 0.14ms Total Children 535ms Total runtime 535ms `Rack::ETag`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/conditional_get.rb:28	<1%
Average Self 0.14ms Average calls 1x Total Self 0.14ms Total Children 535ms Total runtime 536ms `Rack::ConditionalGet`
sql app/models/api_key.rb:46	<1%
Average Self 0.14ms Average calls 1x Total Self 0.14ms Total Children 0ms Total runtime 0.14ms `SELECT "api_keys".* FROM "api_keys" WHERE "api_keys"."token_digest" = ? LIMIT ?`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/method_override.rb:19	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 538ms Total runtime 538ms `Rack::MethodOverride`
rack /app/vendor/bundle/ruby/4.0.0/gems/ip_anonymizer-0.4.0/lib/ip_anonymizer/mask_ip.rb:7	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 537ms Total runtime 537ms `IpAnonymizer::MaskIp`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/head.rb:14	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 536ms Total runtime 536ms `Rack::Head`
sql app/controllers/api/v1/base_controller.rb:15	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 0ms Total runtime 0.07ms `SELECT "institutions".* FROM "institutions" WHERE "institutions"."id" = ? LIMIT ?`
sql app/models/solicitation.rb:220	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 0ms Total runtime 0.07ms `SELECT "cooperations".* FROM "cooperations" WHERE "cooperations"."id" = ? LIMIT ?`
rack /app/vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 538ms Total runtime 538ms `ActiveSupport::Cache::Strategy::LocalCache::Middleware`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/ssl.rb:88	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 538ms Total runtime 538ms `ActionDispatch::SSL`
rack /app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/rack/silence_request.rb:27	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 537ms Total runtime 537ms `Rails::Rack::SilenceRequest`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/cookies.rb:706	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 536ms Total runtime 536ms `ActionDispatch::Cookies`
sql app/serializers/api/v1/solicitation_logo_serializer.rb:6	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms SELECT "institutions".* FROM "institutions" INNER JOIN "institutions_subjects" ON "institutions"."id" = "institutions_subjects"."institution_id" INNER JOIN "subjects" ON "institutions_subjects"."subject_id" = "subjects"."id" INNER JOIN "logos" ON "logos"."logoable_type" = ? AND "logos"."logoable_id" = "institutions"."id" WHERE "subjects"."id" = ? AND "institutions"."deleted_at" IS NULL AND "institutions"."deleted_at" IS NULL AND "institutions"."display_logo_in_partner_list" = ? ORDER BY "institutions"."name" ASC
rack /app/vendor/bundle/ruby/4.0.0/gems/appsignal-4.8.4/lib/appsignal/rack/abstract_middleware.rb:26	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 536ms Total runtime 536ms `Appsignal::Rack::RailsInstrumentation`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/events.rb:126	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 538ms Total runtime 538ms `Appsignal::Rack::EventMiddleware`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/sendfile.rb:130	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 538ms Total runtime 538ms `Rack::Sendfile`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/debug_exceptions.rb:30	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 536ms Total runtime 536ms `ActionDispatch::DebugExceptions`
sql app/models/concerns/mandatory_answers.rb:17	<1%
Average Self 0ms Average calls 2x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT ? AS one FROM "subject_questions" WHERE "subject_questions"."subject_id" = ? LIMIT ?`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/runtime.rb:22	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 538ms Total runtime 538ms `Rack::Runtime`
rack /app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/static.rb:26	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 538ms Total runtime 538ms `ActionDispatch::Static`
rack /app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/tempfile_reaper.rb:16	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 535ms Total runtime 535ms `Rack::TempfileReaper`

Slowest executions

loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-