IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:34;  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 (2966) AND ev.date>='2024-02-22 22:00:00' AND ev.date<='2024-02-23 21:59:59'AND ev.eventtype in(12,7) order by imei,ev.date
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:34;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.31277/57.2958) + COS(GeoX/57.2958) * COS(33.31277/57.2958) * COS(49.1604/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:36;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.31283/57.2958) + COS(GeoX/57.2958) * COS(33.31283/57.2958) * COS(49.1604/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:37;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.25308/57.2958) + COS(GeoX/57.2958) * COS(33.25308/57.2958) * COS(49.16825/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:37;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.04704/57.2958) + COS(GeoX/57.2958) * COS(33.04704/57.2958) * COS(48.96862/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:38;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.22402/57.2958) + COS(GeoX/57.2958) * COS(33.22402/57.2958) * COS(49.05422/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:38;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.40741/57.2958) + COS(GeoX/57.2958) * COS(33.40741/57.2958) * COS(49.06033/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:39;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.44598/57.2958) + COS(GeoX/57.2958) * COS(33.44598/57.2958) * COS(49.08632/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:40;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43049/57.2958) + COS(GeoX/57.2958) * COS(33.43049/57.2958) * COS(49.09836/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:40;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43054/57.2958) + COS(GeoX/57.2958) * COS(33.43054/57.2958) * COS(49.09827/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:41;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43047/57.2958) + COS(GeoX/57.2958) * COS(33.43047/57.2958) * COS(49.09842/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:41;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.4304/57.2958) + COS(GeoX/57.2958) * COS(33.4304/57.2958) * COS(49.09832/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:42;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43068/57.2958) + COS(GeoX/57.2958) * COS(33.43068/57.2958) * COS(49.09832/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:43;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.4305/57.2958) + COS(GeoX/57.2958) * COS(33.4305/57.2958) * COS(49.09848/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:43;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43067/57.2958) + COS(GeoX/57.2958) * COS(33.43067/57.2958) * COS(49.09851/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:44;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43059/57.2958) + COS(GeoX/57.2958) * COS(33.43059/57.2958) * COS(49.09836/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:45;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43064/57.2958) + COS(GeoX/57.2958) * COS(33.43064/57.2958) * COS(49.09832/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:45;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43119/57.2958) + COS(GeoX/57.2958) * COS(33.43119/57.2958) * COS(49.09802/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:46;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.4308/57.2958) + COS(GeoX/57.2958) * COS(33.4308/57.2958) * COS(49.0982/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:47;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43062/57.2958) + COS(GeoX/57.2958) * COS(33.43062/57.2958) * COS(49.09826/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:47;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43051/57.2958) + COS(GeoX/57.2958) * COS(33.43051/57.2958) * COS(49.09843/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:48;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43055/57.2958) + COS(GeoX/57.2958) * COS(33.43055/57.2958) * COS(49.09824/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:49;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43034/57.2958) + COS(GeoX/57.2958) * COS(33.43034/57.2958) * COS(49.09832/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:49;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43077/57.2958) + COS(GeoX/57.2958) * COS(33.43077/57.2958) * COS(49.09815/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:50;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43019/57.2958) + COS(GeoX/57.2958) * COS(33.43019/57.2958) * COS(49.09859/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:51;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43036/57.2958) + COS(GeoX/57.2958) * COS(33.43036/57.2958) * COS(49.09846/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:51;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43035/57.2958) + COS(GeoX/57.2958) * COS(33.43035/57.2958) * COS(49.0983/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 188.163.35.222 - 147.161.138.99; TIME:2024-02-26 12:53:52;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.43039/57.2958) + COS(GeoX/57.2958) * COS(33.43039/57.2958) * COS(49.09833/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;