# Api::V1::CragsController#advanced_search

- **Period:** 12 May 12:03 UTC – 13 May 12:03 UTC
- **Throughput**: 0.02 / min
- **Average:** 446.0 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| sql | app/controllers/api/v1/crags_controller.rb:119 | 93.98 | 3.91 | 82.37% | `SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`d…` |
| code | app/controllers/api/v1/crags_controller.rb:37 | 68.0 | 1.0 | 15.25% | `Api::V1::CragsController#advanced_search` |
| sql | app/models/concerns/route_figurable.rb:70 | 6.18 | 1.0 | 1.39% | `SELECT climbing_type, crag_routes.max_grade_value, crag_routes.max_grade_text, …` |

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