IP: - 93.175.194.138 - 147.161.136.92; TIME:2024-04-18 08:43:36;  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 (4849) AND ev.date>='2024-04-17 21:00:00' AND ev.date<='2024-04-18 20:59:59'AND ev.eventtype in(12,7) order by imei,ev.date
IP: - 93.175.194.138 - 147.161.136.92; TIME:2024-04-18 08:43:36;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(27.00521/57.2958) + COS(GeoX/57.2958) * COS(27.00521/57.2958) * COS(49.43751/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 93.175.194.138 - 147.161.136.92; TIME:2024-04-18 08:43:54;  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 (4849) AND ev.date>='2024-04-16 21:00:00' AND ev.date<='2024-04-17 20:59:59'AND ev.eventtype in(12,7) order by imei,ev.date
IP: - 93.175.194.138 - 147.161.136.92; TIME:2024-04-18 08:43:54;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(26.93381/57.2958) + COS(GeoX/57.2958) * COS(26.93381/57.2958) * COS(49.46339/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;
IP: - 93.175.194.138 - 147.161.136.92; TIME:2024-04-18 08:43:55;  TS : Query SELECT `Code`,`Name`,`Address`, 1609.344*(3958.75 * ACOS( SIN(GeoX/57.2958) * SIN(27.00542/57.2958) + COS(GeoX/57.2958) * COS(27.00542/57.2958) * COS(49.43719/57.2958 - GeoY/57.2958))) AS dist FROM tms_warehouse WHERE `instanceID`=53 HAVING dist < 100 ORDER BY dist ASC LIMIT 0,1;