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