---------------------------------------------------------------
[ 2024-03-19T01:57:51+08:00 ] 39.144.10.171 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.004562s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013667s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001382s ]
---------------------------------------------------------------
[ 2024-03-19T01:58:00+08:00 ] 39.144.10.171 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240319&time=015701&v1=-00.070&v2=+00.001&v3=+00.017&v4=-00.008&v5=05.7&t=+08.8&h=71.4&rssi=+222&ccid=4600485905031430000099m9990000000038000000g0680,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.003664s ] 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` = '868922055644013' LIMIT 1 [ RunTime:0.000677s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='240319',`time`='015701',`v1`=-0.07,`v2`=0.001,`v3`=0.017,`v4`=-0.008,`v5`=5.7,`t`=8.8,`h`=71.4,`rssi`=222,`ccid`='4600485905031430000099m9990000000038000000g0680,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1710784680 WHERE `imei` = '868922055644013' [ RunTime:0.000783s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019104s ]
[ 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' , '240319' , '015701' , -0.07 , 0.001 , 0.017 , -0.008 , 5.7 , 8.8 , 71.4 , 222 , '4600485905031430000099m9990000000038000000g0680,N,00E000=-00.000' , 0 , 0 , 1710784680 , 1710784680) [ RunTime:0.003859s ]
---------------------------------------------------------------
[ 2024-03-19T14:17:14+08:00 ] 112.224.164.2 GET /admin
[ sql ] [ DB ] CONNECT:[ UseTime:0.002181s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012735s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000387s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000901s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001154s ]
---------------------------------------------------------------
[ 2024-03-19T14:17:18+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001951s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012686s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000408s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000886s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001645s ]
---------------------------------------------------------------
[ 2024-03-19T14:17:25+08:00 ] 112.224.164.2 GET /admin/show/index.html?keyword=868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001877s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011778s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055684209%' LIMIT 1 [ RunTime:0.000498s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055684209%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000666s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001084s ]
---------------------------------------------------------------
[ 2024-03-19T14:17:28+08:00 ] 112.224.164.2 GET /admin/show/edit/id/47.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003310s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011553s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000729s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.016146s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001317s ]
---------------------------------------------------------------
[ 2024-03-19T14:17:37+08:00 ] 112.224.164.2 POST /admin/show/update.html
[ 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.012310s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试2',`interval`=10,`gps`='120.184811,35.985164',`username`='admin',`introduce`=' ',`update_time`=1710829057 WHERE `id` = 47 [ RunTime:0.001039s ]
---------------------------------------------------------------
[ 2024-03-19T14:17:38+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002755s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012648s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000371s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000847s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001127s ]
---------------------------------------------------------------
[ 2024-03-19T14:29:25+08:00 ] 117.132.198.129 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002366s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011026s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000775s ]
---------------------------------------------------------------
[ 2024-03-19T14:29:27+08:00 ] 117.132.198.129 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710829765&v1=0.041870&v2=0.028978&v3=0.014719&v4=0.017127&v5=6.480000&t=19.645605&h=78.022522&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428403,36.323243&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012374s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000922s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710829765,`v1`=0.04187,`v2`=0.028978,`v3`=0.014719,`v4`=0.017127,`v5`=6.48,`t`=19.645605,`h`=78.022522,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428403,36.323243',`update_time`=1710829767 WHERE `imei` = '868922055684209' [ RunTime:0.000916s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014229s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710829765 , 0.04187 , 0.028978 , 0.014719 , 0.017127 , 6.48 , 19.645605 , 78.022522 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428403,36.323243' , 1710829767) [ RunTime:0.001669s ]
---------------------------------------------------------------
[ 2024-03-19T14:31:05+08:00 ] 112.224.164.2 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002284s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011081s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000706s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011112s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000622s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.058492s ]
---------------------------------------------------------------
[ 2024-03-19T14:39:55+08:00 ] 39.144.112.14 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002405s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011655s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000810s ]
---------------------------------------------------------------
[ 2024-03-19T14:39:56+08:00 ] 39.144.112.14 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710830395&v1=0.015381&v2=0.029053&v3=0.015923&v4=0.015441&v5=6.480000&t=17.404060&h=78.915161&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428445,36.323179&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001944s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011904s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000770s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710830395,`v1`=0.015381,`v2`=0.029053,`v3`=0.015923,`v4`=0.015441,`v5`=6.48,`t`=17.40406,`h`=78.915161,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428445,36.323179',`update_time`=1710830396 WHERE `imei` = '868922055684209' [ RunTime:0.000860s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012161s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710830395 , 0.015381 , 0.029053 , 0.015923 , 0.015441 , 6.48 , 17.40406 , 78.915161 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428445,36.323179' , 1710830396) [ RunTime:0.000596s ]
---------------------------------------------------------------
[ 2024-03-19T14:40:35+08:00 ] 112.224.164.2 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001810s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013189s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.001041s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011150s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000595s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002699s ]
---------------------------------------------------------------
[ 2024-03-19T14:44:51+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001977s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016116s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000458s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000987s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001761s ]
---------------------------------------------------------------
[ 2024-03-19T14:45:02+08:00 ] 112.224.164.2 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001759s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011723s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000774s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014156s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000722s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003092s ]
---------------------------------------------------------------
[ 2024-03-19T14:45:19+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001754s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011679s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000427s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000916s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001195s ]
---------------------------------------------------------------
[ 2024-03-19T14:45:21+08:00 ] 112.224.164.2 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.008453s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013364s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001505s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.015739s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.002132s ]
---------------------------------------------------------------
[ 2024-03-19T14:45:34+08:00 ] 112.224.164.2 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002685s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010106s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001248s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012385s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001381s ]
---------------------------------------------------------------
[ 2024-03-19T14:49:29+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002413s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011916s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000426s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000936s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001311s ]
---------------------------------------------------------------
[ 2024-03-19T14:49:34+08:00 ] 112.224.164.2 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001812s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012763s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000715s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010593s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000648s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003283s ]
---------------------------------------------------------------
[ 2024-03-19T14:49:42+08:00 ] 112.224.164.2 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001934s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010794s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000807s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012060s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000565s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002550s ]
---------------------------------------------------------------
[ 2024-03-19T14:50:17+08:00 ] 39.144.112.9 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001629s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010872s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000695s ]
---------------------------------------------------------------
[ 2024-03-19T14:50:19+08:00 ] 39.144.112.9 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710831017&v1=-1.202960&v2=0.621742&v3=-0.012130&v4=0.013154&v5=6.480000&t=16.889256&h=78.693909&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428706,36.322945&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001881s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011150s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000694s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710831017,`v1`=-1.20296,`v2`=0.621742,`v3`=-0.01213,`v4`=0.013154,`v5`=6.48,`t`=16.889256,`h`=78.693909,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428706,36.322945',`update_time`=1710831019 WHERE `imei` = '868922055684209' [ RunTime:0.000699s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011891s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710831017 , -1.20296 , 0.621742 , -0.01213 , 0.013154 , 6.48 , 16.889256 , 78.693909 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428706,36.322945' , 1710831019) [ RunTime:0.000679s ]
---------------------------------------------------------------
[ 2024-03-19T14:51:49+08:00 ] 112.224.164.2 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002872s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012892s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000834s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014270s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000677s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003411s ]
---------------------------------------------------------------
[ 2024-03-19T15:01:34+08:00 ] 39.144.112.1 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.003051s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013295s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000757s ]
---------------------------------------------------------------
[ 2024-03-19T15:01:35+08:00 ] 39.144.112.1 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710831694&v1=1.196579&v2=0.676613&v3=0.015953&v4=0.018030&v5=6.480000&t=16.739103&h=78.503174&rssi=29&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.427931,36.322871&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001988s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012247s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000743s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710831694,`v1`=1.196579,`v2`=0.676613,`v3`=0.015953,`v4`=0.01803,`v5`=6.48,`t`=16.739103,`h`=78.503174,`rssi`=29,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.427931,36.322871',`update_time`=1710831695 WHERE `imei` = '868922055684209' [ RunTime:0.000673s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012027s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710831694 , 1.196579 , 0.676613 , 0.015953 , 0.01803 , 6.48 , 16.739103 , 78.503174 , 29 , '898604650119C1078511' , '460048590708511' , -0 , '120.427931,36.322871' , 1710831695) [ RunTime:0.000550s ]
---------------------------------------------------------------
[ 2024-03-19T15:06:59+08:00 ] 112.224.164.2 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002352s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010483s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000785s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011774s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000693s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002633s ]
---------------------------------------------------------------
[ 2024-03-19T15:07:17+08:00 ] 112.224.164.2 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012816s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000726s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012334s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000753s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003150s ]
---------------------------------------------------------------
[ 2024-03-19T15:12:55+08:00 ] 39.144.112.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002364s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011520s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000708s ]
---------------------------------------------------------------
[ 2024-03-19T15:12:56+08:00 ] 39.144.112.8 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710832375&v1=-0.634064&v2=0.649848&v3=0.001144&v4=0.015321&v5=6.480000&t=16.696203&h=78.373474&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428404,36.323159&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002526s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011506s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000706s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710832375,`v1`=-0.634064,`v2`=0.649848,`v3`=0.001144,`v4`=0.015321,`v5`=6.48,`t`=16.696203,`h`=78.373474,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428404,36.323159',`update_time`=1710832376 WHERE `imei` = '868922055684209' [ RunTime:0.000762s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010404s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710832375 , -0.634064 , 0.649848 , 0.001144 , 0.015321 , 6.48 , 16.696203 , 78.373474 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428404,36.323159' , 1710832376) [ RunTime:0.000700s ]
---------------------------------------------------------------
[ 2024-03-19T15:20:19+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014161s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000526s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001312s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001615s ]
---------------------------------------------------------------
[ 2024-03-19T15:20:23+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001906s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011824s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000358s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000948s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001102s ]
---------------------------------------------------------------
[ 2024-03-19T15:20:38+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002253s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011157s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000404s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001011s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001489s ]
---------------------------------------------------------------
[ 2024-03-19T15:20:40+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002065s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010613s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000424s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000954s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001150s ]
---------------------------------------------------------------
[ 2024-03-19T15:20:44+08:00 ] 112.224.164.2 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001703s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012330s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000737s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011098s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000606s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002738s ]
---------------------------------------------------------------
[ 2024-03-19T15:22:59+08:00 ] 111.55.139.156 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002831s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012174s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000780s ]
---------------------------------------------------------------
[ 2024-03-19T15:23:00+08:00 ] 111.55.139.156 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710832979&v1=-1.688118&v2=0.631331&v3=-0.912823&v4=-0.921342&v5=6.480000&t=16.749828&h=78.281921&rssi=28&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.427361,36.322675&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010348s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000718s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710832979,`v1`=-1.688118,`v2`=0.631331,`v3`=-0.912823,`v4`=-0.921342,`v5`=6.48,`t`=16.749828,`h`=78.281921,`rssi`=28,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.427361,36.322675',`update_time`=1710832980 WHERE `imei` = '868922055684209' [ RunTime:0.000654s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009654s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710832979 , -1.688118 , 0.631331 , -0.912823 , -0.921342 , 6.48 , 16.749828 , 78.281921 , 28 , '898604650119C1078511' , '460048590708511' , -0 , '120.427361,36.322675' , 1710832980) [ RunTime:0.000592s ]
---------------------------------------------------------------
[ 2024-03-19T15:34:20+08:00 ] 39.144.4.252 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012705s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001128s ]
---------------------------------------------------------------
[ 2024-03-19T15:34:22+08:00 ] 39.144.4.252 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710833660&v1=-1.726044&v2=0.577035&v3=-0.903612&v4=-0.783181&v5=6.480000&t=16.631853&h=78.297180&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428408,36.323189&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001711s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010356s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000716s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710833660,`v1`=-1.726044,`v2`=0.577035,`v3`=-0.903612,`v4`=-0.783181,`v5`=6.48,`t`=16.631853,`h`=78.29718,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428408,36.323189',`update_time`=1710833662 WHERE `imei` = '868922055684209' [ RunTime:0.000608s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012028s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710833660 , -1.726044 , 0.577035 , -0.903612 , -0.783181 , 6.48 , 16.631853 , 78.29718 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428408,36.323189' , 1710833662) [ RunTime:0.001250s ]
---------------------------------------------------------------
[ 2024-03-19T15:45:32+08:00 ] 39.144.112.9 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002911s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012601s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001589s ]
---------------------------------------------------------------
[ 2024-03-19T15:45:33+08:00 ] 39.144.112.9 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710834332&v1=-0.203749&v2=0.587496&v3=-0.663683&v4=-0.766505&v5=6.660000&t=16.739103&h=78.175110&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.425569,36.323687&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001760s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011441s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000729s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710834332,`v1`=-0.203749,`v2`=0.587496,`v3`=-0.663683,`v4`=-0.766505,`v5`=6.66,`t`=16.739103,`h`=78.17511,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.425569,36.323687',`update_time`=1710834333 WHERE `imei` = '868922055684209' [ RunTime:0.000676s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010193s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710834332 , -0.203749 , 0.587496 , -0.663683 , -0.766505 , 6.66 , 16.739103 , 78.17511 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.425569,36.323687' , 1710834333) [ RunTime:0.000651s ]
---------------------------------------------------------------
[ 2024-03-19T15:57:11+08:00 ] 117.132.198.133 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002424s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011463s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000705s ]
---------------------------------------------------------------
[ 2024-03-19T15:57:12+08:00 ] 117.132.198.133 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710835031&v1=-2.276700&v2=0.609419&v3=-0.936723&v4=-0.759943&v5=6.480000&t=16.760553&h=78.152222&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001888s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011546s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000710s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710835031,`v1`=-2.2767,`v2`=0.609419,`v3`=-0.936723,`v4`=-0.759943,`v5`=6.48,`t`=16.760553,`h`=78.152222,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1710835032 WHERE `imei` = '868922055684209' [ RunTime:0.000613s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011584s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1710835031 , -2.2767 , 0.609419 , -0.936723 , -0.759943 , 6.48 , 16.760553 , 78.152222 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1710835032) [ RunTime:0.000612s ]
---------------------------------------------------------------
[ 2024-03-19T16:02:00+08:00 ] 39.144.112.7 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.022104s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013484s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000796s ]
---------------------------------------------------------------
[ 2024-03-19T16:02:01+08:00 ] 39.144.112.7 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710835320&v1=0.005268&v2=0.004491&v3=0.004154&v4=0.005448&v5=6.480000&t=19.999535&h=75.161499&rssi=31&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&gps=120.428304,36.326083&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002827s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011064s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000747s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710835320,`v1`=0.005268,`v2`=0.004491,`v3`=0.004154,`v4`=0.005448,`v5`=6.48,`t`=19.999535,`h`=75.161499,`rssi`=31,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`gps`='120.428304,36.326083',`update_time`=1710835321 WHERE `imei` = '868922055644021' [ RunTime:0.000582s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012546s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055644021' , 1710835320 , 0.005268 , 0.004491 , 0.004154 , 0.005448 , 6.48 , 19.999535 , 75.161499 , 31 , '898604650119C1053141' , '460048590503141' , -0 , '120.428304,36.326083' , 1710835321) [ RunTime:0.001340s ]
---------------------------------------------------------------
[ 2024-03-19T16:06:32+08:00 ] 112.224.164.2 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002165s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011515s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000704s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010765s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000599s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002789s ]
---------------------------------------------------------------
[ 2024-03-19T16:08:10+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002505s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010404s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000424s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000969s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001183s ]
---------------------------------------------------------------
[ 2024-03-19T16:08:15+08:00 ] 112.224.164.2 GET /admin/show/index.html?keyword=868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001738s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011275s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.000479s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000700s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001241s ]
---------------------------------------------------------------
[ 2024-03-19T16:08:21+08:00 ] 112.224.164.2 GET /admin/show/edit/id/41.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001937s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011915s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000691s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011015s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000547s ]
---------------------------------------------------------------
[ 2024-03-19T16:08:27+08:00 ] 39.144.112.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001830s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010873s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000725s ]
---------------------------------------------------------------
[ 2024-03-19T16:08:28+08:00 ] 112.224.164.2 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010754s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=10,`gps`='120.428304,36.326083',`username`='admin',`introduce`=' ',`update_time`=1710835708 WHERE `id` = 41 [ RunTime:0.001042s ]
---------------------------------------------------------------
[ 2024-03-19T16:08:29+08:00 ] 39.144.112.16 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710835707&v1=-1.500954&v2=0.566712&v3=-0.968388&v4=-0.740619&v5=6.480000&t=16.899981&h=78.083557&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428580,36.323228&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002152s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012001s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000828s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710835707,`v1`=-1.500954,`v2`=0.566712,`v3`=-0.968388,`v4`=-0.740619,`v5`=6.48,`t`=16.899981,`h`=78.083557,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428580,36.323228',`update_time`=1710835709 WHERE `imei` = '868922055684209' [ RunTime:0.000661s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011506s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710835707 , -1.500954 , 0.566712 , -0.968388 , -0.740619 , 6.48 , 16.899981 , 78.083557 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428580,36.323228' , 1710835709) [ RunTime:0.000589s ]
---------------------------------------------------------------
[ 2024-03-19T16:08:29+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002264s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012220s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000363s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000910s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001185s ]
---------------------------------------------------------------
[ 2024-03-19T16:11:38+08:00 ] 112.224.164.2 GET /admin/show/index.html?keyword=868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009862s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.000521s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000872s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001231s ]
---------------------------------------------------------------
[ 2024-03-19T16:11:44+08:00 ] 112.224.164.2 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001995s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010856s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000709s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013892s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000761s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.005162s ]
---------------------------------------------------------------
[ 2024-03-19T16:11:53+08:00 ] 39.144.112.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001791s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011191s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000749s ]
---------------------------------------------------------------
[ 2024-03-19T16:11:55+08:00 ] 39.144.112.16 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710835913&v1=-1.126867&v2=0.064832&v3=-0.849703&v4=-0.576452&v5=6.480000&t=19.077175&h=75.825256&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002064s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012692s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000776s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710835913,`v1`=-1.126867,`v2`=0.064832,`v3`=-0.849703,`v4`=-0.576452,`v5`=6.48,`t`=19.077175,`h`=75.825256,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710835915 WHERE `imei` = '868922055644021' [ RunTime:0.000756s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012601s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710835913 , -1.126867 , 0.064832 , -0.849703 , -0.576452 , 6.48 , 19.077175 , 75.825256 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1710835915) [ RunTime:0.000750s ]
---------------------------------------------------------------
[ 2024-03-19T16:12:55+08:00 ] 112.224.164.2 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012310s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000690s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012722s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000675s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003037s ]
---------------------------------------------------------------
[ 2024-03-19T16:16:45+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002868s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012160s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000382s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000855s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001085s ]
---------------------------------------------------------------
[ 2024-03-19T16:17:35+08:00 ] 112.224.164.2 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002315s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013045s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000366s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001153s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001227s ]
---------------------------------------------------------------
[ 2024-03-19T16:17:46+08:00 ] 112.224.164.2 GET /admin/show/index.html?keyword=868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001698s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011751s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.000526s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000803s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001226s ]
---------------------------------------------------------------
[ 2024-03-19T16:17:54+08:00 ] 112.224.164.2 GET /admin/show/index.html?keyword=868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002029s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012941s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.000545s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000717s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001212s ]
---------------------------------------------------------------
[ 2024-03-19T16:20:11+08:00 ] 39.144.112.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002659s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011235s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000816s ]
---------------------------------------------------------------
[ 2024-03-19T16:20:12+08:00 ] 39.144.112.23 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710836411&v1=-0.764398&v2=0.581600&v3=-0.867612&v4=-0.714131&v5=6.660000&t=16.921431&h=78.083557&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002182s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011343s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000753s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710836411,`v1`=-0.764398,`v2`=0.5816,`v3`=-0.867612,`v4`=-0.714131,`v5`=6.66,`t`=16.921431,`h`=78.083557,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1710836412 WHERE `imei` = '868922055684209' [ RunTime:0.000608s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009803s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1710836411 , -0.764398 , 0.5816 , -0.867612 , -0.714131 , 6.66 , 16.921431 , 78.083557 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1710836412) [ RunTime:0.000624s ]
---------------------------------------------------------------
[ 2024-03-19T16:23:11+08:00 ] 39.144.112.3 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002899s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011077s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000740s ]
---------------------------------------------------------------
[ 2024-03-19T16:23:13+08:00 ] 39.144.112.3 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710836591&v1=-1.149863&v2=0.062394&v3=-0.949245&v4=-0.544244&v5=6.480000&t=17.800888&h=76.916260&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001807s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010060s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000700s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710836591,`v1`=-1.149863,`v2`=0.062394,`v3`=-0.949245,`v4`=-0.544244,`v5`=6.48,`t`=17.800888,`h`=76.91626,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710836593 WHERE `imei` = '868922055644021' [ RunTime:0.000607s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012620s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710836591 , -1.149863 , 0.062394 , -0.949245 , -0.544244 , 6.48 , 17.800888 , 76.91626 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1710836593) [ RunTime:0.000555s ]
---------------------------------------------------------------
[ 2024-03-19T16:32:12+08:00 ] 39.144.10.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002305s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010737s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000782s ]
---------------------------------------------------------------
[ 2024-03-19T16:32:14+08:00 ] 39.144.10.20 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710837132&v1=-0.138552&v2=0.564871&v3=-0.831462&v4=-0.485970&v5=6.480000&t=16.739103&h=78.175110&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002758s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010375s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000788s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710837132,`v1`=-0.138552,`v2`=0.564871,`v3`=-0.831462,`v4`=-0.48597,`v5`=6.48,`t`=16.739103,`h`=78.17511,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1710837134 WHERE `imei` = '868922055684209' [ RunTime:0.000634s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012819s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1710837132 , -0.138552 , 0.564871 , -0.831462 , -0.48597 , 6.48 , 16.739103 , 78.17511 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1710837134) [ RunTime:0.000574s ]
---------------------------------------------------------------
[ 2024-03-19T16:35:11+08:00 ] 39.144.112.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011073s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000713s ]
---------------------------------------------------------------
[ 2024-03-19T16:35:13+08:00 ] 39.144.112.41 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710837311&v1=-1.172920&v2=0.061809&v3=-0.993462&v4=-0.531422&v5=6.660000&t=16.942881&h=77.335876&rssi=22&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001860s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010558s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000820s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710837311,`v1`=-1.17292,`v2`=0.061809,`v3`=-0.993462,`v4`=-0.531422,`v5`=6.66,`t`=16.942881,`h`=77.335876,`rssi`=22,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710837313 WHERE `imei` = '868922055644021' [ RunTime:0.000623s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012161s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710837311 , -1.17292 , 0.061809 , -0.993462 , -0.531422 , 6.66 , 16.942881 , 77.335876 , 22 , '898604650119C1053141' , '460048590503141' , -0 , 1710837313) [ RunTime:0.000579s ]
---------------------------------------------------------------
[ 2024-03-19T16:43:28+08:00 ] 39.144.112.27 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002640s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011918s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000729s ]
---------------------------------------------------------------
[ 2024-03-19T16:43:29+08:00 ] 39.144.112.27 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710837808&v1=-3.083209&v2=0.629373&v3=-0.948161&v4=-1.155101&v5=6.480000&t=16.159948&h=78.411621&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.427287,36.322692&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002085s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011659s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710837808,`v1`=-3.083209,`v2`=0.629373,`v3`=-0.948161,`v4`=-1.155101,`v5`=6.48,`t`=16.159948,`h`=78.411621,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.427287,36.322692',`update_time`=1710837809 WHERE `imei` = '868922055684209' [ RunTime:0.000911s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012696s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710837808 , -3.083209 , 0.629373 , -0.948161 , -1.155101 , 6.48 , 16.159948 , 78.411621 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.427287,36.322692' , 1710837809) [ RunTime:0.000722s ]
---------------------------------------------------------------
[ 2024-03-19T16:47:12+08:00 ] 39.144.112.30 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001873s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013378s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000813s ]
---------------------------------------------------------------
[ 2024-03-19T16:47:14+08:00 ] 39.144.112.30 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710838032&v1=-1.175208&v2=0.063437&v3=-1.010047&v4=-0.525281&v5=6.480000&t=16.213573&h=77.602905&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002384s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015048s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000895s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710838032,`v1`=-1.175208,`v2`=0.063437,`v3`=-1.010047,`v4`=-0.525281,`v5`=6.48,`t`=16.213573,`h`=77.602905,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710838034 WHERE `imei` = '868922055644021' [ RunTime:0.000716s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015060s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710838032 , -1.175208 , 0.063437 , -1.010047 , -0.525281 , 6.48 , 16.213573 , 77.602905 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1710838034) [ RunTime:0.000758s ]
---------------------------------------------------------------
[ 2024-03-19T16:54:26+08:00 ] 117.132.195.73 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002939s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011923s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001006s ]
---------------------------------------------------------------
[ 2024-03-19T16:54:27+08:00 ] 117.132.195.73 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710838466&v1=-1.769870&v2=0.603438&v3=-0.848107&v4=-0.925074&v5=6.660000&t=15.999072&h=78.403992&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428417,36.323138&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001980s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012780s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000800s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710838466,`v1`=-1.76987,`v2`=0.603438,`v3`=-0.848107,`v4`=-0.925074,`v5`=6.66,`t`=15.999072,`h`=78.403992,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428417,36.323138',`update_time`=1710838467 WHERE `imei` = '868922055684209' [ RunTime:0.000697s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011249s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710838466 , -1.76987 , 0.603438 , -0.848107 , -0.925074 , 6.66 , 15.999072 , 78.403992 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428417,36.323138' , 1710838467) [ RunTime:0.000580s ]
---------------------------------------------------------------
[ 2024-03-19T16:58:52+08:00 ] 39.144.112.6 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002364s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012226s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000839s ]
---------------------------------------------------------------
[ 2024-03-19T16:58:53+08:00 ] 39.144.112.6 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710838732&v1=-1.170151&v2=0.062746&v3=-1.020522&v4=-0.520345&v5=6.480000&t=15.602243&h=77.763123&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&gps=120.427620,36.325526&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.003015s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012152s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000824s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710838732,`v1`=-1.170151,`v2`=0.062746,`v3`=-1.020522,`v4`=-0.520345,`v5`=6.48,`t`=15.602243,`h`=77.763123,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`gps`='120.427620,36.325526',`update_time`=1710838733 WHERE `imei` = '868922055644021' [ RunTime:0.000813s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013238s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055644021' , 1710838732 , -1.170151 , 0.062746 , -1.020522 , -0.520345 , 6.48 , 15.602243 , 77.763123 , 23 , '898604650119C1053141' , '460048590503141' , -0 , '120.427620,36.325526' , 1710838733) [ RunTime:0.000613s ]
---------------------------------------------------------------
[ 2024-03-19T17:05:50+08:00 ] 117.132.193.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001894s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010118s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000839s ]
---------------------------------------------------------------
[ 2024-03-19T17:05:52+08:00 ] 117.132.193.247 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710839150&v1=-0.226385&v2=0.573534&v3=-0.923539&v4=-0.494699&v5=6.480000&t=15.688045&h=78.487915&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428400,36.323156&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002412s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011333s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000728s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710839150,`v1`=-0.226385,`v2`=0.573534,`v3`=-0.923539,`v4`=-0.494699,`v5`=6.48,`t`=15.688045,`h`=78.487915,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428400,36.323156',`update_time`=1710839152 WHERE `imei` = '868922055684209' [ RunTime:0.000611s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011762s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710839150 , -0.226385 , 0.573534 , -0.923539 , -0.494699 , 6.48 , 15.688045 , 78.487915 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428400,36.323156' , 1710839152) [ RunTime:0.000566s ]
---------------------------------------------------------------
[ 2024-03-19T17:07:37+08:00 ] 112.224.164.2 GET /admin/show/index.html?keyword=868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002665s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015461s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.000726s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001080s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001868s ]
---------------------------------------------------------------
[ 2024-03-19T17:10:10+08:00 ] 39.144.112.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001919s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012295s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000687s ]
---------------------------------------------------------------
[ 2024-03-19T17:10:12+08:00 ] 39.144.112.20 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710839410&v1=-1.177495&v2=0.063640&v3=-1.025278&v4=-0.518358&v5=6.480000&t=15.141065&h=77.892822&rssi=22&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002220s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013037s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000682s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710839410,`v1`=-1.177495,`v2`=0.06364,`v3`=-1.025278,`v4`=-0.518358,`v5`=6.48,`t`=15.141065,`h`=77.892822,`rssi`=22,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710839412 WHERE `imei` = '868922055644021' [ RunTime:0.000648s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011099s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710839410 , -1.177495 , 0.06364 , -1.025278 , -0.518358 , 6.48 , 15.141065 , 77.892822 , 22 , '898604650119C1053141' , '460048590503141' , -0 , 1710839412) [ RunTime:0.000692s ]
---------------------------------------------------------------
[ 2024-03-19T17:13:47+08:00 ] 112.224.164.2 GET /admin/show/index.html?keyword=868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002759s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014217s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.000508s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000876s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001860s ]
---------------------------------------------------------------
[ 2024-03-19T17:13:50+08:00 ] 112.224.164.2 GET /admin/show/read/id/41/imei/868922055644021.html
[ 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.011172s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000718s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012321s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000659s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002883s ]
---------------------------------------------------------------
[ 2024-03-19T17:17:13+08:00 ] 39.144.112.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002075s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010386s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000749s ]
---------------------------------------------------------------
[ 2024-03-19T17:17:14+08:00 ] 39.144.112.41 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710839833&v1=-0.072572&v2=0.566872&v3=-0.753683&v4=-0.620579&v5=6.480000&t=15.044538&h=78.648132&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002079s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011284s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000712s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710839833,`v1`=-0.072572,`v2`=0.566872,`v3`=-0.753683,`v4`=-0.620579,`v5`=6.48,`t`=15.044538,`h`=78.648132,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1710839834 WHERE `imei` = '868922055684209' [ RunTime:0.000704s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011418s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1710839833 , -0.072572 , 0.566872 , -0.753683 , -0.620579 , 6.48 , 15.044538 , 78.648132 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1710839834) [ RunTime:0.000645s ]
---------------------------------------------------------------
[ 2024-03-19T17:22:11+08:00 ] 39.144.112.4 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002987s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015019s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000726s ]
---------------------------------------------------------------
[ 2024-03-19T17:22:13+08:00 ] 39.144.112.4 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710840131&v1=-1.181108&v2=0.063299&v3=-1.030184&v4=-0.518358&v5=6.660000&t=14.594085&h=77.984375&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002206s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001065s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710840131,`v1`=-1.181108,`v2`=0.063299,`v3`=-1.030184,`v4`=-0.518358,`v5`=6.66,`t`=14.594085,`h`=77.984375,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710840133 WHERE `imei` = '868922055644021' [ RunTime:0.000927s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014394s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710840131 , -1.181108 , 0.063299 , -1.030184 , -0.518358 , 6.66 , 14.594085 , 77.984375 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1710840133) [ RunTime:0.000984s ]
---------------------------------------------------------------
[ 2024-03-19T17:28:25+08:00 ] 39.144.18.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ 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.013007s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000761s ]
---------------------------------------------------------------
[ 2024-03-19T17:28:26+08:00 ] 39.144.18.103 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710840505&v1=-1.820740&v2=0.524261&v3=-0.975402&v4=-0.745194&v5=6.480000&t=14.165081&h=78.899902&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.429229,36.322207&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002221s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011028s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000746s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710840505,`v1`=-1.82074,`v2`=0.524261,`v3`=-0.975402,`v4`=-0.745194,`v5`=6.48,`t`=14.165081,`h`=78.899902,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.429229,36.322207',`update_time`=1710840506 WHERE `imei` = '868922055684209' [ RunTime:0.000647s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.029716s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710840505 , -1.82074 , 0.524261 , -0.975402 , -0.745194 , 6.48 , 14.165081 , 78.899902 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.429229,36.322207' , 1710840506) [ RunTime:0.000610s ]
---------------------------------------------------------------
[ 2024-03-19T17:34:12+08:00 ] 39.144.112.21 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002662s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011861s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000744s ]
---------------------------------------------------------------
[ 2024-03-19T17:34:13+08:00 ] 39.144.112.21 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710840852&v1=-1.183696&v2=0.060713&v3=-1.033826&v4=-0.516552&v5=6.480000&t=14.100730&h=78.075928&rssi=25&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001904s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010211s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000681s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710840852,`v1`=-1.183696,`v2`=0.060713,`v3`=-1.033826,`v4`=-0.516552,`v5`=6.48,`t`=14.10073,`h`=78.075928,`rssi`=25,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710840853 WHERE `imei` = '868922055644021' [ RunTime:0.000607s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010673s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710840852 , -1.183696 , 0.060713 , -1.033826 , -0.516552 , 6.48 , 14.10073 , 78.075928 , 25 , '898604650119C1053141' , '460048590503141' , -0 , 1710840853) [ RunTime:0.000538s ]
---------------------------------------------------------------
[ 2024-03-19T17:38:59+08:00 ] 39.144.7.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002354s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010482s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000794s ]
---------------------------------------------------------------
[ 2024-03-19T17:39:01+08:00 ] 39.144.7.46 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710841139&v1=-0.743810&v2=0.555921&v3=-0.777402&v4=-0.786673&v5=6.660000&t=13.489399&h=79.029602&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002084s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010693s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000694s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710841139,`v1`=-0.74381,`v2`=0.555921,`v3`=-0.777402,`v4`=-0.786673,`v5`=6.66,`t`=13.489399,`h`=79.029602,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1710841141 WHERE `imei` = '868922055684209' [ RunTime:0.000734s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015000s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1710841139 , -0.74381 , 0.555921 , -0.777402 , -0.786673 , 6.66 , 13.489399 , 79.029602 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1710841141) [ RunTime:0.000829s ]
---------------------------------------------------------------
[ 2024-03-19T17:46:12+08:00 ] 111.55.140.67 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002294s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011952s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000750s ]
---------------------------------------------------------------
[ 2024-03-19T17:46:13+08:00 ] 111.55.140.67 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710841572&v1=-1.182071&v2=0.061075&v3=-1.036174&v4=-0.515167&v5=6.480000&t=13.575200&h=78.197998&rssi=26&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001951s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011082s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000684s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710841572,`v1`=-1.182071,`v2`=0.061075,`v3`=-1.036174,`v4`=-0.515167,`v5`=6.48,`t`=13.5752,`h`=78.197998,`rssi`=26,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710841573 WHERE `imei` = '868922055644021' [ RunTime:0.001237s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010971s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710841572 , -1.182071 , 0.061075 , -1.036174 , -0.515167 , 6.48 , 13.5752 , 78.197998 , 26 , '898604650119C1053141' , '460048590503141' , -0 , 1710841573) [ RunTime:0.000634s ]
---------------------------------------------------------------
[ 2024-03-19T17:50:56+08:00 ] 39.144.112.6 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001763s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010977s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000723s ]
---------------------------------------------------------------
[ 2024-03-19T17:50:58+08:00 ] 39.144.112.6 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710841856&v1=-0.865415&v2=0.568287&v3=-0.824328&v4=-0.721656&v5=6.480000&t=12.899519&h=79.075378&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428490,36.323203&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.011318s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000687s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710841856,`v1`=-0.865415,`v2`=0.568287,`v3`=-0.824328,`v4`=-0.721656,`v5`=6.48,`t`=12.899519,`h`=79.075378,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428490,36.323203',`update_time`=1710841858 WHERE `imei` = '868922055684209' [ RunTime:0.000624s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012306s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710841856 , -0.865415 , 0.568287 , -0.824328 , -0.721656 , 6.48 , 12.899519 , 79.075378 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428490,36.323203' , 1710841858) [ RunTime:0.000658s ]
---------------------------------------------------------------
[ 2024-03-19T17:58:11+08:00 ] 39.144.112.43 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002553s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012818s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000734s ]
---------------------------------------------------------------
[ 2024-03-19T17:58:12+08:00 ] 39.144.112.43 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710842291&v1=-1.181830&v2=0.062916&v3=-1.039546&v4=-0.513783&v5=6.480000&t=13.017495&h=78.281921&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001936s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010955s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000732s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710842291,`v1`=-1.18183,`v2`=0.062916,`v3`=-1.039546,`v4`=-0.513783,`v5`=6.48,`t`=13.017495,`h`=78.281921,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710842292 WHERE `imei` = '868922055644021' [ RunTime:0.000635s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010356s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710842291 , -1.18183 , 0.062916 , -1.039546 , -0.513783 , 6.48 , 13.017495 , 78.281921 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1710842292) [ RunTime:0.000531s ]
---------------------------------------------------------------
[ 2024-03-19T18:01:36+08:00 ] 39.144.3.245 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001979s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010362s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000694s ]
---------------------------------------------------------------
[ 2024-03-19T18:01:37+08:00 ] 39.144.3.245 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710842496&v1=-1.256599&v2=0.561327&v3=-0.780201&v4=-0.992258&v5=6.480000&t=12.449065&h=79.044861&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428234,36.322931&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001832s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010239s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000743s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710842496,`v1`=-1.256599,`v2`=0.561327,`v3`=-0.780201,`v4`=-0.992258,`v5`=6.48,`t`=12.449065,`h`=79.044861,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428234,36.322931',`update_time`=1710842497 WHERE `imei` = '868922055684209' [ RunTime:0.000705s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011510s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710842496 , -1.256599 , 0.561327 , -0.780201 , -0.992258 , 6.48 , 12.449065 , 79.044861 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428234,36.322931' , 1710842497) [ RunTime:0.000641s ]
---------------------------------------------------------------
[ 2024-03-19T18:10:12+08:00 ] 39.144.112.6 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002316s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011342s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000815s ]
---------------------------------------------------------------
[ 2024-03-19T18:10:13+08:00 ] 39.144.112.6 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710843012&v1=-1.182312&v2=0.068854&v3=-1.041562&v4=-0.514505&v5=6.300000&t=12.352539&h=78.457397&rssi=27&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001899s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012311s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000780s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710843012,`v1`=-1.182312,`v2`=0.068854,`v3`=-1.041562,`v4`=-0.514505,`v5`=6.3,`t`=12.352539,`h`=78.457397,`rssi`=27,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710843013 WHERE `imei` = '868922055644021' [ RunTime:0.000699s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014195s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710843012 , -1.182312 , 0.068854 , -1.041562 , -0.514505 , 6.3 , 12.352539 , 78.457397 , 27 , '898604650119C1053141' , '460048590503141' , -0 , 1710843013) [ RunTime:0.000640s ]
---------------------------------------------------------------
[ 2024-03-19T18:12:12+08:00 ] 39.144.5.17 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002009s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012481s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000779s ]
---------------------------------------------------------------
[ 2024-03-19T18:12:13+08:00 ] 39.144.5.17 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710843132&v1=-0.625576&v2=0.590593&v3=-0.881308&v4=-0.793535&v5=6.480000&t=11.816284&h=79.121155&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428417,36.323139&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002525s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010640s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000676s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710843132,`v1`=-0.625576,`v2`=0.590593,`v3`=-0.881308,`v4`=-0.793535,`v5`=6.48,`t`=11.816284,`h`=79.121155,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428417,36.323139',`update_time`=1710843133 WHERE `imei` = '868922055684209' [ RunTime:0.000739s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013077s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710843132 , -0.625576 , 0.590593 , -0.881308 , -0.793535 , 6.48 , 11.816284 , 79.121155 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428417,36.323139' , 1710843133) [ RunTime:0.000726s ]
---------------------------------------------------------------
[ 2024-03-19T18:13:15+08:00 ] 112.224.164.2 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001852s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010768s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000398s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001501s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001082s ]
---------------------------------------------------------------
[ 2024-03-19T18:13:21+08:00 ] 112.224.164.2 GET /admin/show/index.html?keyword=868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001748s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009924s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.000459s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000761s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001602s ]
---------------------------------------------------------------
[ 2024-03-19T18:13:23+08:00 ] 112.224.164.2 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001675s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010923s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000714s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012843s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000739s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003546s ]
---------------------------------------------------------------
[ 2024-03-19T18:22:11+08:00 ] 39.144.112.17 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.003463s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011775s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001008s ]
---------------------------------------------------------------
[ 2024-03-19T18:22:12+08:00 ] 39.144.112.17 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710843731&v1=-1.180144&v2=0.068003&v3=-1.042887&v4=-0.514084&v5=6.480000&t=11.601782&h=78.609985&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001817s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011256s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000798s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710843731,`v1`=-1.180144,`v2`=0.068003,`v3`=-1.042887,`v4`=-0.514084,`v5`=6.48,`t`=11.601782,`h`=78.609985,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710843732 WHERE `imei` = '868922055644021' [ RunTime:0.000712s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012411s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710843731 , -1.180144 , 0.068003 , -1.042887 , -0.514084 , 6.48 , 11.601782 , 78.609985 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1710843732) [ RunTime:0.000643s ]
---------------------------------------------------------------
[ 2024-03-19T18:23:32+08:00 ] 39.144.112.5 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001951s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011547s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000741s ]
---------------------------------------------------------------
[ 2024-03-19T18:23:33+08:00 ] 39.144.112.5 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710843812&v1=0.485488&v2=0.612218&v3=-0.949214&v4=-0.597040&v5=6.480000&t=11.044077&h=79.243225&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428400,36.323154&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002887s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010138s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000703s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710843812,`v1`=0.485488,`v2`=0.612218,`v3`=-0.949214,`v4`=-0.59704,`v5`=6.48,`t`=11.044077,`h`=79.243225,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428400,36.323154',`update_time`=1710843813 WHERE `imei` = '868922055684209' [ RunTime:0.000625s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011467s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710843812 , 0.485488 , 0.612218 , -0.949214 , -0.59704 , 6.48 , 11.044077 , 79.243225 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428400,36.323154' , 1710843813) [ RunTime:0.000526s ]
---------------------------------------------------------------
[ 2024-03-19T18:34:12+08:00 ] 39.144.112.6 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.003866s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013934s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000987s ]
---------------------------------------------------------------
[ 2024-03-19T18:34:13+08:00 ] 39.144.112.6 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710844452&v1=-1.180746&v2=0.069142&v3=-1.044994&v4=-0.512398&v5=6.300000&t=10.818851&h=78.747314&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010509s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000852s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710844452,`v1`=-1.180746,`v2`=0.069142,`v3`=-1.044994,`v4`=-0.512398,`v5`=6.3,`t`=10.818851,`h`=78.747314,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710844453 WHERE `imei` = '868922055644021' [ RunTime:0.000627s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011633s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710844452 , -1.180746 , 0.069142 , -1.044994 , -0.512398 , 6.3 , 10.818851 , 78.747314 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1710844453) [ RunTime:0.000615s ]
---------------------------------------------------------------
[ 2024-03-19T18:34:21+08:00 ] 39.144.112.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001956s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012714s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000733s ]
---------------------------------------------------------------
[ 2024-03-19T18:34:23+08:00 ] 39.144.112.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710844461&v1=-1.345817&v2=0.616517&v3=-0.880887&v4=-0.763856&v5=6.300000&t=10.271870&h=79.319519&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428443,36.323241&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001906s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009752s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000732s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710844461,`v1`=-1.345817,`v2`=0.616517,`v3`=-0.880887,`v4`=-0.763856,`v5`=6.3,`t`=10.27187,`h`=79.319519,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428443,36.323241',`update_time`=1710844463 WHERE `imei` = '868922055684209' [ RunTime:0.001132s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012104s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710844461 , -1.345817 , 0.616517 , -0.880887 , -0.763856 , 6.3 , 10.27187 , 79.319519 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428443,36.323241' , 1710844463) [ RunTime:0.000538s ]
---------------------------------------------------------------
[ 2024-03-19T18:45:56+08:00 ] 117.132.196.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002462s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012067s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000837s ]
---------------------------------------------------------------
[ 2024-03-19T18:45:57+08:00 ] 117.132.196.103 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710845156&v1=-0.621783&v2=0.632235&v3=-0.858372&v4=-0.430224&v5=6.480000&t=9.499663&h=79.350037&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428262,36.322734&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002214s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011602s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000781s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710845156,`v1`=-0.621783,`v2`=0.632235,`v3`=-0.858372,`v4`=-0.430224,`v5`=6.48,`t`=9.499663,`h`=79.350037,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428262,36.322734',`update_time`=1710845157 WHERE `imei` = '868922055684209' [ RunTime:0.000774s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013655s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710845156 , -0.621783 , 0.632235 , -0.858372 , -0.430224 , 6.48 , 9.499663 , 79.350037 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428262,36.322734' , 1710845157) [ RunTime:0.000757s ]
---------------------------------------------------------------
[ 2024-03-19T18:46:03+08:00 ] 39.144.112.33 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001912s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012517s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000796s ]
---------------------------------------------------------------
[ 2024-03-19T18:46:04+08:00 ] 39.144.112.33 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710845163&v1=-1.183937&v2=0.067747&v3=-1.046047&v4=-0.510532&v5=6.480000&t=10.057368&h=78.869385&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&gps=120.428595,36.326033&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.011493s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000688s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710845163,`v1`=-1.183937,`v2`=0.067747,`v3`=-1.046047,`v4`=-0.510532,`v5`=6.48,`t`=10.057368,`h`=78.869385,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`gps`='120.428595,36.326033',`update_time`=1710845164 WHERE `imei` = '868922055644021' [ RunTime:0.000598s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010466s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055644021' , 1710845163 , -1.183937 , 0.067747 , -1.046047 , -0.510532 , 6.48 , 10.057368 , 78.869385 , 23 , '898604650119C1053141' , '460048590503141' , -0 , '120.428595,36.326033' , 1710845164) [ RunTime:0.000959s ]
---------------------------------------------------------------
[ 2024-03-19T18:56:19+08:00 ] 39.144.112.31 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.003186s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013913s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001119s ]
---------------------------------------------------------------
[ 2024-03-19T18:56:20+08:00 ] 39.144.112.31 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710845779&v1=-2.169302&v2=0.645687&v3=-0.993944&v4=-0.883716&v5=6.480000&t=8.845432&h=79.342407&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428423,36.323188&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001897s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011589s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000765s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710845779,`v1`=-2.169302,`v2`=0.645687,`v3`=-0.993944,`v4`=-0.883716,`v5`=6.48,`t`=8.845432,`h`=79.342407,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428423,36.323188',`update_time`=1710845780 WHERE `imei` = '868922055684209' [ RunTime:0.000722s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009895s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710845779 , -2.169302 , 0.645687 , -0.993944 , -0.883716 , 6.48 , 8.845432 , 79.342407 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428423,36.323188' , 1710845780) [ RunTime:0.001911s ]
---------------------------------------------------------------
[ 2024-03-19T18:58:12+08:00 ] 39.144.112.27 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002353s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013566s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000779s ]
---------------------------------------------------------------
[ 2024-03-19T18:58:13+08:00 ] 39.144.112.27 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710845892&v1=-1.183997&v2=0.067992&v3=-1.047041&v4=-0.511315&v5=6.480000&t=9.403137&h=78.968567&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001835s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010731s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000752s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710845892,`v1`=-1.183997,`v2`=0.067992,`v3`=-1.047041,`v4`=-0.511315,`v5`=6.48,`t`=9.403137,`h`=78.968567,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710845893 WHERE `imei` = '868922055644021' [ RunTime:0.000643s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011823s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710845892 , -1.183997 , 0.067992 , -1.047041 , -0.511315 , 6.48 , 9.403137 , 78.968567 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1710845893) [ RunTime:0.000561s ]
---------------------------------------------------------------
[ 2024-03-19T19:07:18+08:00 ] 39.144.112.47 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002845s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013206s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000776s ]
---------------------------------------------------------------
[ 2024-03-19T19:07:19+08:00 ] 39.144.112.47 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710846438&v1=-1.225596&v2=0.636854&v3=-0.849522&v4=-0.894010&v5=6.480000&t=8.212651&h=79.395813&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428031,36.322979&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001827s ] 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` = '868922055684209' LIMIT 1 [ RunTime:0.000742s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710846438,`v1`=-1.225596,`v2`=0.636854,`v3`=-0.849522,`v4`=-0.89401,`v5`=6.48,`t`=8.212651,`h`=79.395813,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428031,36.322979',`update_time`=1710846439 WHERE `imei` = '868922055684209' [ RunTime:0.000682s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011279s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710846438 , -1.225596 , 0.636854 , -0.849522 , -0.89401 , 6.48 , 8.212651 , 79.395813 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428031,36.322979' , 1710846439) [ RunTime:0.000946s ]
---------------------------------------------------------------
[ 2024-03-19T19:10:11+08:00 ] 39.144.112.12 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002402s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014148s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000767s ]
---------------------------------------------------------------
[ 2024-03-19T19:10:12+08:00 ] 39.144.112.12 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710846611&v1=-1.188151&v2=0.072324&v3=-1.048847&v4=-0.513723&v5=6.480000&t=8.791806&h=78.999084&rssi=24&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001884s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012813s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000725s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710846611,`v1`=-1.188151,`v2`=0.072324,`v3`=-1.048847,`v4`=-0.513723,`v5`=6.48,`t`=8.791806,`h`=78.999084,`rssi`=24,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710846612 WHERE `imei` = '868922055644021' [ RunTime:0.000735s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014087s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710846611 , -1.188151 , 0.072324 , -1.048847 , -0.513723 , 6.48 , 8.791806 , 78.999084 , 24 , '898604650119C1053141' , '460048590503141' , -0 , 1710846612) [ RunTime:0.000631s ]
---------------------------------------------------------------
[ 2024-03-19T19:14:20+08:00 ] 112.224.164.2 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002339s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013376s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000742s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013024s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000728s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003067s ]
---------------------------------------------------------------
[ 2024-03-19T19:15:58+08:00 ] 112.224.154.197 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001686s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010672s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000716s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011189s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001007s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002772s ]
---------------------------------------------------------------
[ 2024-03-19T19:16:22+08:00 ] 112.224.154.197 GET /admin/show/index.html?keyword=868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002061s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013110s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.001181s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000690s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001180s ]
---------------------------------------------------------------
[ 2024-03-19T19:18:56+08:00 ] 111.55.139.159 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001860s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011728s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000781s ]
---------------------------------------------------------------
[ 2024-03-19T19:18:57+08:00 ] 111.55.139.159 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710847136&v1=-2.765168&v2=0.631916&v3=-0.994335&v4=-0.976245&v5=6.480000&t=7.730022&h=79.327148&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428365,36.323071&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002574s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012984s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000917s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710847136,`v1`=-2.765168,`v2`=0.631916,`v3`=-0.994335,`v4`=-0.976245,`v5`=6.48,`t`=7.730022,`h`=79.327148,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428365,36.323071',`update_time`=1710847137 WHERE `imei` = '868922055684209' [ RunTime:0.000940s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014020s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710847136 , -2.765168 , 0.631916 , -0.994335 , -0.976245 , 6.48 , 7.730022 , 79.327148 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428365,36.323071' , 1710847137) [ RunTime:0.001309s ]
---------------------------------------------------------------
[ 2024-03-19T19:22:03+08:00 ] 39.144.112.36 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002382s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010832s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000750s ]
---------------------------------------------------------------
[ 2024-03-19T19:22:04+08:00 ] 39.144.112.36 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710847323&v1=-1.188994&v2=0.070099&v3=-1.050141&v4=-0.513783&v5=6.480000&t=8.244826&h=79.006714&rssi=25&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&gps=120.427529,36.326448&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002136s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011513s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000764s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710847323,`v1`=-1.188994,`v2`=0.070099,`v3`=-1.050141,`v4`=-0.513783,`v5`=6.48,`t`=8.244826,`h`=79.006714,`rssi`=25,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`gps`='120.427529,36.326448',`update_time`=1710847324 WHERE `imei` = '868922055644021' [ RunTime:0.000592s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012017s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055644021' , 1710847323 , -1.188994 , 0.070099 , -1.050141 , -0.513783 , 6.48 , 8.244826 , 79.006714 , 25 , '898604650119C1053141' , '460048590503141' , -0 , '120.427529,36.326448' , 1710847324) [ RunTime:0.000563s ]
---------------------------------------------------------------
[ 2024-03-19T19:29:45+08:00 ] 39.144.112.25 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.004404s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015156s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001114s ]
---------------------------------------------------------------
[ 2024-03-19T19:29:47+08:00 ] 39.144.112.25 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710847785&v1=-3.046607&v2=0.641696&v3=-1.093726&v4=-1.081235&v5=6.660000&t=7.418994&h=79.220337&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428400,36.323044&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002144s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011845s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000772s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710847785,`v1`=-3.046607,`v2`=0.641696,`v3`=-1.093726,`v4`=-1.081235,`v5`=6.66,`t`=7.418994,`h`=79.220337,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428400,36.323044',`update_time`=1710847787 WHERE `imei` = '868922055684209' [ RunTime:0.000654s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009976s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710847785 , -3.046607 , 0.641696 , -1.093726 , -1.081235 , 6.66 , 7.418994 , 79.220337 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428400,36.323044' , 1710847787) [ RunTime:0.000796s ]
---------------------------------------------------------------
[ 2024-03-19T19:34:11+08:00 ] 111.55.139.146 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002939s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015358s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001047s ]
---------------------------------------------------------------
[ 2024-03-19T19:34:12+08:00 ] 111.55.139.146 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710848051&v1=-1.183937&v2=0.070270&v3=-1.049689&v4=-0.511676&v5=6.480000&t=7.762197&h=79.014343&rssi=25&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002369s ] 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` = '868922055644021' LIMIT 1 [ RunTime:0.000750s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710848051,`v1`=-1.183937,`v2`=0.07027,`v3`=-1.049689,`v4`=-0.511676,`v5`=6.48,`t`=7.762197,`h`=79.014343,`rssi`=25,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710848052 WHERE `imei` = '868922055644021' [ RunTime:0.000663s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011055s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710848051 , -1.183937 , 0.07027 , -1.049689 , -0.511676 , 6.48 , 7.762197 , 79.014343 , 25 , '898604650119C1053141' , '460048590503141' , -0 , 1710848052) [ RunTime:0.000560s ]
---------------------------------------------------------------
[ 2024-03-19T19:40:21+08:00 ] 39.144.5.220 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002484s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011875s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000733s ]
---------------------------------------------------------------
[ 2024-03-19T19:40:22+08:00 ] 39.144.5.220 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710848421&v1=0.945482&v2=0.857965&v3=-0.845398&v4=-0.642071&v5=6.300000&t=7.204492&h=79.136414&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428274,36.323124&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001962s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010838s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000746s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710848421,`v1`=0.945482,`v2`=0.857965,`v3`=-0.845398,`v4`=-0.642071,`v5`=6.3,`t`=7.204492,`h`=79.136414,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428274,36.323124',`update_time`=1710848422 WHERE `imei` = '868922055684209' [ RunTime:0.000763s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011153s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710848421 , 0.945482 , 0.857965 , -0.845398 , -0.642071 , 6.3 , 7.204492 , 79.136414 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.428274,36.323124' , 1710848422) [ RunTime:0.000579s ]
---------------------------------------------------------------
[ 2024-03-19T19:46:12+08:00 ] 39.144.112.45 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002062s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012422s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000719s ]
---------------------------------------------------------------
[ 2024-03-19T19:46:13+08:00 ] 39.144.112.45 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710848772&v1=-1.184599&v2=0.068312&v3=-1.051255&v4=-0.512759&v5=6.480000&t=7.429719&h=78.930420&rssi=26&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002186s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011997s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000740s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710848772,`v1`=-1.184599,`v2`=0.068312,`v3`=-1.051255,`v4`=-0.512759,`v5`=6.48,`t`=7.429719,`h`=78.93042,`rssi`=26,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710848773 WHERE `imei` = '868922055644021' [ RunTime:0.000730s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014495s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710848772 , -1.184599 , 0.068312 , -1.051255 , -0.512759 , 6.48 , 7.429719 , 78.93042 , 26 , '898604650119C1053141' , '460048590503141' , -0 , 1710848773) [ RunTime:0.001174s ]
---------------------------------------------------------------
[ 2024-03-19T19:52:12+08:00 ] 39.144.4.18 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012331s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000799s ]
---------------------------------------------------------------
[ 2024-03-19T19:52:14+08:00 ] 39.144.4.18 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710849132&v1=-1.716833&v2=0.625733&v3=-0.930342&v4=-0.808044&v5=6.300000&t=7.054341&h=79.067749&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.429714,36.323627&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001893s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010597s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000686s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710849132,`v1`=-1.716833,`v2`=0.625733,`v3`=-0.930342,`v4`=-0.808044,`v5`=6.3,`t`=7.054341,`h`=79.067749,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.429714,36.323627',`update_time`=1710849134 WHERE `imei` = '868922055684209' [ RunTime:0.000632s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012420s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710849132 , -1.716833 , 0.625733 , -0.930342 , -0.808044 , 6.3 , 7.054341 , 79.067749 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.429714,36.323627' , 1710849134) [ RunTime:0.000688s ]
---------------------------------------------------------------
[ 2024-03-19T19:58:12+08:00 ] 111.55.141.188 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ 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.012778s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000677s ]
---------------------------------------------------------------
[ 2024-03-19T19:58:13+08:00 ] 111.55.141.188 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710849492&v1=-1.194833&v2=0.067311&v3=-1.056281&v4=-0.516191&v5=6.480000&t=7.225943&h=78.815979&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002177s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010639s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000752s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710849492,`v1`=-1.194833,`v2`=0.067311,`v3`=-1.056281,`v4`=-0.516191,`v5`=6.48,`t`=7.225943,`h`=78.815979,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710849493 WHERE `imei` = '868922055644021' [ RunTime:0.000614s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011599s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710849492 , -1.194833 , 0.067311 , -1.056281 , -0.516191 , 6.48 , 7.225943 , 78.815979 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1710849493) [ RunTime:0.000592s ]
---------------------------------------------------------------
[ 2024-03-19T19:59:28+08:00 ] 124.129.68.57 GET /admin/show/index.html?keyword=868922055644021
[ 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.012433s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.000495s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000737s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001251s ]
---------------------------------------------------------------
[ 2024-03-19T20:04:04+08:00 ] 221.178.126.218 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001890s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010400s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000732s ]
---------------------------------------------------------------
[ 2024-03-19T20:04:06+08:00 ] 221.178.126.218 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710849844&v1=-0.035970&v2=0.575960&v3=-0.773669&v4=-0.671569&v5=6.480000&t=7.140141&h=78.960938&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428934,36.323078&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001713s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010400s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000716s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710849844,`v1`=-0.03597,`v2`=0.57596,`v3`=-0.773669,`v4`=-0.671569,`v5`=6.48,`t`=7.140141,`h`=78.960938,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428934,36.323078',`update_time`=1710849846 WHERE `imei` = '868922055684209' [ RunTime:0.000731s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010936s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710849844 , -0.03597 , 0.57596 , -0.773669 , -0.671569 , 6.48 , 7.140141 , 78.960938 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428934,36.323078' , 1710849846) [ RunTime:0.000580s ]
---------------------------------------------------------------
[ 2024-03-19T20:05:00+08:00 ] 124.129.68.57 GET /admin/show/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_show` [ RunTime:0.010262s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000895s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000952s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001148s ]
---------------------------------------------------------------
[ 2024-03-19T20:08:20+08:00 ] 124.129.68.57 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002170s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011715s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000651s ]
---------------------------------------------------------------
[ 2024-03-19T20:08:24+08:00 ] 124.129.68.57 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002392s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011914s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000477s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001009s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001569s ]
---------------------------------------------------------------
[ 2024-03-19T20:08:33+08:00 ] 124.129.68.57 GET /admin/show/edit/id/47.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011828s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000700s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012717s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000641s ]
---------------------------------------------------------------
[ 2024-03-19T20:08:43+08:00 ] 124.129.68.57 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001919s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012414s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000548s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000861s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001138s ]
---------------------------------------------------------------
[ 2024-03-19T20:08:45+08:00 ] 124.129.68.57 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002208s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011406s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000763s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012355s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000673s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003575s ]
---------------------------------------------------------------
[ 2024-03-19T20:08:50+08:00 ] 124.129.68.57 GET /admin/user/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001632s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011770s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000462s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000632s ]
---------------------------------------------------------------
[ 2024-03-19T20:09:16+08:00 ] 124.129.68.57 POST /admin/user/save.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001997s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012095s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE ( `username` = 'shankehaiyanghuanjing' ) AND `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000599s ]
[ sql ] [ SQL ] INSERT INTO `collect_user` (`username` , `password` , `user_type` , `user_phone` , `user_email` , `introduce` , `update_time`) VALUES ('shankehaiyanghuanjing' , 'ba3c4352a7a9e9c182e1a1ca75b7e844' , 'collect' , '' , '' , ' ' , 1710850156) [ RunTime:0.000575s ]
---------------------------------------------------------------
[ 2024-03-19T20:09:17+08:00 ] 124.129.68.57 GET /admin/user/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001893s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012883s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000601s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000919s ]
---------------------------------------------------------------
[ 2024-03-19T20:09:21+08:00 ] 124.129.68.57 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011202s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000415s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000974s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001546s ]
---------------------------------------------------------------
[ 2024-03-19T20:09:29+08:00 ] 124.129.68.57 GET /admin/show/edit/id/47.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002830s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013867s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000983s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014002s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000513s ]
---------------------------------------------------------------
[ 2024-03-19T20:09:32+08:00 ] 124.129.68.57 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001978s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010021s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试2',`interval`=10,`gps`='120.428934,36.323078',`username`='shankehaiyanghuanjing',`introduce`=' ',`update_time`=1710850172 WHERE `id` = 47 [ RunTime:0.000761s ]
---------------------------------------------------------------
[ 2024-03-19T20:09:34+08:00 ] 124.129.68.57 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002220s ] 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 COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000407s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000968s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001148s ]
---------------------------------------------------------------
[ 2024-03-19T20:09:39+08:00 ] 124.129.68.57 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002075s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010292s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001126s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001120s ]
---------------------------------------------------------------
[ 2024-03-19T20:09:44+08:00 ] 124.129.68.57 GET /admin/show/edit/id/41.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001918s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010155s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000648s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010859s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000464s ]
---------------------------------------------------------------
[ 2024-03-19T20:09:50+08:00 ] 124.129.68.57 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002112s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012163s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=10,`gps`='120.427529,36.326448',`username`='shankehaiyanghuanjing',`introduce`=' ',`update_time`=1710850190 WHERE `id` = 41 [ RunTime:0.000718s ]
---------------------------------------------------------------
[ 2024-03-19T20:09:51+08:00 ] 124.129.68.57 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002042s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010360s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000423s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001035s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001387s ]
---------------------------------------------------------------
[ 2024-03-19T20:10:12+08:00 ] 39.144.112.0 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013369s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000748s ]
---------------------------------------------------------------
[ 2024-03-19T20:10:13+08:00 ] 39.144.112.0 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710850212&v1=-1.188211&v2=0.066204&v3=-1.051857&v4=-0.512338&v5=6.300000&t=7.022165&h=78.754944&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002392s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013181s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000826s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710850212,`v1`=-1.188211,`v2`=0.066204,`v3`=-1.051857,`v4`=-0.512338,`v5`=6.3,`t`=7.022165,`h`=78.754944,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710850213 WHERE `imei` = '868922055644021' [ RunTime:0.000722s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013143s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710850212 , -1.188211 , 0.066204 , -1.051857 , -0.512338 , 6.3 , 7.022165 , 78.754944 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1710850213) [ RunTime:0.000777s ]
---------------------------------------------------------------
[ 2024-03-19T20:10:30+08:00 ] 124.129.68.57 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002090s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012216s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'shankehaiyanghuanjing' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000664s ]
---------------------------------------------------------------
[ 2024-03-19T20:10:31+08:00 ] 124.129.68.57 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001884s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011738s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC [ RunTime:0.000834s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011080s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC [ RunTime:0.000642s ]
---------------------------------------------------------------
[ 2024-03-19T20:10:40+08:00 ] 124.129.68.57 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001985s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010705s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' LIMIT 1 [ RunTime:0.000527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000792s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC [ RunTime:0.000656s ]
---------------------------------------------------------------
[ 2024-03-19T20:12:22+08:00 ] 124.129.68.57 GET /home/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015134s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.001188s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014348s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000926s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004500s ]
---------------------------------------------------------------
[ 2024-03-19T20:12:41+08:00 ] 124.129.68.57 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002046s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011435s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' LIMIT 1 [ RunTime:0.000567s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000742s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC [ RunTime:0.000669s ]
---------------------------------------------------------------
[ 2024-03-19T20:12:43+08:00 ] 124.129.68.57 GET /home/show/edit/id/47.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001863s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012121s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000742s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013868s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000646s ]
---------------------------------------------------------------
[ 2024-03-19T20:12:51+08:00 ] 124.129.68.57 POST /home/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003361s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013487s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试2',`interval`=720,`gps`='120.428934,36.323078',`introduce`=' ',`update_time`=1710850371 WHERE `id` = 47 [ RunTime:0.001279s ]
---------------------------------------------------------------
[ 2024-03-19T20:12:52+08:00 ] 124.129.68.57 GET /home/show/index.html
[ 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.011802s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' LIMIT 1 [ RunTime:0.000533s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000762s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC [ RunTime:0.000665s ]
---------------------------------------------------------------
[ 2024-03-19T20:12:58+08:00 ] 124.129.68.57 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002206s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011798s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' LIMIT 1 [ RunTime:0.000841s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000798s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC [ RunTime:0.000645s ]
---------------------------------------------------------------
[ 2024-03-19T20:12:59+08:00 ] 124.129.68.57 GET /home/multipleshow/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001906s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013788s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'shankehaiyanghuanjing' LIMIT 1 [ RunTime:0.000732s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000906s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.002061s ]
---------------------------------------------------------------
[ 2024-03-19T20:13:00+08:00 ] 124.129.68.57 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002006s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012639s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' LIMIT 1 [ RunTime:0.000526s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000801s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC [ RunTime:0.000624s ]
---------------------------------------------------------------
[ 2024-03-19T20:13:02+08:00 ] 124.129.68.57 GET /home/show/edit/id/41.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002333s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012244s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000762s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011666s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000585s ]
---------------------------------------------------------------
[ 2024-03-19T20:13:07+08:00 ] 124.129.68.57 POST /home/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001743s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009979s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=720,`gps`='120.427529,36.326448',`introduce`=' ',`update_time`=1710850387 WHERE `id` = 41 [ RunTime:0.000637s ]
---------------------------------------------------------------
[ 2024-03-19T20:13:08+08:00 ] 124.129.68.57 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001824s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011072s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' LIMIT 1 [ RunTime:0.000546s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000823s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC [ RunTime:0.000909s ]
---------------------------------------------------------------
[ 2024-03-19T20:13:14+08:00 ] 124.129.68.57 GET /home/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012565s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000701s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011989s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000653s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002835s ]
---------------------------------------------------------------
[ 2024-03-19T20:13:18+08:00 ] 124.129.68.57 GET /home/show/read/id/41/imei/868922055644021.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001970s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011006s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000855s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011005s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000801s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.003139s ]
---------------------------------------------------------------
[ 2024-03-19T20:13:20+08:00 ] 124.129.68.57 GET /home/show/read/id/41/imei/868922055644021.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.002678s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010464s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000723s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012173s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000676s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 20,10 [ RunTime:0.003288s ]
---------------------------------------------------------------
[ 2024-03-19T20:13:25+08:00 ] 124.129.68.57 GET /home/show/read/id/41/imei/868922055644021.html?page=4
[ sql ] [ DB ] CONNECT:[ UseTime:0.002025s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011301s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000752s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011598s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000665s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 30,10 [ RunTime:0.002861s ]
---------------------------------------------------------------
[ 2024-03-19T20:13:38+08:00 ] 124.129.68.57 GET /home/show/read/id/41/imei/868922055644021.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.002389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011450s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.001106s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008752s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000667s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 20,10 [ RunTime:0.003560s ]
---------------------------------------------------------------
[ 2024-03-19T20:13:42+08:00 ] 124.129.68.57 GET /home/show/read/id/41/imei/868922055644021.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002501s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010579s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000704s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012020s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000612s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.002742s ]
---------------------------------------------------------------
[ 2024-03-19T20:15:22+08:00 ] 124.129.68.57 GET /home/show/read/id/41/imei/868922055644021.html?page=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.002223s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011401s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000849s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011322s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000744s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002937s ]
---------------------------------------------------------------
[ 2024-03-19T20:16:13+08:00 ] 39.144.16.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.003028s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015077s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001326s ]
---------------------------------------------------------------
[ 2024-03-19T20:16:15+08:00 ] 39.144.16.141 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710850573&v1=-2.178452&v2=0.580387&v3=-1.111004&v4=-0.919837&v5=6.480000&t=7.343918&h=78.793091&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-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.012065s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001334s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710850573,`v1`=-2.178452,`v2`=0.580387,`v3`=-1.111004,`v4`=-0.919837,`v5`=6.48,`t`=7.343918,`h`=78.793091,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1710850575 WHERE `imei` = '868922055684209' [ RunTime:0.000637s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010614s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1710850573 , -2.178452 , 0.580387 , -1.111004 , -0.919837 , 6.48 , 7.343918 , 78.793091 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1710850575) [ RunTime:0.000793s ]
---------------------------------------------------------------
[ 2024-03-19T20:16:22+08:00 ] 124.129.68.57 GET /home/show/read/id/41/imei/868922055644021.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001766s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010684s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000797s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010630s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000940s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.002953s ]
---------------------------------------------------------------
[ 2024-03-19T20:16:35+08:00 ] 124.129.68.57 GET /home/show/read/id/41/imei/868922055644021.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010927s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000677s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011138s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000610s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 20,10 [ RunTime:0.002777s ]
---------------------------------------------------------------
[ 2024-03-19T20:17:21+08:00 ] 124.129.68.57 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.023052s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012840s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' LIMIT 1 [ RunTime:0.000580s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000871s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'shankehaiyanghuanjing' ORDER BY `id` DESC [ RunTime:0.000706s ]
---------------------------------------------------------------
[ 2024-03-19T20:17:23+08:00 ] 124.129.68.57 GET /home/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002077s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011608s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000854s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011228s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000774s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003069s ]
---------------------------------------------------------------
[ 2024-03-19T20:18:06+08:00 ] 124.129.68.57 GET /home/show/read/id/47/imei/868922055684209.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001965s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012052s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000716s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013138s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000647s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.003449s ]
---------------------------------------------------------------
[ 2024-03-19T20:18:19+08:00 ] 124.129.68.57 GET /home/show/read/id/47/imei/868922055684209.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001878s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011425s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000807s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010906s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000723s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 20,10 [ RunTime:0.002931s ]
---------------------------------------------------------------
[ 2024-03-19T20:18:35+08:00 ] 124.129.68.57 GET /home/show/read/id/47/imei/868922055684209.html?page=4
[ sql ] [ DB ] CONNECT:[ UseTime:0.003005s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013360s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000808s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010696s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000631s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 30,10 [ RunTime:0.003099s ]
---------------------------------------------------------------
[ 2024-03-19T20:22:12+08:00 ] 117.132.197.221 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002270s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011957s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000818s ]
---------------------------------------------------------------
[ 2024-03-19T20:22:14+08:00 ] 117.132.197.221 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710850932&v1=-1.185382&v2=0.069184&v3=-1.051556&v4=-0.511134&v5=6.480000&t=6.829114&h=78.671021&rssi=19&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.022846s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011241s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000694s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710850932,`v1`=-1.185382,`v2`=0.069184,`v3`=-1.051556,`v4`=-0.511134,`v5`=6.48,`t`=6.829114,`h`=78.671021,`rssi`=19,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710850934 WHERE `imei` = '868922055644021' [ RunTime:0.000686s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012796s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710850932 , -1.185382 , 0.069184 , -1.051556 , -0.511134 , 6.48 , 6.829114 , 78.671021 , 19 , '898604650119C1053141' , '460048590503141' , -0 , 1710850934) [ RunTime:0.000753s ]
---------------------------------------------------------------
[ 2024-03-19T23:08:51+08:00 ] 124.129.68.57 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003012s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014289s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000474s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001593s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001329s ]