# Api::V1::GymsController#figures

- **Period:** 27 Jun 09:48 UTC – 27 Jun 16:54 UTC
- **Throughput**: 0.54 / min
- **Average:** 35.0 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/api/v1/gyms_controller.rb:342 | 13.76 | 1.0 | 39.27% | `Api::V1::GymsController#figures` |
| sql | app/controllers/api/v1/gyms_controller.rb:370 | 45.08 | 0.16 | 21.16% | `SELECT COUNT(*) FROM `comments` INNER JOIN ascents ON commentable_id = ascents.…` |
| sql | app/controllers/api/v1/api_controller.rb:64 | 2.25 | 1.06 | 6.82% | `SET NAMES utf8mb4, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ?), ?), @@SES…` |
| sql | app/controllers/api/v1/gyms_controller.rb:523 | 1.87 | 1.0 | 5.34% | `SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`delet…` |
| sql | app/controllers/api/v1/gyms_controller.rb:373 | 4.96 | 0.33 | 4.66% | `SELECT `gym_routes`.`id` FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_rou…` |
| sql | app/controllers/api/v1/gyms_controller.rb:362 | 9.53 | 0.16 | 4.47% | `SELECT COUNT(*) FROM `comments` INNER JOIN gym_routes ON commentable_id = gym_r…` |
| code | /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525 | 1.88 | 0.74 | 3.98% | `Rails::Engine#call` |
| sql | app/controllers/api/v1/gyms_controller.rb:348 | 7.79 | 0.16 | 3.66% | `SELECT COUNT(*) FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_routes`.`gym…` |
| sql | app/controllers/api/v1/gyms_controller.rb:531 | 1.72 | 0.69 | 3.37% | `SELECT COUNT(*) FROM `gym_administrators` WHERE `gym_administrators`.`gym_id` =…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135627/requests/Api::V1::GymsController%23figures?range=2026-06-27+09%3A48%3A53+UTC..2026-06-28+09%3A48%3A53+UTC)