|
code
app/controllers/api/v1/ascent_crag_routes_controller.rb:63
|
58%
|
app/controllers/api/v1/ascent_crag_routes_controller.rb:63
- Average Self
-
53ms
- Calls
- 1x
- Total Self
- 53ms
- Total Children
- 36ms
- Total runtime
- 89ms
Api::V1::AscentCragRoutesController#destroy
|
|
sql
app/models/user.rb:148
|
5%
|
app/models/user.rb:148
- Average Self
-
5ms
- Calls
- 1x
- Total Self
- 5ms
- Total Children
- 0ms
- Total runtime
- 5ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`user_id` = ?
|
|
sql
app/controllers/api/v1/ascent_crag_routes_controller.rb:64
|
3%
|
app/controllers/api/v1/ascent_crag_routes_controller.rb:64
- Average Self
-
1ms
- Calls
- 3x
- Total Self
- 3ms
- Total Children
- 0ms
- Total runtime
- 3ms
DELETE FROM `ascents` WHERE `ascents`.`id` = ?
|
|
sql
app/models/crag_sector.rb:149
|
2%
|
app/models/crag_sector.rb:149
- Average Self
-
2ms
- Calls
- 1x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT COUNT(*) AS count FROM `ascents` INNER JOIN `crag_routes` ON `crag_routes`.`id` = `ascents`.`crag_route_id` AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) WHERE `ascents`.`type` = ? AND `crag_routes`.`crag_sector_id` = ? AND `ascents`.`ascent_status` IN (?) LIMIT ?
|
|
sql
app/models/concerns/gap_gradable.rb:10
|
2%
|
app/models/concerns/gap_gradable.rb:10
- Average Self
-
1ms
- Calls
- 2x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`crag_id` = ? AND (crag_routes.max_grade_value > ?) ORDER BY `crag_routes`.`max_grade_value` DESC LIMIT ?
|
|
sql
app/models/concerns/gap_gradable.rb:11
|
2%
|
app/models/concerns/gap_gradable.rb:11
- Average Self
-
1ms
- Calls
- 2x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`crag_id` = ? AND (crag_routes.min_grade_value > ?) ORDER BY `crag_routes`.`min_grade_value` ASC LIMIT ?
|
|
sql
app/models/crag.rb:301
|
2%
|
app/models/crag.rb:301
- Average Self
-
2ms
- Calls
- 1x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT COUNT(DISTINCT ascents.user_id) AS count FROM `ascents` INNER JOIN `crag_routes` ON `crag_routes`.`id` = `ascents`.`crag_route_id` AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) WHERE `ascents`.`type` = ? AND `crag_routes`.`crag_id` = ? AND `ascents`.`ascent_status` IN (?) LIMIT ?
|
|
sql
app/models/crag.rb:307
|
2%
|
app/models/crag.rb:307
- Average Self
-
2ms
- Calls
- 1x
- Total Self
- 2ms
- Total Children
- 0ms
- Total runtime
- 2ms
SELECT COUNT(*) AS count FROM `ascents` INNER JOIN `crag_routes` ON `crag_routes`.`id` = `ascents`.`crag_route_id` AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) WHERE `ascents`.`type` = ? AND `crag_routes`.`crag_id` = ? AND `ascents`.`ascent_status` IN (?) LIMIT ?
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
2%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
2ms
- Calls
- 1x
- Total Self
- 2ms
- Total Children
- 89ms
- Total runtime
- 91ms
Rails::Engine#call
|
|
sql
app/models/crag.rb:311
|
1%
|
app/models/crag.rb:311
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
UPDATE `crags` SET `crags`.`ascents_count` = ?, `crags`.`updated_at` = ? WHERE `crags`.`id` = ?
|
|
sql
app/models/crag_sector.rb:143
|
1%
|
app/models/crag_sector.rb:143
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT COUNT(DISTINCT ascents.user_id) AS count FROM `ascents` INNER JOIN `crag_routes` ON `crag_routes`.`id` = `ascents`.`crag_route_id` AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) WHERE `ascents`.`type` = ? AND `crag_routes`.`crag_sector_id` = ? AND `ascents`.`ascent_status` IN (?) LIMIT ?
|
|
sql
app/models/crag_sector.rb:153
|
1%
|
app/models/crag_sector.rb:153
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
UPDATE `crag_sectors` SET `crag_sectors`.`ascents_count` = ?, `crag_sectors`.`updated_at` = ? WHERE `crag_sectors`.`id` = ?
|
|
sql
app/models/crag_sector.rb:162
|
1%
|
app/models/crag_sector.rb:162
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`id` = ? LIMIT ?
|
|
sql
app/models/ascent_crag_route.rb:171
|
1%
|
app/models/ascent_crag_route.rb:171
- Average Self
-
0.33ms
- Calls
- 3x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
BEGIN
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`id` = ? LIMIT ?
|
|
sql
app/models/ascent_crag_route.rb:172
|
1%
|
app/models/ascent_crag_route.rb:172
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `crags`.* FROM `crags` INNER JOIN `crag_routes` ON `crags`.`id` = `crag_routes`.`crag_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/ascent_crag_routes_controller.rb:74
|
1%
|
app/controllers/api/v1/ascent_crag_routes_controller.rb:74
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`id` = ? LIMIT ?
|
|
sql
app/models/climbing_session.rb:133
|
1%
|
app/models/climbing_session.rb:133
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT COUNT(*) FROM `ascents` WHERE `ascents`.`climbing_session_id` = ?
|
|
sql
app/models/climbing_session.rb:135
|
1%
|
app/models/climbing_session.rb:135
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
DELETE FROM `climbing_sessions` WHERE `climbing_sessions`.`id` = ?
|
|
sql
app/models/ascent.rb:66
|
1%
|
app/models/ascent.rb:66
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `climbing_sessions`.* FROM `climbing_sessions` WHERE `climbing_sessions`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:26
|
1%
|
app/controllers/api/v1/api_controller.rb:26
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `ip_black_lists`.* FROM `ip_black_lists` WHERE (block_expired_at <= NOW() OR block_expired_at IS NULL) AND `ip_black_lists`.`ip` IS NULL LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
1%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/models/crag_route.rb:100
|
1%
|
app/models/crag_route.rb:100
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`crag_route_id` = ?
|
|
sql
app/models/crag_route.rb:135
|
1%
|
app/models/crag_route.rb:135
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT COUNT(DISTINCT ascents.user_id) AS count FROM `ascents` WHERE `ascents`.`type` = ? AND `ascents`.`crag_route_id` = ? AND `ascents`.`ascent_status` IN (?) LIMIT ?
|
|
sql
app/models/crag_route.rb:143
|
1%
|
app/models/crag_route.rb:143
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT COUNT(*) FROM `comments` WHERE `comments`.`commentable_id` = ? AND `comments`.`commentable_type` = ?
|
|
sql
app/models/crag_route.rb:144
|
1%
|
app/models/crag_route.rb:144
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
UPDATE `crag_routes` SET `crag_routes`.`ascents_count` = ?, `crag_routes`.`ascent_users_count` = ?, `crag_routes`.`updated_at` = ? WHERE `crag_routes`.`id` = ?
|
|
sql
app/models/crag_route.rb:163
|
1%
|
app/models/crag_route.rb:163
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`id` = ? LIMIT ?
|
|
sql
app/models/crag.rb:123
|
1%
|
app/models/crag.rb:123
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT DISTINCT `crag_routes`.`climbing_type` FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`crag_id` = ?
|