|
sql
app/controllers/api/v1/contest_participant_ascents_controller.rb:61
|
44%
|
app/controllers/api/v1/contest_participant_ascents_controller.rb:61
- Average Self
-
1.5ms
- Average calls
- 36x
- Total Self
- 53ms
- Total Children
- 0ms
- Total runtime
- 53ms
BEGIN
SELECT `contest_participants`.* FROM `contest_participants` WHERE `contest_participants`.`id` = ? LIMIT ?
|
|
code
app/controllers/api/v1/contest_participant_ascents_controller.rb:46
|
39%
|
app/controllers/api/v1/contest_participant_ascents_controller.rb:46
- Average Self
-
46ms
- Average calls
- 1x
- Total Self
- 46ms
- Total Children
- 70ms
- Total runtime
- 116ms
Api::V1::ContestParticipantAscentsController#bulk
|
|
sql
app/controllers/api/v1/contest_participant_ascents_controller.rb:49
|
9%
|
app/controllers/api/v1/contest_participant_ascents_controller.rb:49
- Average Self
-
1.5ms
- Average calls
- 7.2x
- Total Self
- 10ms
- Total Children
- 0ms
- Total runtime
- 10ms
SELECT `contest_participant_ascents`.* FROM `contest_participant_ascents` WHERE `contest_participant_ascents`.`contest_participant_id` = ? AND `contest_participant_ascents`.`contest_route_id` = ? LIMIT ?
|
|
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
-
3ms
- Average calls
- 1x
- Total Self
- 3ms
- Total Children
- 116ms
- Total runtime
- 120ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/contest_participant_ascents_controller.rb:95
|
1%
|
app/controllers/api/v1/contest_participant_ascents_controller.rb:95
- Average Self
-
1.8ms
- Average calls
- 1x
- Total Self
- 1.8ms
- Total Children
- 0ms
- Total runtime
- 1.8ms
SELECT `contest_participants`.* FROM `contest_participants` INNER JOIN `contest_categories` ON `contest_participants`.`contest_category_id` = `contest_categories`.`id` WHERE `contest_categories`.`contest_id` = ? AND `contest_participants`.`token` = ? ORDER BY `contest_categories`.`order` ASC LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:26
|
1%
|
app/controllers/api/v1/api_controller.rb:26
- Average Self
-
1.5ms
- Average calls
- 1x
- Total Self
- 1.5ms
- Total Children
- 0ms
- Total runtime
- 1.5ms
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/controllers/api/v1/contest_participant_ascents_controller.rb:90
|
1%
|
app/controllers/api/v1/contest_participant_ascents_controller.rb:90
- Average Self
-
1.4ms
- Average calls
- 1x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
SELECT `contests`.* FROM `contests` WHERE (`contests`.`deleted_at` IS NULL OR `contests`.`deleted_at` > ?) AND `contests`.`gym_id` = ? AND `contests`.`id` = ? LIMIT ?
|
|
redis
app/controllers/api/v1/contest_participant_ascents_controller.rb:78
|
<1%
|
app/controllers/api/v1/contest_participant_ascents_controller.rb:78
- Average Self
-
0.67ms
- Average calls
- 1.1x
- Total Self
- 0.7ms
- Total Children
- 0.03ms
- Total runtime
- 0.73ms
select
|
|
sql
app/models/contest_service/result.rb:22
|
<1%
|
app/models/contest_service/result.rb:22
- Average Self
-
1.8ms
- Average calls
- 0.24x
- Total Self
- 0.43ms
- Total Children
- 0ms
- Total runtime
- 0.43ms
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_participant_ascent.rb:45
|
<1%
|
app/models/contest_participant_ascent.rb:45
- Average Self
-
1.2ms
- Average calls
- 0.24x
- Total Self
- 0.3ms
- Total Children
- 0ms
- Total runtime
- 0.3ms
SELECT `contests`.* FROM `contests` INNER JOIN `contest_categories` ON `contests`.`id` = `contest_categories`.`contest_id` INNER JOIN `contest_participants` ON `contest_categories`.`id` = `contest_participants`.`contest_category_id` WHERE (`contests`.`deleted_at` IS NULL OR `contests`.`deleted_at` > ?) AND `contest_participants`.`id` = ? ORDER BY `contest_categories`.`order` ASC LIMIT ?
|