2021-10-12 18:19:47

SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-10-12' AND t.client_id= ORDER BY t.imei ASC; 2021-10-12 18:19:53

SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd') 2021-10-12 18:19:53
53
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-10-12' AND t.client_id=53 ORDER BY t.imei ASC; 2021-10-12 18:19:55
53
SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC 2021-10-12 18:20:00
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 12:20:00' and t.time < '2021-10-12 18:20:00' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 18:21:53
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 12:21:53' and t.time < '2021-10-12 18:21:53' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 18:34:24
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 12:34:24' and t.time < '2021-10-12 18:34:24' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 18:54:12

SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-10-12' AND t.client_id= ORDER BY t.imei ASC; 2021-10-12 18:54:20

SELECT COUNT(*),u.role_id, u.client_id, u.id, u.frequency, s.milestone,s.MapCenter_longitude,s.MapCenter_latitude,s.defaultMap_scale,s.gmt,s.use_fixed_data,c.is_blocked,b.balance,s.time_track,s.dist_track, s.car_name_format FROM wm_users AS u LEFT JOIN wm_settings AS s ON u.client_id = s.client_id LEFT JOIN wm_clients c on u.client_id=c.id LEFT JOIN wm_balances b ON b.client_id=c.id WHERE (u.`login`='cola-admin' AND u.`password`='7a04440e92466d362697f4929b71c3bd') 2021-10-12 18:54:20
53
SELECT t.id,t.date,c.car_name,t.description,t.client,t.adress_to,t.adress_from,t.customer,t.target FROM tms_tasks t INNER JOIN wm_car_info c ON t.imei=c.imei WHERE DATE='2021-10-12' AND t.client_id=53 ORDER BY t.imei ASC; 2021-10-12 18:54:23
53
SELECT ci.id, ci.car_name,ci.fuel,ci.model,ci.fuel_type,ci.atp,ci.company,ci.imei, d.NAME AS driver_name FROM wm_car_info ci LEFT JOIN wm_drivers d ON ci.driver_id = d.id WHERE ci.client_id = 53 ORDER BY ci.car_name ASC 2021-10-12 18:54:26
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 12:54:26' and t.time < '2021-10-12 18:54:26' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:05:37
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:05:37' and t.time < '2021-10-12 19:05:37' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:27:38
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:27:38' and t.time < '2021-10-12 19:27:38' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:28:08
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:28:08' and t.time < '2021-10-12 19:28:08' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:31:51
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:31:51' and t.time < '2021-10-12 19:31:51' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:41:08
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:41:08' and t.time < '2021-10-12 19:41:08' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:49:43
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:49:43' and t.time < '2021-10-12 19:49:43' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:50:13
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:50:13' and t.time < '2021-10-12 19:50:13' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:50:43
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:50:43' and t.time < '2021-10-12 19:50:43' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:51:13
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:51:13' and t.time < '2021-10-12 19:51:13' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:51:43
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:51:43' and t.time < '2021-10-12 19:51:43' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:55:00
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:55:00' and t.time < '2021-10-12 19:55:00' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:55:42
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:55:42' and t.time < '2021-10-12 19:55:42' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:56:12
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:56:12' and t.time < '2021-10-12 19:56:12' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:56:42
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:56:42' and t.time < '2021-10-12 19:56:42' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:57:12
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:57:12' and t.time < '2021-10-12 19:57:12' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC 2021-10-12 19:57:42
53
SELECT t.latitude, t.longitude, t.date, ROUND(t.speed), ADDTIME(`time`,'0 3:0:0') as fixed_time, c.car_name, c.imei, c.image_path FROM tmslogistic.tms_gpsdata_fixed t INNER JOIN tmslogistic.wm_car_info c ON t.DeviceLoginName=c.imei WHERE t.DeviceLoginName = '861359037404611' AND t.time >= '2021-10-12 13:57:42' and t.time < '2021-10-12 19:57:42' and t.latitude <> 0 and t.longitude <> 0 ORDER BY c.imei,t.time DESC