a:5:{i:0;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:7:"PRIMARY";s:5:"table";s:1:"n";s:4:"type";s:3:"ALL";s:13:"possible_keys";s:7:"PRIMARY";s:3:"key";N;s:7:"key_len";N;s:3:"ref";N;s:4:"rows";s:1:"4";s:5:"Extra";s:44:"Using where; Using temporary; Using filesort";}i:1;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:7:"PRIMARY";s:5:"table";s:2:"cc";s:4:"type";s:3:"ALL";s:13:"possible_keys";N;s:3:"key";N;s:7:"key_len";N;s:3:"ref";N;s:4:"rows";s:1:"4";s:5:"Extra";s:30:"Using where; Using join buffer";}i:2;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:7:"PRIMARY";s:5:"table";s:2:"nl";s:4:"type";s:6:"eq_ref";s:13:"possible_keys";s:7:"PRIMARY";s:3:"key";s:7:"PRIMARY";s:7:"key_len";s:1:"8";s:3:"ref";s:48:"ChallengerprestaV2017.n.id_prestablog_news,const";s:4:"rows";s:1:"1";s:5:"Extra";s:11:"Using where";}i:3;a:10:{s:2:"id";s:1:"3";s:11:"select_type";s:18:"DEPENDENT SUBQUERY";s:5:"table";s:29:"ps_prestablog_categorie_group";s:4:"type";s:3:"ALL";s:13:"possible_keys";N;s:3:"key";N;s:7:"key_len";N;s:3:"ref";N;s:4:"rows";s:1:"3";s:5:"Extra";s:11:"Using where";}i:4;a:10:{s:2:"id";s:1:"2";s:11:"select_type";s:18:"DEPENDENT SUBQUERY";s:5:"table";s:2:"cn";s:4:"type";s:3:"ALL";s:13:"possible_keys";N;s:3:"key";N;s:7:"key_len";N;s:3:"ref";N;s:4:"rows";s:1:"5";s:5:"Extra";s:11:"Using where";}}