IP: - - 192.162.140.46; TIME:2024-01-12 17:55:16; 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 (2456) AND ev.date>='2024-01-11 22:00:00' AND ev.date<='2024-01-12 21:59:59'AND ev.eventtype in(12,7) order by imei,ev.date IP: - - 192.162.140.46; TIME:2024-01-12 17:55:16; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91385/57.2958) + COS(GeoX/57.2958) * COS(34.91385/57.2958) * COS(48.89742/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:19; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91375/57.2958) + COS(GeoX/57.2958) * COS(34.91375/57.2958) * COS(48.8974/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:20; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91386/57.2958) + COS(GeoX/57.2958) * COS(34.91386/57.2958) * COS(48.89756/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:21; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91376/57.2958) + COS(GeoX/57.2958) * COS(34.91376/57.2958) * COS(48.89757/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:21; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91383/57.2958) + COS(GeoX/57.2958) * COS(34.91383/57.2958) * COS(48.89735/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:22; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.9138/57.2958) + COS(GeoX/57.2958) * COS(34.9138/57.2958) * COS(48.89747/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:22; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91392/57.2958) + COS(GeoX/57.2958) * COS(34.91392/57.2958) * COS(48.89739/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:23; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91395/57.2958) + COS(GeoX/57.2958) * COS(34.91395/57.2958) * COS(48.89742/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:23; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91391/57.2958) + COS(GeoX/57.2958) * COS(34.91391/57.2958) * COS(48.89734/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:24; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91391/57.2958) + COS(GeoX/57.2958) * COS(34.91391/57.2958) * COS(48.89743/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:24; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91384/57.2958) + COS(GeoX/57.2958) * COS(34.91384/57.2958) * COS(48.89744/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:25; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91388/57.2958) + COS(GeoX/57.2958) * COS(34.91388/57.2958) * COS(48.89754/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:25; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91384/57.2958) + COS(GeoX/57.2958) * COS(34.91384/57.2958) * COS(48.89753/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:26; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91393/57.2958) + COS(GeoX/57.2958) * COS(34.91393/57.2958) * COS(48.8975/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:26; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91394/57.2958) + COS(GeoX/57.2958) * COS(34.91394/57.2958) * COS(48.9215/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:27; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91392/57.2958) + COS(GeoX/57.2958) * COS(34.91392/57.2958) * COS(48.92136/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:27; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91392/57.2958) + COS(GeoX/57.2958) * COS(34.91392/57.2958) * COS(48.92141/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:28; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91385/57.2958) + COS(GeoX/57.2958) * COS(34.91385/57.2958) * COS(48.89743/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:28; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91379/57.2958) + COS(GeoX/57.2958) * COS(34.91379/57.2958) * COS(48.89742/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:29; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91383/57.2958) + COS(GeoX/57.2958) * COS(34.91383/57.2958) * COS(48.89747/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:29; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91376/57.2958) + COS(GeoX/57.2958) * COS(34.91376/57.2958) * COS(48.8975/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:30; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91389/57.2958) + COS(GeoX/57.2958) * COS(34.91389/57.2958) * COS(48.89743/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:30; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91382/57.2958) + COS(GeoX/57.2958) * COS(34.91382/57.2958) * COS(48.8974/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:31; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91391/57.2958) + COS(GeoX/57.2958) * COS(34.91391/57.2958) * COS(48.89742/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:32; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91388/57.2958) + COS(GeoX/57.2958) * COS(34.91388/57.2958) * COS(48.89743/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:32; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91393/57.2958) + COS(GeoX/57.2958) * COS(34.91393/57.2958) * COS(48.89743/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:33; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91411/57.2958) + COS(GeoX/57.2958) * COS(34.91411/57.2958) * COS(48.89749/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:33; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91398/57.2958) + COS(GeoX/57.2958) * COS(34.91398/57.2958) * COS(48.89759/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:34; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91391/57.2958) + COS(GeoX/57.2958) * COS(34.91391/57.2958) * COS(48.89751/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:34; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91379/57.2958) + COS(GeoX/57.2958) * COS(34.91379/57.2958) * COS(48.89743/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 192.162.140.46; TIME:2024-01-12 17:55:35; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(34.91387/57.2958) + COS(GeoX/57.2958) * COS(34.91387/57.2958) * COS(48.89741/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;