+----------------------------------------------------------+
|                   QUERY 1 (4.0313 sec)                   |
+----------------------------------------------------------+
SELECT * FROM (SELECT * FROM news ORDER BY id DESC) AS x...

__ Overall stats ___________________________________________
   Elapsed time                              4.031
   Data into server                        102
   Data out of server                      158
   Optimizer cost                       324944.999

__ Table and index accesses ________________________________
   Table locks acquired                      1
   Table scans                               2
     Join                                    0
   Index range scans                         0
     Join without check                      0
     Join with check                         0
   Rows sorted                         1299743
     Range sorts                             0
     Merge passes                           52
     Table scans                             2

__ Row operations ____________________ Handler _____________
   Reads                               2599492
     Fixed pos (might be sort)               3
     Next row (table scan)             2599489
     Bookmark lookup                         0
     First in index (full scan?)             0
     Next in index                           0
     Prev in index                           0
   Writes
     Delete                                  0
     Update                                  0
     Insert                            2599480
     Commit                                  0

+----------------------------------------------------------+
|                   QUERY 2 (0.9532 sec)                   |
+----------------------------------------------------------+
SELECT * FROM news JOIN (SELECT MAX(id) AS id FROM news...

__ Overall stats ___________________________________________
   Elapsed time                              0.953
   Data into server                        162
   Data out of server                      243
   Optimizer cost                           16.749

__ Table and index accesses ________________________________
   Table locks acquired                      2
   Table scans                               2
     Join                                    0
   Index range scans                         0
     Join without check                      0
     Join with check                         0
   Rows sorted                               6
     Range sorts                             0
     Merge passes                            0
     Table scans                             2

__ Row operations ____________________ Handler _____________
   Reads                               2599504
     Fixed pos (might be sort)               6
     Next row (table scan)             1299755
     Bookmark lookup                   1299743
     First in index (full scan?)             0
     Next in index                           0
     Prev in index                           0
   Writes
     Delete                                  0
     Update                            1299735
     Insert                                 11
     Commit                                  0

+----------------------------------------------------------+
|                         SUMMARY                          |
+----------------------------------------------------------+

__ Overall stats ___________________________________________
   Total elapsed time                        4.984
   Questions                                 2
     COMMIT                                  0
     DELETE                                  0
     DELETE MULTI                            0
     INSERT                                  0
     INSERT SELECT                           0
     REPLACE                                 0
     REPLACE SELECT                          0
     SELECT                                  2
     UPDATE                                  0
     UPDATE MULTI                            0
   Data into server                        264
   Data out of server                      401
   Optimizer cost                       324961.748

__ Table and index accesses ________________________________
   Table locks acquired                      3
   Table scans                               4
     Join                                    0
   Index range scans                         0
     Join without check                      0
     Join with check                         0
   Rows sorted                         1299749
     Range sorts                             0
     Merge passes                           52
     Table scans                             4

__ Row operations ____________________ Handler _____________
   Reads                               5198996
     Fixed pos (might be sort)               9
     Next row (table scan)             3899244
     Bookmark lookup                   1299743
     First in index (full scan?)             0
     Next in index                           0
     Prev in index                           0
   Writes
     Delete                                  0
     Update                            1299735
     Insert                            2599491
     Commit                                  0