Is there any manual for the visual explain in mysql? The output plan is unreadable Just like this example, I cannot even tell the join ordering from it. And what does "ALL" and "ref" in the table mean? Is there any manual about the visual explain?
ref evidently means a keyed lookup because the definition of ref in EXPLAIN is


  The ref column shows which columns or constants are compared to the index named in the key column to select rows from the table.


As for ALL, my guess is that refers to a full table scan because the same URL says


  A full table scan is done for each combination of rows from the previous tables. This is normally not good if the table is the first table not marked const, and usually very bad in all other cases. Normally, you can avoid ALL by adding indexes that enable row retrieval from the table based on constant values or column values from earlier tables.


In all honesty, I cannot tell what the ORDER BY is. You should try comparing that graph above to the text-based output from one of these:


pt-visual-explain (Documentation)
mk-visual-explain (Documentation)


and see if the JOIN ordering makes sense there.