{"action":"created","issue":{"url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/6706","repository_url":"https://api.github.com/repos/Yoast/wordpress-seo","labels_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/6706/labels{/name}","comments_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/6706/comments","events_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/6706/events","html_url":"https://github.com/Yoast/wordpress-seo/issues/6706","id":209124782,"number":6706,"title":"Very slow query wp-seo","user":{"login":"mehdiraized","id":4368004,"avatar_url":"https://avatars1.githubusercontent.com/u/4368004?v=4","gravatar_id":"","url":"https://api.github.com/users/mehdiraized","html_url":"https://github.com/mehdiraized","followers_url":"https://api.github.com/users/mehdiraized/followers","following_url":"https://api.github.com/users/mehdiraized/following{/other_user}","gists_url":"https://api.github.com/users/mehdiraized/gists{/gist_id}","starred_url":"https://api.github.com/users/mehdiraized/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mehdiraized/subscriptions","organizations_url":"https://api.github.com/users/mehdiraized/orgs","repos_url":"https://api.github.com/users/mehdiraized/repos","events_url":"https://api.github.com/users/mehdiraized/events{/privacy}","received_events_url":"https://api.github.com/users/mehdiraized/received_events","type":"User","site_admin":false},"labels":[{"id":19494702,"url":"https://api.github.com/repos/Yoast/wordpress-seo/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":26,"created_at":"2017-02-21T12:01:17Z","updated_at":"2018-03-05T20:41:59Z","closed_at":null,"author_association":"NONE","body":"Very slow query of site me \r\n(\r\nSELECT SQL_CALC_FOUND_ROWS wp_posts.ID\r\nFROM wp_posts\r\nINNER JOIN wp_postmeta\r\nON ( wp_posts.ID = wp_postmeta.post_id )\r\nWHERE 1=1\r\nAND wp_posts.ID NOT IN (260706)\r\nAND ( ( wp_postmeta.meta_key = '_yoast_wpseo_focuskw'\r\nAND wp_postmeta.meta_value = 'real madrid' ) )\r\nAND wp_posts.post_type IN ('post', 'page', 'attachment')\r\nAND (wp_posts.post_status = 'publish'\r\nOR wp_posts.post_status = 'future'\r\nOR wp_posts.post_status = 'draft'\r\nOR wp_posts.post_status = 'pending'\r\nOR wp_posts.post_author = 306\r\nAND wp_posts.post_status = 'private')\r\nGROUP BY wp_posts.ID\r\nORDER BY wp_posts.post_date DESC\r\nLIMIT 0, 2\r\n)\r\n\r\n<img width=\"1511\" alt=\"screen shot 1395-12-03 at 15 29 15\" src=\"https://cloud.githubusercontent.com/assets/4368004/23164099/c2af4b4e-f84a-11e6-9627-afaa3a682e00.png\">\r\n\r\n### Technical info\r\n* WordPress version: 4.7.2\r\n* Yoast SEO version: 4.3\r\n"},"comment":{"url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/comments/370557688","html_url":"https://github.com/Yoast/wordpress-seo/issues/6706#issuecomment-370557688","issue_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/6706","id":370557688,"user":{"login":"fatihtoprak","id":2514952,"avatar_url":"https://avatars3.githubusercontent.com/u/2514952?v=4","gravatar_id":"","url":"https://api.github.com/users/fatihtoprak","html_url":"https://github.com/fatihtoprak","followers_url":"https://api.github.com/users/fatihtoprak/followers","following_url":"https://api.github.com/users/fatihtoprak/following{/other_user}","gists_url":"https://api.github.com/users/fatihtoprak/gists{/gist_id}","starred_url":"https://api.github.com/users/fatihtoprak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fatihtoprak/subscriptions","organizations_url":"https://api.github.com/users/fatihtoprak/orgs","repos_url":"https://api.github.com/users/fatihtoprak/repos","events_url":"https://api.github.com/users/fatihtoprak/events{/privacy}","received_events_url":"https://api.github.com/users/fatihtoprak/received_events","type":"User","site_admin":false},"created_at":"2018-03-05T20:41:59Z","updated_at":"2018-03-05T20:41:59Z","author_association":"NONE","body":"Is there any update ? Fix etc ? \r\n\r\n`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = ''''_yoast_wpseo_focuskw'''' ) WHERE 1=1 AND ( \r\nwp_postmeta.post_id IS NULL\r\n) AND wp_posts.post_type = ''''post'''' AND ((wp_posts.post_status = ''''publish'''')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10;`"}}
{"actor":{"display_login":"fatihtoprak"}}