Oblyk API

.MD

Api::V1::SearchesController#search_around

…

Most impactful sections

sql78%
code22%


sql app/controllers/api/v1/searches_controller.rb:91	66%
Average Self 168ms Calls 1x Total Self 168ms Total Children 0ms Total runtime 168ms `SELECT id, type, getrange(latitude, longitude, ?, ?) FROM (SELECT id, ? AS type, name, latitude, longitude FROM crags WHERE deleted_at IS NULL UNION ALL SELECT id, ? AS type, name, latitude, longitude FROM gyms WHERE deleted_at IS NULL) AS crag_and_gyms ORDER BY getrange(latitude, longitude, ?, ?) LIMIT ? OFFSET ?`
code app/controllers/api/v1/searches_controller.rb:66	21%
Average Self 54ms Calls 1x Total Self 54ms Total Children 199ms Total runtime 253ms `Api::V1::SearchesController#search_around`
sql app/models/concerns/attachment_resizable.rb:10	4%
Average Self 1.1ms Calls 8x Total Self 9ms Total Children 0ms Total runtime 9ms 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	3%
Average Self 1ms Calls 8x Total Self 8ms Total Children 0ms Total runtime 8ms SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
sql app/models/gym.rb:182	2%
Average Self 1ms Calls 4x Total Self 4ms Total Children 0ms Total runtime 4ms SELECT `gym_options`.* FROM `gym_options` WHERE `gym_options`.`gym_id` = ?
sql app/models/gym.rb:295	2%
Average Self 1ms Calls 4x Total Self 4ms Total Children 0ms Total runtime 4ms SELECT COUNT(*) FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ?
sql app/controllers/api/v1/searches_controller.rb:100	1%
Average Self 3ms Calls 1x Total Self 3ms Total Children 0ms Total runtime 3ms SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` IN (?)
sql app/models/gym.rb:284	<1%
Average Self 2ms Calls 1x Total Self 2ms Total Children 0ms Total runtime 2ms SELECT `gym_spaces`.* FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? ORDER BY `gym_spaces`.`order` ASC
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 253ms Total runtime 255ms `Rails::Engine#call`
sql app/controllers/api/v1/searches_controller.rb:99	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND ?=?

Slowest executions

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