Average Self

23ms

Average calls

16x

Total Self

389ms

Total Children

0ms

Total runtime

389ms

        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]
      

Average Self

307ms

Average calls

1x

Total Self

307ms

Total Children

399ms

Total runtime

707ms

        Api::V1::GymsController#ascent_scores
      

Average Self

7.3ms

Average calls

0.98x

Total Self

7.2ms

Total Children

0ms

Total runtime

7.2ms

        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`
      

Average Self

2.4ms

Average calls

1x

Total Self

2.4ms

Total Children

707ms

Total runtime

709ms

        Rails::Engine#call
      

Average Self

1.3ms

Average calls

0.98x

Total Self

1.3ms

Total Children

0ms

Total runtime

1.3ms

        SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` = ? LIMIT ?
      

Average Self

1.1ms

Average calls

0.98x

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, ?, ?, ?)
      

Average Self

1ms

Average calls

0.03x

Total Self

0.03ms

Total Children

0ms

Total runtime

0.03ms

        SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` IS NULL LIMIT ?