{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11207","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11207/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11207/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11207/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11207","id":97138244,"number":11207,"title":"Some query take very long time","user":{"login":"pma-import","id":13239178,"avatar_url":"https://avatars.githubusercontent.com/u/13239178?v=3","gravatar_id":"","url":"https://api.github.com/users/pma-import","html_url":"https://github.com/pma-import","followers_url":"https://api.github.com/users/pma-import/followers","following_url":"https://api.github.com/users/pma-import/following{/other_user}","gists_url":"https://api.github.com/users/pma-import/gists{/gist_id}","starred_url":"https://api.github.com/users/pma-import/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pma-import/subscriptions","organizations_url":"https://api.github.com/users/pma-import/orgs","repos_url":"https://api.github.com/users/pma-import/repos","events_url":"https://api.github.com/users/pma-import/events{/privacy}","received_events_url":"https://api.github.com/users/pma-import/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2015-04-08T12:21:12Z","updated_at":"2015-07-29T10:56:14Z","closed_at":null,"body":"Hi, some query, like a simple Select * from TABLE GROUP BY Fields1,Fields2 take like 3-4 minutes to show, when it show up it write \"Showing rows ... Query took 0.0418 seconds.)\"\n\nif I enable \"profiling\" on this query, I got errors:\n\nNotice in ./libraries/sql.lib.php#420\nUndefined index: time\n\nBacktrace\n\n./libraries/sql.lib.php#345: PMA_analyzeAndGetTableHtmlForProfilingResults(array)\n./libraries/sql.lib.php#2033: PMA_getHtmlForProfilingChart(\nNULL,\nstring 'Dispatch_Mysql',\narray,\n)\n./libraries/sql.lib.php#2242: PMA_getQueryResponseForResultsReturned(\nobject,\narray,\nstring 'Dispatch_Mysql',\nstring 'TC_Horaire',\nNULL,\nNULL,\nobject,\nstring './themes/pmahomme/img/',\nstring '30',\ninteger 25,\nstring 'SELECT * FROM `TC_Horaire` GROUP BY Numero,Type LIMIT 0, 25 ',\nNULL,\nNULL,\narray,\nNULL,\nNULL,\nstring 'SELECT * FROM `TC_Horaire` GROUP BY Numero,Type',\nNULL,\n)\n./import.php#717: PMA_executeQueryAndGetQueryResponse(\narray,\nboolean false,\nstring 'Dispatch_Mysql',\nstring 'TC_Horaire',\nNULL,\nstring 'SELECT * FROM `TC_Horaire` GROUP BY Numero,Type ',\nNULL,\nboolean false,\nNULL,\nNULL,\nNULL,\nstring 'tbl_structure.php',\nstring './themes/pmahomme/img/',\nNULL,\nNULL,\nNULL,\nstring 'SELECT * FROM `TC_Horaire` GROUP BY Numero,Type ',\nNULL,\nNULL,\n)\n\n---\n* **Original URL**: https://sourceforge.net/p/phpmyadmin/bugs/4847/\n* **Original author**: jfdionne\n* **Found in version**: 4.4.1\n"},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/125918810","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11207#issuecomment-125918810","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11207","id":125918810,"user":{"login":"lem9","id":195509,"avatar_url":"https://avatars.githubusercontent.com/u/195509?v=3","gravatar_id":"","url":"https://api.github.com/users/lem9","html_url":"https://github.com/lem9","followers_url":"https://api.github.com/users/lem9/followers","following_url":"https://api.github.com/users/lem9/following{/other_user}","gists_url":"https://api.github.com/users/lem9/gists{/gist_id}","starred_url":"https://api.github.com/users/lem9/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lem9/subscriptions","organizations_url":"https://api.github.com/users/lem9/orgs","repos_url":"https://api.github.com/users/lem9/repos","events_url":"https://api.github.com/users/lem9/events{/privacy}","received_events_url":"https://api.github.com/users/lem9/received_events","type":"User","site_admin":false},"created_at":"2015-07-29T10:56:14Z","updated_at":"2015-07-29T10:56:14Z","body":"Asked jfdionne an export of the table's structure or better, of the data itself."}}