Average Self

149ms

Average calls

1x

Total Self

149ms

Total Children

0ms

Total runtime

149ms

        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

127ms

Average calls

1x

Total Self

127ms

Total Children

0ms

Total runtime

127ms

        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

49ms

Average calls

1x

Total Self

49ms

Total Children

0ms

Total runtime

49ms

        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

22ms

Average calls

1x

Total Self

22ms

Total Children

363ms

Total runtime

385ms

        Api::V1::Statistics::GymRouteStatisticsController#appreciation_figures
      

Average Self

14ms

Average calls

1x

Total Self

14ms

Total Children

0ms

Total runtime

14ms

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

Average Self

13ms

Average calls

1x

Total Self

13ms

Total Children

0ms

Total runtime

13ms

        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

4ms

Average calls

1x

Total Self

4ms

Total Children

0ms

Total runtime

4ms

        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

2.3ms

Average calls

1x

Total Self

2.3ms

Total Children

385ms

Total runtime

387ms

        Rails::Engine#call