Oblyk API

.MD

Api::V1::CurrentUsersController#projects

…

…

…

Most impactful sections

code73%
sql27%

code app/controllers/api/v1/current_users_controller.rb:167	70%
Average Self 37ms Average calls 1x Total Self 37ms Total Children 14ms Total runtime 51ms `Api::V1::CurrentUsersController#projects`
sql app/controllers/api/v1/current_users_controller.rb:183	18%
Average Self 1ms Average calls 9x Total Self 9.3ms Total Children 0ms Total runtime 9.3ms SELECT `crag_routes`.* FROM `crag_routes` INNER JOIN `crags` ON `crags`.`id` = `crag_routes`.`crag_id` AND (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`id` IN (?) AND `crag_routes`.`id` NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? [TRUNCATED]
code /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525	3%
Average Self 1.3ms Average calls 1x Total Self 1.3ms Total Children 51ms Total runtime 53ms `Rails::Engine#call`
sql app/controllers/api/v1/api_controller.rb:64	3%
Average Self 1.3ms Average calls 1x Total Self 1.3ms Total Children 0ms Total runtime 1.3ms SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
sql app/controllers/api/v1/current_users_controller.rb:168	3%
Average Self 1.3ms Average calls 1x Total Self 1.3ms Total Children 0ms Total runtime 1.3ms SELECT `ascents`.`crag_route_id` FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` = ?
sql app/controllers/api/v1/current_users_controller.rb:169	2%
Average Self 1ms Average calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms SELECT `ascents`.`crag_route_id` FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ?
sql app/models/crag_sector.rb:115	1%
Average Self 1ms Average calls 0.67x Total Self 0.67ms Total Children 0ms Total runtime 0.67ms SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = ? LIMIT ?
sql app/models/concerns/attachment_resizable.rb:10	1%
Average Self 1ms Average calls 0.67x Total Self 0.67ms Total Children 0ms Total runtime 0.67ms 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/concerns/attachment_resizable.rb:12	<1%
Average Self 0ms Average calls 0.67x Total Self 0ms Total Children 0ms Total runtime 0ms SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?

Slowest executions

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