|
sql
app/models/crag_route.rb:98
|
409 ms
|
1.0
|
72 %
|
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`crag_route_id` = 27665
|
|
code
app/controllers/api/v1/ascent_crag_routes_controller.rb:55
|
108 ms
|
1.0
|
19 %
|
Api::V1::AscentCragRoutesController#update
|
|
sql
app/models/search.rb:43
|
<1 ms
|
7.0
|
1 %
|
SELECT `searches`.* FROM `searches` WHERE `searches`.`index_name` = 'drole-soiree' AND `searches`.`index_id` = 27665 AND `searches`.`collection` = 'CragRoute' AND `searches`.`bucket` = 'CragRoute_in_Crag_1084' AND `searches`.`secondary_bucket` = 'CragRoute_in_CragSector_2108' LIMIT 1
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
4 ms
|
1.0
|
<1 %
|
|
|
|
sql
app/models/concerns/gap_gradable.rb:10
|
2 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 07:11:26.009504') AND `crag_routes`.`crag_id` = 1084 ORDER BY `crag_routes`.`max_grade_value` DESC LIMIT 1
|
|
sql
app/models/search.rb:59
|
<1 ms
|
4.0
|
<1 %
|
DELETE FROM `searches` WHERE `searches`.`collection` = 'CragRoute' AND `searches`.`index_id` = 27665
|
|
sql
app/models/search.rb:48
|
<1 ms
|
4.0
|
<1 %
|
INSERT INTO `searches` (`index_name`, `index_id`, `collection`, `bucket`, `secondary_bucket`) VALUES ('drole-soiree', 27665, 'CragRoute', 'CragRoute_in_Crag_1084', 'CragRoute_in_CragSector_2108')
|
|
sql
app/controllers/api/v1/ascent_crag_routes_controller.rb:56
|
<1 ms
|
5.0
|
<1 %
|
SELECT `users`.* FROM `users` WHERE `users`.`id` = 3298 LIMIT 1
|
|
redis
app/models/concerns/activity_feedable.rb:19
|
<1 ms
|
4.0
|
<1 %
|
|
|
|
sql
app/models/user.rb:119
|
3 ms
|
1.0
|
<1 %
|
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`user_id` = 3298
|
|
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 07:11:26.013678') AND `crag_routes`.`crag_id` = 1084 ORDER BY `crag_routes`.`min_grade_value` ASC LIMIT 1
|
|
sql
app/controllers/api/v1/api_controller.rb:20
|
2 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` = '109.18.80.222' LIMIT 1
|
|
sql
app/models/crag_route.rb:134
|
2 ms
|
1.0
|
<1 %
|
UPDATE `crag_routes` SET `crag_routes`.`ascents_count` = 1, `crag_routes`.`updated_at` = '2022-06-29 07:11:25.994184' WHERE `crag_routes`.`id` = 27665
|
|
sql
app/models/crag_route.rb:142
|
<1 ms
|
2.0
|
<1 %
|
SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > '2022-06-29 07:11:25.986010') AND `crag_sectors`.`id` = 2108 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 07:11:25.548469') AND `crag_routes`.`id` = 27665 LIMIT 1
|
|
sql
app/controllers/api/v1/ascent_crag_routes_controller.rb:74
|
2 ms
|
1.0
|
<1 %
|
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`id` = 32147 LIMIT 1
|
|
sql
app/models/crag_sector.rb:155
|
<1 ms
|
1.0
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 07:11:26.042791') AND `crags`.`id` = 1084 LIMIT 1
|
|
sql
app/models/crag.rb:118
|
<1 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 07:11:26.025740') AND `crag_routes`.`crag_id` = 1084
|
|
sql
app/controllers/api/v1/api_controller.rb:55
|
<1 ms
|
1.0
|
<1 %
|
SELECT `users`.* FROM `users` WHERE `users`.`id` = 3298 LIMIT 1
|
|
sql
app/controllers/api/v1/api_controller.rb:42
|
<1 ms
|
1.0
|
<1 %
|
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = 'M4rvBxc4M7kqqdtXPDvFEYm9' LIMIT 1
|