|
code
app/controllers/api/v1/crag_routes_controller.rb:43
|
59%
|
app/controllers/api/v1/crag_routes_controller.rb:43
- Average Self
-
48ms
- Average calls
- 1x
- Total Self
- 48ms
- Total Children
- 31ms
- Total runtime
- 79ms
Api::V1::CragRoutesController#suggested_routes
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:54
|
16%
|
app/controllers/api/v1/crag_routes_controller.rb:54
- Average Self
-
12ms
- Average calls
- 1x
- 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 (EXISTS (SELECT * FROM follows WHERE followable_type = "Crag" AND followable_id = crag_routes.crag_id AND follows.user_id = ?)) AND NOT (EXISTS (SELECT * FROM ascents WHERE ascents.crag_route_id = crag_routes.id AND ascents.user_id = ?)) ORDER BY ascent_users_count DESC, note_count DESC LIMIT ? OFFSET ?
|
|
sql
app/models/crag_route.rb:200
|
8%
|
app/models/crag_route.rb:200
- Average Self
-
1.1ms
- Average calls
- 6.7x
- Total Self
- 7ms
- Total Children
- 0ms
- Total runtime
- 7ms
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`id` = ? LIMIT ?
|
|
sql
app/models/crag_route.rb:199
|
8%
|
app/models/crag_route.rb:199
- Average Self
-
0.98ms
- Average calls
- 6.7x
- Total Self
- 6.5ms
- Total Children
- 0ms
- Total runtime
- 6.5ms
SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > ?) AND `crag_sectors`.`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
-
2.8ms
- Average calls
- 1x
- Total Self
- 2.8ms
- Total Children
- 79ms
- Total runtime
- 82ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
2%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.3ms
- Average calls
- 1x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:45
|
1%
|
app/controllers/api/v1/crag_routes_controller.rb:45
- Average Self
-
1.2ms
- Average calls
- 0.83x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT MIN(min_grade_value) AS min_grade_value, MAX(max_grade_value) AS max_grade_value FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:44
|
1%
|
app/controllers/api/v1/crag_routes_controller.rb:44
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT COUNT(*) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ?
|
|
sql
app/models/concerns/attachment_resizable.rb:10
|
<1%
|
app/models/concerns/attachment_resizable.rb:10
- Average Self
-
1.3ms
- Average calls
- 0.5x
- Total Self
- 0.67ms
- Total Children
- 0ms
- Total runtime
- 0.67ms
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
-
1ms
- Average calls
- 0.5x
- Total Self
- 0.5ms
- Total Children
- 0ms
- Total runtime
- 0.5ms
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
|
|
sql
app/models/crag_route.rb:202
|
<1%
|
app/models/crag_route.rb:202
- Average Self
-
0.67ms
- Average calls
- 0.5x
- Total Self
- 0.33ms
- Total Children
- 0ms
- Total runtime
- 0.33ms
SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = ? LIMIT ?
|