--------------------------------------------------------------- [ 2023-05-29T00:00:24+08:00 ] 221.178.126.202 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.003450s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2023-05-29T00:00:25+08:00 ] 221.178.126.202 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1685289624&v1=0.021161&v2=0.013247&v3=0.018421&v4=-0.006351&v5=12.240000&t=22.434132&h=79.197449&rssi=27&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010367s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000912s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1685289624,`v1`=0.021161,`v2`=0.013247,`v3`=0.018421,`v4`=-0.006351,`v5`=12.24,`t`=22.434132,`h`=79.197449,`rssi`=27,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1685289625 WHERE `imei` = '868922055680850' [ RunTime:0.000691s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010530s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1685289624 , 0.021161 , 0.013247 , 0.018421 , -0.006351 , 12.24 , 22.434132 , 79.197449 , 27 , '898604650119C1078510' , '460048590708510' , -0 , 1685289625) [ RunTime:0.001323s ] --------------------------------------------------------------- [ 2023-05-29T02:03:54+08:00 ] 221.178.126.242 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002224s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011948s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2023-05-29T02:03:55+08:00 ] 111.55.140.118 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014515s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001148s ] --------------------------------------------------------------- [ 2023-05-29T02:04:03+08:00 ] 221.178.126.242 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230529&time=020301&v1=-01.367&v2=+00.012&v3=-00.961&v4=-00.041&v5=06.2&t=+17.9&h=59.5&rssi=+229&ccid=4600485905031420000099m9990000000410000001g3760,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.010301s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230529',`time`='020301',`v1`=-1.367,`v2`=0.012,`v3`=-0.961,`v4`=-0.041,`v5`=6.2,`t`=17.9,`h`=59.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000410000001g3760,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685297043 WHERE `imei` = '868922055643643' [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012106s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '230529' , '020301' , -1.367 , 0.012 , -0.961 , -0.041 , 6.2 , 17.9 , 59.5 , 229 , '4600485905031420000099m9990000000410000001g3760,N,00E000=-00.000' , 0 , 0 , 1685297043 , 1685297043) [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2023-05-29T02:04:04+08:00 ] 111.55.140.118 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230529&time=020301&v1=-00.239&v2=+00.001&v3=-00.191&v4=-00.002&v5=06.0&t=+18.1&h=62.3&rssi=+226&ccid=4600485905031430000099m9990000000000000000g2460,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001826s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010538s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001076s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230529',`time`='020301',`v1`=-0.239,`v2`=0.001,`v3`=-0.191,`v4`=-0.002,`v5`=6,`t`=18.1,`h`=62.3,`rssi`=226,`ccid`='4600485905031430000099m9990000000000000000g2460,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685297044 WHERE `imei` = '868922055644013' [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009062s ] [ 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' , '230529' , '020301' , -0.239 , 0.001 , -0.191 , -0.002 , 6 , 18.1 , 62.3 , 226 , '4600485905031430000099m9990000000000000000g2460,N,00E000=-00.000' , 0 , 0 , 1685297044 , 1685297044) [ RunTime:0.000538s ] --------------------------------------------------------------- [ 2023-05-29T09:50:33+08:00 ] 183.162.198.35 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003911s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011819s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001308s ] --------------------------------------------------------------- [ 2023-05-29T09:50:34+08:00 ] 183.162.198.35 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001516s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013787s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001043s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000669s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2023-05-29T09:59:57+08:00 ] 183.162.198.6 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002141s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010910s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000528s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000581s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2023-05-29T09:59:59+08:00 ] 183.162.198.6 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001650s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010224s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000539s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000605s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2023-05-29T10:00:03+08:00 ] 183.162.198.6 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001516s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009662s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000525s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000604s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2023-05-29T10:00:07+08:00 ] 183.162.198.6 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002138s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009325s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000490s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000589s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-05-29T10:01:59+08:00 ] 183.162.198.3 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001468s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008738s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000551s ] --------------------------------------------------------------- [ 2023-05-29T10:02:10+08:00 ] 183.162.198.48 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001724s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009875s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000465s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000564s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2023-05-29T10:02:13+08:00 ] 183.162.198.48 GET /home/device/edit/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001643s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010520s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000923s ] --------------------------------------------------------------- [ 2023-05-29T10:02:19+08:00 ] 183.162.198.17 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010217s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2023-05-29T10:02:30+08:00 ] 183.162.198.46 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001637s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009567s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000486s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000542s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-05-29T10:02:34+08:00 ] 183.162.198.46 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001823s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010483s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.001115s ] --------------------------------------------------------------- [ 2023-05-29T10:03:56+08:00 ] 183.162.198.35 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001549s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011503s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000514s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000632s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000644s ] --------------------------------------------------------------- [ 2023-05-29T10:04:01+08:00 ] 183.162.198.35 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004815s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011580s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000594s ] --------------------------------------------------------------- [ 2023-05-29T10:04:11+08:00 ] 183.162.198.3 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010928s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000578s ] --------------------------------------------------------------- [ 2023-05-29T10:05:26+08:00 ] 183.162.198.46 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001826s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009920s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2023-05-29T10:05:39+08:00 ] 183.162.198.45 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001410s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008790s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2023-05-29T10:05:44+08:00 ] 183.162.198.45 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001653s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012299s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000608s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000659s ] --------------------------------------------------------------- [ 2023-05-29T10:05:48+08:00 ] 183.162.198.45 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001678s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010068s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2023-05-29T10:06:06+08:00 ] 183.162.198.50 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001814s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011377s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2023-05-29T10:10:06+08:00 ] 183.162.198.29 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002225s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010736s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000502s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000564s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2023-05-29T10:10:21+08:00 ] 183.162.198.45 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.004267s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013028s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001353s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000685s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000562s ] --------------------------------------------------------------- [ 2023-05-29T10:10:27+08:00 ] 183.162.198.46 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001857s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010683s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000494s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000553s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000561s ] --------------------------------------------------------------- [ 2023-05-29T10:10:30+08:00 ] 183.162.198.46 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002084s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008449s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000526s ] --------------------------------------------------------------- [ 2023-05-29T10:10:37+08:00 ] 183.162.198.35 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002081s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009360s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000465s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000543s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000537s ] --------------------------------------------------------------- [ 2023-05-29T10:10:40+08:00 ] 183.162.198.35 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001561s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008366s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2023-05-29T10:10:48+08:00 ] 183.162.198.26 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001663s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008989s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000473s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001229s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000601s ] --------------------------------------------------------------- [ 2023-05-29T10:10:53+08:00 ] 183.162.198.26 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002725s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009012s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000510s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000552s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000553s ] --------------------------------------------------------------- [ 2023-05-29T10:10:56+08:00 ] 183.162.198.26 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001572s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012169s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000472s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000539s ] --------------------------------------------------------------- [ 2023-05-29T10:10:58+08:00 ] 183.162.198.26 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002266s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010316s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2023-05-29T10:11:06+08:00 ] 183.162.198.33 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011337s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000545s ] --------------------------------------------------------------- [ 2023-05-29T10:12:54+08:00 ] 183.162.198.18 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011170s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000525s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000600s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-05-29T10:15:40+08:00 ] 183.162.198.6 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003162s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009784s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000519s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000567s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2023-05-29T10:17:13+08:00 ] 183.162.198.44 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001634s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009905s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000546s ] --------------------------------------------------------------- [ 2023-05-29T10:17:17+08:00 ] 183.162.198.44 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001762s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010873s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2023-05-29T10:24:12+08:00 ] 183.162.198.22 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002210s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009639s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2023-05-29T10:24:15+08:00 ] 183.162.198.22 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001769s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010276s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000473s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000550s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-05-29T10:24:25+08:00 ] 183.162.198.23 GET /home/device/communication/id/1/unique_identification_number/15621561103.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002781s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010350s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2023-05-29T10:24:31+08:00 ] 183.162.198.15 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001858s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009775s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000528s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000604s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2023-05-29T10:25:18+08:00 ] 124.129.68.101 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001570s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012948s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2023-05-29T10:25:22+08:00 ] 124.129.68.101 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001551s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011182s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000332s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000830s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000971s ] --------------------------------------------------------------- [ 2023-05-29T10:25:48+08:00 ] 124.129.68.101 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001942s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009947s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000380s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001090s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001019s ] --------------------------------------------------------------- [ 2023-05-29T10:26:04+08:00 ] 124.129.68.101 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001928s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011399s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001176s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001115s ] --------------------------------------------------------------- [ 2023-05-29T10:26:21+08:00 ] 183.162.198.42 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001964s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011909s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000453s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000558s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000551s ] --------------------------------------------------------------- [ 2023-05-29T10:26:24+08:00 ] 183.162.198.42 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001669s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010933s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000493s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000565s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000564s ] --------------------------------------------------------------- [ 2023-05-29T10:26:55+08:00 ] 183.162.198.18 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.011374s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011838s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000487s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000563s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000804s ] --------------------------------------------------------------- [ 2023-05-29T10:26:58+08:00 ] 183.162.198.18 GET /home/device/edit/id/1/unique_identification_number/15621561103.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010795s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000732s ] --------------------------------------------------------------- [ 2023-05-29T10:27:02+08:00 ] 183.162.198.18 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001864s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010603s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000503s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000645s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-05-29T10:27:05+08:00 ] 183.162.198.18 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001828s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010885s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000502s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000557s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2023-05-29T10:27:09+08:00 ] 183.162.198.18 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012717s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010772s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000480s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000558s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2023-05-29T10:31:22+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002336s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009810s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000523s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000657s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2023-05-29T10:31:23+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002033s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010908s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000760s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000552s ] --------------------------------------------------------------- [ 2023-05-29T10:31:24+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001712s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010078s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000473s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000557s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000564s ] --------------------------------------------------------------- [ 2023-05-29T10:31:26+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001959s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012094s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000507s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000564s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2023-05-29T10:31:28+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001735s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011139s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000479s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000569s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2023-05-29T10:31:29+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001630s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010127s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000577s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000568s ] --------------------------------------------------------------- [ 2023-05-29T10:31:30+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010938s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000519s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000544s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000611s ] --------------------------------------------------------------- [ 2023-05-29T10:31:31+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004693s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011657s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000454s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000576s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000607s ] --------------------------------------------------------------- [ 2023-05-29T10:31:32+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001816s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011521s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000518s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000640s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2023-05-29T10:31:33+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001925s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009603s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000489s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000555s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000603s ] --------------------------------------------------------------- [ 2023-05-29T10:31:34+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001742s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008596s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000482s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000576s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000599s ] --------------------------------------------------------------- [ 2023-05-29T10:31:35+08:00 ] 183.162.198.33 GET /home/device/index.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_device` [ RunTime:0.008824s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000521s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000553s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-05-29T10:31:37+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002548s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008818s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000421s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000547s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000595s ] --------------------------------------------------------------- [ 2023-05-29T10:31:38+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002326s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010721s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000493s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000599s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2023-05-29T10:31:39+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003569s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.014278s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000797s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000797s ] --------------------------------------------------------------- [ 2023-05-29T10:31:39+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011467s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000501s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000593s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2023-05-29T10:32:16+08:00 ] 124.129.68.101 GET /admin/show/index.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.002285s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010934s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000341s ] [ 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.001325s ] --------------------------------------------------------------- [ 2023-05-29T10:32:20+08:00 ] 124.129.68.101 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001605s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011015s ] [ 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 10,10 [ RunTime:0.001034s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000973s ] --------------------------------------------------------------- [ 2023-05-29T10:32:27+08:00 ] 124.129.68.101 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010130s ] [ 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 20,10 [ RunTime:0.001024s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001009s ] --------------------------------------------------------------- [ 2023-05-29T10:33:22+08:00 ] 183.162.198.44 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001537s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009738s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000523s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000608s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000841s ] --------------------------------------------------------------- [ 2023-05-29T10:33:23+08:00 ] 183.162.198.44 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002326s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011189s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000505s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000832s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000579s ] --------------------------------------------------------------- [ 2023-05-29T10:33:24+08:00 ] 183.162.198.44 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001820s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.015212s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000552s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000609s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000600s ] --------------------------------------------------------------- [ 2023-05-29T10:33:25+08:00 ] 183.162.198.44 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001647s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011184s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000563s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2023-05-29T10:33:27+08:00 ] 183.162.198.44 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001903s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011391s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000519s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000557s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2023-05-29T10:35:59+08:00 ] 183.162.198.19 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001667s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009306s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000811s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000567s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2023-05-29T10:36:00+08:00 ] 183.162.198.19 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001566s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010688s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000487s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000598s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2023-05-29T10:36:01+08:00 ] 183.162.198.19 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009779s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000503s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000583s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-05-29T10:36:02+08:00 ] 183.162.198.19 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001827s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009287s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000558s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000539s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2023-05-29T10:36:48+08:00 ] 183.162.198.26 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010130s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000500s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000599s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000554s ] --------------------------------------------------------------- [ 2023-05-29T10:36:50+08:00 ] 183.162.198.26 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002133s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011110s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000542s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000607s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2023-05-29T10:36:51+08:00 ] 183.162.198.26 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001758s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009558s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000481s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000550s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2023-05-29T10:36:55+08:00 ] 183.162.198.26 GET /home/device/index.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_device` [ RunTime:0.010649s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000509s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000558s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000606s ] --------------------------------------------------------------- [ 2023-05-29T10:36:57+08:00 ] 183.162.198.26 GET /home/device/group.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_device` [ RunTime:0.011045s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2023-05-29T10:37:20+08:00 ] 183.162.198.29 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001553s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010885s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000863s ] --------------------------------------------------------------- [ 2023-05-29T10:37:23+08:00 ] 183.162.198.29 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002280s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009236s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000590s ] --------------------------------------------------------------- [ 2023-05-29T10:37:25+08:00 ] 183.162.198.29 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002029s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010496s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000497s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000547s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2023-05-29T10:39:20+08:00 ] 183.162.198.28 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002347s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010934s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000511s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000587s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2023-05-29T10:39:21+08:00 ] 183.162.198.28 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002087s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010783s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000509s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000586s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2023-05-29T10:39:23+08:00 ] 183.162.198.28 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001683s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012107s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000496s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000558s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000577s ] --------------------------------------------------------------- [ 2023-05-29T10:40:07+08:00 ] 183.162.198.22 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001684s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010724s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000481s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000594s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000561s ] --------------------------------------------------------------- [ 2023-05-29T10:41:12+08:00 ] 183.162.198.4 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001605s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011031s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000851s ] --------------------------------------------------------------- [ 2023-05-29T10:45:13+08:00 ] 183.162.198.11 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001817s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010972s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000575s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000593s ] --------------------------------------------------------------- [ 2023-05-29T10:45:24+08:00 ] 183.162.198.38 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001363s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009076s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000484s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000728s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2023-05-29T10:45:47+08:00 ] 183.162.198.22 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001599s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010848s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000482s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000576s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000566s ] --------------------------------------------------------------- [ 2023-05-29T10:45:48+08:00 ] 183.162.198.22 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002277s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011543s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000615s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2023-05-29T10:45:53+08:00 ] 183.162.198.22 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001690s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011149s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2023-05-29T10:46:01+08:00 ] 183.162.198.21 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001692s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.014543s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000496s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000597s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000560s ] --------------------------------------------------------------- [ 2023-05-29T10:46:27+08:00 ] 183.162.198.48 GET /home/device/communication/id/8/unique_identification_number/868922055679944.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_device` [ RunTime:0.011126s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000537s ] --------------------------------------------------------------- [ 2023-05-29T10:46:30+08:00 ] 183.162.198.48 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009918s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2023-05-29T11:18:28+08:00 ] 111.55.139.142 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ 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.011174s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2023-05-29T11:18:29+08:00 ] 111.55.139.142 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1685330308&v1=0.029348&v2=0.013769&v3=0.034254&v4=0.001355&v5=12.240000&t=22.455582&h=79.021973&rssi=30&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001542s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010854s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1685330308,`v1`=0.029348,`v2`=0.013769,`v3`=0.034254,`v4`=0.001355,`v5`=12.24,`t`=22.455582,`h`=79.021973,`rssi`=30,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1685330309 WHERE `imei` = '868922055678110' [ RunTime:0.000728s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015437s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1685330308 , 0.029348 , 0.013769 , 0.034254 , 0.001355 , 12.24 , 22.455582 , 79.021973 , 30 , '898604650119C1078513' , '460048590708513' , -0 , 1685330309) [ RunTime:0.001192s ] --------------------------------------------------------------- [ 2023-05-29T12:24:59+08:00 ] 112.224.65.198 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002435s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010822s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'na' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2023-05-29T12:25:00+08:00 ] 112.224.65.198 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001916s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011042s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000600s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2023-05-29T12:25:44+08:00 ] 112.224.65.198 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001800s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010196s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000470s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000523s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2023-05-29T12:25:46+08:00 ] 112.224.65.198 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002430s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013238s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000608s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001003s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2023-05-29T12:25:55+08:00 ] 112.224.65.198 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001976s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010261s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2023-05-29T12:27:30+08:00 ] 112.224.65.198 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001932s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010677s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000513s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000621s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000610s ] --------------------------------------------------------------- [ 2023-05-29T12:27:35+08:00 ] 112.224.65.198 GET /home/device/edit/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001623s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009746s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000550s ] --------------------------------------------------------------- [ 2023-05-29T12:27:45+08:00 ] 112.224.65.198 POST /home/device/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001681s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010073s ] [ sql ] [ SQL ] UPDATE `collect_device` SET `field1`='字段1',`field2`='字段2',`field3`='字段3',`field4`='字段4',`field5`='字段5',`introduce`=' ' WHERE `id` = 11 [ RunTime:0.000832s ] --------------------------------------------------------------- [ 2023-05-29T12:27:46+08:00 ] 112.224.65.198 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001777s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010962s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000519s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000534s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-05-29T12:27:53+08:00 ] 112.224.65.198 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001976s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011288s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2023-05-29T12:29:16+08:00 ] 124.129.68.101 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001747s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010364s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'na' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2023-05-29T12:29:17+08:00 ] 124.129.68.101 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002032s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010819s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000517s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000547s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2023-05-29T12:29:52+08:00 ] 124.129.68.101 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002055s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009805s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000532s ] --------------------------------------------------------------- [ 2023-05-29T12:30:02+08:00 ] 112.224.65.198 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011681s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000745s ] --------------------------------------------------------------- [ 2023-05-29T12:30:10+08:00 ] 112.224.65.198 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.001864s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010775s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.000505s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000652s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2023-05-29T12:30:21+08:00 ] 112.224.65.198 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001529s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009785s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'na' LIMIT 1 [ RunTime:0.001104s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000665s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2023-05-29T12:30:28+08:00 ] 112.224.65.198 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001739s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010870s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2023-05-29T14:03:54+08:00 ] 39.144.5.216 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002386s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011903s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2023-05-29T14:03:55+08:00 ] 221.178.126.232 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ 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.010427s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-05-29T14:04:03+08:00 ] 39.144.5.216 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230529&time=140301&v1=-01.374&v2=+00.031&v3=-00.959&v4=-00.044&v5=06.2&t=+27.4&h=56.8&rssi=+231&ccid=4600485905031420000099m9990000000416000001g3820,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001692s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010178s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230529',`time`='140301',`v1`=-1.374,`v2`=0.031,`v3`=-0.959,`v4`=-0.044,`v5`=6.2,`t`=27.4,`h`=56.8,`rssi`=231,`ccid`='4600485905031420000099m9990000000416000001g3820,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685340243 WHERE `imei` = '868922055643643' [ RunTime:0.000602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012574s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '230529' , '140301' , -1.374 , 0.031 , -0.959 , -0.044 , 6.2 , 27.4 , 56.8 , 231 , '4600485905031420000099m9990000000416000001g3820,N,00E000=-00.000' , 0 , 0 , 1685340243 , 1685340243) [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-05-29T14:04:03+08:00 ] 221.178.126.232 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230529&time=140301&v1=-00.322&v2=+00.001&v3=+00.007&v4=-00.003&v5=06.0&t=+27.0&h=59.5&rssi=+222&ccid=4600485905031430000099m9990000000041000000g3450,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001597s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010695s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230529',`time`='140301',`v1`=-0.322,`v2`=0.001,`v3`=0.007,`v4`=-0.003,`v5`=6,`t`=27,`h`=59.5,`rssi`=222,`ccid`='4600485905031430000099m9990000000041000000g3450,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1685340243 WHERE `imei` = '868922055644013' [ RunTime:0.000519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010622s ] [ 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' , '230529' , '140301' , -0.322 , 0.001 , 0.007 , -0.003 , 6 , 27 , 59.5 , 222 , '4600485905031430000099m9990000000041000000g3450,N,00E000=-00.000' , 0 , 0 , 1685340243 , 1685340243) [ RunTime:0.000514s ] --------------------------------------------------------------- [ 2023-05-29T14:45:23+08:00 ] 221.178.126.1 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011029s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2023-05-29T14:45:24+08:00 ] 221.178.126.1 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1685342723&v1=0.016585&v2=0.014812&v3=0.014147&v4=-0.011769&v5=12.420000&t=23.131262&h=77.412170&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001749s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010203s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1685342723,`v1`=0.016585,`v2`=0.014812,`v3`=0.014147,`v4`=-0.011769,`v5`=12.42,`t`=23.131262,`h`=77.41217,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1685342724 WHERE `imei` = '868922055684548' [ RunTime:0.000608s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011969s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1685342723 , 0.016585 , 0.014812 , 0.014147 , -0.011769 , 12.42 , 23.131262 , 77.41217 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1685342724) [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2023-05-29T15:06:47+08:00 ] 223.81.89.198 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002809s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010539s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000637s ] --------------------------------------------------------------- [ 2023-05-29T15:06:48+08:00 ] 223.81.89.198 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002151s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011889s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2023-05-29T15:44:56+08:00 ] 223.81.89.198 GET /home/map/index.html [ 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.010576s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000849s ] --------------------------------------------------------------- [ 2023-05-29T17:00:22+08:00 ] 111.55.141.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002343s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011925s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2023-05-29T17:00:24+08:00 ] 111.55.141.46 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1685350822&v1=0.018512&v2=0.014186&v3=0.015201&v4=-0.000090&v5=12.240000&t=24.353924&h=79.716248&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002154s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010349s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000832s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1685350822,`v1`=0.018512,`v2`=0.014186,`v3`=0.015201,`v4`=-9.0E-5,`v5`=12.24,`t`=24.353924,`h`=79.716248,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1685350823 WHERE `imei` = '868922055647586' [ RunTime:0.000779s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012557s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1685350822 , 0.018512 , 0.014186 , 0.015201 , -9.0E-5 , 12.24 , 24.353924 , 79.716248 , 27 , '898604650119C1078512' , '460048590708512' , -0 , 1685350824) [ RunTime:0.000697s ] --------------------------------------------------------------- [ 2023-05-29T17:15:59+08:00 ] 124.129.68.101 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002326s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011702s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2023-05-29T17:40:01+08:00 ] 117.132.198.108 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002419s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010615s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2023-05-29T17:40:02+08:00 ] 117.132.198.108 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1685353201&v1=0.027843&v2=0.013039&v3=0.027151&v4=0.015923&v5=12.240000&t=24.085796&h=77.503723&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.186006,35.986716&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002295s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010564s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000837s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1685353201,`v1`=0.027843,`v2`=0.013039,`v3`=0.027151,`v4`=0.015923,`v5`=12.24,`t`=24.085796,`h`=77.503723,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.186006,35.986716',`update_time`=1685353202 WHERE `imei` = '868922056976208' [ RunTime:0.000740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011776s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1685353201 , 0.027843 , 0.013039 , 0.027151 , 0.015923 , 12.24 , 24.085796 , 77.503723 , 26 , '898604650119C1053139' , '460048590503139' , -0 , '120.186006,35.986716' , 1685353202) [ RunTime:0.000827s ] --------------------------------------------------------------- [ 2023-05-29T17:45:21+08:00 ] 39.144.10.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002562s ] 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 `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000768s ] --------------------------------------------------------------- [ 2023-05-29T17:45:22+08:00 ] 39.144.10.87 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1685353521&v1=0.019656&v2=0.014082&v3=0.017157&v4=-0.006953&v5=12.420000&t=24.128696&h=79.395813&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012018s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1685353521,`v1`=0.019656,`v2`=0.014082,`v3`=0.017157,`v4`=-0.006953,`v5`=12.42,`t`=24.128696,`h`=79.395813,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1685353522 WHERE `imei` = '868922055684209' [ RunTime:0.000735s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011689s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1685353521 , 0.019656 , 0.014082 , 0.017157 , -0.006953 , 12.42 , 24.128696 , 79.395813 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1685353522) [ RunTime:0.000612s ] --------------------------------------------------------------- [ 2023-05-29T18:06:43+08:00 ] 39.144.13.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002512s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011724s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000765s ] --------------------------------------------------------------- [ 2023-05-29T18:06:51+08:00 ] 39.144.13.55 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230529&time=180601&v1=-01.259&v2=+00.013&v3=-01.153&v4=-00.614&v5=06.0&t=+25.4&h=77.4&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.123&a2=01.282&a3=00.000&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.010090s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001026s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230529',`time`='180601',`v1`=-1.259,`v2`=0.013,`v3`=-1.153,`v4`=-0.614,`v5`=6,`t`=25.4,`h`=77.4,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.123,`a2`=1.282,`update_time`=1685354811 WHERE `imei` = '868922055684076' [ RunTime:0.000553s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010524s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '230529' , '180601' , -1.259 , 0.013 , -1.153 , -0.614 , 6 , 25.4 , 77.4 , 227 , '460044618415249' , -0 , 0.123 , 1.282 , 1685354811 , 1685354811) [ RunTime:0.000776s ] --------------------------------------------------------------- [ 2023-05-29T18:10:19+08:00 ] 39.144.1.224 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002996s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012727s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000937s ] --------------------------------------------------------------- [ 2023-05-29T18:10:21+08:00 ] 39.144.1.224 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1685355019&v1=0.018572&v2=0.015438&v3=0.016224&v4=-0.004726&v5=12.420000&t=23.667517&h=82.294983&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001851s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009638s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1685355019,`v1`=0.018572,`v2`=0.015438,`v3`=0.016224,`v4`=-0.004726,`v5`=12.42,`t`=23.667517,`h`=82.294983,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1685355020 WHERE `imei` = '868922055683920' [ RunTime:0.000576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010164s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1685355019 , 0.018572 , 0.015438 , 0.016224 , -0.004726 , 12.42 , 23.667517 , 82.294983 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1685355021) [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2023-05-29T20:56:17+08:00 ] 39.144.5.85 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002810s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012318s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000751s ] --------------------------------------------------------------- [ 2023-05-29T20:56:18+08:00 ] 39.144.5.85 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1685364977&v1=0.031756&v2=0.015020&v3=0.028926&v4=0.008278&v5=12.600000&t=22.981112&h=81.036133&rssi=19&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.186560,35.985940&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002015s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010632s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1685364977,`v1`=0.031756,`v2`=0.01502,`v3`=0.028926,`v4`=0.008278,`v5`=12.6,`t`=22.981112,`h`=81.036133,`rssi`=19,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.186560,35.985940',`update_time`=1685364978 WHERE `imei` = '868922055683912' [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012367s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1685364977 , 0.031756 , 0.01502 , 0.028926 , 0.008278 , 12.6 , 22.981112 , 81.036133 , 19 , '898604650119C1053138' , '460048590503138' , -0 , '120.186560,35.985940' , 1685364978) [ RunTime:0.000799s ] --------------------------------------------------------------- [ 2023-05-29T21:02:03+08:00 ] 39.144.8.1 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002173s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011486s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2023-05-29T21:02:04+08:00 ] 39.144.8.1 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1685365323&v1=0.019114&v2=0.014812&v3=0.016284&v4=-0.017247&v5=12.420000&t=22.959661&h=81.867737&rssi=17&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.185207,35.989810&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001678s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010089s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1685365323,`v1`=0.019114,`v2`=0.014812,`v3`=0.016284,`v4`=-0.017247,`v5`=12.42,`t`=22.959661,`h`=81.867737,`rssi`=17,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.185207,35.989810',`update_time`=1685365324 WHERE `imei` = '868922055683771' [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009610s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1685365323 , 0.019114 , 0.014812 , 0.016284 , -0.017247 , 12.42 , 22.959661 , 81.867737 , 17 , '898604650119C1053136' , '460048590503136' , -0 , '120.185207,35.989810' , 1685365324) [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2023-05-29T23:40:24+08:00 ] 111.55.138.27 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002074s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011770s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000748s ] --------------------------------------------------------------- [ 2023-05-29T23:40:25+08:00 ] 111.55.138.27 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1685374824&v1=0.006953&v2=0.014707&v3=0.005087&v4=-0.015803&v5=12.420000&t=22.798784&h=80.372375&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001660s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010408s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000851s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1685374824,`v1`=0.006953,`v2`=0.014707,`v3`=0.005087,`v4`=-0.015803,`v5`=12.42,`t`=22.798784,`h`=80.372375,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1685374825 WHERE `imei` = '868922055644021' [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011498s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1685374824 , 0.006953 , 0.014707 , 0.005087 , -0.015803 , 12.42 , 22.798784 , 80.372375 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1685374825) [ RunTime:0.000617s ]