Oblyk API

.MD

Api::V1::CragsController#show

…

Most impactful sections

code58%
sql42%
unknown<1%


code app/controllers/api/v1/crags_controller.rb:341	52%
Average Self 16ms Average calls 1x Total Self 16ms Total Children 13ms Total runtime 30ms `Api::V1::CragsController#show`
code /var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525	6%
Average Self 1.9ms Average calls 1x Total Self 1.9ms Total Children 30ms Total runtime 32ms `Rails::Engine#call`
sql app/models/crag.rb:115	6%
Average Self 0.91ms Average calls 2x Total Self 1.8ms Total Children 0ms Total runtime 1.8ms 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` = ?
sql app/models/crag.rb:222	4%
Average Self 1.3ms Average calls 1x Total Self 1.3ms Total Children 0ms Total runtime 1.3ms SELECT COUNT(*) FROM `alerts` WHERE `alerts`.`alertable_id` = ? AND `alerts`.`alertable_type` = ?
sql app/controllers/api/v1/crags_controller.rb:451	4%
Average Self 1.3ms Average calls 1x Total Self 1.3ms Total Children 0ms Total runtime 1.3ms 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.1ms Average calls 1x Total Self 1.1ms Total Children 0ms Total runtime 1.1ms SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
sql app/models/crag.rb:235	3%
Average Self 1ms Average calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms 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:220	3%
Average Self 0.94ms Average calls 1x Total Self 0.94ms Total Children 0ms Total runtime 0.94ms SELECT COUNT(*) FROM `links` WHERE `links`.`linkable_id` = ? AND `links`.`linkable_type` = ?
sql app/models/crag.rb:232	3%
Average Self 0.86ms Average calls 1x Total Self 0.86ms Total Children 0ms Total runtime 0.86ms 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:119	3%
Average Self 0.86ms Average calls 1x Total Self 0.86ms Total Children 0ms Total runtime 0.86ms 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:236	3%
Average Self 0.81ms Average calls 1x Total Self 0.81ms Total Children 0ms Total runtime 0.81ms 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:225	2%
Average Self 0.79ms Average calls 1x Total Self 0.79ms Total Children 0ms Total runtime 0.79ms SELECT COUNT(*) FROM `versions` WHERE `versions`.`item_id` = ? AND `versions`.`item_type` = ?
sql app/models/crag.rb:221	2%
Average Self 0.77ms Average calls 1x Total Self 0.77ms Total Children 0ms Total runtime 0.77ms SELECT COUNT(*) FROM `parks` WHERE `parks`.`crag_id` = ?
sql app/models/crag.rb:230	2%
Average Self 0.76ms Average calls 1x Total Self 0.76ms Total Children 0ms Total runtime 0.76ms SELECT COUNT(*) FROM `guide_book_webs` WHERE `guide_book_webs`.`crag_id` = ?
sql app/models/crag.rb:231	2%
Average Self 0.76ms Average calls 1x Total Self 0.76ms Total Children 0ms Total runtime 0.76ms SELECT COUNT(*) FROM `guide_book_pdfs` WHERE `guide_book_pdfs`.`crag_id` = ?
sql app/models/concerns/attachment_resizable.rb:10	<1%
Average Self 0.94ms Average calls 0.3x Total Self 0.28ms Total Children 0ms Total runtime 0.28ms 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.86ms Average calls 0.29x Total Self 0.25ms Total Children 0ms Total runtime 0.25ms SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
sql app/models/crag.rb:189	<1%
Average Self 0.88ms Average calls 0.04x 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 1ms 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	127	25 Jun 14:48