# Api::V1::CommonsController#figures

- **Period:** 12 May 11:03 UTC – 13 May 11:03 UTC
- **Throughput**: 0.1 / min
- **Average:** 3473.0 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/api/v1/commons_controller.rb:17 | 535.14 | 2.0 | 30.82% | `SELECT COUNT(*) FROM `comments`` |
| sql | app/controllers/api/v1/commons_controller.rb:28 | 488.58 | 2.0 | 28.14% | `SELECT COUNT(*) FROM `comments` WHERE (created_at >= ?)` |
| sql | app/controllers/api/v1/commons_controller.rb:25 | 563.32 | 1.0 | 16.22% | `SELECT COUNT(*) FROM `ascents` WHERE (created_at >= ?)` |
| sql | app/controllers/api/v1/commons_controller.rb:14 | 319.58 | 1.0 | 9.20% | `SELECT COUNT(*) FROM `ascents`` |
| sql | app/controllers/api/v1/commons_controller.rb:13 | 102.49 | 2.0 | 5.90% | `SELECT COUNT(*) FROM `gym_routes`` |
| sql | app/controllers/api/v1/commons_controller.rb:24 | 101.76 | 2.0 | 5.86% | `SELECT COUNT(*) FROM `gym_routes` WHERE (created_at >= ?)` |

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