--------------------------------------------------------------- [ 2022-11-23T00:38:26+08:00 ] 39.144.5.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002392s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013561s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000904s ] --------------------------------------------------------------- [ 2022-11-23T00:38:27+08:00 ] 39.144.5.180 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1669135106&v1=0.025013&v2=1.250446&v3=0.025344&v4=0.024833&v5=11.520000&t=13.403599&h=56.164307&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001640s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010706s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000735s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1669135106,`v1`=0.025013,`v2`=1.250446,`v3`=0.025344,`v4`=0.024833,`v5`=11.52,`t`=13.403599,`h`=56.164307,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1669135107 WHERE `imei` = '868922056976208' [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012669s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1669135106 , 0.025013 , 1.250446 , 0.025344 , 0.024833 , 11.52 , 13.403599 , 56.164307 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1669135107) [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2022-11-23T02:03:54+08:00 ] 223.104.255.182 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002325s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009892s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000744s ] --------------------------------------------------------------- [ 2022-11-23T02:03:55+08:00 ] 39.144.2.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009016s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2022-11-23T02:04:03+08:00 ] 223.104.255.182 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221123&time=020301&v1=-00.502&v2=+00.001&v3=-00.364&v4=-00.003&v5=05.9&t=+08.1&h=63.2&rssi=+224&ccid=4600485905031430000099m9990000000056000000g5320,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001571s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009872s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221123',`time`='020301',`v1`=-0.502,`v2`=0.001,`v3`=-0.364,`v4`=-0.003,`v5`=5.9,`t`=8.1,`h`=63.2,`rssi`=224,`ccid`='4600485905031430000099m9990000000056000000g5320,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1669140243 WHERE `imei` = '868922055644013' [ RunTime:0.000744s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012722s ] [ 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' , '221123' , '020301' , -0.502 , 0.001 , -0.364 , -0.003 , 5.9 , 8.1 , 63.2 , 224 , '4600485905031430000099m9990000000056000000g5320,N,00E000=-00.000' , 0 , 0 , 1669140243 , 1669140243) [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2022-11-23T02:04:04+08:00 ] 39.144.2.247 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221123&time=020301&v1=-01.173&v2=+00.042&v3=-00.992&v4=-00.032&v5=05.7&t=+07.9&h=59.8&rssi=+228&ccid=4600485905031420000099m9990000000183000001g1870,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001509s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009460s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221123',`time`='020301',`v1`=-1.173,`v2`=0.042,`v3`=-0.992,`v4`=-0.032,`v5`=5.7,`t`=7.9,`h`=59.8,`rssi`=228,`ccid`='4600485905031420000099m9990000000183000001g1870,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1669140244 WHERE `imei` = '868922055643643' [ RunTime:0.000495s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010143s ] [ 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' , '221123' , '020301' , -1.173 , 0.042 , -0.992 , -0.032 , 5.7 , 7.9 , 59.8 , 228 , '4600485905031420000099m9990000000183000001g1870,N,00E000=-00.000' , 0 , 0 , 1669140244 , 1669140244) [ RunTime:0.000462s ] --------------------------------------------------------------- [ 2022-11-23T02:08:51+08:00 ] 117.132.193.211 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002093s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010750s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2022-11-23T02:09:00+08:00 ] 117.132.193.211 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221123&time=020801&v1=-01.268&v2=+00.020&v3=-01.099&v4=-00.707&v5=05.9&t=+07.8&h=80.9&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.201&a2=01.284&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013303s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221123',`time`='020801',`v1`=-1.268,`v2`=0.02,`v3`=-1.099,`v4`=-0.707,`v5`=5.9,`t`=7.8,`h`=80.9,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.201,`a2`=1.284,`update_time`=1669140540 WHERE `imei` = '868922055684076' [ RunTime:0.000549s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010568s ] [ 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' , '221123' , '020801' , -1.268 , 0.02 , -1.099 , -0.707 , 5.9 , 7.8 , 80.9 , 227 , '460044618415249' , -0 , 0.201 , 1.284 , 1669140540 , 1669140540) [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2022-11-23T02:32:40+08:00 ] 39.144.8.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002539s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008684s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2022-11-23T02:32:41+08:00 ] 39.144.8.49 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1669141960&v1=0.007375&v2=0.059351&v3=0.007886&v4=0.018391&v5=11.520000&t=13.382050&h=59.948532&rssi=13&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001781s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010497s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1669141960,`v1`=0.007375,`v2`=0.059351,`v3`=0.007886,`v4`=0.018391,`v5`=11.52,`t`=13.38205,`h`=59.948532,`rssi`=13,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1669141961 WHERE `imei` = '868922055677740' [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010504s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1669141960 , 0.007375 , 0.059351 , 0.007886 , 0.018391 , 11.52 , 13.38205 , 59.948532 , 13 , '89860426102071188504' , '460044618415254' , -0 , 1669141961) [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2022-11-23T02:32:43+08:00 ] 39.144.8.49 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1669127522&v1=0.007314&v2=0.076145&v3=0.007796&v4=0.018753&v5=11.520000&t=13.875403&h=59.834091&rssi=13&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010010s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1669127522,`v1`=0.007314,`v2`=0.076145,`v3`=0.007796,`v4`=0.018753,`v5`=11.52,`t`=13.875403,`h`=59.834091,`rssi`=13,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1669141963 WHERE `imei` = '868922055677740' [ RunTime:0.000531s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011014s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1669127522 , 0.007314 , 0.076145 , 0.007796 , 0.018753 , 11.52 , 13.875403 , 59.834091 , 13 , '89860426102071188504' , '460044618415254' , -0 , 1669141963) [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2022-11-23T04:38:26+08:00 ] 221.178.127.116 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012606s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000860s ] --------------------------------------------------------------- [ 2022-11-23T04:38:27+08:00 ] 221.178.127.116 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1669149506&v1=0.024953&v2=1.004279&v3=0.025435&v4=0.024833&v5=11.520000&t=12.824444&h=56.225342&rssi=15&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001390s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009712s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1669149506,`v1`=0.024953,`v2`=1.004279,`v3`=0.025435,`v4`=0.024833,`v5`=11.52,`t`=12.824444,`h`=56.225342,`rssi`=15,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1669149507 WHERE `imei` = '868922056976208' [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011473s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1669149506 , 0.024953 , 1.004279 , 0.025435 , 0.024833 , 11.52 , 12.824444 , 56.225342 , 15 , '898604650119C1053139' , '460048590503139' , -0 , 1669149507) [ RunTime:0.000630s ] --------------------------------------------------------------- [ 2022-11-23T06:33:08+08:00 ] 39.144.18.24 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002114s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.225602s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2022-11-23T08:38:27+08:00 ] 117.132.191.234 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002184s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010974s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2022-11-23T08:38:28+08:00 ] 117.132.191.234 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1669163907&v1=0.024712&v2=1.629293&v3=0.025074&v4=0.024712&v5=11.520000&t=14.014929&h=55.256409&rssi=17&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001783s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010514s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1669163907,`v1`=0.024712,`v2`=1.629293,`v3`=0.025074,`v4`=0.024712,`v5`=11.52,`t`=14.014929,`h`=55.256409,`rssi`=17,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1669163908 WHERE `imei` = '868922056976208' [ RunTime:0.000784s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011421s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1669163907 , 0.024712 , 1.629293 , 0.025074 , 0.024712 , 11.52 , 14.014929 , 55.256409 , 17 , '898604650119C1053139' , '460048590503139' , -0 , 1669163908) [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2022-11-23T10:33:45+08:00 ] 39.144.17.117 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002779s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011129s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2022-11-23T10:33:47+08:00 ] 39.144.17.117 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1669170825&v1=0.010385&v2=1.008868&v3=0.006682&v4=-0.043615&v5=11.520000&t=15.537790&h=59.551804&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001829s ] 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` = '868922055677740' LIMIT 1 [ RunTime:0.000769s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1669170825,`v1`=0.010385,`v2`=1.008868,`v3`=0.006682,`v4`=-0.043615,`v5`=11.52,`t`=15.53779,`h`=59.551804,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1669170827 WHERE `imei` = '868922055677740' [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009627s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1669170825 , 0.010385 , 1.008868 , 0.006682 , -0.043615 , 11.52 , 15.53779 , 59.551804 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1669170827) [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2022-11-23T10:33:48+08:00 ] 39.144.17.117 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1669156388&v1=0.007375&v2=0.079691&v3=0.007946&v4=0.014900&v5=11.520000&t=12.856521&h=59.940903&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001576s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012876s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000662s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1669156388,`v1`=0.007375,`v2`=0.079691,`v3`=0.007946,`v4`=0.0149,`v5`=11.52,`t`=12.856521,`h`=59.940903,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1669170828 WHERE `imei` = '868922055677740' [ RunTime:0.000561s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009743s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1669156388 , 0.007375 , 0.079691 , 0.007946 , 0.0149 , 11.52 , 12.856521 , 59.940903 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1669170828) [ RunTime:0.000817s ] --------------------------------------------------------------- [ 2022-11-23T10:43:46+08:00 ] 39.65.57.14 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002009s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010637s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user1' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001239s ] --------------------------------------------------------------- [ 2022-11-23T10:43:47+08:00 ] 39.65.57.14 GET /home/map/index.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.011406s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2022-11-23T10:43:50+08:00 ] 39.65.57.14 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009592s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000655s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2022-11-23T10:43:52+08:00 ] 39.65.57.14 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010296s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000807s ] --------------------------------------------------------------- [ 2022-11-23T10:43:53+08:00 ] 39.65.57.14 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009893s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000443s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000620s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000488s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011308s ] [ 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.000362s ] [ 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.000406s ] --------------------------------------------------------------- [ 2022-11-23T10:43:58+08:00 ] 39.65.57.14 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001835s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010698s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000560s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000570s ] --------------------------------------------------------------- [ 2022-11-23T10:46:49+08:00 ] 39.65.57.14 GET /home/show/read/id/31/imei/868922055644211.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001553s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010923s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000853s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012553s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000989s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644211' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.005302s ] --------------------------------------------------------------- [ 2022-11-23T10:58:39+08:00 ] 39.65.57.14 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002214s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009678s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000518s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000659s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011198s ] [ 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.000441s ] [ 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.000443s ] --------------------------------------------------------------- [ 2022-11-23T10:58:43+08:00 ] 39.65.57.14 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001839s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008225s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000463s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001200s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000555s ] --------------------------------------------------------------- [ 2022-11-23T12:38:27+08:00 ] 39.144.13.249 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002220s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012797s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000686s ] --------------------------------------------------------------- [ 2022-11-23T12:38:28+08:00 ] 39.144.13.249 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1669178307&v1=0.024953&v2=1.398668&v3=0.025254&v4=0.025013&v5=11.520000&t=17.328985&h=54.676575&rssi=17&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001462s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009519s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1669178307,`v1`=0.024953,`v2`=1.398668,`v3`=0.025254,`v4`=0.025013,`v5`=11.52,`t`=17.328985,`h`=54.676575,`rssi`=17,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1669178308 WHERE `imei` = '868922056976208' [ RunTime:0.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010238s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1669178307 , 0.024953 , 1.398668 , 0.025254 , 0.025013 , 11.52 , 17.328985 , 54.676575 , 17 , '898604650119C1053139' , '460048590503139' , -0 , 1669178308) [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2022-11-23T14:03:55+08:00 ] 117.132.191.116 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002140s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010798s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2022-11-23T14:03:55+08:00 ] 218.204.252.175 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001764s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011979s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2022-11-23T14:04:03+08:00 ] 117.132.191.116 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221123&time=140301&v1=-00.608&v2=+00.001&v3=-00.188&v4=-00.006&v5=05.9&t=+13.8&h=62.0&rssi=+225&ccid=4600485905031430000099m9990000000077000000g6770,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011111s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221123',`time`='140301',`v1`=-0.608,`v2`=0.001,`v3`=-0.188,`v4`=-0.006,`v5`=5.9,`t`=13.8,`h`=62,`rssi`=225,`ccid`='4600485905031430000099m9990000000077000000g6770,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1669183443 WHERE `imei` = '868922055644013' [ RunTime:0.000570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010629s ] [ 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' , '221123' , '140301' , -0.608 , 0.001 , -0.188 , -0.006 , 5.9 , 13.8 , 62 , 225 , '4600485905031430000099m9990000000077000000g6770,N,00E000=-00.000' , 0 , 0 , 1669183443 , 1669183443) [ RunTime:0.000623s ] --------------------------------------------------------------- [ 2022-11-23T14:04:04+08:00 ] 218.204.252.175 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221123&time=140301&v1=-01.185&v2=+00.066&v3=-01.000&v4=-00.031&v5=06.2&t=+13.7&h=58.8&rssi=+229&ccid=4600485905031420000099m9990000000188000001g2000,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.004923s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012655s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000915s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221123',`time`='140301',`v1`=-1.185,`v2`=0.066,`v3`=-1,`v4`=-0.031,`v5`=6.2,`t`=13.7,`h`=58.8,`rssi`=229,`ccid`='4600485905031420000099m9990000000188000001g2000,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1669183444 WHERE `imei` = '868922055643643' [ RunTime:0.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012015s ] [ 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' , '221123' , '140301' , -1.185 , 0.066 , -1 , -0.031 , 6.2 , 13.7 , 58.8 , 229 , '4600485905031420000099m9990000000188000001g2000,N,00E000=-00.000' , 0 , 0 , 1669183444 , 1669183444) [ RunTime:0.000852s ] --------------------------------------------------------------- [ 2022-11-23T14:34:13+08:00 ] 223.104.254.218 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002290s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010729s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000635s ] --------------------------------------------------------------- [ 2022-11-23T14:34:14+08:00 ] 223.104.254.218 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1669185253&v1=0.007013&v2=0.115365&v3=0.007254&v4=0.011408&v5=11.520000&t=16.706823&h=60.658070&rssi=14&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001774s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010325s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000600s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1669185253,`v1`=0.007013,`v2`=0.115365,`v3`=0.007254,`v4`=0.011408,`v5`=11.52,`t`=16.706823,`h`=60.65807,`rssi`=14,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1669185254 WHERE `imei` = '868922055677740' [ RunTime:0.000519s ] [ 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' , 1669185253 , 0.007013 , 0.115365 , 0.007254 , 0.011408 , 11.52 , 16.706823 , 60.65807 , 14 , '89860426102071188504' , '460044618415254' , -0 , 1669185254) [ RunTime:0.000608s ] --------------------------------------------------------------- [ 2022-11-23T16:38:26+08:00 ] 39.144.18.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002303s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011005s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2022-11-23T16:38:28+08:00 ] 39.144.18.49 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1669192706&v1=0.024893&v2=3.423184&v3=0.025585&v4=0.024893&v5=11.700000&t=14.937287&h=56.400818&rssi=17&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008643s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1669192706,`v1`=0.024893,`v2`=3.423184,`v3`=0.025585,`v4`=0.024893,`v5`=11.7,`t`=14.937287,`h`=56.400818,`rssi`=17,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1669192708 WHERE `imei` = '868922056976208' [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010467s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1669192706 , 0.024893 , 3.423184 , 0.025585 , 0.024893 , 11.7 , 14.937287 , 56.400818 , 17 , '898604650119C1053139' , '460048590503139' , -0 , 1669192708) [ RunTime:0.000593s ] --------------------------------------------------------------- [ 2022-11-23T18:34:39+08:00 ] 39.144.3.67 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010540s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2022-11-23T18:34:41+08:00 ] 39.144.3.67 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1669199679&v1=0.007194&v2=0.089914&v3=0.007495&v4=0.021823&v5=11.520000&t=14.465282&h=59.887497&rssi=16&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001402s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010573s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000591s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1669199679,`v1`=0.007194,`v2`=0.089914,`v3`=0.007495,`v4`=0.021823,`v5`=11.52,`t`=14.465282,`h`=59.887497,`rssi`=16,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1669199681 WHERE `imei` = '868922055677740' [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010018s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1669199679 , 0.007194 , 0.089914 , 0.007495 , 0.021823 , 11.52 , 14.465282 , 59.887497 , 16 , '89860426102071188504' , '460044618415254' , -0 , 1669199681) [ RunTime:0.000606s ] --------------------------------------------------------------- [ 2022-11-23T19:44:17+08:00 ] 39.144.6.11 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002088s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008855s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000627s ] --------------------------------------------------------------- [ 2022-11-23T19:44:19+08:00 ] 39.144.6.11 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1669203857&v1=0.025856&v2=0.254408&v3=0.016826&v4=-0.001114&v5=6.660000&t=9.789241&h=64.571899&rssi=18&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.015022s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009847s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1669203857,`v1`=0.025856,`v2`=0.254408,`v3`=0.016826,`v4`=-0.001114,`v5`=6.66,`t`=9.789241,`h`=64.571899,`rssi`=18,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1669203859 WHERE `imei` = '868922055644211' [ RunTime:0.000576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009843s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1669203857 , 0.025856 , 0.254408 , 0.016826 , -0.001114 , 6.66 , 9.789241 , 64.571899 , 18 , '89860426102071188505' , '460044618415255' , -0 , 1669203859) [ RunTime:0.000684s ] --------------------------------------------------------------- [ 2022-11-23T20:38:27+08:00 ] 223.104.255.245 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002359s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010838s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2022-11-23T20:38:29+08:00 ] 223.104.255.245 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1669207107&v1=0.024171&v2=4.215822&v3=0.025736&v4=0.024833&v5=11.520000&t=14.122180&h=56.187195&rssi=17&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ 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.011613s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1669207107,`v1`=0.024171,`v2`=4.215822,`v3`=0.025736,`v4`=0.024833,`v5`=11.52,`t`=14.12218,`h`=56.187195,`rssi`=17,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1669207109 WHERE `imei` = '868922056976208' [ RunTime:0.000584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010225s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1669207107 , 0.024171 , 4.215822 , 0.025736 , 0.024833 , 11.52 , 14.12218 , 56.187195 , 17 , '898604650119C1053139' , '460048590503139' , -0 , 1669207109) [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2022-11-23T22:35:06+08:00 ] 117.132.198.178 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003577s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015661s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000961s ] --------------------------------------------------------------- [ 2022-11-23T22:35:08+08:00 ] 117.132.198.178 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1669214106&v1=0.007254&v2=0.052676&v3=0.007615&v4=0.018993&v5=11.160000&t=14.272231&h=59.811203&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010604s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1669214106,`v1`=0.007254,`v2`=0.052676,`v3`=0.007615,`v4`=0.018993,`v5`=11.16,`t`=14.272231,`h`=59.811203,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1669214108 WHERE `imei` = '868922055677740' [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010536s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1669214106 , 0.007254 , 0.052676 , 0.007615 , 0.018993 , 11.16 , 14.272231 , 59.811203 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1669214108) [ RunTime:0.000666s ]