1. system 2. const 3. eq_ref 4. ref 5. fulltext 6. ref_or_null, 7. unique_subquery 8. index subquery 9. range 10. index_merge 11. index 12. all