0|Trace|0|0|0|explain SELECT * FROM messages INNER JOIN messagesText ON messages.id = messagesText.rowid WHERE id IN (SELECT docid FROM messagesText WHERE subject MATCH "sutherland") AND deleted = 0 AND folderID IS NOT NULL AND messageKey IS NOT NULL ORDER BY date DESC LIMIT 100;|00|
1|OpenEphemeral|3|3|0|keyinfo(1,-BINARY)|00|
2|Integer|100|1|0||00|
3|MustBeInt|1|0|0||00|LIMIT counter
4|IfZero|1|100|0||00|
5|Integer|0|2|0||00|
6|Goto|0|101|0||00|
7|SetNumColumns|0|8|0||00|
8|OpenRead|0|13|0||00|messages
9|SetNumColumns|0|2|0||00|
10|OpenRead|4|24|0|keyinfo(1,BINARY)|00|deleted
11|VOpen|1|0|0|vtab:1771798:7FCEA46A3100|00|
12|IsNull|2|77|0||00|
13|Affinity|2|1|0|db|00|
14|SeekGe|4|77|2|1|00|
15|IdxGE|4|77|2|1|01|
16|IdxRowid|4|3|0||00|
17|Seek|0|3|0||00|
18|Noop|0|0|0||00|begin IN expr r3
19|If|5|33|0||00|
20|Integer|1|5|0||00|
21|Null|0|4|0||00|
22|OpenEphemeral|6|1|0|keyinfo(1,BINARY)|00|
23|VOpen|2|0|0|vtab:1771798:7FCEA46A3100|00|
24|String8|0|8|0|sutherland|00|
25|Integer|2|6|0||00|
26|Integer|1|7|0||00|
27|VFilter|2|32|6||00|
28|VColumn|2|4|9||00|messagesText.docid
29|MakeRecord|9|1|10|c|00|
30|IdxInsert|6|10|0||00|
31|VNext|2|28|0||00|
32|Close|2|0|0||00|
33|IdxRowid|4|3|0||00|
34|IsNull|3|44|0||00|
35|MakeRecord|3|1|10|c|00|
36|Integer|1|3|0||00|
37|Found|6|44|10||00|
38|NotNull|4|43|0||00|
39|Null|0|11|0||00|
40|Blob|2|4|0||00|
41|Found|6|43|4||00|
42|Integer|0|11|0||00|
43|Copy|11|3|0||00|end IN expr r3
44|IfNot|3|76|1||00|
45|Column|0|1|3||00|messages.folderID
46|IsNull|3|76|0||00|
47|Column|0|2|3||00|messages.messageKey
48|IsNull|3|76|0||00|
49|IdxRowid|4|8|0||00|
50|Integer|1|6|0||00|
51|Integer|1|7|0||00|
52|VFilter|1|76|6||00|
53|IdxRowid|4|12|0||00|
54|Column|0|1|13||00|messages.folderID
55|Column|0|2|14||00|messages.messageKey
56|Column|0|3|15||00|messages.conversationID
57|Column|0|4|16||00|messages.date
58|Column|0|5|17||00|messages.headerMessageID
59|Column|4|0|18|0|00|messages.deleted
60|Column|0|7|19||00|messages.jsonAttributes
61|VColumn|1|0|20||00|messagesText.subject
62|VColumn|1|1|21||00|messagesText.body
63|VColumn|1|2|22||00|messagesText.attachmentNames
64|MakeRecord|12|11|3||00|
65|SCopy|16|6|0||00|
66|Sequence|3|7|0||00|
67|Move|3|8|1||00|
68|MakeRecord|6|3|10||00|
69|IdxInsert|3|10|0||00|
70|IfZero|1|73|0||00|
71|AddImm|1|-1|0||00|
72|Goto|0|75|0||00|
73|Last|3|0|0||00|
74|Delete|3|0|0||00|
75|VNext|1|53|0||00|
76|Next|4|15|0||00|
77|Close|0|0|0||00|
78|Close|4|0|0||00|
79|Close|1|0|0||00|
80|SetNumColumns|0|11|0||00|
81|OpenPseudo|7|1|0||00|
82|Sort|3|99|0||00|
83|Column|3|2|3||00|
84|Integer|1|10|0||00|
85|Insert|7|3|10||00|
86|Column|7|0|12||00|
87|Column|7|1|13||00|
88|Column|7|2|14||00|
89|Column|7|3|15||00|
90|Column|7|4|16||00|
91|Column|7|5|17||00|
92|Column|7|6|18||00|
93|Column|7|7|19||00|
94|Column|7|8|20||00|
95|Column|7|9|21||00|
96|Column|7|10|22||00|
97|ResultRow|12|11|0||00|
98|Next|3|83|0||00|
99|Close|7|0|0||00|
100|Halt|0|0|0||00|
101|Transaction|0|0|0||00|
102|VerifyCookie|0|31|0||00|
103|TableLock|0|13|0|messages|00|
104|Goto|0|7|0||00|