Oblyk API

.MD

Api::V1::CragsController#show

…

Most impactful sections

code57%
sql43%
unknown<1%


code app/controllers/api/v1/crags_controller.rb:341	52%
Average Self 18ms Average calls 1x Total Self 18ms Total Children 15ms Total runtime 33ms `Api::V1::CragsController#show`
sql app/models/crag.rb:115	6%
Average Self 1.1ms Average calls 2x Total Self 2.2ms Total Children 0ms Total runtime 2.2ms SELECT SUM(`crag_sectors`.`photos_count`) FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > ?) AND `crag_sectors`.`crag_id` = ?
code /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525	5%
Average Self 1.7ms Average calls 1x Total Self 1.7ms Total Children 33ms Total runtime 35ms `Rails::Engine#call`
sql app/controllers/api/v1/crags_controller.rb:451	4%
Average Self 1.4ms Average calls 1x Total Self 1.4ms Total Children 0ms Total runtime 1.4ms SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`id` = ? LIMIT ?
sql app/models/crag.rb:234	4%
Average Self 1.3ms Average calls 1x Total Self 1.3ms Total Children 0ms Total runtime 1.3ms SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
sql app/models/crag.rb:236	3%
Average Self 1.2ms Average calls 1x Total Self 1.2ms Total Children 0ms Total runtime 1.2ms SELECT `areas`.* FROM `areas` INNER JOIN `area_crags` ON `areas`.`id` = `area_crags`.`area_id` WHERE `area_crags`.`crag_id` = ?
sql app/models/crag.rb:235	3%
Average Self 1.2ms Average calls 1x Total Self 1.2ms Total Children 0ms Total runtime 1.2ms SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > ?) AND `crag_sectors`.`crag_id` = ?
sql app/models/crag.rb:119	3%
Average Self 1.1ms Average calls 1x Total Self 1.1ms Total Children 0ms Total runtime 1.1ms SELECT SUM(`crag_routes`.`videos_count`) FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`crag_id` = ?
sql app/models/crag.rb:220	3%
Average Self 1ms Average calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms SELECT COUNT(*) FROM `links` WHERE `links`.`linkable_id` = ? AND `links`.`linkable_type` = ?
sql app/models/crag.rb:232	3%
Average Self 0.98ms Average calls 1x Total Self 0.98ms Total Children 0ms Total runtime 0.98ms SELECT COUNT(*) FROM `guide_book_papers` INNER JOIN `guide_book_paper_crags` ON `guide_book_papers`.`id` = `guide_book_paper_crags`.`guide_book_paper_id` WHERE `guide_book_paper_crags`.`crag_id` = ?
sql app/models/crag.rb:225	3%
Average Self 0.92ms Average calls 1x Total Self 0.92ms Total Children 0ms Total runtime 0.92ms SELECT COUNT(*) FROM `versions` WHERE `versions`.`item_id` = ? AND `versions`.`item_type` = ?
sql app/models/crag.rb:222	3%
Average Self 0.89ms Average calls 1x Total Self 0.89ms Total Children 0ms Total runtime 0.89ms SELECT COUNT(*) FROM `alerts` WHERE `alerts`.`alertable_id` = ? AND `alerts`.`alertable_type` = ?
sql app/models/crag.rb:221	2%
Average Self 0.88ms Average calls 1x Total Self 0.88ms Total Children 0ms Total runtime 0.88ms SELECT COUNT(*) FROM `parks` WHERE `parks`.`crag_id` = ?
sql app/models/crag.rb:230	2%
Average Self 0.87ms Average calls 1x Total Self 0.87ms Total Children 0ms Total runtime 0.87ms SELECT COUNT(*) FROM `guide_book_webs` WHERE `guide_book_webs`.`crag_id` = ?
sql app/models/crag.rb:231	2%
Average Self 0.84ms Average calls 1x Total Self 0.84ms Total Children 0ms Total runtime 0.84ms SELECT COUNT(*) FROM `guide_book_pdfs` WHERE `guide_book_pdfs`.`crag_id` = ?
sql app/models/concerns/attachment_resizable.rb:10	<1%
Average Self 1ms Average calls 0.22x Total Self 0.23ms Total Children 0ms Total runtime 0.23ms 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.9ms Average calls 0.21x Total Self 0.19ms Total Children 0ms Total runtime 0.19ms SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
sql app/models/crag.rb:189	<1%
Average Self 0.97ms Average calls 0.03x Total Self 0.03ms Total Children 0ms Total runtime 0.03ms SELECT `photos`.* FROM `photos` WHERE `photos`.`id` = ? LIMIT ?
sql app/controllers/api/v1/api_controller.rb:50	<1%
Average Self 2ms Average calls <0.01x Total Self <0.01ms Total Children 0ms Total runtime <0.01ms SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = ? LIMIT ?

Slowest executions

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

Last errors

Mysql2::Error::ConnectionError: Can't connect to MySQL server on '185.163.127.177:3306' (111) app/models/concerns/soft_deletable.rb:7	51	31 May 11:13