SQL performance tuning advice

[Oliver C]

Hi,

I'm looking for some general advice regarding performance tuning of SQL queries on MySQL 5.7. I'm looking at MySQL Workbench currently and cannot understand the timing figures on High Cost SQL Statements -> Statement Analysis where the various "time" columns show up as (us). Is it possible to change this to milliseconds?
Is it possible to use Workbench to show the execution plans for some of these long running queries?
Is it possible to use Workbench to give advice on how to improve the SQL statements, if its possibly missing an index, etc. I'm thinking along the lines of what the SQL tuning advisor that Oracle RDBMS provides.

Any other general advice on performance tuning on MySQL 5.7 would be greatly appreciated. Any tools you've used would be helpful.

Thanks,
OC