Resources

no query time
1 SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 0.00098800659179688
2 use official 0.0010130405426025
3 select * from tb_node a where vid = 'resources' and nid='98' 0.001140832901001
4 select * from tb_node a where vid='resources' and nid<'98' order by nid desc limit 1 0.0012519359588623
5 select * from tb_node a where vid='resources' and nid>'98' order by nid limit 1 0.0010881423950195
6 select * from tb_node a where vid='resources' and nid!='98' and (find_in_set('popinborder', tags)) order by nid limit 1 0.0012149810791016
total 0.0066969394683838