Place des Entreprises Prod

.MD

ActionMailer::MailDeliveryJob

…

Most impactful sections

code70%
mail26%
gc2%
sql2%
view<1%


code vendor/bundle/ruby/4.0.0/gems/actionmailer-8.1.3/lib/action_mailer/mail_delivery_job.rb:21	70%
Average Self 558ms Average calls 1x Total Self 558ms Total Children 217ms Total runtime 775ms `ActionMailer::MailDeliveryJob#perform`
mail vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158	26%
Average Self 206ms Average calls 1x Total Self 206ms Total Children 0ms Total runtime 206ms `CompanyMailer`
gc ruby/gc.c	2%
Average Self 20ms Average calls 0.94x Total Self 19ms Total Children 0ms Total runtime 19ms `GC.start`
sql vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158	<1%
Average Self 6.1ms Average calls 1x Total Self 6.1ms Total Children 0ms Total runtime 6.1ms `SELECT "needs".* FROM "needs" WHERE "needs"."id" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:52	<1%
Average Self 0.98ms Average calls 1.4x Total Self 1.3ms Total Children 0ms Total runtime 1.3ms `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.68x Total Self 1.3ms Total Children 0ms Total runtime 1.3ms `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/sidekiq-8.1.6/lib/active_job/queue_adapters/sidekiq_adapter.rb:13	<1%
Average Self 1.2ms Average calls 1x Total Self 1.2ms Total Children 781ms Total runtime 782ms `ActionMailer::MailDeliveryJob#perform`
sql app/views/mailers/company_mailer/not_yet_taken_care.mjml:7	<1%
Average Self 5ms Average calls 0.19x Total Self 0.94ms Total Children 0ms Total runtime 0.94ms `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.38x Total Self 0.91ms Total Children 0ms Total runtime 0.91ms `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.68x Total Self 0.86ms Total Children 2.1ms Total runtime 2.9ms
sql app/views/mailers/company_mailer/retention.mjml:8	<1%
Average Self 1ms Average calls 0.68x Total Self 0.71ms Total Children 0ms Total runtime 0.71ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
view app/views/mailers/company_mailer/not_yet_taken_care.mjml	<1%
Average Self 3.2ms Average calls 0.19x Total Self 0.61ms Total Children 1.9ms Total runtime 2.5ms
sql app/models/solicitation.rb:615	<1%
Average Self 2.5ms Average calls 0.23x Total Self 0.57ms Total Children 0ms Total runtime 0.57ms `SELECT "needs".* FROM "needs" INNER JOIN "diagnoses" ON "needs"."diagnosis_id" = "diagnoses"."id" WHERE "diagnoses"."solicitation_id" = ?`
sql app/mailers/company_mailer.rb:90	<1%
Average Self 7.2ms Average calls 0.05x Total Self 0.33ms Total Children 0ms Total runtime 0.33ms `SELECT "cooperations".* FROM "cooperations" WHERE "cooperations"."id" = ? LIMIT ? SELECT "logos".* FROM "logos" WHERE "logos"."logoable_id" = ? AND "logos"."logoable_type" = ? LIMIT ?`
sql app/views/mailers/company_mailer/notify_taking_care.mjml:10	<1%
Average Self 1.3ms Average calls 0.18x Total Self 0.24ms Total Children 0ms Total runtime 0.24ms `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 ?`
sql app/mailers/company_mailer.rb:41	<1%
Average Self 15ms Average calls 0.02x Total Self 0.23ms Total Children 0ms Total runtime 0.23ms `SELECT "diagnoses".* FROM "diagnoses" WHERE "diagnoses"."id" = ? LIMIT ? SELECT "contacts".* FROM "contacts" WHERE "contacts"."id" = ? LIMIT ?`
sql app/models/solicitation.rb:616	<1%
Average Self 1.2ms Average calls 0.19x Total Self 0.22ms Total Children 0ms Total runtime 0.22ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
sql app/models/landing_subject.rb:78	<1%
Average Self 4.2ms Average calls 0.04x Total Self 0.16ms Total Children 0ms Total runtime 0.16ms `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/views/mailers/company_mailer/satisfaction.mjml:4	<1%
Average Self 20ms Average calls <0.01x Total Self 0.15ms Total Children 0ms Total runtime 0.15ms `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/solicitation_mailer/_footer.mjml	<1%
Average Self 0.15ms Average calls 0.99x Total Self 0.14ms Total Children 0ms Total runtime 0.14ms
view app/views/mailers/_header.mjml	<1%
Average Self 0.14ms Average calls 0.99x Total Self 0.14ms Total Children 0ms Total runtime 0.14ms
view app/views/mailers/company_mailer/confirmation_solicitation.mjml	<1%
Average Self 3.2ms Average calls 0.04x Total Self 0.12ms Total Children 0.53ms Total runtime 0.65ms
sql app/models/antenne.rb:166	<1%
Average Self 8ms Average calls 0.02x Total Self 0.12ms Total Children 0ms Total runtime 0.12ms 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 ?
view app/views/mailers/company_mailer/notify_taking_care.mjml	<1%
Average Self 1.9ms Average calls 0.06x Total Self 0.11ms Total Children 0.33ms Total runtime 0.44ms
view app/views/mailers/_footer.mjml	<1%
Average Self 0.11ms Average calls 0.99x Total Self 0.11ms Total Children 0ms Total runtime 0.11ms
sql app/models/concerns/with_territorial_zones.rb:35	<1%
Average Self 12ms Average calls <0.01x Total Self 0.09ms Total Children 0ms Total runtime 0.09ms `SELECT "territorial_zones".* FROM "territorial_zones" WHERE "territorial_zones"."zoneable_id" = ? AND "territorial_zones"."zoneable_type" = ?`
sql app/services/partner_origin.rb:72	<1%
Average Self 5.5ms Average calls 0.02x Total Self 0.08ms Total Children 0ms Total runtime 0.08ms `SELECT "landings".* FROM "landings" WHERE "landings"."id" = ? LIMIT ?`
sql app/models/institution.rb:167	<1%
Average Self 0.91ms Average calls 0.08x Total Self 0.08ms Total Children 0ms Total runtime 0.08ms `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/mailers/company_mailer.rb:21	<1%
Average Self 1.1ms Average calls 0.06x Total Self 0.07ms Total Children 0ms Total runtime 0.07ms `SELECT "contacts".* FROM "contacts" WHERE "contacts"."id" = ? LIMIT ?`
code vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 775ms Total runtime 775ms `ActionMailer::MailDeliveryJob`
sql app/views/mailers/expert_mailer/_support_user_signature.mjml:15	<1%
Average Self 8ms Average calls <0.01x Total Self 0.06ms Total Children 0ms Total runtime 0.06ms `SELECT "profil_pictures".* FROM "profil_pictures" WHERE "profil_pictures"."user_id" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:44	<1%
Average Self 7ms Average calls <0.01x Total Self 0.05ms Total Children 0ms Total runtime 0.05ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
code vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182	<1%
Average Self 0.05ms Average calls 0.99x Total Self 0.05ms Total Children 776ms Total runtime 776ms
sql app/models/solicitation.rb:618	<1%
Average Self 1.4ms Average calls 0.04x Total Self 0.05ms Total Children 0ms Total runtime 0.05ms `SELECT "landing_subjects".* FROM "landing_subjects" WHERE "landing_subjects"."id" = ? LIMIT ?`
sql app/models/landing_subject.rb:79	<1%
Average Self 1.2ms Average calls 0.04x Total Self 0.05ms Total Children 0ms Total runtime 0.05ms 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/landing_subject.rb:80	<1%
Average Self 1.2ms Average calls 0.04x Total Self 0.05ms Total Children 0ms Total runtime 0.05ms 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:18	<1%
Average Self 0.75ms Average calls 0.06x Total Self 0.05ms Total Children 0ms Total runtime 0.05ms `SELECT "diagnoses".* FROM "diagnoses" INNER JOIN "needs" ON "diagnoses"."id" = "needs"."diagnosis_id" WHERE "needs"."id" = ? LIMIT ?`
view app/views/mailers/company_mailer/satisfaction.mjml	<1%
Average Self 5ms Average calls <0.01x Total Self 0.04ms Total Children 0.16ms Total runtime 0.2ms
sql app/views/mailers/company_mailer/notify_taking_care.mjml:5	<1%
Average Self 0.5ms Average calls 0.06x Total Self 0.03ms Total Children 0ms Total runtime 0.03ms `SELECT "companies".* FROM "companies" INNER JOIN "facilities" ON "companies"."id" = "facilities"."company_id" WHERE "facilities"."id" = ? LIMIT ?`
sql app/models/diagnosis.rb:171	<1%
Average Self 0.4ms Average calls 0.08x Total Self 0.03ms Total Children 0ms Total runtime 0.03ms `SELECT "subjects".* FROM "subjects" WHERE "subjects"."id" = ? LIMIT ?`
view app/views/devise/mailer/invitation_instructions.mjml	<1%
Average Self 3ms Average calls <0.01x Total Self 0.02ms Total Children 0.06ms Total runtime 0.08ms
view app/views/mailers/company_mailer/notify_not_reachable.mjml	<1%
Average Self 1.5ms Average calls 0.02x Total Self 0.02ms Total Children 0.02ms Total runtime 0.05ms
sql app/mailers/custom_devise_mailer.rb:20	<1%
Average Self 1.5ms 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/models/institution.rb:166	<1%
Average Self 0.18ms Average calls 0.08x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `SELECT "categories".* FROM "categories" WHERE "categories"."label" = ? LIMIT ?`
sql app/views/mailers/company_mailer/notify_not_reachable.mjml:11	<1%
Average Self 0.25ms Average calls 0.03x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "experts".* FROM "experts" WHERE "experts"."id" = ? LIMIT ? SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?`
sql app/models/diagnosis.rb:170	<1%
Average Self 0.1ms Average calls 0.08x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms `SELECT "needs".* FROM "needs" WHERE "needs"."diagnosis_id" = ?`
sql app/models/user.rb:314	<1%
Average Self 0ms Average calls 0.02x Total Self 0ms Total Children 0ms Total runtime 0ms `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 0ms Average calls 0.02x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? LIMIT ?`
view app/views/mailers/expert_mailer/_support_user_signature.mjml	<1%
Average Self 0ms Average calls <0.01x Total Self 0ms Total Children 0.06ms Total runtime 0.06ms
view app/views/mailers/_expert_header.mjml	<1%
Average Self 0ms Average calls <0.01x Total Self 0ms Total Children 0ms Total runtime 0ms
sql app/models/user.rb:310	<1%
Average Self 0ms Average calls <0.01x Total Self 0ms Total Children 0ms Total runtime 0ms `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 0ms Average calls <0.01x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?`
sql app/views/mailers/company_mailer/notify_not_reachable.mjml:5	<1%
Average Self 0ms Average calls 0.02x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "companies".* FROM "companies" INNER JOIN "facilities" ON "companies"."id" = "facilities"."company_id" WHERE "facilities"."id" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:31	<1%
Average Self 0ms Average calls 0.02x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "diagnoses".* FROM "diagnoses" INNER JOIN "needs" ON "diagnoses"."id" = "needs"."diagnosis_id" WHERE "needs"."id" = ? LIMIT ?`
sql app/mailers/company_mailer.rb:34	<1%
Average Self 0ms Average calls 0.02x Total Self 0ms Total Children 0ms Total runtime 0ms `SELECT "contacts".* FROM "contacts" WHERE "contacts"."id" = ? LIMIT ?`

Slowest executions

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