a:10:{i:0;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:7:"PRIMARY";s:5:"table";s:1:"p";s:4:"type";s:5:"range";s:13:"possible_keys";s:7:"PRIMARY";s:3:"key";s:7:"PRIMARY";s:7:"key_len";s:1:"4";s:3:"ref";N;s:4:"rows";s:3:"157";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:"pl";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:2:"12";s:3:"ref";s:46:"ChallengerprestaV2017.p.id_product,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:7:"PRIMARY";s:5:"table";s:12:"product_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:41:"ChallengerprestaV2017.pl.id_product,const";s:4:"rows";s:1:"1";s:5:"Extra";s:11:"Using where";}i:3;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:7:"PRIMARY";s:5:"table";s:22:"product_attribute_shop";s:4:"type";s:3:"ref";s:13:"possible_keys";s:10:"id_product";s:3:"key";s:10:"id_product";s:7:"key_len";s:2:"10";s:3:"ref";s:47:"ChallengerprestaV2017.pl.id_product,const,const";s:4:"rows";s:2:"16";s:5:"Extra";s:0:"";}i:4;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:7:"PRIMARY";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:52:"ChallengerprestaV2017.p.id_product,const,const,const";s:4:"rows";s:1:"1";s:5:"Extra";s:0:"";}i:5;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:7:"PRIMARY";s:5:"table";s:1:"m";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:39:"ChallengerprestaV2017.p.id_manufacturer";s:4:"rows";s:1:"1";s:5:"Extra";s:0:"";}i:6;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:7:"PRIMARY";s:5:"table";s:10:"image_shop";s:4:"type";s:3:"ref";s:13:"possible_keys";s:18:"id_product,id_shop";s:3:"key";s:10:"id_product";s:7:"key_len";s:2:"10";s:3:"ref";s:57:"ChallengerprestaV2017.product_shop.id_product,const,const";s:4:"rows";s:1:"1";s:5:"Extra";s:11:"Using index";}i:7;a:10:{s:2:"id";s:1:"1";s:11:"select_type";s:7:"PRIMARY";s:5:"table";s:2:"il";s:4:"type";s:6:"eq_ref";s:13:"possible_keys";s:16:"PRIMARY,id_image";s:3:"key";s:7:"PRIMARY";s:7:"key_len";s:1:"8";s:3:"ref";s:47:"ChallengerprestaV2017.image_shop.id_image,const";s:4:"rows";s:1:"1";s:5:"Extra";s:0:"";}i:8;a:10:{s:2:"id";s:1:"2";s:11:"select_type";s:18:"DEPENDENT SUBQUERY";s:5:"table";s:2:"si";s:4:"type";s:3:"ref";s:13:"possible_keys";s:18:"PRIMARY,id_product";s:3:"key";s:10:"id_product";s:7:"key_len";s:1:"4";s:3:"ref";s:4:"func";s:4:"rows";s:2:"31";s:5:"Extra";s:11:"Using where";}i:9;a:10:{s:2:"id";s:1:"2";s:11:"select_type";s:18:"DEPENDENT SUBQUERY";s:5:"table";s:2:"sw";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:"4";s:3:"ref";s:32:"ChallengerprestaV2017.si.id_word";s:4:"rows";s:1:"1";s:5:"Extra";s:11:"Using where";}}