+----------------------------------------------------------+
| QUERY 2 (0.8769 sec) |
+----------------------------------------------------------+
SELECT * FROM news JOIN (SELECT MAX(id) AS id FROM news...
__ Overall stats ___________________________________________
Elapsed time 0.877
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 1299764
Fixed pos (might be sort) 6
Next row (table scan) 14
Bookmark lookup 3
First in index (full scan?) 1
Next in index 1299740
Prev in index 0
Writes
Delete 0
Update 0
Insert 11
Commit 0