# Api::V1::CommonsController#figures

- **Period:** 13 May 05:04 UTC – 13 May 11:04 UTC
- **Throughput**: 0.11 / min
- **Average:** 3027.4 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/api/v1/commons_controller.rb:17 | 460.12 | 2.0 | 30.40% | `SELECT COUNT(*) FROM `comments`` |
| sql | app/controllers/api/v1/commons_controller.rb:28 | 438.96 | 2.0 | 29.00% | `SELECT COUNT(*) FROM `comments` WHERE (created_at >= ?)` |
| sql | app/controllers/api/v1/commons_controller.rb:25 | 483.9 | 1.0 | 15.98% | `SELECT COUNT(*) FROM `ascents` WHERE (created_at >= ?)` |
| sql | app/controllers/api/v1/commons_controller.rb:14 | 294.9 | 1.0 | 9.74% | `SELECT COUNT(*) FROM `ascents`` |
| sql | app/controllers/api/v1/commons_controller.rb:24 | 86.0 | 2.0 | 5.68% | `SELECT COUNT(*) FROM `gym_routes` WHERE (created_at >= ?)` |
| sql | app/controllers/api/v1/commons_controller.rb:13 | 79.42 | 2.0 | 5.25% | `SELECT COUNT(*) FROM `gym_routes`` |
| code | app/controllers/api/v1/commons_controller.rb:6 | 30.56 | 1.0 | 1.01% | `Api::V1::CommonsController#figures` |

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