IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-02-04 14:54:46;  TS : Query1 select ev.eventtype,ADDTIME(ev.date,'0 2:0:0'),ci.imei, ev.`addr`, ev.`GeoX`, ev.`GeoY` from tms_events ev left join wm_car_info ci on ev.deviceloginname=ci.imei where ev.deviceloginname in (352353083439767) AND ev.date>='2025-02-03 22:00:00' AND ev.date<='2025-02-04 21:59:59'AND ev.eventtype in(12,7) order by imei,ev.date
IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-02-04 14:54:46;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.13533/57.2958) + COS(GeoX/57.2958) * COS(35.13533/57.2958) * COS(48.41807/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-02-04 14:54:48;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.26215/57.2958) + COS(GeoX/57.2958) * COS(35.26215/57.2958) * COS(48.63451/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-02-04 14:54:48;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.2359/57.2958) + COS(GeoX/57.2958) * COS(35.2359/57.2958) * COS(48.63583/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-02-04 14:54:49;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.25404/57.2958) + COS(GeoX/57.2958) * COS(35.25404/57.2958) * COS(48.63098/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-02-04 14:54:49;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.25401/57.2958) + COS(GeoX/57.2958) * COS(35.25401/57.2958) * COS(48.63094/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-02-04 14:54:50;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.254/57.2958) + COS(GeoX/57.2958) * COS(35.254/57.2958) * COS(48.62819/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-02-04 14:54:51;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.25591/57.2958) + COS(GeoX/57.2958) * COS(35.25591/57.2958) * COS(48.62526/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-02-04 14:54:51;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.25622/57.2958) + COS(GeoX/57.2958) * COS(35.25622/57.2958) * COS(48.62257/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-02-04 14:54:52;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.25292/57.2958) + COS(GeoX/57.2958) * COS(35.25292/57.2958) * COS(48.63357/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;