|
code
app/controllers/api/v1/guide_book_papers_controller.rb:90
|
147 ms
|
1.0
|
76 %
|
Api::V1::GuideBookPapersController#photos
|
|
sql
app/controllers/api/v1/guide_book_papers_controller.rb:100
|
17 ms
|
1.0
|
9 %
|
SELECT `photos`.* FROM `photos` WHERE ((illustrable_type = "Crag" AND illustrable_id IN (SELECT crag_id FROM guide_book_paper_crags WHERE guide_book_paper_id = 186)) OR
(illustrable_type = "CragSector" AND illustrable_id IN (SELECT id FROM crag_sectors WHERE crag_id IN (SELECT crag_id FROM guide_book_paper_crags WHERE guide_book_paper_id = 186))) OR
(illustrable_type = "CragRoute" AND illustrable_id IN (SELECT id FROM crag_routes WHERE crag_id IN (SELECT crag_id FROM guide_book_paper_crags WHERE guide_book_paper_id = 186)))) ORDER BY `photos`.`posted_at` DESC LIMIT 25 OFFSET 0
|
|
sql
app/models/photo.rb:43
|
<1 ms
|
11
|
5 %
|
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = 1979 AND `active_storage_attachments`.`record_type` = 'Photo' AND `active_storage_attachments`.`name` = 'picture' LIMIT 1
|
|
sql
app/models/photo.rb:63
|
1 ms
|
5.5
|
3 %
|
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 22:42:08.988370') AND `crag_routes`.`id` = 74667 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
|
2 %
|
|
|
|
sql
app/models/photo.rb:93
|
<1 ms
|
5.5
|
1 %
|
SELECT `users`.* FROM `users` WHERE `users`.`id` = 417 LIMIT 1
|
|
sql
app/models/photo.rb:72
|
<1 ms
|
2.9
|
1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 22:42:08.995206') AND `crags`.`id` = 303 LIMIT 1
|
|
sql
app/controllers/api/v1/api_controller.rb:42
|
2 ms
|
1.0
|
<1 %
|
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = 'M4rvBxc4M7kqqdtXPDvFEYm9' LIMIT 1
|
|
sql
app/controllers/api/v1/guide_book_papers_controller.rb:235
|
1 ms
|
1.0
|
<1 %
|
SELECT `guide_book_papers`.* FROM `guide_book_papers` WHERE `guide_book_papers`.`id` = 43 LIMIT 1
|
|
sql
app/models/concerns/attachment_resizable.rb:9
|
2 ms
|
<0.1
|
<1 %
|
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = 195 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` = 417 AND `active_storage_attachments`.`record_type` = 'User' AND `active_storage_attachments`.`name` = 'avatar' LIMIT 1
|