Oblyk API

.MD

SendPublicationsEmailsJob

…

Most impactful sections

code91%
sql8%
view1%
unknown<1%
redis<1%


code app/jobs/send_publications_emails_job.rb:6	91%
Average Self 18,399ms Calls 1x Total Self 18,399ms Total Children 1,869ms Total runtime 20,268ms `SendPublicationsEmailsJob#perform`
sql app/jobs/send_publications_emails_job.rb:23	6%
Average Self 4.2ms Calls 271x Total Self 1,137ms Total Children 0ms Total runtime 1,137ms UPDATE `notifications` SET `notifications`.`email_notification_sent_at` = ? WHERE `notifications`.`user_id` = ? AND `notifications`.`notification_type` = ? AND `notifications`.`notifiable_type` = ? AND `notifications`.`notifiable_id` = ? ORDER BY `notifications`.`posted_at` DESC
sql app/jobs/send_publications_emails_job.rb:19	2%
Average Self 1.5ms Calls 271x Total Self 420ms Total Children 0ms Total runtime 420ms SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
view app/views/notification_mailer/new_publications.html.erb	<1%
Average Self 0.55ms Calls 271x Total Self 148ms Total Children 0ms Total runtime 148ms
view app/views/notification_mailer/new_publications.text.erb	<1%
Average Self 0.5ms Calls 271x Total Self 135ms Total Children 0ms Total runtime 135ms
sql app/jobs/send_publications_emails_job.rb:15	<1%
Average Self 9ms Calls 2x Total Self 18ms Total Children 0ms Total runtime 18ms SELECT `notifications`.* FROM `notifications` INNER JOIN `users` ON `users`.`id` = `notifications`.`user_id` WHERE `notifications`.`notification_type` = ? AND `notifications`.`notifiable_type` = ? AND (JSON_SEARCH(users.email_notifiable_list, ?, ?)) AND `notifications`.`read_at` IS NULL AND `notifications`.`email_notification_sent_at` IS NULL AND `notifications`.`posted_at` BETWEEN ? AND ? ORDER BY `notifications`.`posted_at` DESC
sql app/mailers/notification_mailer.rb:40	<1%
Average Self 4ms Calls 1x Total Self 4ms Total Children 0ms Total runtime 4ms SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` = ? LIMIT ?
sql app/models/notification.rb:31	<1%
Average Self 3ms Calls 1x Total Self 3ms Total Children 0ms Total runtime 3ms `SET NAMES utf8mb4, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ?), ?), @@SESSION.sql_auto_is_null = ?, @@SESSION.wait_timeout = ?`
sql app/models/concerns/attachment_resizable.rb:12	<1%
Average Self 2ms Calls 1x Total Self 2ms Total Children 0ms Total runtime 2ms SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
sql app/models/concerns/attachment_resizable.rb:10	<1%
Average Self 2ms Calls 1x Total Self 2ms Total Children 0ms Total runtime 2ms SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = ? AND `active_storage_attachments`.`record_type` = ? AND `active_storage_attachments`.`name` = ? LIMIT ?
code /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/activesupport-6.0.3.6/lib/active_support/callbacks.rb:121	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 20,268ms Total runtime 20,268ms `SendPublicationsEmailsJob`
redis app/jobs/send_publications_emails_job.rb:27	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms `multi`

Slowest executions

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