---------------------------------------------------------------
[ 2022-11-08T00:38:29+08:00 ] 39.144.5.69 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011225s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000796s ]
---------------------------------------------------------------
[ 2022-11-08T00:38:30+08:00 ] 39.144.5.69 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667839109&v1=0.024592&v2=0.027955&v3=0.024893&v4=0.024953&v5=12.060000&t=15.473542&h=55.355591&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010046s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000681s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1667839109,`v1`=0.024592,`v2`=0.027955,`v3`=0.024893,`v4`=0.024953,`v5`=12.06,`t`=15.473542,`h`=55.355591,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667839110  WHERE  `imei` = '868922056976208' [ RunTime:0.000780s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011693s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667839109 , 0.024592 , 0.027955 , 0.024893 , 0.024953 , 12.06 , 15.473542 , 55.355591 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1667839110) [ RunTime:0.000640s ]
---------------------------------------------------------------
[ 2022-11-08T01:04:19+08:00 ] 39.144.11.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002159s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009830s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000607s ]
---------------------------------------------------------------
[ 2022-11-08T01:04:20+08:00 ] 39.144.11.100 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667840659&v1=0.006953&v2=0.026390&v3=0.007104&v4=0.007314&v5=11.700000&t=15.612865&h=59.155075&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001487s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010849s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000614s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1667840659,`v1`=0.006953,`v2`=0.02639,`v3`=0.007104,`v4`=0.007314,`v5`=11.7,`t`=15.612865,`h`=59.155075,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667840660  WHERE  `imei` = '868922055677740' [ RunTime:0.000520s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008319s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667840659 , 0.006953 , 0.02639 , 0.007104 , 0.007314 , 11.7 , 15.612865 , 59.155075 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1667840660) [ RunTime:0.000555s ]
---------------------------------------------------------------
[ 2022-11-08T02:03:54+08:00 ] 218.204.252.151 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002023s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011373s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000676s ]
---------------------------------------------------------------
[ 2022-11-08T02:03:55+08:00 ] 39.144.12.25 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001448s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011146s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000658s ]
---------------------------------------------------------------
[ 2022-11-08T02:04:03+08:00 ] 218.204.252.151 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221108&time=020301&v1=-01.109&v2=+00.036&v3=-00.980&v4=-00.042&v5=06.0&t=+07.0&h=57.3&rssi=+229&ccid=4600485905031420000099m9990000000131000001g1230,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001358s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008272s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000697s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='221108',`time`='020301',`v1`=-1.109,`v2`=0.036,`v3`=-0.98,`v4`=-0.042,`v5`=6,`t`=7,`h`=57.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000131000001g1230,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667844243  WHERE  `imei` = '868922055643643' [ RunTime:0.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009897s ]
[ 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' , '221108' , '020301' , -1.109 , 0.036 , -0.98 , -0.042 , 6 , 7 , 57.3 , 229 , '4600485905031420000099m9990000000131000001g1230,N,00E000=-00.000' , 0 , 0 , 1667844243 , 1667844243) [ RunTime:0.000552s ]
---------------------------------------------------------------
[ 2022-11-08T02:04:04+08:00 ] 39.144.12.25 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221108&time=020301&v1=-00.653&v2=+00.001&v3=-00.321&v4=-00.004&v5=05.9&t=+07.9&h=61.6&rssi=+225&ccid=4600485905031430000099m9990000000096000000g7070,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001542s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010410s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000675s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='221108',`time`='020301',`v1`=-0.653,`v2`=0.001,`v3`=-0.321,`v4`=-0.004,`v5`=5.9,`t`=7.9,`h`=61.6,`rssi`=225,`ccid`='4600485905031430000099m9990000000096000000g7070,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667844244  WHERE  `imei` = '868922055644013' [ RunTime:0.000631s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008877s ]
[ 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' , '221108' , '020301' , -0.653 , 0.001 , -0.321 , -0.004 , 5.9 , 7.9 , 61.6 , 225 , '4600485905031430000099m9990000000096000000g7070,N,00E000=-00.000' , 0 , 0 , 1667844244 , 1667844244) [ RunTime:0.000524s ]
---------------------------------------------------------------
[ 2022-11-08T04:38:27+08:00 ] 39.144.18.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.003671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016294s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.001223s ]
---------------------------------------------------------------
[ 2022-11-08T04:38:28+08:00 ] 39.144.18.87 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667853507&v1=0.024652&v2=0.042349&v3=0.024863&v4=0.024893&v5=12.060000&t=14.851487&h=55.279297&rssi=15&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009696s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000652s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1667853507,`v1`=0.024652,`v2`=0.042349,`v3`=0.024863,`v4`=0.024893,`v5`=12.06,`t`=14.851487,`h`=55.279297,`rssi`=15,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667853508  WHERE  `imei` = '868922056976208' [ RunTime:0.000566s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010132s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667853507 , 0.024652 , 0.042349 , 0.024863 , 0.024893 , 12.06 , 14.851487 , 55.279297 , 15 , '898604650119C1053139' , '460048590503139' , -0 , 1667853508) [ RunTime:0.000632s ]
---------------------------------------------------------------
[ 2022-11-08T05:04:44+08:00 ] 39.144.11.155 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002155s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009721s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000656s ]
---------------------------------------------------------------
[ 2022-11-08T05:04:46+08:00 ] 39.144.11.155 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667855084&v1=0.006893&v2=0.022009&v3=0.007013&v4=0.007314&v5=11.700000&t=15.108788&h=59.078781&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001898s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009221s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000604s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1667855084,`v1`=0.006893,`v2`=0.022009,`v3`=0.007013,`v4`=0.007314,`v5`=11.7,`t`=15.108788,`h`=59.078781,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667855085  WHERE  `imei` = '868922055677740' [ RunTime:0.000536s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.017151s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667855084 , 0.006893 , 0.022009 , 0.007013 , 0.007314 , 11.7 , 15.108788 , 59.078781 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1667855086) [ RunTime:0.000594s ]
---------------------------------------------------------------
[ 2022-11-08T08:38:27+08:00 ] 117.132.191.90 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002326s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011228s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000716s ]
---------------------------------------------------------------
[ 2022-11-08T08:38:28+08:00 ] 117.132.191.90 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667867907&v1=0.024592&v2=0.036404&v3=0.024953&v4=0.025013&v5=12.060000&t=16.052698&h=54.356140&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001364s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009933s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000596s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1667867907,`v1`=0.024592,`v2`=0.036404,`v3`=0.024953,`v4`=0.025013,`v5`=12.06,`t`=16.052698,`h`=54.35614,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667867908  WHERE  `imei` = '868922056976208' [ RunTime:0.000528s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010340s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667867907 , 0.024592 , 0.036404 , 0.024953 , 0.025013 , 12.06 , 16.052698 , 54.35614 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1667867908) [ RunTime:0.000548s ]
---------------------------------------------------------------
[ 2022-11-08T09:05:10+08:00 ] 39.144.5.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002417s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010383s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000749s ]
---------------------------------------------------------------
[ 2022-11-08T09:05:12+08:00 ] 39.144.5.141 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667869510&v1=0.006953&v2=0.424013&v3=0.007164&v4=0.007555&v5=11.700000&t=17.071476&h=58.277695&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001405s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009724s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000654s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1667869510,`v1`=0.006953,`v2`=0.424013,`v3`=0.007164,`v4`=0.007555,`v5`=11.7,`t`=17.071476,`h`=58.277695,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667869512  WHERE  `imei` = '868922055677740' [ RunTime:0.000521s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010132s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667869510 , 0.006953 , 0.424013 , 0.007164 , 0.007555 , 11.7 , 17.071476 , 58.277695 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1667869512) [ RunTime:0.000540s ]
---------------------------------------------------------------
[ 2022-11-08T12:38:27+08:00 ] 221.178.127.193 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002340s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012184s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000722s ]
---------------------------------------------------------------
[ 2022-11-08T12:38:28+08:00 ] 221.178.127.193 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667882307&v1=0.025074&v2=0.063732&v3=0.025344&v4=0.025254&v5=12.060000&t=19.162975&h=53.875488&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001594s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010964s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000778s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1667882307,`v1`=0.025074,`v2`=0.063732,`v3`=0.025344,`v4`=0.025254,`v5`=12.06,`t`=19.162975,`h`=53.875488,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667882308  WHERE  `imei` = '868922056976208' [ RunTime:0.000645s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011815s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667882307 , 0.025074 , 0.063732 , 0.025344 , 0.025254 , 12.06 , 19.162975 , 53.875488 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1667882308) [ RunTime:0.000662s ]
---------------------------------------------------------------
[ 2022-11-08T13:05:36+08:00 ] 39.144.7.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ 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.008975s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000584s ]
---------------------------------------------------------------
[ 2022-11-08T13:05:37+08:00 ] 39.144.7.21 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667883936&v1=0.007375&v2=0.096068&v3=0.007405&v4=0.007736&v5=11.700000&t=19.827822&h=59.399216&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001396s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008561s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000621s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1667883936,`v1`=0.007375,`v2`=0.096068,`v3`=0.007405,`v4`=0.007736,`v5`=11.7,`t`=19.827822,`h`=59.399216,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667883937  WHERE  `imei` = '868922055677740' [ RunTime:0.000526s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010628s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667883936 , 0.007375 , 0.096068 , 0.007405 , 0.007736 , 11.7 , 19.827822 , 59.399216 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1667883937) [ RunTime:0.000559s ]
---------------------------------------------------------------
[ 2022-11-08T14:03:55+08:00 ] 117.132.194.94 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011242s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000684s ]
---------------------------------------------------------------
[ 2022-11-08T14:03:55+08:00 ] 39.144.18.215 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001945s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009133s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000899s ]
---------------------------------------------------------------
[ 2022-11-08T14:04:03+08:00 ] 117.132.194.94 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221108&time=140301&v1=-00.724&v2=+00.001&v3=+00.000&v4=-00.008&v5=06.0&t=+18.1&h=59.5&rssi=+226&ccid=4600485905031430000099m9990000000051000000g7980,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001717s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009223s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000702s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='221108',`time`='140301',`v1`=-0.724,`v2`=0.001,`v3`=0,`v4`=-0.008,`v5`=6,`t`=18.1,`h`=59.5,`rssi`=226,`ccid`='4600485905031430000099m9990000000051000000g7980,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667887443  WHERE  `imei` = '868922055644013' [ RunTime:0.000596s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010537s ]
[ 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' , '221108' , '140301' , -0.724 , 0.001 , 0 , -0.008 , 6 , 18.1 , 59.5 , 226 , '4600485905031430000099m9990000000051000000g7980,N,00E000=-00.000' , 0 , 0 , 1667887443 , 1667887443) [ RunTime:0.000641s ]
---------------------------------------------------------------
[ 2022-11-08T14:04:04+08:00 ] 39.144.18.215 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221108&time=140301&v1=-01.112&v2=+00.072&v3=-00.975&v4=-00.042&v5=06.2&t=+16.2&h=55.2&rssi=+229&ccid=4600485905031420000099m9990000000139000001g1250,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.015424s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010111s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000740s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='221108',`time`='140301',`v1`=-1.112,`v2`=0.072,`v3`=-0.975,`v4`=-0.042,`v5`=6.2,`t`=16.2,`h`=55.2,`rssi`=229,`ccid`='4600485905031420000099m9990000000139000001g1250,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667887443  WHERE  `imei` = '868922055643643' [ RunTime:0.000503s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010496s ]
[ 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' , '221108' , '140301' , -1.112 , 0.072 , -0.975 , -0.042 , 6.2 , 16.2 , 55.2 , 229 , '4600485905031420000099m9990000000139000001g1250,N,00E000=-00.000' , 0 , 0 , 1667887444 , 1667887444) [ RunTime:0.000543s ]
---------------------------------------------------------------
[ 2022-11-08T16:38:26+08:00 ] 117.132.195.65 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002249s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011456s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.001011s ]
---------------------------------------------------------------
[ 2022-11-08T16:38:28+08:00 ] 117.132.195.65 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667896706&v1=0.024893&v2=0.057369&v3=0.025164&v4=0.025194&v5=11.700000&t=18.122643&h=55.172485&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011454s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000680s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1667896706,`v1`=0.024893,`v2`=0.057369,`v3`=0.025164,`v4`=0.025194,`v5`=11.7,`t`=18.122643,`h`=55.172485,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667896708  WHERE  `imei` = '868922056976208' [ RunTime:0.000582s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011148s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667896706 , 0.024893 , 0.057369 , 0.025164 , 0.025194 , 11.7 , 18.122643 , 55.172485 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1667896708) [ RunTime:0.000623s ]
---------------------------------------------------------------
[ 2022-11-08T17:06:01+08:00 ] 39.144.12.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002298s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011748s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000764s ]
---------------------------------------------------------------
[ 2022-11-08T17:06:03+08:00 ] 39.144.12.149 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667898361&v1=0.007013&v2=0.122353&v3=0.007254&v4=0.007495&v5=11.880000&t=17.972383&h=59.689133&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001719s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009819s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000604s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055677740',`create_time`=1667898361,`v1`=0.007013,`v2`=0.122353,`v3`=0.007254,`v4`=0.007495,`v5`=11.88,`t`=17.972383,`h`=59.689133,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667898362  WHERE  `imei` = '868922055677740' [ RunTime:0.000693s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010175s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667898361 , 0.007013 , 0.122353 , 0.007254 , 0.007495 , 11.88 , 17.972383 , 59.689133 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1667898363) [ RunTime:0.000555s ]
---------------------------------------------------------------
[ 2022-11-08T19:44:18+08:00 ] 117.132.194.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211
[ sql ] [ DB ] CONNECT:[ UseTime:0.002329s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011513s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000717s ]
---------------------------------------------------------------
[ 2022-11-08T19:44:19+08:00 ] 117.132.194.237 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1667907858&v1=0.025916&v2=0.173151&v3=0.021672&v4=-0.002077&v5=6.660000&t=10.486372&h=65.037292&rssi=22&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001790s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010827s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000628s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644211',`create_time`=1667907858,`v1`=0.025916,`v2`=0.173151,`v3`=0.021672,`v4`=-0.002077,`v5`=6.66,`t`=10.486372,`h`=65.037292,`rssi`=22,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1667907859  WHERE  `imei` = '868922055644211' [ RunTime:0.000894s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010286s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1667907858 , 0.025916 , 0.173151 , 0.021672 , -0.002077 , 6.66 , 10.486372 , 65.037292 , 22 , '89860426102071188505' , '460044618415255' , -0 , 1667907859) [ RunTime:0.000600s ]
---------------------------------------------------------------
[ 2022-11-08T20:10:19+08:00 ] 112.226.103.28 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002194s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010513s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000550s ]
---------------------------------------------------------------
[ 2022-11-08T20:10:22+08:00 ] 112.226.103.28 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001504s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009681s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000352s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000714s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000604s ]
---------------------------------------------------------------
[ 2022-11-08T20:10:29+08:00 ] 112.226.103.28 GET /admin/show/read/id/35/imei/868922056976208.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009844s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 35 LIMIT 1 [ RunTime:0.000634s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010845s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000472s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003731s ]
---------------------------------------------------------------
[ 2022-11-08T20:10:36+08:00 ] 112.226.103.28 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002192s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010594s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000348s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000692s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000646s ]
---------------------------------------------------------------
[ 2022-11-08T20:21:59+08:00 ] 112.226.103.28 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002561s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013807s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'user1'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001479s ]
---------------------------------------------------------------
[ 2022-11-08T20:22:00+08:00 ] 112.226.103.28 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002480s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010530s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000837s ]
---------------------------------------------------------------
[ 2022-11-08T20:22:02+08:00 ] 112.226.103.28 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001738s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010682s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'user1' LIMIT 1 [ RunTime:0.000494s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000652s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000512s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010745s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` IS NULL  AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.000509s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` IS NULL  AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.000446s ]
---------------------------------------------------------------
[ 2022-11-08T20:38:27+08:00 ] 39.144.15.224 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002130s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010234s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000648s ]
---------------------------------------------------------------
[ 2022-11-08T20:38:29+08:00 ] 39.144.15.224 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667911107&v1=0.024773&v2=0.034630&v3=0.024983&v4=0.024833&v5=12.060000&t=16.460251&h=55.340332&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010857s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000635s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1667911107,`v1`=0.024773,`v2`=0.03463,`v3`=0.024983,`v4`=0.024833,`v5`=12.06,`t`=16.460251,`h`=55.340332,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667911109  WHERE  `imei` = '868922056976208' [ RunTime:0.000561s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011144s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667911107 , 0.024773 , 0.03463 , 0.024983 , 0.024833 , 12.06 , 16.460251 , 55.340332 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1667911109) [ RunTime:0.000589s ]
---------------------------------------------------------------
[ 2022-11-08T21:24:32+08:00 ] 112.226.103.28 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009006s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'user1' LIMIT 1 [ RunTime:0.000489s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000592s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000511s ]
---------------------------------------------------------------
[ 2022-11-08T22:01:43+08:00 ] 39.144.2.4 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002295s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011326s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000679s ]
---------------------------------------------------------------
[ 2022-11-08T22:01:51+08:00 ] 39.144.2.4 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221108&time=220101&v1=-01.276&v2=+00.017&v3=-01.105&v4=-00.755&v5=05.9&t=+10.4&h=81.2&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.201&a2=01.292&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010961s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000634s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='221108',`time`='220101',`v1`=-1.276,`v2`=0.017,`v3`=-1.105,`v4`=-0.755,`v5`=5.9,`t`=10.4,`h`=81.2,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.201,`a2`=1.292,`update_time`=1667916111  WHERE  `imei` = '868922055684076' [ RunTime:0.000783s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010571s ]
[ 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' , '221108' , '220101' , -1.276 , 0.017 , -1.105 , -0.755 , 5.9 , 10.4 , 81.2 , 227 , '460044618415249' , -0 , 0.201 , 1.292 , 1667916111 , 1667916111) [ RunTime:0.000575s ]