--------------------------------------------------------------- [ 2022-12-12T02:03:52+08:00 ] 223.104.254.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002439s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009618s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2022-12-12T02:03:56+08:00 ] 39.144.16.26 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001433s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010267s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000607s ] --------------------------------------------------------------- [ 2022-12-12T02:04:00+08:00 ] 223.104.254.86 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221212&time=020301&v1=-00.365&v2=+00.001&v3=-00.160&v4=-00.010&v5=05.7&t=-00.2&h=63.7&rssi=+225&ccid=4600485905031430000099m9990000000033000000g4090,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009790s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221212',`time`='020301',`v1`=-0.365,`v2`=0.001,`v3`=-0.16,`v4`=-0.01,`v5`=5.7,`t`=-0.2,`h`=63.7,`rssi`=225,`ccid`='4600485905031430000099m9990000000033000000g4090,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1670781840 WHERE `imei` = '868922055644013' [ RunTime:0.000580s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010607s ] [ 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' , '221212' , '020301' , -0.365 , 0.001 , -0.16 , -0.01 , 5.7 , -0.2 , 63.7 , 225 , '4600485905031430000099m9990000000033000000g4090,N,00E000=-00.000' , 0 , 0 , 1670781840 , 1670781840) [ RunTime:0.001198s ] --------------------------------------------------------------- [ 2022-12-12T02:04:04+08:00 ] 39.144.16.26 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221212&time=020301&v1=-00.158&v2=+00.005&v3=-00.027&v4=+00.247&v5=06.0&t=-00.9&h=60.5&rssi=+228&ccid=4600485905031420000099m9990000000959000000g9730,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001644s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009100s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000593s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221212',`time`='020301',`v1`=-0.158,`v2`=0.005,`v3`=-0.027,`v4`=0.247,`v5`=6,`t`=-0.9,`h`=60.5,`rssi`=228,`ccid`='4600485905031420000099m9990000000959000000g9730,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1670781844 WHERE `imei` = '868922055643643' [ RunTime:0.000468s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009195s ] [ 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' , '221212' , '020301' , -0.158 , 0.005 , -0.027 , 0.247 , 6 , -0.9 , 60.5 , 228 , '4600485905031420000099m9990000000959000000g9730,N,00E000=-00.000' , 0 , 0 , 1670781844 , 1670781844) [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2022-12-12T02:05:51+08:00 ] 117.132.195.168 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.001470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009852s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000853s ] --------------------------------------------------------------- [ 2022-12-12T02:06:01+08:00 ] 117.132.195.168 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221212&time=020501&v1=-01.273&v2=+00.023&v3=-01.113&v4=-00.695&v5=05.7&t=+00.0&h=80.5&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.190&a2=01.289&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008973s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221212',`time`='020501',`v1`=-1.273,`v2`=0.023,`v3`=-1.113,`v4`=-0.695,`v5`=5.7,`t`=0,`h`=80.5,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.19,`a2`=1.289,`update_time`=1670781961 WHERE `imei` = '868922055684076' [ RunTime:0.000518s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011150s ] [ 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' , '221212' , '020501' , -1.273 , 0.023 , -1.113 , -0.695 , 5.7 , 0 , 80.5 , 228 , '460044618415249' , -0 , 0.19 , 1.289 , 1670781961 , 1670781961) [ RunTime:0.001199s ] --------------------------------------------------------------- [ 2022-12-12T14:03:55+08:00 ] 117.132.191.5 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002447s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009526s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2022-12-12T14:03:55+08:00 ] 39.144.6.22 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021718s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2022-12-12T14:04:03+08:00 ] 117.132.191.5 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221212&time=140301&v1=-00.356&v2=+00.001&v3=+00.019&v4=-00.013&v5=05.7&t=+06.2&h=64.1&rssi=+226&ccid=4600485905031430000099m9990000000037000000g4200,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001636s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010111s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221212',`time`='140301',`v1`=-0.356,`v2`=0.001,`v3`=0.019,`v4`=-0.013,`v5`=5.7,`t`=6.2,`h`=64.1,`rssi`=226,`ccid`='4600485905031430000099m9990000000037000000g4200,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1670825043 WHERE `imei` = '868922055644013' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011433s ] [ 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' , '221212' , '140301' , -0.356 , 0.001 , 0.019 , -0.013 , 5.7 , 6.2 , 64.1 , 226 , '4600485905031430000099m9990000000037000000g4200,N,00E000=-00.000' , 0 , 0 , 1670825043 , 1670825043) [ RunTime:0.000715s ] --------------------------------------------------------------- [ 2022-12-12T14:04:04+08:00 ] 39.144.6.22 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221212&time=140301&v1=-00.138&v2=+00.008&v3=-00.022&v4=+00.255&v5=05.7&t=+05.3&h=60.3&rssi=+231&ccid=4600485905031420000099m9990000000959000000g9730,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001411s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009465s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221212',`time`='140301',`v1`=-0.138,`v2`=0.008,`v3`=-0.022,`v4`=0.255,`v5`=5.7,`t`=5.3,`h`=60.3,`rssi`=231,`ccid`='4600485905031420000099m9990000000959000000g9730,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1670825044 WHERE `imei` = '868922055643643' [ RunTime:0.000502s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010205s ] [ 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' , '221212' , '140301' , -0.138 , 0.008 , -0.022 , 0.255 , 5.7 , 5.3 , 60.3 , 231 , '4600485905031420000099m9990000000959000000g9730,N,00E000=-00.000' , 0 , 0 , 1670825044 , 1670825044) [ RunTime:0.000649s ]