# HistorizeTownJob

- **Period:** 10 Jun 03:49 UTC – 11 Jun 03:48 UTC
- **Throughput**: 0.1 / min
- **Average:** 112.0 ms

## Most Impactful Sections
| Kind | Location | Avg ms | Avg calls | Impact | Command |
| ---- | -------- | -----: | --------: | -----: | ------- |
| code | app/jobs/historize_town_job.rb:6 | 43.78 | 1.0 | 39.09% | `HistorizeTownJob#perform` |
| sql | app/models/town.rb:109 | 11.45 | 1.82 | 18.60% | `SELECT `crags`.`id`, `crags`.`name`, `crags`.`slug_name`, `crags`.`sport_climbi…` |
| sql | app/models/town.rb:31 | 13.98 | 0.82 | 10.22% | `SELECT `crags`.`id` FROM `crags` LEFT OUTER JOIN `crag_routes` ON `crag_routes`…` |
| sql | app/models/town.rb:194 | 1.99 | 4.0 | 7.12% | `BEGIN SELECT `towns`.* FROM `towns` WHERE `towns`.`id` = ? LIMIT ?` |
| sql | app/models/town.rb:59 | 2.9 | 2.74 | 7.10% | `SELECT `gyms`.`id`, `gyms`.`slug_name`, `gyms`.`name`, `gyms`.`country`, `gyms`…` |
| sql | app/models/town.rb:134 | 30.56 | 0.18 | 4.94% | `SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`d…` |
| sql | app/models/town.rb:187 | 1.24 | 3.0 | 3.33% | `BEGIN UPDATE `towns` SET `towns`.`updated_at` = ? WHERE `towns`.`id` = ?` |
| sql | app/models/town.rb:48 | 2.41 | 1.0 | 2.15% | `SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = ? LIMIT ?` |
| sql | app/models/concerns/route_figurable.rb:70 | 2.79 | 0.82 | 2.04% | `SELECT climbing_type, crag_routes.max_grade_value, crag_routes.max_grade_text, …` |
| sql | app/models/town.rb:191 | 1.67 | 1.0 | 1.49% | `SELECT `town_json_objects`.* FROM `town_json_objects` WHERE `town_json_objects`…` |
| sql | app/models/town.rb:152 | 1.67 | 0.82 | 1.22% | `SELECT `guide_book_papers`.`id`, `guide_book_papers`.`slug_name`, `guide_book_p…` |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135627/jobs/HistorizeTownJob?range=1d)