a:4:{i:0;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:1:"c";s:4:"type";s:3:"ref";s:13:"possible_keys";s:32:"PRIMARY,activenleft,activenright";s:3:"key";s:11:"activenleft";s:7:"key_len";s:1:"1";s:3:"ref";s:5:"const";s:4:"rows";s:2:"10";s:5:"Extra";s:28:"Using index; Using temporary";}i:1;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:2:"cp";s:4:"type";s:3:"ref";s:13:"possible_keys";s:30:"PRIMARY,id_product,id_category";s:3:"key";s:11:"id_category";s:7:"key_len";s:1:"4";s:3:"ref";s:35:"ChallengerprestaV2017.c.id_category";s:4:"rows";s:2:"26";s:5:"Extra";s:11:"Using index";}i:2;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:12:"product_shop";s:4:"type";s:6:"eq_ref";s:13:"possible_keys";s:15:"PRIMARY,indexed";s:3:"key";s:7:"PRIMARY";s:7:"key_len";s:1:"8";s:3:"ref";s:41:"ChallengerprestaV2017.cp.id_product,const";s:4:"rows";s:1:"1";s:5:"Extra";s:21:"Using where; Distinct";}i:3;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:1:"p";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:"4";s:3:"ref";s:45:"ChallengerprestaV2017.product_shop.id_product";s:4:"rows";s:1:"1";s:5:"Extra";s:34:"Using where; Using index; Distinct";}}