|
sql
app/controllers/api/v1/crag_sectors_controller.rb:67
|
20 ms
|
1.0
|
47 %
|
SELECT `photos`.* FROM `photos` WHERE ((illustrable_type = "CragSector" AND illustrable_id = 2725) OR
(illustrable_type = "CragRoute" AND illustrable_id IN (SELECT id FROM crag_routes WHERE crag_sector_id = 2725))) ORDER BY `photos`.`posted_at` DESC LIMIT 25 OFFSET 0
|
|
code
app/controllers/api/v1/crag_sectors_controller.rb:58
|
12 ms
|
1.0
|
27 %
|
Api::V1::CragSectorsController#photos
|
|
sql
app/controllers/api/v1/crag_sectors_controller.rb:109
|
2 ms
|
2.0
|
10 %
|
SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > '2022-06-30 00:24:09.463213') AND `crag_sectors`.`id` = 2725 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/controllers/api/v1/api_controller.rb:42
|
2 ms
|
1.0
|
6 %
|
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = 'M4rvBxc4M7kqqdtXPDvFEYm9' LIMIT 1
|
|
sql
app/models/photo.rb:43
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = 1320 AND `active_storage_attachments`.`record_type` = 'Photo' AND `active_storage_attachments`.`name` = 'picture' LIMIT 1
|
|
sql
app/models/photo.rb:72
|
2 ms
|
<0.1
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 23:31:02.111171') AND `crags`.`id` = 1932 LIMIT 1
|
|
sql
app/models/photo.rb:93
|
2 ms
|
<0.1
|
<1 %
|
SELECT `users`.* FROM `users` WHERE `users`.`id` = 1909 LIMIT 1
|
|
sql
app/models/photo.rb:63
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 23:31:02.106222') AND `crag_routes`.`id` = 66632 LIMIT 1
|