Average Self

9.6ms

Average calls

1x

Total Self

9.6ms

Total Children

17ms

Total runtime

27ms

        Api::V1::ClimbingSessionsController#friends_climbing_sessions
      

Average Self

8ms

Average calls

0.99x

Total Self

7.9ms

Total Children

0ms

Total runtime

7.9ms

        SELECT `ascents`.* FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY released_at DESC,  min_grade_value DESC, gym_grade_level DESC) AS rn FROM `ascents` WHERE `ascents`.`user_id` IN (?) AND `ascents`.`ascent_status` != ?) AS ascents WHERE (rn = ?)
      

Average Self

3.1ms

Average calls

2.4x

Total Self

7.4ms

Total Children

0ms

Total runtime

7.4ms

        SELECT users.*, (SELECT released_at FROM ascents WHERE ascents.user_id = users.id AND ascents.ascent_status != "project" ORDER BY released_at DESC LIMIT ?) AS last_released_at FROM `users` WHERE (EXISTS(SELECT *
                                   FROM follows
                                   WHERE follows.followable_type = "User"
                                     AND follows.followable_id = users.id
                                     AND follows.followable_id != ?
                                     AND follows.accepted_at IS NOT NULL
                                     AND follows.user_id = ?)) ORDER BY last_released_at DESC, users.id LIMIT ? OFFSET ?
      

Average Self

2.7ms

Average calls

1x

Total Self

2.7ms

Total Children

27ms

Total runtime

30ms

        Rails::Engine#call
      

Average Self

1.8ms

Average calls

1x

Total Self

1.8ms

Total Children

0ms

Total runtime

1.8ms

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

Average Self

1.4ms

Average calls

0.48x

Total Self

0.7ms

Total Children

0ms

Total runtime

0.7ms

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

Average Self

1ms

Average calls

<0.01x

Total Self

<0.01ms

Total Children

0ms

Total runtime

<0.01ms

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