Resources

no query time
1 SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 0.0010130405426025
2 use official 0.0010411739349365
3 select * from tb_node a where vid = 'resources' and nid='98' 0.0011858940124512
4 select * from tb_node a where vid='resources' and nid<'98' order by nid desc limit 1 0.0036201477050781
5 select * from tb_node a where vid='resources' and nid>'98' order by nid limit 1 0.0012359619140625
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.0092689990997314