|
code
app/controllers/api/v1/contests_controller.rb:81
|
65%
|
app/controllers/api/v1/contests_controller.rb:81
- Average Self
-
219ms
- Calls
- 1x
- Total Self
- 219ms
- Total Children
- 115ms
- Total runtime
- 334ms
Api::V1::ContestsController#create
|
|
sql
app/models/contest_category.rb:188
|
5%
|
app/models/contest_category.rb:188
- Average Self
-
1.5ms
- Calls
- 11x
- Total Self
- 17ms
- Total Children
- 0ms
- Total runtime
- 17ms
SELECT `contest_categories`.* FROM `contest_categories` WHERE `contest_categories`.`contest_id` = ? ORDER BY `contest_categories`.`order` DESC LIMIT ?
|
|
sql
app/models/contest_category.rb:103
|
4%
|
app/models/contest_category.rb:103
- Average Self
-
1.3ms
- Calls
- 11x
- Total Self
- 14ms
- Total Children
- 0ms
- Total runtime
- 14ms
SELECT `gyms`.* FROM `gyms` INNER JOIN `contests` ON `gyms`.`id` = `contests`.`gym_id` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND (`contests`.`deleted_at` IS NULL OR `contests`.`deleted_at` > ?) AND `contests`.`id` = ? LIMIT ?
|
|
sql
app/models/contest.rb:362
|
4%
|
app/models/contest.rb:362
- Average Self
-
1.1ms
- Calls
- 11x
- Total Self
- 12ms
- Total Children
- 0ms
- Total runtime
- 12ms
INSERT INTO `contest_categories` (`name`, `order`, `capacity`, `registration_obligation`, `contest_id`, `created_at`, `updated_at`) VALUES (?, ?, ?, ?, ?, ?, ?)
|
|
sql
app/models/contest_category.rb:181
|
4%
|
app/models/contest_category.rb:181
- Average Self
-
1.1ms
- Calls
- 11x
- Total Self
- 12ms
- Total Children
- 0ms
- Total runtime
- 12ms
SELECT `contest_participants`.* FROM `contest_participants` WHERE `contest_participants`.`contest_category_id` = ?
|
|
sql
app/models/contest_category.rb:97
|
3%
|
app/models/contest_category.rb:97
- Average Self
-
1ms
- Calls
- 11x
- Total Self
- 11ms
- Total Children
- 0ms
- Total runtime
- 11ms
SELECT COUNT(*) FROM `contest_participants` WHERE `contest_participants`.`contest_category_id` = ? AND `contest_participants`.`genre` = ?
|
|
sql
app/models/contest_service/result.rb:22
|
3%
|
app/models/contest_service/result.rb:22
- Average Self
-
1ms
- Calls
- 11x
- Total Self
- 11ms
- Total Children
- 0ms
- Total runtime
- 11ms
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_category.rb:98
|
3%
|
app/models/contest_category.rb:98
- Average Self
-
0.91ms
- Calls
- 11x
- Total Self
- 10ms
- Total Children
- 0ms
- Total runtime
- 10ms
SELECT COUNT(*) FROM `contest_participants` WHERE `contest_participants`.`contest_category_id` = ? AND `contest_participants`.`genre` = ?
|
|
sql
app/models/contest_category.rb:96
|
2%
|
app/models/contest_category.rb:96
- Average Self
-
0.73ms
- Calls
- 11x
- Total Self
- 8ms
- Total Children
- 0ms
- Total runtime
- 8ms
SELECT COUNT(*) FROM `contest_participants` WHERE `contest_participants`.`contest_category_id` = ?
|
|
sql
app/controllers/api/v1/contests_controller.rb:84
|
2%
|
app/controllers/api/v1/contests_controller.rb:84
- Average Self
-
2ms
- Calls
- 3x
- Total Self
- 6ms
- Total Children
- 0ms
- Total runtime
- 6ms
BEGIN
INSERT INTO `contests` (`gym_id`, `name`, `slug_name`, `description`, `start_date`, `end_date`, `subscription_start_date`, `subscription_end_date`, `total_capacity`, `categorization_type`, `created_at`, `updated_at`, `draft`, `hide_results`, `combined_ranking_type`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, TRUE, TRUE, ?)
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
1%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
5ms
- Calls
- 1x
- Total Self
- 5ms
- Total Children
- 334ms
- Total runtime
- 339ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/api_controller.rb:26
|
<1%
|
app/controllers/api/v1/api_controller.rb:26
- Average Self
-
2ms
- 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_category.rb:73
|
<1%
|
app/models/contest_category.rb:73
- Average Self
-
0.18ms
- Calls
- 11x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT `contest_categories`.`registration_obligation` FROM `contest_categories` WHERE `contest_categories`.`contest_id` = ? AND `contest_categories`.`registration_obligation` IN (?) ORDER BY `contest_categories`.`order` ASC
|
|
sql
app/models/contest.rb:147
|
<1%
|
app/models/contest.rb:147
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `contest_waves`.* FROM `contest_waves` WHERE `contest_waves`.`contest_id` = ? ORDER BY `contest_waves`.`name` ASC
|
|
sql
app/models/contest.rb:148
|
<1%
|
app/models/contest.rb:148
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `ffme_contests`.* FROM `ffme_contests` WHERE `ffme_contests`.`contest_id` = ? LIMIT ?
|
|
sql
app/models/contest.rb:144
|
<1%
|
app/models/contest.rb:144
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `contest_categories`.* FROM `contest_categories` WHERE `contest_categories`.`contest_id` = ? ORDER BY `contest_categories`.`order` ASC
|
|
sql
app/models/contest.rb:114
|
<1%
|
app/models/contest.rb:114
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT COUNT(*) FROM `contest_participants` INNER JOIN `contest_categories` ON `contest_participants`.`contest_category_id` = `contest_categories`.`id` WHERE `contest_categories`.`contest_id` = ?
|
|
sql
app/controllers/api/v1/contests_controller.rb:160
|
<1%
|
app/controllers/api/v1/contests_controller.rb:160
- Average Self
-
1ms
- 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/contests_controller.rb:148
|
<1%
|
app/controllers/api/v1/contests_controller.rb:148
- Average Self
-
1ms
- 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_category.rb:180
|
<1%
|
app/models/contest_category.rb:180
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `contest_stage_steps`.* FROM `contest_stage_steps` INNER JOIN `contest_stages` ON `contest_stage_steps`.`contest_stage_id` = `contest_stages`.`id` WHERE `contest_stages`.`contest_id` = ? ORDER BY `contest_stages`.`stage_order` ASC
|
|
sql
app/models/contest.rb:145
|
<1%
|
app/models/contest.rb:145
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `contest_stages`.* FROM `contest_stages` WHERE `contest_stages`.`contest_id` = ? ORDER BY `contest_stages`.`stage_order` ASC
|
|
sql
app/models/contest.rb:146
|
<1%
|
app/models/contest.rb:146
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `championships`.* FROM `championships` INNER JOIN `championship_contests` ON `championships`.`id` = `championship_contests`.`championship_id` WHERE `championship_contests`.`contest_id` = ?
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
<1%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/models/contest.rb:49
|
<1%
|
app/models/contest.rb:49
- Average Self
-
0ms
- Calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT COUNT(*) FROM `contest_participants` INNER JOIN `contest_categories` ON `contest_participants`.`contest_category_id` = `contest_categories`.`id` WHERE `contest_categories`.`contest_id` = ?
|
|
sql
app/controllers/concerns/gym_roles_verification.rb:17
|
<1%
|
app/controllers/concerns/gym_roles_verification.rb:17
- Average Self
-
0ms
- Calls
- 1x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT `gym_administrators`.* FROM `gym_administrators` WHERE `gym_administrators`.`user_id` = ? AND `gym_administrators`.`gym_id` = ? LIMIT ?
|