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