app/controllers/api/v1/gyms_controller.rb:155
- Average Self
-
24ms
- Average calls
- 16x
- Total Self
- 405ms
- Total Children
- 0ms
- Total runtime
- 405ms
SELECT `ascents`.`id` AS t0_r0, `ascents`.`type` AS t0_r1, `ascents`.`ascent_status` AS t0_r2, `ascents`.`roping_status` AS t0_r3, `ascents`.`attempt` AS t0_r4, `ascents`.`user_id` AS t0_r5, `ascents`.`crag_route_id` AS t0_r6, `ascents`.`gym_route_id` AS t0_r7, `ascents`.`sections` AS t0_r8, `ascents`.`height` AS t0_r9, `ascents`.`climbing_type` AS t0_r10, `ascents`.`note` AS t0_r11, `ascents`.`comment` AS t0_r12, `ascents`.`comments_count` AS t0_r13, `ascents`.`sections_count` AS t0_r14, `ascents`.`max_grade_value` AS t0_r15, `ascents`.`min_grade_value` AS t0_r16, `ascents`.`max_grade_text` AS t0_r17, `ascents`.`min_grade_text` AS t0_r18, `ascents`.`legacy_id` AS t0_r19, `ascents`.`released_at` AS t0_r20, `ascents`.`created_at` AS t0_r21, `ascents`.`updated_at` AS t0_r22, `ascents`.`points` AS t0_r23, `ascents`.`private_comment` AS t0_r24, `ascents`.`hardness_status` AS t0_r25, `ascents`.`gym_grade_level` AS t0_r26, `ascents`.`gym_id` AS t0_r27, `ascents`.`quantity` AS t0_r28, `ascent [TRUNCATED]
|
app/controllers/api/v1/gyms_controller.rb:118
- Average Self
-
7.1ms
- Average calls
- 0.99x
- Total Self
- 7.1ms
- Total Children
- 0ms
- Total runtime
- 7.1ms
SELECT MIN(gym_routes.min_grade_value) AS min_grade_value, MAX(gym_routes.min_grade_value) AS max_grade_value, gym_routes.climbing_type FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_sectors`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` ON `gym_spaces`.`id` = `gym_sectors`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) WHERE `gym_spaces`.`gym_id` = ? AND (opened_at <= ? AND dismounted_at IS NULL OR dismounted_at >= ?) GROUP BY `gym_routes`.`climbing_type`
|
app/controllers/api/v1/gyms_controller.rb:125
- Average Self
-
1.1ms
- Average calls
- 0.99x
- Total Self
- 1.1ms
- Total Children
- 0ms
- Total runtime
- 1.1ms
SELECT `gym_levels`.* FROM `gym_levels` WHERE `gym_levels`.`gym_id` = ? AND `gym_levels`.`enabled` = TRUE ORDER BY FIELD(climbing_type, ?, ?, ?)
|