|
code
app/controllers/api/v1/climbing_sessions_controller.rb:15
|
61%
|
app/controllers/api/v1/climbing_sessions_controller.rb:15
- Average Self
-
125ms
- Average calls
- 1x
- Total Self
- 125ms
- Total Children
- 76ms
- Total runtime
- 202ms
Api::V1::ClimbingSessionsController#index
|
|
sql
app/models/climbing_session.rb:13
|
9%
|
app/models/climbing_session.rb:13
- Average Self
-
1.2ms
- Average calls
- 15x
- Total Self
- 18ms
- Total Children
- 0ms
- Total runtime
- 18ms
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
|
8%
|
app/models/climbing_session.rb:14
- Average Self
-
1ms
- Average calls
- 15x
- Total Self
- 15ms
- Total Children
- 0ms
- Total runtime
- 15ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`climbing_session_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/models/climbing_session.rb:26
|
5%
|
app/models/climbing_session.rb:26
- Average Self
-
0.14ms
- Average calls
- 70x
- Total Self
- 10ms
- Total Children
- 0ms
- Total runtime
- 10ms
SELECT `color_system_lines`.* FROM `color_system_lines` WHERE `color_system_lines`.`id` = ? ORDER BY `color_system_lines`.`order` ASC LIMIT ?
|
|
sql
app/models/climbing_session.rb:45
|
4%
|
app/models/climbing_session.rb:45
- Average Self
-
0.98ms
- Average calls
- 8.9x
- Total Self
- 8.7ms
- Total Children
- 0ms
- Total runtime
- 8.7ms
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/controllers/api/v1/climbing_sessions_controller.rb:55
|
3%
|
app/controllers/api/v1/climbing_sessions_controller.rb:55
- Average Self
-
2.8ms
- Average calls
- 2.4x
- Total Self
- 6.8ms
- Total Children
- 0ms
- Total runtime
- 6.8ms
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 ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:53
|
3%
|
app/controllers/api/v1/climbing_sessions_controller.rb:53
- Average Self
-
1.9ms
- Average calls
- 3.2x
- Total Self
- 6.3ms
- Total Children
- 0ms
- Total runtime
- 6.3ms
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:56
|
3%
|
app/controllers/api/v1/climbing_sessions_controller.rb:56
- Average Self
-
2ms
- Average 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` 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 ?
|
|
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
-
3.4ms
- Average calls
- 1x
- Total Self
- 3.4ms
- Total Children
- 202ms
- Total runtime
- 205ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
<1%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.2ms
- Average calls
- 1x
- Total Self
- 1.2ms
- Total Children
- 0ms
- Total runtime
- 1.2ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/models/concerns/attachment_resizable.rb:10
|
<1%
|
app/models/concerns/attachment_resizable.rb:10
- Average Self
-
0.95ms
- Average calls
- 0.93x
- Total Self
- 0.88ms
- Total Children
- 0ms
- Total runtime
- 0.88ms
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
|
<1%
|
app/models/concerns/attachment_resizable.rb:12
- Average Self
-
0.73ms
- Average calls
- 0.9x
- Total Self
- 0.65ms
- Total Children
- 0ms
- Total runtime
- 0.65ms
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:29
|
<1%
|
app/controllers/api/v1/climbing_sessions_controller.rb:29
- Average Self
-
1.5ms
- Average calls
- 0.38x
- Total Self
- 0.56ms
- Total Children
- 0ms
- Total runtime
- 0.56ms
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/models/gym.rb:282
|
<1%
|
app/models/gym.rb:282
- Average Self
-
1.1ms
- Average calls
- 0.28x
- Total Self
- 0.32ms
- Total Children
- 0ms
- Total runtime
- 0.32ms
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:180
|
<1%
|
app/models/gym.rb:180
- Average Self
-
0.88ms
- Average calls
- 0.32x
- Total Self
- 0.28ms
- Total Children
- 0ms
- Total runtime
- 0.28ms
SELECT `gym_options`.* FROM `gym_options` WHERE `gym_options`.`gym_id` = ?
|
|
sql
app/models/gym.rb:295
|
<1%
|
app/models/gym.rb:295
- Average Self
-
0.91ms
- Average calls
- 0.27x
- Total Self
- 0.25ms
- Total Children
- 0ms
- Total runtime
- 0.25ms
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:293
|
<1%
|
app/models/gym.rb:293
- Average Self
-
0.65ms
- Average calls
- 0.32x
- Total Self
- 0.21ms
- Total Children
- 0ms
- Total runtime
- 0.21ms
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/crag.rb:189
|
<1%
|
app/models/crag.rb:189
- Average Self
-
0.67ms
- Average calls
- 0.04x
- Total Self
- 0.02ms
- Total Children
- 0ms
- Total runtime
- 0.02ms
SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = ? LIMIT ?
|