code
app/controllers/api/v1/crags_controller.rb:114
|
38 ms
|
1.0
|
58 %
|
Api::V1::CragsController#show
|
sql
app/controllers/api/v1/crags_controller.rb:218
|
1 ms
|
3.0
|
7 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:37:47.220201') AND `crags`.`id` = 1296 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
|
6 %
|
|
sql
app/models/crag.rb:110
|
1 ms
|
2.0
|
4 %
|
SELECT SUM(`crag_sectors`.`photos_count`) FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > '2022-06-30 00:37:47.249047') AND `crag_sectors`.`crag_id` = 1296
|
sql
app/models/crag.rb:192
|
2 ms
|
1.0
|
3 %
|
SELECT COUNT(*) FROM `comments` WHERE `comments`.`commentable_id` = 2837 AND `comments`.`commentable_type` = 'Crag'
|
sql
app/models/crag.rb:193
|
1 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `links` WHERE `links`.`linkable_id` = 2837 AND `links`.`linkable_type` = 'Crag'
|
sql
app/controllers/api/v1/api_controller.rb:42
|
1 ms
|
1.0
|
2 %
|
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = 'M4rvBxc4M7kqqdtXPDvFEYm9' LIMIT 1
|
sql
app/models/crag.rb:196
|
1 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `alerts` WHERE `alerts`.`alertable_id` = 2837 AND `alerts`.`alertable_type` = 'Crag'
|
sql
app/models/crag.rb:194
|
1 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `follows` WHERE `follows`.`followable_id` = 2837 AND `follows`.`followable_type` = 'Crag'
|
sql
app/models/crag.rb:197
|
1 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `videos` WHERE `videos`.`viewable_id` = 2837 AND `videos`.`viewable_type` = 'Crag'
|
sql
app/models/crag.rb:199
|
1 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `versions` WHERE `versions`.`item_id` = 2837 AND `versions`.`item_type` = 'Crag'
|
sql
app/models/crag.rb:210
|
1 ms
|
1.0
|
2 %
|
SELECT `areas`.* FROM `areas` INNER JOIN `area_crags` ON `areas`.`id` = `area_crags`.`area_id` WHERE `area_crags`.`crag_id` = 2837
|
sql
app/models/crag.rb:195
|
1 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `parks` WHERE `parks`.`crag_id` = 2837
|
sql
app/models/crag.rb:198
|
1 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `photos` WHERE `photos`.`illustrable_id` = 2837 AND `photos`.`illustrable_type` = 'Crag'
|
sql
app/models/crag.rb:114
|
1 ms
|
1.0
|
2 %
|
SELECT SUM(`crag_routes`.`videos_count`) FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-30 00:37:47.255692') AND `crag_routes`.`crag_id` = 1296
|
sql
app/models/crag.rb:206
|
1 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `guide_book_papers` INNER JOIN `guide_book_paper_crags` ON `guide_book_papers`.`id` = `guide_book_paper_crags`.`guide_book_paper_id` WHERE `guide_book_paper_crags`.`crag_id` = 2837
|
sql
app/models/crag.rb:205
|
1 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `guide_book_pdfs` WHERE `guide_book_pdfs`.`crag_id` = 2837
|
sql
app/models/crag.rb:204
|
<1 ms
|
1.0
|
1 %
|
SELECT COUNT(*) FROM `guide_book_webs` WHERE `guide_book_webs`.`crag_id` = 2837
|
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` = 4259 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` = 4134 AND `active_storage_attachments`.`record_type` = 'User' AND `active_storage_attachments`.`name` = 'avatar' LIMIT 1
|
sql
app/models/crag.rb:167
|
1 ms
|
<0.1
|
<1 %
|
SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = 535 LIMIT 1
|