|
code
app/controllers/api/v1/climbing_sessions_controller.rb:82
|
39%
|
app/controllers/api/v1/climbing_sessions_controller.rb:82
- Average Self
-
9.5ms
- Average calls
- 1x
- Total Self
- 9.5ms
- Total Children
- 12ms
- Total runtime
- 22ms
Api::V1::ClimbingSessionsController#friends_climbing_sessions
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:105
|
25%
|
app/controllers/api/v1/climbing_sessions_controller.rb:105
- Average Self
-
6ms
- Average calls
- 1x
- Total Self
- 6ms
- Total Children
- 0ms
- Total runtime
- 6ms
SELECT `ascents`.* FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY released_at DESC, min_grade_value DESC, gym_grade_level DESC) AS rn FROM `ascents` WHERE `ascents`.`user_id` IN (?) AND `ascents`.`ascent_status` != ?) AS ascents WHERE (rn = ?)
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:99
|
20%
|
app/controllers/api/v1/climbing_sessions_controller.rb:99
- Average Self
-
2.2ms
- Average calls
- 2.3x
- Total Self
- 4.9ms
- Total Children
- 0ms
- Total runtime
- 4.9ms
SELECT users.*, (SELECT released_at FROM ascents WHERE ascents.user_id = users.id AND ascents.ascent_status != "project" ORDER BY released_at DESC LIMIT ?) AS last_released_at FROM `users` WHERE (EXISTS(SELECT *
FROM follows
WHERE follows.followable_type = "User"
AND follows.followable_id = users.id
AND follows.followable_id != ?
AND follows.accepted_at IS NOT NULL
AND follows.user_id = ?)) ORDER BY last_released_at DESC, users.id LIMIT ? OFFSET ?
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
8%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
1.9ms
- Average calls
- 1x
- Total Self
- 1.9ms
- Total Children
- 22ms
- Total runtime
- 24ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
7%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.6ms
- Average calls
- 1x
- Total Self
- 1.6ms
- Total Children
- 0ms
- Total runtime
- 1.6ms
SET NAMES utf8mb4, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ?), ?), @@SESSION.sql_auto_is_null = ?, @@SESSION.wait_timeout = ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:111
|
2%
|
app/controllers/api/v1/climbing_sessions_controller.rb:111
- Average Self
-
1.1ms
- Average calls
- 0.37x
- Total Self
- 0.39ms
- Total Children
- 0ms
- Total runtime
- 0.39ms
SELECT `gym_routes`.* FROM `gym_routes` WHERE `gym_routes`.`id` = ? LIMIT ?
|