|
code
app/controllers/api/v1/ascent_crag_routes_controller.rb:30
|
109 ms
|
1.0
|
59 %
|
Api::V1::AscentCragRoutesController#create
|
|
sql
app/models/search.rb:48
|
2 ms
|
6.3
|
7 %
|
INSERT INTO `searches` (`index_name`, `index_id`, `collection`, `bucket`, `secondary_bucket`) VALUES ('experience-verticale', 36199, 'CragRoute', 'CragRoute_in_Crag_1230', 'CragRoute_in_CragSector_2514')
|
|
sql
app/controllers/api/v1/ascent_crag_routes_controller.rb:33
|
3 ms
|
4.0
|
6 %
|
INSERT INTO `ascents` (`type`, `ascent_status`, `roping_status`, `attempt`, `user_id`, `crag_route_id`, `sections`, `climbing_type`, `sections_count`, `max_grade_value`, `min_grade_value`, `max_grade_text`, `min_grade_text`, `released_at`, `created_at`, `updated_at`, `private_comment`) VALUES ('AscentCragRoute', 'onsight', 'lead_climb', 1, 4170, 36199, '[{\"index\":0,\"height\":null,\"grade\":\"4a\",\"grade_value\":19}]', 'sport_climbing', 1, 19, 19, '4a', '4a', '2022-06-29', '2022-06-29 20:38:40.243925', '2022-06-29 20:38:40.243925', FALSE)
|
|
sql
app/models/search.rb:43
|
1 ms
|
7.0
|
4 %
|
SELECT `searches`.* FROM `searches` WHERE `searches`.`index_name` = 'experience-verticale' AND `searches`.`index_id` = 36199 AND `searches`.`collection` = 'CragRoute' AND `searches`.`bucket` = 'CragRoute_in_Crag_1230' AND `searches`.`secondary_bucket` = 'CragRoute_in_CragSector_2514' LIMIT 1
|
|
sql
app/models/search.rb:59
|
2 ms
|
4.0
|
4 %
|
DELETE FROM `searches` WHERE `searches`.`collection` = 'CragRoute' AND `searches`.`index_id` = 36199
|
|
sql
app/models/ascent_crag_route.rb:167
|
6 ms
|
1.0
|
3 %
|
SELECT `tick_lists`.* FROM `tick_lists` WHERE `tick_lists`.`crag_route_id` = 36199 AND `tick_lists`.`user_id` = 4170 LIMIT 1
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
5 ms
|
1.0
|
3 %
|
|
|
|
sql
app/models/concerns/gap_gradable.rb:10
|
2 ms
|
2.0
|
2 %
|
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 20:38:40.339321') AND `crag_routes`.`crag_id` = 1230 ORDER BY `crag_routes`.`max_grade_value` DESC LIMIT 1
|
|
redis
app/models/concerns/activity_feedable.rb:19
|
<1 ms
|
4.0
|
2 %
|
|
|
|
sql
app/models/user.rb:119
|
3 ms
|
1.0
|
1 %
|
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`user_id` = 2553
|
|
sql
app/models/crag_route.rb:134
|
2 ms
|
1.3
|
1 %
|
UPDATE `crag_routes` SET `crag_routes`.`ascents_count` = 3, `crag_routes`.`updated_at` = '2022-06-29 20:38:40.298583' WHERE `crag_routes`.`id` = 36199
|
|
sql
app/models/crag_route.rb:142
|
1 ms
|
1.8
|
1 %
|
SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > '2022-06-29 20:38:40.288577') AND `crag_sectors`.`id` = 2514 LIMIT 1
|
|
sql
app/models/concerns/gap_gradable.rb:11
|
<1 ms
|
2.0
|
<1 %
|
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 20:38:40.343574') AND `crag_routes`.`crag_id` = 1230 ORDER BY `crag_routes`.`min_grade_value` ASC LIMIT 1
|
|
sql
app/models/ascent_crag_route.rb:127
|
<1 ms
|
2.0
|
<1 %
|
BEGIN
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 20:38:40.237759') AND `crag_routes`.`id` = 36199 LIMIT 1
|
|
sql
app/models/crag.rb:118
|
2 ms
|
1.0
|
<1 %
|
SELECT DISTINCT `crag_routes`.`climbing_type` FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-29 20:38:40.363749') AND `crag_routes`.`crag_id` = 1230
|
|
sql
app/controllers/api/v1/api_controller.rb:42
|
2 ms
|
1.0
|
<1 %
|
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = 'M4rvBxc4M7kqqdtXPDvFEYm9' LIMIT 1
|
|
sql
app/controllers/api/v1/api_controller.rb:20
|
1 ms
|
1.0
|
<1 %
|
SELECT `ip_black_lists`.* FROM `ip_black_lists` WHERE (block_expired_at <= NOW() OR block_expired_at IS NULL) AND `ip_black_lists`.`ip` = '92.151.206.126' LIMIT 1
|
|
sql
app/controllers/api/v1/api_controller.rb:55
|
<1 ms
|
1.0
|
<1 %
|
SELECT `users`.* FROM `users` WHERE `users`.`id` = 4170 LIMIT 1
|
|
sql
app/models/crag_route.rb:98
|
<1 ms
|
1.0
|
<1 %
|
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`crag_route_id` = 36199
|
|
sql
app/models/crag_sector.rb:155
|
<1 ms
|
0.8
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 20:38:40.386984') AND `crags`.`id` = 1230 LIMIT 1
|
|
sql
app/models/ascent_crag_route.rb:168
|
<1 ms
|
0.3
|
<1 %
|
DELETE FROM `tick_lists` WHERE `tick_lists`.`id` = 1952
|
|
sql
app/models/concerns/gap_gradable.rb:17
|
<1 ms
|
0.3
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 06:39:42.706858') AND `crags`.`id` = 236 LIMIT 1
|