Average Self

291ms

Average calls

1x

Total Self

291ms

Total Children

327ms

Total runtime

618ms

        Api::V1::CommonsController#active_gyms
      

Average Self

1.1ms

Average calls

144x

Total Self

162ms

Total Children

0ms

Total runtime

162ms

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

Average Self

120ms

Average calls

1x

Total Self

120ms

Total Children

0ms

Total runtime

120ms

        SELECT gyms.id,
                     COUNT(gym_routes.id),
                     MAX(opened_at)
              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 dismounted_at IS NULL
                AND opened_at > CURRENT_DATE - INTERVAL ? YEAR
              GROUP BY gyms.id
              HAVING COUNT(gym_routes.id) >= ?
              ORDER BY ? DESC
      

Average Self

1.1ms

Average calls

11x

Total Self

12ms

Total Children

0ms

Total runtime

12ms

        SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = ? AND `active_storage_attachments`.`record_type` = ? AND `active_storage_attachments`.`name` = ? LIMIT ?
      

Average Self

0.85ms

Average calls

11x

Total Self

9.7ms

Total Children

0ms

Total runtime

9.7ms

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

Average Self

1ms

Average calls

6.7x

Total Self

6.7ms

Total Children

0ms

Total runtime

6.7ms

        SELECT `gym_spaces`.* FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? ORDER BY `gym_spaces`.`order` ASC LIMIT ?
      

Average Self

1ms

Average calls

5.7x

Total Self

5.7ms

Total Children

0ms

Total runtime

5.7ms

        SELECT `gym_spaces`.* FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? ORDER BY `gym_spaces`.`order` ASC
      

Average Self

0.94ms

Average calls

5.7x

Total Self

5.3ms

Total Children

0ms

Total runtime

5.3ms

        SELECT `gym_options`.* FROM `gym_options` WHERE `gym_options`.`gym_id` = ?
      

Average Self

0.88ms

Average calls

5.7x

Total Self

5ms

Total Children

0ms

Total runtime

5ms

        SELECT COUNT(*) FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ?
      

Average Self

2.7ms

Average calls

1x

Total Self

2.7ms

Total Children

618ms

Total runtime

621ms

        Rails::Engine#call