|
code
app/controllers/api/v1/departments_controller.rb:25
|
105 ms
|
1.0
|
63 %
|
Api::V1::DepartmentsController#show
|
|
sql
app/models/department.rb:37
|
14 ms
|
1.0
|
8 %
|
SELECT `crag_routes`.* FROM `crag_routes` INNER JOIN `crags` ON `crag_routes`.`crag_id` = `crags`.`id` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-30 00:25:48.132511') AND (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.132880') AND `crags`.`department_id` = 36 AND `crag_routes`.`climbing_type` = 'sport_climbing' ORDER BY `crag_routes`.`max_grade_value` DESC LIMIT 1
|
|
sql
app/models/department.rb:38
|
8 ms
|
1.0
|
5 %
|
SELECT `crag_routes`.* FROM `crag_routes` INNER JOIN `crags` ON `crag_routes`.`crag_id` = `crags`.`id` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-30 00:25:48.141950') AND (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.142284') AND `crags`.`department_id` = 36 AND `crag_routes`.`climbing_type` = 'bouldering' ORDER BY `crag_routes`.`max_grade_value` DESC LIMIT 1
|
|
sql
app/models/department.rb:28
|
3 ms
|
2.6
|
4 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.116587') AND `crags`.`department_id` = 36 ORDER BY `crags`.`id` ASC LIMIT 1000
|
|
sql
app/models/department.rb:42
|
6 ms
|
1.0
|
4 %
|
SELECT `towns`.* FROM `towns` WHERE `towns`.`department_id` = 19 ORDER BY `towns`.`name` ASC
|
|
sql
app/controllers/api/v1/departments_controller.rb:74
|
5 ms
|
1.0
|
3 %
|
SELECT `departments`.* FROM `departments` WHERE `departments`.`country_id` = 1 AND `departments`.`department_number` = '19' LIMIT 1
|
|
sql
app/models/department.rb:61
|
5 ms
|
1.0
|
3 %
|
SELECT COUNT(*) FROM `crag_routes` INNER JOIN `crags` ON `crag_routes`.`crag_id` = `crags`.`id` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > '2022-06-30 00:25:48.188078') AND (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.188420') AND `crags`.`department_id` = 36
|
|
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
|
2 %
|
|
|
|
sql
app/models/department.rb:47
|
2 ms
|
1.0
|
1 %
|
SELECT COUNT(*) FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.177043') AND `crags`.`department_id` = 36
|
|
sql
app/models/department.rb:43
|
2 ms
|
1.0
|
<1 %
|
SELECT `guide_book_papers`.* FROM `guide_book_papers` WHERE `guide_book_papers`.`id` IN (86, 290) ORDER BY `guide_book_papers`.`publication_year` DESC
|
|
sql
app/models/department.rb:50
|
1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.180052') AND `crags`.`department_id` = 36 AND `crags`.`bouldering` = TRUE
|
|
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
|
|
sql
app/models/department.rb:49
|
1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.178583') AND `crags`.`department_id` = 36 AND `crags`.`sport_climbing` = TRUE
|
|
sql
app/controllers/api/v1/departments_controller.rb:70
|
<1 ms
|
1.0
|
<1 %
|
SELECT `countries`.* FROM `countries` WHERE `countries`.`code_country` = 'fr' LIMIT 1
|
|
sql
app/models/department.rb:68
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > '2022-06-30 00:25:48.192010') AND `gyms`.`department_id` = 36
|
|
sql
app/models/department.rb:52
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.182653') AND `crags`.`department_id` = 36 AND `crags`.`trad_climbing` = TRUE
|
|
sql
app/models/department.rb:53
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.183985') AND `crags`.`department_id` = 36 AND `crags`.`aid_climbing` = TRUE
|
|
sql
app/models/department.rb:55
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.186664') AND `crags`.`department_id` = 36 AND `crags`.`via_ferrata` = TRUE
|
|
sql
app/models/department.rb:54
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.185352') AND `crags`.`department_id` = 36 AND `crags`.`deep_water` = TRUE
|
|
sql
app/models/department.rb:51
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 00:25:48.181365') AND `crags`.`department_id` = 36 AND `crags`.`multi_pitch` = TRUE
|
|
sql
app/models/crag_route.rb:176
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > '2022-06-29 04:11:07.433911') AND `crag_sectors`.`id` = 2011 LIMIT 1
|
|
sql
app/models/crag_route.rb:177
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-29 04:11:07.436414') AND `crags`.`id` = 1065 LIMIT 1
|