Have the following MySQL question, prawns, many advice please, thank you!

1. In addition to SQL Profiling can capture the SQL for IO, CPU use with duration, how slight MySQL query in a certain period of IO, more statements occupy more resources such as CPU usage statement and the statement of IO, CPU used as duration?
2. If there was any better optimization tool for MySQL statement gives optimization advice?