|
code
app/controllers/api/v1/climbing_sessions_controller.rb:15
|
61%
|
app/controllers/api/v1/climbing_sessions_controller.rb:15
- Average Self
-
162ms
- Calls
- 1x
- Total Self
- 162ms
- Total Children
- 99ms
- Total runtime
- 261ms
Api::V1::ClimbingSessionsController#index
|
|
sql
app/models/climbing_session.rb:14
|
10%
|
app/models/climbing_session.rb:14
- Average Self
-
1.1ms
- Calls
- 25x
- Total Self
- 27ms
- Total Children
- 0ms
- Total runtime
- 27ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`climbing_session_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/models/climbing_session.rb:13
|
10%
|
app/models/climbing_session.rb:13
- Average Self
-
1ms
- Calls
- 25x
- Total Self
- 26ms
- Total Children
- 0ms
- Total runtime
- 26ms
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/models/climbing_session.rb:45
|
5%
|
app/models/climbing_session.rb:45
- Average Self
-
0.88ms
- Calls
- 16x
- Total Self
- 14ms
- Total Children
- 0ms
- Total runtime
- 14ms
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/climbing_session.rb:26
|
3%
|
app/models/climbing_session.rb:26
- Average Self
-
0.18ms
- Calls
- 51x
- Total Self
- 9ms
- Total Children
- 0ms
- Total runtime
- 9ms
SELECT `color_system_lines`.* FROM `color_system_lines` WHERE `color_system_lines`.`id` = ? ORDER BY `color_system_lines`.`order` ASC LIMIT ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:53
|
3%
|
app/controllers/api/v1/climbing_sessions_controller.rb:53
- Average Self
-
2.3ms
- Calls
- 4x
- Total Self
- 9ms
- Total Children
- 0ms
- Total runtime
- 9ms
SELECT `climbing_sessions`.* FROM `climbing_sessions` WHERE `climbing_sessions`.`user_id` = ? ORDER BY `climbing_sessions`.`session_date` DESC LIMIT ? OFFSET ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:55
|
2%
|
app/controllers/api/v1/climbing_sessions_controller.rb:55
- Average Self
-
2ms
- Calls
- 3x
- Total Self
- 6ms
- Total Children
- 0ms
- Total runtime
- 6ms
SELECT DISTINCT `climbing_sessions`.`session_date` AS alias_0, `climbing_sessions`.`id` FROM `climbing_sessions` INNER JOIN `ascents` ON `ascents`.`climbing_session_id` = `climbing_sessions`.`id` AND `ascents`.`type` = ? LEFT OUTER JOIN `ascents` `ascents_climbing_sessions` ON `ascents_climbing_sessions`.`climbing_session_id` = `climbing_sessions`.`id` LEFT OUTER JOIN `color_system_lines` ON `color_system_lines`.`id` = `ascents_climbing_sessions`.`color_system_line_id` LEFT OUTER JOIN `crag_routes` ON `crag_routes`.`id` = `ascents_climbing_sessions`.`crag_route_id` AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) WHERE `climbing_sessions`.`user_id` = ? ORDER BY `climbing_sessions`.`session_date` DESC LIMIT ? OFFSET ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:56
|
2%
|
app/controllers/api/v1/climbing_sessions_controller.rb:56
- Average Self
-
1.7ms
- Calls
- 3x
- Total Self
- 5ms
- Total Children
- 0ms
- Total runtime
- 5ms
SELECT DISTINCT `climbing_sessions`.`session_date` AS alias_0, `climbing_sessions`.`id` FROM `climbing_sessions` INNER JOIN `ascents` ON `ascents`.`climbing_session_id` = `climbing_sessions`.`id` LEFT OUTER JOIN `color_system_lines` ON `color_system_lines`.`id` = `ascents`.`color_system_line_id` LEFT OUTER JOIN `crag_routes` ON `crag_routes`.`id` = `ascents`.`crag_route_id` AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) WHERE `climbing_sessions`.`user_id` = ? ORDER BY `climbing_sessions`.`session_date` DESC LIMIT ? OFFSET ?
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
1%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
3ms
- Calls
- 1x
- Total Self
- 3ms
- Total Children
- 261ms
- Total runtime
- 264ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:29
|
<1%
|
app/controllers/api/v1/climbing_sessions_controller.rb:29
- Average Self
-
2ms
- Calls
- 1x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
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`.`uuid` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
<1%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|