|
code
app/controllers/api/v1/climbing_sessions_controller.rb:151
|
58%
|
app/controllers/api/v1/climbing_sessions_controller.rb:151
- Average Self
-
43ms
- Average calls
- 1x
- Total Self
- 43ms
- Total Children
- 29ms
- Total runtime
- 72ms
Api::V1::ClimbingSessionsController#show
|
|
sql
app/models/ascent_crag_route.rb:50
|
5%
|
app/models/ascent_crag_route.rb:50
- Average Self
-
1ms
- Average calls
- 3.5x
- Total Self
- 3.5ms
- Total Children
- 0ms
- Total runtime
- 3.5ms
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`id` = ? LIMIT ?
|
|
sql
app/models/ascent_crag_route.rb:51
|
5%
|
app/models/ascent_crag_route.rb:51
- Average Self
-
1ms
- Average calls
- 3.5x
- Total Self
- 3.5ms
- Total Children
- 0ms
- Total runtime
- 3.5ms
SELECT `crags`.* FROM `crags` INNER JOIN `crag_routes` ON `crags`.`id` = `crag_routes`.`crag_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`id` = ? LIMIT ?
|
|
sql
app/models/ascent_crag_route.rb:52
|
4%
|
app/models/ascent_crag_route.rb:52
- Average Self
-
0.86ms
- Average calls
- 3.5x
- Total Self
- 3ms
- Total Children
- 0ms
- Total runtime
- 3ms
SELECT `ascent_users`.* FROM `ascent_users` WHERE `ascent_users`.`ascent_id` = ?
|
|
sql
app/models/climbing_session.rb:45
|
3%
|
app/models/climbing_session.rb:45
- Average Self
-
0.71ms
- Average calls
- 3.5x
- Total Self
- 2.5ms
- Total Children
- 0ms
- Total runtime
- 2.5ms
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`id` = ? LIMIT ?
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
3%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
2ms
- Average calls
- 1x
- Total Self
- 2ms
- Total Children
- 72ms
- Total runtime
- 74ms
Rails::Engine#call
|
|
sql
app/models/climbing_session.rb:97
|
3%
|
app/models/climbing_session.rb:97
- Average Self
-
1ms
- Average calls
- 2x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT `ascents`.`id` FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`climbing_session_id` = ?
|
|
sql
app/models/climbing_session.rb:112
|
2%
|
app/models/climbing_session.rb:112
- Average Self
-
1.5ms
- Average calls
- 1x
- Total Self
- 1.5ms
- Total Children
- 0ms
- Total runtime
- 1.5ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`climbing_session_id` = ?
|
|
sql
app/models/climbing_session.rb:91
|
2%
|
app/models/climbing_session.rb:91
- Average Self
-
1.5ms
- Average calls
- 1x
- Total Self
- 1.5ms
- Total Children
- 0ms
- Total runtime
- 1.5ms
SELECT MAX(`climbing_sessions`.`session_date`) FROM `climbing_sessions` WHERE `climbing_sessions`.`user_id` = ? AND (climbing_sessions.session_date < ?)
|
|
sql
app/models/climbing_session.rb:13
|
2%
|
app/models/climbing_session.rb:13
- Average Self
-
1.5ms
- Average calls
- 1x
- Total Self
- 1.5ms
- Total Children
- 0ms
- Total runtime
- 1.5ms
SELECT `ascents`.* FROM `ascents` INNER JOIN `crag_routes` ON `crag_routes`.`id` = `ascents`.`crag_route_id` AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) INNER JOIN `crags` ON `crags`.`id` = `crag_routes`.`crag_id` AND (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) WHERE `ascents`.`climbing_session_id` = ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:185
|
2%
|
app/controllers/api/v1/climbing_sessions_controller.rb:185
- Average Self
-
1.5ms
- Average calls
- 1x
- Total Self
- 1.5ms
- Total Children
- 0ms
- Total runtime
- 1.5ms
SELECT `climbing_sessions`.* FROM `climbing_sessions` WHERE `climbing_sessions`.`session_date` = ? AND `climbing_sessions`.`user_id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
2%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.5ms
- Average calls
- 1x
- Total Self
- 1.5ms
- Total Children
- 0ms
- Total runtime
- 1.5ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:162
|
1%
|
app/controllers/api/v1/climbing_sessions_controller.rb:162
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `users`.* FROM `users` WHERE (EXISTS(SELECT followable_id
FROM follows
WHERE followable_type = "User"
AND followable_id = users.id
AND accepted_at IS NOT NULL
AND user_id = ?)) AND `users`.`id` = ? LIMIT ?
|
|
sql
app/models/climbing_session.rb:14
|
1%
|
app/models/climbing_session.rb:14
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`climbing_session_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/models/climbing_session.rb:95
|
1%
|
app/models/climbing_session.rb:95
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT MIN(`climbing_sessions`.`session_date`) FROM `climbing_sessions` WHERE `climbing_sessions`.`user_id` = ? AND (climbing_sessions.session_date > ?)
|
|
sql
app/models/climbing_session.rb:127
|
1%
|
app/models/climbing_session.rb:127
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `users`.* FROM `users` WHERE ?=?
|
|
sql
app/models/climbing_session.rb:100
|
1%
|
app/models/climbing_session.rb:100
- Average Self
-
1ms
- Average 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 `crags`.`id` = ?
|
|
sql
app/models/climbing_session.rb:104
|
1%
|
app/models/climbing_session.rb:104
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`climbing_session_id` = ?
|
|
sql
app/models/climbing_session.rb:101
|
<1%
|
app/models/climbing_session.rb:101
- Average Self
-
0.5ms
- Average calls
- 1x
- Total Self
- 0.5ms
- Total Children
- 0ms
- Total runtime
- 0.5ms
SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND ?=?
|
|
sql
app/models/climbing_session.rb:73
|
<1%
|
app/models/climbing_session.rb:73
- Average Self
-
0.5ms
- Average calls
- 1x
- Total Self
- 0.5ms
- Total Children
- 0ms
- Total runtime
- 0.5ms
SELECT COUNT(*) FROM `ascents` WHERE `ascents`.`climbing_session_id` = ?
|
|
sql
app/models/climbing_session.rb:89
|
<1%
|
app/models/climbing_session.rb:89
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:165
|
<1%
|
app/controllers/api/v1/climbing_sessions_controller.rb:165
- Average Self
-
0ms
- Average calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT `climbing_sessions`.* FROM `climbing_sessions` WHERE `climbing_sessions`.`session_date` = ? AND `climbing_sessions`.`user_id` = ? LIMIT ?
|