--------------------------------------------------------------- [ 2023-02-28T02:03:55+08:00 ] 111.55.136.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002444s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010366s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2023-02-28T02:03:56+08:00 ] 39.144.6.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ 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.010775s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-02-28T02:04:04+08:00 ] 111.55.136.86 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230228&time=020301&v1=-00.255&v2=+00.001&v3=-00.156&v4=-00.015&v5=05.7&t=+03.2&h=65.1&rssi=+225&ccid=4600485905031430000099m9990000000007000000g2880,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002075s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011495s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230228',`time`='020301',`v1`=-0.255,`v2`=0.001,`v3`=-0.156,`v4`=-0.015,`v5`=5.7,`t`=3.2,`h`=65.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000007000000g2880,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677521044 WHERE `imei` = '868922055644013' [ RunTime:0.000679s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013139s ] [ 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' , '230228' , '020301' , -0.255 , 0.001 , -0.156 , -0.015 , 5.7 , 3.2 , 65.1 , 225 , '4600485905031430000099m9990000000007000000g2880,N,00E000=-00.000' , 0 , 0 , 1677521044 , 1677521044) [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2023-02-28T02:04:04+08:00 ] 39.144.6.87 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230228&time=020301&v1=-01.273&v2=+00.022&v3=-00.989&v4=-00.026&v5=05.6&t=+01.7&h=62.2&rssi=+231&ccid=4600485905031420000099m9990000000264000001g2870,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001556s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000728s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230228',`time`='020301',`v1`=-1.273,`v2`=0.022,`v3`=-0.989,`v4`=-0.026,`v5`=5.6,`t`=1.7,`h`=62.2,`rssi`=231,`ccid`='4600485905031420000099m9990000000264000001g2870,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677521044 WHERE `imei` = '868922055643643' [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010728s ] [ 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' , '230228' , '020301' , -1.273 , 0.022 , -0.989 , -0.026 , 5.6 , 1.7 , 62.2 , 231 , '4600485905031420000099m9990000000264000001g2870,N,00E000=-00.000' , 0 , 0 , 1677521044 , 1677521044) [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2023-02-28T06:09:51+08:00 ] 39.144.6.83 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ 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.010690s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-02-28T06:10:00+08:00 ] 39.144.6.83 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230228&time=060901&v1=-01.267&v2=+00.024&v3=-00.944&v4=-00.616&v5=05.6&t=-01.1&h=80.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.341&a2=01.281&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001513s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009950s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230228',`time`='060901',`v1`=-1.267,`v2`=0.024,`v3`=-0.944,`v4`=-0.616,`v5`=5.6,`t`=-1.1,`h`=80.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.341,`a2`=1.281,`update_time`=1677535800 WHERE `imei` = '868922055684076' [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013846s ] [ 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' , '230228' , '060901' , -1.267 , 0.024 , -0.944 , -0.616 , 5.6 , -1.1 , 80.9 , 228 , '460044618415249' , -0 , 0.341 , 1.281 , 1677535800 , 1677535800) [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2023-02-28T14:03:55+08:00 ] 39.144.11.106 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002302s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010530s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2023-02-28T14:03:55+08:00 ] 39.144.4.253 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001605s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010411s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-02-28T14:04:03+08:00 ] 39.144.11.106 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230228&time=140301&v1=-01.276&v2=+00.066&v3=-00.958&v4=-00.024&v5=05.7&t=+13.5&h=61.2&rssi=+231&ccid=4600485905031420000099m9990000000298000001g2890,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001864s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010764s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230228',`time`='140301',`v1`=-1.276,`v2`=0.066,`v3`=-0.958,`v4`=-0.024,`v5`=5.7,`t`=13.5,`h`=61.2,`rssi`=231,`ccid`='4600485905031420000099m9990000000298000001g2890,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677564243 WHERE `imei` = '868922055643643' [ RunTime:0.000683s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012561s ] [ 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' , '230228' , '140301' , -1.276 , 0.066 , -0.958 , -0.024 , 5.7 , 13.5 , 61.2 , 231 , '4600485905031420000099m9990000000298000001g2890,N,00E000=-00.000' , 0 , 0 , 1677564243 , 1677564243) [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2023-02-28T14:04:04+08:00 ] 39.144.4.253 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230228&time=140301&v1=-00.223&v2=+00.001&v3=+00.019&v4=-00.018&v5=05.7&t=+15.4&h=66.0&rssi=+226&ccid=4600485905031430000099m9990000000038000000g2630,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002040s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011742s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230228',`time`='140301',`v1`=-0.223,`v2`=0.001,`v3`=0.019,`v4`=-0.018,`v5`=5.7,`t`=15.4,`h`=66,`rssi`=226,`ccid`='4600485905031430000099m9990000000038000000g2630,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677564244 WHERE `imei` = '868922055644013' [ RunTime:0.000566s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011664s ] [ 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' , '230228' , '140301' , -0.223 , 0.001 , 0.019 , -0.018 , 5.7 , 15.4 , 66 , 226 , '4600485905031430000099m9990000000038000000g2630,N,00E000=-00.000' , 0 , 0 , 1677564244 , 1677564244) [ RunTime:0.000672s ]