id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE table2 NULL index store_id_table2 store_id_table2 8 NULL 6 50.00 Using index; LooseScan
1 SIMPLE table1 NULL eq_ref PRIMARY PRIMARY 8 db1.table2.store_id 1 100.00 NULL