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-25 22:02:27' AND '2025-01-25 23: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 ('')
	AND g.`time` BETWEEN '2025-01-25 22:02:27' AND '2025-01-25 23:04:24' 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','353173060485131','356078111430936','352353086157176','3135','356078111473761','3157','862531041080715','352353083439767','356078111347361','2883','3055','353173060512918','2677','3188','2785','862531041041642','355234055170423','2500','2665','354836080392292','3162','354836080405763','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-25 22:02:27' AND '2025-01-25 23:04:39' 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','353173060485131','356078111430936','352353086157176','3135','356078111473761','3157','862531041080715','352353083439767','356078111347361','2883','3055','353173060512918','2677','3188','2785','862531041041642','355234055170423','2500','2665','354836080392292','3162','354836080405763','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-25 22:02:27' AND '2025-01-25 23:04:59' 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','353173060485131','356078111430936','352353086157176','3135','356078111473761','3157','862531041080715','352353083439767','356078111347361','2883','3055','353173060512918','2677','3188','2785','862531041041642','355234055170423','2500','2665','354836080392292','3162','354836080405763','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-25 22:02:27' AND '2025-01-25 23:05: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 ('353173060488028','353173060485131','356078111430936','352353086157176','3135','356078111473761','3157','862531041080715','352353083439767','356078111347361','2883','3055','353173060512918','2677','3188','2785','862531041041642','355234055170423','2500','2665','354836080392292','3162','354836080405763','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-25 22:02:27' AND '2025-01-25 23:05:24' 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','353173060485131','356078111430936','352353086157176','3135','356078111473761','3157','862531041080715','352353083439767','356078111347361','2883','3055','353173060512918','2677','3188','2785','862531041041642','355234055170423','2500','2665','354836080392292','3162','354836080405763','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-25 22:02:27' AND '2025-01-25 23:05:39' 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','353173060485131','356078111430936','352353086157176','3135','356078111473761','3157','862531041080715','352353083439767','356078111347361','2883','3055','353173060512918','2677','3188','2785','862531041041642','355234055170423','2500','2665','354836080392292','3162','354836080405763','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-25 22:02:27' AND '2025-01-25 23:05:54' 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','353173060485131','356078111430936','352353086157176','3135','356078111473761','3157','862531041080715','352353083439767','356078111347361','2883','3055','353173060512918','2677','3188','2785','862531041041642','355234055170423','2500','2665','354836080392292','3162','354836080405763','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-25 22:02:27' AND '2025-01-25 23:06: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 ('353173060488028','353173060485131','356078111430936','352353086157176','3135','356078111473761','3157','862531041080715','352353083439767','356078111347361','2883','3055','353173060512918','2677','3188','2785','862531041041642','355234055170423','2500','2665','354836080392292','3162','354836080405763','2743','358021081839668','3167','355234055744904','2948','352353084655866','352353084097622','352353083500956','356078111451585','354836080357964','356078118085444','356078118082904')
	AND g.`time` BETWEEN '2025-01-25 22:02:27' AND '2025-01-25 23:06:24' 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-26 04:40:39' AND '2025-01-26 05:42:24' 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-26 04:40:39' AND '2025-01-26 05:42: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:42: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:43: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:43: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:43: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:43: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:44: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:44: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:44: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:44: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:45: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:45: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:45: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:45: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:46: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:46: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:46: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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','2876','353173060512918','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-01-26 04:40:39' AND '2025-01-26 05:46:53' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :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 ('2530','356078111279317','5046','862531041080400','3056','3089','2593','2753','3044','352353086184048','356078116299468','862531041072357','2566','4964','2575','3144','352353084209250','2558','2865','3189','352353084314373','354836080173346','2935','2761','5070','358021081816773','2622','2751','352353084274585','4863','352353084175477','9022','2920','355234055763003','352353084656807','2962','354836080274714','8990','3053','356078116474665','352353083550043','2974','354836080080269','352353083473741','4827','352353084275277','353173067110641','3076','358021081838710','3191','356078111473472','3122','355234055558247','352353086133862','353173066426337','3209','2947','354836080091142','3092','2932','358021081932786','3028','2930','2582','355234055172825','355234055763185','9379','352353083474160','2672','2713','3060','2504','2674','9021','2714','353173067115228','3168','2489','2540','352353084101507','3062','2738','2620','2815','353173060488002','352353086186415','352353085654322','355234055521542','352353086182380','352353086180491','352353086185151','352353086181390','352353085654314','3070','352353086183362','352353084181731','352353086185169','352353086186407','352353084290888','4957','352353083473444','352353086605497','2496','352353084131751','352353084101606','356078111473464','3105','4864','9374','352353086151005','352353084101820','2458','2610','2968','352353086181416','2515','2589','356078111292955','2606','2763','352353083466810','352353083500956','3027','2878','356078116390085','2752','2762','2923','3205','2937','353173066354539','3115','2908','3077','352353086187975','3145','2804','3192','2848','2709','355234055698654','3047','356078111430829','3980','3068','2857','356078111294241')
	AND g.`time` BETWEEN '2025-01-23 10:05:09' AND '2025-01-26 10:38:17' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :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 ('2530','356078111279317','5046','862531041080400','3056','3089','2593','2753','3044','352353086184048','356078116299468','862531041072357','2566','4964','2575','3144','352353084209250','2558','2865','3189','352353084314373','354836080173346','2935','2761','5070','358021081816773','2622','2751','352353084274585','4863','352353084175477','9022','2920','355234055763003','352353084656807','2962','354836080274714','8990','3053','356078116474665','352353083550043','2974','354836080080269','352353083473741','4827','352353084275277','353173067110641','3076','358021081838710','3191','356078111473472','3122','355234055558247','352353086133862','353173066426337','3209','2947','354836080091142','3092','2932','358021081932786','3028','2930','2582','355234055172825','355234055763185','9379','352353083474160','2672','2713','3060','2504','2674','9021','2714','353173067115228','3168','2489','2540','352353084101507','3062','2738','2620','2815','353173060488002','352353086186415','352353085654322','355234055521542','352353086182380','352353086180491','352353086185151','352353086181390','352353085654314','3070','352353086183362','352353084181731','352353086185169','352353086186407','352353084290888','4957','352353083473444','352353086605497','2496','352353084131751','352353084101606','356078111473464','3105','4864','9374','352353086151005','352353084101820','2458','2610','2968','352353086181416','2515','2589','356078111292955','2606','2763','352353083466810','352353083500956','3027','2878','356078116390085','2752','2762','2923','3205','2937','353173066354539','3115','2908','3077','352353086187975','3145','2804','3192','2848','2709','355234055698654','3047','356078111430829','3980','3068','2857','356078111294241')
	AND g.`time` BETWEEN '2025-01-23 10:05:09' AND '2025-01-26 10:38:46' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 :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 ('2530','356078111279317','5046','862531041080400','3056','3089','2593','2753','3044','352353086184048','356078116299468','862531041072357','2566','4964','2575','3144','352353084209250','2558','2865','3189','352353084314373','354836080173346','2935','2761','5070','358021081816773','2622','2751','352353084274585','4863','352353084175477','9022','2920','355234055763003','352353084656807','2962','354836080274714','8990','3053','356078116474665','352353083550043','2974','354836080080269','352353083473741','4827','352353084275277','353173067110641','3076','358021081838710','3191','356078111473472','3122','355234055558247','352353086133862','353173066426337','3209','2947','354836080091142','3092','2932','358021081932786','3028','2930','2582','355234055172825','355234055763185','9379','352353083474160','2672','2713','3060','2504','2674','9021','2714','353173067115228','3168','2489','2540','352353084101507','3062','2738','2620','2815','353173060488002','352353086186415','352353085654322','355234055521542','352353086182380','352353086180491','352353086185151','352353086181390','352353085654314','3070','352353086183362','352353084181731','352353086185169','352353086186407','352353084290888','4957','352353083473444','352353086605497','2496','352353084131751','352353084101606','356078111473464','3105','4864','9374','352353086151005','352353084101820','2458','2610','2968','352353086181416','2515','2589','356078111292955','2606','2763','352353083466810','352353083500956','3027','2878','356078116390085','2752','2762','2923','3205','2937','353173066354539','3115','2908','3077','352353086187975','3145','2804','3192','2848','2709','355234055698654','3047','356078111430829','3980','3068','2857','356078111294241')
	AND g.`time` BETWEEN '2025-01-23 10:05:09' AND '2025-01-26 10:39:01' 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-26 14:32:21' AND '2025-01-26 14:34:06' 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-26 14:32:21' AND '2025-01-26 14:34:20' 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','356078111301566','352353084175477','3090','354836080120826','2837','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-01-26 14:32:21' AND '2025-01-26 14:34:35' 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','356078111301566','352353084175477','3090','354836080120826','2837','3166','2501','9380','352353086131601','3210','352353086186647','354836080167561','356078111279986','352353083473493','3023','352353086184659','352353084314407','4825','3039','352353085630363','352353083499175','358021081803706','2556','352353086185144','356078111472854','2550','2473')
	AND g.`time` BETWEEN '2025-01-26 14:32:21' AND '2025-01-26 14:34:50' ORDER BY g.`time` DESC LIMIT 500