--------------------------------------------------------------- [ 2022-11-09T00:38:27+08:00 ] 39.144.1.65 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002343s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011159s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2022-11-09T00:38:28+08:00 ] 39.144.1.65 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667925507&v1=0.024712&v2=0.022218&v3=0.024983&v4=0.024953&v5=12.060000&t=16.020523&h=55.233521&rssi=15&ccid=898604650119C1053139&imsi=460048590503139&v6=-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.009554s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1667925507,`v1`=0.024712,`v2`=0.022218,`v3`=0.024983,`v4`=0.024953,`v5`=12.06,`t`=16.020523,`h`=55.233521,`rssi`=15,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667925508 WHERE `imei` = '868922056976208' [ RunTime:0.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011313s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667925507 , 0.024712 , 0.022218 , 0.024983 , 0.024953 , 12.06 , 16.020523 , 55.233521 , 15 , '898604650119C1053139' , '460048590503139' , -0 , 1667925508) [ RunTime:0.000734s ] --------------------------------------------------------------- [ 2022-11-09T01:06:52+08:00 ] 39.144.6.145 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.009736s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2022-11-09T01:06:55+08:00 ] 39.144.6.145 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667927212&v1=0.007013&v2=0.019923&v3=0.007134&v4=0.007495&v5=11.700000&t=16.138395&h=59.269516&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001607s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010380s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1667927212,`v1`=0.007013,`v2`=0.019923,`v3`=0.007134,`v4`=0.007495,`v5`=11.7,`t`=16.138395,`h`=59.269516,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667927215 WHERE `imei` = '868922055677740' [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010880s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667927212 , 0.007013 , 0.019923 , 0.007134 , 0.007495 , 11.7 , 16.138395 , 59.269516 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1667927215) [ RunTime:0.000637s ] --------------------------------------------------------------- [ 2022-11-09T01:06:57+08:00 ] 39.144.6.145 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667912772&v1=0.006953&v2=0.018045&v3=0.007224&v4=0.007555&v5=11.880000&t=16.610298&h=59.238998&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-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.009368s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000594s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1667912772,`v1`=0.006953,`v2`=0.018045,`v3`=0.007224,`v4`=0.007555,`v5`=11.88,`t`=16.610298,`h`=59.238998,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667927217 WHERE `imei` = '868922055677740' [ RunTime:0.000466s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010367s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667912772 , 0.006953 , 0.018045 , 0.007224 , 0.007555 , 11.88 , 16.610298 , 59.238998 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1667927217) [ RunTime:0.000499s ] --------------------------------------------------------------- [ 2022-11-09T02:03:55+08:00 ] 218.204.252.69 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010254s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2022-11-09T02:03:55+08:00 ] 39.144.5.32 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001730s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008391s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000632s ] --------------------------------------------------------------- [ 2022-11-09T02:04:03+08:00 ] 218.204.252.69 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221109&time=020301&v1=-00.647&v2=+00.001&v3=-00.322&v4=-00.003&v5=05.9&t=+09.3&h=61.4&rssi=+227&ccid=4600485905031430000099m9990000000111000000g6950,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001614s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010789s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221109',`time`='020301',`v1`=-0.647,`v2`=0.001,`v3`=-0.322,`v4`=-0.003,`v5`=5.9,`t`=9.3,`h`=61.4,`rssi`=227,`ccid`='4600485905031430000099m9990000000111000000g6950,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667930643 WHERE `imei` = '868922055644013' [ RunTime:0.000656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011581s ] [ 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' , '221109' , '020301' , -0.647 , 0.001 , -0.322 , -0.003 , 5.9 , 9.3 , 61.4 , 227 , '4600485905031430000099m9990000000111000000g6950,N,00E000=-00.000' , 0 , 0 , 1667930643 , 1667930643) [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2022-11-09T02:04:04+08:00 ] 39.144.5.32 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221109&time=020301&v1=-01.113&v2=+00.042&v3=-00.980&v4=-00.041&v5=05.9&t=+08.4&h=57.4&rssi=+228&ccid=4600485905031420000099m9990000000135000001g1260,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010124s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221109',`time`='020301',`v1`=-1.113,`v2`=0.042,`v3`=-0.98,`v4`=-0.041,`v5`=5.9,`t`=8.4,`h`=57.4,`rssi`=228,`ccid`='4600485905031420000099m9990000000135000001g1260,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667930644 WHERE `imei` = '868922055643643' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010448s ] [ 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' , '221109' , '020301' , -1.113 , 0.042 , -0.98 , -0.041 , 5.9 , 8.4 , 57.4 , 228 , '4600485905031420000099m9990000000135000001g1260,N,00E000=-00.000' , 0 , 0 , 1667930644 , 1667930644) [ RunTime:0.000544s ] --------------------------------------------------------------- [ 2022-11-09T04:38:28+08:00 ] 218.204.252.126 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002682s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016068s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000790s ] --------------------------------------------------------------- [ 2022-11-09T04:38:30+08:00 ] 218.204.252.126 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667939908&v1=0.024712&v2=0.024617&v3=0.024923&v4=0.024953&v5=12.060000&t=15.398467&h=55.210632&rssi=15&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001793s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010612s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000907s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1667939908,`v1`=0.024712,`v2`=0.024617,`v3`=0.024923,`v4`=0.024953,`v5`=12.06,`t`=15.398467,`h`=55.210632,`rssi`=15,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667939910 WHERE `imei` = '868922056976208' [ RunTime:0.000622s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010578s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667939908 , 0.024712 , 0.024617 , 0.024923 , 0.024953 , 12.06 , 15.398467 , 55.210632 , 15 , '898604650119C1053139' , '460048590503139' , -0 , 1667939910) [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2022-11-09T05:07:21+08:00 ] 117.132.195.52 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002071s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009595s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000603s ] --------------------------------------------------------------- [ 2022-11-09T05:07:23+08:00 ] 117.132.195.52 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667941641&v1=0.007013&v2=0.015959&v3=0.007104&v4=0.007375&v5=11.700000&t=15.527065&h=59.216110&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008806s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1667941641,`v1`=0.007013,`v2`=0.015959,`v3`=0.007104,`v4`=0.007375,`v5`=11.7,`t`=15.527065,`h`=59.21611,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667941643 WHERE `imei` = '868922055677740' [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009735s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667941641 , 0.007013 , 0.015959 , 0.007104 , 0.007375 , 11.7 , 15.527065 , 59.21611 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1667941643) [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2022-11-09T08:38:29+08:00 ] 39.144.5.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002108s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010360s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000739s ] --------------------------------------------------------------- [ 2022-11-09T08:38:30+08:00 ] 39.144.5.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667954309&v1=0.024773&v2=0.025138&v3=0.025104&v4=0.025074&v5=11.880000&t=17.414785&h=53.906006&rssi=15&ccid=898604650119C1053139&imsi=460048590503139&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.010584s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1667954309,`v1`=0.024773,`v2`=0.025138,`v3`=0.025104,`v4`=0.025074,`v5`=11.88,`t`=17.414785,`h`=53.906006,`rssi`=15,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667954310 WHERE `imei` = '868922056976208' [ RunTime:0.000590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011709s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667954309 , 0.024773 , 0.025138 , 0.025104 , 0.025074 , 11.88 , 17.414785 , 53.906006 , 15 , '898604650119C1053139' , '460048590503139' , -0 , 1667954310) [ RunTime:0.000812s ] --------------------------------------------------------------- [ 2022-11-09T09:07:46+08:00 ] 221.178.124.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011240s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000800s ] --------------------------------------------------------------- [ 2022-11-09T09:07:48+08:00 ] 221.178.124.249 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667956066&v1=0.007134&v2=0.481904&v3=0.007344&v4=0.007495&v5=11.700000&t=18.455011&h=58.468430&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001623s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009780s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1667956066,`v1`=0.007134,`v2`=0.481904,`v3`=0.007344,`v4`=0.007495,`v5`=11.7,`t`=18.455011,`h`=58.46843,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667956068 WHERE `imei` = '868922055677740' [ RunTime:0.000999s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012416s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667956066 , 0.007134 , 0.481904 , 0.007344 , 0.007495 , 11.7 , 18.455011 , 58.46843 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1667956068) [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2022-11-09T09:56:02+08:00 ] 218.204.253.175 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002281s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010464s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000927s ] --------------------------------------------------------------- [ 2022-11-09T09:56:03+08:00 ] 218.204.253.175 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667958962&v1=0.007856&v2=0.766665&v3=0.008247&v4=0.009301&v5=11.700000&t=19.624046&h=59.345810&rssi=30&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001561s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009909s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1667958962,`v1`=0.007856,`v2`=0.766665,`v3`=0.008247,`v4`=0.009301,`v5`=11.7,`t`=19.624046,`h`=59.34581,`rssi`=30,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667958963 WHERE `imei` = '868922055677740' [ RunTime:0.000576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010385s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667958962 , 0.007856 , 0.766665 , 0.008247 , 0.009301 , 11.7 , 19.624046 , 59.34581 , 30 , '89860426102071188504' , '460044618415254' , -0 , 1667958963) [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2022-11-09T12:01:54+08:00 ] 112.9.188.102 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002250s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009315s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2022-11-09T12:01:55+08:00 ] 112.9.188.102 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009736s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2022-11-09T12:01:58+08:00 ] 112.9.188.102 GET /home/show/index.html [ 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.011015s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000492s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000688s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2022-11-09T12:02:01+08:00 ] 112.9.188.102 GET /home/show/read/id/34/imei/868922055681494.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001453s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008681s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010085s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.001226s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681494' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000906s ] --------------------------------------------------------------- [ 2022-11-09T12:02:26+08:00 ] 112.9.188.102 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001399s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008278s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000426s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000747s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000579s ] --------------------------------------------------------------- [ 2022-11-09T12:02:28+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001505s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000809s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009160s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003887s ] --------------------------------------------------------------- [ 2022-11-09T12:02:41+08:00 ] 112.9.188.102 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009885s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000469s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000726s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000573s ] --------------------------------------------------------------- [ 2022-11-09T12:02:42+08:00 ] 112.9.188.102 GET /home/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001595s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009012s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000690s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009996s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000532s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001637s ] --------------------------------------------------------------- [ 2022-11-09T12:38:32+08:00 ] 39.144.11.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002427s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009302s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000734s ] --------------------------------------------------------------- [ 2022-11-09T12:38:33+08:00 ] 39.144.11.103 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667968712&v1=0.025074&v2=7.536993&v3=0.025555&v4=0.025615&v5=11.880000&t=20.771740&h=53.761047&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001511s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008706s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1667968712,`v1`=0.025074,`v2`=7.536993,`v3`=0.025555,`v4`=0.025615,`v5`=11.88,`t`=20.77174,`h`=53.761047,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667968713 WHERE `imei` = '868922056976208' [ RunTime:0.000583s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011276s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667968712 , 0.025074 , 7.536993 , 0.025555 , 0.025615 , 11.88 , 20.77174 , 53.761047 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1667968713) [ RunTime:0.000546s ] --------------------------------------------------------------- [ 2022-11-09T13:56:28+08:00 ] 117.132.195.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002137s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010782s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2022-11-09T13:56:30+08:00 ] 117.132.195.153 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667973388&v1=0.007314&v2=0.192761&v3=0.007495&v4=0.010746&v5=11.700000&t=19.849272&h=59.574692&rssi=14&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001522s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009634s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1667973388,`v1`=0.007314,`v2`=0.192761,`v3`=0.007495,`v4`=0.010746,`v5`=11.7,`t`=19.849272,`h`=59.574692,`rssi`=14,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1667973390 WHERE `imei` = '868922055677740' [ RunTime:0.000573s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011096s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667973388 , 0.007314 , 0.192761 , 0.007495 , 0.010746 , 11.7 , 19.849272 , 59.574692 , 14 , '89860426102071188504' , '460044618415254' , -0 , 1667973390) [ RunTime:0.000577s ] --------------------------------------------------------------- [ 2022-11-09T14:03:54+08:00 ] 39.144.15.152 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001652s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009877s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2022-11-09T14:03:55+08:00 ] 39.144.11.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ 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.010633s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000648s ] --------------------------------------------------------------- [ 2022-11-09T14:04:03+08:00 ] 39.144.15.152 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221109&time=140301&v1=-00.696&v2=+00.001&v3=-00.006&v4=-00.010&v5=06.0&t=+19.6&h=59.4&rssi=+225&ccid=4600485905031430000099m9990000000050000000g7700,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001429s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013790s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221109',`time`='140301',`v1`=-0.696,`v2`=0.001,`v3`=-0.006,`v4`=-0.01,`v5`=6,`t`=19.6,`h`=59.4,`rssi`=225,`ccid`='4600485905031430000099m9990000000050000000g7700,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667973843 WHERE `imei` = '868922055644013' [ RunTime:0.000517s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009189s ] [ 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' , '221109' , '140301' , -0.696 , 0.001 , -0.006 , -0.01 , 6 , 19.6 , 59.4 , 225 , '4600485905031430000099m9990000000050000000g7700,N,00E000=-00.000' , 0 , 0 , 1667973843 , 1667973843) [ RunTime:0.000488s ] --------------------------------------------------------------- [ 2022-11-09T14:04:04+08:00 ] 39.144.11.250 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221109&time=140301&v1=-01.116&v2=+00.075&v3=-00.969&v4=-00.040&v5=05.9&t=+19.4&h=55.3&rssi=+229&ccid=4600485905031420000099m9990000000150000001g1290,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.009750s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221109',`time`='140301',`v1`=-1.116,`v2`=0.075,`v3`=-0.969,`v4`=-0.04,`v5`=5.9,`t`=19.4,`h`=55.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000150000001g1290,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667973843 WHERE `imei` = '868922055643643' [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010415s ] [ 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' , '221109' , '140301' , -1.116 , 0.075 , -0.969 , -0.04 , 5.9 , 19.4 , 55.3 , 229 , '4600485905031420000099m9990000000150000001g1290,N,00E000=-00.000' , 0 , 0 , 1667973844 , 1667973844) [ RunTime:0.000483s ] --------------------------------------------------------------- [ 2022-11-09T16:38:26+08:00 ] 39.144.7.74 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ 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.010414s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2022-11-09T16:38:28+08:00 ] 39.144.7.74 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667983106&v1=0.025013&v2=1.337960&v3=0.025194&v4=0.025375&v5=11.880000&t=18.583820&h=55.538696&rssi=15&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009664s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1667983106,`v1`=0.025013,`v2`=1.33796,`v3`=0.025194,`v4`=0.025375,`v5`=11.88,`t`=18.58382,`h`=55.538696,`rssi`=15,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667983108 WHERE `imei` = '868922056976208' [ RunTime:0.000548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010853s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667983106 , 0.025013 , 1.33796 , 0.025194 , 0.025375 , 11.88 , 18.58382 , 55.538696 , 15 , '898604650119C1053139' , '460048590503139' , -0 , 1667983108) [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2022-11-09T19:44:17+08:00 ] 39.144.15.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002091s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010610s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2022-11-09T19:44:18+08:00 ] 39.144.15.120 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1667994257&v1=0.026278&v2=0.228122&v3=0.022395&v4=-0.000933&v5=6.660000&t=12.920969&h=65.044922&rssi=22&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001806s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010675s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000749s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1667994257,`v1`=0.026278,`v2`=0.228122,`v3`=0.022395,`v4`=-0.000933,`v5`=6.66,`t`=12.920969,`h`=65.044922,`rssi`=22,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1667994258 WHERE `imei` = '868922055644211' [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010440s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1667994257 , 0.026278 , 0.228122 , 0.022395 , -0.000933 , 6.66 , 12.920969 , 65.044922 , 22 , '89860426102071188505' , '460044618415255' , -0 , 1667994258) [ RunTime:0.000727s ] --------------------------------------------------------------- [ 2022-11-09T20:38:26+08:00 ] 221.178.127.64 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002231s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009968s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000755s ] --------------------------------------------------------------- [ 2022-11-09T20:38:28+08:00 ] 221.178.127.64 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1667997506&v1=0.024773&v2=0.445604&v3=0.025043&v4=0.025134&v5=11.880000&t=16.942881&h=55.447144&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001471s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010686s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1667997506,`v1`=0.024773,`v2`=0.445604,`v3`=0.025043,`v4`=0.025134,`v5`=11.88,`t`=16.942881,`h`=55.447144,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1667997508 WHERE `imei` = '868922056976208' [ RunTime:0.000601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010796s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1667997506 , 0.024773 , 0.445604 , 0.025043 , 0.025134 , 11.88 , 16.942881 , 55.447144 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1667997508) [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2022-11-09T21:57:17+08:00 ] 221.178.127.181 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002091s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011564s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2022-11-09T21:57:19+08:00 ] 221.178.127.181 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1668002237&v1=0.007555&v2=0.104621&v3=0.008067&v4=0.019114&v5=11.700000&t=16.846251&h=59.322922&rssi=15&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010217s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000590s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1668002237,`v1`=0.007555,`v2`=0.104621,`v3`=0.008067,`v4`=0.019114,`v5`=11.7,`t`=16.846251,`h`=59.322922,`rssi`=15,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1668002239 WHERE `imei` = '868922055677740' [ RunTime:0.000518s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010496s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1668002237 , 0.007555 , 0.104621 , 0.008067 , 0.019114 , 11.7 , 16.846251 , 59.322922 , 15 , '89860426102071188504' , '460044618415254' , -0 , 1668002239) [ RunTime:0.000553s ] --------------------------------------------------------------- [ 2022-11-09T21:57:21+08:00 ] 221.178.127.181 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1667987799&v1=0.007375&v2=0.045583&v3=0.007706&v4=0.019475&v5=11.880000&t=17.479031&h=59.521286&rssi=15&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001375s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009464s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1667987799,`v1`=0.007375,`v2`=0.045583,`v3`=0.007706,`v4`=0.019475,`v5`=11.88,`t`=17.479031,`h`=59.521286,`rssi`=15,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1668002241 WHERE `imei` = '868922055677740' [ RunTime:0.000481s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010088s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1667987799 , 0.007375 , 0.045583 , 0.007706 , 0.019475 , 11.88 , 17.479031 , 59.521286 , 15 , '89860426102071188504' , '460044618415254' , -0 , 1668002241) [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2022-11-09T22:00:50+08:00 ] 117.132.191.163 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002059s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009547s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2022-11-09T22:00:58+08:00 ] 117.132.191.163 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221109&time=220001&v1=-01.275&v2=+00.016&v3=-01.106&v4=-00.752&v5=05.9&t=+12.7&h=81.2&rssi=+220&imsi=460044618415249&v6=-00.000&a1=00.198&a2=01.290&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001622s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010192s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221109',`time`='220001',`v1`=-1.275,`v2`=0.016,`v3`=-1.106,`v4`=-0.752,`v5`=5.9,`t`=12.7,`h`=81.2,`rssi`=220,`imsi`='460044618415249',`v6`=-0,`a1`=0.198,`a2`=1.29,`update_time`=1668002458 WHERE `imei` = '868922055684076' [ RunTime:0.000523s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015385s ] [ 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' , '221109' , '220001' , -1.275 , 0.016 , -1.106 , -0.752 , 5.9 , 12.7 , 81.2 , 220 , '460044618415249' , -0 , 0.198 , 1.29 , 1668002458 , 1668002458) [ RunTime:0.000507s ]