|
code
app/controllers/api/v1/crag_routes_controller.rb:43
|
47%
|
app/controllers/api/v1/crag_routes_controller.rb:43
- Average Self
-
6ms
- Average calls
- 1x
- Total Self
- 6ms
- Total Children
- 4.8ms
- Total runtime
- 10ms
Api::V1::CragRoutesController#suggested_routes
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
16%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
2ms
- Average calls
- 1x
- Total Self
- 2ms
- Total Children
- 10ms
- Total runtime
- 12ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:54
|
14%
|
app/controllers/api/v1/crag_routes_controller.rb:54
- Average Self
-
1.8ms
- Average calls
- 1x
- Total Self
- 1.8ms
- Total Children
- 0ms
- Total runtime
- 1.8ms
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/controllers/api/v1/api_controller.rb:64
|
12%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.5ms
- Average calls
- 1x
- Total Self
- 1.5ms
- Total Children
- 0ms
- Total runtime
- 1.5ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:44
|
8%
|
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/controllers/api/v1/crag_routes_controller.rb:45
|
4%
|
app/controllers/api/v1/crag_routes_controller.rb:45
- Average Self
-
1ms
- Average calls
- 0.5x
- Total Self
- 0.5ms
- Total Children
- 0ms
- Total runtime
- 0.5ms
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 ?
|