# Api::V1::AreasController#show

- **Period:** 12 May 11:08 UTC – 13 May 11:08 UTC
- **Throughput**: 0.08 / min
- **Average:** 43.9 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/api/v1/areas_controller.rb:125 | 22.05 | 1.0 | 50.19% | `Api::V1::AreasController#show` |
| sql | app/models/area.rb:27 | 1.89 | 2.0 | 8.62% | `SELECT `crags`.* FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_c…` |
| sql | app/models/area.rb:23 | 1.79 | 2.0 | 8.16% | `SELECT `crags`.* FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_c…` |
| sql | app/models/area.rb:19 | 1.47 | 2.0 | 6.71% | `SELECT SUM(`crags`.`crag_routes_count`) FROM `crags` INNER JOIN `area_crags` ON…` |
| sql | app/models/area.rb:63 | 1.45 | 2.0 | 6.61% | `SELECT `area_crags`.* FROM `area_crags` WHERE `area_crags`.`area_id` = ?` |
| code | /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525 | 2.53 | 1.0 | 5.76% | `Rails::Engine#call` |
| sql | app/models/area.rb:61 | 1.62 | 1.0 | 3.69% | `SELECT COUNT(*) FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_cr…` |
| sql | app/controllers/api/v1/areas_controller.rb:194 | 1.4 | 1.0 | 3.18% | `SELECT `areas`.* FROM `areas` WHERE `areas`.`id` = ? LIMIT ?` |
| sql | app/models/area.rb:49 | 1.6 | 0.55 | 1.99% | `SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS …` |
| sql | app/models/area.rb:47 | 1.39 | 0.55 | 1.73% | `SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = ? LIMIT ?` |
| sql | app/models/concerns/attachment_resizable.rb:10 | 1.37 | 0.55 | 1.71% | `SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `…` |
| sql | app/models/concerns/attachment_resizable.rb:12 | 1.26 | 0.55 | 1.57% | `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=1d)