---------------------------------------------------------------
[ 2023-04-22T02:03:54+08:00 ] 39.144.4.219 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002828s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014262s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000795s ]
---------------------------------------------------------------
[ 2023-04-22T02:03:55+08:00 ] 39.144.9.61 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001715s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011127s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001261s ]
---------------------------------------------------------------
[ 2023-04-22T02:04:03+08:00 ] 39.144.4.219 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230422&time=020301&v1=-01.340&v2=+00.021&v3=-00.998&v4=-00.028&v5=05.7&t=+11.3&h=61.1&rssi=+228&ccid=4600485905031420000099m9990000000346000001g3500,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001822s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011102s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000634s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230422',`time`='020301',`v1`=-1.34,`v2`=0.021,`v3`=-0.998,`v4`=-0.028,`v5`=5.7,`t`=11.3,`h`=61.1,`rssi`=228,`ccid`='4600485905031420000099m9990000000346000001g3500,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682100243  WHERE  `imei` = '868922055643643' [ RunTime:0.000589s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011324s ]
[ 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' , '230422' , '020301' , -1.34 , 0.021 , -0.998 , -0.028 , 5.7 , 11.3 , 61.1 , 228 , '4600485905031420000099m9990000000346000001g3500,N,00E000=-00.000' , 0 , 0 , 1682100243 , 1682100243) [ RunTime:0.001260s ]
---------------------------------------------------------------
[ 2023-04-22T02:04:03+08:00 ] 39.144.9.61 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230422&time=020301&v1=-00.242&v2=+00.001&v3=+00.020&v4=-00.013&v5=05.9&t=+11.6&h=64.1&rssi=+225&ccid=4600485905031430000099m9990000000037000000g2620,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002156s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009907s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000656s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230422',`time`='020301',`v1`=-0.242,`v2`=0.001,`v3`=0.02,`v4`=-0.013,`v5`=5.9,`t`=11.6,`h`=64.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000037000000g2620,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682100243  WHERE  `imei` = '868922055644013' [ RunTime:0.000538s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011238s ]
[ 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' , '230422' , '020301' , -0.242 , 0.001 , 0.02 , -0.013 , 5.9 , 11.6 , 64.1 , 225 , '4600485905031430000099m9990000000037000000g2620,N,00E000=-00.000' , 0 , 0 , 1682100243 , 1682100243) [ RunTime:0.000539s ]
---------------------------------------------------------------
[ 2023-04-22T10:01:50+08:00 ] 39.144.12.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.007183s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015203s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001326s ]
---------------------------------------------------------------
[ 2023-04-22T10:01:59+08:00 ] 39.144.12.60 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230422&time=100101&v1=-00.110&v2=+00.011&v3=-00.045&v4=+00.347&v5=05.9&t=+14.5&h=79.8&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.129&a2=00.202&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001804s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009782s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230422',`time`='100101',`v1`=-0.11,`v2`=0.011,`v3`=-0.045,`v4`=0.347,`v5`=5.9,`t`=14.5,`h`=79.8,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.129,`a2`=0.202,`update_time`=1682128919  WHERE  `imei` = '868922055684076' [ RunTime:0.000663s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015587s ]
[ 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' , '230422' , '100101' , -0.11 , 0.011 , -0.045 , 0.347 , 5.9 , 14.5 , 79.8 , 229 , '460044618415249' , -0 , 0.129 , 0.202 , 1682128919 , 1682128919) [ RunTime:0.001748s ]
---------------------------------------------------------------
[ 2023-04-22T14:03:55+08:00 ] 117.132.193.202 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002373s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011884s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000680s ]
---------------------------------------------------------------
[ 2023-04-22T14:03:55+08:00 ] 39.144.6.179 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001981s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010876s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000709s ]
---------------------------------------------------------------
[ 2023-04-22T14:04:03+08:00 ] 117.132.193.202 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230422&time=140301&v1=-00.230&v2=+00.001&v3=+00.020&v4=-00.012&v5=06.0&t=+18.3&h=62.4&rssi=+223&ccid=4600485905031430000099m9990000000039000000g2490,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002153s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010441s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000807s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230422',`time`='140301',`v1`=-0.23,`v2`=0.001,`v3`=0.02,`v4`=-0.012,`v5`=6,`t`=18.3,`h`=62.4,`rssi`=223,`ccid`='4600485905031430000099m9990000000039000000g2490,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682143443  WHERE  `imei` = '868922055644013' [ RunTime:0.000631s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011188s ]
[ 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' , '230422' , '140301' , -0.23 , 0.001 , 0.02 , -0.012 , 6 , 18.3 , 62.4 , 223 , '4600485905031430000099m9990000000039000000g2490,N,00E000=-00.000' , 0 , 0 , 1682143443 , 1682143443) [ RunTime:0.000721s ]
---------------------------------------------------------------
[ 2023-04-22T14:04:04+08:00 ] 39.144.6.179 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230422&time=140301&v1=-01.337&v2=+00.030&v3=-00.985&v4=-00.028&v5=05.7&t=+18.1&h=59.3&rssi=+228&ccid=4600485905031420000099m9990000000356000001g3470,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002019s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011390s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000862s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230422',`time`='140301',`v1`=-1.337,`v2`=0.03,`v3`=-0.985,`v4`=-0.028,`v5`=5.7,`t`=18.1,`h`=59.3,`rssi`=228,`ccid`='4600485905031420000099m9990000000356000001g3470,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682143444  WHERE  `imei` = '868922055643643' [ RunTime:0.000593s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012022s ]
[ 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' , '230422' , '140301' , -1.337 , 0.03 , -0.985 , -0.028 , 5.7 , 18.1 , 59.3 , 228 , '4600485905031420000099m9990000000356000001g3470,N,00E000=-00.000' , 0 , 0 , 1682143444 , 1682143444) [ RunTime:0.000549s ]