|
code
app/controllers/api/v1/commons_controller.rb:75
|
47%
|
app/controllers/api/v1/commons_controller.rb:75
- Average Self
-
291ms
- Average calls
- 1x
- Total Self
- 291ms
- Total Children
- 327ms
- Total runtime
- 618ms
Api::V1::CommonsController#active_gyms
|
|
sql
app/controllers/api/v1/commons_controller.rb:93
|
26%
|
app/controllers/api/v1/commons_controller.rb:93
- Average Self
-
1.1ms
- Average calls
- 144x
- Total Self
- 162ms
- Total Children
- 0ms
- Total runtime
- 162ms
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
-
120ms
- Average calls
- 1x
- Total Self
- 120ms
- Total Children
- 0ms
- Total runtime
- 120ms
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/concerns/attachment_resizable.rb:10
|
2%
|
app/models/concerns/attachment_resizable.rb:10
- Average Self
-
1.1ms
- Average calls
- 11x
- Total Self
- 12ms
- Total Children
- 0ms
- Total runtime
- 12ms
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.85ms
- Average calls
- 11x
- Total Self
- 9.7ms
- Total Children
- 0ms
- Total runtime
- 9.7ms
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.7x
- Total Self
- 6.7ms
- Total Children
- 0ms
- Total runtime
- 6.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:282
|
<1%
|
app/models/gym.rb:282
- Average Self
-
1ms
- Average calls
- 5.7x
- Total Self
- 5.7ms
- Total Children
- 0ms
- Total runtime
- 5.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
|
|
sql
app/models/gym.rb:180
|
<1%
|
app/models/gym.rb:180
- Average Self
-
0.94ms
- Average calls
- 5.7x
- Total Self
- 5.3ms
- Total Children
- 0ms
- Total runtime
- 5.3ms
SELECT `gym_options`.* FROM `gym_options` WHERE `gym_options`.`gym_id` = ?
|
|
sql
app/models/gym.rb:293
|
<1%
|
app/models/gym.rb:293
- Average Self
-
0.88ms
- Average calls
- 5.7x
- Total Self
- 5ms
- Total Children
- 0ms
- Total runtime
- 5ms
SELECT COUNT(*) FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`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.7ms
- Average calls
- 1x
- Total Self
- 2.7ms
- Total Children
- 618ms
- Total runtime
- 621ms
Rails::Engine#call
|