The profiler (visual explain) of queries in MySQL workbench is a godsend.
Also, for general querying and table layout lookup in OSX (macOS, whatever) I recommend Sequel Pro. It has a slightly better UI when working with multiple databases (easier to switch).
The profiler (visual explain) of queries in MySQL workbench is a godsend.
Also, for general querying and table layout lookup in OSX (macOS, whatever) I recommend Sequel Pro. It has a slightly better UI when working with multiple databases (easier to switch).