Average Self

38ms

Average calls

1x

Total Self

38ms

Total Children

21ms

Total runtime

60ms

        Api::V1::GymSpacesController#show
      

Average Self

6.8ms

Average calls

1x

Total Self

6.8ms

Total Children

0ms

Total runtime

6.8ms

        SELECT SUM(coalesce(level_index, ?)) AS ?,
                         SUM(COALESCE(min_grade_value, ?)) AS ?,
                         SUM(COALESCE(points, ?)) AS ?,
                         GROUP_CONCAT(DISTINCT gym_routes.climbing_type) AS ?,
                         SUM(COALESCE(ascents_count, ?)) AS ?,
                         SUM(COALESCE(likes_count, ?)) AS ?,
                         SUM(COALESCE(comments_count, ?)) AS ? FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_sectors`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) WHERE `gym_routes`.`dismounted_at` IS NULL AND `gym_sectors`.`gym_space_id` = ? ORDER BY `gym_routes`.`id` ASC LIMIT ?
      

Average Self

1.5ms

Average calls

1.9x

Total Self

2.8ms

Total Children

0ms

Total runtime

2.8ms

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

Average Self

2.6ms

Average calls

1x

Total Self

2.6ms

Total Children

60ms

Total runtime

62ms

        Rails::Engine#call
      

Average Self

2.3ms

Average calls

1x

Total Self

2.3ms

Total Children

0ms

Total runtime

2.3ms

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

Average Self

1.9ms

Average calls

1x

Total Self

1.9ms

Total Children

0ms

Total runtime

1.9ms

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

Average Self

1.8ms

Average calls

1x

Total Self

1.8ms

Total Children

0ms

Total runtime

1.8ms

        SELECT `gym_sectors`.* FROM `gym_sectors` WHERE (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) AND `gym_sectors`.`gym_space_id` = ? ORDER BY `gym_sectors`.`order` DESC LIMIT ?
      

Average Self

1.5ms

Average calls

1x

Total Self

1.5ms

Total Children

0ms

Total runtime

1.5ms

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

Average Self

1.5ms

Average calls

1x

Total Self

1.5ms

Total Children

0ms

Total runtime

1.5ms

        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

1.6ms

Average calls

0.81x

Total Self

1.3ms

Total Children

0ms

Total runtime

1.3ms

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

Average Self

1.2ms

Average calls

0.98x

Total Self

1.2ms

Total Children

0ms

Total runtime

1.2ms

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

Average Self

1.2ms

Average calls

0.12x

Total Self

0.14ms

Total Children

0ms

Total runtime

0.14ms

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