Average Self

15ms

Average calls

1x

Total Self

15ms

Total Children

14ms

Total runtime

30ms

        Api::V1::UsersController#indoor_figures
      

Average Self

1.4ms

Average calls

2x

Total Self

2.8ms

Total Children

0ms

Total runtime

2.8ms

        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.3ms

Average calls

2x

Total Self

2.6ms

Total Children

0ms

Total runtime

2.6ms

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

Average Self

2.5ms

Average calls

1x

Total Self

2.5ms

Total Children

30ms

Total runtime

33ms

        Rails::Engine#call
      

Average Self

2.1ms

Average calls

1x

Total Self

2.1ms

Total Children

0ms

Total runtime

2.1ms

        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.7ms

Average calls

1x

Total Self

1.7ms

Total Children

0ms

Total runtime

1.7ms

        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

1.5ms

Average calls

1x

Total Self

1.5ms

Total Children

0ms

Total runtime

1.5ms

        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

1.5ms

Average calls

1x

Total Self

1.5ms

Total Children

0ms

Total runtime

1.5ms

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

Average Self

1.3ms

Average calls

1x

Total Self

1.3ms

Total Children

0ms

Total runtime

1.3ms

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

Average Self

1.2ms

Average calls

1x

Total Self

1.2ms

Total Children

0ms

Total runtime

1.2ms

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