SELECT c.id, c.name, c.slug, s.id, s.name, s.slug, b.id, b.name, b.slug, b.location
FROM bank bs
INNER JOIN branch b ON b.bank_id = bs.id
INNER JOIN city c ON c.id = b.city_id
INNER JOIN state s ON s.id = c.state_id
WHERE bs.slug = 'wells-fargo-bank'
ORDER BY c.name, b.name
LIMIT 50


--

"id"    "select_type"   "table" "partitions"    "type"  "possible_keys" "key"   "key_len"   "ref"   "rows"  "filtered"  "Extra"
"1" "SIMPLE"    "bs"    \t  "ref"   "PRIMARY,slug"  "slug"  "767"   "const" "1" "100,00"    "Using index; Using temporary; Using filesort"
"1" "SIMPLE"    "b" \t  "ref"   "location_bank_fk_idx,location_city_fk_idx" "location_bank_fk_idx"  "4" "banks.bs.id"   "17"    "100,00"    \t
"1" "SIMPLE"    "c" \t  "eq_ref"    "PRIMARY,city_state_fk" "PRIMARY"   "8" "banks.b.city_id"   "1" "100,00"    \t
"1" "SIMPLE"    "s" \t  "eq_ref"    "PRIMARY"   "PRIMARY"   "4" "banks.c.state_id"  "1" "100,00"    \t