sql
app/models/town.rb:59
|
188 ms
|
1.0
|
28 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 01:53:52.188776') ORDER BY getRange(crags.latitude, crags.longitude, 48.583302 , 7.63333) LIMIT 1
|
sql
app/models/town.rb:71
|
111 ms
|
1.3
|
21 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 01:53:52.410111') AND (getRange(latitude, longitude, 48.583302, 7.63333) < 10000) ORDER BY getRange(latitude, longitude, 48.583302 , 7.63333)
|
sql
app/models/town.rb:30
|
108 ms
|
1.3
|
21 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 01:53:52.555311') AND (getRange(latitude, longitude, 48.583302, 7.63333) < 10000) ORDER BY getRange(latitude, longitude, 48.583302 , 7.63333)
|
sql
app/models/town.rb:100
|
114 ms
|
1.0
|
17 %
|
SELECT `guide_book_papers`.`id` AS t0_r0, `guide_book_papers`.`name` AS t0_r1, `guide_book_papers`.`author` AS t0_r2, `guide_book_papers`.`editor` AS t0_r3, `guide_book_papers`.`publication_year` AS t0_r4, `guide_book_papers`.`price_cents` AS t0_r5, `guide_book_papers`.`ean` AS t0_r6, `guide_book_papers`.`vc_reference` AS t0_r7, `guide_book_papers`.`number_of_page` AS t0_r8, `guide_book_papers`.`weight` AS t0_r9, `guide_book_papers`.`user_id` AS t0_r10, `guide_book_papers`.`legacy_id` AS t0_r11, `guide_book_papers`.`created_at` AS t0_r12, `guide_book_papers`.`updated_at` AS t0_r13, `guide_book_papers`.`slug_name` AS t0_r14, `guide_book_papers`.`follows_count` AS t0_r15, `guide_book_papers`.`articles_count` AS t0_r16, `guide_book_papers`.`comments_count` AS t0_r17, `guide_book_papers`.`funding_status` AS t0_r18, `guide_book_papers`.`next_guide_book_paper_id` AS t0_r19, `guide_book_paper_crags`.`id` AS t1_r0, `guide_book_paper_crags`.`crag_id` AS t1_r1, `guide_book_paper_crags`.`guide_bo [TRUNCATED]
|
code
app/controllers/api/v1/towns_controller.rb:22
|
52 ms
|
1.0
|
8 %
|
Api::V1::TownsController#show
|
sql
app/models/town.rb:60
|
17 ms
|
1.0
|
3 %
|
SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > '2022-06-30 01:53:52.378461') ORDER BY getRange(gyms.latitude, gyms.longitude, 48.583302 , 7.63333) LIMIT 1
|
sql
app/models/town.rb:98
|
13 ms
|
1.0
|
2 %
|
SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > '2022-06-30 01:53:52.411008') AND (getRange(latitude, longitude, 48.583302, 7.63333) < 10000) ORDER BY getRange(latitude, longitude, 48.583302 , 7.63333)
|
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/town.rb:52
|
5 ms
|
0.6
|
<1 %
|
SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = 102 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
|
sql
app/controllers/api/v1/towns_controller.rb:56
|
1 ms
|
1.0
|
<1 %
|
SELECT `towns`.* FROM `towns` WHERE `towns`.`slug_name` = 'oberschaeffolsheim' LIMIT 1
|
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-30 01:50:33.244167') AND `crag_sectors`.`id` = 5543 LIMIT 1
|
sql
app/models/crag_sector.rb:124
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > '2022-06-30 01:50:33.247392') AND `crags`.`id` = 1838 LIMIT 1
|
sql
app/models/concerns/attachment_resizable.rb:9
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = 4046 LIMIT 1
|
sql
app/models/concerns/attachment_resizable.rb:7
|
1 ms
|
<0.1
|
<1 %
|
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = 1364 AND `active_storage_attachments`.`record_type` = 'Photo' AND `active_storage_attachments`.`name` = 'picture' LIMIT 1
|
sql
app/models/crag.rb:167
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = 1364 LIMIT 1
|
sql
app/models/gym.rb:144
|
2 ms
|
<0.1
|
<1 %
|
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = 231 AND `active_storage_attachments`.`record_type` = 'Gym' AND `active_storage_attachments`.`name` = 'banner' LIMIT 1
|
sql
app/models/gym.rb:147
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = 231 AND `active_storage_attachments`.`record_type` = 'Gym' AND `active_storage_attachments`.`name` = 'logo' LIMIT 1
|
sql
app/models/guide_book_paper.rb:83
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = 55 AND `active_storage_attachments`.`record_type` = 'GuideBookPaper' AND `active_storage_attachments`.`name` = 'cover' LIMIT 1
|
sql
app/models/crag_route.rb:179
|
<1 ms
|
<0.1
|
<1 %
|
SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = 2230 LIMIT 1
|