Resources

no query time
1 SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 0.0003211498260498
2 use official 0.00033903121948242
3 select * from tb_node a where vid = 'resources' and nid='98' 0.0005030632019043
4 select * from tb_node a where vid='resources' and nid<'98' order by nid desc limit 1 0.00052785873413086
5 select * from tb_node a where vid='resources' and nid>'98' order by nid limit 1 0.00058507919311523
6 select * from tb_node a where vid='resources' and nid!='98' and (find_in_set('popinborder', tags)) order by nid limit 1 0.00050497055053711
total 0.0027811527252197