Average Self

150ms

Average calls

1x

Total Self

150ms

Total Children

0ms

Total runtime

150ms

        SELECT `gym_routes`.* FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_routes`.`gym_sector_id` = `gym_sectors`.`id` INNER JOIN `gym_spaces` ON `gym_sectors`.`gym_space_id` = `gym_spaces`.`id` INNER JOIN `gym_sectors` `gym_sectors_gym_routes` ON `gym_sectors_gym_routes`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` `gym_spaces_gym_sectors` ON `gym_spaces_gym_sectors`.`id` = `gym_sectors_gym_routes`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) WHERE (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? AND (gym_routes.opened_at <= ? AND (gym_routes.dismounted_at IS NULL OR gym_routes.dismounted_at >= ?)) ORDE [TRUNCATED]
      

Average Self

27ms

Average calls

1x

Total Self

27ms

Total Children

0ms

Total runtime

27ms

        SELECT COUNT(*) FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_routes`.`gym_sector_id` = `gym_sectors`.`id` INNER JOIN `gym_spaces` ON `gym_sectors`.`gym_space_id` = `gym_spaces`.`id` INNER JOIN `gym_sectors` `gym_sectors_gym_routes` ON `gym_sectors_gym_routes`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` `gym_spaces_gym_sectors` ON `gym_spaces_gym_sectors`.`id` = `gym_sectors_gym_routes`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) WHERE (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? AND (gym_routes.opened_at <= ? AND (gym_routes.dismounted_at IS NULL OR gym_routes.dismounted_at >= ?))
      

Average Self

25ms

Average calls

1x

Total Self

25ms

Total Children

0ms

Total runtime

25ms

        SELECT MIN(`gym_routes`.`opened_at`) FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_routes`.`gym_sector_id` = `gym_sectors`.`id` INNER JOIN `gym_spaces` ON `gym_sectors`.`gym_space_id` = `gym_spaces`.`id` INNER JOIN `gym_sectors` `gym_sectors_gym_routes` ON `gym_sectors_gym_routes`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) INNER JOIN `gym_spaces` `gym_spaces_gym_sectors` ON `gym_spaces_gym_sectors`.`id` = `gym_sectors_gym_routes`.`gym_space_id` AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) WHERE (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? AND (gym_routes.opened_at <= ? AND (gym_routes.dismounted_at IS NULL OR gym_routes.dismounted_at >= '? [TRUNCATED]
      

Average Self

25ms

Average calls

1x

Total Self

25ms

Total Children

246ms

Total runtime

271ms

        Api::V1::Statistics::GymRouteStatisticsController#opening_frequencies
      

Average Self

17ms

Average calls

1x

Total Self

17ms

Total Children

0ms

Total runtime

17ms

        SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` = ? LIMIT ?
      

Average Self

14ms

Average calls

1x

Total Self

14ms

Total Children

0ms

Total runtime

14ms

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

Average Self

5.3ms

Average calls

1x

Total Self

5.3ms

Total Children

0ms

Total runtime

5.3ms

        SELECT ? AS one FROM `gym_administrators` WHERE `gym_administrators`.`gym_id` = ? AND `gym_administrators`.`user_id` = ? LIMIT ?
      

Average Self

5.3ms

Average calls

1x

Total Self

5.3ms

Total Children

0ms

Total runtime

5.3ms

        SELECT `ip_black_lists`.* FROM `ip_black_lists` WHERE (block_expired_at <= NOW() OR block_expired_at IS NULL) AND `ip_black_lists`.`ip` IS NULL LIMIT ?
      

Average Self

1.7ms

Average calls

1x

Total Self

1.7ms

Total Children

271ms

Total runtime

273ms

        Rails::Engine#call