code
app/controllers/api/v1/ascent_crag_routes_controller.rb:10
|
21 ms
|
1.0
|
45 %
|
Api::V1::AscentCragRoutesController#index
|
sql
app/controllers/api/v1/ascent_crag_routes_controller.rb:13
|
6 ms
|
1.0
|
13 %
|
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`user_id` = 4170 AND `ascents`.`crag_route_id` = 36198
|
sql
app/controllers/api/v1/api_controller.rb:55
|
6 ms
|
1.0
|
12 %
|
SELECT `users`.* FROM `users` WHERE `users`.`id` = 4176 LIMIT 1
|
sql
app/controllers/api/v1/api_controller.rb:42
|
6 ms
|
1.0
|
12 %
|
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = 'M4rvBxc4M7kqqdtXPDvFEYm9' LIMIT 1
|
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
|
9 %
|
|
sql
app/models/ascent_crag_route.rb:54
|
5 ms
|
0.3
|
3 %
|
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` > '2022-06-29 20:38:40.642684') AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 20:38:40.643047') AND `crag_routes`.`id` = 36199 LIMIT 1
|
sql
app/models/ascent_crag_route.rb:53
|
5 ms
|
0.3
|
3 %
|
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 20:38:40.577335') AND `crag_routes`.`id` = 36199 LIMIT 1
|
sql
app/models/ascent_crag_route.rb:55
|
2 ms
|
0.3
|
1 %
|
SELECT `ascent_users`.* FROM `ascent_users` WHERE `ascent_users`.`ascent_id` = 34307
|
sql
app/models/crag_sector.rb:124
|
3 ms
|
0.2
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 20:38:40.610640') AND `crags`.`id` = 1230 LIMIT 1
|
sql
app/models/crag_route.rb:176
|
3 ms
|
0.2
|
<1 %
|
SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > '2022-06-29 20:38:40.593275') AND `crag_sectors`.`id` = 2514 LIMIT 1
|
sql
app/models/crag_route.rb:177
|
2 ms
|
0.2
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 20:38:40.635137') AND `crags`.`id` = 1230 LIMIT 1
|