# Api::V1::CommonsController#figures

- **Period:** 27 Jun 09:48 UTC – 27 Jun 15:31 UTC
- **Throughput**: 0.17 / min
- **Average:** 2122.0 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/api/v1/commons_controller.rb:17 | 331.38 | 2.0 | 31.23% | `SELECT COUNT(*) FROM `comments` SELECT COUNT(*) FROM `ascents` WHERE `ascents`.…` |
| sql | app/controllers/api/v1/commons_controller.rb:28 | 327.34 | 2.0 | 30.85% | `SELECT COUNT(*) FROM `comments` WHERE (created_at >= ?) SELECT COUNT(*) FROM `a…` |
| sql | app/controllers/api/v1/commons_controller.rb:25 | 346.7 | 1.0 | 16.34% | `SELECT COUNT(*) FROM `ascents` WHERE (created_at >= ?)` |
| sql | app/controllers/api/v1/commons_controller.rb:14 | 144.56 | 1.0 | 6.81% | `SELECT COUNT(*) FROM `ascents`` |
| sql | app/controllers/api/v1/commons_controller.rb:24 | 63.22 | 2.0 | 5.96% | `SELECT COUNT(*) FROM `gym_routes` WHERE (created_at >= ?) SELECT COUNT(*) FROM …` |
| sql | app/controllers/api/v1/commons_controller.rb:13 | 49.57 | 2.0 | 4.67% | `SELECT COUNT(*) FROM `gym_routes` SELECT COUNT(*) FROM `crag_routes` WHERE (`cr…` |
| sql | app/controllers/api/v1/commons_controller.rb:22 | 22.07 | 1.0 | 1.04% | `SELECT COUNT(*) FROM `users` WHERE (created_at >= ?)` |

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