Oblyk API

.MD

HistorizeTownJob

…

Most impactful sections

sql61%
code39%
unknown<1%


code app/jobs/historize_town_job.rb:6	39%
Average Self 43ms Average calls 1x Total Self 43ms Total Children 67ms Total runtime 111ms `HistorizeTownJob#perform`
sql app/models/town.rb:109	19%
Average Self 11ms Average calls 1.8x Total Self 20ms Total Children 0ms Total runtime 20ms 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 (ST_DISTANCE_SPHERE(POINT(longitude, latitude), POINT(?, ?)) < ?) ORDER BY ST_DISTANCE_SPHERE(POINT(longitude, latitude), POINT(?, ?))
sql app/models/town.rb:31	10%
Average Self 13ms Average calls 0.82x Total Self 11ms Total Children 0ms Total runtime 11ms 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 (ST_DISTANCE_SPHERE(POINT(longitude, latitude), POINT(?, ?)) < ?) ORDER BY ST_DISTANCE_SPHERE(POINT(longitude, latitude), POINT(?, ?))
sql app/models/town.rb:194	7%
Average Self 2ms Average calls 4x Total Self 8ms Total Children 0ms Total runtime 8ms BEGIN SELECT `towns`.* FROM `towns` WHERE `towns`.`id` = ? LIMIT ?
sql app/models/town.rb:59	7%
Average Self 2.9ms Average calls 2.7x Total Self 7.9ms Total Children 0ms Total runtime 7.9ms 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 (ST_DISTANCE_SPHERE(POINT(longitude, latitude), POINT(?, ?)) < ?) ORDER BY ST_DISTANCE_SPHERE(POINT(longitude, latitude), POINT(?, ?))
sql app/models/town.rb:134	5%
Average Self 30ms Average calls 0.18x Total Self 5.5ms Total Children 0ms Total runtime 5.5ms SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) ORDER BY ST_DISTANCE_SPHERE(POINT(crags.longitude, crags.latitude), POINT(?, ?)) LIMIT ?
sql app/models/town.rb:187	3%
Average Self 1.2ms Average calls 3x Total Self 3.7ms Total Children 0ms Total runtime 3.7ms BEGIN UPDATE `towns` SET `towns`.`updated_at` = ? WHERE `towns`.`id` = ?
sql app/models/town.rb:48	2%
Average Self 2.4ms Average calls 1x Total Self 2.4ms Total Children 0ms Total runtime 2.4ms SELECT `departments`.* FROM `departments` WHERE `departments`.`id` = ? LIMIT ?
sql app/models/concerns/route_figurable.rb:70	2%
Average Self 2.8ms Average calls 0.82x Total Self 2.3ms Total Children 0ms Total runtime 2.3ms 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:191	1%
Average Self 1.7ms Average calls 1x Total Self 1.7ms Total Children 0ms Total runtime 1.7ms SELECT `town_json_objects`.* FROM `town_json_objects` WHERE `town_json_objects`.`town_id` = ? AND `town_json_objects`.`dist` = ? LIMIT ?
sql app/models/town.rb:152	1%
Average Self 1.7ms Average calls 0.82x Total Self 1.4ms Total Children 0ms Total runtime 1.4ms 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/jobs/historize_town_job.rb:7	<1%
Average Self 0.93ms Average calls 1x Total Self 0.93ms Total Children 0ms Total runtime 0.93ms SELECT `towns`.* FROM `towns` WHERE `towns`.`id` = ? LIMIT ?
sql app/models/town.rb:188	<1%
Average Self 0.83ms Average calls 1x Total Self 0.83ms Total Children 0ms Total runtime 0.83ms SELECT `towns`.* FROM `towns` WHERE `towns`.`id` = ? LIMIT ?
sql app/models/town.rb:75	<1%
Average Self 3.9ms Average calls 0.13x Total Self 0.51ms Total Children 0ms Total runtime 0.51ms 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 ST_DISTANCE_SPHERE(POINT(gyms.longitude, gyms.latitude), POINT(?, ?)) LIMIT ?
sql app/models/concerns/attachment_resizable.rb:10	<1%
Average Self 1.1ms Average calls 0.15x Total Self 0.17ms Total Children 0ms Total runtime 0.17ms 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%
Average Self 0.95ms Average calls 0.15x Total Self 0.14ms Total Children 0ms Total runtime 0.14ms SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
code /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/activesupport-6.0.3.6/lib/active_support/callbacks.rb:121	<1%
Average Self 0.08ms Average calls 1x Total Self 0.08ms Total Children 111ms Total runtime 111ms `HistorizeTownJob`
sql app/models/town.rb:144	<1%
Average Self 1ms Average calls 0.02x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = ? LIMIT ?

Slowest executions

loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-