--------------------------------------------------------------- [ 2022-12-15T02:03:55+08:00 ] 39.144.15.186 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008778s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2022-12-15T02:03:56+08:00 ] 39.144.15.29 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001455s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000612s ] --------------------------------------------------------------- [ 2022-12-15T02:04:04+08:00 ] 39.144.15.186 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221215&time=020301&v1=-00.128&v2=+00.004&v3=-00.020&v4=+00.263&v5=06.0&t=-02.5&h=60.2&rssi=+230&ccid=4600485905031420000099m9990000000953000000g9670,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001443s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010240s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221215',`time`='020301',`v1`=-0.128,`v2`=0.004,`v3`=-0.02,`v4`=0.263,`v5`=6,`t`=-2.5,`h`=60.2,`rssi`=230,`ccid`='4600485905031420000099m9990000000953000000g9670,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1671041044 WHERE `imei` = '868922055643643' [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010262s ] [ 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' , '221215' , '020301' , -0.128 , 0.004 , -0.02 , 0.263 , 6 , -2.5 , 60.2 , 230 , '4600485905031420000099m9990000000953000000g9670,N,00E000=-00.000' , 0 , 0 , 1671041044 , 1671041044) [ RunTime:0.013292s ] --------------------------------------------------------------- [ 2022-12-15T02:04:04+08:00 ] 39.144.15.29 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221215&time=020301&v1=-00.338&v2=+00.001&v3=+00.016&v4=-00.013&v5=05.6&t=-00.9&h=63.6&rssi=+225&ccid=4600485905031430000099m9990000000036000000g3990,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009431s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221215',`time`='020301',`v1`=-0.338,`v2`=0.001,`v3`=0.016,`v4`=-0.013,`v5`=5.6,`t`=-0.9,`h`=63.6,`rssi`=225,`ccid`='4600485905031430000099m9990000000036000000g3990,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1671041044 WHERE `imei` = '868922055644013' [ RunTime:0.000496s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010189s ] [ 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' , '221215' , '020301' , -0.338 , 0.001 , 0.016 , -0.013 , 5.6 , -0.9 , 63.6 , 225 , '4600485905031430000099m9990000000036000000g3990,N,00E000=-00.000' , 0 , 0 , 1671041044 , 1671041044) [ RunTime:0.000472s ] --------------------------------------------------------------- [ 2022-12-15T02:05:52+08:00 ] 39.144.7.177 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.001766s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008897s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000635s ] --------------------------------------------------------------- [ 2022-12-15T02:06:00+08:00 ] 39.144.7.177 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221215&time=020501&v1=-01.275&v2=+00.020&v3=-01.113&v4=-00.693&v5=05.7&t=-01.8&h=80.3&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.191&a2=01.290&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001687s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.024515s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221215',`time`='020501',`v1`=-1.275,`v2`=0.02,`v3`=-1.113,`v4`=-0.693,`v5`=5.7,`t`=-1.8,`h`=80.3,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.191,`a2`=1.29,`update_time`=1671041160 WHERE `imei` = '868922055684076' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011570s ] [ 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' , '221215' , '020501' , -1.275 , 0.02 , -1.113 , -0.693 , 5.7 , -1.8 , 80.3 , 227 , '460044618415249' , -0 , 0.191 , 1.29 , 1671041160 , 1671041160) [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2022-12-15T14:03:55+08:00 ] 117.132.196.2 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002291s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012142s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2022-12-15T14:03:56+08:00 ] 39.144.6.143 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ 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.009268s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2022-12-15T14:04:03+08:00 ] 117.132.196.2 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221215&time=140301&v1=-00.326&v2=+00.001&v3=+00.019&v4=-00.013&v5=05.7&t=+05.7&h=63.9&rssi=+225&ccid=4600485905031430000099m9990000000037000000g3850,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001593s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010590s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000610s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221215',`time`='140301',`v1`=-0.326,`v2`=0.001,`v3`=0.019,`v4`=-0.013,`v5`=5.7,`t`=5.7,`h`=63.9,`rssi`=225,`ccid`='4600485905031430000099m9990000000037000000g3850,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1671084243 WHERE `imei` = '868922055644013' [ RunTime:0.000562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011185s ] [ 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' , '221215' , '140301' , -0.326 , 0.001 , 0.019 , -0.013 , 5.7 , 5.7 , 63.9 , 225 , '4600485905031430000099m9990000000037000000g3850,N,00E000=-00.000' , 0 , 0 , 1671084243 , 1671084243) [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2022-12-15T14:04:04+08:00 ] 39.144.6.143 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221215&time=140301&v1=-00.127&v2=+00.007&v3=-00.019&v4=+00.261&v5=05.7&t=+04.9&h=59.9&rssi=+231&ccid=4600485905031420000099m9990000000955000000g9680,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001476s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010608s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000619s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221215',`time`='140301',`v1`=-0.127,`v2`=0.007,`v3`=-0.019,`v4`=0.261,`v5`=5.7,`t`=4.9,`h`=59.9,`rssi`=231,`ccid`='4600485905031420000099m9990000000955000000g9680,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1671084244 WHERE `imei` = '868922055643643' [ RunTime:0.000479s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009294s ] [ 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' , '221215' , '140301' , -0.127 , 0.007 , -0.019 , 0.261 , 5.7 , 4.9 , 59.9 , 231 , '4600485905031420000099m9990000000955000000g9680,N,00E000=-00.000' , 0 , 0 , 1671084244 , 1671084244) [ RunTime:0.000522s ]