{"action":"created","issue":{"url":"https://api.github.com/repos/cakephp/cakephp/issues/9049","repository_url":"https://api.github.com/repos/cakephp/cakephp","labels_url":"https://api.github.com/repos/cakephp/cakephp/issues/9049/labels{/name}","comments_url":"https://api.github.com/repos/cakephp/cakephp/issues/9049/comments","events_url":"https://api.github.com/repos/cakephp/cakephp/issues/9049/events","html_url":"https://github.com/cakephp/cakephp/issues/9049","id":162588644,"number":9049,"title":"SELECT * FROM information_schema Called in every query","user":{"login":"ayoub-bousetta","id":6423366,"avatar_url":"https://avatars.githubusercontent.com/u/6423366?v=3","gravatar_id":"","url":"https://api.github.com/users/ayoub-bousetta","html_url":"https://github.com/ayoub-bousetta","followers_url":"https://api.github.com/users/ayoub-bousetta/followers","following_url":"https://api.github.com/users/ayoub-bousetta/following{/other_user}","gists_url":"https://api.github.com/users/ayoub-bousetta/gists{/gist_id}","starred_url":"https://api.github.com/users/ayoub-bousetta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ayoub-bousetta/subscriptions","organizations_url":"https://api.github.com/users/ayoub-bousetta/orgs","repos_url":"https://api.github.com/users/ayoub-bousetta/repos","events_url":"https://api.github.com/users/ayoub-bousetta/events{/privacy}","received_events_url":"https://api.github.com/users/ayoub-bousetta/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-06-28T02:22:09Z","updated_at":"2016-06-28T02:30:01Z","closed_at":"2016-06-28T02:30:01Z","body":"This is a (multiple allowed):\r\n* [x] bug\r\n\r\n* CakePHP Version: 3.2\r\n\r\n\r\ni'm trying to load multiple Model in 3rd ControllerAction but it sames that not working properly cuz every time i do that i ended up with alot o queries that's tooks more than 100s.\r\n\r\n### My code inside the Action\r\n```php\r\n$users = $this->loadModel('Users');\r\n$datas=$users->find('all')->select(['id','phone', 'first_name','last_name','birthday','email','website', 'address', 'resume', 'cv_url'])->where(['id' => 1])->bufferResults(false)->ToArray();\r\n\r\n\r\n    $technologies = $this->loadModel('Technologies');\r\n    $technologies=$technologies->find('all')->select(['id', 'name', 'slug', 'image', 'exp', 'exp_perc'])->bufferResults(false)->ToArray();\r\n\r\n    $this->set(compact('datas','technologies'));\r\n```\r\n\r\n### Debug images\r\n\r\nhttp://i.stack.imgur.com/85vBT.png\r\nhttp://i.stack.imgur.com/xX6x6.png\r\n\r\nas you can see i only have 2 queries but in debug it shows 10 and TABLE_SCHEMA took 35322ms and its called 2 time (35322*2)\r\n\r\nPS : i have 'cacheMetadata' => true,\r\n\r\nAny suggestion is welcome.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/cakephp/cakephp/issues/comments/228931858","html_url":"https://github.com/cakephp/cakephp/issues/9049#issuecomment-228931858","issue_url":"https://api.github.com/repos/cakephp/cakephp/issues/9049","id":228931858,"user":{"login":"markstory","id":24086,"avatar_url":"https://avatars.githubusercontent.com/u/24086?v=3","gravatar_id":"","url":"https://api.github.com/users/markstory","html_url":"https://github.com/markstory","followers_url":"https://api.github.com/users/markstory/followers","following_url":"https://api.github.com/users/markstory/following{/other_user}","gists_url":"https://api.github.com/users/markstory/gists{/gist_id}","starred_url":"https://api.github.com/users/markstory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markstory/subscriptions","organizations_url":"https://api.github.com/users/markstory/orgs","repos_url":"https://api.github.com/users/markstory/repos","events_url":"https://api.github.com/users/markstory/events{/privacy}","received_events_url":"https://api.github.com/users/markstory/received_events","type":"User","site_admin":false},"created_at":"2016-06-28T02:30:01Z","updated_at":"2016-06-28T02:30:01Z","body":"Looks like you're in debug mode. Metadata caching only lasts 10 seconds in development mode. You can tweak that by changing settings in your bootstrap.php."}}
{"actor":{"display_login":"markstory"}}