# Api::V1::AreasController#show

- **Period:** 13 May 05:09 UTC – 13 May 11:09 UTC
- **Throughput**: 0.08 / min
- **Average:** 40.4 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/api/v1/areas_controller.rb:125 | 20.04 | 1.0 | 49.59% | `Api::V1::AreasController#show` |
| sql | app/models/area.rb:27 | 1.8 | 2.0 | 8.89% | `SELECT `crags`.* FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_c…` |
| sql | app/models/area.rb:23 | 1.57 | 2.0 | 7.79% | `SELECT `crags`.* FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_c…` |
| sql | app/models/area.rb:63 | 1.39 | 2.0 | 6.87% | `SELECT `area_crags`.* FROM `area_crags` WHERE `area_crags`.`area_id` = ?` |
| sql | app/models/area.rb:19 | 1.28 | 2.0 | 6.32% | `SELECT SUM(`crags`.`crag_routes_count`) FROM `crags` INNER JOIN `area_crags` ON…` |
| code | /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525 | 2.22 | 1.0 | 5.50% | `Rails::Engine#call` |
| sql | app/models/area.rb:61 | 1.52 | 1.0 | 3.76% | `SELECT COUNT(*) FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_cr…` |
| sql | app/controllers/api/v1/areas_controller.rb:194 | 1.48 | 1.0 | 3.67% | `SELECT `areas`.* FROM `areas` WHERE `areas`.`id` = ? LIMIT ?` |
| sql | app/models/area.rb:49 | 1.44 | 0.59 | 2.11% | `SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` …` |
| sql | app/models/concerns/attachment_resizable.rb:10 | 1.38 | 0.59 | 2.02% | `SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `…` |
| sql | app/models/area.rb:47 | 1.25 | 0.59 | 1.83% | `SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = ? LIMIT ?` |
| sql | app/models/concerns/attachment_resizable.rb:12 | 1.13 | 0.59 | 1.65% | `SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_stora…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135627/requests/Api::V1::AreasController%23show?range=6h)