--------------------------------------------------------------- [ 2023-06-04T00:06:24+08:00 ] 117.132.195.243 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.003242s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010114s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2023-06-04T00:06:25+08:00 ] 117.132.195.243 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1685808384&v1=0.021281&v2=0.013143&v3=0.018452&v4=-0.006110&v5=12.240000&t=24.622051&h=79.144043&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001689s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010445s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1685808384,`v1`=0.021281,`v2`=0.013143,`v3`=0.018452,`v4`=-0.00611,`v5`=12.24,`t`=24.622051,`h`=79.144043,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1685808385 WHERE `imei` = '868922055680850' [ RunTime:0.000559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010059s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1685808384 , 0.021281 , 0.013143 , 0.018452 , -0.00611 , 12.24 , 24.622051 , 79.144043 , 25 , '898604650119C1078510' , '460048590708510' , -0 , 1685808385) [ RunTime:0.001089s ] --------------------------------------------------------------- [ 2023-06-04T02:03:55+08:00 ] 111.55.139.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002314s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010596s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-06-04T02:03:55+08:00 ] 221.178.124.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001654s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010014s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2023-06-04T02:04:04+08:00 ] 221.178.124.41 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230604&time=020301&v1=-00.539&v2=+00.001&v3=+00.018&v4=-00.003&v5=06.0&t=+22.2&h=63.1&rssi=+224&ccid=4600485905031430000099m9990000000041000000g5590,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002026s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009127s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000709s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230604',`time`='020301',`v1`=-0.539,`v2`=0.001,`v3`=0.018,`v4`=-0.003,`v5`=6,`t`=22.2,`h`=63.1,`rssi`=224,`ccid`='4600485905031430000099m9990000000041000000g5590,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685815444 WHERE `imei` = '868922055644013' [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009968s ] [ 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' , '230604' , '020301' , -0.539 , 0.001 , 0.018 , -0.003 , 6 , 22.2 , 63.1 , 224 , '4600485905031430000099m9990000000041000000g5590,N,00E000=-00.000' , 0 , 0 , 1685815444 , 1685815444) [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2023-06-04T09:32:01+08:00 ] 183.162.198.25 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012150s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001392s ] --------------------------------------------------------------- [ 2023-06-04T09:32:02+08:00 ] 183.162.198.25 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001563s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013396s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001107s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000608s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2023-06-04T09:33:00+08:00 ] 183.162.198.20 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008644s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000547s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000651s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2023-06-04T09:34:52+08:00 ] 183.162.198.5 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001984s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010096s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001310s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000562s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000582s ] --------------------------------------------------------------- [ 2023-06-04T09:36:23+08:00 ] 183.162.198.43 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001481s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010302s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000527s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000570s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000603s ] --------------------------------------------------------------- [ 2023-06-04T09:37:51+08:00 ] 220.205.224.5 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002255s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009385s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000477s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000554s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000729s ] --------------------------------------------------------------- [ 2023-06-04T09:38:42+08:00 ] 220.205.224.5 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.007075s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013020s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000491s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000595s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-06-04T09:38:44+08:00 ] 220.205.224.5 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002029s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011487s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000546s ] --------------------------------------------------------------- [ 2023-06-04T09:43:04+08:00 ] 220.205.224.5 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003367s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011329s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000598s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000734s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001553s ] --------------------------------------------------------------- [ 2023-06-04T09:43:05+08:00 ] 220.205.224.5 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002115s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012443s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000623s ] --------------------------------------------------------------- [ 2023-06-04T09:43:07+08:00 ] 220.205.224.5 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001988s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010862s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000491s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000557s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2023-06-04T09:43:09+08:00 ] 220.205.224.5 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001486s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010630s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000524s ] --------------------------------------------------------------- [ 2023-06-04T09:44:22+08:00 ] 220.205.224.5 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.015054s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000463s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000574s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000551s ] --------------------------------------------------------------- [ 2023-06-04T09:44:25+08:00 ] 220.205.224.5 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001690s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010628s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000589s ] --------------------------------------------------------------- [ 2023-06-04T09:44:32+08:00 ] 220.205.224.5 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001454s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009499s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2023-06-04T09:44:33+08:00 ] 220.205.224.5 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010697s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000464s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000544s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000578s ] --------------------------------------------------------------- [ 2023-06-04T09:44:37+08:00 ] 220.205.224.5 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002037s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009363s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000528s ] --------------------------------------------------------------- [ 2023-06-04T11:24:30+08:00 ] 221.178.125.126 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010827s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-06-04T11:24:31+08:00 ] 221.178.125.126 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1685849069&v1=0.029589&v2=0.015959&v3=0.026549&v4=0.001415&v5=12.420000&t=25.662386&h=78.907532&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001814s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009939s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1685849069,`v1`=0.029589,`v2`=0.015959,`v3`=0.026549,`v4`=0.001415,`v5`=12.42,`t`=25.662386,`h`=78.907532,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1685849071 WHERE `imei` = '868922055678110' [ RunTime:0.000672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012362s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1685849069 , 0.029589 , 0.015959 , 0.026549 , 0.001415 , 12.42 , 25.662386 , 78.907532 , 29 , '898604650119C1078513' , '460048590708513' , -0 , 1685849071) [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2023-06-04T14:03:52+08:00 ] 223.104.255.42 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002348s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011935s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000810s ] --------------------------------------------------------------- [ 2023-06-04T14:03:55+08:00 ] 221.178.126.77 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002438s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009999s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000661s ] --------------------------------------------------------------- [ 2023-06-04T14:04:00+08:00 ] 223.104.255.42 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230604&time=140301&v1=-01.379&v2=+00.015&v3=-00.985&v4=-00.042&v5=06.4&t=+39.2&h=54.6&rssi=+231&ccid=4600485905031420000099m9990000000392000001g3860,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001599s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009364s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230604',`time`='140301',`v1`=-1.379,`v2`=0.015,`v3`=-0.985,`v4`=-0.042,`v5`=6.4,`t`=39.2,`h`=54.6,`rssi`=231,`ccid`='4600485905031420000099m9990000000392000001g3860,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685858640 WHERE `imei` = '868922055643643' [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012427s ] [ 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' , '230604' , '140301' , -1.379 , 0.015 , -0.985 , -0.042 , 6.4 , 39.2 , 54.6 , 231 , '4600485905031420000099m9990000000392000001g3860,N,00E000=-00.000' , 0 , 0 , 1685858640 , 1685858640) [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2023-06-04T14:04:03+08:00 ] 221.178.126.77 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230604&time=140301&v1=-00.512&v2=+00.001&v3=+00.018&v4=-00.001&v5=06.2&t=+37.5&h=58.8&rssi=+224&ccid=4600485905031430000099m9990000000049000000g5370,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002119s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011672s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000783s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230604',`time`='140301',`v1`=-0.512,`v2`=0.001,`v3`=0.018,`v4`=-0.001,`v5`=6.2,`t`=37.5,`h`=58.8,`rssi`=224,`ccid`='4600485905031430000099m9990000000049000000g5370,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685858643 WHERE `imei` = '868922055644013' [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011657s ] [ 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' , '230604' , '140301' , -0.512 , 0.001 , 0.018 , -0.001 , 6.2 , 37.5 , 58.8 , 224 , '4600485905031430000099m9990000000049000000g5370,N,00E000=-00.000' , 0 , 0 , 1685858643 , 1685858643) [ RunTime:0.000489s ] --------------------------------------------------------------- [ 2023-06-04T14:51:22+08:00 ] 223.104.255.206 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.003030s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012702s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.001081s ] --------------------------------------------------------------- [ 2023-06-04T14:51:23+08:00 ] 223.104.255.206 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1685861482&v1=0.016766&v2=0.013977&v3=0.014418&v4=-0.011589&v5=12.420000&t=26.262991&h=77.450317&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001689s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010618s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1685861482,`v1`=0.016766,`v2`=0.013977,`v3`=0.014418,`v4`=-0.011589,`v5`=12.42,`t`=26.262991,`h`=77.450317,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1685861483 WHERE `imei` = '868922055684548' [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012719s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1685861482 , 0.016766 , 0.013977 , 0.014418 , -0.011589 , 12.42 , 26.262991 , 77.450317 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1685861483) [ RunTime:0.001205s ] --------------------------------------------------------------- [ 2023-06-04T17:03:14+08:00 ] 39.144.11.28 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002338s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012609s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2023-06-04T17:03:16+08:00 ] 39.144.11.28 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1685869394&v1=0.018452&v2=0.012308&v3=0.015923&v4=-0.000030&v5=12.240000&t=26.434593&h=79.403442&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184955,35.985349&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001642s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009390s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000891s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1685869394,`v1`=0.018452,`v2`=0.012308,`v3`=0.015923,`v4`=-3.0E-5,`v5`=12.24,`t`=26.434593,`h`=79.403442,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184955,35.985349',`update_time`=1685869396 WHERE `imei` = '868922055647586' [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010653s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055647586' , 1685869394 , 0.018452 , 0.012308 , 0.015923 , -3.0E-5 , 12.24 , 26.434593 , 79.403442 , 27 , '898604650119C1078512' , '460048590708512' , -0 , '120.184955,35.985349' , 1685869396) [ RunTime:0.001235s ] --------------------------------------------------------------- [ 2023-06-04T17:46:23+08:00 ] 39.144.5.13 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011727s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000829s ] --------------------------------------------------------------- [ 2023-06-04T17:46:24+08:00 ] 39.144.5.13 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1685871983&v1=0.027241&v2=0.014499&v3=0.027241&v4=0.015863&v5=12.240000&t=26.059214&h=77.305359&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001769s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009827s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1685871983,`v1`=0.027241,`v2`=0.014499,`v3`=0.027241,`v4`=0.015863,`v5`=12.24,`t`=26.059214,`h`=77.305359,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1685871984 WHERE `imei` = '868922056976208' [ RunTime:0.000682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011081s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1685871983 , 0.027241 , 0.014499 , 0.027241 , 0.015863 , 12.24 , 26.059214 , 77.305359 , 27 , '898604650119C1053139' , '460048590503139' , -0 , 1685871984) [ RunTime:0.001647s ] --------------------------------------------------------------- [ 2023-06-04T17:51:21+08:00 ] 39.144.12.125 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002119s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010282s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2023-06-04T17:51:23+08:00 ] 39.144.12.125 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1685872281&v1=0.020860&v2=0.013873&v3=0.017157&v4=-0.006953&v5=12.420000&t=26.155739&h=79.357666&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001551s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008785s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1685872281,`v1`=0.02086,`v2`=0.013873,`v3`=0.017157,`v4`=-0.006953,`v5`=12.42,`t`=26.155739,`h`=79.357666,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1685872283 WHERE `imei` = '868922055684209' [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009699s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1685872281 , 0.02086 , 0.013873 , 0.017157 , -0.006953 , 12.42 , 26.155739 , 79.357666 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1685872283) [ RunTime:0.001115s ] --------------------------------------------------------------- [ 2023-06-04T18:01:50+08:00 ] 111.55.141.121 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.005446s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009817s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000753s ] --------------------------------------------------------------- [ 2023-06-04T18:01:58+08:00 ] 111.55.141.121 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230604&time=180101&v1=-01.233&v2=+00.022&v3=-01.123&v4=-00.284&v5=06.0&t=+27.4&h=79.3&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.130&a2=01.269&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002033s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011230s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230604',`time`='180101',`v1`=-1.233,`v2`=0.022,`v3`=-1.123,`v4`=-0.284,`v5`=6,`t`=27.4,`h`=79.3,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.13,`a2`=1.269,`update_time`=1685872918 WHERE `imei` = '868922055684076' [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011151s ] [ 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' , '230604' , '180101' , -1.233 , 0.022 , -1.123 , -0.284 , 6 , 27.4 , 79.3 , 228 , '460044618415249' , -0 , 0.13 , 1.269 , 1685872918 , 1685872918) [ RunTime:0.000514s ] --------------------------------------------------------------- [ 2023-06-04T18:16:20+08:00 ] 111.55.139.99 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012421s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2023-06-04T18:16:21+08:00 ] 111.55.139.99 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1685873780&v1=0.018813&v2=0.014395&v3=0.016284&v4=-0.004726&v5=12.420000&t=25.973413&h=82.661194&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009447s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.001067s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1685873780,`v1`=0.018813,`v2`=0.014395,`v3`=0.016284,`v4`=-0.004726,`v5`=12.42,`t`=25.973413,`h`=82.661194,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1685873781 WHERE `imei` = '868922055683920' [ RunTime:0.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010865s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1685873780 , 0.018813 , 0.014395 , 0.016284 , -0.004726 , 12.42 , 25.973413 , 82.661194 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1685873781) [ RunTime:0.001209s ] --------------------------------------------------------------- [ 2023-06-04T21:01:17+08:00 ] 39.144.14.83 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002705s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012653s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000796s ] --------------------------------------------------------------- [ 2023-06-04T21:01:19+08:00 ] 39.144.14.83 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1685883677&v1=0.031816&v2=0.013977&v3=0.028957&v4=0.007977&v5=12.420000&t=25.716011&h=81.265015&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184319,35.986338&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001649s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011245s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1685883677,`v1`=0.031816,`v2`=0.013977,`v3`=0.028957,`v4`=0.007977,`v5`=12.42,`t`=25.716011,`h`=81.265015,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184319,35.986338',`update_time`=1685883679 WHERE `imei` = '868922055683912' [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010826s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1685883677 , 0.031816 , 0.013977 , 0.028957 , 0.007977 , 12.42 , 25.716011 , 81.265015 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.184319,35.986338' , 1685883679) [ RunTime:0.001398s ] --------------------------------------------------------------- [ 2023-06-04T21:08:22+08:00 ] 39.144.18.221 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002690s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009839s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2023-06-04T21:08:24+08:00 ] 39.144.18.221 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1685884102&v1=0.018391&v2=0.015333&v3=0.015411&v4=-0.017247&v5=12.420000&t=25.780361&h=82.088989&rssi=28&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185410,35.986058&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001848s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010347s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1685884102,`v1`=0.018391,`v2`=0.015333,`v3`=0.015411,`v4`=-0.017247,`v5`=12.42,`t`=25.780361,`h`=82.088989,`rssi`=28,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185410,35.986058',`update_time`=1685884104 WHERE `imei` = '868922055683771' [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009623s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1685884102 , 0.018391 , 0.015333 , 0.015411 , -0.017247 , 12.42 , 25.780361 , 82.088989 , 28 , '898604650119C1053136' , '460048590503136' , -0 , '120.185410,35.986058' , 1685884104) [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2023-06-04T23:46:23+08:00 ] 218.204.253.226 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002275s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011318s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-06-04T23:46:25+08:00 ] 218.204.253.226 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1685893583&v1=0.007856&v2=0.013247&v3=0.005147&v4=-0.015803&v5=12.420000&t=25.544409&h=80.349487&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002126s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011033s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1685893583,`v1`=0.007856,`v2`=0.013247,`v3`=0.005147,`v4`=-0.015803,`v5`=12.42,`t`=25.544409,`h`=80.349487,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1685893585 WHERE `imei` = '868922055644021' [ RunTime:0.000622s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010062s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1685893583 , 0.007856 , 0.013247 , 0.005147 , -0.015803 , 12.42 , 25.544409 , 80.349487 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1685893585) [ RunTime:0.000696s ]