{"action":"created","issue":{"url":"https://api.github.com/repos/yiisoft/yii2/issues/7500","labels_url":"https://api.github.com/repos/yiisoft/yii2/issues/7500/labels{/name}","comments_url":"https://api.github.com/repos/yiisoft/yii2/issues/7500/comments","events_url":"https://api.github.com/repos/yiisoft/yii2/issues/7500/events","html_url":"https://github.com/yiisoft/yii2/pull/7500","id":59344564,"number":7500,"title":"Faster buildInCondition from array of integers","user":{"login":"bethrezen","id":260284,"avatar_url":"https://avatars.githubusercontent.com/u/260284?v=3","gravatar_id":"","url":"https://api.github.com/users/bethrezen","html_url":"https://github.com/bethrezen","followers_url":"https://api.github.com/users/bethrezen/followers","following_url":"https://api.github.com/users/bethrezen/following{/other_user}","gists_url":"https://api.github.com/users/bethrezen/gists{/gist_id}","starred_url":"https://api.github.com/users/bethrezen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bethrezen/subscriptions","organizations_url":"https://api.github.com/users/bethrezen/orgs","repos_url":"https://api.github.com/users/bethrezen/repos","events_url":"https://api.github.com/users/bethrezen/events{/privacy}","received_events_url":"https://api.github.com/users/bethrezen/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/yiisoft/yii2/labels/type:enhancement","name":"type:enhancement","color":"d7e102"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":21,"created_at":"2015-02-28T15:03:50Z","updated_at":"2015-03-02T09:35:01Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/yiisoft/yii2/pulls/7500","html_url":"https://github.com/yiisoft/yii2/pull/7500","diff_url":"https://github.com/yiisoft/yii2/pull/7500.diff","patch_url":"https://github.com/yiisoft/yii2/pull/7500.patch"},"body":"`buildInCondition` checks each value from an array for it's type(`NULL` or `Expression`). Otherwise it converts value to PDO binding param, which is not effective for numbers.\r\nMy fix just skips variables of integer or double type so they are not binded, leaved as-is and are just imploded on line 1108. That's much faster."},"comment":{"url":"https://api.github.com/repos/yiisoft/yii2/issues/comments/76681828","html_url":"https://github.com/yiisoft/yii2/pull/7500#issuecomment-76681828","issue_url":"https://api.github.com/repos/yiisoft/yii2/issues/7500","id":76681828,"user":{"login":"samdark","id":47294,"avatar_url":"https://avatars.githubusercontent.com/u/47294?v=3","gravatar_id":"","url":"https://api.github.com/users/samdark","html_url":"https://github.com/samdark","followers_url":"https://api.github.com/users/samdark/followers","following_url":"https://api.github.com/users/samdark/following{/other_user}","gists_url":"https://api.github.com/users/samdark/gists{/gist_id}","starred_url":"https://api.github.com/users/samdark/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/samdark/subscriptions","organizations_url":"https://api.github.com/users/samdark/orgs","repos_url":"https://api.github.com/users/samdark/repos","events_url":"https://api.github.com/users/samdark/events{/privacy}","received_events_url":"https://api.github.com/users/samdark/received_events","type":"User","site_admin":false},"created_at":"2015-03-02T09:35:01Z","updated_at":"2015-03-02T09:35:01Z","body":"Are you sure 20K is a real scenario?"}}