| no | query | time |
|---|---|---|
| 1 | SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' | 0.00023198127746582 |
| 2 | use official | 0.00034999847412109 |
| 3 | select * from tb_node a where vid = 'resources' and (find_in_set('loyalty', tags)) order by sticker, nid desc limit 0, 20 | 0.0019590854644775 |
| 4 | select count(*) from tb_node a where vid = 'resources' and (find_in_set('loyalty', tags)) order by sticker, nid desc | 0.0009310245513916 |
| total | 0.0034720897674561 |