# Api::V1::AscentGymRoutesController#add_bulk

- **Period:** 12 May 23:14 UTC – 13 May 11:14 UTC
- **Throughput**: 0.0 / min
- **Average:** 474.3 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/controllers/api/v1/ascent_gym_routes_controller.rb:167 | 235.0 | 1.0 | 49.54% | `Api::V1::AscentGymRoutesController#add_bulk` |
| sql | app/controllers/api/v1/ascent_gym_routes_controller.rb:199 | 1.66 | 39.0 | 13.63% | `BEGIN INSERT INTO `ascents` (`type`, `ascent_status`, `user_id`, `gym_route_id`…` |
| sql | app/models/gym_route.rb:187 | 1.21 | 39.0 | 9.91% | `SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `…` |
| sql | app/models/ascent_gym_route.rb:132 | 1.64 | 13.0 | 4.50% | `SELECT `gyms`.* FROM `gyms` INNER JOIN `gym_spaces` ON `gyms`.`id` = `gym_space…` |
| sql | app/models/ascent.rb:56 | 1.44 | 13.0 | 3.94% | `SELECT `climbing_sessions`.* FROM `climbing_sessions` WHERE `climbing_sessions`…` |
| sql | app/models/ascent_gym_route.rb:130 | 1.33 | 13.0 | 3.65% | `SELECT `gym_routes`.* FROM `gym_routes` WHERE `gym_routes`.`id` = ? LIMIT ?` |
| sql | app/models/ascent.rb:58 | 1.28 | 13.0 | 3.51% | `SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?` |
| sql | app/models/ascent.rb:60 | 1.18 | 13.0 | 3.23% | `UPDATE `ascents` SET `ascents`.`climbing_session_id` = ? WHERE `ascents`.`id` =…` |
| sql | app/models/gym_route.rb:161 | 1.18 | 13.0 | 3.23% | `SELECT `ascents`.`hardness_status`, `ascents`.`ascent_status`, `ascents`.`user_…` |
| sql | app/models/gym_route.rb:437 | 1.15 | 13.0 | 3.16% | `SELECT `contest_routes`.* FROM `contest_routes` WHERE `contest_routes`.`gym_rou…` |

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