--------------------------------------------------------------- [ 2022-11-01T02:03:54+08:00 ] 39.144.12.216 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002380s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011937s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000811s ] --------------------------------------------------------------- [ 2022-11-01T02:03:55+08:00 ] 117.132.195.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001574s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011712s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2022-11-01T02:04:02+08:00 ] 39.144.12.216 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221101&time=020301&v1=-01.064&v2=+00.044&v3=-00.988&v4=-00.043&v5=05.7&t=+10.6&h=56.3&rssi=+228&ccid=4600485905031420000099m9990000000075000001g0830,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001555s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009503s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000588s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221101',`time`='020301',`v1`=-1.064,`v2`=0.044,`v3`=-0.988,`v4`=-0.043,`v5`=5.7,`t`=10.6,`h`=56.3,`rssi`=228,`ccid`='4600485905031420000099m9990000000075000001g0830,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667239442 WHERE `imei` = '868922055643643' [ RunTime:0.000583s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010340s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221101' , '020301' , -1.064 , 0.044 , -0.988 , -0.043 , 5.7 , 10.6 , 56.3 , 228 , '4600485905031420000099m9990000000075000001g0830,N,00E000=-00.000' , 0 , 0 , 1667239442 , 1667239442) [ RunTime:0.000570s ] --------------------------------------------------------------- [ 2022-11-01T02:04:03+08:00 ] 117.132.195.46 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221101&time=020301&v1=-00.623&v2=+00.001&v3=-00.404&v4=+00.008&v5=05.9&t=+11.2&h=60.1&rssi=+223&ccid=4600485905031430000099m9990000000066000000g6980,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001727s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010043s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221101',`time`='020301',`v1`=-0.623,`v2`=0.001,`v3`=-0.404,`v4`=0.008,`v5`=5.9,`t`=11.2,`h`=60.1,`rssi`=223,`ccid`='4600485905031430000099m9990000000066000000g6980,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667239443 WHERE `imei` = '868922055644013' [ RunTime:0.000540s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010185s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221101' , '020301' , -0.623 , 0.001 , -0.404 , 0.008 , 5.9 , 11.2 , 60.1 , 223 , '4600485905031430000099m9990000000066000000g6980,N,00E000=-00.000' , 0 , 0 , 1667239443 , 1667239443) [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2022-11-01T09:28:24+08:00 ] 117.136.94.219 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002381s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011811s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000775s ] --------------------------------------------------------------- [ 2022-11-01T09:28:27+08:00 ] 117.136.94.219 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011659s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000474s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000642s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000545s ] --------------------------------------------------------------- [ 2022-11-01T09:28:42+08:00 ] 117.136.94.219 GET /home/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002043s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008630s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010005s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000602s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001689s ] --------------------------------------------------------------- [ 2022-11-01T09:29:02+08:00 ] 117.136.94.219 GET /home/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001419s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009604s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009903s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001719s ] --------------------------------------------------------------- [ 2022-11-01T09:30:39+08:00 ] 117.136.94.219 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002325s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009420s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000464s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000629s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000539s ] --------------------------------------------------------------- [ 2022-11-01T09:30:41+08:00 ] 117.136.94.219 GET /home/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001482s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012042s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010741s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002023s ] --------------------------------------------------------------- [ 2022-11-01T09:31:37+08:00 ] 117.136.94.219 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001770s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009254s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2022-11-01T09:48:02+08:00 ] 27.210.88.91 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002532s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010269s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2022-11-01T09:48:03+08:00 ] 27.210.88.91 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010424s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000761s ] --------------------------------------------------------------- [ 2022-11-01T09:48:08+08:00 ] 27.210.88.91 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001858s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009731s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000465s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000673s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000528s ] --------------------------------------------------------------- [ 2022-11-01T11:01:51+08:00 ] 39.144.15.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681494 [ sql ] [ DB ] CONNECT:[ UseTime:0.002277s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011442s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.000932s ] --------------------------------------------------------------- [ 2022-11-01T11:02:00+08:00 ] 39.144.15.75 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681494&date=221101&time=110101&v1=+00.007&v2=+00.269&v3=+00.007&v4=+00.008&v5=10.7&t=+18.6&h=60.3&rssi=+225&ccid=4600485905031400000099m9990000000023000000g0170,N,00E003=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001488s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010571s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.000772s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681494',`date`='221101',`time`='110101',`v1`=0.007,`v2`=0.269,`v3`=0.007,`v4`=0.008,`v5`=10.7,`t`=18.6,`h`=60.3,`rssi`=225,`ccid`='4600485905031400000099m9990000000023000000g0170,N,00E003=-00.000',`a1`=0,`a2`=0,`update_time`=1667271720 WHERE `imei` = '868922055681494' [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010657s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055681494' , '221101' , '110101' , 0.007 , 0.269 , 0.007 , 0.008 , 10.7 , 18.6 , 60.3 , 225 , '4600485905031400000099m9990000000023000000g0170,N,00E003=-00.000' , 0 , 0 , 1667271720 , 1667271720) [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2022-11-01T14:03:55+08:00 ] 39.144.3.200 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002126s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011502s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2022-11-01T14:03:55+08:00 ] 117.132.196.191 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001896s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009779s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2022-11-01T14:04:03+08:00 ] 117.132.196.191 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221101&time=140301&v1=-00.599&v2=+00.001&v3=+00.018&v4=-00.006&v5=06.0&t=+19.5&h=59.5&rssi=+224&ccid=4600485905031430000099m9990000000041000000g6950,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001736s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008424s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221101',`time`='140301',`v1`=-0.599,`v2`=0.001,`v3`=0.018,`v4`=-0.006,`v5`=6,`t`=19.5,`h`=59.5,`rssi`=224,`ccid`='4600485905031430000099m9990000000041000000g6950,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667282643 WHERE `imei` = '868922055644013' [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010672s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '221101' , '140301' , -0.599 , 0.001 , 0.018 , -0.006 , 6 , 19.5 , 59.5 , 224 , '4600485905031430000099m9990000000041000000g6950,N,00E000=-00.000' , 0 , 0 , 1667282643 , 1667282643) [ RunTime:0.000595s ] --------------------------------------------------------------- [ 2022-11-01T14:04:03+08:00 ] 39.144.3.200 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221101&time=140301&v1=-01.073&v2=+00.068&v3=-00.991&v4=-00.043&v5=06.2&t=+17.5&h=54.5&rssi=+230&ccid=4600485905031420000099m9990000000081000001g0900,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009284s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221101',`time`='140301',`v1`=-1.073,`v2`=0.068,`v3`=-0.991,`v4`=-0.043,`v5`=6.2,`t`=17.5,`h`=54.5,`rssi`=230,`ccid`='4600485905031420000099m9990000000081000001g0900,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667282643 WHERE `imei` = '868922055643643' [ RunTime:0.000478s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010387s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '221101' , '140301' , -1.073 , 0.068 , -0.991 , -0.043 , 6.2 , 17.5 , 54.5 , 230 , '4600485905031420000099m9990000000081000001g0900,N,00E000=-00.000' , 0 , 0 , 1667282643 , 1667282643) [ RunTime:0.000518s ] --------------------------------------------------------------- [ 2022-11-01T14:39:52+08:00 ] 27.210.88.91 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002267s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010999s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000535s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000664s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2022-11-01T19:44:13+08:00 ] 39.144.17.79 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002163s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010491s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2022-11-01T19:44:15+08:00 ] 39.144.17.79 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1667303053&v1=0.025676&v2=0.166267&v3=0.021552&v4=-0.001234&v5=6.660000&t=8.169751&h=65.853638&rssi=22&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008929s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1667303053,`v1`=0.025676,`v2`=0.166267,`v3`=0.021552,`v4`=-0.001234,`v5`=6.66,`t`=8.169751,`h`=65.853638,`rssi`=22,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1667303055 WHERE `imei` = '868922055644211' [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011966s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1667303053 , 0.025676 , 0.166267 , 0.021552 , -0.001234 , 6.66 , 8.169751 , 65.853638 , 22 , '89860426102071188505' , '460044618415255' , -0 , 1667303055) [ RunTime:0.000603s ] --------------------------------------------------------------- [ 2022-11-01T22:03:50+08:00 ] 221.178.127.32 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002128s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012413s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2022-11-01T22:03:59+08:00 ] 221.178.127.32 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221101&time=220301&v1=-01.281&v2=+00.025&v3=-01.115&v4=-00.761&v5=05.9&t=+08.2&h=81.5&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.195&a2=01.297&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001508s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011243s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221101',`time`='220301',`v1`=-1.281,`v2`=0.025,`v3`=-1.115,`v4`=-0.761,`v5`=5.9,`t`=8.2,`h`=81.5,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.195,`a2`=1.297,`update_time`=1667311439 WHERE `imei` = '868922055684076' [ RunTime:0.000570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010509s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '221101' , '220301' , -1.281 , 0.025 , -1.115 , -0.761 , 5.9 , 8.2 , 81.5 , 228 , '460044618415249' , -0 , 0.195 , 1.297 , 1667311439 , 1667311439) [ RunTime:0.000637s ]