IP: - - 89.209.188.104; TIME:2024-12-03 18:02:44; 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 (3176) AND ev.date>='2024-12-01 22:00:00' AND ev.date<='2024-12-02 21:59:59'AND ev.eventtype in(12,7) order by imei,ev.date IP: - - 89.209.188.104; TIME:2024-12-03 18:02:44; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45453/57.2958) + COS(GeoX/57.2958) * COS(33.45453/57.2958) * COS(47.96457/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:46; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.505/57.2958) + COS(GeoX/57.2958) * COS(33.505/57.2958) * COS(48.02784/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:47; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.51568/57.2958) + COS(GeoX/57.2958) * COS(33.51568/57.2958) * COS(48.0733/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:47; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.52103/57.2958) + COS(GeoX/57.2958) * COS(33.52103/57.2958) * COS(48.07516/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:48; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.51377/57.2958) + COS(GeoX/57.2958) * COS(33.51377/57.2958) * COS(48.07423/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:48; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45483/57.2958) + COS(GeoX/57.2958) * COS(33.45483/57.2958) * COS(47.96458/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:49; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.4548/57.2958) + COS(GeoX/57.2958) * COS(33.4548/57.2958) * COS(47.96446/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:50; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45479/57.2958) + COS(GeoX/57.2958) * COS(33.45479/57.2958) * COS(47.96462/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:50; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45477/57.2958) + COS(GeoX/57.2958) * COS(33.45477/57.2958) * COS(47.96438/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:51; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45456/57.2958) + COS(GeoX/57.2958) * COS(33.45456/57.2958) * COS(47.96444/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:52; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45473/57.2958) + COS(GeoX/57.2958) * COS(33.45473/57.2958) * COS(47.96449/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:52; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.47661/57.2958) + COS(GeoX/57.2958) * COS(33.47661/57.2958) * COS(47.99816/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:53; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.509/57.2958) + COS(GeoX/57.2958) * COS(33.509/57.2958) * COS(48.0117/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:53; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45518/57.2958) + COS(GeoX/57.2958) * COS(33.45518/57.2958) * COS(47.96462/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:54; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45499/57.2958) + COS(GeoX/57.2958) * COS(33.45499/57.2958) * COS(47.96518/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:55; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45551/57.2958) + COS(GeoX/57.2958) * COS(33.45551/57.2958) * COS(47.96449/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:55; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45542/57.2958) + COS(GeoX/57.2958) * COS(33.45542/57.2958) * COS(47.96456/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:56; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45549/57.2958) + COS(GeoX/57.2958) * COS(33.45549/57.2958) * COS(47.96463/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:56; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45493/57.2958) + COS(GeoX/57.2958) * COS(33.45493/57.2958) * COS(47.96424/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:57; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45531/57.2958) + COS(GeoX/57.2958) * COS(33.45531/57.2958) * COS(47.96482/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:57; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45534/57.2958) + COS(GeoX/57.2958) * COS(33.45534/57.2958) * COS(47.96504/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:58; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45464/57.2958) + COS(GeoX/57.2958) * COS(33.45464/57.2958) * COS(47.96459/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:59; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45495/57.2958) + COS(GeoX/57.2958) * COS(33.45495/57.2958) * COS(47.96457/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1; IP: - - 89.209.188.104; TIME:2024-12-03 18:02:59; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45506/57.2958) + COS(GeoX/57.2958) * COS(33.45506/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: - - 89.209.188.104; TIME:2024-12-03 18:03:00; TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(33.45521/57.2958) + COS(GeoX/57.2958) * COS(33.45521/57.2958) * COS(47.96492/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;