|
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.4ms
- Average calls
- 38x
- Total Self
- 52ms
- Total Children
- 0ms
- Total runtime
- 52ms
BEGIN
SELECT `contest_participants`.* FROM `contest_participants` WHERE `contest_participants`.`id` = ? LIMIT ?
|
|
code
app/controllers/api/v1/contest_participant_ascents_controller.rb:46
|
40%
|
app/controllers/api/v1/contest_participant_ascents_controller.rb:46
- Average Self
-
47ms
- Average calls
- 1x
- Total Self
- 47ms
- Total Children
- 69ms
- Total runtime
- 117ms
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.6x
- Total Self
- 11ms
- Total Children
- 0ms
- Total runtime
- 11ms
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
-
3.1ms
- Average calls
- 1x
- Total Self
- 3.1ms
- Total Children
- 117ms
- Total runtime
- 120ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/api_controller.rb:26
|
1%
|
app/controllers/api/v1/api_controller.rb:26
- Average Self
-
1.6ms
- Average calls
- 1x
- Total Self
- 1.6ms
- Total Children
- 0ms
- Total runtime
- 1.6ms
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:95
|
1%
|
app/controllers/api/v1/contest_participant_ascents_controller.rb:95
- Average Self
-
1.6ms
- Average calls
- 1x
- Total Self
- 1.6ms
- Total Children
- 0ms
- Total runtime
- 1.6ms
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/contest_participant_ascents_controller.rb:90
|
1%
|
app/controllers/api/v1/contest_participant_ascents_controller.rb:90
- Average Self
-
1.3ms
- Average calls
- 1x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
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.57ms
- Average calls
- 1x
- Total Self
- 0.57ms
- Total Children
- 0ms
- Total runtime
- 0.57ms
publish
|
|
sql
app/models/contest_service/result.rb:22
|
<1%
|
app/models/contest_service/result.rb:22
- Average Self
-
1.4ms
- Average calls
- 0.36x
- Total Self
- 0.5ms
- Total Children
- 0ms
- Total runtime
- 0.5ms
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
-
1ms
- Average calls
- 0.36x
- Total Self
- 0.36ms
- Total Children
- 0ms
- Total runtime
- 0.36ms
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 ?
|