Database : Test - Table t1

SQL query :   Records 0-13/13  [Modify] [Explain SQL] [Update]
EXPLAIN
SELECT *
FROM 't1'
LIMIT 0 , 20

Truncated text   HTML
Query time: 0.14 msec.
addr opcode p1 p2 p3 p4 p5 comment
0 Init 0 22 0   00  
1 Integer 20 1 0   00  
2 Integer 0 2 0   00  
3 MustBeInt 2 0 0   00  
4 IfPos 2 6 0   00  
5 Integer 0 2 0   00  
6 Add 1 2 3   00  
7 IfPos 1 9 0   00  
8 Integer -1 3 0   00  
9 OpenRead 0 2 0 3 00  
10 Rewind 0 20 0   00  
11 AddImm 2 -1 0   00  
12 IfNeg 2 14 0   00  
13 Goto 0 19 0   00  
14 Rowid 0 4 0   00  
15 Column 0 1 5   00  
16 Column 0 2 6   00  
17 ResultRow 4 3 0   00  
18 IfZero 1 20 -1   00  
19 Next 0 11 0   01  
20 Close 0 0 0   00  
21 Halt 0 0 0   00  
22 Transaction 0 0 2 0 01  
23 TableLock 0 2 0 t1 00  
24 Goto 0 1 0   00  

 » Create a View with name from this query.