Oblyk API

.MD

Api::V1::Statistics::CrossStatisticsController#index

…

Most impactful sections

sql65%
code22%
unknown7%
rack6%
cache<1%


sql app/controllers/api/v1/statistics/cross_statistics_controller.rb:53	36%
Average Self 13ms Calls 1x Total Self 13ms Total Children 0ms Total runtime 13ms SELECT COUNT(*) AS count, CONCAT(gym_spaces.name, " / ", gym_sectors.name) AS by_field, gym_routes.min_grade_value AS number_of FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_sectors`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` ON `gym_spaces`.`id` = `gym_sectors`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) WHERE `gym_spaces`.`gym_id` = ? AND `gym_spaces`.`archived_at` IS NULL AND `gym_spaces`.`deleted_at` IS NULL AND (gym_routes.dismounted_at IS NULL OR gym_routes.dismounted_at > ?) GROUP BY by_field, number_of ORDER BY by_field, number_of
sql app/controllers/api/v1/statistics/cross_statistics_controller.rb:40	25%
Average Self 9ms Calls 1x Total Self 9ms Total Children 0ms Total runtime 9ms SELECT DISTINCT gym_routes.min_grade_value AS distinct_number_of FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_sectors`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` ON `gym_spaces`.`id` = `gym_sectors`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) WHERE `gym_spaces`.`gym_id` = ? AND `gym_spaces`.`archived_at` IS NULL AND `gym_spaces`.`deleted_at` IS NULL AND `gym_routes`.`dismounted_at` IS NULL ORDER BY distinct_number_of
code app/controllers/api/v1/statistics/cross_statistics_controller.rb:9	22%
Average Self 8ms Calls 1x Total Self 8ms Total Children 25ms Total runtime 33ms `Api::V1::Statistics::CrossStatisticsController#index`
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	3%
Average Self 1ms Calls 1x Total Self 1ms Total Children 34ms Total runtime 35ms `ActionDispatch::RemoteIp`
sql app/controllers/api/v1/api_controller.rb:50	3%
Average Self 1ms Calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = ? LIMIT ?
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/rack-2.2.23/lib/rack/session/abstract/id.rb:259	3%
Average Self 1ms Calls 1x Total Self 1ms Total Children 33ms Total runtime 34ms `ActionDispatch::Session::CookieStore`
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 34ms Total runtime 34ms `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 34ms Total runtime 34ms `Rails::Rack::Logger`
rack /var/www/oblyk/api/shared/bundle/ruby/2.7.0/gems/actionpack-6.0.6.1/lib/action_dispatch/middleware/ssl.rb:70	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 35ms Total runtime 35ms `ActionDispatch::SSL`
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 35ms Total runtime 35ms `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 35ms Total runtime 35ms `RequestStore::Middleware`
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/rack-2.2.23/lib/rack/sendfile.rb:126	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 35ms Total runtime 35ms `Rack::Sendfile`
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 34ms Total runtime 34ms `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 35ms Total runtime 35ms `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 34ms Total runtime 34ms `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 34ms Total runtime 34ms `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 35ms Total runtime 35ms `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 34ms Total runtime 34ms `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 35ms Total runtime 35ms `Rack::Runtime`
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/actionpack-6.0.6.1/lib/action_dispatch/middleware/request_id.rb:24	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 35ms Total runtime 35ms `ActionDispatch::RequestId`
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 35ms Total runtime 35ms `Rails::Engine#call`
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 34ms Total runtime 34ms `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 34ms Total runtime 34ms `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 34ms Total runtime 34ms `ActionDispatch::Cookies`
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 35ms Total runtime 35ms `ActionDispatch::HostAuthorization`

Slowest executions

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