# Api::V1::CommonsController#figures

- **Period:** 26 Jun 20:16 UTC – 27 Jun 09:48 UTC
- **Throughput**: 0.05 / min
- **Average:** 2103.1 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/api/v1/commons_controller.rb:17 | 326.33 | 2.0 | 31.03% | `SELECT COUNT(*) FROM `comments` SELECT COUNT(*) FROM `ascents` WHERE `ascents`.…` |
| sql | app/controllers/api/v1/commons_controller.rb:28 | 323.37 | 2.0 | 30.75% | `SELECT COUNT(*) FROM `comments` WHERE (created_at >= ?) SELECT COUNT(*) FROM `a…` |
| sql | app/controllers/api/v1/commons_controller.rb:25 | 337.36 | 1.0 | 16.04% | `SELECT COUNT(*) FROM `ascents` WHERE (created_at >= ?)` |
| sql | app/controllers/api/v1/commons_controller.rb:14 | 146.59 | 1.0 | 6.97% | `SELECT COUNT(*) FROM `ascents`` |
| sql | app/controllers/api/v1/commons_controller.rb:24 | 62.19 | 2.0 | 5.91% | `SELECT COUNT(*) FROM `gym_routes` WHERE (created_at >= ?) SELECT COUNT(*) FROM …` |
| sql | app/controllers/api/v1/commons_controller.rb:13 | 51.13 | 2.0 | 4.86% | `SELECT COUNT(*) FROM `gym_routes` SELECT COUNT(*) FROM `crag_routes` WHERE (`cr…` |
| code | app/controllers/api/v1/commons_controller.rb:6 | 22.59 | 1.0 | 1.07% | `Api::V1::CommonsController#figures` |

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