--------------------------------------------------------------- [ 2023-02-27T02:03:55+08:00 ] 39.144.13.162 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003074s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010911s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-02-27T02:03:55+08:00 ] 39.144.14.102 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002013s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011964s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2023-02-27T02:04:03+08:00 ] 39.144.13.162 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230227&time=020301&v1=-00.262&v2=+00.001&v3=-00.131&v4=-00.014&v5=05.7&t=+00.9&h=65.2&rssi=+225&ccid=4600485905031430000099m9990000000010000000g3010,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002256s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011189s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230227',`time`='020301',`v1`=-0.262,`v2`=0.001,`v3`=-0.131,`v4`=-0.014,`v5`=5.7,`t`=0.9,`h`=65.2,`rssi`=225,`ccid`='4600485905031430000099m9990000000010000000g3010,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677434643 WHERE `imei` = '868922055644013' [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009683s ] [ 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' , '230227' , '020301' , -0.262 , 0.001 , -0.131 , -0.014 , 5.7 , 0.9 , 65.2 , 225 , '4600485905031430000099m9990000000010000000g3010,N,00E000=-00.000' , 0 , 0 , 1677434643 , 1677434643) [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2023-02-27T02:04:04+08:00 ] 39.144.14.102 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230227&time=020301&v1=-01.275&v2=+00.016&v3=-00.950&v4=-00.026&v5=05.6&t=-01.1&h=62.1&rssi=+229&ccid=4600485905031420000099m9990000000304000001g2880,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001800s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010615s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230227',`time`='020301',`v1`=-1.275,`v2`=0.016,`v3`=-0.95,`v4`=-0.026,`v5`=5.6,`t`=-1.1,`h`=62.1,`rssi`=229,`ccid`='4600485905031420000099m9990000000304000001g2880,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677434644 WHERE `imei` = '868922055643643' [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011333s ] [ 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' , '230227' , '020301' , -1.275 , 0.016 , -0.95 , -0.026 , 5.6 , -1.1 , 62.1 , 229 , '4600485905031420000099m9990000000304000001g2880,N,00E000=-00.000' , 0 , 0 , 1677434644 , 1677434644) [ RunTime:0.000528s ] --------------------------------------------------------------- [ 2023-02-27T06:10:44+08:00 ] 117.132.196.95 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002564s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014361s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-02-27T06:10:53+08:00 ] 117.132.196.95 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230227&time=061001&v1=-01.265&v2=+00.022&v3=-00.989&v4=-00.615&v5=05.6&t=-03.4&h=80.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.300&a2=01.281&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001537s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010615s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230227',`time`='061001',`v1`=-1.265,`v2`=0.022,`v3`=-0.989,`v4`=-0.615,`v5`=5.6,`t`=-3.4,`h`=80.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.3,`a2`=1.281,`update_time`=1677449453 WHERE `imei` = '868922055684076' [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011403s ] [ 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' , '230227' , '061001' , -1.265 , 0.022 , -0.989 , -0.615 , 5.6 , -3.4 , 80.7 , 228 , '460044618415249' , -0 , 0.3 , 1.281 , 1677449453 , 1677449453) [ RunTime:0.001269s ] --------------------------------------------------------------- [ 2023-02-27T14:03:54+08:00 ] 39.144.6.220 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011338s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2023-02-27T14:03:55+08:00 ] 117.132.192.53 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001546s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010202s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000870s ] --------------------------------------------------------------- [ 2023-02-27T14:04:03+08:00 ] 39.144.6.220 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230227&time=140301&v1=-00.246&v2=+00.001&v3=+00.020&v4=-00.016&v5=06.0&t=+14.6&h=65.0&rssi=+225&ccid=4600485905031430000099m9990000000038000000g2900,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.011346s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230227',`time`='140301',`v1`=-0.246,`v2`=0.001,`v3`=0.02,`v4`=-0.016,`v5`=6,`t`=14.6,`h`=65,`rssi`=225,`ccid`='4600485905031430000099m9990000000038000000g2900,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677477843 WHERE `imei` = '868922055644013' [ RunTime:0.000674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011510s ] [ 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' , '230227' , '140301' , -0.246 , 0.001 , 0.02 , -0.016 , 6 , 14.6 , 65 , 225 , '4600485905031430000099m9990000000038000000g2900,N,00E000=-00.000' , 0 , 0 , 1677477843 , 1677477843) [ RunTime:0.000707s ] --------------------------------------------------------------- [ 2023-02-27T14:04:04+08:00 ] 117.132.192.53 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230227&time=140301&v1=-01.274&v2=+00.067&v3=-00.953&v4=-00.025&v5=05.7&t=+11.8&h=60.7&rssi=+229&ccid=4600485905031420000099m9990000000299000001g2880,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001942s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011802s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001159s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230227',`time`='140301',`v1`=-1.274,`v2`=0.067,`v3`=-0.953,`v4`=-0.025,`v5`=5.7,`t`=11.8,`h`=60.7,`rssi`=229,`ccid`='4600485905031420000099m9990000000299000001g2880,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1677477844 WHERE `imei` = '868922055643643' [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011413s ] [ 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' , '230227' , '140301' , -1.274 , 0.067 , -0.953 , -0.025 , 5.7 , 11.8 , 60.7 , 229 , '4600485905031420000099m9990000000299000001g2880,N,00E000=-00.000' , 0 , 0 , 1677477844 , 1677477844) [ RunTime:0.000563s ]