|
code
app/controllers/api/v1/log_books/indoors_controller.rb:10
|
39%
|
app/controllers/api/v1/log_books/indoors_controller.rb:10
- Average Self
-
18ms
- Average calls
- 1x
- Total Self
- 18ms
- Total Children
- 25ms
- Total runtime
- 44ms
Api::V1::LogBooks::IndoorsController#figures
|
|
sql
app/models/log_book/indoor/figure.rb:61
|
12%
|
app/models/log_book/indoor/figure.rb:61
- Average Self
-
2.8ms
- Average calls
- 2x
- Total Self
- 5.5ms
- Total Children
- 0ms
- Total runtime
- 5.5ms
SELECT COUNT(DISTINCT `gyms`.`id`) FROM `gyms` INNER JOIN `ascents` ON `gyms`.`id` = `ascents`.`gym_id` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `ascents`.`type` = ? AND `ascents`.`user_id` = ?
|
|
sql
app/models/log_book/indoor/figure.rb:33
|
10%
|
app/models/log_book/indoor/figure.rb:33
- Average Self
-
2.3ms
- Average calls
- 2x
- Total Self
- 4.5ms
- Total Children
- 0ms
- Total runtime
- 4.5ms
SELECT SUM(`ascents`.`quantity`) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/models/log_book/indoor/figure.rb:45
|
8%
|
app/models/log_book/indoor/figure.rb:45
- Average Self
-
3.7ms
- Average calls
- 0.98x
- Total Self
- 3.6ms
- Total Children
- 0ms
- Total runtime
- 3.6ms
SELECT COUNT(DISTINCT `gyms`.`code_country`) FROM `gyms` INNER JOIN `ascents` ON `gyms`.`id` = `ascents`.`gym_id` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `ascents`.`type` = ? AND `ascents`.`user_id` = ?
|
|
sql
app/models/log_book/indoor/figure.rb:49
|
7%
|
app/models/log_book/indoor/figure.rb:49
- Average Self
-
3.2ms
- Average calls
- 0.98x
- Total Self
- 3.2ms
- Total Children
- 0ms
- Total runtime
- 3.2ms
SELECT COUNT(DISTINCT `gyms`.`region`) FROM `gyms` INNER JOIN `ascents` ON `gyms`.`id` = `ascents`.`gym_id` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `ascents`.`type` = ? AND `ascents`.`user_id` = ?
|
|
sql
app/models/log_book/indoor/figure.rb:55
|
6%
|
app/models/log_book/indoor/figure.rb:55
- Average Self
-
3ms
- Average calls
- 0.98x
- Total Self
- 3ms
- Total Children
- 0ms
- Total runtime
- 3ms
SELECT COUNT(*) FROM `climbing_sessions` WHERE `climbing_sessions`.`user_id` = ? AND (EXISTS(SELECT * FROM ascents WHERE gym_id IS NOT NULL AND climbing_session_id = climbing_sessions.id)) AND (climbing_sessions.session_date >= ?)
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
5%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
2.4ms
- Average calls
- 1x
- Total Self
- 2.4ms
- Total Children
- 44ms
- Total runtime
- 46ms
Rails::Engine#call
|
|
sql
app/models/log_book/indoor/figure.rb:37
|
5%
|
app/models/log_book/indoor/figure.rb:37
- Average Self
-
2.3ms
- Average calls
- 0.98x
- Total Self
- 2.3ms
- Total Children
- 0ms
- Total runtime
- 2.3ms
SELECT SUM(height * quantity) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/models/log_book/indoor/figure.rb:41
|
5%
|
app/models/log_book/indoor/figure.rb:41
- Average Self
-
2.2ms
- Average calls
- 0.98x
- Total Self
- 2.1ms
- Total Children
- 0ms
- Total runtime
- 2.1ms
SELECT MAX(`ascents`.`max_grade_value`) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
4%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.7ms
- Average calls
- 0.98x
- Total Self
- 1.7ms
- Total Children
- 0ms
- Total runtime
- 1.7ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:50
|
<1%
|
app/controllers/api/v1/api_controller.rb:50
- Average Self
-
1ms
- Average calls
- <0.01x
- Total Self
- <0.01ms
- Total Children
- 0ms
- Total runtime
- <0.01ms
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = ? LIMIT ?
|