Average Self

5.8ms

Average calls

1x

Total Self

5.8ms

Total Children

5ms

Total runtime

10ms

        Api::V1::CragRoutesController#suggested_routes
      

Average Self

2.4ms

Average calls

1x

Total Self

2.4ms

Total Children

10ms

Total runtime

13ms

        Rails::Engine#call
      

Average Self

1.9ms

Average calls

1x

Total Self

1.9ms

Total Children

0ms

Total runtime

1.9ms

        SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND (EXISTS (SELECT * FROM follows WHERE followable_type = "Crag" AND followable_id = crag_routes.crag_id AND follows.user_id = ?)) AND NOT (EXISTS (SELECT * FROM ascents WHERE ascents.crag_route_id = crag_routes.id AND ascents.user_id = ?)) ORDER BY ascent_users_count DESC, note_count DESC LIMIT ? OFFSET ?
      

Average Self

1.7ms

Average calls

1x

Total Self

1.7ms

Total Children

0ms

Total runtime

1.7ms

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

Average Self

1.2ms

Average calls

1x

Total Self

1.2ms

Total Children

0ms

Total runtime

1.2ms

        SELECT COUNT(*) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ?
      

Average Self

1ms

Average calls

0.22x

Total Self

0.22ms

Total Children

0ms

Total runtime

0.22ms

        SELECT MIN(min_grade_value) AS min_grade_value, MAX(max_grade_value) AS max_grade_value FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? LIMIT ?