Average Self

10ms

Average calls

1x

Total Self

10ms

Total Children

11ms

Total runtime

22ms

        Api::V1::UsersController#indoor_figures
      

Average Self

1.6ms

Average calls

2x

Total Self

3.3ms

Total Children

0ms

Total runtime

3.3ms

        SELECT SUM(`ascents`.`quantity`) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ?
      

Average Self

1.1ms

Average calls

2x

Total Self

2.3ms

Total Children

0ms

Total runtime

2.3ms

        SELECT COUNT(DISTINCT `gyms`.`id`) FROM `gyms` INNER JOIN `ascents` ON `gyms`.`id` = `ascents`.`gym_id` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `ascents`.`type` = ? AND `ascents`.`user_id` = ?
      

Average Self

1.5ms

Average calls

1x

Total Self

1.5ms

Total Children

22ms

Total runtime

23ms

        Rails::Engine#call
      

Average Self

1.5ms

Average calls

1x

Total Self

1.5ms

Total Children

0ms

Total runtime

1.5ms

        SELECT COUNT(DISTINCT `gyms`.`code_country`) FROM `gyms` INNER JOIN `ascents` ON `gyms`.`id` = `ascents`.`gym_id` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `ascents`.`type` = ? AND `ascents`.`user_id` = ?
      

Average Self

1.3ms

Average calls

1x

Total Self

1.3ms

Total Children

0ms

Total runtime

1.3ms

        SELECT COUNT(*) FROM `climbing_sessions` WHERE `climbing_sessions`.`user_id` = ? AND (EXISTS(SELECT * FROM ascents WHERE gym_id IS NOT NULL AND climbing_session_id = climbing_sessions.id)) AND (climbing_sessions.session_date >= ?)
      

Average Self

1ms

Average calls

1x

Total Self

1ms

Total Children

0ms

Total runtime

1ms

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

Average Self

1ms

Average calls

1x

Total Self

1ms

Total Children

0ms

Total runtime

1ms

        SELECT COUNT(DISTINCT `gyms`.`region`) FROM `gyms` INNER JOIN `ascents` ON `gyms`.`id` = `ascents`.`gym_id` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `ascents`.`type` = ? AND `ascents`.`user_id` = ?
      

Average Self

1ms

Average calls

1x

Total Self

1ms

Total Children

0ms

Total runtime

1ms

        SELECT SUM(height * quantity) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ?
      

Average Self

0.5ms

Average calls

1x

Total Self

0.5ms

Total Children

0ms

Total runtime

0.5ms

        SELECT MAX(`ascents`.`max_grade_value`) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ?