# Api::V1::ContestsController#statistics

- **Period:** 13 May 09:22 UTC – 13 May 21:22 UTC
- **Throughput**: 0.0 / min
- **Average:** 281.5 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/api/v1/contests_controller.rb:63 | 148.5 | 1.0 | 52.75% | `Api::V1::ContestsController#statistics` |
| sql | app/models/concerns/attachment_resizable.rb:10 | 1.36 | 21.0 | 10.12% | `SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `…` |
| sql | app/models/contest_service/statistics.rb:103 | 1.29 | 21.0 | 9.59% | `SELECT `gym_routes`.* FROM `gym_routes` WHERE `gym_routes`.`id` = ? LIMIT ?` |
| sql | app/models/concerns/attachment_resizable.rb:12 | 1.14 | 14.0 | 5.68% | `SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_stora…` |
| sql | app/models/contest_service/statistics.rb:71 | 1.58 | 6.0 | 3.37% | `SELECT `contest_stages`.* FROM `contest_stages` WHERE `contest_stages`.`contest…` |
| sql | app/models/contest_service/statistics.rb:89 | 0.85 | 10.0 | 3.02% | `SELECT `contest_route_group_categories`.* FROM `contest_route_group_categories`…` |
| sql | app/models/contest_service/statistics.rb:97 | 1.6 | 5.0 | 2.84% | `SELECT `contest_routes`.* FROM `contest_routes` WHERE `contest_routes`.`contest…` |
| sql | app/models/contest_service/statistics.rb:308 | 4.5 | 1.0 | 1.60% | `SELECT `contest_participant_ascents`.* FROM `contest_participant_ascents` INNER…` |
| sql | app/models/contest_service/statistics.rb:90 | 1.5 | 2.0 | 1.07% | `SELECT COUNT(*) FROM `contest_participant_steps` INNER JOIN `contest_participan…` |
| sql | app/models/contest_service/statistics.rb:88 | 1.5 | 2.0 | 1.07% | `SELECT `contest_route_groups`.* FROM `contest_route_groups` WHERE `contest_rout…` |
| sql | app/models/contest_service/statistics.rb:86 | 1.5 | 2.0 | 1.07% | `SELECT COUNT(*) FROM `contest_participant_steps` INNER JOIN `contest_participan…` |
| sql | app/models/contest_service/statistics.rb:77 | 1.5 | 2.0 | 1.07% | `SELECT `contest_stage_steps`.* FROM `contest_stage_steps` WHERE `contest_stage_…` |

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