Resources

no query time
1 SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 0.0011100769042969
2 use official 0.0010449886322021
3 select * from tb_node a where vid = 'resources' and nid='98' 0.0007479190826416
4 select * from tb_node a where vid='resources' and nid<'98' order by nid desc limit 1 0.0073661804199219
5 select * from tb_node a where vid='resources' and nid>'98' order by nid limit 1 0.0098910331726074
6 select * from tb_node a where vid='resources' and nid!='98' and (find_in_set('popinborder', tags)) order by nid limit 1 0.0039122104644775
total 0.024072408676147