with_order.txt

mysql> show profile;
+--------------------------------+----------+
| Status                         | Duration |
+--------------------------------+----------+
| starting                       | 0.000014 |
| Waiting for query cache lock   | 0.000002 |
| checking query cache for query | 0.000068 |
| checking permissions           | 0.000002 |
| checking permissions           | 0.000001 |
| checking permissions           | 0.000001 |
| checking permissions           | 0.000003 |
| Opening tables                 | 0.000112 |
| System lock                    | 0.000009 |
| Waiting for query cache lock   | 0.000031 |
| init                           | 0.000008 |
| checking permissions           | 0.000002 |
| checking permissions           | 0.000001 |
| checking permissions           | 0.000001 |
| checking permissions           | 0.000001 |
| checking permissions           | 0.000045 |
| optimizing                     | 0.000020 |
| statistics                     | 0.000131 |
| preparing                      | 0.000028 |
| Creating tmp table             | 0.000026 |
| executing                      | 0.000001 |
| Copying to tmp table           | 0.130601 |
| Sorting result                 | 0.003861 |
| Sending data                   | 0.000047 |
| end                            | 0.000002 |
| removing tmp table             | 0.002758 |
| end                            | 0.000004 |
| query end                      | 0.000004 |
| closing tables                 | 0.000015 |
| freeing items                  | 0.000014 |
| Waiting for query cache lock   | 0.000002 |
| freeing items                  | 0.000019 |
| Waiting for query cache lock   | 0.000003 |
| freeing items                  | 0.000001 |
| storing result in query cache  | 0.000002 |
| logging slow query             | 0.000001 |
| cleaning up                    | 0.000008 |
+--------------------------------+----------+
37 rows in set (0.00 sec)

without_order.txt

mysql> show profile;
+--------------------------------+----------+
| Status                         | Duration |
+--------------------------------+----------+
| starting                       | 0.000014 |
| Waiting for query cache lock   | 0.000002 |
| checking query cache for query | 0.000065 |
| checking permissions           | 0.000002 |
| checking permissions           | 0.000000 |
| checking permissions           | 0.000001 |
| checking permissions           | 0.000003 |
| Opening tables                 | 0.000109 |
| System lock                    | 0.000009 |
| Waiting for query cache lock   | 0.000033 |
| init                           | 0.000004 |
| checking permissions           | 0.000001 |
| checking permissions           | 0.000001 |
| checking permissions           | 0.000001 |
| checking permissions           | 0.000001 |
| checking permissions           | 0.000043 |
| optimizing                     | 0.000021 |
| statistics                     | 0.000146 |
| preparing                      | 0.000033 |
| executing                      | 0.000002 |
| Sending data                   | 0.000312 |
| end                            | 0.000003 |
| query end                      | 0.000003 |
| closing tables                 | 0.000008 |
| freeing items                  | 0.000007 |
| Waiting for query cache lock   | 0.000001 |
| freeing items                  | 0.000006 |
| Waiting for query cache lock   | 0.000001 |
| freeing items                  | 0.000001 |
| storing result in query cache  | 0.000002 |
| logging slow query             | 0.000001 |
| cleaning up                    | 0.000002 |
+--------------------------------+----------+
32 rows in set (0.00 sec)