Resources

no query time
1 SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 0.0010261535644531
2 use official 0.00095915794372559
3 select * from tb_node a where vid = 'resources' and nid='98' 0.001086950302124
4 select * from tb_node a where vid='resources' and nid<'98' order by nid desc limit 1 0.0037531852722168
5 select * from tb_node a where vid='resources' and nid>'98' order by nid limit 1 0.0012991428375244
6 select * from tb_node a where vid='resources' and nid!='98' and (find_in_set('popinborder', tags)) order by nid limit 1 0.0011727809906006
total 0.0092973709106445