Oblyk API

.MD

Api::V1::Statistics::GymRouteStatisticsController#opening_frequencies

…

Most impactful sections

sql66%
code26%
unknown5%
rack3%
cache<1%


sql app/models/statistics/gym_statistic.rb:189	29%
Average Self 19ms Calls 1x Total Self 19ms Total Children 0ms Total runtime 19ms 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 >= ?)) ORDER BY `gym_sectors`.`order` ASC, `gym_spaces`.`order` ASC
code app/controllers/api/v1/statistics/gym_route_statistics_controller.rb:42	26%
Average Self 17ms Calls 1x Total Self 17ms Total Children 46ms Total runtime 63ms `Api::V1::Statistics::GymRouteStatisticsController#opening_frequencies`
sql app/models/statistics/gym_statistic.rb:175	20%
Average Self 13ms Calls 1x Total Self 13ms Total Children 0ms Total runtime 13ms SELECT COUNT(*) 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 >= ?))
sql app/models/statistics/gym_statistic.rb:182	17%
Average Self 11ms Calls 1x Total Self 11ms Total Children 0ms Total runtime 11ms 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 >= ?))
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/rack-2.2.23/lib/rack/session/abstract/id.rb:259	2%
Average Self 1ms Calls 1x Total Self 1ms Total Children 63ms Total runtime 64ms `ActionDispatch::Session::CookieStore`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/ssl.rb:70	2%
Average Self 1ms Calls 1x Total Self 1ms Total Children 64ms Total runtime 65ms `ActionDispatch::SSL`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/host_authorization.rb:96	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 65ms Total runtime 65ms `ActionDispatch::HostAuthorization`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/rack-2.2.23/lib/rack/conditional_get.rb:24	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `Rack::ConditionalGet`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/railties-6.0.6.1/lib/rails/rack/logger.rb:22	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `Rails::Rack::Logger`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/executor.rb:11	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `ActionDispatch::Executor`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/request_store-1.7.0/lib/request_store/middleware.rb:16	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `RequestStore::Middleware`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/request_id.rb:24	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `ActionDispatch::RequestId`
cache app/controllers/api/v1/api_controller.rb:49	<1%
Average Self 0ms Calls 2x Total Self 0ms Total Children 0ms Total runtime 0ms `read write`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/show_exceptions.rb:31	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `ActionDispatch::ShowExceptions`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/activesupport-6.0.6.1/lib/active_support/cache/strategy/local_cache_middleware.rb:27	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `ActiveSupport::Cache::Strategy::LocalCache::Middleware`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/rack-2.2.23/lib/rack/head.rb:11	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `Rack::Head`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/debug_exceptions.rb:30	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `ActionDispatch::DebugExceptions`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/rack-cors-2.0.2/lib/rack/cors.rb:66	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 65ms Total runtime 65ms `Rack::Cors`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/rack-2.2.23/lib/rack/etag.rb:26	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `Rack::ETag`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/rack-2.2.23/lib/rack/runtime.rb:20	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `Rack::Runtime`
sql app/controllers/api/v1/api_controller.rb:26	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms 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/api/v1/api_controller.rb:50	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = ? LIMIT ?
sql app/controllers/api/v1/api_controller.rb:64	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
sql app/controllers/concerns/gymable.rb:16	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` = ? LIMIT ?
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/rack-2.2.23/lib/rack/sendfile.rb:126	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `Rack::Sendfile`
code /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/railties-6.0.6.1/lib/rails/engine.rb:525	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 65ms Total runtime 65ms `Rails::Engine#call`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/remote_ip.rb:78	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `ActionDispatch::RemoteIp`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/actionable_exceptions.rb:16	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `ActionDispatch::ActionableExceptions`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/callbacks.rb:24	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `ActionDispatch::Callbacks`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/cookies.rb:651	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 64ms Total runtime 64ms `ActionDispatch::Cookies`

Slowest executions

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