Place des Entreprises Prod

.MD

ActionMailer::MailDeliveryJob

…

Most impactful sections

code49%
sql29%
mail14%
gc7%
view<1%
unknown<1%


code vendor/bundle/ruby/4.0.0/gems/actionmailer-8.1.3/lib/action_mailer/mail_delivery_job.rb:21	48%
Average Self 838ms Average calls 1x Total Self 838ms Total Children 717ms Total runtime 1,556ms `ActionMailer::MailDeliveryJob#perform`
mail vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158	14%
Average Self 308ms Average calls 0.83x Total Self 254ms Total Children 0ms Total runtime 254ms `SolicitationMailer`
gc ruby/gc.c	7%
Average Self 21ms Average calls 6.1x Total Self 130ms Total Children 0ms Total runtime 130ms `GC.start`
sql app/models/antenne.rb:166	5%
Average Self 81ms Average calls 1.1x Total Self 88ms Total Children 0ms Total runtime 88ms SELECT "user_rights".* FROM "user_rights" INNER JOIN "territorial_zones" ON "territorial_zones"."id" = "user_rights"."rightable_element_id" INNER JOIN "user_rights" "user_rights_territorial_zones" ON "user_rights_territorial_zones"."rightable_element_type" = ? AND "user_rights_territorial_zones"."rightable_element_id" = "territorial_zones"."id" AND "user_rights"."rightable_element_type" = ? WHERE "user_rights"."category" = ? AND "territorial_zones"."code" = ? LIMIT ? SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?
sql app/mailers/expert_mailer.rb:16	5%
Average Self 74ms Average calls 1.1x Total Self 82ms Total Children 0ms Total runtime 82ms `SELECT "institutions".* FROM "institutions" INNER JOIN "antennes" ON "institutions"."id" = "antennes"."institution_id" WHERE "antennes"."id" = ? LIMIT ? SELECT "logos".* FROM "logos" WHERE "logos"."logoable_id" = ? AND "logos"."logoable_type" = ? LIMIT ?`
sql vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158	3%
Average Self 47ms Average calls 1.1x Total Self 52ms Total Children 0ms Total runtime 52ms `SELECT "needs".* FROM "needs" WHERE "needs"."id" = ? LIMIT ? SELECT "email_retentions".* FROM "email_retentions" WHERE "email_retentions"."id" = ? LIMIT ?`
sql app/models/concerns/with_territorial_zones.rb:35	3%
Average Self 83ms Average calls 0.56x Total Self 47ms Total Children 0ms Total runtime 47ms `SELECT "territorial_zones".* FROM "territorial_zones" WHERE "territorial_zones"."zoneable_id" = ? AND "territorial_zones"."zoneable_type" = ?`
sql app/models/expert.rb:303	3%
Average Self 84ms Average calls 0.55x Total Self 46ms Total Children 0ms Total runtime 46ms `SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?`
sql app/mailers/expert_mailer.rb:46	2%
Average Self 92ms Average calls 0.45x Total Self 41ms Total Children 0ms Total runtime 41ms `SELECT DISTINCT "needs".* FROM "needs" INNER JOIN "matches" ON "needs"."id" = "matches"."need_id" WHERE "matches"."expert_id" = ? AND "matches"."archived_at" IS NULL AND "matches"."status" = ? AND "matches"."sent_at" >= ? AND "needs"."id" IN (?) ORDER BY "needs"."id" ASC LIMIT ?`
sql app/views/mailers/expert_mailer/_need_card.text.erb:1	2%
Average Self 56ms Average calls 0.59x Total Self 33ms Total Children 0ms Total runtime 33ms `SELECT "facilities".* FROM "facilities" INNER JOIN "diagnoses" ON "facilities"."id" = "diagnoses"."facility_id" WHERE "diagnoses"."id" = ? LIMIT ?`
sql app/views/mailers/expert_mailer/_need_card.text.erb:2	2%
Average Self 54ms Average calls 0.59x Total Self 32ms Total Children 0ms Total runtime 32ms `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 ?`
sql app/views/mailers/expert_mailer/_need_card.text.erb:3	1%
Average Self 45ms Average calls 0.48x Total Self 21ms Total Children 0ms Total runtime 21ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
code vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/active_job/queue_adapters/sidekiq_adapter.rb:13	1%
Average Self 20ms Average calls 1x Total Self 20ms Total Children 1,609ms Total runtime 1,629ms `ActionMailer::MailDeliveryJob#perform`
sql app/mailers/expert_mailer.rb:48	1%
Average Self 74ms Average calls 0.27x Total Self 20ms Total Children 0ms Total runtime 20ms `SELECT DISTINCT "needs".* FROM "needs" INNER JOIN "matches" ON "needs"."id" = "matches"."need_id" WHERE "matches"."expert_id" = ? AND "matches"."archived_at" IS NULL AND "matches"."status" = ? AND "matches"."sent_at" >= ?`
sql app/views/mailers/expert_mailer/_support_user_signature.mjml:15	1%
Average Self 47ms Average calls 0.41x Total Self 19ms Total Children 0ms Total runtime 19ms `SELECT "profil_pictures".* FROM "profil_pictures" WHERE "profil_pictures"."user_id" = ? LIMIT ?`
sql app/models/antenne.rb:168	<1%
Average Self 67ms Average calls 0.09x Total Self 5.9ms Total Children 0ms Total runtime 5.9ms `SELECT "user_rights".* FROM "user_rights" WHERE "user_rights"."category" = ? ORDER BY "user_rights"."id" ASC LIMIT ? SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?`
sql app/mailers/expert_mailer.rb:30	<1%
Average Self 23ms Average calls 0.11x Total Self 2.6ms Total Children 0ms Total runtime 2.6ms `SELECT "companies".* FROM "companies" INNER JOIN "facilities" ON "companies"."id" = "facilities"."company_id" WHERE "facilities"."id" = ? LIMIT ?`
sql app/mailers/expert_mailer.rb:25	<1%
Average Self 23ms Average calls 0.11x Total Self 2.5ms Total Children 0ms Total runtime 2.5ms `SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ?`
sql app/mailers/expert_mailer.rb:26	<1%
Average Self 22ms Average calls 0.11x Total Self 2.4ms Total Children 0ms Total runtime 2.4ms `SELECT "solicitations".* FROM "solicitations" INNER JOIN "diagnoses" ON "solicitations"."id" = "diagnoses"."solicitation_id" WHERE "diagnoses"."id" = ? LIMIT ?`
sql app/views/mailers/expert_mailer/notify_company_needs.text.erb:3	<1%
Average Self 14ms Average calls 0.11x Total Self 1.6ms Total Children 0ms Total runtime 1.6ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
sql app/views/mailers/expert_mailer/notify_company_needs.text.erb:7	<1%
Average Self 13ms Average calls 0.11x Total Self 1.5ms Total Children 0ms Total runtime 1.5ms `SELECT "landings".* FROM "landings" WHERE "landings"."id" = ? LIMIT ?`
view app/views/mailers/expert_mailer/_need_card.text.erb	<1%
Average Self 2.1ms Average calls 0.59x Total Self 1.3ms Total Children 87ms Total runtime 88ms
view app/views/mailers/expert_mailer/remind_involvement.text.erb	<1%
Average Self 3.3ms Average calls 0.27x Total Self 0.91ms Total Children 85ms Total runtime 86ms
sql app/mailers/solicitation_mailer.rb:14	<1%
Average Self 20ms Average calls 0.04x Total Self 0.83ms Total Children 0ms Total runtime 0.83ms SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_id" = "diagnoses"."id" WHERE "diagnoses"."solicitation_id" = ? ORDER BY "needs"."id" ASC LIMIT ? SELECT "landings".* FROM "landings" WHERE "landings"."id" = ? LIMIT ? SELECT "landing_subjects".* FROM "landing_subjects" INNER JOIN "landing_themes" ON "landing_themes"."id" = "landing_subjects"."landing_theme_id" INNER JOIN "landing_joint_themes" ON "landing_joint_themes"."landing_theme_id" = "landing_themes"."id" INNER JOIN "landings" ON "landings"."id" = "landing_joint_themes"."landing_id" WHERE "landing_subjects"."subject_id" IS NULL AND "landings"."id" = ? LIMIT ?
view app/views/mailers/company_mailer/confirmation_solicitation.mjml	<1%
Average Self 6.1ms Average calls 0.13x Total Self 0.8ms Total Children 1.6ms Total runtime 2.4ms
sql app/models/diagnosis.rb:171	<1%
Average Self 2.7ms Average calls 0.17x Total Self 0.45ms Total Children 0ms Total runtime 0.45ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
sql app/models/landing_subject.rb:78	<1%
Average Self 3.4ms Average calls 0.13x Total Self 0.44ms Total Children 0ms Total runtime 0.44ms `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 ?`
sql app/models/diagnosis.rb:170	<1%
Average Self 2.4ms Average calls 0.17x Total Self 0.41ms Total Children 0ms Total runtime 0.41ms `SELECT "needs".* FROM "needs" WHERE "needs"."diagnosis_id" = ?`
view app/views/mailers/company_mailer/notify_taking_care.mjml	<1%
Average Self 2.5ms Average calls 0.15x Total Self 0.38ms Total Children 0.54ms Total runtime 0.92ms
sql app/mailers/company_mailer.rb:90	<1%
Average Self 1.7ms Average calls 0.22x Total Self 0.36ms Total Children 0ms Total runtime 0.36ms `SELECT "cooperations".* FROM "cooperations" WHERE "cooperations"."id" = ? LIMIT ? SELECT "logos".* FROM "logos" WHERE "logos"."logoable_id" = ? AND "logos"."logoable_type" = ? LIMIT ?`
view app/views/mailers/expert_mailer/_need_card.mjml	<1%
Average Self 0.59ms Average calls 0.59x Total Self 0.35ms Total Children 0ms Total runtime 0.35ms
sql app/models/institution.rb:167	<1%
Average Self 0.9ms Average calls 0.39x Total Self 0.35ms Total Children 0ms Total runtime 0.35ms `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 ?`
sql app/views/mailers/company_mailer/notify_taking_care.mjml:10	<1%
Average Self 0.72ms Average calls 0.45x Total Self 0.33ms Total Children 0ms Total runtime 0.33ms `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 ? SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?`
view app/views/mailers/expert_mailer/_support_user_signature.mjml	<1%
Average Self 0.78ms Average calls 0.41x Total Self 0.32ms Total Children 19ms Total runtime 19ms
sql app/models/solicitation.rb:622	<1%
Average Self 2.4ms Average calls 0.11x Total Self 0.27ms Total Children 0ms Total runtime 0.27ms `SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_id" = "diagnoses"."id" WHERE "diagnoses"."solicitation_id" = ?`
sql app/mailers/solicitation_mailer.rb:13	<1%
Average Self 24ms Average calls 0.01x Total Self 0.25ms Total Children 0ms Total runtime 0.25ms `SELECT "cooperations".* FROM "cooperations" WHERE "cooperations"."id" = ? LIMIT ? SELECT "logos".* FROM "logos" WHERE "logos"."logoable_id" = ? AND "logos"."logoable_type" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:21	<1%
Average Self 1.6ms Average calls 0.15x Total Self 0.24ms Total Children 0ms Total runtime 0.24ms `SELECT "contacts".* FROM "contacts" WHERE "contacts"."id" = ? LIMIT ?`
view app/views/mailers/expert_mailer/notify_company_needs.text.erb	<1%
Average Self 2.1ms Average calls 0.11x Total Self 0.23ms Total Children 6.6ms Total runtime 6.9ms
view app/views/mailers/expert_mailer/remind_involvement.mjml	<1%
Average Self 0.82ms Average calls 0.27x Total Self 0.22ms Total Children 18ms Total runtime 19ms
sql app/models/solicitation.rb:625	<1%
Average Self 2ms Average calls 0.11x Total Self 0.21ms Total Children 0ms Total runtime 0.21ms `SELECT "landing_subjects".* FROM "landing_subjects" WHERE "landing_subjects"."id" = ? LIMIT ?`
view app/views/mailers/expert_mailer/_remind_received_needs.text.erb	<1%
Average Self 0.71ms Average calls 0.27x Total Self 0.19ms Total Children 85ms Total runtime 85ms
sql app/models/landing_subject.rb:80	<1%
Average Self 1.3ms Average calls 0.13x Total Self 0.17ms Total Children 0ms Total runtime 0.17ms 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/mailers/company_mailer.rb:34	<1%
Average Self 8.8ms Average calls 0.02x Total Self 0.16ms Total Children 0ms Total runtime 0.16ms `SELECT "contacts".* FROM "contacts" WHERE "contacts"."id" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:18	<1%
Average Self 1.1ms Average calls 0.15x Total Self 0.16ms Total Children 0ms Total runtime 0.16ms `SELECT "diagnoses".* FROM "diagnoses" INNER JOIN "needs" ON "diagnoses"."id" = "needs"."diagnosis_id" WHERE "needs"."id" = ? LIMIT ?`
sql app/models/landing_subject.rb:79	<1%
Average Self 1.1ms Average calls 0.13x Total Self 0.14ms Total Children 0ms Total runtime 0.14ms 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
sql app/models/solicitation.rb:615	<1%
Average Self 2ms Average calls 0.07x Total Self 0.14ms Total Children 0ms Total runtime 0.14ms `SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_id" = "diagnoses"."id" WHERE "diagnoses"."solicitation_id" = ?`
sql app/views/mailers/company_mailer/notify_taking_care.mjml:5	<1%
Average Self 0.76ms Average calls 0.15x Total Self 0.11ms Total Children 0ms Total runtime 0.11ms `SELECT "companies".* FROM "companies" INNER JOIN "facilities" ON "companies"."id" = "facilities"."company_id" WHERE "facilities"."id" = ? LIMIT ?`
sql app/services/partner_origin.rb:72	<1%
Average Self 1.6ms Average calls 0.07x Total Self 0.11ms Total Children 0ms Total runtime 0.11ms `SELECT "landings".* FROM "landings" WHERE "landings"."id" = ? LIMIT ?`
sql app/models/institution.rb:166	<1%
Average Self 0.26ms Average calls 0.39x Total Self 0.1ms Total Children 0ms Total runtime 0.1ms `SELECT "categories".* FROM "categories" WHERE "categories"."label" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:31	<1%
Average Self 5.6ms Average calls 0.02x Total Self 0.1ms Total Children 0ms Total runtime 0.1ms `SELECT "diagnoses".* FROM "diagnoses" INNER JOIN "needs" ON "diagnoses"."id" = "needs"."diagnosis_id" WHERE "needs"."id" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:52	<1%
Average Self 0.98ms Average calls 0.09x Total Self 0.09ms Total Children 0ms Total runtime 0.09ms `SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ? SELECT "contacts".* FROM "contacts" WHERE "contacts"."id" = ? LIMIT ?`
sql app/views/mailers/company_mailer/retention.mjml:5	<1%
Average Self 1.8ms Average calls 0.05x Total Self 0.09ms Total Children 0ms Total runtime 0.09ms `SELECT "companies".* FROM "companies" INNER JOIN "facilities" ON "companies"."id" = "facilities"."company_id" WHERE "facilities"."id" = ? LIMIT ?`
code vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130	<1%
Average Self 0.09ms Average calls 1x Total Self 0.09ms Total Children 1,556ms Total runtime 1,556ms `ActionMailer::MailDeliveryJob`
code vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 1,629ms Total runtime 1,629ms
view app/views/mailers/_expert_header.mjml	<1%
Average Self 0.16ms Average calls 0.41x Total Self 0.06ms Total Children 0ms Total runtime 0.06ms
sql app/models/solicitation.rb:618	<1%
Average Self 1.2ms Average calls 0.05x Total Self 0.06ms Total Children 0ms Total runtime 0.06ms `SELECT "landing_subjects".* FROM "landing_subjects" WHERE "landing_subjects"."id" = ? LIMIT ?`
sql app/views/mailers/company_mailer/not_yet_taken_care.mjml:7	<1%
Average Self 5ms Average calls 0.01x Total Self 0.06ms Total Children 0ms Total runtime 0.06ms `SELECT "landing_subjects".* FROM "landing_subjects" WHERE "landing_subjects"."id" = ? LIMIT ?`
sql app/views/mailers/company_mailer/not_yet_taken_care.mjml:5	<1%
Average Self 2.4ms Average calls 0.03x Total Self 0.06ms Total Children 0ms Total runtime 0.06ms `SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."solicitation_id" = ? LIMIT ? SELECT "companies".* FROM "companies" INNER JOIN "facilities" ON "companies"."id" = "facilities"."company_id" WHERE "facilities"."id" = ? LIMIT ?`
view app/views/mailers/company_mailer/retention.mjml	<1%
Average Self 1.3ms Average calls 0.05x Total Self 0.06ms Total Children 0.14ms Total runtime 0.2ms
view app/views/mailers/company_mailer/solicitation_relaunch_company.mjml	<1%
Average Self 2ms Average calls 0.03x Total Self 0.06ms Total Children 0.11ms Total runtime 0.16ms
sql app/views/mailers/company_mailer/retention.mjml:8	<1%
Average Self 1ms Average calls 0.05x Total Self 0.05ms Total Children 0ms Total runtime 0.05ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
view app/views/mailers/_header.mjml	<1%
Average Self 0.11ms Average calls 0.42x Total Self 0.05ms Total Children 0ms Total runtime 0.05ms
view app/views/mailers/solicitation_mailer/_footer.mjml	<1%
Average Self 0.11ms Average calls 0.42x Total Self 0.05ms Total Children 0ms Total runtime 0.05ms
sql app/mailers/user_mailer.rb:43	<1%
Average Self 4.8ms Average calls <0.01x Total Self 0.04ms Total Children 0ms Total runtime 0.04ms `SELECT DISTINCT "experts".* FROM "experts" INNER JOIN "experts_users" ON "experts"."id" = "experts_users"."expert_id" LEFT OUTER JOIN "experts_subjects" ON "experts_subjects"."expert_id" = "experts"."id" WHERE "experts_users"."user_id" = ? AND "experts"."deleted_at" IS NULL AND "experts_subjects"."id" IS NOT NULL ORDER BY "experts"."id" ASC LIMIT ?`
view app/views/mailers/company_mailer/not_yet_taken_care.mjml	<1%
Average Self 3.2ms Average calls 0.01x Total Self 0.04ms Total Children 0.13ms Total runtime 0.17ms
view app/views/mailers/expert_mailer/_support_user_signature.text.erb	<1%
Average Self 0.1ms Average calls 0.39x Total Self 0.04ms Total Children 0ms Total runtime 0.04ms
view app/views/mailers/company_mailer/notify_not_reachable.mjml	<1%
Average Self 2ms Average calls 0.02x Total Self 0.04ms Total Children 0.05ms Total runtime 0.08ms
view app/views/mailers/expert_mailer/notify_company_needs.mjml	<1%
Average Self 0.32ms Average calls 0.11x Total Self 0.03ms Total Children 1.2ms Total runtime 1.2ms
sql app/views/mailers/company_mailer/solicitation_relaunch_company.mjml:11	<1%
Average Self 2.9ms Average calls 0.01x Total Self 0.03ms Total Children 0ms Total runtime 0.03ms `SELECT "subjects".* FROM "subjects" INNER JOIN "landing_subjects" ON "subjects"."id" = "landing_subjects"."subject_id" WHERE "landing_subjects"."id" = ? LIMIT ?`
sql app/views/mailers/company_mailer/solicitation_relaunch_company.mjml:6	<1%
Average Self 1.9ms Average calls 0.02x Total Self 0.03ms Total Children 0ms Total runtime 0.03ms `SELECT "subjects".* FROM "subjects" INNER JOIN "landing_subjects" ON "subjects"."id" = "landing_subjects"."subject_id" WHERE "landing_subjects"."id" = ? LIMIT ?`
view app/views/mailers/expert_mailer/_remind_received_needs.mjml	<1%
Average Self 0.11ms Average calls 0.27x Total Self 0.03ms Total Children 0.32ms Total runtime 0.35ms
sql app/models/landing.rb:143	<1%
Average Self 1.6ms Average calls 0.02x Total Self 0.03ms Total Children 0ms Total runtime 0.03ms `SELECT "cooperations".* FROM "cooperations" WHERE "cooperations"."id" = ? LIMIT ?`
sql app/mailers/custom_devise_mailer.rb:20	<1%
Average Self 1.1ms Average calls 0.02x Total Self 0.03ms Total Children 0ms Total runtime 0.03ms `SELECT "institutions".* FROM "institutions" INNER JOIN "antennes" ON "institutions"."id" = "antennes"."institution_id" WHERE "antennes"."id" = ? LIMIT ? SELECT "logos".* FROM "logos" WHERE "logos"."logoable_id" = ? AND "logos"."logoable_type" = ? LIMIT ?`
sql app/models/user.rb:314	<1%
Average Self 0.67ms Average calls 0.04x Total Self 0.03ms Total Children 0ms Total runtime 0.03ms `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? LIMIT ?`
view app/views/devise/mailer/reset_password_instructions.text.erb	<1%
Average Self 3.6ms Average calls <0.01x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms
sql app/models/solicitation.rb:623	<1%
Average Self 5.9ms Average calls <0.01x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
view app/views/mailers/_footer.mjml	<1%
Average Self 0.06ms Average calls 0.42x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms
view app/views/mailers/solicitation_mailer/bad_quality.mjml	<1%
Average Self 1.9ms Average calls 0.01x Total Self 0.02ms Total Children <0.01ms Total runtime 0.03ms
sql app/mailers/user_mailer.rb:16	<1%
Average Self 1.1ms Average calls 0.02x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT "institutions".* FROM "institutions" INNER JOIN "antennes" ON "institutions"."id" = "antennes"."institution_id" WHERE "antennes"."id" = ? LIMIT ? SELECT "logos".* FROM "logos" WHERE "logos"."logoable_id" = ? AND "logos"."logoable_type" = ? LIMIT ?`
sql app/views/mailers/company_mailer/notify_not_reachable.mjml:11	<1%
Average Self 0.53ms Average calls 0.04x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT "experts".* FROM "experts" WHERE "experts"."id" = ? LIMIT ? SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?`
sql app/views/mailers/company_mailer/confirmation_solicitation.mjml:15	<1%
Average Self 4.5ms Average calls <0.01x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT "landing_subjects".* FROM "landing_subjects" WHERE "landing_subjects"."id" = ? LIMIT ?`
view app/views/mailers/company_mailer/solicitation_relaunch_description.mjml	<1%
Average Self 3.3ms Average calls <0.01x Total Self 0.02ms Total Children 0.01ms Total runtime 0.03ms
sql app/models/user.rb:310	<1%
Average Self 0.61ms Average calls 0.03x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? LIMIT ?`
sql app/models/user.rb:318	<1%
Average Self 0.42ms Average calls 0.04x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? LIMIT ?`
sql app/models/user.rb:365	<1%
Average Self 0.64ms Average calls 0.03x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:41	<1%
Average Self 15ms Average calls <0.01x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ? SELECT "contacts".* FROM "contacts" WHERE "contacts"."id" = ? LIMIT ?`
view app/views/mailers/company_mailer/intelligent_retention.mjml	<1%
Average Self 29ms Average calls <0.01x Total Self 0.02ms Total Children <0.01ms Total runtime 0.02ms
sql app/models/solicitation.rb:616	<1%
Average Self 1.2ms Average calls 0.01x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
sql app/views/mailers/company_mailer/notify_not_reachable.mjml:5	<1%
Average Self 0.71ms Average calls 0.02x Total Self 0.01ms Total Children 0ms Total runtime 0.01ms `SELECT "companies".* FROM "companies" INNER JOIN "facilities" ON "companies"."id" = "facilities"."company_id" WHERE "facilities"."id" = ? LIMIT ?`
view app/views/devise/mailer/invitation_instructions.mjml	<1%
Average Self 1ms Average calls 0.01x Total Self 0.01ms Total Children 0.04ms Total runtime 0.05ms
sql app/views/mailers/company_mailer/satisfaction.mjml:4	<1%
Average Self 20ms Average calls <0.01x Total Self 0.01ms Total Children 0ms Total runtime 0.01ms `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/mailers/user_mailer/invite_to_demo.mjml	<1%
Average Self 1.2ms Average calls <0.01x Total Self <0.01ms Total Children 0.02ms Total runtime 0.03ms
view app/views/devise/mailer/reset_password_instructions.mjml	<1%
Average Self 1.2ms Average calls <0.01x Total Self <0.01ms Total Children 0.01ms Total runtime 0.02ms
sql app/mailers/custom_devise_mailer.rb:34	<1%
Average Self 0.5ms Average calls 0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "institutions".* FROM "institutions" INNER JOIN "antennes" ON "institutions"."id" = "antennes"."institution_id" WHERE "antennes"."id" = ? LIMIT ? SELECT "logos".* FROM "logos" WHERE "logos"."logoable_id" = ? AND "logos"."logoable_type" = ? LIMIT ?`
sql app/views/mailers/company_mailer/intelligent_retention.mjml:10	<1%
Average Self 5ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ? SELECT "landing_subjects".* FROM "landing_subjects" INNER JOIN "landing_themes" ON "landing_subjects"."landing_theme_id" = "landing_themes"."id" INNER JOIN "landing_joint_themes" ON "landing_themes"."id" = "landing_joint_themes"."landing_theme_id" INNER JOIN "subjects" ON "subjects"."id" = "landing_subjects"."subject_id" WHERE "landing_joint_themes"."landing_id" = ? AND "landing_subjects"."subject_id" = ? ORDER BY "landing_joint_themes"."position" ASC LIMIT ?
sql app/views/mailers/company_mailer/solicitation_relaunch_description.mjml:6	<1%
Average Self 1ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "subjects".* FROM "subjects" INNER JOIN "landing_subjects" ON "subjects"."id" = "landing_subjects"."subject_id" WHERE "landing_subjects"."id" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:79	<1%
Average Self 7ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "solicitations".* FROM "solicitations" INNER JOIN "diagnoses" ON "solicitations"."id" = "diagnoses"."solicitation_id" WHERE "diagnoses"."id" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:44	<1%
Average Self 7ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
view app/views/mailers/solicitation_mailer/carsat.mjml	<1%
Average Self 3ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms
view app/views/mailers/solicitation_mailer/creation.mjml	<1%
Average Self 2.5ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms
view app/views/mailers/company_mailer/satisfaction.mjml	<1%
Average Self 5ms Average calls <0.01x Total Self <0.01ms Total Children 0.01ms Total runtime 0.01ms
sql app/models/user.rb:360	<1%
Average Self 1ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?`
view app/views/mailers/solicitation_mailer/formalites_asso_agri_sci.mjml	<1%
Average Self 0.44ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms
sql app/views/mailers/solicitation_mailer/bad_quality.mjml:5	<1%
Average Self 0.3ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "subjects".* FROM "subjects" INNER JOIN "landing_subjects" ON "subjects"."id" = "landing_subjects"."subject_id" WHERE "landing_subjects"."id" = ? LIMIT ?`
sql app/views/mailers/solicitation_mailer/bad_quality.mjml:8	<1%
Average Self 0.27ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "subjects".* FROM "subjects" INNER JOIN "landing_subjects" ON "subjects"."id" = "landing_subjects"."subject_id" WHERE "landing_subjects"."id" = ? LIMIT ?`
view app/views/mailers/company_mailer/failed_need.mjml	<1%
Average Self 3ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms
view app/views/mailers/solicitation_mailer/no_expert_agri.mjml	<1%
Average Self 1ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms
sql app/views/mailers/company_mailer/solicitation_relaunch_description.mjml:10	<1%
Average Self 0.5ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "subjects".* FROM "subjects" INNER JOIN "landing_subjects" ON "subjects"."id" = "landing_subjects"."subject_id" WHERE "landing_subjects"."id" = ? LIMIT ?`
sql app/mailers/solicitation_mailer.rb:15	<1%
Average Self 0.17ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "landing_subjects".* FROM "landing_subjects" WHERE "landing_subjects"."id" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:60	<1%
Average Self 0.5ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ? SELECT "contacts".* FROM "contacts" WHERE "contacts"."id" = ? LIMIT ?`
view app/views/mailers/solicitation_mailer/sie_sip_declare_and_pay.mjml	<1%
Average Self 1ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms
sql app/models/landing.rb:86	<1%
Average Self 0.25ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "landings".* FROM "landings" WHERE "landings"."slug" = ? LIMIT ?`
sql app/models/user.rb:361	<1%
Average Self 0.5ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "user_rights".* FROM "user_rights" WHERE "user_rights"."category" = ? ORDER BY "user_rights"."id" ASC LIMIT ? SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?`
view app/views/mailers/solicitation_mailer/no_expert.mjml	<1%
Average Self 0.2ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms
view app/views/mailers/solicitation_mailer/tns_training.mjml	<1%
Average Self 1ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms
sql app/views/mailers/company_mailer/intelligent_retention.mjml:14	<1%
Average Self 0.5ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ? SELECT "landing_subjects".* FROM "landing_subjects" INNER JOIN "landing_themes" ON "landing_subjects"."landing_theme_id" = "landing_themes"."id" INNER JOIN "landing_joint_themes" ON "landing_themes"."id" = "landing_joint_themes"."landing_theme_id" INNER JOIN "subjects" ON "subjects"."id" = "landing_subjects"."subject_id" WHERE "landing_joint_themes"."landing_id" = ? AND "landing_subjects"."subject_id" = ? ORDER BY "landing_joint_themes"."position" ASC LIMIT ?
view app/views/mailers/solicitation_mailer/moderation.mjml	<1%
Average Self 0ms Average calls <0.01x Total Self 0ms Total Children 0ms Total runtime 0ms
view app/views/mailers/solicitation_mailer/sie_tva_and_others.mjml	<1%
Average Self 0ms Average calls <0.01x Total Self 0ms Total Children 0ms Total runtime 0ms
sql app/views/mailers/company_mailer/failed_need.mjml:6	<1%
Average Self 0ms Average calls <0.01x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
sql app/models/landing.rb:139	<1%
Average Self 0ms Average calls 0.01x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "cooperations".* FROM "cooperations" WHERE "cooperations"."id" = ? LIMIT ?`
sql app/views/mailers/company_mailer/intelligent_retention.mjml:9	<1%
Average Self 0ms Average calls <0.01x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
view app/views/mailers/solicitation_mailer/employee_labor_law.mjml	<1%
Average Self 0ms Average calls <0.01x Total Self 0ms Total Children 0ms Total runtime 0ms

Slowest executions

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