title: How do I see high-precision query times in mysql command line?
body: <p>I'm working through some optimization work, and I've noticed that in some mysql dumps people post in articles and questions (which I cannot find again now that I'm actually looking), there are high-precision execution times (0.05985215  sec instead of 0.06 sec).</p>
  
  <p>How can I see these more precise times for my queries on the command line?</p>
  
  <p>EDIT</p>
  
  <p>Example of this is:</p>
  
  <pre><code>+----------+
  | COUNT(*) |
  +----------+
  | 11596    |
  +----------+
  1 row in set (0.05894344 sec)
  </code></pre>
  
  <p>Using profiling gets me part of the way there, but produces an output too long, and I have to remember to enable it. I am just looking for a simple high-precision duration.</p>
  
  <pre><code>SET profiling = 1;
  &lt;query&gt;
  SHOW PROFILES;
  </code></pre>
  
  <p>Gives me something like this:</p>
  
  <pre><code>+----------------------+-----------+
  | Status               | Duration  |
  +----------------------+-----------+
  | (initialization)     | 0.000005  |
  | checking permissions | 0.00001   |
  | Opening tables       | 0.000499  |
  | Table lock           | 0.000071  |
  | preparing            | 0.000018  |
  | Creating tmp table   | 0.00002   |
  | executing            | 0.000006  |
  | Copying to tmp table | 6.565327  |
  | Sorting result       | 0.000431  |
  | Sending data         | 0.006204  |
  | query end            | 0.000007  |
  | freeing items        | 0.000028  |
  | closing tables       | 0.000015  |
  | logging slow query   | 0.000005  |
  +----------------------+-----------+
  14 rows in set (0.00 sec)
  </code></pre>