OLD | NEW |
1 # 2014-06-17 | 1 # 2014-06-17 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #************************************************************************* | 10 #************************************************************************* |
(...skipping 251 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
262 WHERE | 262 WHERE |
263 t1.ptime > 1393520400 | 263 t1.ptime > 1393520400 |
264 AND param3<>9001 | 264 AND param3<>9001 |
265 AND t3.flg7 = 1 | 265 AND t3.flg7 = 1 |
266 AND t1.did = t2.did | 266 AND t1.did = t2.did |
267 AND t2.uid = t3.uid | 267 AND t2.uid = t3.uid |
268 ORDER BY t1.ptime desc LIMIT 500; | 268 ORDER BY t1.ptime desc LIMIT 500; |
269 } {0 0 2 {SEARCH TABLE t1 USING INDEX t1x1 (ptime>?)} 0 1 1 {SEARCH TABLE t2 USI
NG INDEX t2x0 (did=?)} 0 2 0 {SEARCH TABLE t3 USING INDEX t3x0 (uid=?)}} | 269 } {0 0 2 {SEARCH TABLE t1 USING INDEX t1x1 (ptime>?)} 0 1 1 {SEARCH TABLE t2 USI
NG INDEX t2x0 (did=?)} 0 2 0 {SEARCH TABLE t3 USING INDEX t3x0 (uid=?)}} |
270 | 270 |
271 finish_test | 271 finish_test |
OLD | NEW |