|
sql
app/models/town.rb:31
|
33%
|
app/models/town.rb:31
- Average Self
-
197ms
- Average calls
- 1x
- Total Self
- 197ms
- Total Children
- 0ms
- Total runtime
- 197ms
SELECT `crags`.`id` FROM `crags` LEFT OUTER JOIN `crag_routes` ON `crag_routes`.`crag_id` = `crags`.`id` AND (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND (getRange(latitude, longitude, ?, ?) < ?) ORDER BY getRange(latitude, longitude, ? , ?)
|
|
sql
app/models/town.rb:109
|
30%
|
app/models/town.rb:109
- Average Self
-
91ms
- Average calls
- 2x
- Total Self
- 183ms
- Total Children
- 0ms
- Total runtime
- 183ms
SELECT `crags`.`id`, `crags`.`name`, `crags`.`slug_name`, `crags`.`sport_climbing`, `crags`.`bouldering`, `crags`.`multi_pitch`, `crags`.`trad_climbing`, `crags`.`aid_climbing`, `crags`.`deep_water`, `crags`.`via_ferrata`, `crags`.`north`, `crags`.`north_east`, `crags`.`east`, `crags`.`south_east`, `crags`.`south`, `crags`.`south_west`, `crags`.`west`, `crags`.`north_west`, `crags`.`summer`, `crags`.`autumn`, `crags`.`winter`, `crags`.`spring`, `crags`.`min_approach_time`, `crags`.`max_approach_time` FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND (getRange(latitude, longitude, ?, ?) < ?) ORDER BY getRange(latitude, longitude, ? , ?)
|
|
sql
app/models/town.rb:59
|
6%
|
app/models/town.rb:59
- Average Self
-
20ms
- Average calls
- 1.9x
- Total Self
- 38ms
- Total Children
- 0ms
- Total runtime
- 38ms
SELECT `gyms`.`id`, `gyms`.`slug_name`, `gyms`.`name`, `gyms`.`country`, `gyms`.`city` FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND (getRange(latitude, longitude, ?, ?) < ?) ORDER BY getRange(latitude, longitude, ? , ?)
|
|
sql
app/models/town.rb:75
|
4%
|
app/models/town.rb:75
- Average Self
-
43ms
- Average calls
- 0.57x
- Total Self
- 24ms
- Total Children
- 0ms
- Total runtime
- 24ms
SELECT `gyms`.`id`, `gyms`.`slug_name`, `gyms`.`name`, `gyms`.`country`, `gyms`.`city`, `gyms`.`latitude`, `gyms`.`longitude` FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) ORDER BY getRange(gyms.latitude, gyms.longitude, ? , ?) LIMIT ?
|
|
sql
app/models/town.rb:192
|
2%
|
app/models/town.rb:192
- Average Self
-
2.5ms
- Average calls
- 4x
- Total Self
- 9.9ms
- Total Children
- 0ms
- Total runtime
- 9.9ms
BEGIN
SELECT `towns`.* FROM `towns` WHERE `towns`.`id` = ? LIMIT ?
|
|
sql
app/models/concerns/route_figurable.rb:70
|
2%
|
app/models/concerns/route_figurable.rb:70
- Average Self
-
9.6ms
- Average calls
- 1x
- Total Self
- 9.6ms
- Total Children
- 0ms
- Total runtime
- 9.6ms
SELECT climbing_type,
crag_routes.max_grade_value,
crag_routes.max_grade_text,
crag_routes.min_grade_value,
crag_routes.min_grade_text,
crag_routes.id,
crag_id,
crag_routes.name,
crag_routes.slug_name,
sections_count,
sections,
crags.name AS crag_name,
crags.slug_name AS crag_slug_name FROM `crag_routes` INNER JOIN `crags` ON `crags`.`id` = `crag_routes`.`crag_id` AND (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`crag_id` IN (?)
|
|
sql
app/models/town.rb:48
|
1%
|
app/models/town.rb:48
- Average Self
-
6.4ms
- Average calls
- 1x
- Total Self
- 6.4ms
- Total Children
- 0ms
- Total runtime
- 6.4ms
SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = ? LIMIT ?
|
|
sql
app/models/town.rb:185
|
<1%
|
app/models/town.rb:185
- Average Self
-
1.8ms
- Average calls
- 3x
- Total Self
- 5.5ms
- Total Children
- 0ms
- Total runtime
- 5.5ms
BEGIN
UPDATE `towns` SET `towns`.`updated_at` = ? WHERE `towns`.`id` = ?
|
|
sql
app/models/town.rb:150
|
<1%
|
app/models/town.rb:150
- Average Self
-
3.7ms
- Average calls
- 1x
- Total Self
- 3.7ms
- Total Children
- 0ms
- Total runtime
- 3.7ms
SELECT `guide_book_papers`.`id`, `guide_book_papers`.`slug_name`, `guide_book_papers`.`name`, `guide_book_papers`.`author`, `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, `g [TRUNCATED]
|
|
sql
app/models/town.rb:189
|
<1%
|
app/models/town.rb:189
- Average Self
-
1.9ms
- Average calls
- 1x
- Total Self
- 1.9ms
- Total Children
- 0ms
- Total runtime
- 1.9ms
SELECT `town_json_objects`.* FROM `town_json_objects` WHERE `town_json_objects`.`town_id` = ? AND `town_json_objects`.`dist` = ? LIMIT ?
|
|
sql
app/worker/historize_town_worker.rb:8
|
<1%
|
app/worker/historize_town_worker.rb:8
- Average Self
-
1.3ms
- Average calls
- 1x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
SELECT `towns`.* FROM `towns` WHERE `towns`.`id` = ? LIMIT ?
|
|
sql
app/models/town.rb:186
|
<1%
|
app/models/town.rb:186
- Average Self
-
1ms
- Average calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `towns`.* FROM `towns` WHERE `towns`.`id` = ? LIMIT ?
|
|
sql
app/models/concerns/attachment_resizable.rb:10
|
<1%
|
app/models/concerns/attachment_resizable.rb:10
- Average Self
-
1.5ms
- Average calls
- 0.57x
- Total Self
- 0.86ms
- Total Children
- 0ms
- Total runtime
- 0.86ms
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = ? AND `active_storage_attachments`.`record_type` = ? AND `active_storage_attachments`.`name` = ? LIMIT ?
|
|
sql
app/models/concerns/attachment_resizable.rb:12
|
<1%
|
app/models/concerns/attachment_resizable.rb:12
- Average Self
-
1ms
- Average calls
- 0.07x
- Total Self
- 0.07ms
- Total Children
- 0ms
- Total runtime
- 0.07ms
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
|