# Api::V1::CommonsController#figures

- **Period:** 13 May 10:33 UTC – 13 May 11:03 UTC
- **Throughput**: 0.1 / min
- **Average:** 3357.0 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/api/v1/commons_controller.rb:17 | 613.67 | 2.0 | 36.56% | `SELECT COUNT(*) FROM `comments`` |
| sql | app/controllers/api/v1/commons_controller.rb:28 | 403.83 | 2.0 | 24.06% | `SELECT COUNT(*) FROM `comments` WHERE (created_at >= ?)` |
| sql | app/controllers/api/v1/commons_controller.rb:25 | 507.0 | 1.0 | 15.10% | `SELECT COUNT(*) FROM `ascents` WHERE (created_at >= ?)` |
| sql | app/controllers/api/v1/commons_controller.rb:14 | 366.0 | 1.0 | 10.90% | `SELECT COUNT(*) FROM `ascents`` |
| sql | app/controllers/api/v1/commons_controller.rb:13 | 94.83 | 2.0 | 5.65% | `SELECT COUNT(*) FROM `gym_routes`` |
| sql | app/controllers/api/v1/commons_controller.rb:24 | 75.33 | 2.0 | 4.49% | `SELECT COUNT(*) FROM `gym_routes` WHERE (created_at >= ?)` |

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