grup 
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:31:09' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:31:23' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:31:38' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:31:53' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:32:08' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:32:23' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:32:38' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:32:53' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:33:08' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:33:23' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:33:38' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:33:53' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:34:08' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:34:23' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:34:38' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:35:18' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:35:23' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:35:38' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:35:53' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:36:08' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:36:23' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','3043','2953','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','3172','356078118085444','3071','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:30:16' AND '2025-02-01 00:36:38' ORDER BY g.`time` DESC LIMIT 500
grup 
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2025-01-31 23:54:23' AND '2025-02-01 00:55:16' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2025-01-31 23:54:23' AND '2025-02-01 00:55:30' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2756','356078111430936','3176','356078116305406','352353086157176','3135','356078111473761','3057','3238','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2953','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:54:23' AND '2025-02-01 00:55:45' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2756','356078111430936','3176','356078116305406','352353086157176','3135','356078111473761','3057','3238','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2953','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:54:23' AND '2025-02-01 00:56:00' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2756','356078111430936','3176','356078116305406','352353086157176','3135','356078111473761','3057','3238','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2953','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:54:23' AND '2025-02-01 00:56:15' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2756','356078111430936','3176','356078116305406','352353086157176','3135','356078111473761','3057','3238','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2953','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:54:23' AND '2025-02-01 00:56:30' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2756','356078111430936','3176','356078116305406','352353086157176','3135','356078111473761','3057','3238','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2953','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:54:23' AND '2025-02-01 00:56:45' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2756','356078111430936','3176','356078116305406','352353086157176','3135','356078111473761','3057','3238','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2953','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:54:23' AND '2025-02-01 00:57:00' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('352353086155659','353173060488028','3155','2485','353173060485131','2756','356078111430936','3176','356078116305406','352353086157176','3135','356078111473761','3057','3238','3025','352353083439767','2790','356078111347361','2883','3055','353173060512918','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2953','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353084102240','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-31 23:54:23' AND '2025-02-01 00:57:15' ORDER BY g.`time` DESC LIMIT 500
grup 
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:11:46' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:12:00' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:12:15' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:12:30' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:12:45' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:13:00' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:13:15' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:13:30' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:13:45' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:14:00' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:14:15' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:14:30' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:14:45' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:15:00' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:15:15' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:15:30' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:15:45' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:16:00' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:16:15' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:16:30' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:16:45' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:17:00' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:17:15' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:17:30' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('9011','354836080392664','356078111353955','356078116292406','356078116291663','2689','354836080121006','2769','2874','2966','5080','2535','9378','354836080168387','356078118139753','352353084234167','3263','5082','2510','352353085645312','2725','862531041050148','2844','2633','2706','4959','352353084149035','352353086184659','352353083471786','862531041069957','2971','862531041041535','3063','3175','2665','2866','356078116474855','356078116291713','2590','2585','358021081941837','2846','2494','864866053465679','3147','355234055304584','3061','2889','353173060488002','3072','2728','352353083338704','2611','352353084146585','2495','2676','356078111277071','356078111445637','2950','352353084652467','352353084291100','2888','2597','354836080627978')
	AND g.`time` BETWEEN '2025-02-01 10:10:45' AND '2025-02-01 10:17:45' ORDER BY g.`time` DESC LIMIT 500
grup 
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:51:43' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:51:57' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:52:12' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:52:27' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:52:42' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:52:57' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:53:12' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:53:27' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:53:42' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:53:57' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:54:18' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:54:27' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:54:42' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:54:57' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','352353084175477','3090','354836080120826','3166','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 10:50:45' AND '2025-02-01 10:55:12' ORDER BY g.`time` DESC LIMIT 500
grup 
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:31:11' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:31:25' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:31:40' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:31:55' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:32:10' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:32:25' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:32:40' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:32:55' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:33:10' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:33:25' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:33:40' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:33:55' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:34:10' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:34:25' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:34:40' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:34:55' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('355234055581363','5046','2736','356078116278207','3161','3059','3079','3056','3089','355234055221853','352353084175477','3090','354836080120826','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','352353083458635','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-02-01 19:30:12' AND '2025-02-01 19:35:10' ORDER BY g.`time` DESC LIMIT 500
grup 
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2025-02-01 19:01:31' AND '2025-02-01 20:02:26' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('')
	AND g.`time` BETWEEN '2025-02-01 19:01:31' AND '2025-02-01 20:02:40' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2025-02-01 19:01:31' AND '2025-02-01 20:02:55' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2025-02-01 19:01:31' AND '2025-02-01 20:03:10' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2025-02-01 19:01:31' AND '2025-02-01 20:03:25' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2025-02-01 19:01:31' AND '2025-02-01 20:03:40' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2025-02-01 19:01:31' AND '2025-02-01 20:03:55' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2025-02-01 19:01:31' AND '2025-02-01 20:04:10' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2025-02-01 19:01:31' AND '2025-02-01 20:04:25' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 2:0:0'), c.`car_name` FROM `tms_gpsdata_fixed` g
	INNER JOIN `wm_car_info` c ON g.`DeviceLoginName`= c.`imei`
	WHERE g.`DeviceLoginName` IN ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','3176','356078116305406','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','2456','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904')
	AND g.`time` BETWEEN '2025-02-01 19:01:31' AND '2025-02-01 20:04:40' ORDER BY g.`time` DESC LIMIT 500