| no | query | time |
|---|---|---|
| 1 | SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' | 0.0003359317779541 |
| 2 | use official | 0.00033187866210938 |
| 3 | select * from tb_node a where vid = 'resources' and (find_in_set('lotteon', tags)) order by sticker, nid desc limit 0, 20 | 0.00076603889465332 |
| 4 | select count(*) from tb_node a where vid = 'resources' and (find_in_set('lotteon', tags)) order by sticker, nid desc | 0.00048494338989258 |
| total | 0.0019187927246094 |