Made for rule-of-thumb; you need to understand SQL well to modify these queries for your own taste.
SET @@profiling=1; SET @@profiling_history_size = 100;
general list: SHOW profiles; get query time: SELECT sum(duration) from information_schema.profiling where query_id=<query id from 'profiles'>; Exact details on query: SHOW profile for query 1;
SET @@profiling = 0; SET @@profiling_history_size = 0;