|
code
app/controllers/api/v1/publications_controller.rb:80
|
43%
|
app/controllers/api/v1/publications_controller.rb:80
- Average Self
-
96ms
- Average calls
- 1x
- Total Self
- 96ms
- Total Children
- 127ms
- Total runtime
- 223ms
Api::V1::PublicationsController#my_publication_feed
|
|
sql
app/models/publication_views_mapper.rb:25
|
24%
|
app/models/publication_views_mapper.rb:25
- Average Self
-
8.1ms
- Average calls
- 6.7x
- Total Self
- 54ms
- Total Children
- 0ms
- Total runtime
- 54ms
SELECT `publications`.* FROM `publications` WHERE `publications`.`published_at` IS NOT NULL AND ((EXISTS (SELECT *
FROM follows
WHERE user_id = ?
AND accepted_at IS NOT NULL
AND followable_id = publications.publishable_id
AND followable_type = publications.publishable_type)
OR (publications.publishable_type = "User" AND publications.publishable_id = ?)
OR publications.publishable_type = "Article"
)) ORDER BY `publications`.`published_at` DESC, `publications`.`id` DESC LIMIT ? OFFSET ?
|
|
sql
app/models/video.rb:112
|
13%
|
app/models/video.rb:112
- Average Self
-
0.84ms
- Average calls
- 34x
- Total Self
- 28ms
- Total Children
- 0ms
- Total runtime
- 28ms
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:17
|
7%
|
app/controllers/api/v1/api_controller.rb:17
- Average Self
-
0.96ms
- Average calls
- 17x
- Total Self
- 16ms
- Total Children
- 0ms
- Total runtime
- 16ms
SELECT `gym_routes`.* FROM `gym_routes` WHERE `gym_routes`.`id` = ? LIMIT ?
|
|
sql
app/models/video.rb:109
|
6%
|
app/models/video.rb:109
- Average Self
-
0.82ms
- Average calls
- 17x
- Total Self
- 13ms
- Total Children
- 0ms
- Total runtime
- 13ms
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/concerns/attachment_resizable.rb:12
|
1%
|
app/models/concerns/attachment_resizable.rb:12
- Average Self
-
0.88ms
- Average calls
- 3.5x
- Total Self
- 3.1ms
- Total Children
- 0ms
- Total runtime
- 3.1ms
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
-
0.86ms
- Average calls
- 3.5x
- Total Self
- 3ms
- Total Children
- 0ms
- Total runtime
- 3ms
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 ?
|
|
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
-
1.6ms
- Average calls
- 1x
- Total Self
- 1.6ms
- Total Children
- 223ms
- Total runtime
- 225ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
<1%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.3ms
- Average calls
- 1.1x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/models/gym.rb:282
|
<1%
|
app/models/gym.rb:282
- Average Self
-
1.3ms
- Average calls
- 1x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
SELECT `gym_spaces`.* FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? ORDER BY `gym_spaces`.`order` ASC
|
|
sql
app/models/publication_views_mapper.rb:57
|
<1%
|
app/models/publication_views_mapper.rb:57
- Average Self
-
1.1ms
- Average calls
- 1x
- Total Self
- 1.1ms
- Total Children
- 0ms
- Total runtime
- 1.1ms
BEGIN
SELECT `publications`.* FROM `publications` WHERE `publications`.`id` = ? LIMIT ?
|
|
sql
app/models/publication_views_mapper.rb:29
|
<1%
|
app/models/publication_views_mapper.rb:29
- Average Self
-
0.9ms
- Average calls
- 1x
- Total Self
- 0.9ms
- Total Children
- 0ms
- Total runtime
- 0.9ms
SELECT COUNT(*) FROM `publication_views` WHERE `publication_views`.`user_id` = ? AND `publication_views`.`publication_id` IN (?)
|
|
sql
app/models/gym.rb:293
|
<1%
|
app/models/gym.rb:293
- Average Self
-
0.85ms
- Average calls
- 1x
- Total Self
- 0.85ms
- Total Children
- 0ms
- Total runtime
- 0.85ms
SELECT COUNT(*) FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ?
|
|
sql
app/models/gym.rb:295
|
<1%
|
app/models/gym.rb:295
- Average Self
-
0.92ms
- Average calls
- 0.6x
- Total Self
- 0.55ms
- Total Children
- 0ms
- Total runtime
- 0.55ms
SELECT `gym_spaces`.* FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? ORDER BY `gym_spaces`.`order` ASC LIMIT ?
|
|
sql
app/models/publication_views_mapper.rb:34
|
<1%
|
app/models/publication_views_mapper.rb:34
- Average Self
-
0.92ms
- Average calls
- 0.6x
- Total Self
- 0.55ms
- Total Children
- 0ms
- Total runtime
- 0.55ms
SELECT `publication_views`.* FROM `publication_views` WHERE `publication_views`.`user_id` = ? AND `publication_views`.`publication_id` = ?
|
|
sql
app/models/publication_views_mapper.rb:64
|
<1%
|
app/models/publication_views_mapper.rb:64
- Average Self
-
0.8ms
- Average calls
- 0.5x
- Total Self
- 0.4ms
- Total Children
- 0ms
- Total runtime
- 0.4ms
SELECT `notifications`.* FROM `notifications` WHERE `notifications`.`notification_type` = ? AND `notifications`.`notifiable_type` = ? AND `notifications`.`notifiable_id` IN (?) AND `notifications`.`user_id` = ? ORDER BY `notifications`.`posted_at` DESC
|
|
sql
app/models/gym_space.rb:118
|
<1%
|
app/models/gym_space.rb:118
- Average Self
-
1ms
- Average calls
- 0.1x
- Total Self
- 0.1ms
- Total Children
- 0ms
- Total runtime
- 0.1ms
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_space.rb:48
|
<1%
|
app/models/gym_space.rb:48
- Average Self
-
1ms
- Average calls
- 0.1x
- Total Self
- 0.1ms
- Total Children
- 0ms
- Total runtime
- 0.1ms
SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` = ? LIMIT ?
|
|
sql
app/models/gym_route.rb:102
|
<1%
|
app/models/gym_route.rb:102
- Average Self
-
1ms
- Average calls
- 0.1x
- Total Self
- 0.1ms
- Total Children
- 0ms
- Total runtime
- 0.1ms
SELECT `gym_levels`.* FROM `gym_levels` WHERE `gym_levels`.`gym_id` = ?
|
|
sql
app/serializers/contest_serializer.rb:51
|
<1%
|
app/serializers/contest_serializer.rb:51
- Average Self
-
1ms
- Average calls
- 0.05x
- Total Self
- 0.05ms
- Total Children
- 0ms
- Total runtime
- 0.05ms
SELECT `ffme_contests`.* FROM `ffme_contests` WHERE `ffme_contests`.`contest_id` = ? LIMIT ?
|
|
sql
app/serializers/contest_serializer.rb:47
|
<1%
|
app/serializers/contest_serializer.rb:47
- Average Self
-
0ms
- Average calls
- 0.05x
- 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` = ?
|