IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-04-04 09:18:02;  TS : Query1 select ev.eventtype,ADDTIME(ev.date,'0 3: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 (356078116305406) AND ev.date>='2025-04-02 21:00:00' AND ev.date<='2025-04-03 20:59:59'AND ev.eventtype in(12,7) order by imei,ev.date
IP: - 77.93.45.223 - 165.225.206.95; TIME:2025-04-04 09:18:02;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.40454/57.2958) + COS(GeoX/57.2958) * COS(33.40454/57.2958) * COS(47.93774/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-04-04 09:18:04;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.40456/57.2958) + COS(GeoX/57.2958) * COS(33.40456/57.2958) * COS(47.93769/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-04-04 09:18:05;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43581/57.2958) + COS(GeoX/57.2958) * COS(33.43581/57.2958) * COS(47.96468/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-04-04 09:18:05;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43358/57.2958) + COS(GeoX/57.2958) * COS(33.43358/57.2958) * COS(47.93935/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-04-04 09:18:06;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43166/57.2958) + COS(GeoX/57.2958) * COS(33.43166/57.2958) * COS(47.93996/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-04-04 09:18:06;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.42219/57.2958) + COS(GeoX/57.2958) * COS(33.42219/57.2958) * COS(47.9371/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-04-04 09:18:06;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.42231/57.2958) + COS(GeoX/57.2958) * COS(33.42231/57.2958) * COS(47.93564/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-04-04 09:18:07;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.42614/57.2958) + COS(GeoX/57.2958) * COS(33.42614/57.2958) * COS(47.93356/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-04-04 09:18:08;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.42257/57.2958) + COS(GeoX/57.2958) * COS(33.42257/57.2958) * COS(47.93713/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-04-04 09:18:08;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.42713/57.2958) + COS(GeoX/57.2958) * COS(33.42713/57.2958) * COS(47.93719/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-04-04 09:18:09;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43582/57.2958) + COS(GeoX/57.2958) * COS(33.43582/57.2958) * COS(47.9647/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-04-04 09:18:09;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.4325/57.2958) + COS(GeoX/57.2958) * COS(33.4325/57.2958) * COS(47.94233/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-04-04 09:18:10;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.42509/57.2958) + COS(GeoX/57.2958) * COS(33.42509/57.2958) * COS(47.93914/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-04-04 09:18:10;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.42518/57.2958) + COS(GeoX/57.2958) * COS(33.42518/57.2958) * COS(47.92949/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-04-04 09:18:11;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.40628/57.2958) + COS(GeoX/57.2958) * COS(33.40628/57.2958) * COS(47.93578/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-04-04 09:18:11;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.34272/57.2958) + COS(GeoX/57.2958) * COS(33.34272/57.2958) * COS(47.89788/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;