{"action":"closed","number":18,"pull_request":{"url":"https://api.github.com/repos/shipperhq/module-shipper/pulls/18","id":94899868,"html_url":"https://github.com/shipperhq/module-shipper/pull/18","diff_url":"https://github.com/shipperhq/module-shipper/pull/18.diff","patch_url":"https://github.com/shipperhq/module-shipper/pull/18.patch","issue_url":"https://api.github.com/repos/shipperhq/module-shipper/issues/18","number":18,"state":"closed","locked":false,"title":"use single single quotes in sql","user":{"login":"ryannguyen","id":5667,"avatar_url":"https://avatars.githubusercontent.com/u/5667?v=3","gravatar_id":"","url":"https://api.github.com/users/ryannguyen","html_url":"https://github.com/ryannguyen","followers_url":"https://api.github.com/users/ryannguyen/followers","following_url":"https://api.github.com/users/ryannguyen/following{/other_user}","gists_url":"https://api.github.com/users/ryannguyen/gists{/gist_id}","starred_url":"https://api.github.com/users/ryannguyen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryannguyen/subscriptions","organizations_url":"https://api.github.com/users/ryannguyen/orgs","repos_url":"https://api.github.com/users/ryannguyen/repos","events_url":"https://api.github.com/users/ryannguyen/events{/privacy}","received_events_url":"https://api.github.com/users/ryannguyen/received_events","type":"User","site_admin":false},"body":"without the the single, mysql won't search against the index.\r\n\r\nWhen we did this we saw savings of up to 5-6 seconds in New Relic\r\n\r\n![NR Graph](https://d1zjcuqflbd5k.cloudfront.net/files/acc_674/7LAo?response-content-disposition=inline;%20filename=Screen%20Shot%202016-11-22%20at%201.13.13%20PM.png&Expires=1479849627&Signature=KKI8kXICAC9ACayJ7MsuEoF3OhHoqoZr~5fNYIeMvjMa-g1Caa6-3mZtHGz8c-EPPmuSlWW5m7yaET2DNhLpE3Vghf6lXynoqSY07PkS3fMf-RL0SXUAA4lR-ZuSgDdkIJM2EfPeo8mHLrBzpr3t5kIoIOoZ7q5KFhnApK00OBM_&Key-Pair-Id=APKAJTEIOJM3LSMN33SA)\r\n\r\nThe query went from 17 seconds \r\n\r\n![query1](https://d1zjcuqflbd5k.cloudfront.net/files/acc_674/1hBbA?response-content-disposition=inline;%20filename=Screen%20Shot%202016-11-22%20at%2012.36.06%20AM.png&Expires=1479849709&Signature=Pb-VElG6zN~2ICLZvUnR9y-4DzQI5GBiEiFBGCq4CJZADaFEpbQO~YnTmxql2PRSm~n0dehF~LH4sQ628nEw7dXFkjI4HIC2RFvhZytQPj3jEddpgRde8eXkU25xwsNfbt0C7vUAP8sgnhaWzTEU0prnU8A9gkSED1dhqYFuiMk_&Key-Pair-Id=APKAJTEIOJM3LSMN33SA)\r\n\r\nTo 11 seconds\r\n\r\n![query2](https://d1zjcuqflbd5k.cloudfront.net/files/acc_674/OCvG?response-content-disposition=inline;%20filename=Screen%20Shot%202016-11-22%20at%201.14.29%20PM.png&Expires=1479849744&Signature=bGYOT4-SrkYfC~47pU1sQehlCPPg8iR~bT4k9H5YAyZjXsVsaNN331aOJaB-HOXwW7PZIHbyaZU46OD5-TBGvBSKzoqW7kNsYGwnBGL34XMxzQaMPIucEfmXqH8XQtVrqtJByEpm2uWcEclJIrrlxz5huDVTFk7o9xvZSRRgabM_&Key-Pair-Id=APKAJTEIOJM3LSMN33SA)\r\n\r\nimage links:\r\nhttps://d.pr/7LAo\r\nhttps://d.pr/1hBbA\r\nhttps://d.pr/OCvG","created_at":"2016-11-22T21:17:48Z","updated_at":"2016-11-24T03:43:16Z","closed_at":"2016-11-24T03:43:16Z","merged_at":null,"merge_commit_sha":"f2bc639afc414826048206200d7e5d83fcd02ef1","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/shipperhq/module-shipper/pulls/18/commits","review_comments_url":"https://api.github.com/repos/shipperhq/module-shipper/pulls/18/comments","review_comment_url":"https://api.github.com/repos/shipperhq/module-shipper/pulls/comments{/number}","comments_url":"https://api.github.com/repos/shipperhq/module-shipper/issues/18/comments","statuses_url":"https://api.github.com/repos/shipperhq/module-shipper/statuses/8f41cb321f8495fdf47563a0ddcb85659626937e","head":{"label":"ryannguyen:patch-1","ref":"patch-1","sha":"8f41cb321f8495fdf47563a0ddcb85659626937e","user":{"login":"ryannguyen","id":5667,"avatar_url":"https://avatars.githubusercontent.com/u/5667?v=3","gravatar_id":"","url":"https://api.github.com/users/ryannguyen","html_url":"https://github.com/ryannguyen","followers_url":"https://api.github.com/users/ryannguyen/followers","following_url":"https://api.github.com/users/ryannguyen/following{/other_user}","gists_url":"https://api.github.com/users/ryannguyen/gists{/gist_id}","starred_url":"https://api.github.com/users/ryannguyen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryannguyen/subscriptions","organizations_url":"https://api.github.com/users/ryannguyen/orgs","repos_url":"https://api.github.com/users/ryannguyen/repos","events_url":"https://api.github.com/users/ryannguyen/events{/privacy}","received_events_url":"https://api.github.com/users/ryannguyen/received_events","type":"User","site_admin":false},"repo":{"id":74513490,"name":"module-shipper","full_name":"ryannguyen/module-shipper","owner":{"login":"ryannguyen","id":5667,"avatar_url":"https://avatars.githubusercontent.com/u/5667?v=3","gravatar_id":"","url":"https://api.github.com/users/ryannguyen","html_url":"https://github.com/ryannguyen","followers_url":"https://api.github.com/users/ryannguyen/followers","following_url":"https://api.github.com/users/ryannguyen/following{/other_user}","gists_url":"https://api.github.com/users/ryannguyen/gists{/gist_id}","starred_url":"https://api.github.com/users/ryannguyen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryannguyen/subscriptions","organizations_url":"https://api.github.com/users/ryannguyen/orgs","repos_url":"https://api.github.com/users/ryannguyen/repos","events_url":"https://api.github.com/users/ryannguyen/events{/privacy}","received_events_url":"https://api.github.com/users/ryannguyen/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/ryannguyen/module-shipper","description":"Base ShipperHQ Repo","fork":true,"url":"https://api.github.com/repos/ryannguyen/module-shipper","forks_url":"https://api.github.com/repos/ryannguyen/module-shipper/forks","keys_url":"https://api.github.com/repos/ryannguyen/module-shipper/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ryannguyen/module-shipper/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ryannguyen/module-shipper/teams","hooks_url":"https://api.github.com/repos/ryannguyen/module-shipper/hooks","issue_events_url":"https://api.github.com/repos/ryannguyen/module-shipper/issues/events{/number}","events_url":"https://api.github.com/repos/ryannguyen/module-shipper/events","assignees_url":"https://api.github.com/repos/ryannguyen/module-shipper/assignees{/user}","branches_url":"https://api.github.com/repos/ryannguyen/module-shipper/branches{/branch}","tags_url":"https://api.github.com/repos/ryannguyen/module-shipper/tags","blobs_url":"https://api.github.com/repos/ryannguyen/module-shipper/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ryannguyen/module-shipper/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ryannguyen/module-shipper/git/refs{/sha}","trees_url":"https://api.github.com/repos/ryannguyen/module-shipper/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ryannguyen/module-shipper/statuses/{sha}","languages_url":"https://api.github.com/repos/ryannguyen/module-shipper/languages","stargazers_url":"https://api.github.com/repos/ryannguyen/module-shipper/stargazers","contributors_url":"https://api.github.com/repos/ryannguyen/module-shipper/contributors","subscribers_url":"https://api.github.com/repos/ryannguyen/module-shipper/subscribers","subscription_url":"https://api.github.com/repos/ryannguyen/module-shipper/subscription","commits_url":"https://api.github.com/repos/ryannguyen/module-shipper/commits{/sha}","git_commits_url":"https://api.github.com/repos/ryannguyen/module-shipper/git/commits{/sha}","comments_url":"https://api.github.com/repos/ryannguyen/module-shipper/comments{/number}","issue_comment_url":"https://api.github.com/repos/ryannguyen/module-shipper/issues/comments{/number}","contents_url":"https://api.github.com/repos/ryannguyen/module-shipper/contents/{+path}","compare_url":"https://api.github.com/repos/ryannguyen/module-shipper/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ryannguyen/module-shipper/merges","archive_url":"https://api.github.com/repos/ryannguyen/module-shipper/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ryannguyen/module-shipper/downloads","issues_url":"https://api.github.com/repos/ryannguyen/module-shipper/issues{/number}","pulls_url":"https://api.github.com/repos/ryannguyen/module-shipper/pulls{/number}","milestones_url":"https://api.github.com/repos/ryannguyen/module-shipper/milestones{/number}","notifications_url":"https://api.github.com/repos/ryannguyen/module-shipper/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ryannguyen/module-shipper/labels{/name}","releases_url":"https://api.github.com/repos/ryannguyen/module-shipper/releases{/id}","deployments_url":"https://api.github.com/repos/ryannguyen/module-shipper/deployments","created_at":"2016-11-22T21:09:47Z","updated_at":"2016-11-22T21:09:49Z","pushed_at":"2016-11-22T21:12:38Z","git_url":"git://github.com/ryannguyen/module-shipper.git","ssh_url":"git@github.com:ryannguyen/module-shipper.git","clone_url":"https://github.com/ryannguyen/module-shipper.git","svn_url":"https://github.com/ryannguyen/module-shipper","homepage":null,"size":2575,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"shipperhq:master","ref":"master","sha":"95b9527a025bbc29770022766504b6155b89eaef","user":{"login":"shipperhq","id":18652528,"avatar_url":"https://avatars.githubusercontent.com/u/18652528?v=3","gravatar_id":"","url":"https://api.github.com/users/shipperhq","html_url":"https://github.com/shipperhq","followers_url":"https://api.github.com/users/shipperhq/followers","following_url":"https://api.github.com/users/shipperhq/following{/other_user}","gists_url":"https://api.github.com/users/shipperhq/gists{/gist_id}","starred_url":"https://api.github.com/users/shipperhq/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shipperhq/subscriptions","organizations_url":"https://api.github.com/users/shipperhq/orgs","repos_url":"https://api.github.com/users/shipperhq/repos","events_url":"https://api.github.com/users/shipperhq/events{/privacy}","received_events_url":"https://api.github.com/users/shipperhq/received_events","type":"Organization","site_admin":false},"repo":{"id":57012030,"name":"module-shipper","full_name":"shipperhq/module-shipper","owner":{"login":"shipperhq","id":18652528,"avatar_url":"https://avatars.githubusercontent.com/u/18652528?v=3","gravatar_id":"","url":"https://api.github.com/users/shipperhq","html_url":"https://github.com/shipperhq","followers_url":"https://api.github.com/users/shipperhq/followers","following_url":"https://api.github.com/users/shipperhq/following{/other_user}","gists_url":"https://api.github.com/users/shipperhq/gists{/gist_id}","starred_url":"https://api.github.com/users/shipperhq/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shipperhq/subscriptions","organizations_url":"https://api.github.com/users/shipperhq/orgs","repos_url":"https://api.github.com/users/shipperhq/repos","events_url":"https://api.github.com/users/shipperhq/events{/privacy}","received_events_url":"https://api.github.com/users/shipperhq/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/shipperhq/module-shipper","description":"Base ShipperHQ Repo","fork":false,"url":"https://api.github.com/repos/shipperhq/module-shipper","forks_url":"https://api.github.com/repos/shipperhq/module-shipper/forks","keys_url":"https://api.github.com/repos/shipperhq/module-shipper/keys{/key_id}","collaborators_url":"https://api.github.com/repos/shipperhq/module-shipper/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/shipperhq/module-shipper/teams","hooks_url":"https://api.github.com/repos/shipperhq/module-shipper/hooks","issue_events_url":"https://api.github.com/repos/shipperhq/module-shipper/issues/events{/number}","events_url":"https://api.github.com/repos/shipperhq/module-shipper/events","assignees_url":"https://api.github.com/repos/shipperhq/module-shipper/assignees{/user}","branches_url":"https://api.github.com/repos/shipperhq/module-shipper/branches{/branch}","tags_url":"https://api.github.com/repos/shipperhq/module-shipper/tags","blobs_url":"https://api.github.com/repos/shipperhq/module-shipper/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/shipperhq/module-shipper/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/shipperhq/module-shipper/git/refs{/sha}","trees_url":"https://api.github.com/repos/shipperhq/module-shipper/git/trees{/sha}","statuses_url":"https://api.github.com/repos/shipperhq/module-shipper/statuses/{sha}","languages_url":"https://api.github.com/repos/shipperhq/module-shipper/languages","stargazers_url":"https://api.github.com/repos/shipperhq/module-shipper/stargazers","contributors_url":"https://api.github.com/repos/shipperhq/module-shipper/contributors","subscribers_url":"https://api.github.com/repos/shipperhq/module-shipper/subscribers","subscription_url":"https://api.github.com/repos/shipperhq/module-shipper/subscription","commits_url":"https://api.github.com/repos/shipperhq/module-shipper/commits{/sha}","git_commits_url":"https://api.github.com/repos/shipperhq/module-shipper/git/commits{/sha}","comments_url":"https://api.github.com/repos/shipperhq/module-shipper/comments{/number}","issue_comment_url":"https://api.github.com/repos/shipperhq/module-shipper/issues/comments{/number}","contents_url":"https://api.github.com/repos/shipperhq/module-shipper/contents/{+path}","compare_url":"https://api.github.com/repos/shipperhq/module-shipper/compare/{base}...{head}","merges_url":"https://api.github.com/repos/shipperhq/module-shipper/merges","archive_url":"https://api.github.com/repos/shipperhq/module-shipper/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/shipperhq/module-shipper/downloads","issues_url":"https://api.github.com/repos/shipperhq/module-shipper/issues{/number}","pulls_url":"https://api.github.com/repos/shipperhq/module-shipper/pulls{/number}","milestones_url":"https://api.github.com/repos/shipperhq/module-shipper/milestones{/number}","notifications_url":"https://api.github.com/repos/shipperhq/module-shipper/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/shipperhq/module-shipper/labels{/name}","releases_url":"https://api.github.com/repos/shipperhq/module-shipper/releases{/id}","deployments_url":"https://api.github.com/repos/shipperhq/module-shipper/deployments","created_at":"2016-04-25T04:38:57Z","updated_at":"2016-10-24T16:06:20Z","pushed_at":"2016-11-22T21:17:48Z","git_url":"git://github.com/shipperhq/module-shipper.git","ssh_url":"git@github.com:shipperhq/module-shipper.git","clone_url":"https://github.com/shipperhq/module-shipper.git","svn_url":"https://github.com/shipperhq/module-shipper","homepage":null,"size":2575,"stargazers_count":5,"watchers_count":5,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":3,"mirror_url":null,"open_issues_count":2,"forks":3,"open_issues":2,"watchers":5,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/shipperhq/module-shipper/pulls/18"},"html":{"href":"https://github.com/shipperhq/module-shipper/pull/18"},"issue":{"href":"https://api.github.com/repos/shipperhq/module-shipper/issues/18"},"comments":{"href":"https://api.github.com/repos/shipperhq/module-shipper/issues/18/comments"},"review_comments":{"href":"https://api.github.com/repos/shipperhq/module-shipper/pulls/18/comments"},"review_comment":{"href":"https://api.github.com/repos/shipperhq/module-shipper/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/shipperhq/module-shipper/pulls/18/commits"},"statuses":{"href":"https://api.github.com/repos/shipperhq/module-shipper/statuses/8f41cb321f8495fdf47563a0ddcb85659626937e"}},"merged":false,"mergeable":true,"mergeable_state":"clean","merged_by":null,"comments":1,"review_comments":0,"commits":1,"additions":1,"deletions":1,"changed_files":1}}
{"actor":{"display_login":"wsagen"}}