app/controllers/api/v1/gyms_controller.rb:508
- Average Self
-
10ms
- Average calls
- 3x
- Total Self
- 31ms
- Total Children
- 0ms
- Total runtime
- 31ms
SELECT `gyms`.`id`, `gyms`.`name`, `gyms`.`longitude`, `gyms`.`latitude`, `gyms`.`updated_at` FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND (EXISTS(SELECT * 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 WHERE gym_routes.dismounted_at IS NULL AND gym_spaces.draft IS FALSE AND gym_spaces.gym_id = gyms.id AND gym_routes.opened_at > NOW() - INTERVAL ? DAY))
|