|
code
app/controllers/api/v1/contest_route_groups_controller.rb:42
|
60%
|
app/controllers/api/v1/contest_route_groups_controller.rb:42
- Average Self
-
49ms
- Average calls
- 1x
- Total Self
- 49ms
- Total Children
- 29ms
- Total runtime
- 78ms
Api::V1::ContestRouteGroupsController#update
|
|
sql
app/controllers/api/v1/contest_route_groups_controller.rb:43
|
10%
|
app/controllers/api/v1/contest_route_groups_controller.rb:43
- Average Self
-
1.6ms
- Average calls
- 5.3x
- Total Self
- 8.3ms
- Total Children
- 0ms
- Total runtime
- 8.3ms
BEGIN
SELECT `contest_categories`.* FROM `contest_categories` WHERE `contest_categories`.`id` IN (?) ORDER BY `contest_categories`.`order` ASC
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
4%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
3ms
- Average calls
- 1x
- Total Self
- 3ms
- Total Children
- 78ms
- Total runtime
- 81ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/contest_route_groups_controller.rb:76
|
2%
|
app/controllers/api/v1/contest_route_groups_controller.rb:76
- Average Self
-
2ms
- Average calls
- 1x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT `contest_stages`.* FROM `contest_stages` WHERE `contest_stages`.`contest_id` = ? AND `contest_stages`.`id` = ? ORDER BY `contest_stages`.`stage_order` ASC LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:26
|
2%
|
app/controllers/api/v1/api_controller.rb:26
- Average Self
-
2ms
- Average calls
- 1x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT `ip_black_lists`.* FROM `ip_black_lists` WHERE (block_expired_at <= NOW() OR block_expired_at IS NULL) AND `ip_black_lists`.`ip` IS NULL LIMIT ?
|
|
sql
app/models/contest_route_group.rb:46
|
2%
|
app/models/contest_route_group.rb:46
- Average Self
-
2ms
- Average calls
- 1x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT `contest_routes`.* FROM `contest_routes` WHERE `contest_routes`.`contest_route_group_id` = ? ORDER BY `contest_routes`.`number` ASC
|
|
sql
app/models/contest_service/result.rb:22
|
2%
|
app/models/contest_service/result.rb:22
- Average Self
-
1.7ms
- Average calls
- 1x
- Total Self
- 1.7ms
- Total Children
- 0ms
- Total runtime
- 1.7ms
SELECT MAX(`contest_participant_ascents`.`registered_at`) FROM `contest_participant_ascents` INNER JOIN `contest_participants` ON `contest_participant_ascents`.`contest_participant_id` = `contest_participants`.`id` INNER JOIN `contest_categories` ON `contest_participants`.`contest_category_id` = `contest_categories`.`id` WHERE `contest_categories`.`contest_id` = ?
|
|
sql
app/models/contest_route_group.rb:47
|
2%
|
app/models/contest_route_group.rb:47
- Average Self
-
1.7ms
- Average calls
- 1x
- Total Self
- 1.7ms
- Total Children
- 0ms
- Total runtime
- 1.7ms
SELECT `contest_time_blocks`.* FROM `contest_time_blocks` WHERE `contest_time_blocks`.`contest_route_group_id` = ?
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
2%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.7ms
- Average calls
- 1x
- Total Self
- 1.7ms
- Total Children
- 0ms
- Total runtime
- 1.7ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/controllers/concerns/gym_roles_verification.rb:17
|
2%
|
app/controllers/concerns/gym_roles_verification.rb:17
- Average Self
-
1.7ms
- Average calls
- 1x
- Total Self
- 1.7ms
- Total Children
- 0ms
- Total runtime
- 1.7ms
SELECT `gym_administrators`.* FROM `gym_administrators` WHERE `gym_administrators`.`user_id` = ? AND `gym_administrators`.`gym_id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/contest_route_groups_controller.rb:80
|
2%
|
app/controllers/api/v1/contest_route_groups_controller.rb:80
- Average Self
-
1.7ms
- Average calls
- 1x
- Total Self
- 1.7ms
- Total Children
- 0ms
- Total runtime
- 1.7ms
SELECT `contest_stage_steps`.* FROM `contest_stage_steps` WHERE `contest_stage_steps`.`contest_stage_id` = ? AND `contest_stage_steps`.`id` = ? LIMIT ?
|
|
sql
app/models/contest_route_group.rb:109
|
2%
|
app/models/contest_route_group.rb:109
- Average Self
-
0.57ms
- Average calls
- 2.3x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
SELECT `contest_route_groups`.* FROM `contest_route_groups` WHERE `contest_route_groups`.`contest_stage_step_id` = ? AND `contest_route_groups`.`id` != ?
|
|
sql
app/controllers/api/v1/contest_route_groups_controller.rb:92
|
1%
|
app/controllers/api/v1/contest_route_groups_controller.rb:92
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT COUNT(*) FROM `gym_administrators` WHERE `gym_administrators`.`gym_id` = ? AND `gym_administrators`.`user_id` = ?
|
|
sql
app/controllers/api/v1/contest_route_groups_controller.rb:72
|
1%
|
app/controllers/api/v1/contest_route_groups_controller.rb:72
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `contests`.* FROM `contests` WHERE (`contests`.`deleted_at` IS NULL OR `contests`.`deleted_at` > ?) AND `contests`.`gym_id` = ? AND `contests`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/contest_route_groups_controller.rb:84
|
1%
|
app/controllers/api/v1/contest_route_groups_controller.rb:84
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `contest_route_groups`.* FROM `contest_route_groups` WHERE `contest_route_groups`.`contest_stage_step_id` = ? AND `contest_route_groups`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/contest_route_groups_controller.rb:68
|
1%
|
app/controllers/api/v1/contest_route_groups_controller.rb:68
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` = ? LIMIT ?
|
|
sql
app/models/contest_route_group.rb:101
|
1%
|
app/models/contest_route_group.rb:101
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `contests`.* FROM `contests` INNER JOIN `contest_stages` ON `contests`.`id` = `contest_stages`.`contest_id` INNER JOIN `contest_stage_steps` ON `contest_stages`.`id` = `contest_stage_steps`.`contest_stage_id` WHERE (`contests`.`deleted_at` IS NULL OR `contests`.`deleted_at` > ?) AND `contest_stage_steps`.`id` = ? ORDER BY `contest_stages`.`stage_order` ASC LIMIT ?
|