Average Self

22ms

Average calls

1x

Total Self

22ms

Total Children

8.7ms

Total runtime

31ms

        Api::V1::LogBooks::OutdoorsController#stats
      

Average Self

4.4ms

Average calls

0.94x

Total Self

4.2ms

Total Children

0ms

Total runtime

4.2ms

        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`.`gym_grade_id` AS t0_r28, `as [TRUNCATED]
      

Average Self

2.8ms

Average calls

1x

Total Self

2.8ms

Total Children

31ms

Total runtime

34ms

        Rails::Engine#call
      

Average Self

2.9ms

Average calls

0.94x

Total Self

2.8ms

Total Children

0ms

Total runtime

2.8ms

        SELECT COUNT(DISTINCT `ascents`.`id`) FROM `ascents` INNER JOIN `crag_routes` ON `crag_routes`.`id` = `ascents`.`crag_route_id` AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) INNER JOIN `crags` ON `crags`.`id` = `crag_routes`.`crag_id` AND (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ? AND `ascents`.`ascent_status` IN (?) AND `ascents`.`roping_status` IN (?) AND `crag_routes`.`climbing_type` IN (?)
      

Average Self

1.6ms

Average calls

1x

Total Self

1.6ms

Total Children

0ms

Total runtime

1.6ms

        SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
      

Average Self

3ms

Average calls

0.06x

Total Self

0.19ms

Total Children

0ms

Total runtime

0.19ms

        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`.`gym_grade_id` AS t0_r28, `as [TRUNCATED]