--------------------------------------------------------------- [ 2023-04-28T02:03:55+08:00 ] 223.104.255.66 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002873s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010617s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-04-28T02:03:55+08:00 ] 117.132.194.14 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001503s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009523s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000644s ] --------------------------------------------------------------- [ 2023-04-28T02:04:03+08:00 ] 223.104.255.66 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230428&time=020301&v1=-01.334&v2=+00.016&v3=-00.971&v4=-00.029&v5=05.7&t=+13.1&h=60.9&rssi=+228&ccid=4600485905031420000099m9990000000366000001g3430,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002277s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009619s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230428',`time`='020301',`v1`=-1.334,`v2`=0.016,`v3`=-0.971,`v4`=-0.029,`v5`=5.7,`t`=13.1,`h`=60.9,`rssi`=228,`ccid`='4600485905031420000099m9990000000366000001g3430,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682618643 WHERE `imei` = '868922055643643' [ RunTime:0.000573s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010668s ] [ 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' , '230428' , '020301' , -1.334 , 0.016 , -0.971 , -0.029 , 5.7 , 13.1 , 60.9 , 228 , '4600485905031420000099m9990000000366000001g3430,N,00E000=-00.000' , 0 , 0 , 1682618643 , 1682618643) [ RunTime:0.000610s ] --------------------------------------------------------------- [ 2023-04-28T02:04:04+08:00 ] 117.132.194.14 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230428&time=020301&v1=-00.222&v2=+00.001&v3=+00.003&v4=-00.012&v5=05.9&t=+13.4&h=63.6&rssi=+224&ccid=4600485905031430000099m9990000000033000000g2370,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002118s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009685s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000639s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230428',`time`='020301',`v1`=-0.222,`v2`=0.001,`v3`=0.003,`v4`=-0.012,`v5`=5.9,`t`=13.4,`h`=63.6,`rssi`=224,`ccid`='4600485905031430000099m9990000000033000000g2370,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682618644 WHERE `imei` = '868922055644013' [ RunTime:0.000519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010759s ] [ 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' , '230428' , '020301' , -0.222 , 0.001 , 0.003 , -0.012 , 5.9 , 13.4 , 63.6 , 224 , '4600485905031430000099m9990000000033000000g2370,N,00E000=-00.000' , 0 , 0 , 1682618644 , 1682618644) [ RunTime:0.000530s ] --------------------------------------------------------------- [ 2023-04-28T09:17:24+08:00 ] 183.162.198.9 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003293s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011756s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001142s ] --------------------------------------------------------------- [ 2023-04-28T09:17:25+08:00 ] 183.162.198.9 GET /home/device/index.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.011842s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001138s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000568s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2023-04-28T09:19:09+08:00 ] 183.162.198.12 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002245s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010318s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000585s ] --------------------------------------------------------------- [ 2023-04-28T09:19:17+08:00 ] 183.162.198.13 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001737s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010206s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000468s ] [ 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.000583s ] --------------------------------------------------------------- [ 2023-04-28T09:19:20+08:00 ] 183.162.198.13 GET /home/device/edit/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010010s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000520s ] --------------------------------------------------------------- [ 2023-04-28T09:19:31+08:00 ] 183.162.198.48 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001349s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010117s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001231s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000584s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2023-04-28T09:19:37+08:00 ] 183.162.198.47 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001830s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010286s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000529s ] --------------------------------------------------------------- [ 2023-04-28T09:20:03+08:00 ] 183.162.198.6 GET /home/device/group.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_device` [ RunTime:0.009031s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2023-04-28T09:20:08+08:00 ] 183.162.198.6 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001913s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010191s ] [ 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.000597s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000661s ] --------------------------------------------------------------- [ 2023-04-28T09:21:21+08:00 ] 183.162.198.44 GET /home/device/index.html?keyword=868922055679944 [ sql ] [ DB ] CONNECT:[ UseTime:0.002255s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009953s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `unique_identification_number` LIKE '%868922055679944%' AND `username` = 'user' LIMIT 1 [ RunTime:0.000545s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `unique_identification_number` LIKE '%868922055679944%' AND `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.000577s ] --------------------------------------------------------------- [ 2023-04-28T09:21:23+08:00 ] 183.162.198.44 GET /home/device/edit/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012152s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000566s ] --------------------------------------------------------------- [ 2023-04-28T09:21:28+08:00 ] 183.162.198.44 GET /home/device/index.html?keyword=868922055679944 [ sql ] [ DB ] CONNECT:[ UseTime:0.001784s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011247s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `unique_identification_number` LIKE '%868922055679944%' AND `username` = 'user' LIMIT 1 [ RunTime:0.000528s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `unique_identification_number` LIKE '%868922055679944%' AND `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.000532s ] --------------------------------------------------------------- [ 2023-04-28T09:21:29+08:00 ] 183.162.198.44 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002268s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009846s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000553s ] --------------------------------------------------------------- [ 2023-04-28T09:21:37+08:00 ] 183.162.198.45 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010827s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010662s ] [ 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.000617s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000546s ] --------------------------------------------------------------- [ 2023-04-28T09:32:20+08:00 ] 183.162.198.49 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002182s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012614s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-04-28T09:32:30+08:00 ] 183.162.198.50 GET /home/device/index.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.010396s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000456s ] [ 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.000532s ] --------------------------------------------------------------- [ 2023-04-28T09:32:38+08:00 ] 183.162.198.11 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002302s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009574s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000560s ] --------------------------------------------------------------- [ 2023-04-28T09:32:48+08:00 ] 183.162.198.38 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001601s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010941s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000562s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000616s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2023-04-28T09:32:52+08:00 ] 183.162.198.38 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002217s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011754s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000538s ] --------------------------------------------------------------- [ 2023-04-28T09:33:40+08:00 ] 183.162.198.38 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001887s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009704s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000461s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000536s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001006s ] --------------------------------------------------------------- [ 2023-04-28T09:33:59+08:00 ] 183.162.198.37 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001991s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009562s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000533s ] --------------------------------------------------------------- [ 2023-04-28T09:34:50+08:00 ] 124.129.96.215 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001753s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008793s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2023-04-28T09:34:51+08:00 ] 124.129.96.215 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009260s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000512s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000580s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000582s ] --------------------------------------------------------------- [ 2023-04-28T09:34:55+08:00 ] 124.129.96.215 GET /home/device/communication/id/7/unique_identification_number/867032052356297.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.009643s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2023-04-28T09:35:22+08:00 ] 124.129.96.215 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002377s ] 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.000513s ] [ 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.001447s ] --------------------------------------------------------------- [ 2023-04-28T09:35:33+08:00 ] 124.129.96.215 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009848s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000527s ] --------------------------------------------------------------- [ 2023-04-28T09:36:46+08:00 ] 183.162.198.10 GET /home/device/group.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_device` [ RunTime:0.010657s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000577s ] --------------------------------------------------------------- [ 2023-04-28T09:43:11+08:00 ] 183.162.198.24 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002391s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012064s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000595s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000610s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2023-04-28T09:43:23+08:00 ] 183.162.198.25 GET /home/device/edit/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001711s ] 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 * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000562s ] --------------------------------------------------------------- [ 2023-04-28T09:43:25+08:00 ] 183.162.198.25 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009873s ] [ 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.000583s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2023-04-28T09:43:27+08:00 ] 183.162.198.25 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001501s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010604s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000532s ] --------------------------------------------------------------- [ 2023-04-28T09:43:45+08:00 ] 183.162.198.33 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001831s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010743s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000540s ] --------------------------------------------------------------- [ 2023-04-28T09:44:37+08:00 ] 183.162.198.50 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009874s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000572s ] --------------------------------------------------------------- [ 2023-04-28T09:44:39+08:00 ] 183.162.198.50 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002011s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009434s ] [ 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.000574s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000555s ] --------------------------------------------------------------- [ 2023-04-28T09:44:45+08:00 ] 183.162.198.4 GET /home/device/edit/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002569s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009663s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2023-04-28T09:44:49+08:00 ] 183.162.198.4 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002593s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010004s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000516s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000663s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-04-28T09:44:51+08:00 ] 183.162.198.4 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001877s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010498s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000525s ] --------------------------------------------------------------- [ 2023-04-28T09:45:12+08:00 ] 183.162.198.21 GET /home/device/group.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.009670s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2023-04-28T09:45:25+08:00 ] 183.162.198.20 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001898s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010498s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2023-04-28T09:45:27+08:00 ] 183.162.198.20 GET /home/device/group.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.009556s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-04-28T09:48:32+08:00 ] 183.162.198.45 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002659s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010569s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2023-04-28T09:49:46+08:00 ] 183.162.198.21 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001696s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011010s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000508s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000562s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2023-04-28T09:49:50+08:00 ] 183.162.198.21 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001700s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009990s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000544s ] --------------------------------------------------------------- [ 2023-04-28T09:50:08+08:00 ] 183.162.198.20 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009796s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2023-04-28T09:54:15+08:00 ] 124.129.96.215 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.001624s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012676s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001155s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000679s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2023-04-28T09:54:35+08:00 ] 124.129.96.215 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.014440s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2023-04-28T09:54:37+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001511s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009949s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000388s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000851s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000971s ] --------------------------------------------------------------- [ 2023-04-28T09:54:41+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002940s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010950s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000400s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001128s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001016s ] --------------------------------------------------------------- [ 2023-04-28T09:54:48+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001941s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011166s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000513s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000717s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001074s ] --------------------------------------------------------------- [ 2023-04-28T09:54:54+08:00 ] 183.162.198.39 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002020s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008708s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000499s ] [ 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.000588s ] --------------------------------------------------------------- [ 2023-04-28T09:54:59+08:00 ] 183.162.198.39 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002209s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010624s ] [ 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.000623s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-04-28T09:55:29+08:00 ] 183.162.198.40 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001706s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010512s ] [ 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.000570s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-04-28T09:55:30+08:00 ] 183.162.198.40 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001994s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009010s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000732s ] [ 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.000570s ] --------------------------------------------------------------- [ 2023-04-28T09:55:31+08:00 ] 183.162.198.40 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.012407s ] [ 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.000691s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000623s ] --------------------------------------------------------------- [ 2023-04-28T09:55:32+08:00 ] 183.162.198.40 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001930s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009449s ] [ 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.000555s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2023-04-28T09:55:32+08:00 ] 183.162.198.40 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002169s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010561s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000529s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000580s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2023-04-28T09:55:33+08:00 ] 183.162.198.40 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001996s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009770s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000477s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000565s ] --------------------------------------------------------------- [ 2023-04-28T09:55:35+08:00 ] 183.162.198.40 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001763s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010246s ] [ 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.000564s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2023-04-28T09:55:46+08:00 ] 183.162.198.23 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.002102s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012363s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000595s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000735s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000529s ] --------------------------------------------------------------- [ 2023-04-28T09:55:53+08:00 ] 183.162.198.25 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001876s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011893s ] [ 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.000572s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2023-04-28T09:55:54+08:00 ] 183.162.198.27 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002275s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010966s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000716s ] --------------------------------------------------------------- [ 2023-04-28T09:56:07+08:00 ] 183.162.198.31 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002276s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012215s ] [ 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.000596s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-04-28T09:56:20+08:00 ] 183.162.198.14 GET / [ sql ] [ DB ] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011346s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000561s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000748s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2023-04-28T09:56:23+08:00 ] 183.162.198.14 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001993s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010204s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000568s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000561s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2023-04-28T09:56:29+08:00 ] 183.162.198.50 GET /home/device/edit/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001546s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010983s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2023-04-28T09:56:32+08:00 ] 183.162.198.50 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002497s ] 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 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.000573s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000593s ] --------------------------------------------------------------- [ 2023-04-28T09:56:34+08:00 ] 183.162.198.50 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002349s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010294s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000576s ] --------------------------------------------------------------- [ 2023-04-28T09:56:40+08:00 ] 183.162.198.46 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002049s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010050s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000554s ] --------------------------------------------------------------- [ 2023-04-28T09:56:42+08:00 ] 183.162.198.46 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001665s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010751s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000585s ] --------------------------------------------------------------- [ 2023-04-28T09:56:43+08:00 ] 183.162.198.46 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002264s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009567s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000477s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000540s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000866s ] --------------------------------------------------------------- [ 2023-04-28T09:59:03+08:00 ] 124.129.96.215 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001934s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010197s ] [ 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.000807s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-04-28T10:01:29+08:00 ] 124.129.96.215 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001622s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010352s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000600s ] --------------------------------------------------------------- [ 2023-04-28T10:01:37+08:00 ] 183.162.198.16 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001994s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009170s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000551s ] --------------------------------------------------------------- [ 2023-04-28T10:02:56+08:00 ] 183.162.198.42 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002110s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009829s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2023-04-28T10:05:17+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001505s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010655s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000536s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000751s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001021s ] --------------------------------------------------------------- [ 2023-04-28T10:05:19+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001962s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010068s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000472s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000716s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001005s ] --------------------------------------------------------------- [ 2023-04-28T10:05:41+08:00 ] 124.129.96.215 GET /admin/show/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_show` [ RunTime:0.009478s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000388s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000863s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000998s ] --------------------------------------------------------------- [ 2023-04-28T10:06:00+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010611s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000447s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000659s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000968s ] --------------------------------------------------------------- [ 2023-04-28T10:06:02+08:00 ] 124.129.96.215 GET /admin/show/edit/id/58.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009875s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010675s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000476s ] --------------------------------------------------------------- [ 2023-04-28T10:06:06+08:00 ] 124.129.96.215 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002506s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010783s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=2,`gps`='120.184668,35.984770',`username`='admin',`introduce`=' ',`update_time`=1682647566 WHERE `id` = 58 [ RunTime:0.000794s ] --------------------------------------------------------------- [ 2023-04-28T10:06:07+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001971s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009530s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000393s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000853s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001005s ] --------------------------------------------------------------- [ 2023-04-28T10:06:56+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001878s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010173s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000484s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000954s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000988s ] --------------------------------------------------------------- [ 2023-04-28T10:14:52+08:00 ] 183.162.198.39 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004305s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.018341s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000953s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001006s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.001197s ] --------------------------------------------------------------- [ 2023-04-28T10:15:09+08:00 ] 183.162.198.38 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002040s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009798s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2023-04-28T10:15:55+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002020s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011512s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000527s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000956s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001149s ] --------------------------------------------------------------- [ 2023-04-28T10:15:56+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002011s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011540s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000511s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000799s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001163s ] --------------------------------------------------------------- [ 2023-04-28T10:15:57+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001582s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011600s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000462s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000656s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000973s ] --------------------------------------------------------------- [ 2023-04-28T10:15:58+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002308s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009782s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.001492s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000660s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000993s ] --------------------------------------------------------------- [ 2023-04-28T10:16:00+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002101s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011156s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000459s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000690s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000997s ] --------------------------------------------------------------- [ 2023-04-28T10:16:03+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002233s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010326s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000455s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000658s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000995s ] --------------------------------------------------------------- [ 2023-04-28T10:16:04+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002625s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009458s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000549s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000694s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000984s ] --------------------------------------------------------------- [ 2023-04-28T10:16:07+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001895s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009430s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000402s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000650s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000965s ] --------------------------------------------------------------- [ 2023-04-28T10:16:17+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009704s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.001007s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000712s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000967s ] --------------------------------------------------------------- [ 2023-04-28T10:16:26+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002118s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009775s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000456s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000659s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001006s ] --------------------------------------------------------------- [ 2023-04-28T10:16:29+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002451s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010316s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000490s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000732s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001028s ] --------------------------------------------------------------- [ 2023-04-28T10:16:30+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001719s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009270s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000481s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000716s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000989s ] --------------------------------------------------------------- [ 2023-04-28T10:17:00+08:00 ] 183.162.198.47 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001698s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009237s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000527s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001028s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000617s ] --------------------------------------------------------------- [ 2023-04-28T10:17:04+08:00 ] 183.162.198.47 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001891s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009800s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000552s ] --------------------------------------------------------------- [ 2023-04-28T10:17:19+08:00 ] 183.162.198.29 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001343s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010151s ] [ 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.000594s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000589s ] --------------------------------------------------------------- [ 2023-04-28T10:17:23+08:00 ] 183.162.198.29 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001790s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009510s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000532s ] --------------------------------------------------------------- [ 2023-04-28T10:17:53+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002236s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012831s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000507s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000739s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000993s ] --------------------------------------------------------------- [ 2023-04-28T10:17:58+08:00 ] 183.162.198.30 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002259s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009704s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000474s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000579s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000591s ] --------------------------------------------------------------- [ 2023-04-28T10:18:03+08:00 ] 183.162.198.30 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002510s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010897s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-04-28T10:18:14+08:00 ] 183.162.198.44 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001975s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011144s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000613s ] --------------------------------------------------------------- [ 2023-04-28T10:18:45+08:00 ] 183.162.198.9 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002152s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010994s ] [ 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.000898s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000612s ] --------------------------------------------------------------- [ 2023-04-28T10:23:20+08:00 ] 183.162.198.10 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001617s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010269s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000573s ] --------------------------------------------------------------- [ 2023-04-28T10:23:27+08:00 ] 183.162.198.9 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001838s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010273s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000492s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000621s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2023-04-28T10:23:31+08:00 ] 183.162.198.9 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.010581s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000566s ] --------------------------------------------------------------- [ 2023-04-28T10:25:36+08:00 ] 183.162.198.46 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001658s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009771s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000513s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000588s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000613s ] --------------------------------------------------------------- [ 2023-04-28T10:25:39+08:00 ] 183.162.198.46 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004934s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011526s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2023-04-28T10:25:41+08:00 ] 183.162.198.46 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001629s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010016s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000491s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000587s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000610s ] --------------------------------------------------------------- [ 2023-04-28T10:25:43+08:00 ] 183.162.198.46 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008972s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000478s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000780s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-04-28T10:25:44+08:00 ] 183.162.198.46 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001821s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012479s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000464s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000540s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000532s ] --------------------------------------------------------------- [ 2023-04-28T10:26:14+08:00 ] 183.162.198.47 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001685s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008983s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000537s ] --------------------------------------------------------------- [ 2023-04-28T10:26:17+08:00 ] 183.162.198.47 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.010635s ] [ 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.000551s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000589s ] --------------------------------------------------------------- [ 2023-04-28T10:26:19+08:00 ] 183.162.198.47 GET /home/device/communication/id/8/unique_identification_number/868922055679944.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_device` [ RunTime:0.009593s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000527s ] --------------------------------------------------------------- [ 2023-04-28T10:26:25+08:00 ] 183.162.198.28 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002402s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009787s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2023-04-28T10:26:57+08:00 ] 183.162.198.13 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002067s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009175s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000495s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000573s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2023-04-28T10:27:01+08:00 ] 183.162.198.13 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002263s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010907s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2023-04-28T10:27:04+08:00 ] 183.162.198.13 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001594s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009839s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-04-28T10:27:31+08:00 ] 183.162.198.44 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008848s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000578s ] --------------------------------------------------------------- [ 2023-04-28T10:37:29+08:00 ] 183.162.198.49 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002304s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013661s ] [ 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.000585s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2023-04-28T10:37:37+08:00 ] 183.162.198.50 GET /home/device/communication/id/7/unique_identification_number/867032052356297.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001642s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010817s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000531s ] --------------------------------------------------------------- [ 2023-04-28T10:37:52+08:00 ] 183.162.198.11 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001975s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012933s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000598s ] --------------------------------------------------------------- [ 2023-04-28T10:39:53+08:00 ] 183.162.198.10 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002880s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009634s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000475s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000545s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000552s ] --------------------------------------------------------------- [ 2023-04-28T10:41:23+08:00 ] 39.144.1.226 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001460s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011017s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2023-04-28T10:41:24+08:00 ] 39.144.1.226 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682649683&v1=0.029288&v2=0.014499&v3=0.027421&v4=0.001355&v5=12.420000&t=18.433670&h=66.601318&rssi=28&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002005s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009010s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000665s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682649683,`v1`=0.029288,`v2`=0.014499,`v3`=0.027421,`v4`=0.001355,`v5`=12.42,`t`=18.43367,`h`=66.601318,`rssi`=28,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1682649684 WHERE `imei` = '868922055678110' [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013294s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1682649683 , 0.029288 , 0.014499 , 0.027421 , 0.001355 , 12.42 , 18.43367 , 66.601318 , 28 , '898604650119C1078513' , '460048590708513' , -0 , 1682649684) [ RunTime:0.001392s ] --------------------------------------------------------------- [ 2023-04-28T10:44:30+08:00 ] 221.178.124.108 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002242s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010793s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000756s ] --------------------------------------------------------------- [ 2023-04-28T10:44:31+08:00 ] 221.178.124.108 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682649870&v1=0.029227&v2=0.014707&v3=0.027361&v4=0.001355&v5=12.240000&t=19.903008&h=63.587708&rssi=28&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002354s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012681s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000778s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682649870,`v1`=0.029227,`v2`=0.014707,`v3`=0.027361,`v4`=0.001355,`v5`=12.24,`t`=19.903008,`h`=63.587708,`rssi`=28,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1682649871 WHERE `imei` = '868922055678110' [ RunTime:0.000795s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011740s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1682649870 , 0.029227 , 0.014707 , 0.027361 , 0.001355 , 12.24 , 19.903008 , 63.587708 , 28 , '898604650119C1078513' , '460048590708513' , -0 , 1682649871) [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2023-04-28T10:46:36+08:00 ] 183.162.198.10 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000899s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000623s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2023-04-28T10:46:38+08:00 ] 183.162.198.10 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.010340s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000586s ] --------------------------------------------------------------- [ 2023-04-28T10:46:51+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=8110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001786s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009609s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%8110%' LIMIT 1 [ RunTime:0.000467s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%8110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000697s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000974s ] --------------------------------------------------------------- [ 2023-04-28T10:46:52+08:00 ] 183.162.198.9 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010241s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009994s ] [ 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.000547s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000579s ] --------------------------------------------------------------- [ 2023-04-28T10:46:54+08:00 ] 124.129.96.215 GET /admin/show/edit/id/58.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001843s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011290s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010197s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000459s ] --------------------------------------------------------------- [ 2023-04-28T10:46:59+08:00 ] 124.129.96.215 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001661s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012113s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=1440,`gps`='120.184668,35.984770',`username`='admin',`introduce`=' ',`update_time`=1682650019 WHERE `id` = 58 [ RunTime:0.000660s ] --------------------------------------------------------------- [ 2023-04-28T10:47:00+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001636s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010392s ] [ 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 0,10 [ RunTime:0.000835s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001526s ] --------------------------------------------------------------- [ 2023-04-28T10:47:30+08:00 ] 218.204.253.207 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011200s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000832s ] --------------------------------------------------------------- [ 2023-04-28T10:47:31+08:00 ] 218.204.253.207 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682650050&v1=0.029288&v2=0.014812&v3=0.027331&v4=0.001475&v5=12.240000&t=20.503613&h=62.367004&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010664s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000746s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682650050,`v1`=0.029288,`v2`=0.014812,`v3`=0.027331,`v4`=0.001475,`v5`=12.24,`t`=20.503613,`h`=62.367004,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1682650051 WHERE `imei` = '868922055678110' [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010558s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1682650050 , 0.029288 , 0.014812 , 0.027331 , 0.001475 , 12.24 , 20.503613 , 62.367004 , 29 , '898604650119C1078513' , '460048590708513' , -0 , 1682650051) [ RunTime:0.000540s ] --------------------------------------------------------------- [ 2023-04-28T10:47:35+08:00 ] 183.162.198.10 GET /home/device/communication/id/9/unique_identification_number/868922055684019.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001627s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010032s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000600s ] --------------------------------------------------------------- [ 2023-04-28T10:47:39+08:00 ] 183.162.198.10 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002773s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010572s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000549s ] --------------------------------------------------------------- [ 2023-04-28T10:56:33+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002174s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010425s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000398s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000876s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-04-28T10:56:44+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001697s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010983s ] [ 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.001082s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001063s ] --------------------------------------------------------------- [ 2023-04-28T10:57:03+08:00 ] 124.129.96.215 GET /admin/show/read/id/32/imei/868922055643643.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001853s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010282s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010431s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000689s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.012709s ] --------------------------------------------------------------- [ 2023-04-28T10:57:13+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002130s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009274s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000344s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001089s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001039s ] --------------------------------------------------------------- [ 2023-04-28T11:15:54+08:00 ] 183.162.198.33 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002312s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013712s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000628s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2023-04-28T11:19:03+08:00 ] 183.162.198.14 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010924s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000538s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000560s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2023-04-28T11:19:46+08:00 ] 183.162.198.13 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001966s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009761s ] [ 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.000900s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000587s ] --------------------------------------------------------------- [ 2023-04-28T11:19:46+08:00 ] 183.162.198.13 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001788s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010155s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000591s ] --------------------------------------------------------------- [ 2023-04-28T11:22:08+08:00 ] 183.162.198.37 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001327s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008843s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000471s ] [ 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.000565s ] --------------------------------------------------------------- [ 2023-04-28T11:22:13+08:00 ] 183.162.198.37 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001929s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010392s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000569s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000625s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000611s ] --------------------------------------------------------------- [ 2023-04-28T11:22:19+08:00 ] 183.162.198.41 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001798s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010856s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2023-04-28T11:22:20+08:00 ] 183.162.198.41 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001677s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010322s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000623s ] --------------------------------------------------------------- [ 2023-04-28T11:22:40+08:00 ] 183.162.198.18 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001612s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009902s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2023-04-28T11:24:53+08:00 ] 183.162.198.44 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001508s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009622s ] [ 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.000608s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2023-04-28T11:24:57+08:00 ] 183.162.198.44 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.007744s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.017405s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000770s ] --------------------------------------------------------------- [ 2023-04-28T11:24:58+08:00 ] 183.162.198.44 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001682s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008766s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000474s ] [ 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.000612s ] --------------------------------------------------------------- [ 2023-04-28T11:25:02+08:00 ] 183.162.198.44 GET /home/device/communication/id/8/unique_identification_number/868922055679944.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001854s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010961s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2023-04-28T11:25:39+08:00 ] 183.162.198.45 GET /home/device/group.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002251s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010480s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' [ RunTime:0.000574s ] --------------------------------------------------------------- [ 2023-04-28T12:43:58+08:00 ] 218.204.253.107 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009614s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-04-28T12:43:59+08:00 ] 218.204.253.107 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1682657038&v1=0.016344&v2=0.014499&v3=0.014177&v4=-0.011829&v5=12.420000&t=17.747263&h=71.713013&rssi=30&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001672s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010808s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.001018s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1682657038,`v1`=0.016344,`v2`=0.014499,`v3`=0.014177,`v4`=-0.011829,`v5`=12.42,`t`=17.747263,`h`=71.713013,`rssi`=30,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1682657039 WHERE `imei` = '868922055684548' [ RunTime:0.001570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013953s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1682657038 , 0.016344 , 0.014499 , 0.014177 , -0.011829 , 12.42 , 17.747263 , 71.713013 , 30 , '898604650119C1053137' , '460048590503137' , -0 , 1682657039) [ RunTime:0.000992s ] --------------------------------------------------------------- [ 2023-04-28T13:37:51+08:00 ] 111.55.140.177 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.003060s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011362s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000912s ] --------------------------------------------------------------- [ 2023-04-28T13:37:52+08:00 ] 111.55.140.177 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1682660271&v1=0.016344&v2=0.015125&v3=0.014418&v4=-0.011769&v5=12.420000&t=19.345303&h=71.415466&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001609s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1682660271,`v1`=0.016344,`v2`=0.015125,`v3`=0.014418,`v4`=-0.011769,`v5`=12.42,`t`=19.345303,`h`=71.415466,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1682660272 WHERE `imei` = '868922055684548' [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013020s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1682660271 , 0.016344 , 0.015125 , 0.014418 , -0.011769 , 12.42 , 19.345303 , 71.415466 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1682660272) [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2023-04-28T14:03:54+08:00 ] 39.144.10.37 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002501s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009395s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-04-28T14:03:55+08:00 ] 117.132.196.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001519s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009516s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-04-28T14:04:03+08:00 ] 39.144.10.37 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230428&time=140301&v1=-01.332&v2=+00.040&v3=-00.985&v4=-00.029&v5=05.9&t=+25.9&h=58.2&rssi=+230&ccid=4600485905031420000099m9990000000346000001g3400,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001954s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011673s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000770s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230428',`time`='140301',`v1`=-1.332,`v2`=0.04,`v3`=-0.985,`v4`=-0.029,`v5`=5.9,`t`=25.9,`h`=58.2,`rssi`=230,`ccid`='4600485905031420000099m9990000000346000001g3400,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682661843 WHERE `imei` = '868922055643643' [ RunTime:0.000702s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012302s ] [ 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' , '230428' , '140301' , -1.332 , 0.04 , -0.985 , -0.029 , 5.9 , 25.9 , 58.2 , 230 , '4600485905031420000099m9990000000346000001g3400,N,00E000=-00.000' , 0 , 0 , 1682661843 , 1682661843) [ RunTime:0.000793s ] --------------------------------------------------------------- [ 2023-04-28T14:04:03+08:00 ] 117.132.196.75 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230428&time=140301&v1=-00.222&v2=+00.001&v3=+00.019&v4=-00.011&v5=06.0&t=+24.8&h=61.6&rssi=+227&ccid=4600485905031430000099m9990000000040000000g2400,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001594s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009964s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230428',`time`='140301',`v1`=-0.222,`v2`=0.001,`v3`=0.019,`v4`=-0.011,`v5`=6,`t`=24.8,`h`=61.6,`rssi`=227,`ccid`='4600485905031430000099m9990000000040000000g2400,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682661843 WHERE `imei` = '868922055644013' [ RunTime:0.000492s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011461s ] [ 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' , '230428' , '140301' , -0.222 , 0.001 , 0.019 , -0.011 , 6 , 24.8 , 61.6 , 227 , '4600485905031430000099m9990000000040000000g2400,N,00E000=-00.000' , 0 , 0 , 1682661843 , 1682661843) [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2023-04-28T14:13:50+08:00 ] 218.204.253.157 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002542s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013048s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000772s ] --------------------------------------------------------------- [ 2023-04-28T14:13:58+08:00 ] 218.204.253.157 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230428&time=141301&v1=-00.840&v2=+00.022&v3=-00.732&v4=-00.254&v5=06.0&t=+24.8&h=79.8&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.135&a2=00.935&a3=00.000&end=$ [ 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.009583s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000980s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230428',`time`='141301',`v1`=-0.84,`v2`=0.022,`v3`=-0.732,`v4`=-0.254,`v5`=6,`t`=24.8,`h`=79.8,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.135,`a2`=0.935,`update_time`=1682662438 WHERE `imei` = '868922055684076' [ RunTime:0.000590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011321s ] [ 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' , '230428' , '141301' , -0.84 , 0.022 , -0.732 , -0.254 , 6 , 24.8 , 79.8 , 227 , '460044618415249' , -0 , 0.135 , 0.935 , 1682662438 , 1682662438) [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2023-04-28T16:32:24+08:00 ] 39.144.15.162 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002364s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010461s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000733s ] --------------------------------------------------------------- [ 2023-04-28T16:32:26+08:00 ] 39.144.15.162 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682670744&v1=0.017910&v2=0.015438&v3=0.014990&v4=0.000030&v5=12.420000&t=17.972490&h=79.884094&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001752s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010848s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000770s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682670744,`v1`=0.01791,`v2`=0.015438,`v3`=0.01499,`v4`=3.0E-5,`v5`=12.42,`t`=17.97249,`h`=79.884094,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682670746 WHERE `imei` = '868922055647586' [ RunTime:0.000680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010980s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682670744 , 0.01791 , 0.015438 , 0.01499 , 3.0E-5 , 12.42 , 17.97249 , 79.884094 , 27 , '898604650119C1078512' , '460048590708512' , -0 , 1682670746) [ RunTime:0.002564s ] --------------------------------------------------------------- [ 2023-04-28T17:11:25+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2 [ 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.012175s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000395s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001028s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001007s ] --------------------------------------------------------------- [ 2023-04-28T17:12:09+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001603s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009075s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000367s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001068s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001041s ] --------------------------------------------------------------- [ 2023-04-28T17:12:13+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001818s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010132s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000414s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001169s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001043s ] --------------------------------------------------------------- [ 2023-04-28T17:12:16+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010616s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000393s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000922s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001575s ] --------------------------------------------------------------- [ 2023-04-28T17:12:19+08:00 ] 223.104.255.138 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010562s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2023-04-28T17:12:21+08:00 ] 223.104.255.138 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1682673139&v1=0.027602&v2=0.014082&v3=0.025465&v4=0.016104&v5=12.240000&t=17.972490&h=73.574585&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184713,35.984766&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001901s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011544s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000752s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1682673139,`v1`=0.027602,`v2`=0.014082,`v3`=0.025465,`v4`=0.016104,`v5`=12.24,`t`=17.97249,`h`=73.574585,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184713,35.984766',`update_time`=1682673141 WHERE `imei` = '868922056976208' [ RunTime:0.001189s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011970s ] [ 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' , 1682673139 , 0.027602 , 0.014082 , 0.025465 , 0.016104 , 12.24 , 17.97249 , 73.574585 , 28 , '898604650119C1053139' , '460048590503139' , -0 , '120.184713,35.984766' , 1682673141) [ RunTime:0.001383s ] --------------------------------------------------------------- [ 2023-04-28T17:12:48+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002269s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012026s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000682s ] [ 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.000998s ] --------------------------------------------------------------- [ 2023-04-28T17:14:23+08:00 ] 39.144.16.121 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002729s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011525s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000812s ] --------------------------------------------------------------- [ 2023-04-28T17:14:24+08:00 ] 39.144.16.121 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1682673263&v1=0.019114&v2=0.015646&v3=0.016104&v4=-0.007074&v5=12.600000&t=17.961765&h=75.192017&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002094s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010084s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000746s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1682673263,`v1`=0.019114,`v2`=0.015646,`v3`=0.016104,`v4`=-0.007074,`v5`=12.6,`t`=17.961765,`h`=75.192017,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1682673264 WHERE `imei` = '868922055684209' [ RunTime:0.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012195s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1682673263 , 0.019114 , 0.015646 , 0.016104 , -0.007074 , 12.6 , 17.961765 , 75.192017 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1682673264) [ RunTime:0.000659s ] --------------------------------------------------------------- [ 2023-04-28T17:39:20+08:00 ] 117.132.191.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.011852s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012049s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000719s ] --------------------------------------------------------------- [ 2023-04-28T17:39:21+08:00 ] 117.132.191.44 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1682674760&v1=0.018331&v2=0.014707&v3=0.015472&v4=-0.004726&v5=12.420000&t=17.833063&h=75.779480&rssi=27&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ 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.009853s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1682674760,`v1`=0.018331,`v2`=0.014707,`v3`=0.015472,`v4`=-0.004726,`v5`=12.42,`t`=17.833063,`h`=75.77948,`rssi`=27,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1682674761 WHERE `imei` = '868922055683920' [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010802s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1682674760 , 0.018331 , 0.014707 , 0.015472 , -0.004726 , 12.42 , 17.833063 , 75.77948 , 27 , '89860426102071188500' , '460044618415250' , -0 , 1682674761) [ RunTime:0.001206s ] --------------------------------------------------------------- [ 2023-04-28T20:29:05+08:00 ] 39.144.11.32 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002917s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011824s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000842s ] --------------------------------------------------------------- [ 2023-04-28T20:29:06+08:00 ] 39.144.11.32 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1682684945&v1=0.031274&v2=0.013977&v3=0.028445&v4=0.008458&v5=12.600000&t=17.672188&h=76.153320&rssi=28&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184690,35.984835&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001896s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012006s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1682684945,`v1`=0.031274,`v2`=0.013977,`v3`=0.028445,`v4`=0.008458,`v5`=12.6,`t`=17.672188,`h`=76.15332,`rssi`=28,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184690,35.984835',`update_time`=1682684946 WHERE `imei` = '868922055683912' [ RunTime:0.000704s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011545s ] [ 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' , 1682684945 , 0.031274 , 0.013977 , 0.028445 , 0.008458 , 12.6 , 17.672188 , 76.15332 , 28 , '898604650119C1053138' , '460048590503138' , -0 , '120.184690,35.984835' , 1682684946) [ RunTime:0.001184s ] --------------------------------------------------------------- [ 2023-04-28T20:32:29+08:00 ] 39.144.18.66 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.001788s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010651s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000715s ] --------------------------------------------------------------- [ 2023-04-28T20:32:30+08:00 ] 39.144.18.66 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1682685149&v1=0.018632&v2=0.014186&v3=0.015833&v4=-0.016405&v5=12.420000&t=17.682913&h=78.205627&rssi=22&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001508s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009406s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1682685149,`v1`=0.018632,`v2`=0.014186,`v3`=0.015833,`v4`=-0.016405,`v5`=12.42,`t`=17.682913,`h`=78.205627,`rssi`=22,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1682685150 WHERE `imei` = '868922055683771' [ RunTime:0.000520s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011307s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1682685149 , 0.018632 , 0.014186 , 0.015833 , -0.016405 , 12.42 , 17.682913 , 78.205627 , 22 , '898604650119C1053136' , '460048590503136' , -0 , 1682685150) [ RunTime:0.000477s ] --------------------------------------------------------------- [ 2023-04-28T23:09:33+08:00 ] 218.204.252.145 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012059s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-04-28T23:09:34+08:00 ] 218.204.252.145 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1682694573&v1=0.006532&v2=0.014290&v3=0.004605&v4=-0.016043&v5=12.420000&t=17.640013&h=75.344604&rssi=12&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001624s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009810s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1682694573,`v1`=0.006532,`v2`=0.01429,`v3`=0.004605,`v4`=-0.016043,`v5`=12.42,`t`=17.640013,`h`=75.344604,`rssi`=12,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1682694574 WHERE `imei` = '868922055644021' [ RunTime:0.000674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011223s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1682694573 , 0.006532 , 0.01429 , 0.004605 , -0.016043 , 12.42 , 17.640013 , 75.344604 , 12 , '898604650119C1053141' , '460048590503141' , -0 , 1682694574) [ RunTime:0.001610s ] --------------------------------------------------------------- [ 2023-04-28T23:30:20+08:00 ] 39.144.3.246 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.011568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010747s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000745s ] --------------------------------------------------------------- [ 2023-04-28T23:30:21+08:00 ] 39.144.3.246 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1682695820&v1=0.020980&v2=0.013456&v3=0.018000&v4=-0.006291&v5=12.240000&t=17.543486&h=75.398010&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.184940,35.985401&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001821s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010324s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1682695820,`v1`=0.02098,`v2`=0.013456,`v3`=0.018,`v4`=-0.006291,`v5`=12.24,`t`=17.543486,`h`=75.39801,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.184940,35.985401',`update_time`=1682695821 WHERE `imei` = '868922055680850' [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011132s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055680850' , 1682695820 , 0.02098 , 0.013456 , 0.018 , -0.006291 , 12.24 , 17.543486 , 75.39801 , 25 , '898604650119C1078510' , '460048590708510' , -0 , '120.184940,35.985401' , 1682695821) [ RunTime:0.001388s ]