|
code
app/controllers/api/v1/climbing_sessions_controller.rb:15
|
61%
|
app/controllers/api/v1/climbing_sessions_controller.rb:15
- Average Self
-
95ms
- Average calls
- 1x
- Total Self
- 95ms
- Total Children
- 59ms
- Total runtime
- 155ms
Api::V1::ClimbingSessionsController#index
|
|
sql
app/models/climbing_session.rb:13
|
9%
|
app/models/climbing_session.rb:13
- Average Self
-
1.6ms
- Average calls
- 9.3x
- Total Self
- 14ms
- Total Children
- 0ms
- Total runtime
- 14ms
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:14
|
9%
|
app/models/climbing_session.rb:14
- Average Self
-
1.6ms
- Average calls
- 9.3x
- Total Self
- 14ms
- Total Children
- 0ms
- Total runtime
- 14ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`climbing_session_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:56
|
5%
|
app/controllers/api/v1/climbing_sessions_controller.rb:56
- Average Self
-
2.5ms
- Average calls
- 3x
- Total Self
- 7.5ms
- Total Children
- 0ms
- Total runtime
- 7.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` = ? AND (EXISTS(SELECT * FROM ascents WHERE gym_id IS NOT NULL AND climbing_session_id = climbing_sessions.id)) ORDER BY `climbing_sessions`.`session_date` DESC LIMIT ? OFFSET ?
|
|
sql
app/models/climbing_session.rb:26
|
5%
|
app/models/climbing_session.rb:26
- Average Self
-
0.27ms
- Average calls
- 27x
- Total Self
- 7.3ms
- Total Children
- 0ms
- Total runtime
- 7.3ms
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
-
1.7ms
- Average calls
- 3x
- Total Self
- 5.1ms
- Total Children
- 0ms
- Total runtime
- 5.1ms
SELECT `climbing_sessions`.* FROM `climbing_sessions` WHERE `climbing_sessions`.`user_id` = ? AND (EXISTS(SELECT * FROM ascents WHERE gym_id IS NOT NULL AND climbing_session_id = climbing_sessions.id)) ORDER BY `climbing_sessions`.`session_date` DESC LIMIT ? OFFSET ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:55
|
3%
|
app/controllers/api/v1/climbing_sessions_controller.rb:55
- Average Self
-
2.1ms
- Average calls
- 2x
- Total Self
- 4.1ms
- Total Children
- 0ms
- Total runtime
- 4.1ms
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` = ? AND (EXISTS(SELECT * FROM ascents WHERE gym_id IS NOT NULL AND climbing_session_id = climbing_sessions.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
|
2%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
2.6ms
- Average calls
- 1x
- Total Self
- 2.6ms
- Total Children
- 155ms
- Total runtime
- 158ms
Rails::Engine#call
|
|
sql
app/models/concerns/attachment_resizable.rb:10
|
2%
|
app/models/concerns/attachment_resizable.rb:10
- Average Self
-
4.4ms
- Average calls
- 0.57x
- Total Self
- 2.5ms
- Total Children
- 0ms
- Total runtime
- 2.5ms
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/controllers/api/v1/api_controller.rb:64
|
1%
|
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
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/models/concerns/attachment_resizable.rb:12
|
<1%
|
app/models/concerns/attachment_resizable.rb:12
- Average Self
-
1.1ms
- Average calls
- 0.57x
- Total Self
- 0.64ms
- Total Children
- 0ms
- Total runtime
- 0.64ms
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
|
|
sql
app/models/gym.rb:295
|
<1%
|
app/models/gym.rb:295
- Average Self
-
1.5ms
- Average calls
- 0.29x
- Total Self
- 0.43ms
- Total Children
- 0ms
- Total runtime
- 0.43ms
SELECT COUNT(*) FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ?
|
|
sql
app/models/gym.rb:284
|
<1%
|
app/models/gym.rb:284
- Average Self
-
1.5ms
- Average calls
- 0.29x
- Total Self
- 0.43ms
- Total Children
- 0ms
- Total runtime
- 0.43ms
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
|
|
sql
app/models/gym.rb:297
|
<1%
|
app/models/gym.rb:297
- Average Self
-
1.5ms
- Average calls
- 0.29x
- Total Self
- 0.43ms
- Total Children
- 0ms
- Total runtime
- 0.43ms
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 LIMIT ?
|
|
sql
app/models/gym.rb:182
|
<1%
|
app/models/gym.rb:182
- Average Self
-
1.3ms
- Average calls
- 0.29x
- Total Self
- 0.36ms
- Total Children
- 0ms
- Total runtime
- 0.36ms
SELECT `gym_options`.* FROM `gym_options` WHERE `gym_options`.`gym_id` = ?
|