|
code
app/controllers/api/v1/climbing_sessions_controller.rb:15
|
55%
|
app/controllers/api/v1/climbing_sessions_controller.rb:15
- Average Self
-
119ms
- Average calls
- 1x
- Total Self
- 119ms
- Total Children
- 97ms
- Total runtime
- 217ms
Api::V1::ClimbingSessionsController#index
|
|
sql
app/models/climbing_session.rb:13
|
10%
|
app/models/climbing_session.rb:13
- Average Self
-
1.3ms
- Average calls
- 17x
- Total Self
- 22ms
- Total Children
- 0ms
- Total runtime
- 22ms
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.1ms
- Average calls
- 17x
- Total Self
- 18ms
- Total Children
- 0ms
- Total runtime
- 18ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`climbing_session_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/controllers/api/v1/climbing_sessions_controller.rb:55
|
6%
|
app/controllers/api/v1/climbing_sessions_controller.rb:55
- Average Self
-
4.9ms
- Average calls
- 2.6x
- Total Self
- 12ms
- Total Children
- 0ms
- Total runtime
- 12ms
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 IN(?) AND climbing_session_id = climbing_sessions.id)) ORDER BY `climbing_sessions`.`session_date` DESC LIMIT ? OFFSET ?
|
|
sql
app/models/climbing_session.rb:45
|
6%
|
app/models/climbing_session.rb:45
- Average Self
-
0.99ms
- Average calls
- 12x
- Total Self
- 12ms
- Total Children
- 0ms
- Total runtime
- 12ms
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:56
|
5%
|
app/controllers/api/v1/climbing_sessions_controller.rb:56
- Average Self
-
3.6ms
- Average calls
- 3x
- Total Self
- 10ms
- Total Children
- 0ms
- Total runtime
- 10ms
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 IN(?) AND climbing_session_id = climbing_sessions.id)) ORDER BY `climbing_sessions`.`session_date` DESC LIMIT ? OFFSET ?
|
|
sql
app/models/climbing_session.rb:26
|
4%
|
app/models/climbing_session.rb:26
- Average Self
-
0.17ms
- Average calls
- 51x
- Total Self
- 8.9ms
- Total Children
- 0ms
- Total runtime
- 8.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
|
4%
|
app/controllers/api/v1/climbing_sessions_controller.rb:53
- Average Self
-
2.5ms
- Average calls
- 3.2x
- Total Self
- 7.9ms
- Total Children
- 0ms
- Total runtime
- 7.9ms
SELECT `climbing_sessions`.* FROM `climbing_sessions` WHERE `climbing_sessions`.`user_id` = ? AND (EXISTS(SELECT * FROM ascents WHERE gym_id IN(?) 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
|
<1%
|
/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
- 217ms
- Total runtime
- 219ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
<1%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.1ms
- Average calls
- 1x
- Total Self
- 1.1ms
- Total Children
- 0ms
- Total runtime
- 1.1ms
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.92ms
- Average calls
- 0.8x
- Total Self
- 0.73ms
- Total Children
- 0ms
- Total runtime
- 0.73ms
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.83ms
- Average calls
- 0.8x
- Total Self
- 0.67ms
- Total Children
- 0ms
- Total runtime
- 0.67ms
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.8ms
- Average calls
- 0.27x
- Total Self
- 0.47ms
- Total Children
- 0ms
- Total runtime
- 0.47ms
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:180
|
<1%
|
app/models/gym.rb:180
- Average Self
-
1ms
- Average calls
- 0.13x
- Total Self
- 0.13ms
- Total Children
- 0ms
- Total runtime
- 0.13ms
SELECT `gym_options`.* FROM `gym_options` WHERE `gym_options`.`gym_id` = ?
|
|
sql
app/models/gym.rb:282
|
<1%
|
app/models/gym.rb:282
- Average Self
-
1ms
- Average calls
- 0.13x
- Total Self
- 0.13ms
- Total Children
- 0ms
- Total runtime
- 0.13ms
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:293
|
<1%
|
app/models/gym.rb:293
- Average Self
-
1ms
- Average calls
- 0.13x
- Total Self
- 0.13ms
- Total Children
- 0ms
- Total runtime
- 0.13ms
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:295
|
<1%
|
app/models/gym.rb:295
- Average Self
-
1ms
- Average calls
- 0.13x
- Total Self
- 0.13ms
- Total Children
- 0ms
- Total runtime
- 0.13ms
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 ?
|