|
code
app/controllers/api/v1/ascent_gym_routes_controller.rb:35
|
56%
|
app/controllers/api/v1/ascent_gym_routes_controller.rb:35
- Average Self
-
11ms
- Average calls
- 1x
- Total Self
- 11ms
- Total Children
- 6.5ms
- Total runtime
- 18ms
Api::V1::AscentGymRoutesController#gym_routes_infos_in_logbook
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
12%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
2.5ms
- Average calls
- 1x
- Total Self
- 2.5ms
- Total Children
- 18ms
- Total runtime
- 20ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/ascent_gym_routes_controller.rb:39
|
8%
|
app/controllers/api/v1/ascent_gym_routes_controller.rb:39
- Average Self
-
1.6ms
- Average calls
- 1x
- Total Self
- 1.6ms
- Total Children
- 0ms
- Total runtime
- 1.6ms
SELECT `ascents`.`gym_route_id` FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`gym_route_id` = ? AND `ascents`.`user_id` = ? AND `ascents`.`ascent_status` != ?
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
7%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.5ms
- Average calls
- 1x
- Total Self
- 1.5ms
- Total Children
- 0ms
- Total runtime
- 1.5ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/ascent_gym_routes_controller.rb:48
|
7%
|
app/controllers/api/v1/ascent_gym_routes_controller.rb:48
- Average Self
-
1.4ms
- Average calls
- 1x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
SELECT `gym_routes`.* FROM `gym_routes` WHERE `gym_routes`.`id` = ?
|
|
sql
app/controllers/api/v1/ascent_gym_routes_controller.rb:41
|
6%
|
app/controllers/api/v1/ascent_gym_routes_controller.rb:41
- Average Self
-
1.3ms
- Average calls
- 1x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
SELECT COUNT(*) AS count_all, `gym_routes`.`climbing_type` AS gym_routes_climbing_type FROM `gym_routes` WHERE `gym_routes`.`id` = ? GROUP BY `gym_routes`.`climbing_type`
|
|
sql
app/models/gym_route.rb:254
|
<1%
|
app/models/gym_route.rb:254
- Average Self
-
1.5ms
- Average calls
- 0.13x
- Total Self
- 0.19ms
- Total Children
- 0ms
- Total runtime
- 0.19ms
SELECT `gym_route_covers`.* FROM `gym_route_covers` WHERE `gym_route_covers`.`id` = ? LIMIT ?
|
|
sql
app/models/gym_route.rb:143
|
<1%
|
app/models/gym_route.rb:143
- Average Self
-
2ms
- Average calls
- 0.04x
- Total Self
- 0.08ms
- Total Children
- 0ms
- Total runtime
- 0.08ms
SELECT `gym_spaces`.* FROM `gym_spaces` INNER JOIN `gym_sectors` ON `gym_spaces`.`id` = `gym_sectors`.`gym_space_id` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) AND `gym_sectors`.`id` = ? ORDER BY `gym_spaces`.`order` ASC, `gym_sectors`.`order` ASC LIMIT ?
|
|
sql
app/models/gym_route.rb:249
|
<1%
|
app/models/gym_route.rb:249
- Average Self
-
2ms
- Average calls
- 0.04x
- Total Self
- 0.08ms
- Total Children
- 0ms
- Total runtime
- 0.08ms
SELECT `gym_sectors`.* FROM `gym_sectors` WHERE (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) AND `gym_sectors`.`id` = ? ORDER BY `gym_sectors`.`order` ASC LIMIT ?
|
|
sql
app/models/gym_route.rb:226
|
<1%
|
app/models/gym_route.rb:226
- Average Self
-
1.5ms
- Average calls
- 0.04x
- Total Self
- 0.06ms
- Total Children
- 0ms
- Total runtime
- 0.06ms
SELECT `gym_openers`.* FROM `gym_openers` INNER JOIN `gym_route_openers` ON `gym_openers`.`id` = `gym_route_openers`.`gym_opener_id` WHERE `gym_route_openers`.`gym_route_id` = ?
|
|
sql
app/models/gym_route.rb:113
|
<1%
|
app/models/gym_route.rb:113
- Average Self
-
1.5ms
- Average calls
- 0.04x
- Total Self
- 0.06ms
- Total Children
- 0ms
- Total runtime
- 0.06ms
SELECT `gym_levels`.* FROM `gym_levels` WHERE `gym_levels`.`gym_id` = ?
|
|
sql
app/models/concerns/attachment_resizable.rb:12
|
<1%
|
app/models/concerns/attachment_resizable.rb:12
- Average Self
-
1.5ms
- Average calls
- 0.04x
- Total Self
- 0.06ms
- Total Children
- 0ms
- Total runtime
- 0.06ms
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
|
|
sql
app/models/concerns/attachment_resizable.rb:10
|
<1%
|
app/models/concerns/attachment_resizable.rb:10
- Average Self
-
1ms
- Average calls
- 0.04x
- Total Self
- 0.04ms
- Total Children
- 0ms
- Total runtime
- 0.04ms
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 ?
|
|
sql
app/models/gym_route.rb:61
|
<1%
|
app/models/gym_route.rb:61
- Average Self
-
2ms
- Average calls
- 0.02x
- Total Self
- 0.04ms
- Total Children
- 0ms
- Total runtime
- 0.04ms
SELECT `gyms`.* 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` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) AND `gym_sectors`.`id` = ? ORDER BY `gym_spaces`.`order` ASC, `gym_sectors`.`order` ASC LIMIT ?
|
|
sql
app/models/gym_route.rb:59
|
<1%
|
app/models/gym_route.rb:59
- Average Self
-
2ms
- Average calls
- 0.02x
- Total Self
- 0.04ms
- Total Children
- 0ms
- Total runtime
- 0.04ms
SELECT `gyms`.* 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` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND (`gym_sectors`.`deleted_at` IS NULL OR `gym_sectors`.`deleted_at` > ?) AND `gym_sectors`.`id` = ? ORDER BY `gym_spaces`.`order` ASC, `gym_sectors`.`order` ASC LIMIT ?
|