client side time bug clear and sql optimization

tooltip add gps indicator