How to get MariaDB (MySql) query time? I'm using MariaDB 10.1. How to get actual query time for all of executed query? It seems that SHOW PROFILES; was deprecated. Is there a better solution for database tuning?

Edit: It's deprecated only in MySQL 5.6.7.
Set long_query_time=0 and turn on the slowlog to a FILE (in my.cnf, and restart).  Then the slowlog will contain a variety of info about every command executed, including the query time.

You might also want to run pt-query-digest to summarize the slow log.  This will include min/max/avg/etc for each 'different' query.