|
code
app/controllers/api/v1/commons_controller.rb:75
|
46%
|
app/controllers/api/v1/commons_controller.rb:75
- Average Self
-
275ms
- Average calls
- 1x
- Total Self
- 275ms
- Total Children
- 319ms
- Total runtime
- 594ms
Api::V1::CommonsController#active_gyms
|
|
sql
app/controllers/api/v1/commons_controller.rb:93
|
27%
|
app/controllers/api/v1/commons_controller.rb:93
- Average Self
-
1.1ms
- Average calls
- 144x
- Total Self
- 160ms
- Total Children
- 0ms
- Total runtime
- 160ms
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
|
19%
|
app/controllers/api/v1/commons_controller.rb:77
- Average Self
-
111ms
- Average calls
- 1x
- Total Self
- 111ms
- Total Children
- 0ms
- Total runtime
- 111ms
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.9ms
- Average calls
- 5.4x
- Total Self
- 15ms
- Total Children
- 0ms
- Total runtime
- 15ms
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
- 10x
- Total Self
- 9.2ms
- Total Children
- 0ms
- Total runtime
- 9.2ms
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.73ms
- Average calls
- 10x
- Total Self
- 7.6ms
- Total Children
- 0ms
- Total runtime
- 7.6ms
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
-
1.1ms
- Average calls
- 5.2x
- Total Self
- 5.6ms
- Total Children
- 0ms
- Total runtime
- 5.6ms
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.89ms
- Average calls
- 5.4x
- Total Self
- 4.8ms
- Total Children
- 0ms
- Total runtime
- 4.8ms
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.78ms
- Average calls
- 5.4x
- Total Self
- 4.2ms
- Total Children
- 0ms
- Total runtime
- 4.2ms
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
- 594ms
- Total runtime
- 597ms
Rails::Engine#call
|