|
view
app/views/conseiller/diagnoses/steps/matches.html.haml
|
42%
|
app/views/conseiller/diagnoses/steps/matches.html.haml
- Average Self
-
140ms
- Average calls
- 1x
- Total Self
- 140ms
- Total Children
- 120ms
- Total runtime
- 261ms
|
|
sql
app/models/expert.rb:256
|
16%
|
app/models/expert.rb:256
- Average Self
-
54ms
- Average calls
- 1x
- Total Self
- 54ms
- Total Children
- 0ms
- Total runtime
- 54ms
SELECT "experts"."id" FROM "experts" LEFT OUTER JOIN "antennes" ON "antennes"."id" = "experts"."antenne_id" LEFT OUTER JOIN "territorial_zones" ON "territorial_zones"."zoneable_type" = ? AND "territorial_zones"."zoneable_id" = "antennes"."id" WHERE "experts"."id" NOT IN (?) AND ("territorial_zones"."zone_type" = ? AND "territorial_zones"."code" = ? OR "territorial_zones"."zone_type" = ? AND "territorial_zones"."code" = ? OR "territorial_zones"."zone_type" = ? AND "territorial_zones"."code" = ? OR "territorial_zones"."zone_type" = ? AND "territorial_zones"."code" = ? OR "antennes"."territorial_level" = ?)
|
|
gc
ruby/gc.c
|
12%
|
ruby/gc.c
- Average Self
-
41ms
- Average calls
- 1x
- Total Self
- 41ms
- Total Children
- 0ms
- Total runtime
- 41ms
GC.start
|
|
code
app/controllers/conseiller/diagnoses/steps_controller.rb:67
|
4%
|
app/controllers/conseiller/diagnoses/steps_controller.rb:67
- Average Self
-
14ms
- Average calls
- 1x
- Total Self
- 14ms
- Total Children
- 275ms
- Total runtime
- 289ms
Conseiller::Diagnoses::StepsController#add_match
|
|
sql
app/controllers/conseiller/diagnoses/steps_controller.rb:71
|
3%
|
app/controllers/conseiller/diagnoses/steps_controller.rb:71
- Average Self
-
1.2ms
- Average calls
- 8x
- Total Self
- 9.3ms
- Total Children
- 0ms
- Total runtime
- 9.3ms
BEGIN
SELECT ? AS one FROM "matches" WHERE "matches"."expert_id" = ? AND "matches"."need_id" = ? LIMIT ?
INSERT INTO "matches" ("need_id", "created_at", "updated_at", "taken_care_of_at", "closed_at", "expert_id", "subject_id", "status", "archived_at", "sent_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING "id"
UPDATE "needs" SET "matches_count" = COALESCE("needs"."matches_count", ?) + ?, "updated_at" = ? WHERE "needs"."id" = ?
SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ?
SELECT "solicitations".* FROM "solicitations" WHERE "solicitations"."id" = ? LIMIT ?
UPDATE "solicitations" SET "updated_at" = ? WHERE "solicitations"."id" = ?
COMMIT
|
|
sql
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:36
|
3%
|
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:36
- Average Self
-
9.3ms
- Average calls
- 1x
- Total Self
- 9.3ms
- Total Children
- 0ms
- Total runtime
- 9.3ms
SELECT "experts_subjects".* FROM "experts_subjects" INNER JOIN "experts" ON "experts"."deleted_at" IS NULL AND "experts"."id" = "experts_subjects"."expert_id" INNER JOIN "institutions_subjects" ON "institutions_subjects"."id" = "experts_subjects"."institution_subject_id" INNER JOIN "institutions" ON "institutions"."id" = "institutions_subjects"."institution_id" WHERE "experts_subjects"."expert_id" IN (?) OR "experts"."id" IN (?))) AND "institutions_subjects"."subject_id" = ? AND "institutions_subjects"."institution_id" IN (?) AND "institutions_subjects"."institution_id" NOT IN (?)
|
|
view
app/views/conseiller/diagnoses/steps/_expert_content.html.haml
|
2%
|
app/views/conseiller/diagnoses/steps/_expert_content.html.haml
- Average Self
-
2.4ms
- Average calls
- 2.8x
- Total Self
- 6.5ms
- Total Children
- 7.5ms
- Total runtime
- 14ms
|
|
sql
app/models/expert_subject.rb:99
|
2%
|
app/models/expert_subject.rb:99
- Average Self
-
0.58ms
- Average calls
- 9x
- Total Self
- 5.3ms
- Total Children
- 0ms
- Total runtime
- 5.3ms
SELECT "match_filters".* FROM "match_filters" INNER JOIN "experts" ON "match_filters"."filtrable_element_id" = "experts"."id" WHERE "experts"."id" = ? AND "match_filters"."filtrable_element_type" = ?
SELECT "match_filters".* FROM "match_filters" INNER JOIN "antennes" ON "match_filters"."filtrable_element_id" = "antennes"."id" INNER JOIN "experts" ON "antennes"."id" = "experts"."antenne_id" WHERE "experts"."id" = ? AND "match_filters"."filtrable_element_type" = ?
SELECT "match_filters".* FROM "match_filters" INNER JOIN "institutions" ON "match_filters"."filtrable_element_id" = "institutions"."id" INNER JOIN "antennes" ON "institutions"."id" = "antennes"."institution_id" INNER JOIN "experts" ON "antennes"."id" = "experts"."antenne_id" WHERE "experts"."id" = ? AND "match_filters"."filtrable_element_type" = ?
|
|
sql
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:31
|
1%
|
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:31
- Average Self
-
0.94ms
- Average calls
- 4.5x
- Total Self
- 4.3ms
- Total Children
- 0ms
- Total runtime
- 4.3ms
SELECT ? AS one FROM "subject_answer_groupings" INNER JOIN "subject_answers" ON "subject_answers"."subject_answer_grouping_id" = "subject_answer_groupings"."id" AND "subject_answers"."type" = ? INNER JOIN "subject_questions" "subject_question" ON "subject_question"."id" = "subject_answers"."subject_question_id" INNER JOIN "subjects" ON "subjects"."id" = "subject_question"."subject_id" WHERE "subject_answer_groupings"."institution_id" = ? AND "subject_question"."subject_id" = ? LIMIT ?
SELECT DISTINCT "subject_answer_groupings".* FROM "subject_answer_groupings" INNER JOIN "subject_answers" ON "subject_answers"."subject_answer_grouping_id" = "subject_answer_groupings"."id" AND "subject_answers"."type" = ? INNER JOIN "subject_questions" "subject_question" ON "subject_question"."id" = "subject_answers"."subject_question_id" INNER JOIN "subjects" ON "subjects"."id" = "subject_question"."subject_id" WHERE "subject_answer_groupings"."institution_id" = ? AND "subject_question"."subject_id" = ?
|
|
sql
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:30
|
1%
|
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:30
- Average Self
-
0.67ms
- Average calls
- 6x
- Total Self
- 4ms
- Total Children
- 0ms
- Total runtime
- 4ms
SELECT "experts".* FROM "experts" WHERE "experts"."id" = ? LIMIT ?
SELECT "institutions".* FROM "institutions" INNER JOIN "antennes" ON "institutions"."id" = "antennes"."institution_id" WHERE "antennes"."id" = ? LIMIT ?
|
|
sql
app/models/expert.rb:247
|
1%
|
app/models/expert.rb:247
- Average Self
-
4ms
- Average calls
- 1x
- Total Self
- 4ms
- Total Children
- 0ms
- Total runtime
- 4ms
SELECT "experts"."id" FROM "experts" INNER JOIN "territorial_zones" ON "territorial_zones"."zoneable_type" = ? AND "territorial_zones"."zoneable_id" = "experts"."id" WHERE "experts"."deleted_at" IS NULL
|
|
view
app/views/conseiller/diagnoses/steps/_expert_subject_checkboxes.html.haml
|
1%
|
app/views/conseiller/diagnoses/steps/_expert_subject_checkboxes.html.haml
- Average Self
-
3.8ms
- Average calls
- 1x
- Total Self
- 3.8ms
- Total Children
- 17ms
- Total runtime
- 21ms
|
|
sql
app/views/conseiller/diagnoses/steps/_expert_content.html.haml:15
|
<1%
|
app/views/conseiller/diagnoses/steps/_expert_content.html.haml:15
- Average Self
-
0.48ms
- Average calls
- 6.3x
- Total Self
- 3ms
- Total Children
- 0ms
- Total runtime
- 3ms
SELECT "institutions_subjects".* FROM "institutions_subjects" WHERE "institutions_subjects"."id" = ? LIMIT ?
|
|
sql
app/views/conseiller/diagnoses/steps/_expert_subject_checkboxes.html.haml:7
|
<1%
|
app/views/conseiller/diagnoses/steps/_expert_subject_checkboxes.html.haml:7
- Average Self
-
0.71ms
- Average calls
- 3.5x
- Total Self
- 2.5ms
- Total Children
- 0ms
- Total runtime
- 2.5ms
SELECT "subjects".* FROM "subjects" INNER JOIN "institutions_subjects" ON "subjects"."id" = "institutions_subjects"."subject_id" WHERE "institutions_subjects"."id" = ? LIMIT ?
SELECT "matches".* FROM "matches" WHERE "matches"."need_id" = ? AND "matches"."expert_id" = ? AND "matches"."subject_id" = ? ORDER BY "matches"."id" ASC LIMIT ?
|
|
view
app/views/conseiller/diagnoses/_company_details.haml
|
<1%
|
app/views/conseiller/diagnoses/_company_details.haml
- Average Self
-
2ms
- Average calls
- 1x
- Total Self
- 2ms
- Total Children
- 1ms
- Total runtime
- 3ms
|
|
sql
app/views/conseiller/diagnoses/steps/_expert_content.html.haml:7
|
<1%
|
app/views/conseiller/diagnoses/steps/_expert_content.html.haml:7
- Average Self
-
0.64ms
- Average calls
- 2.8x
- Total Self
- 1.8ms
- Total Children
- 0ms
- Total runtime
- 1.8ms
SELECT "users".* FROM "users" INNER JOIN "experts_users" ON "users"."id" = "experts_users"."user_id" WHERE "experts_users"."expert_id" = ? AND "users"."deleted_at" IS NULL
|
|
sql
app/views/conseiller/diagnoses/steps/_expert_content.html.haml:4
|
<1%
|
app/views/conseiller/diagnoses/steps/_expert_content.html.haml:4
- Average Self
-
0.45ms
- Average calls
- 2.8x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?
|
|
sql
app/models/expert.rb:244
|
<1%
|
app/models/expert.rb:244
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT "experts"."id" FROM "experts" LEFT OUTER JOIN "territorial_zones" ON "territorial_zones"."zoneable_type" = ? AND "territorial_zones"."zoneable_id" = "experts"."id" WHERE ("territorial_zones"."zone_type" = ? AND "territorial_zones"."code" = ? OR "territorial_zones"."zone_type" = ? AND "territorial_zones"."code" = ? OR "territorial_zones"."zone_type" = ? AND "territorial_zones"."code" = ? OR "territorial_zones"."zone_type" = ? AND "territorial_zones"."code" = ?)
|
|
sql
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:64
|
<1%
|
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:64
- Average Self
-
0.67ms
- Average calls
- 1.5x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT "subject_answers".* FROM "subject_answers" WHERE "subject_answers"."type" = ? AND "subject_answers"."subject_questionable_id" = ? AND "subject_answers"."subject_questionable_type" = ? AND "subject_answers"."subject_question_id" = ? LIMIT ?
|
|
sql
app/models/expert_subject.rb:85
|
<1%
|
app/models/expert_subject.rb:85
- Average Self
-
1ms
- Average calls
- 0.75x
- Total Self
- 0.75ms
- Total Children
- 0ms
- Total runtime
- 0.75ms
SELECT "institutions".* FROM "institutions" WHERE "institutions"."slug" = ? LIMIT ?
|
|
sql
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:62
|
<1%
|
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:62
- Average Self
-
0.5ms
- Average calls
- 1.5x
- Total Self
- 0.75ms
- Total Children
- 0ms
- Total runtime
- 0.75ms
SELECT "subject_answers".* FROM "subject_answers" WHERE "subject_answers"."type" = ? AND "subject_answers"."subject_answer_grouping_id" = ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-attack-6.8.0/lib/rack/attack.rb:104
- Average Self
-
0.75ms
- Average calls
- 1x
- Total Self
- 0.75ms
- Total Children
- 289ms
- Total runtime
- 290ms
Rack::Attack
|
|
queue
queue
|
<1%
|
queue
- Average Self
-
0.5ms
- Average calls
- 1x
- Total Self
- 0.5ms
- Total Children
- 0ms
- Total runtime
- 0.5ms
|
|
view
app/views/conseiller/diagnoses/steps/_header.haml
|
<1%
|
app/views/conseiller/diagnoses/steps/_header.haml
- Average Self
-
0.5ms
- Average calls
- 1x
- Total Self
- 0.5ms
- Total Children
- 3.3ms
- Total runtime
- 3.8ms
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/ssl.rb:88
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/ssl.rb:88
- Average Self
-
0.5ms
- Average calls
- 1x
- Total Self
- 0.5ms
- Total Children
- 292ms
- Total runtime
- 293ms
ActionDispatch::SSL
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/tempfile_reaper.rb:16
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/tempfile_reaper.rb:16
- Average Self
-
0.5ms
- Average calls
- 1x
- Total Self
- 0.5ms
- Total Children
- 290ms
- Total runtime
- 290ms
Rack::TempfileReaper
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/rack/logger.rb:20
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/rack/logger.rb:20
- Average Self
-
0.5ms
- Average calls
- 1x
- Total Self
- 0.5ms
- Total Children
- 291ms
- Total runtime
- 292ms
Rails::Rack::Logger
|
|
sql
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:76
|
<1%
|
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:76
- Average Self
-
0.29ms
- Average calls
- 1.8x
- Total Self
- 0.5ms
- Total Children
- 0ms
- Total runtime
- 0.5ms
SELECT ? AS one FROM "subjects" INNER JOIN "match_filters_subjects" ON "subjects"."id" = "match_filters_subjects"."subject_id" WHERE "match_filters_subjects"."match_filter_id" = ? LIMIT ?
SELECT ? AS one FROM "subjects" INNER JOIN "match_filters_subjects" ON "subjects"."id" = "match_filters_subjects"."subject_id" WHERE "match_filters_subjects"."match_filter_id" = ? AND "subjects"."id" = ? LIMIT ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-session-2.1.2/lib/rack/session/abstract/id.rb:267
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-session-2.1.2/lib/rack/session/abstract/id.rb:267
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 290ms
- Total runtime
- 291ms
ActionDispatch::Session::CookieStore
|
|
code
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/engine.rb:532
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/engine.rb:532
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 293ms
- Total runtime
- 293ms
Rails::Engine#call
|
|
rack
ActionDispatch::Flash
|
<1%
|
ActionDispatch::Flash
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 290ms
- Total runtime
- 290ms
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-timeout-0.7.0/lib/rack/timeout/core.rb:90
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-timeout-0.7.0/lib/rack/timeout/core.rb:90
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 292ms
- Total runtime
- 292ms
Rack::Timeout
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/static.rb:26
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/static.rb:26
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 292ms
- Total runtime
- 292ms
ActionDispatch::Static
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/cookies.rb:706
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/cookies.rb:706
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 291ms
- Total runtime
- 291ms
ActionDispatch::Cookies
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/remote_ip.rb:95
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/remote_ip.rb:95
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 292ms
- Total runtime
- 292ms
ActionDispatch::RemoteIp
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/appsignal-4.8.4/lib/appsignal/rack/abstract_middleware.rb:26
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/appsignal-4.8.4/lib/appsignal/rack/abstract_middleware.rb:26
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 291ms
- Total runtime
- 291ms
Appsignal::Rack::RailsInstrumentation
|
|
sql
app/models/user.rb:326
|
<1%
|
app/models/user.rb:326
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 0ms
- Total runtime
- 0.25ms
SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? LIMIT ?
|
|
sql
app/models/need.rb:462
|
<1%
|
app/models/need.rb:462
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 0ms
- Total runtime
- 0.25ms
SELECT "matches".* FROM "matches" WHERE "matches"."need_id" = ?
|
|
sql
vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158
|
<1%
|
vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158
- Average Self
-
0.25ms
- Average calls
- 1x
- Total Self
- 0.25ms
- Total Children
- 0ms
- Total runtime
- 0.25ms
SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC LIMIT ?
|
|
sql
app/models/expert_subject.rb:83
|
<1%
|
app/models/expert_subject.rb:83
- Average Self
-
0ms
- Average calls
- 0.75x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "institutions".* FROM "institutions" WHERE "institutions"."slug" = ? LIMIT ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/ip_anonymizer-0.4.0/lib/ip_anonymizer/mask_ip.rb:7
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/ip_anonymizer-0.4.0/lib/ip_anonymizer/mask_ip.rb:7
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 292ms
- Total runtime
- 292ms
IpAnonymizer::MaskIp
|
|
sql
app/models/facility.rb:84
|
<1%
|
app/models/facility.rb:84
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "companies".* FROM "companies" WHERE "companies"."id" = ? LIMIT ?
|
|
sql
app/models/facility.rb:104
|
<1%
|
app/models/facility.rb:104
- Average Self
-
0ms
- Average calls
- 0.25x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "institutions".* FROM "institutions" INNER JOIN "categories_institutions" ON "categories_institutions"."institution_id" = "institutions"."id" INNER JOIN "categories" ON "categories"."id" = "categories_institutions"."category_id" WHERE "institutions"."id" = ? AND "institutions"."deleted_at" IS NULL AND "categories"."label" = ? LIMIT ?
|
|
sql
app/controllers/conseiller/diagnoses/steps_controller.rb:68
|
<1%
|
app/controllers/conseiller/diagnoses/steps_controller.rb:68
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "needs".* FROM "needs" WHERE "needs"."id" = ? LIMIT ?
|
|
sql
app/controllers/conseiller/diagnoses/steps_controller.rb:69
|
<1%
|
app/controllers/conseiller/diagnoses/steps_controller.rb:69
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "experts".* FROM "experts" WHERE "experts"."id" = ? LIMIT ?
|
|
sql
app/controllers/conseiller/diagnoses/steps_controller.rb:70
|
<1%
|
app/controllers/conseiller/diagnoses/steps_controller.rb:70
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/events.rb:126
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/events.rb:126
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 293ms
- Total runtime
- 293ms
Appsignal::Rack::EventMiddleware
|
|
sql
app/controllers/conseiller/diagnoses/steps_controller.rb:80
|
<1%
|
app/controllers/conseiller/diagnoses/steps_controller.rb:80
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ?
|
|
sql
app/views/conseiller/diagnoses/_company_details.haml:1
|
<1%
|
app/views/conseiller/diagnoses/_company_details.haml:1
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "facilities".* FROM "facilities" WHERE "facilities"."id" = ? LIMIT ?
|
|
sql
app/views/conseiller/diagnoses/_company_details.haml:2
|
<1%
|
app/views/conseiller/diagnoses/_company_details.haml:2
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "solicitations".* FROM "solicitations" WHERE "solicitations"."id" = ? LIMIT ?
|
|
sql
app/views/conseiller/diagnoses/_company_details.haml:4
|
<1%
|
app/views/conseiller/diagnoses/_company_details.haml:4
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "companies".* FROM "companies" WHERE "companies"."id" = ? LIMIT ?
|
|
sql
app/views/conseiller/diagnoses/steps/matches.html.haml:26
|
<1%
|
app/views/conseiller/diagnoses/steps/matches.html.haml:26
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "needs".* FROM "needs" LEFT OUTER JOIN "subjects" ON "subjects"."id" = "needs"."subject_id" LEFT OUTER JOIN "themes" ON "themes"."id" = "subjects"."theme_id" WHERE "needs"."diagnosis_id" = ? AND "subjects"."archived_at" IS NULL ORDER BY "themes"."interview_sort_order" ASC, "themes"."id" ASC, "subjects"."interview_sort_order" ASC, "subjects"."id" ASC
|
|
sql
app/views/conseiller/diagnoses/steps/matches.html.haml:29
|
<1%
|
app/views/conseiller/diagnoses/steps/matches.html.haml:29
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?
|
|
sql
app/views/conseiller/diagnoses/steps/matches.html.haml:46
|
<1%
|
app/views/conseiller/diagnoses/steps/matches.html.haml:46
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "needs".* FROM "needs" WHERE "needs"."diagnosis_id" = ? ORDER BY "needs"."id" ASC LIMIT ?
|
|
sql
app/views/conseiller/diagnoses/steps/matches.html.haml:62
|
<1%
|
app/views/conseiller/diagnoses/steps/matches.html.haml:62
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "contacts".* FROM "contacts" WHERE "contacts"."id" = ? LIMIT ?
|
|
sql
app/views/conseiller/diagnoses/steps/matches.html.haml:65
|
<1%
|
app/views/conseiller/diagnoses/steps/matches.html.haml:65
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "needs".* FROM "needs" WHERE "needs"."diagnosis_id" = ? ORDER BY "needs"."id" ASC LIMIT ?
|
|
sql
app/views/conseiller/diagnoses/steps/matches.html.haml:66
|
<1%
|
app/views/conseiller/diagnoses/steps/matches.html.haml:66
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "needs".* FROM "needs" WHERE "needs"."diagnosis_id" = ? ORDER BY "needs"."id" ASC LIMIT ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/method_override.rb:19
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/method_override.rb:19
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 292ms
- Total runtime
- 292ms
Rack::MethodOverride
|
|
sql
app/views/conseiller/diagnoses/steps/_expert_subject_checkboxes.html.haml:17
|
<1%
|
app/views/conseiller/diagnoses/steps/_expert_subject_checkboxes.html.haml:17
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "matches".* FROM "matches" WHERE "matches"."need_id" = ? AND "matches"."expert_id" != ?
|
|
sql
app/views/conseiller/diagnoses/steps/_expert_subject_checkboxes.html.haml:18
|
<1%
|
app/views/conseiller/diagnoses/steps/_expert_subject_checkboxes.html.haml:18
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "experts".* FROM "experts" WHERE "experts"."id" = ? LIMIT ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/runtime.rb:22
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/runtime.rb:22
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 292ms
- Total runtime
- 292ms
Rack::Runtime
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/sendfile.rb:130
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/sendfile.rb:130
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 292ms
- Total runtime
- 292ms
Rack::Sendfile
|
|
sql
app/views/conseiller/diagnoses/steps/_expert_content.html.haml:14
|
<1%
|
app/views/conseiller/diagnoses/steps/_expert_content.html.haml:14
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "experts_subjects".* FROM "experts_subjects" WHERE "experts_subjects"."expert_id" = ?
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/head.rb:14
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/head.rb:14
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 290ms
- Total runtime
- 290ms
Rack::Head
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/conditional_get.rb:28
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/conditional_get.rb:28
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 290ms
- Total runtime
- 290ms
Rack::ConditionalGet
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/etag.rb:28
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/rack-3.2.6/lib/rack/etag.rb:28
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 290ms
- Total runtime
- 290ms
Rack::ETag
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/rack/silence_request.rb:27
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/railties-8.1.3/lib/rails/rack/silence_request.rb:27
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 292ms
- Total runtime
- 292ms
Rails::Rack::SilenceRequest
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/request_id.rb:31
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/request_id.rb:31
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 292ms
- Total runtime
- 292ms
ActionDispatch::RequestId
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/http/content_security_policy.rb:37
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/http/content_security_policy.rb:37
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 290ms
- Total runtime
- 290ms
ActionDispatch::ContentSecurityPolicy::Middleware
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/debug_exceptions.rb:30
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/debug_exceptions.rb:30
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 291ms
- Total runtime
- 291ms
ActionDispatch::DebugExceptions
|
|
sql
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:157
|
<1%
|
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:157
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "facilities".* FROM "facilities" INNER JOIN "diagnoses" ON "facilities"."id" = "diagnoses"."facility_id" WHERE "diagnoses"."id" = ? LIMIT ?
|
|
sql
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:161
|
<1%
|
app/services/diagnosis_creation/find_relevant_expert_subjects.rb:161
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "companies".* FROM "companies" INNER JOIN "facilities" ON "companies"."id" = "facilities"."company_id" INNER JOIN "diagnoses" ON "facilities"."id" = "diagnoses"."facility_id" WHERE "diagnoses"."id" = ? LIMIT ?
|
|
view
app/views/needs/_star_btn.html.haml
|
<1%
|
app/views/needs/_star_btn.html.haml
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/show_exceptions.rb:31
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/show_exceptions.rb:31
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 291ms
- Total runtime
- 291ms
ActionDispatch::ShowExceptions
|
|
view
app/views/conseiller/diagnoses/steps/_steps.haml
|
<1%
|
app/views/conseiller/diagnoses/steps/_steps.haml
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 292ms
- Total runtime
- 292ms
ActiveSupport::Cache::Strategy::LocalCache::Middleware
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/executor.rb:13
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/executor.rb:13
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 292ms
- Total runtime
- 292ms
ActionDispatch::Executor
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/callbacks.rb:28
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/actionpack-8.1.3/lib/action_dispatch/middleware/callbacks.rb:28
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 291ms
- Total runtime
- 291ms
ActionDispatch::Callbacks
|
|
rack
/app/vendor/bundle/ruby/4.0.0/gems/warden-1.2.9/lib/warden/manager.rb:30
|
<1%
|
/app/vendor/bundle/ruby/4.0.0/gems/warden-1.2.9/lib/warden/manager.rb:30
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 290ms
- Total runtime
- 290ms
Warden::Manager
|
|
sql
app/models/need.rb:466
|
<1%
|
app/models/need.rb:466
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
UPDATE "diagnoses" SET "updated_at" = ? WHERE "diagnoses"."id" = ?
|