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-09-22 06:14:48' AND '2024-09-22 06:15:27' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:15:41' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:15:56' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:16:11' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:16:26' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:16:41' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:16:56' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:17:11' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:18:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:19:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:20:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:21:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:22:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:23:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:24:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:25:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:26:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:27:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:28:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:29:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:30:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:31:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:32:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:33:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:34:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:35:13' 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 ('353173060488028','3155','2485','353173060485131','2898','2756','356078111430936','2554','352353086157176','3123','3135','356078111473761','3057','356078111471005','2759','3238','3157','862531041080715','3025','352353083439767','2790','356078111347361','2883','3055','3081','2876','9378','2677','3188','862531041041642','352353084149035','355234055170423','2500','2665','354836080392292','3162','354836080405763','354836080314031','355234055575019','3178','2743','358021081839668','3167','355234055744904','2466','2948','352353084655866','3100','352353084102240','2630','352353083500956','356078111451585','354836080357964','3172','3197','3071','356078118082904','3187') AND g.`time` BETWEEN '2024-09-22 06:14:48' AND '2024-09-22 06:36:06' ORDER BY g.`time` DESC LIMIT 500