1502
1502
ON t4.carrier = t1.carrier;
1503
1503
id select_type table type possible_keys key key_len ref rows Extra
1504
1504
1 SIMPLE t1 ALL PRIMARY NULL NULL NULL 36
1506
1506
1 SIMPLE t5 ref carrier_id carrier_id 5 test.t4.id 1 Using index
1507
1507
1 SIMPLE t2 ref package_id package_id 5 test.t1.id 1 Using index
1508
1508
1 SIMPLE t3 ref package_id package_id 5 test.t1.id 1 Using index