--------------------------------------------------------------- [ 2023-07-20T00:31:24+08:00 ] 39.144.14.185 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012356s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2023-07-20T00:31:26+08:00 ] 39.144.14.185 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1689784284&v1=0.007977&v2=0.014395&v3=0.006171&v4=-0.015863&v5=12.060000&t=29.523420&h=82.188171&rssi=11&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ 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.010886s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1689784284,`v1`=0.007977,`v2`=0.014395,`v3`=0.006171,`v4`=-0.015863,`v5`=12.06,`t`=29.52342,`h`=82.188171,`rssi`=11,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1689784286 WHERE `imei` = '868922055644021' [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010535s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1689784284 , 0.007977 , 0.014395 , 0.006171 , -0.015863 , 12.06 , 29.52342 , 82.188171 , 11 , '898604650119C1053141' , '460048590503141' , -0 , 1689784286) [ RunTime:0.000627s ] --------------------------------------------------------------- [ 2023-07-20T00:51:03+08:00 ] 111.55.140.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850 [ sql ] [ DB ] CONNECT:[ UseTime:0.002413s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010744s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-07-20T00:51:04+08:00 ] 111.55.140.41 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1689785463&v1=0.021522&v2=0.012413&v3=0.019054&v4=-0.006231&v5=12.240000&t=29.566320&h=78.884644&rssi=25&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&gps=120.186560,35.985775&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.009793s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1689785463,`v1`=0.021522,`v2`=0.012413,`v3`=0.019054,`v4`=-0.006231,`v5`=12.24,`t`=29.56632,`h`=78.884644,`rssi`=25,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`gps`='120.186560,35.985775',`update_time`=1689785464 WHERE `imei` = '868922055680850' [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011828s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055680850' , 1689785463 , 0.021522 , 0.012413 , 0.019054 , -0.006231 , 12.24 , 29.56632 , 78.884644 , 25 , '898604650119C1078510' , '460048590708510' , -0 , '120.186560,35.985775' , 1689785464) [ RunTime:0.000632s ] --------------------------------------------------------------- [ 2023-07-20T02:01:50+08:00 ] 117.132.193.176 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ 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.011748s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000734s ] --------------------------------------------------------------- [ 2023-07-20T02:01:59+08:00 ] 117.132.193.176 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230720&time=020101&v1=-01.100&v2=+00.015&v3=-00.990&v4=-00.508&v5=06.0&t=+22.7&h=78.6&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.138&a2=01.171&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001717s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012513s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230720',`time`='020101',`v1`=-1.1,`v2`=0.015,`v3`=-0.99,`v4`=-0.508,`v5`=6,`t`=22.7,`h`=78.6,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.138,`a2`=1.171,`update_time`=1689789719 WHERE `imei` = '868922055684076' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010128s ] [ 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' , '230720' , '020101' , -1.1 , 0.015 , -0.99 , -0.508 , 6 , 22.7 , 78.6 , 227 , '460044618415249' , -0 , 0.138 , 1.171 , 1689789719 , 1689789719) [ RunTime:0.000638s ] --------------------------------------------------------------- [ 2023-07-20T02:03:54+08:00 ] 39.144.14.89 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001852s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010629s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [ 2023-07-20T02:03:54+08:00 ] 111.55.136.246 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010700s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000877s ] --------------------------------------------------------------- [ 2023-07-20T02:04:02+08:00 ] 39.144.14.89 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230720&time=020301&v1=-01.319&v2=+00.022&v3=-01.020&v4=-00.027&v5=06.2&t=+25.1&h=61.9&rssi=+227&ccid=4600485905031420000099m9990000000309000001g3250,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001780s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010593s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230720',`time`='020301',`v1`=-1.319,`v2`=0.022,`v3`=-1.02,`v4`=-0.027,`v5`=6.2,`t`=25.1,`h`=61.9,`rssi`=227,`ccid`='4600485905031420000099m9990000000309000001g3250,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689789842 WHERE `imei` = '868922055643643' [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011180s ] [ 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' , '230720' , '020301' , -1.319 , 0.022 , -1.02 , -0.027 , 6.2 , 25.1 , 61.9 , 227 , '4600485905031420000099m9990000000309000001g3250,N,00E000=-00.000' , 0 , 0 , 1689789842 , 1689789842) [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-07-20T02:04:03+08:00 ] 111.55.136.246 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230720&time=020301&v1=-00.520&v2=+00.001&v3=-00.220&v4=-00.007&v5=06.0&t=+25.4&h=66.1&rssi=+224&ccid=4600485905031430000099m9990000000094000000g5230,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002049s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009533s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000662s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230720',`time`='020301',`v1`=-0.52,`v2`=0.001,`v3`=-0.22,`v4`=-0.007,`v5`=6,`t`=25.4,`h`=66.1,`rssi`=224,`ccid`='4600485905031430000099m9990000000094000000g5230,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689789843 WHERE `imei` = '868922055644013' [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009915s ] [ 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' , '230720' , '020301' , -0.52 , 0.001 , -0.22 , -0.007 , 6 , 25.4 , 66.1 , 224 , '4600485905031430000099m9990000000094000000g5230,N,00E000=-00.000' , 0 , 0 , 1689789843 , 1689789843) [ RunTime:0.000505s ] --------------------------------------------------------------- [ 2023-07-20T08:03:27+08:00 ] 124.129.68.144 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003228s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.022912s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2023-07-20T08:03:30+08:00 ] 124.129.68.144 GET /admin/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001484s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011457s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000390s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000607s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2023-07-20T08:03:32+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001705s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009928s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000551s ] --------------------------------------------------------------- [ 2023-07-20T08:54:29+08:00 ] 124.129.68.144 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002972s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011278s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-07-20T08:54:39+08:00 ] 124.129.68.144 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001490s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012975s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000405s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001624s ] --------------------------------------------------------------- [ 2023-07-20T08:55:02+08:00 ] 124.129.68.144 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002108s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011808s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000392s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000990s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000948s ] --------------------------------------------------------------- [ 2023-07-20T08:55:37+08:00 ] 124.129.68.144 GET /admin/show/index.html?page=3 [ 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.011472s ] [ 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 20,10 [ RunTime:0.001344s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001049s ] --------------------------------------------------------------- [ 2023-07-20T09:16:32+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002383s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009962s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000619s ] --------------------------------------------------------------- [ 2023-07-20T09:46:47+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002193s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012246s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000594s ] --------------------------------------------------------------- [ 2023-07-20T09:46:53+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001863s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011400s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2023-07-20T09:46:54+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001797s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010394s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000550s ] --------------------------------------------------------------- [ 2023-07-20T09:48:36+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001824s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011005s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000577s ] --------------------------------------------------------------- [ 2023-07-20T09:51:59+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010040s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2023-07-20T09:55:21+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001851s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009605s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2023-07-20T11:03:24+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012972s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2023-07-20T11:03:27+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002561s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012074s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000612s ] --------------------------------------------------------------- [ 2023-07-20T11:03:28+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.018835s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010425s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000556s ] --------------------------------------------------------------- [ 2023-07-20T11:03:29+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001719s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010471s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000563s ] --------------------------------------------------------------- [ 2023-07-20T11:03:29+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001876s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010010s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000566s ] --------------------------------------------------------------- [ 2023-07-20T11:08:24+08:00 ] 124.129.68.144 GET /admin/device/communication/id/12/unique_identification_number/862810047258784.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_device` [ RunTime:0.010246s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2023-07-20T13:02:16+08:00 ] 124.129.68.144 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002319s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.010848s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000380s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000419s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000451s ] --------------------------------------------------------------- [ 2023-07-20T13:02:18+08:00 ] 124.129.68.144 GET /admin/thermocouple/communication/id/1/unique_identification_number/15621561103.html [ sql ] [ DB ] CONNECT:[ UseTime:0.017258s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.010498s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000499s ] --------------------------------------------------------------- [ 2023-07-20T13:07:22+08:00 ] 124.129.68.144 GET /admin/device/index.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_device` [ RunTime:0.012333s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000435s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000646s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000688s ] --------------------------------------------------------------- [ 2023-07-20T13:07:25+08:00 ] 124.129.68.144 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001919s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.011841s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000353s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000380s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000457s ] --------------------------------------------------------------- [ 2023-07-20T13:07:28+08:00 ] 124.129.68.144 GET /admin/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.017772s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009608s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000379s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000643s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000644s ] --------------------------------------------------------------- [ 2023-07-20T13:07:31+08:00 ] 124.129.68.144 GET /admin/device/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001910s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010427s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000382s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000604s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2023-07-20T13:07:33+08:00 ] 124.129.68.144 GET /admin/device/communication/id/1/unique_identification_number/15621561103.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001865s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011344s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000930s ] --------------------------------------------------------------- [ 2023-07-20T13:08:44+08:00 ] 124.129.68.144 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001397s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.010139s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000389s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000424s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000461s ] --------------------------------------------------------------- [ 2023-07-20T13:08:46+08:00 ] 124.129.68.144 GET /admin/thermocouple/communication/id/1/unique_identification_number/15621561103.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.010135s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000474s ] --------------------------------------------------------------- [ 2023-07-20T13:09:43+08:00 ] 124.129.68.144 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002132s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.010851s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000399s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000443s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000551s ] --------------------------------------------------------------- [ 2023-07-20T13:09:44+08:00 ] 124.129.68.144 GET /admin/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001740s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011525s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000389s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000606s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2023-07-20T13:09:47+08:00 ] 124.129.68.144 GET /admin/device/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001731s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011604s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000393s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000583s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000615s ] --------------------------------------------------------------- [ 2023-07-20T13:09:51+08:00 ] 124.129.68.144 GET /admin/device/communication/id/1/unique_identification_number/15621561103.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012270s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000549s ] --------------------------------------------------------------- [ 2023-07-20T14:03:54+08:00 ] 39.144.12.181 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002208s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011682s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001246s ] --------------------------------------------------------------- [ 2023-07-20T14:03:55+08:00 ] 39.144.7.14 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ 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.009617s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000749s ] --------------------------------------------------------------- [ 2023-07-20T14:04:02+08:00 ] 39.144.12.181 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230720&time=140301&v1=-01.319&v2=+00.040&v3=-01.020&v4=-00.027&v5=06.4&t=+41.2&h=56.0&rssi=+228&ccid=4600485905031420000099m9990000000305000001g3240,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011285s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230720',`time`='140301',`v1`=-1.319,`v2`=0.04,`v3`=-1.02,`v4`=-0.027,`v5`=6.4,`t`=41.2,`h`=56,`rssi`=228,`ccid`='4600485905031420000099m9990000000305000001g3240,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689833042 WHERE `imei` = '868922055643643' [ RunTime:0.000664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014863s ] [ 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' , '230720' , '140301' , -1.319 , 0.04 , -1.02 , -0.027 , 6.4 , 41.2 , 56 , 228 , '4600485905031420000099m9990000000305000001g3240,N,00E000=-00.000' , 0 , 0 , 1689833042 , 1689833042) [ RunTime:0.001185s ] --------------------------------------------------------------- [ 2023-07-20T14:04:04+08:00 ] 39.144.7.14 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230720&time=140301&v1=-00.467&v2=+00.001&v3=-00.048&v4=-00.006&v5=06.2&t=+38.5&h=62.1&rssi=+223&ccid=4600485905031430000099m9990000000154000000g4710,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001517s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011674s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230720',`time`='140301',`v1`=-0.467,`v2`=0.001,`v3`=-0.048,`v4`=-0.006,`v5`=6.2,`t`=38.5,`h`=62.1,`rssi`=223,`ccid`='4600485905031430000099m9990000000154000000g4710,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1689833044 WHERE `imei` = '868922055644013' [ RunTime:0.000526s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010380s ] [ 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' , '230720' , '140301' , -0.467 , 0.001 , -0.048 , -0.006 , 6.2 , 38.5 , 62.1 , 223 , '4600485905031430000099m9990000000154000000g4710,N,00E000=-00.000' , 0 , 0 , 1689833044 , 1689833044) [ RunTime:0.000490s ] --------------------------------------------------------------- [ 2023-07-20T17:48:25+08:00 ] 218.204.252.225 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586 [ sql ] [ DB ] CONNECT:[ UseTime:0.002969s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012966s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2023-07-20T17:48:26+08:00 ] 218.204.252.225 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1689846505&v1=0.018452&v2=0.014290&v3=0.016916&v4=-0.000090&v5=12.240000&t=30.242002&h=78.854126&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.185093,35.985478&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001611s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009758s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1689846505,`v1`=0.018452,`v2`=0.01429,`v3`=0.016916,`v4`=-9.0E-5,`v5`=12.24,`t`=30.242002,`h`=78.854126,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.185093,35.985478',`update_time`=1689846506 WHERE `imei` = '868922055647586' [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011905s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055647586' , 1689846505 , 0.018452 , 0.01429 , 0.016916 , -9.0E-5 , 12.24 , 30.242002 , 78.854126 , 27 , '898604650119C1078512' , '460048590708512' , -0 , '120.185093,35.985478' , 1689846506) [ RunTime:0.000609s ] --------------------------------------------------------------- [ 2023-07-20T18:28:59+08:00 ] 111.55.141.102 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014196s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.001076s ] --------------------------------------------------------------- [ 2023-07-20T18:29:00+08:00 ] 111.55.141.102 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1689848939&v1=0.027903&v2=0.013247&v3=0.032087&v4=0.015502&v5=12.240000&t=30.081125&h=77.038330&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.186016,35.984684&end=$ [ 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.010146s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1689848939,`v1`=0.027903,`v2`=0.013247,`v3`=0.032087,`v4`=0.015502,`v5`=12.24,`t`=30.081125,`h`=77.03833,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.186016,35.984684',`update_time`=1689848940 WHERE `imei` = '868922056976208' [ RunTime:0.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011444s ] [ 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' , 1689848939 , 0.027903 , 0.013247 , 0.032087 , 0.015502 , 12.24 , 30.081125 , 77.03833 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.186016,35.984684' , 1689848940) [ RunTime:0.000597s ] --------------------------------------------------------------- [ 2023-07-20T18:37:21+08:00 ] 39.144.13.163 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002516s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012512s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000701s ] --------------------------------------------------------------- [ 2023-07-20T18:37:22+08:00 ] 39.144.13.163 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1689849441&v1=0.021341&v2=0.012621&v3=0.018482&v4=-0.006712&v5=12.420000&t=30.091850&h=79.250854&rssi=26&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001639s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010473s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000733s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1689849441,`v1`=0.021341,`v2`=0.012621,`v3`=0.018482,`v4`=-0.006712,`v5`=12.42,`t`=30.09185,`h`=79.250854,`rssi`=26,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1689849442 WHERE `imei` = '868922055684209' [ RunTime:0.000571s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010337s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1689849441 , 0.021341 , 0.012621 , 0.018482 , -0.006712 , 12.42 , 30.09185 , 79.250854 , 26 , '898604650119C1078511' , '460048590708511' , -0 , 1689849442) [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2023-07-20T19:02:21+08:00 ] 39.144.16.222 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002312s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012246s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2023-07-20T19:02:22+08:00 ] 39.144.16.222 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1689850941&v1=0.019234&v2=0.014603&v3=0.017247&v4=-0.004726&v5=12.420000&t=30.027500&h=85.247559&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009887s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1689850941,`v1`=0.019234,`v2`=0.014603,`v3`=0.017247,`v4`=-0.004726,`v5`=12.42,`t`=30.0275,`h`=85.247559,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1689850942 WHERE `imei` = '868922055683920' [ RunTime:0.000601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011827s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1689850941 , 0.019234 , 0.014603 , 0.017247 , -0.004726 , 12.42 , 30.0275 , 85.247559 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1689850942) [ RunTime:0.000607s ] --------------------------------------------------------------- [ 2023-07-20T21:23:02+08:00 ] 218.204.252.133 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110 [ sql ] [ DB ] CONNECT:[ UseTime:0.002709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014033s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000849s ] --------------------------------------------------------------- [ 2023-07-20T21:23:04+08:00 ] 218.204.252.133 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1689859382&v1=0.030793&v2=0.013664&v3=0.030010&v4=0.001234&v5=12.240000&t=29.662848&h=79.670471&rssi=28&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&gps=120.184850,35.984777&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002420s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010889s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1689859382,`v1`=0.030793,`v2`=0.013664,`v3`=0.03001,`v4`=0.001234,`v5`=12.24,`t`=29.662848,`h`=79.670471,`rssi`=28,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`gps`='120.184850,35.984777',`update_time`=1689859384 WHERE `imei` = '868922055678110' [ RunTime:0.000871s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011345s ] [ 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' , 1689859382 , 0.030793 , 0.013664 , 0.03001 , 0.001234 , 12.24 , 29.662848 , 79.670471 , 28 , '898604650119C1078513' , '460048590708513' , -0 , '120.184850,35.984777' , 1689859384) [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2023-07-20T21:24:22+08:00 ] 117.132.193.183 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001560s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011706s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2023-07-20T21:24:23+08:00 ] 117.132.193.183 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1689859462&v1=0.017187&v2=0.015333&v3=0.016525&v4=-0.011649&v5=12.240000&t=29.812998&h=79.212708&rssi=30&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001715s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010838s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1689859462,`v1`=0.017187,`v2`=0.015333,`v3`=0.016525,`v4`=-0.011649,`v5`=12.24,`t`=29.812998,`h`=79.212708,`rssi`=30,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1689859463 WHERE `imei` = '868922055684548' [ RunTime:0.000553s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010756s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1689859462 , 0.017187 , 0.015333 , 0.016525 , -0.011649 , 12.24 , 29.812998 , 79.212708 , 30 , '898604650119C1053137' , '460048590503137' , -0 , 1689859463) [ RunTime:0.000521s ] --------------------------------------------------------------- [ 2023-07-20T21:40:03+08:00 ] 117.132.195.29 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002734s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012599s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-07-20T21:40:04+08:00 ] 117.132.195.29 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1689860403&v1=0.032117&v2=0.014186&v3=0.031365&v4=0.007736&v5=12.420000&t=29.673573&h=83.736938&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.186708,35.986250&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002038s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011579s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1689860403,`v1`=0.032117,`v2`=0.014186,`v3`=0.031365,`v4`=0.007736,`v5`=12.42,`t`=29.673573,`h`=83.736938,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.186708,35.986250',`update_time`=1689860404 WHERE `imei` = '868922055683912' [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011071s ] [ 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' , 1689860403 , 0.032117 , 0.014186 , 0.031365 , 0.007736 , 12.42 , 29.673573 , 83.736938 , 18 , '898604650119C1053138' , '460048590503138' , -0 , '120.186708,35.986250' , 1689860404) [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-07-20T21:51:06+08:00 ] 117.132.194.92 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002909s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012279s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000760s ]