Oblyk API

.MD

Api::V1::GymsController#videos

…

Most impactful sections

code59%
sql41%


code app/controllers/api/v1/gyms_controller.rb:406	59%
Average Self 154ms Calls 1x Total Self 154ms Total Children 107ms Total runtime 261ms `Api::V1::GymsController#videos`
sql app/models/video.rb:90	10%
Average Self 1ms Calls 25x Total Self 25ms Total Children 0ms Total runtime 25ms SELECT `gym_routes`.* FROM `gym_routes` WHERE `gym_routes`.`id` = ? LIMIT ?
sql app/models/video.rb:41	7%
Average Self 0.95ms Calls 20x Total Self 19ms Total Children 0ms Total runtime 19ms SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
sql app/models/video.rb:39	7%
Average Self 0.9ms Calls 20x Total Self 18ms Total Children 0ms Total runtime 18ms 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 ?
sql app/models/video.rb:112	7%
Average Self 0.9ms Calls 20x Total Self 18ms Total Children 0ms Total runtime 18ms 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 ?
sql app/controllers/api/v1/gyms_controller.rb:411	4%
Average Self 10ms Calls 1x Total Self 10ms Total Children 0ms Total runtime 10ms SELECT `videos`.* FROM `videos` WHERE `videos`.`viewable_type` = ? AND `videos`.`viewable_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? [TRUNCATED]
sql app/controllers/api/v1/gyms_controller.rb:408	3%
Average Self 9ms Calls 1x Total Self 9ms Total Children 0ms Total runtime 9ms SELECT `gym_routes`.`id` FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_routes`.`gym_sector_id` = `gym_sectors`.`id` INNER JOIN `gym_spaces` ON `gym_sectors`.`gym_space_id` = `gym_spaces`.`id` WHERE (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? ORDER BY `gym_sectors`.`order` ASC, `gym_spaces`.`order` ASC
sql app/models/video.rb:95	2%
Average Self 0.16ms Calls 25x Total Self 4ms Total Children 0ms Total runtime 4ms SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
sql app/controllers/api/v1/gyms_controller.rb:531	<1%
Average Self 2ms Calls 1x Total Self 2ms Total Children 0ms Total runtime 2ms SELECT COUNT(*) FROM `gym_administrators` WHERE `gym_administrators`.`gym_id` = ? AND `gym_administrators`.`user_id` = ?
code /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525	<1%
Average Self 2ms Calls 1x Total Self 2ms Total Children 261ms Total runtime 263ms `Rails::Engine#call`
sql app/controllers/api/v1/gyms_controller.rb:523	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` = ? LIMIT ?
sql app/controllers/api/v1/api_controller.rb:64	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?

Slowest executions

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