|
code
app/controllers/api/v1/crag_routes_controller.rb:12
|
90 ms
|
1.0
|
80 %
|
Api::V1::CragRoutesController#index
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:33
|
5 ms
|
1.5
|
7 %
|
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-30 00:34:41.607461') AND `crag_routes`.`crag_sector_id` = 6994 ORDER BY crag_routes.max_grade_value DESC, crag_routes.name, crag_routes.id LIMIT 25 OFFSET 0
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
5 ms
|
1.0
|
4 %
|
|
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:104
|
4 ms
|
0.9
|
3 %
|
SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > '2022-06-30 00:34:41.600382') AND `crag_sectors`.`id` = 6994 LIMIT 1
|
|
sql
app/controllers/api/v1/crag_routes_controller.rb:108
|
3 ms
|
0.9
|
3 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:34:41.603791') AND `crags`.`id` IS NULL LIMIT 1
|
|
sql
app/controllers/api/v1/api_controller.rb:42
|
3 ms
|
1.0
|
3 %
|
SET NAMES utf8mb4, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
|
|
sql
app/models/crag_route.rb:177
|
2 ms
|
0.4
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:23.484195') AND `crags`.`id` = 1525 LIMIT 1
|
|
sql
app/models/crag_sector.rb:124
|
3 ms
|
<0.1
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:22:11.785284') AND `crags`.`id` = 2436 LIMIT 1
|
|
sql
app/models/crag_route.rb:179
|
3 ms
|
<0.1
|
<1 %
|
SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = 2147 LIMIT 1
|
|
sql
app/models/concerns/attachment_resizable.rb:7
|
2 ms
|
<0.1
|
<1 %
|
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = 2147 AND `active_storage_attachments`.`record_type` = 'Photo' AND `active_storage_attachments`.`name` = 'picture' 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` = 3837 LIMIT 1
|
|
sql
app/models/crag_sector.rb:126
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = 515 LIMIT 1
|