{"action":"created","issue":{"url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/357","labels_url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/357/labels{/name}","comments_url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/357/comments","events_url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/357/events","html_url":"https://github.com/cubing/worldcubeassociation.org/pull/357","id":129915953,"number":357,"title":"Fix n+1 queries on homepage","user":{"login":"timhabermaas","id":96054,"avatar_url":"https://avatars.githubusercontent.com/u/96054?v=3","gravatar_id":"","url":"https://api.github.com/users/timhabermaas","html_url":"https://github.com/timhabermaas","followers_url":"https://api.github.com/users/timhabermaas/followers","following_url":"https://api.github.com/users/timhabermaas/following{/other_user}","gists_url":"https://api.github.com/users/timhabermaas/gists{/gist_id}","starred_url":"https://api.github.com/users/timhabermaas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timhabermaas/subscriptions","organizations_url":"https://api.github.com/users/timhabermaas/orgs","repos_url":"https://api.github.com/users/timhabermaas/repos","events_url":"https://api.github.com/users/timhabermaas/events{/privacy}","received_events_url":"https://api.github.com/users/timhabermaas/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-01-30T00:03:54Z","updated_at":"2016-01-30T00:17:43Z","closed_at":"2016-01-30T00:16:33Z","pull_request":{"url":"https://api.github.com/repos/cubing/worldcubeassociation.org/pulls/357","html_url":"https://github.com/cubing/worldcubeassociation.org/pull/357","diff_url":"https://github.com/cubing/worldcubeassociation.org/pull/357.diff","patch_url":"https://github.com/cubing/worldcubeassociation.org/pull/357.patch"},"body":"* Eager load authors of posts.\r\n* Prevent querying crash_course_post multiple times by using slug for comparison."},"comment":{"url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/comments/177029028","html_url":"https://github.com/cubing/worldcubeassociation.org/pull/357#issuecomment-177029028","issue_url":"https://api.github.com/repos/cubing/worldcubeassociation.org/issues/357","id":177029028,"user":{"login":"timhabermaas","id":96054,"avatar_url":"https://avatars.githubusercontent.com/u/96054?v=3","gravatar_id":"","url":"https://api.github.com/users/timhabermaas","html_url":"https://github.com/timhabermaas","followers_url":"https://api.github.com/users/timhabermaas/followers","following_url":"https://api.github.com/users/timhabermaas/following{/other_user}","gists_url":"https://api.github.com/users/timhabermaas/gists{/gist_id}","starred_url":"https://api.github.com/users/timhabermaas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timhabermaas/subscriptions","organizations_url":"https://api.github.com/users/timhabermaas/orgs","repos_url":"https://api.github.com/users/timhabermaas/repos","events_url":"https://api.github.com/users/timhabermaas/events{/privacy}","received_events_url":"https://api.github.com/users/timhabermaas/received_events","type":"User","site_admin":false},"created_at":"2016-01-30T00:17:43Z","updated_at":"2016-01-30T00:17:43Z","body":"For the record, before:\r\n\r\n```\r\nI, [2016-01-30T01:16:38.893119 #77430]  INFO -- : Started GET \"/\" for ::1 at 2016-01-30 01:16:38 +0100\r\nD, [2016-01-30T01:16:38.899141 #77430] DEBUG -- :   User Load (0.4ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 169  ORDER BY `users`.`id` ASC LIMIT 1\r\nI, [2016-01-30T01:16:38.899918 #77430]  INFO -- : Processing by PostsController#index as HTML\r\nD, [2016-01-30T01:16:38.907818 #77430] DEBUG -- :   Post Load (0.3ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`world_readable` = 1  ORDER BY `posts`.`sticky` DESC, `posts`.`created_at` DESC LIMIT 30 OFFSET 0\r\nD, [2016-01-30T01:16:38.909648 #77430] DEBUG -- :   Post Load (0.2ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1\r\nD, [2016-01-30T01:16:38.909932 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.910708 #77430] DEBUG -- :   User Load (0.2ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 159 LIMIT 1\r\nD, [2016-01-30T01:16:38.911230 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.911431 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.911821 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 159 LIMIT 1  [[\"id\", 159]]\r\nD, [2016-01-30T01:16:38.912214 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.912418 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.913064 #77430] DEBUG -- :   User Load (0.3ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 157 LIMIT 1\r\nD, [2016-01-30T01:16:38.913553 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.913789 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.914382 #77430] DEBUG -- :   User Load (0.2ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 158 LIMIT 1\r\nD, [2016-01-30T01:16:38.914836 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.915040 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.915466 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 158 LIMIT 1  [[\"id\", 158]]\r\nD, [2016-01-30T01:16:38.915857 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.916050 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.916444 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 158 LIMIT 1  [[\"id\", 158]]\r\nD, [2016-01-30T01:16:38.916811 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.917026 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.917386 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 157 LIMIT 1  [[\"id\", 157]]\r\nD, [2016-01-30T01:16:38.917782 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.917971 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.918360 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 159 LIMIT 1  [[\"id\", 159]]\r\nD, [2016-01-30T01:16:38.918756 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.918950 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.919652 #77430] DEBUG -- :   User Load (0.3ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 160 LIMIT 1\r\nD, [2016-01-30T01:16:38.920262 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.920571 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.921272 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 160 LIMIT 1  [[\"id\", 160]]\r\nD, [2016-01-30T01:16:38.921801 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.922039 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.922490 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 157 LIMIT 1  [[\"id\", 157]]\r\nD, [2016-01-30T01:16:38.922893 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.923086 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.923469 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 160 LIMIT 1  [[\"id\", 160]]\r\nD, [2016-01-30T01:16:38.923859 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.924076 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.924483 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 157 LIMIT 1  [[\"id\", 157]]\r\nD, [2016-01-30T01:16:38.924921 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.925124 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.925543 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 159 LIMIT 1  [[\"id\", 159]]\r\nD, [2016-01-30T01:16:38.925964 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.926269 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.926656 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 159 LIMIT 1  [[\"id\", 159]]\r\nD, [2016-01-30T01:16:38.927130 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.927383 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.928153 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 159 LIMIT 1  [[\"id\", 159]]\r\nD, [2016-01-30T01:16:38.928740 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.928990 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.929438 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 160 LIMIT 1  [[\"id\", 160]]\r\nD, [2016-01-30T01:16:38.929883 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.930088 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.930490 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 160 LIMIT 1  [[\"id\", 160]]\r\nD, [2016-01-30T01:16:38.930916 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.931121 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.931516 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 158 LIMIT 1  [[\"id\", 158]]\r\nD, [2016-01-30T01:16:38.931903 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.932126 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`slug` = 'delegate-crash-course' LIMIT 1  [[\"slug\", \"delegate-crash-course\"]]\r\nD, [2016-01-30T01:16:38.932505 #77430] DEBUG -- :   CACHE (0.0ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 159 LIMIT 1  [[\"id\", 159]]\r\nI, [2016-01-30T01:16:38.932774 #77430]  INFO -- :   Rendered posts/_post.html.erb (23.6ms)\r\nI, [2016-01-30T01:16:38.932921 #77430]  INFO -- :   Rendered posts/index.html.erb within layouts/application (25.7ms)\r\nD, [2016-01-30T01:16:39.196622 #77430] DEBUG -- :   Competition Load (0.4ms)  SELECT `Competitions`.* FROM `Competitions` INNER JOIN `competition_delegates` ON `Competitions`.`id` = `competition_delegates`.`competition_id` WHERE `competition_delegates`.`delegate_id` = 169 AND `Competitions`.`isConfirmed` = 0\r\nD, [2016-01-30T01:16:39.197267 #77430] DEBUG -- :   Competition Load (0.3ms)  SELECT `Competitions`.* FROM `Competitions` INNER JOIN `competition_organizers` ON `Competitions`.`id` = `competition_organizers`.`competition_id` WHERE `competition_organizers`.`organizer_id` = 169 AND `Competitions`.`isConfirmed` = 0\r\nD, [2016-01-30T01:16:39.198205 #77430] DEBUG -- :   User Load (0.3ms)  SELECT `users`.* FROM `users` WHERE `users`.`delegate_id_to_handle_wca_id_claim` = 169\r\nI, [2016-01-30T01:16:39.200617 #77430]  INFO -- :   Rendered shared/_user_avatar.html.erb (1.3ms)\r\nI, [2016-01-30T01:16:39.201143 #77430]  INFO -- :   Rendered layouts/_navigation.html.erb (9.0ms)\r\nI, [2016-01-30T01:16:39.202343 #77430]  INFO -- :   Rendered layouts/_flash.html.erb (0.2ms)\r\nI, [2016-01-30T01:16:39.204025 #77430]  INFO -- :   Rendered layouts/_footer.html.erb (0.2ms)\r\nI, [2016-01-30T01:16:39.204265 #77430]  INFO -- : Completed 200 OK in 304ms (Views: 300.7ms | ActiveRecord: 3.0ms)\r\n```\r\n\r\nAfter:\r\n```\r\nI, [2016-01-30T01:15:49.068258 #77371]  INFO -- : Started GET \"/\" for ::1 at 2016-01-30 01:15:49 +0100\r\nD, [2016-01-30T01:15:49.074613 #77371] DEBUG -- :   User Load (0.3ms)  SELECT  `users`.* FROM `users` WHERE `users`.`id` = 169  ORDER BY `users`.`id` ASC LIMIT 1\r\nI, [2016-01-30T01:15:49.075398 #77371]  INFO -- : Processing by PostsController#index as HTML\r\nD, [2016-01-30T01:15:49.084232 #77371] DEBUG -- :   Post Load (0.4ms)  SELECT  `posts`.* FROM `posts` WHERE `posts`.`world_readable` = 1  ORDER BY `posts`.`sticky` DESC, `posts`.`created_at` DESC LIMIT 30 OFFSET 0\r\nD, [2016-01-30T01:15:49.086023 #77371] DEBUG -- :   User Load (0.3ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` IN (159, 157, 158, 160)\r\nI, [2016-01-30T01:15:49.093783 #77371]  INFO -- :   Rendered posts/_post.html.erb (6.5ms)\r\nI, [2016-01-30T01:15:49.093856 #77371]  INFO -- :   Rendered posts/index.html.erb within layouts/application (10.4ms)\r\nD, [2016-01-30T01:15:49.326835 #77371] DEBUG -- :   Competition Load (0.4ms)  SELECT `Competitions`.* FROM `Competitions` INNER JOIN `competition_delegates` ON `Competitions`.`id` = `competition_delegates`.`competition_id` WHERE `competition_delegates`.`delegate_id` = 169 AND `Competitions`.`isConfirmed` = 0\r\nD, [2016-01-30T01:15:49.327417 #77371] DEBUG -- :   Competition Load (0.3ms)  SELECT `Competitions`.* FROM `Competitions` INNER JOIN `competition_organizers` ON `Competitions`.`id` = `competition_organizers`.`competition_id` WHERE `competition_organizers`.`organizer_id` = 169 AND `Competitions`.`isConfirmed` = 0\r\nD, [2016-01-30T01:15:49.328265 #77371] DEBUG -- :   User Load (0.3ms)  SELECT `users`.* FROM `users` WHERE `users`.`delegate_id_to_handle_wca_id_claim` = 169\r\nI, [2016-01-30T01:15:49.330368 #77371]  INFO -- :   Rendered shared/_user_avatar.html.erb (1.1ms)\r\nI, [2016-01-30T01:15:49.330835 #77371]  INFO -- :   Rendered layouts/_navigation.html.erb (8.5ms)\r\nI, [2016-01-30T01:15:49.331616 #77371]  INFO -- :   Rendered layouts/_flash.html.erb (0.1ms)\r\nI, [2016-01-30T01:15:49.332469 #77371]  INFO -- :   Rendered layouts/_footer.html.erb (0.1ms)\r\nI, [2016-01-30T01:15:49.332667 #77371]  INFO -- : Completed 200 OK in 257ms (Views: 255.0ms | ActiveRecord: 1.7ms)\r\n```"}}