Average Self

11ms

Average calls

1x

Total Self

11ms

Total Children

19ms

Total runtime

31ms

        Api::V1::UsersController#indoor_figures
      

Average Self

2ms

Average calls

2x

Total Self

4ms

Total Children

0ms

Total runtime

4ms

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

Average calls

2x

Total Self

3.8ms

Total Children

0ms

Total runtime

3.8ms

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

Average Self

3.2ms

Average calls

1x

Total Self

3.2ms

Total Children

0ms

Total runtime

3.2ms

        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

2.4ms

Average calls

1x

Total Self

2.4ms

Total Children

0ms

Total runtime

2.4ms

        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

2.2ms

Average calls

1x

Total Self

2.2ms

Total Children

0ms

Total runtime

2.2ms

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

Average calls

1x

Total Self

1.8ms

Total Children

31ms

Total runtime

32ms

        Rails::Engine#call
      

Average Self

1.7ms

Average calls

1x

Total Self

1.7ms

Total Children

0ms

Total runtime

1.7ms

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

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 `users`.* FROM `users` WHERE `users`.`uuid` = ? LIMIT ?