|
code
app/controllers/api/v1/log_books/outdoors_controller.rb:30
|
54%
|
app/controllers/api/v1/log_books/outdoors_controller.rb:30
- Average Self
-
8.5ms
- Average calls
- 1x
- Total Self
- 8.5ms
- Total Children
- 5.2ms
- Total runtime
- 13ms
Api::V1::LogBooks::OutdoorsController#daily_ascents
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
13%
|
/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
- 13ms
- Total runtime
- 15ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
7%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.2ms
- Average calls
- 0.97x
- Total Self
- 1.2ms
- Total Children
- 0ms
- Total runtime
- 1.2ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/log_books/outdoors_controller.rb:34
|
7%
|
app/controllers/api/v1/log_books/outdoors_controller.rb:34
- Average Self
-
1.1ms
- Average calls
- 0.97x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT MIN(`ascents`.`released_at`) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/controllers/api/v1/log_books/outdoors_controller.rb:35
|
5%
|
app/controllers/api/v1/log_books/outdoors_controller.rb:35
- Average Self
-
0.83ms
- Average calls
- 0.97x
- Total Self
- 0.81ms
- Total Children
- 0ms
- Total runtime
- 0.81ms
SELECT MAX(`ascents`.`released_at`) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/controllers/api/v1/log_books/outdoors_controller.rb:52
|
5%
|
app/controllers/api/v1/log_books/outdoors_controller.rb:52
- Average Self
-
1.2ms
- Average calls
- 0.65x
- Total Self
- 0.74ms
- Total Children
- 0ms
- Total runtime
- 0.74ms
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
|
4%
|
app/models/ascent_crag_route.rb:50
- Average Self
-
0.95ms
- Average calls
- 0.65x
- Total Self
- 0.61ms
- Total Children
- 0ms
- Total runtime
- 0.61ms
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/ascent_crag_route.rb:52
|
3%
|
app/models/ascent_crag_route.rb:52
- Average Self
-
0.7ms
- Average calls
- 0.65x
- Total Self
- 0.45ms
- Total Children
- 0ms
- Total runtime
- 0.45ms
SELECT `ascent_users`.* FROM `ascent_users` WHERE `ascent_users`.`ascent_id` = ?
|
|
sql
app/controllers/api/v1/log_books/outdoors_controller.rb:50
|
2%
|
app/controllers/api/v1/log_books/outdoors_controller.rb:50
- Average Self
-
1.2ms
- Average calls
- 0.29x
- Total Self
- 0.35ms
- Total Children
- 0ms
- Total runtime
- 0.35ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ? AND (DATE(released_at) IN(?)) ORDER BY `ascents`.`released_at` ASC
|