Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- *************************** 1. row ***************************
- id: 1
- select_type: SIMPLE
- table: c
- type: ALL
- possible_keys: PRIMARY,city_state_fk
- key: NULL
- key_len: NULL
- ref: NULL
- rows: 1
- Extra: Using temporary; Using filesort
- *************************** 2. row ***************************
- id: 1
- select_type: SIMPLE
- table: s
- type: eq_ref
- possible_keys: PRIMARY
- key: PRIMARY
- key_len: 4
- ref: banks.c.state_id
- rows: 1
- Extra:
- *************************** 3. row ***************************
- id: 1
- select_type: SIMPLE
- table: br
- type: ref
- possible_keys: location_city_fk_idx,location_bank_fk_idx
- key: location_city_fk_idx
- key_len: 8
- ref: banks.c.id
- rows: 2
- Extra: Using where
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement