|
sql
app/controllers/api/v1/commons_controller.rb:48
|
35%
|
app/controllers/api/v1/commons_controller.rb:48
- Average Self
-
178ms
- Average calls
- 0.12x
- Total Self
- 21ms
- Total Children
- 0ms
- Total runtime
- 21ms
SELECT COUNT(*), gym_id
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 gym_routes.dismounted_at IS NULL
AND gym_routes.opened_at > CURRENT_DATE - INTERVAL ? YEAR
GROUP BY gym_id
HAVING COUNT(*) > ?
|
|
sql
app/controllers/api/v1/commons_controller.rb:40
|
32%
|
app/controllers/api/v1/commons_controller.rb:40
- Average Self
-
148ms
- Average calls
- 0.13x
- Total Self
- 19ms
- Total Children
- 0ms
- Total runtime
- 19ms
SELECT COUNT(*) FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?)
|
|
sql
app/controllers/api/v1/commons_controller.rb:37
|
12%
|
app/controllers/api/v1/commons_controller.rb:37
- Average Self
-
14ms
- Average calls
- 0.52x
- Total Self
- 7.6ms
- Total Children
- 0ms
- Total runtime
- 7.6ms
SET NAMES utf8mb4, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ?), ?), @@SESSION.sql_auto_is_null = ?, @@SESSION.wait_timeout = ?
|
|
code
app/controllers/api/v1/commons_controller.rb:34
|
11%
|
app/controllers/api/v1/commons_controller.rb:34
- Average Self
-
7ms
- Average calls
- 1x
- Total Self
- 7ms
- Total Children
- 51ms
- Total runtime
- 58ms
Api::V1::CommonsController#micro_stats
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
4%
|
/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
- 58ms
- Total runtime
- 61ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/commons_controller.rb:39
|
4%
|
app/controllers/api/v1/commons_controller.rb:39
- Average Self
-
5.9ms
- Average calls
- 0.4x
- Total Self
- 2.4ms
- Total Children
- 0ms
- Total runtime
- 2.4ms
SELECT COUNT(*) FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?)
|
|
sql
app/controllers/api/v1/commons_controller.rb:38
|
1%
|
app/controllers/api/v1/commons_controller.rb:38
- Average Self
-
2.6ms
- Average calls
- 0.3x
- Total Self
- 0.78ms
- Total Children
- 0ms
- Total runtime
- 0.78ms
SELECT COUNT(*) FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?)
|
|
sql
app/controllers/api/v1/commons_controller.rb:41
|
<1%
|
app/controllers/api/v1/commons_controller.rb:41
- Average Self
-
2.9ms
- Average calls
- 0.02x
- Total Self
- 0.05ms
- Total Children
- 0ms
- Total runtime
- 0.05ms
SELECT COUNT(*) FROM `guide_book_papers`
|
|
sql
app/controllers/api/v1/api_controller.rb:50
|
<1%
|
app/controllers/api/v1/api_controller.rb:50
- Average Self
-
2ms
- Average calls
- <0.01x
- Total Self
- <0.01ms
- Total Children
- 0ms
- Total runtime
- <0.01ms
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = ? LIMIT ?
|