---------------------------------------------------------------
[ 2023-03-01T02:03:55+08:00 ] 39.144.13.106 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.003223s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013188s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000748s ]
---------------------------------------------------------------
[ 2023-03-01T02:03:55+08:00 ] 39.144.13.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002360s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011228s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000715s ]
---------------------------------------------------------------
[ 2023-03-01T02:04:04+08:00 ] 39.144.13.106 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230301&time=020301&v1=-01.273&v2=+00.021&v3=-00.968&v4=-00.025&v5=05.7&t=+00.5&h=62.7&rssi=+227&ccid=4600485905031420000099m9990000000291000001g2870,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001564s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009420s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000687s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230301',`time`='020301',`v1`=-1.273,`v2`=0.021,`v3`=-0.968,`v4`=-0.025,`v5`=5.7,`t`=0.5,`h`=62.7,`rssi`=227,`ccid`='4600485905031420000099m9990000000291000001g2870,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677607444  WHERE  `imei` = '868922055643643' [ RunTime:0.000599s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010585s ]
[ 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' , '230301' , '020301' , -1.273 , 0.021 , -0.968 , -0.025 , 5.7 , 0.5 , 62.7 , 227 , '4600485905031420000099m9990000000291000001g2870,N,00E000=-00.000' , 0 , 0 , 1677607444 , 1677607444) [ RunTime:0.000631s ]
---------------------------------------------------------------
[ 2023-03-01T02:04:04+08:00 ] 39.144.13.40 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230301&time=020301&v1=-00.243&v2=+00.001&v3=-00.214&v4=-00.015&v5=05.7&t=+01.8&h=65.6&rssi=+225&ccid=4600485905031430000099m9990000000045000000g2620,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002376s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009851s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000649s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230301',`time`='020301',`v1`=-0.243,`v2`=0.001,`v3`=-0.214,`v4`=-0.015,`v5`=5.7,`t`=1.8,`h`=65.6,`rssi`=225,`ccid`='4600485905031430000099m9990000000045000000g2620,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677607444  WHERE  `imei` = '868922055644013' [ RunTime:0.000527s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008940s ]
[ 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' , '230301' , '020301' , -0.243 , 0.001 , -0.214 , -0.015 , 5.7 , 1.8 , 65.6 , 225 , '4600485905031430000099m9990000000045000000g2620,N,00E000=-00.000' , 0 , 0 , 1677607444 , 1677607444) [ RunTime:0.000506s ]
---------------------------------------------------------------
[ 2023-03-01T06:09:51+08:00 ] 39.144.14.223 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002054s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013575s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000657s ]
---------------------------------------------------------------
[ 2023-03-01T06:09:59+08:00 ] 39.144.14.223 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230301&time=060901&v1=-01.266&v2=+00.024&v3=-00.992&v4=-00.615&v5=05.7&t=+01.2&h=81.1&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.299&a2=01.282&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001947s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010686s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000779s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230301',`time`='060901',`v1`=-1.266,`v2`=0.024,`v3`=-0.992,`v4`=-0.615,`v5`=5.7,`t`=1.2,`h`=81.1,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.299,`a2`=1.282,`update_time`=1677622199  WHERE  `imei` = '868922055684076' [ RunTime:0.000665s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011915s ]
[ 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' , '230301' , '060901' , -1.266 , 0.024 , -0.992 , -0.615 , 5.7 , 1.2 , 81.1 , 227 , '460044618415249' , -0 , 0.299 , 1.282 , 1677622199 , 1677622199) [ RunTime:0.001339s ]
---------------------------------------------------------------
[ 2023-03-01T11:41:02+08:00 ] 223.80.202.168 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002501s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.017250s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'biandianzhan'  AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.001387s ]
---------------------------------------------------------------
[ 2023-03-01T11:41:03+08:00 ] 223.80.202.168 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003157s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.001311s ]
---------------------------------------------------------------
[ 2023-03-01T12:30:13+08:00 ] 223.80.202.168 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002325s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010995s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'biandianzhan'  AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000827s ]
---------------------------------------------------------------
[ 2023-03-01T12:30:14+08:00 ] 223.80.202.168 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001865s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010905s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000745s ]
---------------------------------------------------------------
[ 2023-03-01T14:03:55+08:00 ] 221.178.127.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012381s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000773s ]
---------------------------------------------------------------
[ 2023-03-01T14:03:55+08:00 ] 218.204.252.6 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009321s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000698s ]
---------------------------------------------------------------
[ 2023-03-01T14:04:04+08:00 ] 221.178.127.23 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230301&time=140301&v1=-00.223&v2=+00.002&v3=+00.019&v4=-00.018&v5=05.9&t=+14.5&h=64.7&rssi=+225&ccid=4600485905031430000099m9990000000038000000g2630,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001790s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010652s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000672s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230301',`time`='140301',`v1`=-0.223,`v2`=0.002,`v3`=0.019,`v4`=-0.018,`v5`=5.9,`t`=14.5,`h`=64.7,`rssi`=225,`ccid`='4600485905031430000099m9990000000038000000g2630,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677650644  WHERE  `imei` = '868922055644013' [ RunTime:0.000715s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011936s ]
[ 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' , '230301' , '140301' , -0.223 , 0.002 , 0.019 , -0.018 , 5.9 , 14.5 , 64.7 , 225 , '4600485905031430000099m9990000000038000000g2630,N,00E000=-00.000' , 0 , 0 , 1677650644 , 1677650644) [ RunTime:0.000751s ]
---------------------------------------------------------------
[ 2023-03-01T14:04:04+08:00 ] 218.204.252.6 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230301&time=140301&v1=-01.273&v2=+00.066&v3=-00.910&v4=-00.024&v5=05.7&t=+12.7&h=61.0&rssi=+229&ccid=4600485905031420000099m9990000000356000001g2850,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001609s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009663s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000635s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230301',`time`='140301',`v1`=-1.273,`v2`=0.066,`v3`=-0.91,`v4`=-0.024,`v5`=5.7,`t`=12.7,`h`=61,`rssi`=229,`ccid`='4600485905031420000099m9990000000356000001g2850,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677650644  WHERE  `imei` = '868922055643643' [ RunTime:0.000523s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009899s ]
[ 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' , '230301' , '140301' , -1.273 , 0.066 , -0.91 , -0.024 , 5.7 , 12.7 , 61 , 229 , '4600485905031420000099m9990000000356000001g2850,N,00E000=-00.000' , 0 , 0 , 1677650644 , 1677650644) [ RunTime:0.000525s ]