|
code
app/controllers/api/v1/gym_routes_controller.rb:84
|
64%
|
app/controllers/api/v1/gym_routes_controller.rb:84
- Average Self
-
48ms
- Average calls
- 1x
- Total Self
- 48ms
- Total Children
- 24ms
- Total runtime
- 73ms
Api::V1::GymRoutesController#paginated
|
|
sql
app/controllers/api/v1/gym_routes_controller.rb:142
|
25%
|
app/controllers/api/v1/gym_routes_controller.rb:142
- Average Self
-
4ms
- Average calls
- 4.7x
- Total Self
- 18ms
- Total Children
- 0ms
- Total runtime
- 18ms
SELECT DISTINCT gym_sectors.order, gym_sectors.name, gym_sectors.id, gym_routes.anchor_number, gym_routes.min_grade_value, gym_routes.id AS alias_0, `gym_routes`.`id` FROM `gym_routes` INNER JOIN `gym_sectors` ON `gym_routes`.`gym_sector_id` = `gym_sectors`.`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` > ?) LEFT OUTER JOIN `gym_route_openers` ON `gym_route_openers`.`gym_route_id` = `gym_routes`.`id` LEFT OUTER JOIN `gym_openers` ON `gym_openers`.`id` = `gym_route_openers`.`gym_opener_id` LEFT OUTER JOIN `gym_sectors` `gym_sectors_gym_routes_join` ON `gym_sectors_gym_routes_join`.`id` = `gym_routes`.`gym_sector_id` AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) LEFT OUTER JOIN `gym_spaces` ON `gym_spaces`.`id` = `gym_sectors_gym_routes_join`.`gym_space_id` AND (`gym [TRUNCATED]
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
3%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
2.3ms
- Average calls
- 1x
- Total Self
- 2.3ms
- Total Children
- 73ms
- Total runtime
- 76ms
Rails::Engine#call
|
|
sql
app/controllers/concerns/gymable.rb:16
|
2%
|
app/controllers/concerns/gymable.rb:16
- Average Self
-
1.4ms
- Average calls
- 1x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` = ? LIMIT ?
|
|
sql
app/models/gym_route_ascents_mapper.rb:26
|
2%
|
app/models/gym_route_ascents_mapper.rb:26
- Average Self
-
1.4ms
- Average calls
- 0.97x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
SELECT COUNT(*) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`gym_route_id` = ?
|
|
sql
app/controllers/api/v1/api_controller.rb:73
|
2%
|
app/controllers/api/v1/api_controller.rb:73
- Average Self
-
1.2ms
- Average calls
- 0.97x
- Total Self
- 1.2ms
- Total Children
- 0ms
- Total runtime
- 1.2ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/gym_routes_controller.rb:413
|
1%
|
app/controllers/api/v1/gym_routes_controller.rb:413
- Average Self
-
1.2ms
- Average calls
- 0.83x
- Total Self
- 0.96ms
- Total Children
- 0ms
- Total runtime
- 0.96ms
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 ?
|
|
sql
app/models/gym_route_ascents_mapper.rb:29
|
<1%
|
app/models/gym_route_ascents_mapper.rb:29
- Average Self
-
1.7ms
- Average calls
- 0.41x
- Total Self
- 0.68ms
- Total Children
- 0ms
- Total runtime
- 0.68ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`gym_route_id` IN (?) ORDER BY FIELD(ascent_status, "onsight", "flash", "red_point", "sent", "repetition", "project")
|
|
sql
app/models/gym_route.rb:132
|
<1%
|
app/models/gym_route.rb:132
- Average Self
-
1.4ms
- Average calls
- 0.29x
- Total Self
- 0.4ms
- Total Children
- 0ms
- Total runtime
- 0.4ms
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 ?
|
|
sql
app/models/gym_route_ascents_mapper.rb:28
|
<1%
|
app/models/gym_route_ascents_mapper.rb:28
- Average Self
-
0.14ms
- Average calls
- 0.41x
- Total Self
- 0.06ms
- Total Children
- 0ms
- Total runtime
- 0.06ms
SELECT COUNT(*) FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ? AND `ascents`.`gym_route_id` IN (?)
|