app/models/concerns/route_figurable.rb:70
- Average Self
-
3ms
- Calls
- 1x
- Total Self
- 3ms
- Total Children
- 0ms
- Total runtime
- 3ms
SELECT climbing_type,
crag_routes.max_grade_value,
crag_routes.max_grade_text,
crag_routes.min_grade_value,
crag_routes.min_grade_text,
crag_routes.id,
crag_id,
crag_routes.name,
crag_routes.slug_name,
sections_count,
sections,
crags.name AS crag_name,
crags.slug_name AS crag_slug_name FROM `crag_routes` INNER JOIN `crags` ON `crags`.`id` = `crag_routes`.`crag_id` AND (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`crag_id` IN (?)
|
app/controllers/api/v1/areas_controller.rb:55
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `crags`.`id`, `crags`.`name`, `crags`.`slug_name`, `crags`.`sport_climbing`, `crags`.`bouldering`, `crags`.`multi_pitch`, `crags`.`trad_climbing`, `crags`.`aid_climbing`, `crags`.`deep_water`, `crags`.`via_ferrata`, `crags`.`north`, `crags`.`north_east`, `crags`.`east`, `crags`.`south_east`, `crags`.`south`, `crags`.`south_west`, `crags`.`west`, `crags`.`north_west`, `crags`.`summer`, `crags`.`autumn`, `crags`.`winter`, `crags`.`spring`, `crags`.`min_approach_time`, `crags`.`max_approach_time` FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_crags`.`crag_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `area_crags`.`area_id` = ?
|