--------------------------------------------------------------- [ 2023-03-15T02:03:54+08:00 ] 117.132.193.210 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002977s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011532s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2023-03-15T02:03:55+08:00 ] 39.144.3.253 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001686s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011840s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2023-03-15T02:04:03+08:00 ] 117.132.193.210 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230315&time=020301&v1=-01.306&v2=+00.022&v3=-00.979&v4=-00.020&v5=05.7&t=+07.9&h=62.8&rssi=+231&ccid=4600485905031420000099m9990000000320000001g3170,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002131s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010299s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001043s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230315',`time`='020301',`v1`=-1.306,`v2`=0.022,`v3`=-0.979,`v4`=-0.02,`v5`=5.7,`t`=7.9,`h`=62.8,`rssi`=231,`ccid`='4600485905031420000099m9990000000320000001g3170,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678817043 WHERE `imei` = '868922055643643' [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010568s ] [ 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' , '230315' , '020301' , -1.306 , 0.022 , -0.979 , -0.02 , 5.7 , 7.9 , 62.8 , 231 , '4600485905031420000099m9990000000320000001g3170,N,00E000=-00.000' , 0 , 0 , 1678817043 , 1678817043) [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2023-03-15T02:04:03+08:00 ] 39.144.3.253 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230315&time=020301&v1=-00.220&v2=+00.001&v3=+00.008&v4=-00.019&v5=05.9&t=+08.5&h=65.6&rssi=+224&ccid=4600485905031430000099m9990000000027000000g2540,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001710s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008763s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230315',`time`='020301',`v1`=-0.22,`v2`=0.001,`v3`=0.008,`v4`=-0.019,`v5`=5.9,`t`=8.5,`h`=65.6,`rssi`=224,`ccid`='4600485905031430000099m9990000000027000000g2540,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678817043 WHERE `imei` = '868922055644013' [ RunTime:0.000524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010006s ] [ 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' , '230315' , '020301' , -0.22 , 0.001 , 0.008 , -0.019 , 5.9 , 8.5 , 65.6 , 224 , '4600485905031430000099m9990000000027000000g2540,N,00E000=-00.000' , 0 , 0 , 1678817043 , 1678817043) [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2023-03-15T06:05:50+08:00 ] 39.144.12.39 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002840s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010823s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000696s ] --------------------------------------------------------------- [ 2023-03-15T06:05:59+08:00 ] 39.144.12.39 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230315&time=060501&v1=-01.144&v2=+00.018&v3=-00.847&v4=-00.516&v5=05.9&t=+07.5&h=81.7&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.324&a2=01.209&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010648s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.001032s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230315',`time`='060501',`v1`=-1.144,`v2`=0.018,`v3`=-0.847,`v4`=-0.516,`v5`=5.9,`t`=7.5,`h`=81.7,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.324,`a2`=1.209,`update_time`=1678831559 WHERE `imei` = '868922055684076' [ RunTime:0.000702s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010495s ] [ 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' , '230315' , '060501' , -1.144 , 0.018 , -0.847 , -0.516 , 5.9 , 7.5 , 81.7 , 229 , '460044618415249' , -0 , 0.324 , 1.209 , 1678831559 , 1678831559) [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2023-03-15T09:12:54+08:00 ] 123.234.205.93 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002165s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011925s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2023-03-15T09:13:02+08:00 ] 112.224.69.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.002032s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012152s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000662s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1678842782 , 1678842782) [ RunTime:0.001188s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2023-03-15T09:13:04+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011021s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000570s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000806s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000871s ] --------------------------------------------------------------- [ 2023-03-15T09:13:08+08:00 ] 112.224.69.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.002172s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009823s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`=' GSN',`update_time`=1678842788 WHERE `imei` = ' GSN' [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012094s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1678842788 , 1678842788) [ RunTime:0.001374s ] --------------------------------------------------------------- [ 2023-03-15T09:13:16+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002525s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009890s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000335s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000885s ] --------------------------------------------------------------- [ 2023-03-15T09:17:04+08:00 ] 112.224.67.221 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.010417s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011321s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES ('868922055684209' , 1678843024 , 1678843024) [ RunTime:0.000454s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2023-03-15T09:17:05+08:00 ] 112.224.67.221 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1678843024&v1=-0.004425&v2=0.628039&v3=0.007796&v4=0.016043&v5=13.320000&t=21.018417&h=34.000916&rssi=17&ccid=89860118803392574452&imsi=460015788115318&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.009804s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1678843024,`v1`=-0.004425,`v2`=0.628039,`v3`=0.007796,`v4`=0.016043,`v5`=13.32,`t`=21.018417,`h`=34.000916,`rssi`=17,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1678843025 WHERE `imei` = '868922055684209' [ RunTime:0.000524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010945s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1678843024 , -0.004425 , 0.628039 , 0.007796 , 0.016043 , 13.32 , 21.018417 , 34.000916 , 17 , '89860118803392574452' , '460015788115318' , -0 , 1678843025) [ RunTime:0.000740s ] --------------------------------------------------------------- [ 2023-03-15T09:17:07+08:00 ] 112.224.67.221 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1575515471&v1=0.015562&v2=0.271827&v3=0.016043&v4=0.016224&v5=13.500000&t=19.956633&h=48.183960&rssi=17&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001836s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011138s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001210s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1575515471,`v1`=0.015562,`v2`=0.271827,`v3`=0.016043,`v4`=0.016224,`v5`=13.5,`t`=19.956633,`h`=48.18396,`rssi`=17,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1678843026 WHERE `imei` = '868922055684209' [ RunTime:0.000495s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007661s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1575515471 , 0.015562 , 0.271827 , 0.016043 , 0.016224 , 13.5 , 19.956633 , 48.18396 , 17 , '89860118803392574452' , '460015788115318' , -0 , 1678843027) [ RunTime:0.000449s ] --------------------------------------------------------------- [ 2023-03-15T09:17:08+08:00 ] 112.224.67.221 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1575515471&v1=-0.030010&v2=0.344008&v3=0.007525&v4=0.015261&v5=-69.300003&t=20.707390&h=34.260315&rssi=17&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&en [ sql ] [ DB ] CONNECT:[ UseTime:0.002147s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011186s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1575515471,`v1`=-0.03001,`v2`=0.344008,`v3`=0.007525,`v4`=0.015261,`v5`=-69.300003,`t`=20.70739,`h`=34.260315,`rssi`=17,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1678843028 WHERE `imei` = '868922055684209' [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010604s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1575515471 , -0.03001 , 0.344008 , 0.007525 , 0.015261 , -69.300003 , 20.70739 , 34.260315 , 17 , '89860118803392574452' , '460015788115318' , -0 , 1678843028) [ RunTime:0.000475s ] --------------------------------------------------------------- [ 2023-03-15T09:17:20+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001435s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009824s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000383s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000756s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000843s ] --------------------------------------------------------------- [ 2023-03-15T09:17:23+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002753s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011295s ] [ 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.000774s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000760s ] --------------------------------------------------------------- [ 2023-03-15T09:17:24+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002387s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012188s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010950s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000522s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000665s ] --------------------------------------------------------------- [ 2023-03-15T09:19:23+08:00 ] 112.224.69.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.001976s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010229s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2023-03-15T09:19:25+08:00 ] 112.224.69.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1678843163&v1=0.015562&v2=0.205070&v3=0.015953&v4=0.016043&v5=13.320000&t=21.361622&h=33.810181&rssi=17&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001993s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010225s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1678843163,`v1`=0.015562,`v2`=0.20507,`v3`=0.015953,`v4`=0.016043,`v5`=13.32,`t`=21.361622,`h`=33.810181,`rssi`=17,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1678843165 WHERE `imei` = '868922055684209' [ RunTime:0.000497s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011449s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1678843163 , 0.015562 , 0.20507 , 0.015953 , 0.016043 , 13.32 , 21.361622 , 33.810181 , 17 , '89860118803392574452' , '460015788115318' , -0 , 1678843165) [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2023-03-15T09:21:07+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001744s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012387s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010710s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2023-03-15T09:21:19+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002254s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009950s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010228s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000489s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2023-03-15T09:21:20+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003561s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012631s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000918s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011804s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000891s ] --------------------------------------------------------------- [ 2023-03-15T09:21:23+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.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_show` [ RunTime:0.011108s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011182s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000885s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-03-15T09:21:25+08:00 ] 112.224.70.230 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.001876s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009608s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2023-03-15T09:21:27+08:00 ] 112.224.70.230 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1678843285&v1=0.015622&v2=0.269637&v3=0.016013&v4=0.016043&v5=13.320000&t=21.265095&h=33.237976&rssi=17&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009876s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000741s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1678843285,`v1`=0.015622,`v2`=0.269637,`v3`=0.016013,`v4`=0.016043,`v5`=13.32,`t`=21.265095,`h`=33.237976,`rssi`=17,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1678843287 WHERE `imei` = '868922055684209' [ RunTime:0.000549s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012068s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1678843285 , 0.015622 , 0.269637 , 0.016013 , 0.016043 , 13.32 , 21.265095 , 33.237976 , 17 , '89860118803392574452' , '460015788115318' , -0 , 1678843287) [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2023-03-15T09:21:35+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001692s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.047681s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011056s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000511s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2023-03-15T11:10:36+08:00 ] 123.234.205.93 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002363s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013539s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2023-03-15T11:10:42+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002058s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011275s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000748s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000786s ] --------------------------------------------------------------- [ 2023-03-15T11:11:23+08:00 ] 123.234.205.93 GET /admin/show/read/id/44/imei/868922055647586.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002395s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010660s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000742s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012668s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.001535s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055647586' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000817s ] --------------------------------------------------------------- [ 2023-03-15T11:23:43+08:00 ] 123.234.205.93 GET /admin/show/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_show` [ RunTime:0.009986s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000485s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000849s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000881s ] --------------------------------------------------------------- [ 2023-03-15T11:23:50+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002279s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014058s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000952s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015133s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000818s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001324s ] --------------------------------------------------------------- [ 2023-03-15T11:24:05+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002611s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010224s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011240s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000534s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2023-03-15T11:24:38+08:00 ] 117.132.191.85 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.002736s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009869s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000920s ] --------------------------------------------------------------- [ 2023-03-15T11:24:43+08:00 ] 117.132.191.85 GET /kaiwu/public/index.php?s=/index/index/update/&imei=+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.002046s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011703s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000781s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`=' GSN',`update_time`=1678850683 WHERE `imei` = ' GSN' [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011008s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1678850683 , 1678850683) [ RunTime:0.001026s ] --------------------------------------------------------------- [ 2023-03-15T11:24:48+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001894s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009471s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000759s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011914s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000553s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000775s ] --------------------------------------------------------------- [ 2023-03-15T11:26:17+08:00 ] 39.144.2.4 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ 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.009854s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [ 2023-03-15T11:26:18+08:00 ] 39.144.2.4 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1678850777&v1=1.040057&v2=0.319913&v3=0.016013&v4=0.015863&v5=5.220000&t=16.299376&h=29.179138&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001836s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009085s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1678850777,`v1`=1.040057,`v2`=0.319913,`v3`=0.016013,`v4`=0.015863,`v5`=5.22,`t`=16.299376,`h`=29.179138,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1678850778 WHERE `imei` = '868922055684209' [ RunTime:0.000520s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011477s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1678850777 , 1.040057 , 0.319913 , 0.016013 , 0.015863 , 5.22 , 16.299376 , 29.179138 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1678850778) [ RunTime:0.000595s ] --------------------------------------------------------------- [ 2023-03-15T11:26:20+08:00 ] 39.144.2.4 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1575515471&v1=1.040358&v2=0.201732&v3=0.016194&v4=0.016104&v5=-69.300003&t=15.559343&h=30.399841&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001687s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011571s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1575515471,`v1`=1.040358,`v2`=0.201732,`v3`=0.016194,`v4`=0.016104,`v5`=-69.300003,`t`=15.559343,`h`=30.399841,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1678850779 WHERE `imei` = '868922055684209' [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010793s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1575515471 , 1.040358 , 0.201732 , 0.016194 , 0.016104 , -69.300003 , 15.559343 , 30.399841 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1678850780) [ RunTime:0.000494s ] --------------------------------------------------------------- [ 2023-03-15T11:26:25+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.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_show` [ RunTime:0.009849s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015003s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000594s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2023-03-15T11:29:07+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010477s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010838s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000496s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-03-15T11:29:13+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.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_show` [ RunTime:0.009974s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000814s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011261s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000526s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000770s ] --------------------------------------------------------------- [ 2023-03-15T11:31:27+08:00 ] 117.132.192.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002315s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010707s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2023-03-15T11:31:28+08:00 ] 117.132.192.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1678851087&v1=0.015321&v2=11.826769&v3=0.015351&v4=1.041382&v5=5.220000&t=16.835630&h=27.164978&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.009941s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010308s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1678851087,`v1`=0.015321,`v2`=11.826769,`v3`=0.015351,`v4`=1.041382,`v5`=5.22,`t`=16.83563,`h`=27.164978,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1678851088 WHERE `imei` = '868922055684209' [ RunTime:0.000497s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009636s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1678851087 , 0.015321 , 11.826769 , 0.015351 , 1.041382 , 5.22 , 16.83563 , 27.164978 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1678851088) [ RunTime:0.000483s ] --------------------------------------------------------------- [ 2023-03-15T11:31:29+08:00 ] 117.132.192.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1678850881&v1=0.015321&v2=12.311071&v3=0.015532&v4=1.041984&v5=6.480000&t=16.685478&h=27.851624&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end= [ 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.012322s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000665s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1678850881,`v1`=0.015321,`v2`=12.311071,`v3`=0.015532,`v4`=1.041984,`v5`=6.48,`t`=16.685478,`h`=27.851624,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1678851089 WHERE `imei` = '868922055684209' [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009194s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1678850881 , 0.015321 , 12.311071 , 0.015532 , 1.041984 , 6.48 , 16.685478 , 27.851624 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1678851089) [ RunTime:0.000481s ] --------------------------------------------------------------- [ 2023-03-15T11:31:37+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.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_show` [ RunTime:0.011569s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009245s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000573s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001086s ] --------------------------------------------------------------- [ 2023-03-15T11:33:29+08:00 ] 39.144.5.253 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011467s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000763s ] --------------------------------------------------------------- [ 2023-03-15T11:33:30+08:00 ] 39.144.5.253 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1678851209&v1=1.039154&v2=0.317827&v3=1.043519&v4=0.016104&v5=5.220000&t=16.942881&h=27.447266&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.010843s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011089s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000786s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1678851209,`v1`=1.039154,`v2`=0.317827,`v3`=1.043519,`v4`=0.016104,`v5`=5.22,`t`=16.942881,`h`=27.447266,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1678851210 WHERE `imei` = '868922055684209' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011596s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1678851209 , 1.039154 , 0.317827 , 1.043519 , 0.016104 , 5.22 , 16.942881 , 27.447266 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1678851210) [ RunTime:0.000500s ] --------------------------------------------------------------- [ 2023-03-15T11:33:37+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001548s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009315s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000748s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011434s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000534s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000789s ] --------------------------------------------------------------- [ 2023-03-15T11:38:05+08:00 ] 39.144.16.195 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.001745s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009571s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000654s ] --------------------------------------------------------------- [ 2023-03-15T11:38:07+08:00 ] 39.144.16.195 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1678851485&v1=0.015381&v2=0.276625&v3=0.015562&v4=0.015983&v5=5.220000&t=17.854515&h=32.139343&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001488s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011281s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1678851485,`v1`=0.015381,`v2`=0.276625,`v3`=0.015562,`v4`=0.015983,`v5`=5.22,`t`=17.854515,`h`=32.139343,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1678851487 WHERE `imei` = '868922055684209' [ RunTime:0.000550s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010445s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1678851485 , 0.015381 , 0.276625 , 0.015562 , 0.015983 , 5.22 , 17.854515 , 32.139343 , 31 , '898604650119C1078511' , '460048590708511' , -0 , 1678851487) [ RunTime:0.000499s ] --------------------------------------------------------------- [ 2023-03-15T11:38:15+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001608s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010366s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000792s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011277s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000573s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000884s ] --------------------------------------------------------------- [ 2023-03-15T11:48:09+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002237s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011190s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000421s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000765s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000823s ] --------------------------------------------------------------- [ 2023-03-15T11:48:13+08:00 ] 123.234.205.93 GET /admin/show/read/id/45/imei/868922055680850.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002817s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012080s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009916s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.001261s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055680850' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000799s ] --------------------------------------------------------------- [ 2023-03-15T11:49:33+08:00 ] 39.144.11.118 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002196s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009630s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000768s ] --------------------------------------------------------------- [ 2023-03-15T11:49:34+08:00 ] 39.144.11.118 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1678852173&v1=1.047342&v2=0.387609&v3=0.017639&v4=0.017729&v5=5.220000&t=16.685478&h=31.544250&rssi=31&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002307s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009199s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000895s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1678852173,`v1`=1.047342,`v2`=0.387609,`v3`=0.017639,`v4`=0.017729,`v5`=5.22,`t`=16.685478,`h`=31.54425,`rssi`=31,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1678852174 WHERE `imei` = '868922055680850' [ RunTime:0.000601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010940s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1678852173 , 1.047342 , 0.387609 , 0.017639 , 0.017729 , 5.22 , 16.685478 , 31.54425 , 31 , '898604650119C1078510' , '460048590708510' , -0 , 1678852174) [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2023-03-15T11:49:38+08:00 ] 123.234.205.93 GET /admin/show/read/id/45/imei/868922055680850.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001819s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011281s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010308s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000557s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055680850' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000974s ] --------------------------------------------------------------- [ 2023-03-15T11:51:27+08:00 ] 111.55.137.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002673s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009472s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2023-03-15T11:51:28+08:00 ] 111.55.137.75 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1678852287&v1=1.047703&v2=0.337750&v3=1.051736&v4=0.017970&v5=5.220000&t=17.146658&h=29.713196&rssi=31&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010373s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1678852287,`v1`=1.047703,`v2`=0.33775,`v3`=1.051736,`v4`=0.01797,`v5`=5.22,`t`=17.146658,`h`=29.713196,`rssi`=31,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1678852288 WHERE `imei` = '868922055680850' [ RunTime:0.000545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009809s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1678852287 , 1.047703 , 0.33775 , 1.051736 , 0.01797 , 5.22 , 17.146658 , 29.713196 , 31 , '898604650119C1078510' , '460048590708510' , -0 , 1678852288) [ RunTime:0.000515s ] --------------------------------------------------------------- [ 2023-03-15T11:51:33+08:00 ] 123.234.205.93 GET /admin/show/read/id/45/imei/868922055680850.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_show` [ RunTime:0.009965s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011842s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000617s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055680850' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000908s ] --------------------------------------------------------------- [ 2023-03-15T11:52:23+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001567s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010289s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000521s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001198s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000871s ] --------------------------------------------------------------- [ 2023-03-15T11:52:27+08:00 ] 123.234.205.93 GET /admin/show/edit/id/45.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_show` [ RunTime:0.011757s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013078s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001132s ] --------------------------------------------------------------- [ 2023-03-15T11:52:34+08:00 ] 123.234.205.93 POST /admin/show/update.html [ 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.009379s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='',`interval`=3,`gps`='',`username`='admin',`introduce`=' ',`update_time`=1678852354 WHERE `id` = 45 [ RunTime:0.000612s ] --------------------------------------------------------------- [ 2023-03-15T11:52:36+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001750s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010028s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000335s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000724s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000784s ] --------------------------------------------------------------- [ 2023-03-15T11:52:40+08:00 ] 123.234.205.93 GET /admin/show/read/id/45/imei/868922055680850.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001749s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010469s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011006s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055680850' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000952s ] --------------------------------------------------------------- [ 2023-03-15T11:53:27+08:00 ] 111.55.138.98 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002072s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010256s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2023-03-15T11:53:28+08:00 ] 111.55.138.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1678852407&v1=0.017368&v2=10.983333&v3=0.017338&v4=1.041924&v5=5.220000&t=17.339710&h=29.377502&rssi=31&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002460s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010931s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1678852407,`v1`=0.017368,`v2`=10.983333,`v3`=0.017338,`v4`=1.041924,`v5`=5.22,`t`=17.33971,`h`=29.377502,`rssi`=31,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1678852408 WHERE `imei` = '868922055680850' [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010539s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1678852407 , 0.017368 , 10.983333 , 0.017338 , 1.041924 , 5.22 , 17.33971 , 29.377502 , 31 , '898604650119C1078510' , '460048590708510' , -0 , 1678852408) [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2023-03-15T11:53:33+08:00 ] 123.234.205.93 GET /admin/show/read/id/45/imei/868922055680850.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001548s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010712s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011530s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000786s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055680850' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001033s ] --------------------------------------------------------------- [ 2023-03-15T11:55:44+08:00 ] 123.234.205.93 GET /admin/show/read/id/45/imei/868922055680850.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002167s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008963s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000818s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008760s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055680850' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000781s ] --------------------------------------------------------------- [ 2023-03-15T11:56:27+08:00 ] 39.144.4.129 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.001770s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011451s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000677s ] --------------------------------------------------------------- [ 2023-03-15T11:56:28+08:00 ] 39.144.4.129 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1678852587&v1=0.017368&v2=10.955795&v3=0.017368&v4=1.041021&v5=5.400000&t=17.404060&h=30.010742&rssi=31&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001720s ] 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 * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1678852587,`v1`=0.017368,`v2`=10.955795,`v3`=0.017368,`v4`=1.041021,`v5`=5.4,`t`=17.40406,`h`=30.010742,`rssi`=31,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1678852588 WHERE `imei` = '868922055680850' [ RunTime:0.000562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011775s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1678852587 , 0.017368 , 10.955795 , 0.017368 , 1.041021 , 5.4 , 17.40406 , 30.010742 , 31 , '898604650119C1078510' , '460048590708510' , -0 , 1678852588) [ RunTime:0.000574s ] --------------------------------------------------------------- [ 2023-03-15T11:56:32+08:00 ] 123.234.205.93 GET /admin/show/read/id/45/imei/868922055680850.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001506s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009835s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010952s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000578s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055680850' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000831s ] --------------------------------------------------------------- [ 2023-03-15T13:05:32+08:00 ] 123.234.205.93 GET /admin/show/read/id/45/imei/868922055680850.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002180s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010346s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012088s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.001081s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055680850' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000987s ] --------------------------------------------------------------- [ 2023-03-15T13:05:39+08:00 ] 123.234.205.93 GET /admin/show/read/id/45/imei/868922055680850.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001676s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010871s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010565s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000511s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055680850' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000802s ] --------------------------------------------------------------- [ 2023-03-15T13:05:55+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010926s ] [ 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 0,10 [ RunTime:0.000890s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000865s ] --------------------------------------------------------------- [ 2023-03-15T13:05:59+08:00 ] 123.234.205.93 GET /admin/show/read/id/43/imei/868922056976109.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011600s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001287s ] --------------------------------------------------------------- [ 2023-03-15T13:06:45+08:00 ] 39.144.5.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.002186s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011011s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000751s ] --------------------------------------------------------------- [ 2023-03-15T13:06:50+08:00 ] 39.144.5.44 GET /kaiwu/public/index.php?s=/index/index/update/&imei=+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.002154s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009846s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000763s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`=' GSN',`update_time`=1678856810 WHERE `imei` = ' GSN' [ RunTime:0.000576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011656s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1678856810 , 1678856810) [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-03-15T13:06:55+08:00 ] 123.234.205.93 GET /admin/show/read/id/43/imei/868922056976109.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001989s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010460s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009276s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000498s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2023-03-15T13:06:57+08:00 ] 123.234.205.93 GET /admin/show/read/id/43/imei/868922056976109.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001951s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009501s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010903s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000522s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-03-15T13:07:12+08:00 ] 123.234.205.93 GET /admin/show/create.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001961s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010299s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000532s ] --------------------------------------------------------------- [ 2023-03-15T13:07:14+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001577s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010601s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000386s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000720s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000788s ] --------------------------------------------------------------- [ 2023-03-15T13:07:31+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001448s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009437s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010088s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000508s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000732s ] --------------------------------------------------------------- [ 2023-03-15T13:08:26+08:00 ] 223.104.255.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.001822s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011483s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2023-03-15T13:08:27+08:00 ] 223.104.255.247 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678856906&v1=1.048726&v2=0.185147&v3=0.028896&v4=0.028746&v5=5.220000&t=18.412220&h=22.045654&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002059s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012268s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000746s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678856906,`v1`=1.048726,`v2`=0.185147,`v3`=0.028896,`v4`=0.028746,`v5`=5.22,`t`=18.41222,`h`=22.045654,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678856907 WHERE `imei` = '868922056976109' [ RunTime:0.000631s ] [ 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 ('868922056976109' , 1678856906 , 1.048726 , 0.185147 , 0.028896 , 0.028746 , 5.22 , 18.41222 , 22.045654 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1678856907) [ RunTime:0.000509s ] --------------------------------------------------------------- [ 2023-03-15T13:08:29+08:00 ] 223.104.255.247 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1575515471&v1=1.049027&v2=0.317097&v3=0.028896&v4=0.028746&v5=-69.300003&t=17.993940&h=24.258179&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.002325s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009819s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1575515471,`v1`=1.049027,`v2`=0.317097,`v3`=0.028896,`v4`=0.028746,`v5`=-69.300003,`t`=17.99394,`h`=24.258179,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678856909 WHERE `imei` = '868922056976109' [ RunTime:0.000515s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010039s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1575515471 , 1.049027 , 0.317097 , 0.028896 , 0.028746 , -69.300003 , 17.99394 , 24.258179 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1678856909) [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2023-03-15T13:08:40+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001835s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010699s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011055s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000853s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000752s ] --------------------------------------------------------------- [ 2023-03-15T13:08:45+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001961s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009595s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010711s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2023-03-15T13:08:57+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009713s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000460s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000797s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000782s ] --------------------------------------------------------------- [ 2023-03-15T13:09:11+08:00 ] 123.234.205.93 GET /admin/show/read/id/43/imei/868922056976109.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_show` [ RunTime:0.010030s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011549s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000484s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2023-03-15T13:10:27+08:00 ] 111.55.136.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ 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.010165s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-03-15T13:10:28+08:00 ] 111.55.136.217 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678857027&v1=1.047703&v2=0.190571&v3=1.049268&v4=0.028686&v5=5.220000&t=18.701797&h=20.809692&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001766s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011628s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678857027,`v1`=1.047703,`v2`=0.190571,`v3`=1.049268,`v4`=0.028686,`v5`=5.22,`t`=18.701797,`h`=20.809692,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678857028 WHERE `imei` = '868922056976109' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011230s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678857027 , 1.047703 , 0.190571 , 1.049268 , 0.028686 , 5.22 , 18.701797 , 20.809692 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1678857028) [ RunTime:0.000510s ] --------------------------------------------------------------- [ 2023-03-15T13:10:34+08:00 ] 123.234.205.93 GET /admin/show/read/id/43/imei/868922056976109.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011340s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000973s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014523s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000603s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000802s ] --------------------------------------------------------------- [ 2023-03-15T13:12:27+08:00 ] 39.144.5.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109 [ sql ] [ DB ] CONNECT:[ UseTime:0.001881s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014114s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2023-03-15T13:12:28+08:00 ] 39.144.5.72 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678857147&v1=0.028084&v2=5.280390&v3=0.028054&v4=1.042887&v5=5.220000&t=18.744698&h=21.870178&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001690s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010376s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678857147,`v1`=0.028084,`v2`=5.28039,`v3`=0.028054,`v4`=1.042887,`v5`=5.22,`t`=18.744698,`h`=21.870178,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678857148 WHERE `imei` = '868922056976109' [ RunTime:0.000592s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013351s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678857147 , 0.028084 , 5.28039 , 0.028054 , 1.042887 , 5.22 , 18.744698 , 21.870178 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1678857148) [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2023-03-15T13:38:25+08:00 ] 123.234.205.93 GET /admin/show/read/id/43/imei/868922056976109.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002171s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009890s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011021s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000527s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000739s ] --------------------------------------------------------------- [ 2023-03-15T13:38:28+08:00 ] 123.234.205.93 GET /admin/show/index.html [ 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.010513s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000382s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000748s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000800s ] --------------------------------------------------------------- [ 2023-03-15T13:38:31+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002041s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009594s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000383s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000757s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2023-03-15T13:38:35+08:00 ] 123.234.205.93 GET /admin/show/read/id/44/imei/868922055647586.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009708s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010810s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000591s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055647586' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000826s ] --------------------------------------------------------------- [ 2023-03-15T13:39:39+08:00 ] 117.132.195.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.001725s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010625s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2023-03-15T13:39:44+08:00 ] 117.132.195.19 GET /kaiwu/public/index.php?s=/index/index/update/&imei=+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.002116s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011455s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000746s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`=' GSN',`update_time`=1678858784 WHERE `imei` = ' GSN' [ RunTime:0.000503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009762s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1678858784 , 1678858784) [ RunTime:0.000511s ] --------------------------------------------------------------- [ 2023-03-15T13:39:53+08:00 ] 123.234.205.93 GET /admin/show/read/id/44/imei/868922055647586.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001429s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010743s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010650s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000545s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055647586' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000765s ] --------------------------------------------------------------- [ 2023-03-15T13:39:59+08:00 ] 123.234.205.93 GET /admin/show/read/id/44/imei/868922055647586.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001563s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010515s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000893s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010239s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000502s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055647586' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-03-15T13:40:51+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001691s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011232s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000381s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000836s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000824s ] --------------------------------------------------------------- [ 2023-03-15T13:41:20+08:00 ] 39.144.12.167 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010088s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-03-15T13:41:22+08:00 ] 39.144.12.167 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1678858880&v1=1.030907&v2=0.014290&v3=0.015532&v4=0.015622&v5=5.040000&t=17.682913&h=21.297974&rssi=31&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.010000s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011141s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1678858880,`v1`=1.030907,`v2`=0.01429,`v3`=0.015532,`v4`=0.015622,`v5`=5.04,`t`=17.682913,`h`=21.297974,`rssi`=31,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1678858882 WHERE `imei` = '868922055647586' [ RunTime:0.000508s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009895s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1678858880 , 1.030907 , 0.01429 , 0.015532 , 0.015622 , 5.04 , 17.682913 , 21.297974 , 31 , '898604650119C1078512' , '460048590708512' , -0 , 1678858882) [ RunTime:0.000499s ] --------------------------------------------------------------- [ 2023-03-15T13:41:23+08:00 ] 39.144.12.167 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1575515471&v1=1.029703&v2=0.013977&v3=0.015652&v4=0.015742&v5=-69.300003&t=17.704363&h=20.870728&rssi=31&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001679s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012626s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1575515471,`v1`=1.029703,`v2`=0.013977,`v3`=0.015652,`v4`=0.015742,`v5`=-69.300003,`t`=17.704363,`h`=20.870728,`rssi`=31,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1678858883 WHERE `imei` = '868922055647586' [ RunTime:0.000499s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010153s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1575515471 , 1.029703 , 0.013977 , 0.015652 , 0.015742 , -69.300003 , 17.704363 , 20.870728 , 31 , '898604650119C1078512' , '460048590708512' , -0 , 1678858883) [ RunTime:0.000521s ] --------------------------------------------------------------- [ 2023-03-15T13:41:31+08:00 ] 123.234.205.93 GET /admin/show/read/id/44/imei/868922055647586.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001691s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009978s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011446s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000499s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055647586' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2023-03-15T13:41:35+08:00 ] 112.224.70.150 GET /admin/show/read/id/44/imei/868922055647586.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001575s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010236s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000501s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055647586' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2023-03-15T13:43:27+08:00 ] 39.144.16.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ 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.011269s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000813s ] --------------------------------------------------------------- [ 2023-03-15T13:43:29+08:00 ] 39.144.16.86 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1678859007&v1=1.029342&v2=0.012934&v3=1.016428&v4=0.015803&v5=5.220000&t=17.597113&h=22.022766&rssi=31&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001750s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010674s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1678859007,`v1`=1.029342,`v2`=0.012934,`v3`=1.016428,`v4`=0.015803,`v5`=5.22,`t`=17.597113,`h`=22.022766,`rssi`=31,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1678859009 WHERE `imei` = '868922055647586' [ RunTime:0.000903s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011431s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1678859007 , 1.029342 , 0.012934 , 1.016428 , 0.015803 , 5.22 , 17.597113 , 22.022766 , 31 , '898604650119C1078512' , '460048590708512' , -0 , 1678859009) [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2023-03-15T13:43:35+08:00 ] 112.224.70.150 GET /admin/show/read/id/44/imei/868922055647586.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011047s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018954s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000530s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055647586' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000760s ] --------------------------------------------------------------- [ 2023-03-15T13:45:27+08:00 ] 39.144.12.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002202s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011080s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000784s ] --------------------------------------------------------------- [ 2023-03-15T13:45:29+08:00 ] 39.144.12.100 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1678859127&v1=0.015201&v2=9.415165&v3=0.015201&v4=1.031509&v5=5.040000&t=17.575661&h=20.939392&rssi=31&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001601s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009878s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1678859127,`v1`=0.015201,`v2`=9.415165,`v3`=0.015201,`v4`=1.031509,`v5`=5.04,`t`=17.575661,`h`=20.939392,`rssi`=31,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1678859129 WHERE `imei` = '868922055647586' [ RunTime:0.000561s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011297s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1678859127 , 0.015201 , 9.415165 , 0.015201 , 1.031509 , 5.04 , 17.575661 , 20.939392 , 31 , '898604650119C1078512' , '460048590708512' , -0 , 1678859129) [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2023-03-15T13:45:37+08:00 ] 112.224.70.150 GET /admin/show/read/id/44/imei/868922055647586.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001436s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010340s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000665s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008966s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000511s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055647586' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000784s ] --------------------------------------------------------------- [ 2023-03-15T14:03:54+08:00 ] 221.178.127.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009975s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-03-15T14:03:56+08:00 ] 221.178.127.222 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010011s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2023-03-15T14:04:03+08:00 ] 221.178.127.250 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230315&time=140301&v1=-00.202&v2=+00.002&v3=+00.020&v4=-00.019&v5=05.9&t=+12.2&h=64.7&rssi=+223&ccid=4600485905031430000099m9990000000037000000g2350,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009461s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000769s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230315',`time`='140301',`v1`=-0.202,`v2`=0.002,`v3`=0.02,`v4`=-0.019,`v5`=5.9,`t`=12.2,`h`=64.7,`rssi`=223,`ccid`='4600485905031430000099m9990000000037000000g2350,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678860243 WHERE `imei` = '868922055644013' [ RunTime:0.000572s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011383s ] [ 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' , '230315' , '140301' , -0.202 , 0.002 , 0.02 , -0.019 , 5.9 , 12.2 , 64.7 , 223 , '4600485905031430000099m9990000000037000000g2350,N,00E000=-00.000' , 0 , 0 , 1678860243 , 1678860243) [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2023-03-15T14:04:04+08:00 ] 221.178.127.222 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230315&time=140301&v1=-01.305&v2=+00.054&v3=-00.978&v4=-00.020&v5=06.0&t=+11.5&h=61.9&rssi=+219&ccid=4600485905031420000099m9990000000323000001g3160,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001600s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009332s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230315',`time`='140301',`v1`=-1.305,`v2`=0.054,`v3`=-0.978,`v4`=-0.02,`v5`=6,`t`=11.5,`h`=61.9,`rssi`=219,`ccid`='4600485905031420000099m9990000000323000001g3160,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678860244 WHERE `imei` = '868922055643643' [ RunTime:0.000528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010813s ] [ 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' , '230315' , '140301' , -1.305 , 0.054 , -0.978 , -0.02 , 6 , 11.5 , 61.9 , 219 , '4600485905031420000099m9990000000323000001g3160,N,00E000=-00.000' , 0 , 0 , 1678860244 , 1678860244) [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2023-03-15T14:43:17+08:00 ] 123.234.205.93 GET /admin/show/read/id/47/imei/868922055684209.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003056s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010121s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019892s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000838s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000814s ] --------------------------------------------------------------- [ 2023-03-15T14:43:46+08:00 ] 123.234.205.93 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001961s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010277s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000394s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000854s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000821s ] --------------------------------------------------------------- [ 2023-03-15T16:24:18+08:00 ] 112.224.70.150 GET /admin/show/read/id/44/imei/868922055647586.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002254s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010702s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011637s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000582s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055647586' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000819s ] --------------------------------------------------------------- [ 2023-03-15T17:04:29+08:00 ] 123.234.205.93 GET /admin/show/read/id/46/imei/+GSN.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002200s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013186s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 46 LIMIT 1 [ RunTime:0.000782s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011413s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '+GSN' LIMIT 1 [ RunTime:0.000522s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '+GSN' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000623s ]