|
code
app/controllers/api/v1/users_controller.rb:62
|
33 ms
|
1.0
|
45 %
|
Api::V1::UsersController#outdoor_figures
|
|
sql
app/models/log_book/outdoor/figure.rb:42
|
13 ms
|
1.0
|
17 %
|
SELECT COUNT(DISTINCT `crags`.`region`) FROM `crags` INNER JOIN `crag_routes` ON `crags`.`id` = `crag_routes`.`crag_id` INNER JOIN `ascents` ON `crag_routes`.`id` = `ascents`.`crag_route_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 23:42:06.439967') AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 23:42:06.440661') AND `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`user_id` = 305
|
|
sql
app/controllers/api/v1/api_controller.rb:42
|
7 ms
|
1.0
|
9 %
|
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = 'M4rvBxc4M7kqqdtXPDvFEYm9' LIMIT 1
|
|
sql
app/controllers/api/v1/users_controller.rb:164
|
5 ms
|
1.0
|
7 %
|
SELECT `users`.* FROM `users` WHERE `users`.`uuid` = 'd16fdb30-2313-452e-8d4f-f22b20064d2e' LIMIT 1
|
|
sql
app/models/log_book/outdoor/figure.rb:38
|
5 ms
|
1.0
|
6 %
|
SELECT COUNT(DISTINCT `crags`.`code_country`) FROM `crags` INNER JOIN `crag_routes` ON `crags`.`id` = `crag_routes`.`crag_id` INNER JOIN `ascents` ON `crag_routes`.`id` = `ascents`.`crag_route_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 23:42:06.430061') AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 23:42:06.430743') AND `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`user_id` = 305
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
4 ms
|
1.0
|
5 %
|
|
|
|
sql
app/models/log_book/outdoor/figure.rb:46
|
4 ms
|
1.0
|
5 %
|
SELECT COUNT(DISTINCT `crags`.`id`) FROM `crags` INNER JOIN `crag_routes` ON `crags`.`id` = `crag_routes`.`crag_id` INNER JOIN `ascents` ON `crag_routes`.`id` = `ascents`.`crag_route_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 23:42:06.444519') AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 23:42:06.445171') AND `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`user_id` = 305
|
|
sql
app/models/log_book/outdoor/figure.rb:34
|
2 ms
|
1.0
|
2 %
|
SELECT MAX(`ascents`.`max_grade_value`) FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`user_id` = 918 AND `ascents`.`ascent_status` != 'project'
|
|
sql
app/models/log_book/outdoor/figure.rb:30
|
1 ms
|
1.0
|
2 %
|
SELECT SUM(`ascents`.`height`) FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`user_id` = 918 AND `ascents`.`ascent_status` != 'project'
|
|
sql
app/models/log_book/outdoor/figure.rb:26
|
1 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`user_id` = 918 AND `ascents`.`ascent_status` != 'project'
|