|
sql
app/controllers/api/v1/crag_routes_controller.rb:54
|
55%
|
app/controllers/api/v1/crag_routes_controller.rb:54
- Average Self
-
134ms
- Calls
- 1x
- Total Self
- 134ms
- Total Children
- 0ms
- Total runtime
- 134ms
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 = ?)) AND `crag_routes`.`max_grade_value` BETWEEN ? AND ? ORDER BY ascent_users_count DESC, note_count DESC LIMIT ? OFFSET ?
|
|
code
app/controllers/api/v1/crag_routes_controller.rb:43
|
29%
|
app/controllers/api/v1/crag_routes_controller.rb:43
- Average Self
-
72ms
- Calls
- 1x
- Total Self
- 72ms
- Total Children
- 170ms
- Total runtime
- 242ms
Api::V1::CragRoutesController#suggested_routes
|
|
sql
app/models/crag_route.rb:200
|
7%
|
app/models/crag_route.rb:200
- Average Self
-
0.94ms
- Calls
- 17x
- Total Self
- 16ms
- Total Children
- 0ms
- Total runtime
- 16ms
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
|
7%
|
app/models/crag_route.rb:199
- Average Self
-
0.94ms
- Calls
- 17x
- Total Self
- 16ms
- Total Children
- 0ms
- Total runtime
- 16ms
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
|
1%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
3ms
- Calls
- 1x
- Total Self
- 3ms
- Total Children
- 242ms
- Total runtime
- 245ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:44
|
<1%
|
app/controllers/api/v1/crag_routes_controller.rb:44
- Average Self
-
2ms
- Calls
- 1x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT COUNT(*) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ?
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:45
|
<1%
|
app/controllers/api/v1/crag_routes_controller.rb:45
- Average Self
-
1ms
- Calls
- 1x
- 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/api_controller.rb:64
|
<1%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|