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 '2024-06-22 10:59:40' AND '2024-06-22 10:59:45' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 10:59:59' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:00:14' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:00:29' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:00:44' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:00:59' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:01:14' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:01:29' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:01:44' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:01:59' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:02:14' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:02:29' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:02:44' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:02:59' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:03:14' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:03:29' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:03:44' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','5135','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 10:59:40' AND '2024-06-22 11:03:59' ORDER BY g.`time` DESC LIMIT 500
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 '2024-06-22 12:11:24' AND '2024-06-22 12:11:30' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:11:43' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:11:59' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:12:14' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:12:29' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:12:44' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:12:59' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:13:14' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:13:29' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:13:44' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:13:59' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:14:14' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:14:29' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:14:44' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:14:59' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:15:14' 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 ('352353086155659','3155','2485','353173060485131','2898','2756','3203','2554','352353086157176','3123','3135','356078111473761','3057','2759','3238','3157','2456','862531041080715','3025','2790','356078111347361','2883','3055','3081','2876','356078111430936','9378','3126','2677','3188','2785','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','2871','2574','354836080314031','355234055575019','3178','352353083473444','2953','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084097622','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','356078118085444','3197','3071','3187')
	AND g.`time` BETWEEN '2024-06-22 12:11:24' AND '2024-06-22 12:15:29' ORDER BY g.`time` DESC LIMIT 500