Average Self

102ms

Average calls

0.17x

Total Self

17ms

Total Children

0ms

Total runtime

17ms

        SELECT COUNT(*), gym_id
                FROM gyms
                     INNER JOIN gym_spaces ON gyms.id = gym_spaces.gym_id
                     INNER JOIN gym_sectors ON gym_spaces.id = gym_sectors.gym_space_id
                     INNER JOIN gym_routes ON gym_sectors.id = gym_routes.gym_sector_id
                WHERE gym_routes.dismounted_at IS NULL
                  AND gym_routes.opened_at > CURRENT_DATE - INTERVAL ? YEAR
                GROUP BY gym_id
                HAVING COUNT(*) > ?
      

Average Self

92ms

Average calls

0.17x

Total Self

16ms

Total Children

0ms

Total runtime

16ms

        SELECT COUNT(*) FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?)
      

Average Self

12ms

Average calls

0.66x

Total Self

8.3ms

Total Children

0ms

Total runtime

8.3ms

        SET NAMES utf8mb4,  @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ?), ?),  @@SESSION.sql_auto_is_null = ?, @@SESSION.wait_timeout = ?
      

Average Self

5ms

Average calls

1x

Total Self

5ms

Total Children

44ms

Total runtime

49ms

        Api::V1::CommonsController#micro_stats
      

Average Self

5.1ms

Average calls

0.52x

Total Self

2.6ms

Total Children

0ms

Total runtime

2.6ms

        SELECT COUNT(*) FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?)
      

Average Self

1.8ms

Average calls

1x

Total Self

1.8ms

Total Children

49ms

Total runtime

51ms

        Rails::Engine#call
      

Average Self

1.5ms

Average calls

0.21x

Total Self

0.31ms

Total Children

0ms

Total runtime

0.31ms

        SELECT COUNT(*) FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?)