Oblyk API

.MD

Api::V1::Statistics::GymRouteStatisticsController#figures

…

Most impactful sections

sql96%
code4%


sql app/models/statistics/gym_statistic.rb:41	31%
Average Self 229ms Average calls 1x Total Self 229ms Total Children 0ms Total runtime 229ms SELECT MAX(`gym_routes`.`max_grade_value`) 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` INNER JOIN `gym_sectors` `gym_sectors_gym_routes` ON `gym_sectors_gym_routes`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` `gym_spaces_gym_sectors` ON `gym_spaces_gym_sectors`.`id` = `gym_sectors_gym_routes`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) 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` = ? AND (gym_routes.opened_at <= ? AND (gym_routes.dismounted_at IS NULL OR gym_routes.dismounted_at > [TRUNCATED]
sql app/models/statistics/gym_statistic.rb:32	15%
Average Self 112ms Average calls 1x Total Self 112ms Total Children 0ms Total runtime 112ms SELECT COUNT(*) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`ascent_status` != ? AND `ascents`.`gym_route_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? [TRUNCATED]
sql app/models/statistics/gym_statistic.rb:23	13%
Average Self 97ms Average calls 1x Total Self 97ms Total Children 0ms Total runtime 97ms SELECT MIN(`gym_routes`.`opened_at`) 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` INNER JOIN `gym_sectors` `gym_sectors_gym_routes` ON `gym_sectors_gym_routes`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` `gym_spaces_gym_sectors` ON `gym_spaces_gym_sectors`.`id` = `gym_sectors_gym_routes`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) 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` = ? AND (gym_routes.opened_at <= ? AND (gym_routes.dismounted_at IS NULL OR gym_routes.dismounted_at >= '? [TRUNCATED]
sql app/models/statistics/gym_statistic.rb:21	12%
Average Self 90ms Average calls 1x Total Self 90ms Total Children 0ms Total runtime 90ms SELECT `gym_routes`.* 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` INNER JOIN `gym_sectors` `gym_sectors_gym_routes` ON `gym_sectors_gym_routes`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` `gym_spaces_gym_sectors` ON `gym_spaces_gym_sectors`.`id` = `gym_sectors_gym_routes`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) 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` = ? AND (gym_routes.opened_at <= ? AND (gym_routes.dismounted_at IS NULL OR gym_routes.dismounted_at >= ?)) ORDE [TRUNCATED]
sql app/models/statistics/gym_statistic.rb:43	11%
Average Self 81ms Average calls 1x Total Self 81ms Total Children 0ms Total runtime 81ms SELECT AVG(`gym_routes`.`max_grade_value`) 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` INNER JOIN `gym_sectors` `gym_sectors_gym_routes` ON `gym_sectors_gym_routes`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` `gym_spaces_gym_sectors` ON `gym_spaces_gym_sectors`.`id` = `gym_sectors_gym_routes`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) 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` = ? AND (gym_routes.opened_at <= ? AND (gym_routes.dismounted_at IS NULL OR gym_routes.dismounted_at > [TRUNCATED]
sql app/models/statistics/gym_statistic.rb:42	4%
Average Self 30ms Average calls 1x Total Self 30ms Total Children 0ms Total runtime 30ms SELECT MIN(`gym_routes`.`min_grade_value`) 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` INNER JOIN `gym_sectors` `gym_sectors_gym_routes` ON `gym_sectors_gym_routes`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` `gym_spaces_gym_sectors` ON `gym_spaces_gym_sectors`.`id` = `gym_sectors_gym_routes`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) 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` = ? AND (gym_routes.opened_at <= ? AND (gym_routes.dismounted_at IS NULL OR gym_routes.dismounted_at > [TRUNCATED]
sql app/models/statistics/gym_statistic.rb:22	4%
Average Self 29ms Average calls 1x Total Self 29ms Total Children 0ms Total runtime 29ms SELECT MAX(`gym_routes`.`opened_at`) 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` INNER JOIN `gym_sectors` `gym_sectors_gym_routes` ON `gym_sectors_gym_routes`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` `gym_spaces_gym_sectors` ON `gym_spaces_gym_sectors`.`id` = `gym_sectors_gym_routes`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) 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` = ? AND (gym_routes.opened_at <= ? AND (gym_routes.dismounted_at IS NULL OR gym_routes.dismounted_at >= '? [TRUNCATED]
code app/controllers/api/v1/statistics/gym_route_statistics_controller.rb:11	4%
Average Self 26ms Average calls 1x Total Self 26ms Total Children 712ms Total runtime 738ms `Api::V1::Statistics::GymRouteStatisticsController#figures`
sql app/controllers/concerns/gym_roles_verification.rb:13	2%
Average Self 11ms Average calls 1x Total Self 11ms Total Children 0ms Total runtime 11ms SELECT ? AS one FROM `gym_administrators` WHERE `gym_administrators`.`gym_id` = ? AND `gym_administrators`.`user_id` = ? LIMIT ?
sql app/controllers/api/v1/api_controller.rb:26	1%
Average Self 10ms Average calls 1x Total Self 10ms Total Children 0ms Total runtime 10ms SELECT `ip_black_lists`.* FROM `ip_black_lists` WHERE (block_expired_at <= NOW() OR block_expired_at IS NULL) AND `ip_black_lists`.`ip` IS NULL LIMIT ?
sql app/controllers/concerns/gymable.rb:16	1%
Average Self 10ms Average calls 1x Total Self 10ms Total Children 0ms Total runtime 10ms 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 9.3ms Average calls 1x Total Self 9.3ms Total Children 0ms Total runtime 9.3ms SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
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 2.3ms Average calls 1x Total Self 2.3ms Total Children 738ms Total runtime 741ms `Rails::Engine#call`

Slowest executions

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