|
code
app/controllers/api/v1/commons_controller.rb:75
|
47%
|
app/controllers/api/v1/commons_controller.rb:75
- Average Self
-
287ms
- Average calls
- 1x
- Total Self
- 287ms
- Total Children
- 318ms
- Total runtime
- 605ms
Api::V1::CommonsController#active_gyms
|
|
sql
app/controllers/api/v1/commons_controller.rb:93
|
25%
|
app/controllers/api/v1/commons_controller.rb:93
- Average Self
-
1.1ms
- Average calls
- 144x
- Total Self
- 154ms
- Total Children
- 0ms
- Total runtime
- 154ms
SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` IN (?) AND `gyms`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/commons_controller.rb:77
|
18%
|
app/controllers/api/v1/commons_controller.rb:77
- Average Self
-
108ms
- Average calls
- 1x
- Total Self
- 108ms
- Total Children
- 0ms
- Total runtime
- 108ms
SELECT gyms.id,
COUNT(gym_routes.id),
MAX(opened_at)
FROM gyms
INNER JOIN gym_spaces ON gyms.id = gym_spaces.gym_id
INNER JOIN gym_sectors ON gym_spaces.id = gym_sectors.gym_space_id
INNER JOIN gym_routes ON gym_sectors.id = gym_routes.gym_sector_id
WHERE dismounted_at IS NULL
AND opened_at > CURRENT_DATE - INTERVAL ? YEAR
GROUP BY gyms.id
HAVING COUNT(gym_routes.id) >= ?
ORDER BY ? DESC
|
|
sql
app/models/gym.rb:282
|
3%
|
app/models/gym.rb:282
- Average Self
-
2.5ms
- Average calls
- 6.6x
- Total Self
- 16ms
- Total Children
- 0ms
- Total runtime
- 16ms
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/concerns/attachment_resizable.rb:10
|
2%
|
app/models/concerns/attachment_resizable.rb:10
- Average Self
-
0.85ms
- Average calls
- 13x
- Total Self
- 11ms
- Total Children
- 0ms
- Total runtime
- 11ms
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
|
2%
|
app/models/concerns/attachment_resizable.rb:12
- Average Self
-
0.8ms
- Average calls
- 12x
- Total Self
- 10ms
- Total Children
- 0ms
- Total runtime
- 10ms
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
|
|
sql
app/models/gym.rb:295
|
1%
|
app/models/gym.rb:295
- Average Self
-
1ms
- Average calls
- 6.8x
- Total Self
- 7ms
- Total Children
- 0ms
- Total runtime
- 7ms
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/gym.rb:293
|
<1%
|
app/models/gym.rb:293
- Average Self
-
0.91ms
- Average calls
- 6.6x
- Total Self
- 6ms
- Total Children
- 0ms
- Total runtime
- 6ms
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:180
|
<1%
|
app/models/gym.rb:180
- Average Self
-
0.82ms
- Average calls
- 6.6x
- Total Self
- 5.4ms
- Total Children
- 0ms
- Total runtime
- 5.4ms
SELECT `gym_options`.* FROM `gym_options` WHERE `gym_options`.`gym_id` = ?
|
|
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
-
2.6ms
- Average calls
- 1x
- Total Self
- 2.6ms
- Total Children
- 605ms
- Total runtime
- 608ms
Rails::Engine#call
|