app/models/concerns/route_figurable.rb:70
- Average Self
-
20ms
- Average calls
- 1x
- Total Self
- 20ms
- Total Children
- 0ms
- Total runtime
- 20ms
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 `crag_routes`.`crag_id` = `crags`.`id` INNER JOIN `crags` `crags_crag_routes` ON `crags_crag_routes`.`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 (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`department_id` = ?
|