{"action":"created","issue":{"url":"https://api.github.com/repos/alphagov/e-petitions/issues/363","labels_url":"https://api.github.com/repos/alphagov/e-petitions/issues/363/labels{/name}","comments_url":"https://api.github.com/repos/alphagov/e-petitions/issues/363/comments","events_url":"https://api.github.com/repos/alphagov/e-petitions/issues/363/events","html_url":"https://github.com/alphagov/e-petitions/pull/363","id":98145648,"number":363,"title":"Add links to petitions waiting for X to homepage","user":{"login":"henryhadlow","id":2234084,"avatar_url":"https://avatars.githubusercontent.com/u/2234084?v=3","gravatar_id":"","url":"https://api.github.com/users/henryhadlow","html_url":"https://github.com/henryhadlow","followers_url":"https://api.github.com/users/henryhadlow/followers","following_url":"https://api.github.com/users/henryhadlow/following{/other_user}","gists_url":"https://api.github.com/users/henryhadlow/gists{/gist_id}","starred_url":"https://api.github.com/users/henryhadlow/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/henryhadlow/subscriptions","organizations_url":"https://api.github.com/users/henryhadlow/orgs","repos_url":"https://api.github.com/users/henryhadlow/repos","events_url":"https://api.github.com/users/henryhadlow/events{/privacy}","received_events_url":"https://api.github.com/users/henryhadlow/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-07-30T11:34:09Z","updated_at":"2015-07-31T10:23:42Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/alphagov/e-petitions/pulls/363","html_url":"https://github.com/alphagov/e-petitions/pull/363","diff_url":"https://github.com/alphagov/e-petitions/pull/363.diff","patch_url":"https://github.com/alphagov/e-petitions/pull/363.patch"},"body":"It's a bit misleading to only show the petitions that *have* a response or debate outcome"},"comment":{"url":"https://api.github.com/repos/alphagov/e-petitions/issues/comments/126636464","html_url":"https://github.com/alphagov/e-petitions/pull/363#issuecomment-126636464","issue_url":"https://api.github.com/repos/alphagov/e-petitions/issues/363","id":126636464,"user":{"login":"oskarpearson","id":129002,"avatar_url":"https://avatars.githubusercontent.com/u/129002?v=3","gravatar_id":"","url":"https://api.github.com/users/oskarpearson","html_url":"https://github.com/oskarpearson","followers_url":"https://api.github.com/users/oskarpearson/followers","following_url":"https://api.github.com/users/oskarpearson/following{/other_user}","gists_url":"https://api.github.com/users/oskarpearson/gists{/gist_id}","starred_url":"https://api.github.com/users/oskarpearson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/oskarpearson/subscriptions","organizations_url":"https://api.github.com/users/oskarpearson/orgs","repos_url":"https://api.github.com/users/oskarpearson/repos","events_url":"https://api.github.com/users/oskarpearson/events{/privacy}","received_events_url":"https://api.github.com/users/oskarpearson/received_events","type":"User","site_admin":false},"created_at":"2015-07-31T10:23:42Z","updated_at":"2015-07-31T10:23:42Z","body":"I'm a bit concerned that we're doing a lot more SQL queries on the homepage. I think it might be worth checking the performance impact of this before it hits prod.. Is the home page cached, so that these queries only run occasionally?\r\n\r\nThere may be indexes that we need to create to make sure that the queries are against indexed fields.\r\n\r\nThe stats pages don't show a lot of hits of the homepage, so I don't know that it'd be a huge problem... but I think it's worth testing."}}