|
code
app/controllers/api/v1/areas_controller.rb:62
|
38 ms
|
1.0
|
61 %
|
Api::V1::AreasController#show
|
|
sql
app/models/area.rb:62
|
<1 ms
|
13
|
16 %
|
SELECT `area_crags`.* FROM `area_crags` WHERE `area_crags`.`area_id` = 25
|
|
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
|
6 %
|
|
|
|
sql
app/models/area.rb:22
|
1 ms
|
2.0
|
4 %
|
SELECT `crags`.* FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_crags`.`crag_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 22:37:41.817856') AND `area_crags`.`area_id` = 21 ORDER BY `crags`.`max_grade_value` DESC LIMIT 1
|
|
sql
app/models/area.rb:26
|
1 ms
|
2.0
|
4 %
|
SELECT `crags`.* FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_crags`.`crag_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 22:37:41.813783') AND `area_crags`.`area_id` = 21 AND `crags`.`min_grade_value` IS NOT NULL ORDER BY `crags`.`min_grade_value` ASC LIMIT 1
|
|
sql
app/models/area.rb:18
|
1 ms
|
2.0
|
3 %
|
SELECT SUM(`crags`.`crag_routes_count`) FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_crags`.`crag_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 22:37:41.789111') AND `area_crags`.`area_id` = 21
|
|
sql
app/models/area.rb:60
|
2 ms
|
1.0
|
2 %
|
SELECT COUNT(*) FROM `crags` INNER JOIN `area_crags` ON `crags`.`id` = `area_crags`.`crag_id` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 22:37:41.786518') AND `area_crags`.`area_id` = 21
|
|
sql
app/controllers/api/v1/api_controller.rb:42
|
1 ms
|
1.0
|
2 %
|
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = 'M4rvBxc4M7kqqdtXPDvFEYm9' LIMIT 1
|
|
sql
app/controllers/api/v1/areas_controller.rb:131
|
<1 ms
|
1.0
|
1 %
|
SELECT `areas`.* FROM `areas` WHERE `areas`.`id` = 25 LIMIT 1
|
|
sql
app/models/area.rb:72
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `users`.* FROM `users` WHERE `users`.`id` = 236 LIMIT 1
|