a:9:{i:0;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:2:"pa";s:4:"type";s:3:"ref";s:13:"possible_keys";s:81:"PRIMARY,product_default,product_attribute_product,id_product_id_product_attribute";s:3:"key";s:15:"product_default";s:7:"key_len";s:1:"4";s:3:"ref";s:5:"const";s:4:"rows";s:2:"95";s:5:"Extra";s:31:"Using temporary; Using filesort";}i:1;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:5:"stock";s:4:"type";s:6:"eq_ref";s:13:"possible_keys";s:70:"product_sqlstock,id_shop,id_shop_group,id_product,id_product_attribute";s:3:"key";s:16:"product_sqlstock";s:7:"key_len";s:2:"16";s:3:"ref";s:22:"const,func,const,const";s:4:"rows";s:1:"1";s:5:"Extra";s:0:"";}i:2;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:22:"product_attribute_shop";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:51:"ChallengerprestaV2017.pa.id_product_attribute,const";s:4:"rows";s:1:"1";s:5:"Extra";s:0:"";}i:3;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:3:"pac";s:4:"type";s:3:"ref";s:13:"possible_keys";s:28:"PRIMARY,id_product_attribute";s:3:"key";s:20:"id_product_attribute";s:7:"key_len";s:1:"4";s:3:"ref";s:65:"ChallengerprestaV2017.product_attribute_shop.id_product_attribute";s:4:"rows";s:1:"1";s:5:"Extra";s:24:"Using where; Using index";}i:4;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:14:"attribute_shop";s:4:"type";s:6:"eq_ref";s:13:"possible_keys";s:15:"PRIMARY,id_shop";s:3:"key";s:7:"PRIMARY";s:7:"key_len";s:1:"8";s:3:"ref";s:44:"ChallengerprestaV2017.pac.id_attribute,const";s:4:"rows";s:1:"1";s:5:"Extra";s:11:"Using index";}i:5;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:3:"agl";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:"8";s:5:"Extra";s:30:"Using where; Using join buffer";}i:6;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:2:"ag";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:44:"ChallengerprestaV2017.agl.id_attribute_group";s:4:"rows";s:1:"1";s:5:"Extra";s:11:"Using where";}i:7;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:1:"a";s:4:"type";s:6:"eq_ref";s:13:"possible_keys";s:23:"PRIMARY,attribute_group";s:3:"key";s:7:"PRIMARY";s:7:"key_len";s:1:"4";s:3:"ref";s:49:"ChallengerprestaV2017.attribute_shop.id_attribute";s:4:"rows";s:1:"1";s:5:"Extra";s:11:"Using where";}i:8;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:6:"SIMPLE";s:5:"table";s:2:"al";s:4:"type";s:6:"eq_ref";s:13:"possible_keys";s:15:"PRIMARY,id_lang";s:3:"key";s:7:"PRIMARY";s:7:"key_len";s:1:"8";s:3:"ref";s:55:"ChallengerprestaV2017.attribute_shop.id_attribute,const";s:4:"rows";s:1:"1";s:5:"Extra";s:11:"Using where";}}