grup 
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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-04-26 18:29:06' AND '2025-04-26 18:30:39' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:30:53' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:31:08' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:31:23' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:31:38' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:31:53' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:32:08' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:32:23' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:32:38' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:32:53' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:33:08' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:33:23' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:33:38' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:33:53' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:34:08' ORDER BY g.`time` DESC LIMIT 500
SELECT g.`latitude`, g.`longitude`, ADDTIME(g.`time`,'0 3: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 ('356078116280740','353173060488028','2485','353173060485131','2898','2756','356078111430936','356078116305406','352353086157176','3123','3135','356078111473761','2759','3238','3157','2456','2833','862531041080715','3025','352353083439767','352353085039615','2790','2883','3055','2876','353173060512918','3126','2677','3188','352353084175774','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','352353084144218','354836080314031','3178','3043','2571','2743','358021081839668','3088','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','352353083500956','4884','356078111451585','354836080357964','3172','356078118085444','3197','3071','356078118082904','3187')
	AND g.`time` BETWEEN '2025-04-26 18:29:06' AND '2025-04-26 18:34:23' ORDER BY g.`time` DESC LIMIT 500