Anonymous
public text v1 · immutable
+----------------------------------------------------------+
| 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