|
code
app/controllers/api/v1/crag_routes_controller.rb:71
|
25 ms
|
1.0
|
62 %
|
Api::V1::CragRoutesController#show
|
|
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
|
11 %
|
|
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:112
|
2 ms
|
1.0
|
5 %
|
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-30 00:48:37.962696') AND `crag_routes`.`id` = 88561 LIMIT 1
|
|
sql
app/controllers/api/v1/api_controller.rb:42
|
2 ms
|
1.0
|
4 %
|
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = 'M4rvBxc4M7kqqdtXPDvFEYm9' LIMIT 1
|
|
sql
app/models/crag_route.rb:193
|
2 ms
|
1.0
|
4 %
|
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`crag_route_id` = 88561 AND `ascents`.`private_comment` != TRUE
|
|
sql
app/models/crag_route.rb:191
|
1 ms
|
1.0
|
3 %
|
SELECT COUNT(*) FROM `versions` WHERE `versions`.`item_id` = 88561 AND `versions`.`item_type` = 'CragRoute'
|
|
sql
app/models/crag_route.rb:201
|
1 ms
|
1.0
|
3 %
|
SELECT COUNT(*) FROM `links` WHERE `links`.`linkable_id` = 88561 AND `links`.`linkable_type` = 'CragRoute'
|
|
sql
app/models/crag_route.rb:203
|
1 ms
|
1.0
|
3 %
|
SELECT `users`.* FROM `users` WHERE `users`.`id` = 3277 LIMIT 1
|
|
sql
app/models/crag_route.rb:202
|
1 ms
|
1.0
|
3 %
|
SELECT COUNT(*) FROM `alerts` WHERE `alerts`.`alertable_id` = 88561 AND `alerts`.`alertable_type` = 'CragRoute'
|
|
sql
app/models/crag_route.rb:198
|
1 ms
|
0.3
|
<1 %
|
SELECT `users`.* FROM `users` WHERE `users`.`id` = 1054 LIMIT 1
|
|
sql
app/models/crag_route.rb:176
|
1 ms
|
0.2
|
<1 %
|
SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > '2022-06-30 00:48:37.968815') AND `crag_sectors`.`id` = 2842 LIMIT 1
|
|
sql
app/models/crag_route.rb:177
|
1 ms
|
0.2
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:48:37.981083') AND `crags`.`id` = 1378 LIMIT 1
|
|
sql
app/models/crag_sector.rb:124
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:41:54.243684') AND `crags`.`id` = 2228 LIMIT 1
|
|
sql
app/models/concerns/attachment_resizable.rb:7
|
1 ms
|
<0.1
|
<1 %
|
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = 4145 AND `active_storage_attachments`.`record_type` = 'User' AND `active_storage_attachments`.`name` = 'avatar' LIMIT 1
|
|
sql
app/models/concerns/attachment_resizable.rb:9
|
1 ms
|
<0.1
|
<1 %
|
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = 4258 LIMIT 1
|