id select table type possible_keys key key_len ref rows Extra ======================================================================================================================================== 1 SIMPLE tabdt0_ ALL tab_dt_bid 5 Using where 1 SIMPLE tabinf1_ eq_ref PRIMARY PRIMARY 8 tabdt0_.bid 1 Using index 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1 1 SIMPLE tab_fm ref PRIMARY,tab_fm_idx_1 tab_fm_idx_1 767 const 1 Using where; Using index 1 SIMPLE tab_str eq_ref PRIMARY,tab_str_idx_1 PRIMARY 16 tabdt0_.bid,tab_fm.id 1