--------------------------------------------------------------- [ 2023-04-27T02:03:55+08:00 ] 111.55.139.194 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.011296s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010932s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000727s ] --------------------------------------------------------------- [ 2023-04-27T02:03:56+08:00 ] 39.144.5.209 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002068s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010306s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000769s ] --------------------------------------------------------------- [ 2023-04-27T02:04:03+08:00 ] 111.55.139.194 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230427&time=020301&v1=-00.239&v2=+00.001&v3=+00.018&v4=-00.012&v5=05.9&t=+11.9&h=63.6&rssi=+225&ccid=4600485905031430000099m9990000000037000000g2600,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001544s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009699s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230427',`time`='020301',`v1`=-0.239,`v2`=0.001,`v3`=0.018,`v4`=-0.012,`v5`=5.9,`t`=11.9,`h`=63.6,`rssi`=225,`ccid`='4600485905031430000099m9990000000037000000g2600,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682532243 WHERE `imei` = '868922055644013' [ RunTime:0.000581s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009654s ] [ 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' , '230427' , '020301' , -0.239 , 0.001 , 0.018 , -0.012 , 5.9 , 11.9 , 63.6 , 225 , '4600485905031430000099m9990000000037000000g2600,N,00E000=-00.000' , 0 , 0 , 1682532243 , 1682532243) [ RunTime:0.000648s ] --------------------------------------------------------------- [ 2023-04-27T02:04:03+08:00 ] 39.144.5.209 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230427&time=020301&v1=-01.336&v2=+00.018&v3=-00.995&v4=-00.028&v5=05.7&t=+11.4&h=60.8&rssi=+222&ccid=4600485905031420000099m9990000000342000001g3460,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002804s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011106s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230427',`time`='020301',`v1`=-1.336,`v2`=0.018,`v3`=-0.995,`v4`=-0.028,`v5`=5.7,`t`=11.4,`h`=60.8,`rssi`=222,`ccid`='4600485905031420000099m9990000000342000001g3460,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682532243 WHERE `imei` = '868922055643643' [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010031s ] [ 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' , '230427' , '020301' , -1.336 , 0.018 , -0.995 , -0.028 , 5.7 , 11.4 , 60.8 , 222 , '4600485905031420000099m9990000000342000001g3460,N,00E000=-00.000' , 0 , 0 , 1682532243 , 1682532243) [ RunTime:0.001286s ] --------------------------------------------------------------- [ 2023-04-27T07:46:13+08:00 ] 112.224.67.62 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013150s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2023-04-27T07:46:18+08:00 ] 112.224.67.62 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001779s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010371s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000435s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001093s ] --------------------------------------------------------------- [ 2023-04-27T07:46:43+08:00 ] 112.224.67.62 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002540s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008805s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000346s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001003s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001019s ] --------------------------------------------------------------- [ 2023-04-27T14:03:53+08:00 ] 39.144.2.115 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011202s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-04-27T14:03:54+08:00 ] 39.144.12.191 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002137s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009723s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2023-04-27T14:04:02+08:00 ] 39.144.2.115 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230427&time=140301&v1=-01.332&v2=+00.036&v3=-00.986&v4=-00.029&v5=05.9&t=+25.4&h=58.0&rssi=+231&ccid=4600485905031420000099m9990000000347000001g3400,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001659s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011312s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000722s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230427',`time`='140301',`v1`=-1.332,`v2`=0.036,`v3`=-0.986,`v4`=-0.029,`v5`=5.9,`t`=25.4,`h`=58,`rssi`=231,`ccid`='4600485905031420000099m9990000000347000001g3400,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682575442 WHERE `imei` = '868922055643643' [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011754s ] [ 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' , '230427' , '140301' , -1.332 , 0.036 , -0.986 , -0.029 , 5.9 , 25.4 , 58 , 231 , '4600485905031420000099m9990000000347000001g3400,N,00E000=-00.000' , 0 , 0 , 1682575442 , 1682575442) [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-04-27T14:04:03+08:00 ] 39.144.12.191 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230427&time=140301&v1=-00.243&v2=+00.001&v3=+00.020&v4=-00.011&v5=06.0&t=+25.7&h=61.8&rssi=+227&ccid=4600485905031430000099m9990000000041000000g2640,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002011s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011878s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000692s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230427',`time`='140301',`v1`=-0.243,`v2`=0.001,`v3`=0.02,`v4`=-0.011,`v5`=6,`t`=25.7,`h`=61.8,`rssi`=227,`ccid`='4600485905031430000099m9990000000041000000g2640,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682575443 WHERE `imei` = '868922055644013' [ RunTime:0.000547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010071s ] [ 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' , '230427' , '140301' , -0.243 , 0.001 , 0.02 , -0.011 , 6 , 25.7 , 61.8 , 227 , '4600485905031430000099m9990000000041000000g2640,N,00E000=-00.000' , 0 , 0 , 1682575443 , 1682575443) [ RunTime:0.000827s ] --------------------------------------------------------------- [ 2023-04-27T14:09:03+08:00 ] 124.129.96.215 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002095s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010022s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2023-04-27T14:09:05+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010790s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000364s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000931s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001038s ] --------------------------------------------------------------- [ 2023-04-27T14:09:10+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001877s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010930s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000485s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000743s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001079s ] --------------------------------------------------------------- [ 2023-04-27T14:09:12+08:00 ] 124.129.96.215 GET /admin/show/edit/id/58.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001729s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009527s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011094s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001129s ] --------------------------------------------------------------- [ 2023-04-27T14:09:16+08:00 ] 124.129.96.215 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001761s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011367s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=2,`gps`='120.184850,35.985093',`username`='admin',`introduce`=' ',`update_time`=1682575756 WHERE `id` = 58 [ RunTime:0.000794s ] --------------------------------------------------------------- [ 2023-04-27T14:09:17+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001877s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010385s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000338s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000816s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000969s ] --------------------------------------------------------------- [ 2023-04-27T14:09:27+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002081s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011631s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000535s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000746s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001154s ] --------------------------------------------------------------- [ 2023-04-27T14:10:45+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002239s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010342s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000461s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000851s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001620s ] --------------------------------------------------------------- [ 2023-04-27T14:10:47+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001741s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010180s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000494s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000684s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001011s ] --------------------------------------------------------------- [ 2023-04-27T14:10:48+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ 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.009303s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000468s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000758s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001012s ] --------------------------------------------------------------- [ 2023-04-27T14:10:49+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ 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.009607s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000837s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000752s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000985s ] --------------------------------------------------------------- [ 2023-04-27T14:10:54+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002047s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010584s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000504s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000692s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001026s ] --------------------------------------------------------------- [ 2023-04-27T14:10:55+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001933s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010510s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000482s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000717s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001056s ] --------------------------------------------------------------- [ 2023-04-27T14:10:56+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011170s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000452s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000744s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000992s ] --------------------------------------------------------------- [ 2023-04-27T14:10:56+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001863s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011237s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000523s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000709s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001019s ] --------------------------------------------------------------- [ 2023-04-27T14:10:57+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010407s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000469s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000764s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001007s ] --------------------------------------------------------------- [ 2023-04-27T14:10:58+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001680s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009343s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000461s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000715s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001406s ] --------------------------------------------------------------- [ 2023-04-27T14:10:59+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010895s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000476s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000744s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001026s ] --------------------------------------------------------------- [ 2023-04-27T14:11:20+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001729s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008407s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000487s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000755s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001116s ] --------------------------------------------------------------- [ 2023-04-27T14:11:21+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002150s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008899s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000466s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000681s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001006s ] --------------------------------------------------------------- [ 2023-04-27T14:11:22+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001689s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009652s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000462s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000779s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001202s ] --------------------------------------------------------------- [ 2023-04-27T14:11:23+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009025s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000434s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000702s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001051s ] --------------------------------------------------------------- [ 2023-04-27T14:11:24+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001966s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011695s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000466s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000710s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001006s ] --------------------------------------------------------------- [ 2023-04-27T14:11:25+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001865s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010197s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000508s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000713s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001162s ] --------------------------------------------------------------- [ 2023-04-27T14:11:26+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002105s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009714s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000477s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000680s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001039s ] --------------------------------------------------------------- [ 2023-04-27T14:11:27+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002047s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011412s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000684s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000739s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001065s ] --------------------------------------------------------------- [ 2023-04-27T14:12:06+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001784s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009998s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000455s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000846s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001153s ] --------------------------------------------------------------- [ 2023-04-27T14:12:07+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002051s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010147s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000480s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000726s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001078s ] --------------------------------------------------------------- [ 2023-04-27T14:12:08+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011005s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000463s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000740s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000994s ] --------------------------------------------------------------- [ 2023-04-27T14:12:09+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001962s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010583s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000454s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000666s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001005s ] --------------------------------------------------------------- [ 2023-04-27T14:12:09+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001984s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010183s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000479s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000726s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001026s ] --------------------------------------------------------------- [ 2023-04-27T14:12:10+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001605s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010258s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000464s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000694s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000994s ] --------------------------------------------------------------- [ 2023-04-27T14:12:11+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010999s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000473s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000664s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000993s ] --------------------------------------------------------------- [ 2023-04-27T14:12:12+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002060s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009851s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000808s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000788s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001002s ] --------------------------------------------------------------- [ 2023-04-27T14:12:13+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001700s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009661s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000526s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000810s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001062s ] --------------------------------------------------------------- [ 2023-04-27T14:12:14+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002150s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009044s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000504s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000920s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001134s ] --------------------------------------------------------------- [ 2023-04-27T14:13:51+08:00 ] 39.144.8.1 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002003s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010527s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000661s ] --------------------------------------------------------------- [ 2023-04-27T14:13:59+08:00 ] 39.144.8.1 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230427&time=141301&v1=-01.002&v2=+00.038&v3=-00.906&v4=-00.413&v5=06.0&t=+26.6&h=78.4&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.137&a2=01.091&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002684s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010326s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230427',`time`='141301',`v1`=-1.002,`v2`=0.038,`v3`=-0.906,`v4`=-0.413,`v5`=6,`t`=26.6,`h`=78.4,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.137,`a2`=1.091,`update_time`=1682576039 WHERE `imei` = '868922055684076' [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013665s ] [ 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' , '230427' , '141301' , -1.002 , 0.038 , -0.906 , -0.413 , 6 , 26.6 , 78.4 , 228 , '460044618415249' , -0 , 0.137 , 1.091 , 1682576039 , 1682576039) [ RunTime:0.001316s ] --------------------------------------------------------------- [ 2023-04-27T14:15:16+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001455s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008952s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000708s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001044s ] --------------------------------------------------------------- [ 2023-04-27T14:15:17+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001556s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009722s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000448s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000651s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001030s ] --------------------------------------------------------------- [ 2023-04-27T14:15:17+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ 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.009811s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000451s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000663s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000991s ] --------------------------------------------------------------- [ 2023-04-27T14:15:18+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001860s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010599s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000461s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000684s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001100s ] --------------------------------------------------------------- [ 2023-04-27T14:31:48+08:00 ] 183.162.198.17 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002750s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010904s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2023-04-27T14:31:50+08:00 ] 183.162.198.17 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001641s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011781s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.001027s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000557s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000658s ] --------------------------------------------------------------- [ 2023-04-27T15:45:59+08:00 ] 117.132.198.200 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002893s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013822s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000899s ] --------------------------------------------------------------- [ 2023-04-27T15:46:00+08:00 ] 117.132.198.200 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682581559&v1=0.031274&v2=0.014603&v3=0.026609&v4=0.001415&v5=12.420000&t=18.776873&h=58.529419&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&gps=120.184657,35.984703&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011221s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000841s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682581559,`v1`=0.031274,`v2`=0.014603,`v3`=0.026609,`v4`=0.001415,`v5`=12.42,`t`=18.776873,`h`=58.529419,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`gps`='120.184657,35.984703',`update_time`=1682581560 WHERE `imei` = '868922055678110' [ RunTime:0.000739s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012828s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055678110' , 1682581559 , 0.031274 , 0.014603 , 0.026609 , 0.001415 , 12.42 , 18.776873 , 58.529419 , 29 , '898604650119C1078513' , '460048590708513' , -0 , '120.184657,35.984703' , 1682581560) [ RunTime:0.001460s ] --------------------------------------------------------------- [ 2023-04-27T15:46:01+08:00 ] 117.132.198.200 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1575515471&v1=0.031334&v2=0.012726&v3=0.026639&v4=0.001294&v5=-62.820000&t=19.688505&h=55.111450&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001613s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012138s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000662s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1575515471,`v1`=0.031334,`v2`=0.012726,`v3`=0.026639,`v4`=0.001294,`v5`=-62.82,`t`=19.688505,`h`=55.11145,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1682581561 WHERE `imei` = '868922055678110' [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009797s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1575515471 , 0.031334 , 0.012726 , 0.026639 , 0.001294 , -62.82 , 19.688505 , 55.11145 , 29 , '898604650119C1078513' , '460048590708513' , -0 , 1682581561) [ RunTime:0.000528s ] --------------------------------------------------------------- [ 2023-04-27T15:48:19+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001520s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010348s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000481s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000718s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001008s ] --------------------------------------------------------------- [ 2023-04-27T15:48:27+08:00 ] 124.129.96.215 GET /admin/show/read/id/58/imei/868922055678110.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002245s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009355s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010964s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000516s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002304s ] --------------------------------------------------------------- [ 2023-04-27T15:49:10+08:00 ] 111.55.140.104 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001555s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010348s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000648s ] --------------------------------------------------------------- [ 2023-04-27T15:49:11+08:00 ] 111.55.140.104 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682581750&v1=0.031274&v2=0.013664&v3=0.026579&v4=0.001355&v5=12.420000&t=19.238052&h=55.500549&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&gps=120.185610,35.985680&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001891s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009378s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682581750,`v1`=0.031274,`v2`=0.013664,`v3`=0.026579,`v4`=0.001355,`v5`=12.42,`t`=19.238052,`h`=55.500549,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`gps`='120.185610,35.985680',`update_time`=1682581751 WHERE `imei` = '868922055678110' [ RunTime:0.001195s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009676s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055678110' , 1682581750 , 0.031274 , 0.013664 , 0.026579 , 0.001355 , 12.42 , 19.238052 , 55.500549 , 29 , '898604650119C1078513' , '460048590708513' , -0 , '120.185610,35.985680' , 1682581751) [ RunTime:0.000515s ] --------------------------------------------------------------- [ 2023-04-27T15:51:14+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001502s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009852s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' LIMIT 1 [ RunTime:0.000553s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055678110%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000776s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001203s ] --------------------------------------------------------------- [ 2023-04-27T15:51:15+08:00 ] 124.129.96.215 GET /admin/show/edit/id/58.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.011048s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010596s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000471s ] --------------------------------------------------------------- [ 2023-04-27T15:51:21+08:00 ] 124.129.96.215 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001950s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009943s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=1440,`gps`='120.185610,35.985680',`username`='admin',`introduce`=' ',`update_time`=1682581881 WHERE `id` = 58 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-04-27T15:51:22+08:00 ] 124.129.96.215 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001789s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010009s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000349s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000829s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001002s ] --------------------------------------------------------------- [ 2023-04-27T15:52:26+08:00 ] 39.144.16.34 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.001774s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008683s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000695s ] --------------------------------------------------------------- [ 2023-04-27T15:52:28+08:00 ] 39.144.16.34 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682581946&v1=0.031395&v2=0.012517&v3=0.026669&v4=0.001355&v5=12.420000&t=19.291677&h=55.492920&rssi=29&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&gps=120.184668,35.984770&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002114s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009825s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000769s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682581946,`v1`=0.031395,`v2`=0.012517,`v3`=0.026669,`v4`=0.001355,`v5`=12.42,`t`=19.291677,`h`=55.49292,`rssi`=29,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`gps`='120.184668,35.984770',`update_time`=1682581948 WHERE `imei` = '868922055678110' [ RunTime:0.000885s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009453s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055678110' , 1682581946 , 0.031395 , 0.012517 , 0.026669 , 0.001355 , 12.42 , 19.291677 , 55.49292 , 29 , '898604650119C1078513' , '460048590708513' , -0 , '120.184668,35.984770' , 1682581948) [ RunTime:0.000535s ] --------------------------------------------------------------- [ 2023-04-27T16:31:23+08:00 ] 39.144.12.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002880s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010418s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000847s ] --------------------------------------------------------------- [ 2023-04-27T16:31:24+08:00 ] 39.144.12.148 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682584283&v1=0.018030&v2=0.015229&v3=0.014629&v4=-0.000090&v5=12.420000&t=17.425510&h=79.327148&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002174s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009952s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682584283,`v1`=0.01803,`v2`=0.015229,`v3`=0.014629,`v4`=-9.0E-5,`v5`=12.42,`t`=17.42551,`h`=79.327148,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682584284 WHERE `imei` = '868922055647586' [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011558s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682584283 , 0.01803 , 0.015229 , 0.014629 , -9.0E-5 , 12.42 , 17.42551 , 79.327148 , 28 , '898604650119C1078512' , '460048590708512' , -0 , 1682584284) [ RunTime:0.001223s ] --------------------------------------------------------------- [ 2023-04-27T17:10:58+08:00 ] 223.104.255.232 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002377s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011127s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000782s ] --------------------------------------------------------------- [ 2023-04-27T17:11:00+08:00 ] 223.104.255.232 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1682586658&v1=0.027361&v2=0.015855&v3=0.025074&v4=0.016043&v5=12.240000&t=17.414785&h=71.850342&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.185068,35.985692&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011695s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000772s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1682586658,`v1`=0.027361,`v2`=0.015855,`v3`=0.025074,`v4`=0.016043,`v5`=12.24,`t`=17.414785,`h`=71.850342,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.185068,35.985692',`update_time`=1682586660 WHERE `imei` = '868922056976208' [ RunTime:0.000779s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010583s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1682586658 , 0.027361 , 0.015855 , 0.025074 , 0.016043 , 12.24 , 17.414785 , 71.850342 , 28 , '898604650119C1053139' , '460048590503139' , -0 , '120.185068,35.985692' , 1682586660) [ RunTime:0.001276s ] --------------------------------------------------------------- [ 2023-04-27T17:13:20+08:00 ] 39.144.1.118 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002217s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010859s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2023-04-27T17:13:22+08:00 ] 39.144.1.118 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1682586800&v1=0.019234&v2=0.023261&v3=0.015923&v4=-0.006953&v5=12.420000&t=17.404060&h=74.169678&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001754s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009936s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1682586800,`v1`=0.019234,`v2`=0.023261,`v3`=0.015923,`v4`=-0.006953,`v5`=12.42,`t`=17.40406,`h`=74.169678,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1682586802 WHERE `imei` = '868922055684209' [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012840s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1682586800 , 0.019234 , 0.023261 , 0.015923 , -0.006953 , 12.42 , 17.40406 , 74.169678 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1682586802) [ RunTime:0.000622s ] --------------------------------------------------------------- [ 2023-04-27T17:38:21+08:00 ] 39.144.18.152 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002723s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009568s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2023-04-27T17:38:22+08:00 ] 39.144.18.152 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1682588301&v1=0.018030&v2=0.014603&v3=0.015351&v4=-0.004485&v5=12.420000&t=17.211008&h=73.788208&rssi=27&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001635s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011163s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000732s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1682588301,`v1`=0.01803,`v2`=0.014603,`v3`=0.015351,`v4`=-0.004485,`v5`=12.42,`t`=17.211008,`h`=73.788208,`rssi`=27,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1682588302 WHERE `imei` = '868922055683920' [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014310s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1682588301 , 0.01803 , 0.014603 , 0.015351 , -0.004485 , 12.42 , 17.211008 , 73.788208 , 27 , '89860426102071188500' , '460044618415250' , -0 , 1682588302) [ RunTime:0.001382s ] --------------------------------------------------------------- [ 2023-04-27T20:28:03+08:00 ] 111.55.141.101 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ 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.010453s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.001139s ] --------------------------------------------------------------- [ 2023-04-27T20:28:05+08:00 ] 111.55.141.101 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1682598483&v1=0.031154&v2=0.014499&v3=0.028084&v4=0.008338&v5=12.600000&t=16.181398&h=75.260681&rssi=17&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184860,35.985701&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001960s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009091s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1682598483,`v1`=0.031154,`v2`=0.014499,`v3`=0.028084,`v4`=0.008338,`v5`=12.6,`t`=16.181398,`h`=75.260681,`rssi`=17,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184860,35.985701',`update_time`=1682598485 WHERE `imei` = '868922055683912' [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010898s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1682598483 , 0.031154 , 0.014499 , 0.028084 , 0.008338 , 12.6 , 16.181398 , 75.260681 , 17 , '898604650119C1053138' , '460048590503138' , -0 , '120.184860,35.985701' , 1682598485) [ RunTime:0.001277s ] --------------------------------------------------------------- [ 2023-04-27T20:31:05+08:00 ] 39.144.12.73 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.003069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010015s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2023-04-27T20:31:07+08:00 ] 39.144.12.73 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1682598665&v1=0.017850&v2=0.015959&v3=0.015592&v4=-0.016344&v5=12.600000&t=16.074148&h=77.312988&rssi=29&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.186187,35.991215&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001757s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011456s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1682598665,`v1`=0.01785,`v2`=0.015959,`v3`=0.015592,`v4`=-0.016344,`v5`=12.6,`t`=16.074148,`h`=77.312988,`rssi`=29,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.186187,35.991215',`update_time`=1682598666 WHERE `imei` = '868922055683771' [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010625s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1682598665 , 0.01785 , 0.015959 , 0.015592 , -0.016344 , 12.6 , 16.074148 , 77.312988 , 29 , '898604650119C1053136' , '460048590503136' , -0 , '120.186187,35.991215' , 1682598667) [ RunTime:0.000520s ] --------------------------------------------------------------- [ 2023-04-27T23:08:35+08:00 ] 117.132.192.60 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.003004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012337s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2023-04-27T23:08:36+08:00 ] 117.132.192.60 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1682608115&v1=0.006291&v2=0.014290&v3=0.004124&v4=-0.016164&v5=12.420000&t=16.041973&h=74.619812&rssi=12&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001532s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008953s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1682608115,`v1`=0.006291,`v2`=0.01429,`v3`=0.004124,`v4`=-0.016164,`v5`=12.42,`t`=16.041973,`h`=74.619812,`rssi`=12,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1682608116 WHERE `imei` = '868922055644021' [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011093s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1682608115 , 0.006291 , 0.01429 , 0.004124 , -0.016164 , 12.42 , 16.041973 , 74.619812 , 12 , '898604650119C1053141' , '460048590503141' , -0 , 1682608116) [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2023-04-27T23:11:24+08:00 ] 221.178.125.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001968s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012052s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000808s ] --------------------------------------------------------------- [ 2023-04-27T23:11:26+08:00 ] 221.178.125.180 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1682608284&v1=0.016224&v2=0.015229&v3=0.013274&v4=-0.011829&v5=12.420000&t=16.159948&h=71.056885&rssi=27&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012301s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1682608284,`v1`=0.016224,`v2`=0.015229,`v3`=0.013274,`v4`=-0.011829,`v5`=12.42,`t`=16.159948,`h`=71.056885,`rssi`=27,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1682608286 WHERE `imei` = '868922055684548' [ RunTime:0.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010737s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1682608284 , 0.016224 , 0.015229 , 0.013274 , -0.011829 , 12.42 , 16.159948 , 71.056885 , 27 , '898604650119C1053137' , '460048590503137' , -0 , 1682608286) [ RunTime:0.000589s ] --------------------------------------------------------------- [ 2023-04-27T23:29:24+08:00 ] 117.132.191.178 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002401s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010800s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-04-27T23:29:25+08:00 ] 117.132.191.178 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1682609364&v1=0.020619&v2=0.013664&v3=0.017850&v4=-0.006652&v5=12.420000&t=16.127773&h=74.352783&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002006s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010067s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000773s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1682609364,`v1`=0.020619,`v2`=0.013664,`v3`=0.01785,`v4`=-0.006652,`v5`=12.42,`t`=16.127773,`h`=74.352783,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1682609365 WHERE `imei` = '868922055680850' [ RunTime:0.000684s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013381s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1682609364 , 0.020619 , 0.013664 , 0.01785 , -0.006652 , 12.42 , 16.127773 , 74.352783 , 25 , '898604650119C1078510' , '460048590708510' , -0 , 1682609365) [ RunTime:0.000644s ]