IP: -  - 77.93.45.223; TIME:2023-12-18 12:37:17;  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 (5135) AND ev.date>='2023-12-14 22:00:00' AND ev.date<='2023-12-15 21:59:59'AND ev.eventtype in(12,7) order by imei,ev.date
IP: -  - 77.93.45.223; TIME:2023-12-18 12:37:17;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.99146/57.2958) + COS(GeoX/57.2958) * COS(34.99146/57.2958) * COS(48.51057/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; TIME:2023-12-18 12:37:18;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.99135/57.2958) + COS(GeoX/57.2958) * COS(34.99135/57.2958) * COS(48.51263/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; TIME:2023-12-18 12:37:19;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.95903/57.2958) + COS(GeoX/57.2958) * COS(34.95903/57.2958) * COS(48.49234/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; TIME:2023-12-18 12:37:19;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.99672/57.2958) + COS(GeoX/57.2958) * COS(34.99672/57.2958) * COS(48.40244/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; TIME:2023-12-18 12:37:20;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.05839/57.2958) + COS(GeoX/57.2958) * COS(35.05839/57.2958) * COS(48.45129/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; TIME:2023-12-18 12:37:20;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.05842/57.2958) + COS(GeoX/57.2958) * COS(35.05842/57.2958) * COS(48.45125/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; TIME:2023-12-18 12:37:21;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(35.12712/57.2958) + COS(GeoX/57.2958) * COS(35.12712/57.2958) * COS(48.41295/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;