|
code
app/controllers/api/v1/log_books/outdoors_controller.rb:63
|
57%
|
app/controllers/api/v1/log_books/outdoors_controller.rb:63
- Average Self
-
6.1ms
- Average calls
- 1x
- Total Self
- 6.1ms
- Total Children
- 2.9ms
- Total runtime
- 9.1ms
Api::V1::LogBooks::OutdoorsController#ascents_of_crag
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
15%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
1.7ms
- Average calls
- 1x
- Total Self
- 1.7ms
- Total Children
- 9.1ms
- Total runtime
- 10ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/log_books/outdoors_controller.rb:70
|
13%
|
app/controllers/api/v1/log_books/outdoors_controller.rb:70
- Average Self
-
1.3ms
- Average calls
- 1x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
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` > ?) WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `crag_routes`.`crag_id` = ? ORDER BY `ascents`.`min_grade_value` DESC
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
11%
|
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/ascent_crag_route.rb:51
|
1%
|
app/models/ascent_crag_route.rb:51
- Average Self
-
1ms
- Average calls
- 0.11x
- Total Self
- 0.11ms
- Total Children
- 0ms
- Total runtime
- 0.11ms
SELECT `crags`.* FROM `crags` INNER JOIN `crag_routes` ON `crags`.`id` = `crag_routes`.`crag_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`id` = ? LIMIT ?
|
|
sql
app/models/ascent_crag_route.rb:50
|
<1%
|
app/models/ascent_crag_route.rb:50
- Average Self
-
0.75ms
- Average calls
- 0.11x
- Total Self
- 0.09ms
- Total Children
- 0ms
- Total runtime
- 0.09ms
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/models/crag_route.rb:199
|
<1%
|
app/models/crag_route.rb:199
- Average Self
-
1ms
- Average calls
- 0.06x
- Total Self
- 0.06ms
- Total Children
- 0ms
- Total runtime
- 0.06ms
SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > ?) AND `crag_sectors`.`id` = ? LIMIT ?
|
|
sql
app/models/crag_route.rb:200
|
<1%
|
app/models/crag_route.rb:200
- Average Self
-
1ms
- Average calls
- 0.06x
- Total Self
- 0.06ms
- Total Children
- 0ms
- Total runtime
- 0.06ms
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`id` = ? LIMIT ?
|
|
sql
app/models/crag_sector.rb:121
|
<1%
|
app/models/crag_sector.rb:121
- Average Self
-
1ms
- Average calls
- 0.03x
- Total Self
- 0.03ms
- Total Children
- 0ms
- Total runtime
- 0.03ms
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`id` = ? LIMIT ?
|
|
sql
app/models/ascent_crag_route.rb:52
|
<1%
|
app/models/ascent_crag_route.rb:52
- Average Self
-
0.25ms
- Average calls
- 0.11x
- Total Self
- 0.03ms
- Total Children
- 0ms
- Total runtime
- 0.03ms
SELECT `ascent_users`.* FROM `ascent_users` WHERE `ascent_users`.`ascent_id` = ?
|