Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
