--------------------------------------------------------------- [ 2023-05-15T02:03:54+08:00 ] 111.55.140.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002266s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010306s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000824s ] --------------------------------------------------------------- [ 2023-05-15T02:03:55+08:00 ] 39.144.4.143 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001944s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008898s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2023-05-15T02:04:03+08:00 ] 111.55.140.150 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230515&time=020301&v1=-01.372&v2=+00.012&v3=-00.927&v4=-00.041&v5=06.2&t=+18.7&h=60.2&rssi=+228&ccid=4600485905031420000099m9990000000452000001g3810,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.010278s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010108s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000928s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230515',`time`='020301',`v1`=-1.372,`v2`=0.012,`v3`=-0.927,`v4`=-0.041,`v5`=6.2,`t`=18.7,`h`=60.2,`rssi`=228,`ccid`='4600485905031420000099m9990000000452000001g3810,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684087443 WHERE `imei` = '868922055643643' [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010618s ] [ 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' , '230515' , '020301' , -1.372 , 0.012 , -0.927 , -0.041 , 6.2 , 18.7 , 60.2 , 228 , '4600485905031420000099m9990000000452000001g3810,N,00E000=-00.000' , 0 , 0 , 1684087443 , 1684087443) [ RunTime:0.000616s ] --------------------------------------------------------------- [ 2023-05-15T02:04:04+08:00 ] 39.144.4.143 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230515&time=020301&v1=-00.228&v2=+00.001&v3=-00.065&v4=-00.008&v5=06.0&t=+19.0&h=63.0&rssi=+224&ccid=4600485905031430000099m9990000000020000000g2370,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002845s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009716s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230515',`time`='020301',`v1`=-0.228,`v2`=0.001,`v3`=-0.065,`v4`=-0.008,`v5`=6,`t`=19,`h`=63,`rssi`=224,`ccid`='4600485905031430000099m9990000000020000000g2370,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684087444 WHERE `imei` = '868922055644013' [ RunTime:0.000498s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009305s ] [ 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' , '230515' , '020301' , -0.228 , 0.001 , -0.065 , -0.008 , 6 , 19 , 63 , 224 , '4600485905031430000099m9990000000020000000g2370,N,00E000=-00.000' , 0 , 0 , 1684087444 , 1684087444) [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2023-05-15T08:42:04+08:00 ] 124.129.66.114 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.014493s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2023-05-15T08:42:10+08:00 ] 124.129.66.114 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001469s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010442s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000396s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000905s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001366s ] --------------------------------------------------------------- [ 2023-05-15T08:42:45+08:00 ] 124.129.66.114 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001427s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010071s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000404s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001057s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000995s ] --------------------------------------------------------------- [ 2023-05-15T08:44:05+08:00 ] 124.129.66.114 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011085s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000428s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001122s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001024s ] --------------------------------------------------------------- [ 2023-05-15T11:04:30+08:00 ] 111.55.139.77 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.003034s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011436s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000835s ] --------------------------------------------------------------- [ 2023-05-15T11:04:31+08:00 ] 111.55.139.77 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1684119870&v1=0.029348&v2=0.012830&v3=0.028114&v4=0.001415&v5=12.420000&t=23.453014&h=77.831787&rssi=28&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009242s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1684119870,`v1`=0.029348,`v2`=0.01283,`v3`=0.028114,`v4`=0.001415,`v5`=12.42,`t`=23.453014,`h`=77.831787,`rssi`=28,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1684119871 WHERE `imei` = '868922055678110' [ RunTime:0.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010278s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1684119870 , 0.029348 , 0.01283 , 0.028114 , 0.001415 , 12.42 , 23.453014 , 77.831787 , 28 , '898604650119C1078513' , '460048590708513' , -0 , 1684119871) [ RunTime:0.000716s ] --------------------------------------------------------------- [ 2023-05-15T14:00:50+08:00 ] 39.144.4.189 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002316s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015331s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000797s ] --------------------------------------------------------------- [ 2023-05-15T14:00:58+08:00 ] 39.144.4.189 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230515&time=140001&v1=-00.827&v2=+00.011&v3=-00.728&v4=-00.243&v5=06.2&t=+39.4&h=75.4&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.142&a2=00.962&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012646s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000712s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230515',`time`='140001',`v1`=-0.827,`v2`=0.011,`v3`=-0.728,`v4`=-0.243,`v5`=6.2,`t`=39.4,`h`=75.4,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.142,`a2`=0.962,`update_time`=1684130458 WHERE `imei` = '868922055684076' [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011715s ] [ 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' , '230515' , '140001' , -0.827 , 0.011 , -0.728 , -0.243 , 6.2 , 39.4 , 75.4 , 228 , '460044618415249' , -0 , 0.142 , 0.962 , 1684130458 , 1684130458) [ RunTime:0.001331s ] --------------------------------------------------------------- [ 2023-05-15T14:03:54+08:00 ] 111.55.141.47 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002002s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009041s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000734s ] --------------------------------------------------------------- [ 2023-05-15T14:03:55+08:00 ] 117.132.198.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001819s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009109s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000721s ] --------------------------------------------------------------- [ 2023-05-15T14:04:02+08:00 ] 111.55.141.47 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230515&time=140301&v1=-01.371&v2=+00.030&v3=-01.018&v4=-00.040&v5=06.0&t=+39.1&h=54.4&rssi=+230&ccid=4600485905031420000099m9990000000352000001g3780,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002379s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010931s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230515',`time`='140301',`v1`=-1.371,`v2`=0.03,`v3`=-1.018,`v4`=-0.04,`v5`=6,`t`=39.1,`h`=54.4,`rssi`=230,`ccid`='4600485905031420000099m9990000000352000001g3780,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684130642 WHERE `imei` = '868922055643643' [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011486s ] [ 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' , '230515' , '140301' , -1.371 , 0.03 , -1.018 , -0.04 , 6 , 39.1 , 54.4 , 230 , '4600485905031420000099m9990000000352000001g3780,N,00E000=-00.000' , 0 , 0 , 1684130642 , 1684130642) [ RunTime:0.001213s ] --------------------------------------------------------------- [ 2023-05-15T14:04:03+08:00 ] 117.132.198.86 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230515&time=140301&v1=-00.293&v2=+00.001&v3=+00.020&v4=-00.006&v5=06.2&t=+37.0&h=59.8&rssi=+225&ccid=4600485905031430000099m9990000000047000000g3170,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001559s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010683s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000855s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230515',`time`='140301',`v1`=-0.293,`v2`=0.001,`v3`=0.02,`v4`=-0.006,`v5`=6.2,`t`=37,`h`=59.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000047000000g3170,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684130643 WHERE `imei` = '868922055644013' [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009665s ] [ 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' , '230515' , '140301' , -0.293 , 0.001 , 0.02 , -0.006 , 6.2 , 37 , 59.8 , 225 , '4600485905031430000099m9990000000047000000g3170,N,00E000=-00.000' , 0 , 0 , 1684130643 , 1684130643) [ RunTime:0.001239s ] --------------------------------------------------------------- [ 2023-05-15T14:31:24+08:00 ] 117.132.196.13 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002416s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012327s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000701s ] --------------------------------------------------------------- [ 2023-05-15T14:31:25+08:00 ] 117.132.196.13 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1684132284&v1=0.016766&v2=0.015646&v3=0.014117&v4=-0.011829&v5=12.420000&t=24.225222&h=75.954956&rssi=29&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001506s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011116s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1684132284,`v1`=0.016766,`v2`=0.015646,`v3`=0.014117,`v4`=-0.011829,`v5`=12.42,`t`=24.225222,`h`=75.954956,`rssi`=29,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1684132285 WHERE `imei` = '868922055684548' [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011569s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1684132284 , 0.016766 , 0.015646 , 0.014117 , -0.011829 , 12.42 , 24.225222 , 75.954956 , 29 , '898604650119C1053137' , '460048590503137' , -0 , 1684132285) [ RunTime:0.000628s ] --------------------------------------------------------------- [ 2023-05-15T16:49:03+08:00 ] 39.144.5.62 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010913s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.001175s ] --------------------------------------------------------------- [ 2023-05-15T16:49:04+08:00 ] 39.144.5.62 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1684140543&v1=0.018873&v2=0.013143&v3=0.015201&v4=-0.000632&v5=12.420000&t=24.686401&h=79.960388&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184928,35.985457&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011599s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1684140543,`v1`=0.018873,`v2`=0.013143,`v3`=0.015201,`v4`=-0.000632,`v5`=12.42,`t`=24.686401,`h`=79.960388,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184928,35.985457',`update_time`=1684140544 WHERE `imei` = '868922055647586' [ RunTime:0.000659s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010350s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055647586' , 1684140543 , 0.018873 , 0.013143 , 0.015201 , -0.000632 , 12.42 , 24.686401 , 79.960388 , 28 , '898604650119C1078512' , '460048590708512' , -0 , '120.184928,35.985457' , 1684140544) [ RunTime:0.001244s ] --------------------------------------------------------------- [ 2023-05-15T17:26:21+08:00 ] 39.144.13.105 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002808s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012453s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000768s ] --------------------------------------------------------------- [ 2023-05-15T17:26:23+08:00 ] 39.144.13.105 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1684142781&v1=0.027241&v2=0.012100&v3=0.026759&v4=0.015742&v5=12.240000&t=24.450449&h=76.664490&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184780,35.985811&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002029s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009608s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1684142781,`v1`=0.027241,`v2`=0.0121,`v3`=0.026759,`v4`=0.015742,`v5`=12.24,`t`=24.450449,`h`=76.66449,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184780,35.985811',`update_time`=1684142783 WHERE `imei` = '868922056976208' [ RunTime:0.000742s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010692s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1684142781 , 0.027241 , 0.0121 , 0.026759 , 0.015742 , 12.24 , 24.450449 , 76.66449 , 28 , '898604650119C1053139' , '460048590503139' , -0 , '120.184780,35.985811' , 1684142783) [ RunTime:0.001324s ] --------------------------------------------------------------- [ 2023-05-15T17:31:21+08:00 ] 39.144.16.132 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.001879s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011135s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000766s ] --------------------------------------------------------------- [ 2023-05-15T17:31:23+08:00 ] 39.144.16.132 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1684143081&v1=0.020679&v2=0.014082&v3=0.017007&v4=-0.006893&v5=12.420000&t=24.525524&h=78.411621&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001609s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009075s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1684143081,`v1`=0.020679,`v2`=0.014082,`v3`=0.017007,`v4`=-0.006893,`v5`=12.42,`t`=24.525524,`h`=78.411621,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1684143083 WHERE `imei` = '868922055684209' [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011542s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1684143081 , 0.020679 , 0.014082 , 0.017007 , -0.006893 , 12.42 , 24.525524 , 78.411621 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1684143083) [ RunTime:0.000545s ] --------------------------------------------------------------- [ 2023-05-15T17:56:20+08:00 ] 39.144.12.213 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012206s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000807s ] --------------------------------------------------------------- [ 2023-05-15T17:56:21+08:00 ] 39.144.12.213 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1684144580&v1=0.018873&v2=0.013977&v3=0.016194&v4=-0.004545&v5=12.420000&t=24.225222&h=80.448669&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009717s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1684144580,`v1`=0.018873,`v2`=0.013977,`v3`=0.016194,`v4`=-0.004545,`v5`=12.42,`t`=24.225222,`h`=80.448669,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1684144581 WHERE `imei` = '868922055683920' [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010488s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1684144580 , 0.018873 , 0.013977 , 0.016194 , -0.004545 , 12.42 , 24.225222 , 80.448669 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1684144581) [ RunTime:0.000612s ] --------------------------------------------------------------- [ 2023-05-15T18:15:57+08:00 ] 117.132.194.200 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003240s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013922s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000784s ] --------------------------------------------------------------- [ 2023-05-15T18:16:05+08:00 ] 117.132.194.200 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230515&time=181501&v1=-00.155&v2=+00.007&v3=-00.080&v4=+00.395&v5=06.2&t=+34.3&h=79.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.140&a2=00.261&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002177s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010904s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230515',`time`='181501',`v1`=-0.155,`v2`=0.007,`v3`=-0.08,`v4`=0.395,`v5`=6.2,`t`=34.3,`h`=79,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.14,`a2`=0.261,`update_time`=1684145765 WHERE `imei` = '868922055684076' [ RunTime:0.000591s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012281s ] [ 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' , '230515' , '181501' , -0.155 , 0.007 , -0.08 , 0.395 , 6.2 , 34.3 , 79 , 228 , '460044618415249' , -0 , 0.14 , 0.261 , 1684145765 , 1684145765) [ RunTime:0.000648s ] --------------------------------------------------------------- [ 2023-05-15T20:18:49+08:00 ] 124.129.66.114 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002115s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011724s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2023-05-15T20:18:53+08:00 ] 124.129.66.114 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001599s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.012324s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000353s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000340s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000422s ] --------------------------------------------------------------- [ 2023-05-15T20:18:57+08:00 ] 124.129.66.114 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.011286s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000404s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000394s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000359s ] --------------------------------------------------------------- [ 2023-05-15T20:19:00+08:00 ] 124.129.66.114 GET /admin/thermocouple/index.html?keyword= [ sql ] [ DB ] CONNECT:[ UseTime:0.001938s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.011153s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000419s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000384s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000412s ] --------------------------------------------------------------- [ 2023-05-15T20:19:02+08:00 ] 124.129.66.114 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001908s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.010852s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000407s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000390s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000437s ] --------------------------------------------------------------- [ 2023-05-15T20:19:05+08:00 ] 124.129.66.114 GET /admin/shelves/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001752s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_shelves` [ RunTime:0.013013s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_shelves` LIMIT 1 [ RunTime:0.000372s ] [ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000559s ] [ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC [ RunTime:0.000494s ] --------------------------------------------------------------- [ 2023-05-15T20:19:07+08:00 ] 124.129.66.114 GET /admin/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001969s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011311s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000371s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001151s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2023-05-15T20:19:20+08:00 ] 124.129.66.114 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009533s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2023-05-15T20:43:58+08:00 ] 117.132.192.228 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002852s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014037s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000816s ] --------------------------------------------------------------- [ 2023-05-15T20:44:00+08:00 ] 117.132.192.228 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1684154638&v1=0.031816&v2=0.015020&v3=0.029047&v4=0.008278&v5=12.600000&t=23.839119&h=79.388184&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184975,35.986771&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002586s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1684154638,`v1`=0.031816,`v2`=0.01502,`v3`=0.029047,`v4`=0.008278,`v5`=12.6,`t`=23.839119,`h`=79.388184,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184975,35.986771',`update_time`=1684154640 WHERE `imei` = '868922055683912' [ RunTime:0.000830s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012117s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1684154638 , 0.031816 , 0.01502 , 0.029047 , 0.008278 , 12.6 , 23.839119 , 79.388184 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.184975,35.986771' , 1684154640) [ RunTime:0.001385s ] --------------------------------------------------------------- [ 2023-05-15T20:48:26+08:00 ] 223.104.255.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002804s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012324s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2023-05-15T20:48:27+08:00 ] 223.104.255.180 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1684154906&v1=0.019294&v2=0.014812&v3=0.016405&v4=-0.017127&v5=12.420000&t=23.892744&h=80.380005&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184926,35.985104&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002110s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010108s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000793s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1684154906,`v1`=0.019294,`v2`=0.014812,`v3`=0.016405,`v4`=-0.017127,`v5`=12.42,`t`=23.892744,`h`=80.380005,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184926,35.985104',`update_time`=1684154907 WHERE `imei` = '868922055683771' [ RunTime:0.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009497s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1684154906 , 0.019294 , 0.014812 , 0.016405 , -0.017127 , 12.42 , 23.892744 , 80.380005 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.184926,35.985104' , 1684154907) [ RunTime:0.000514s ] --------------------------------------------------------------- [ 2023-05-15T21:20:46+08:00 ] 124.129.66.114 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002153s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010585s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000570s ] --------------------------------------------------------------- [ 2023-05-15T23:26:24+08:00 ] 111.55.141.6 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002901s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012180s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000796s ] --------------------------------------------------------------- [ 2023-05-15T23:26:25+08:00 ] 111.55.141.6 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1684164384&v1=0.007074&v2=0.012621&v3=0.005027&v4=-0.015742&v5=12.420000&t=23.764044&h=78.732056&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001825s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010677s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000712s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1684164384,`v1`=0.007074,`v2`=0.012621,`v3`=0.005027,`v4`=-0.015742,`v5`=12.42,`t`=23.764044,`h`=78.732056,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1684164385 WHERE `imei` = '868922055644021' [ RunTime:0.000684s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011922s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1684164384 , 0.007074 , 0.012621 , 0.005027 , -0.015742 , 12.42 , 23.764044 , 78.732056 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1684164385) [ RunTime:0.001356s ] --------------------------------------------------------------- [ 2023-05-15T23:47:24+08:00 ] 39.144.18.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002708s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2023-05-15T23:47:25+08:00 ] 39.144.18.247 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1684165644&v1=0.021221&v2=0.012830&v3=0.018452&v4=-0.006110&v5=12.420000&t=23.646067&h=78.251404&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.185737,35.984845&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002135s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009762s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1684165644,`v1`=0.021221,`v2`=0.01283,`v3`=0.018452,`v4`=-0.00611,`v5`=12.42,`t`=23.646067,`h`=78.251404,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.185737,35.984845',`update_time`=1684165645 WHERE `imei` = '868922055680850' [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010948s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055680850' , 1684165644 , 0.021221 , 0.01283 , 0.018452 , -0.00611 , 12.42 , 23.646067 , 78.251404 , 25 , '898604650119C1078510' , '460048590708510' , -0 , '120.185737,35.984845' , 1684165645) [ RunTime:0.001318s ]