---------------------------------------------------------------
[ 2023-03-30T02:03:55+08:00 ] 39.144.4.203 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.003765s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012635s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001330s ]
---------------------------------------------------------------
[ 2023-03-30T02:03:55+08:00 ] 223.104.255.178 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002756s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009904s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000752s ]
---------------------------------------------------------------
[ 2023-03-30T02:04:03+08:00 ] 39.144.4.203 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230330&time=020301&v1=-01.295&v2=+00.023&v3=-00.943&v4=-00.023&v5=05.9&t=+09.6&h=62.0&rssi=+229&ccid=4600485905031420000099m9990000000347000001g3060,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.010474s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010140s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000667s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230330',`time`='020301',`v1`=-1.295,`v2`=0.023,`v3`=-0.943,`v4`=-0.023,`v5`=5.9,`t`=9.6,`h`=62,`rssi`=229,`ccid`='4600485905031420000099m9990000000347000001g3060,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680113043 WHERE `imei` = '868922055643643' [ RunTime:0.000675s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012891s ]
[ 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' , '230330' , '020301' , -1.295 , 0.023 , -0.943 , -0.023 , 5.9 , 9.6 , 62 , 229 , '4600485905031420000099m9990000000347000001g3060,N,00E000=-00.000' , 0 , 0 , 1680113043 , 1680113043) [ RunTime:0.001186s ]
---------------------------------------------------------------
[ 2023-03-30T02:04:03+08:00 ] 223.104.255.178 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230330&time=020301&v1=-00.179&v2=+00.001&v3=+00.019&v4=-00.020&v5=05.9&t=+11.2&h=64.8&rssi=+224&ccid=4600485905031430000099m9990000000036000000g2110,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001688s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010572s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000669s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230330',`time`='020301',`v1`=-0.179,`v2`=0.001,`v3`=0.019,`v4`=-0.02,`v5`=5.9,`t`=11.2,`h`=64.8,`rssi`=224,`ccid`='4600485905031430000099m9990000000036000000g2110,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680113043 WHERE `imei` = '868922055644013' [ RunTime:0.000536s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009923s ]
[ 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' , '230330' , '020301' , -0.179 , 0.001 , 0.019 , -0.02 , 5.9 , 11.2 , 64.8 , 224 , '4600485905031430000099m9990000000036000000g2110,N,00E000=-00.000' , 0 , 0 , 1680113043 , 1680113043) [ RunTime:0.000512s ]
---------------------------------------------------------------
[ 2023-03-30T10:14:51+08:00 ] 39.144.18.244 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.011909s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011531s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001162s ]
---------------------------------------------------------------
[ 2023-03-30T10:14:59+08:00 ] 39.144.18.244 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230330&time=101401&v1=-01.276&v2=+00.016&v3=-01.023&v4=-00.384&v5=06.0&t=+23.8&h=79.5&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.274&a2=01.291&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001745s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010265s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000747s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230330',`time`='101401',`v1`=-1.276,`v2`=0.016,`v3`=-1.023,`v4`=-0.384,`v5`=6,`t`=23.8,`h`=79.5,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.274,`a2`=1.291,`update_time`=1680142499 WHERE `imei` = '868922055684076' [ RunTime:0.000701s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012218s ]
[ 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' , '230330' , '101401' , -1.276 , 0.016 , -1.023 , -0.384 , 6 , 23.8 , 79.5 , 228 , '460044618415249' , -0 , 0.274 , 1.291 , 1680142499 , 1680142499) [ RunTime:0.000658s ]
---------------------------------------------------------------
[ 2023-03-30T14:03:54+08:00 ] 39.144.4.134 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002601s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012718s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000769s ]
---------------------------------------------------------------
[ 2023-03-30T14:03:54+08:00 ] 218.204.253.52 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001858s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010883s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000693s ]
---------------------------------------------------------------
[ 2023-03-30T14:04:03+08:00 ] 39.144.4.134 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230330&time=140301&v1=-00.203&v2=+00.001&v3=+00.020&v4=-00.018&v5=06.0&t=+25.5&h=64.3&rssi=+223&ccid=4600485905031430000099m9990000000040000000g2390,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002143s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010304s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000734s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230330',`time`='140301',`v1`=-0.203,`v2`=0.001,`v3`=0.02,`v4`=-0.018,`v5`=6,`t`=25.5,`h`=64.3,`rssi`=223,`ccid`='4600485905031430000099m9990000000040000000g2390,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680156243 WHERE `imei` = '868922055644013' [ RunTime:0.000681s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012580s ]
[ 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' , '230330' , '140301' , -0.203 , 0.001 , 0.02 , -0.018 , 6 , 25.5 , 64.3 , 223 , '4600485905031430000099m9990000000040000000g2390,N,00E000=-00.000' , 0 , 0 , 1680156243 , 1680156243) [ RunTime:0.000636s ]
---------------------------------------------------------------
[ 2023-03-30T14:04:03+08:00 ] 218.204.253.52 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230330&time=140301&v1=-01.296&v2=+00.039&v3=-00.955&v4=-00.023&v5=05.9&t=+22.2&h=59.4&rssi=+229&ccid=4600485905031420000099m9990000000335000001g3060,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002145s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011298s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000708s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230330',`time`='140301',`v1`=-1.296,`v2`=0.039,`v3`=-0.955,`v4`=-0.023,`v5`=5.9,`t`=22.2,`h`=59.4,`rssi`=229,`ccid`='4600485905031420000099m9990000000335000001g3060,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680156243 WHERE `imei` = '868922055643643' [ RunTime:0.000586s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021193s ]
[ 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' , '230330' , '140301' , -1.296 , 0.039 , -0.955 , -0.023 , 5.9 , 22.2 , 59.4 , 229 , '4600485905031420000099m9990000000335000001g3060,N,00E000=-00.000' , 0 , 0 , 1680156243 , 1680156243) [ RunTime:0.000586s ]