sqlite> explain SELECT Date, Direction, Message, Variant, Type, RichMessage, EscapePolicy FROM azoth_history WHERE Id = 452 AND AccountID = 1 ORDER BY RowID DESC LIMIT 50 OFFSET 0;
0|Init|0|54|0||00|
1|OpenEphemeral|1|3|0|k(1,-B)|00|
2|Integer|50|1|0||00|
3|Integer|0|2|0||00|
4|MustBeInt|2|0|0||00|
5|IfPos|2|7|0||00|
6|Integer|0|2|0||00|
7|Add|1|2|3||00|
8|IfPos|1|10|0||00|
9|Integer|-1|3|0||00|
10|OpenRead|0|6|0|9|00|
11|OpenRead|2|7|0|k(8,nil,nil,nil,nil,nil,nil)|00|
12|Integer|452|4|0||00|
13|Integer|1|5|0||00|
14|SeekGE|2|37|4|2|00|
15|IdxGT|2|37|4|2|00|
16|IdxRowid|2|6|0||00|
17|Seek|0|6|0||00|
18|Column|2|2|7||00|
19|Column|2|3|8||00|
20|Column|2|4|9||00|
21|Column|2|5|10||00|
22|Column|2|6|11||00|
23|Column|0|7|12||00|
24|Column|0|8|13||00|
25|MakeRecord|7|7|14||00|
26|IdxRowid|2|16|0||00|
27|Sequence|1|17|0||00|
28|Move|14|18|1||00|
29|MakeRecord|16|3|15||00|
30|IdxInsert|1|15|0||00|
31|IfZero|3|34|0||00|
32|AddImm|3|-1|0||00|
33|Goto|0|36|0||00|
34|Last|1|0|0||00|
35|Delete|1|0|0||00|
36|Next|2|15|0||00|
37|Close|0|0|0||00|
38|Close|2|0|0||00|
39|OpenPseudo|3|14|7||00|
40|Sort|1|53|0||00|
41|IfNeg|2|43|-1||00|
42|Goto|0|52|0||00|
43|Column|1|2|14||00|
44|Column|3|0|7||20|
45|Column|3|1|8||00|
46|Column|3|2|9||00|
47|Column|3|3|10||00|
48|Column|3|4|11||00|
49|Column|3|5|12||00|
50|Column|3|6|13||00|
51|ResultRow|7|7|0||00|
52|Next|1|41|0||00|
53|Halt|0|0|0||00|
54|Transaction|0|0|15|0|01|
55|TableLock|0|6|0|azoth_history|00|
56|Goto|0|1|0||00|
sqlite> explain SELECT Date, Direction, Message, Variant, Type, RichMessage, EscapePolicy FROM azoth_history NOT INDEXED WHERE Id = 452 AND AccountID = 1 ORDER BY RowID DESC LIMIT 50 OFFSET 0;
0|Init|0|30|0||00|
1|Noop|0|0|0||00|
2|Integer|50|1|0||00|
3|Integer|0|2|0||00|
4|MustBeInt|2|0|0||00|
5|IfPos|2|7|0||00|
6|Integer|0|2|0||00|
7|Add|1|2|3||00|
8|IfPos|1|10|0||00|
9|Integer|-1|3|0||00|
10|OpenRead|0|6|0|9|00|
11|Last|0|28|0||00|
12|Column|0|0|4||00|
13|Ne|5|27|4|(BINARY)|6c|
14|Column|0|1|6||00|
15|Ne|7|27|6|(BINARY)|6c|
16|IfNeg|2|18|-1||00|
17|Goto|0|27|0||00|
18|Column|0|2|8||00|
19|Column|0|3|9||00|
20|Column|0|4|10||00|
21|Column|0|5|11||00|
22|Column|0|6|12||00|
23|Column|0|7|13||00|
24|Column|0|8|14||00|
25|ResultRow|8|7|0||00|
26|IfZero|1|28|-1||00|
27|Prev|0|12|0||01|
28|Close|0|0|0||00|
29|Halt|0|0|0||00|
30|Transaction|0|0|15|0|01|
31|TableLock|0|6|0|azoth_history|00|
32|Integer|452|5|0||00|
33|Integer|1|7|0||00|
34|Goto|0|1|0||00|