--------------------------------------------------------------- [ 2023-03-09T02:03:54+08:00 ] 117.132.198.98 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002255s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012215s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2023-03-09T02:03:55+08:00 ] 218.204.252.67 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010582s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000644s ] --------------------------------------------------------------- [ 2023-03-09T02:04:03+08:00 ] 117.132.198.98 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230309&time=020301&v1=-01.323&v2=+00.015&v3=-00.971&v4=-00.017&v5=06.0&t=+02.3&h=63.5&rssi=+229&ccid=4600485905031420000099m9990000000352000001g3350,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002044s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011154s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230309',`time`='020301',`v1`=-1.323,`v2`=0.015,`v3`=-0.971,`v4`=-0.017,`v5`=6,`t`=2.3,`h`=63.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000352000001g3350,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678298643 WHERE `imei` = '868922055643643' [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010886s ] [ 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' , '230309' , '020301' , -1.323 , 0.015 , -0.971 , -0.017 , 6 , 2.3 , 63.5 , 229 , '4600485905031420000099m9990000000352000001g3350,N,00E000=-00.000' , 0 , 0 , 1678298643 , 1678298643) [ RunTime:0.000628s ] --------------------------------------------------------------- [ 2023-03-09T02:04:04+08:00 ] 218.204.252.67 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230309&time=020301&v1=-00.242&v2=+00.001&v3=-00.091&v4=-00.017&v5=05.7&t=+03.3&h=66.2&rssi=+223&ccid=4600485905031430000099m9990000000046000000g2650,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.009124s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010363s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230309',`time`='020301',`v1`=-0.242,`v2`=0.001,`v3`=-0.091,`v4`=-0.017,`v5`=5.7,`t`=3.3,`h`=66.2,`rssi`=223,`ccid`='4600485905031430000099m9990000000046000000g2650,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678298644 WHERE `imei` = '868922055644013' [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009484s ] [ 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' , '230309' , '020301' , -0.242 , 0.001 , -0.091 , -0.017 , 5.7 , 3.3 , 66.2 , 223 , '4600485905031430000099m9990000000046000000g2650,N,00E000=-00.000' , 0 , 0 , 1678298644 , 1678298644) [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2023-03-09T06:08:50+08:00 ] 39.144.4.30 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002524s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010677s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2023-03-09T06:08:59+08:00 ] 39.144.4.30 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230309&time=060801&v1=-01.268&v2=+00.023&v3=-00.988&v4=-00.654&v5=05.6&t=+03.2&h=81.8&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.308&a2=01.284&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001936s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010056s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000765s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230309',`time`='060801',`v1`=-1.268,`v2`=0.023,`v3`=-0.988,`v4`=-0.654,`v5`=5.6,`t`=3.2,`h`=81.8,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.308,`a2`=1.284,`update_time`=1678313339 WHERE `imei` = '868922055684076' [ RunTime:0.001632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010266s ] [ 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' , '230309' , '060801' , -1.268 , 0.023 , -0.988 , -0.654 , 5.6 , 3.2 , 81.8 , 227 , '460044618415249' , -0 , 0.308 , 1.284 , 1678313339 , 1678313339) [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-03-09T08:38:06+08:00 ] 123.234.141.218 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002392s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012396s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000729s ] --------------------------------------------------------------- [ 2023-03-09T08:38:14+08:00 ] 123.234.141.218 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002299s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011744s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000419s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000847s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000759s ] --------------------------------------------------------------- [ 2023-03-09T08:38:19+08:00 ] 123.234.141.218 GET /admin/show/read/id/40/imei/868922055683771.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001750s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011066s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010866s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683771' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2023-03-09T08:38:28+08:00 ] 123.234.141.218 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002596s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009432s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000375s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000735s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2023-03-09T08:38:29+08:00 ] 123.234.141.218 GET /admin/show/read/id/40/imei/868922055683771.html [ 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.010546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000961s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010215s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000543s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683771' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000969s ] --------------------------------------------------------------- [ 2023-03-09T08:53:23+08:00 ] 123.234.141.218 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002275s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010434s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000438s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001088s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000760s ] --------------------------------------------------------------- [ 2023-03-09T08:53:26+08:00 ] 123.234.141.218 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002035s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009610s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000398s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000832s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000726s ] --------------------------------------------------------------- [ 2023-03-09T08:53:34+08:00 ] 123.234.141.218 GET /admin/show/index.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.001836s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009837s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000357s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001039s ] --------------------------------------------------------------- [ 2023-03-09T08:53:40+08:00 ] 123.234.141.218 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001849s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010065s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000741s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011315s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006051s ] --------------------------------------------------------------- [ 2023-03-09T08:56:32+08:00 ] 39.144.11.226 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002475s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011085s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2023-03-09T08:56:33+08:00 ] 39.144.11.226 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1678323392&v1=0.024712&v2=7.716403&v3=0.024441&v4=0.024592&v5=13.140000&t=17.875965&h=51.884216&rssi=15&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002799s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009913s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1678323392,`v1`=0.024712,`v2`=7.716403,`v3`=0.024441,`v4`=0.024592,`v5`=13.14,`t`=17.875965,`h`=51.884216,`rssi`=15,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1678323393 WHERE `imei` = '868922056976208' [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009952s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1678323392 , 0.024712 , 7.716403 , 0.024441 , 0.024592 , 13.14 , 17.875965 , 51.884216 , 15 , '898604650119C1053139' , '460048590503139' , -0 , 1678323393) [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2023-03-09T08:56:38+08:00 ] 123.234.141.218 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010865s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000773s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011576s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003005s ] --------------------------------------------------------------- [ 2023-03-09T08:56:39+08:00 ] 123.234.141.218 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001878s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011692s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000773s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011400s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000722s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002924s ] --------------------------------------------------------------- [ 2023-03-09T08:59:18+08:00 ] 123.234.141.218 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010703s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011702s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003045s ] --------------------------------------------------------------- [ 2023-03-09T08:59:19+08:00 ] 123.234.141.218 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001998s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010319s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.001331s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009541s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004511s ] --------------------------------------------------------------- [ 2023-03-09T09:00:25+08:00 ] 218.204.253.168 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009668s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000676s ] --------------------------------------------------------------- [ 2023-03-09T09:00:27+08:00 ] 218.204.253.168 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1678323625&v1=0.024411&v2=1.517683&v3=0.024472&v4=0.024592&v5=13.140000&t=18.605270&h=46.215576&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010623s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1678323625,`v1`=0.024411,`v2`=1.517683,`v3`=0.024472,`v4`=0.024592,`v5`=13.14,`t`=18.60527,`h`=46.215576,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1678323627 WHERE `imei` = '868922056976208' [ RunTime:0.000720s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011211s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1678323625 , 0.024411 , 1.517683 , 0.024472 , 0.024592 , 13.14 , 18.60527 , 46.215576 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1678323627) [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2023-03-09T09:00:29+08:00 ] 218.204.253.168 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1678323481&v1=0.024411&v2=3.650159&v3=0.024441&v4=0.024592&v5=13.320000&t=18.669622&h=49.366516&rssi=16&ccid=898604650119C1053139&imsi=460048590503139&v6=-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.011008s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000767s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1678323481,`v1`=0.024411,`v2`=3.650159,`v3`=0.024441,`v4`=0.024592,`v5`=13.32,`t`=18.669622,`h`=49.366516,`rssi`=16,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1678323629 WHERE `imei` = '868922056976208' [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011224s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1678323481 , 0.024411 , 3.650159 , 0.024441 , 0.024592 , 13.32 , 18.669622 , 49.366516 , 16 , '898604650119C1053139' , '460048590503139' , -0 , 1678323629) [ RunTime:0.000519s ] --------------------------------------------------------------- [ 2023-03-09T09:00:39+08:00 ] 123.234.141.218 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001387s ] 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 * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011297s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000725s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002941s ] --------------------------------------------------------------- [ 2023-03-09T10:09:30+08:00 ] 123.232.5.21 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002366s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010298s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000630s ] --------------------------------------------------------------- [ 2023-03-09T10:09:31+08:00 ] 123.232.5.21 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001546s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010644s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000798s ] --------------------------------------------------------------- [ 2023-03-09T10:09:35+08:00 ] 123.232.5.21 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002313s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012547s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000533s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000770s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013394s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.000496s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.000514s ] --------------------------------------------------------------- [ 2023-03-09T10:09:59+08:00 ] 123.232.5.21 GET /home/data/index.html?keyword=868922055644013&start_date=2022-11-09&end_date=2023-03-09 [ sql ] [ DB ] CONNECT:[ UseTime:0.002241s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009241s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000775s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000490s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000550s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000699s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011003s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1667923200 AND `update_time` <= 1678291200 ) LIMIT 1 [ RunTime:0.004435s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1667923200 AND `update_time` <= 1678291200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.005809s ] --------------------------------------------------------------- [ 2023-03-09T10:25:27+08:00 ] 58.56.115.254 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002087s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010278s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000672s ] --------------------------------------------------------------- [ 2023-03-09T10:26:54+08:00 ] 58.56.115.254 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001907s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010169s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'admin' AND `password` = '207ea1d1d8f95cae50c603ed91e5f3cf' LIMIT 1 [ RunTime:0.000547s ] --------------------------------------------------------------- [ 2023-03-09T10:29:42+08:00 ] 58.56.115.254 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001613s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010611s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = '9f8434419a69997f96bbc41d3d27b1bd' LIMIT 1 [ RunTime:0.000614s ] --------------------------------------------------------------- [ 2023-03-09T10:29:56+08:00 ] 58.56.115.254 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002216s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010552s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'aa6164cff40797f0fa7ddaa3523abc8a' LIMIT 1 [ RunTime:0.000599s ] --------------------------------------------------------------- [ 2023-03-09T10:54:05+08:00 ] 218.204.252.27 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002463s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012451s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000761s ] --------------------------------------------------------------- [ 2023-03-09T10:54:07+08:00 ] 218.204.252.27 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678330445&v1=0.015321&v2=0.669867&v3=0.015472&v4=0.015622&v5=12.420000&t=20.750290&h=50.716919&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001961s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010982s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1678330445,`v1`=0.015321,`v2`=0.669867,`v3`=0.015472,`v4`=0.015622,`v5`=12.42,`t`=20.75029,`h`=50.716919,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678330447 WHERE `imei` = '868922055683920' [ RunTime:0.000662s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012405s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678330445 , 0.015321 , 0.669867 , 0.015472 , 0.015622 , 12.42 , 20.75029 , 50.716919 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678330447) [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2023-03-09T10:56:26+08:00 ] 39.144.10.52 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011181s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2023-03-09T10:56:27+08:00 ] 39.144.10.52 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678330586&v1=0.015502&v2=1.198083&v3=0.015682&v4=0.015983&v5=12.960000&t=21.844250&h=49.473328&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001735s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012444s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1678330586,`v1`=0.015502,`v2`=1.198083,`v3`=0.015682,`v4`=0.015983,`v5`=12.96,`t`=21.84425,`h`=49.473328,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678330587 WHERE `imei` = '868922055683920' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009990s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678330586 , 0.015502 , 1.198083 , 0.015682 , 0.015983 , 12.96 , 21.84425 , 49.473328 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678330587) [ RunTime:0.000525s ] --------------------------------------------------------------- [ 2023-03-09T10:57:47+08:00 ] 123.234.141.218 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001411s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010335s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000390s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000798s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000734s ] --------------------------------------------------------------- [ 2023-03-09T10:58:34+08:00 ] 123.234.141.218 GET /admin/show/read/id/30/imei/868922055683920.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002073s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010921s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011123s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683920' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003061s ] --------------------------------------------------------------- [ 2023-03-09T11:06:42+08:00 ] 123.234.141.218 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002285s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010812s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000459s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000884s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000875s ] --------------------------------------------------------------- [ 2023-03-09T11:06:45+08:00 ] 123.234.141.218 GET /admin/show/read/id/39/imei/868922055684548.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001883s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009730s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010872s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000517s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000814s ] --------------------------------------------------------------- [ 2023-03-09T11:09:30+08:00 ] 39.144.7.143 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002348s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010762s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000633s ] --------------------------------------------------------------- [ 2023-03-09T11:09:31+08:00 ] 39.144.7.143 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678331370&v1=0.012732&v2=2.188593&v3=0.013124&v4=0.013455&v5=12.780000&t=20.160410&h=51.090759&rssi=14&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001883s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011620s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678331370,`v1`=0.012732,`v2`=2.188593,`v3`=0.013124,`v4`=0.013455,`v5`=12.78,`t`=20.16041,`h`=51.090759,`rssi`=14,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678331371 WHERE `imei` = '868922055684548' [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011565s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678331370 , 0.012732 , 2.188593 , 0.013124 , 0.013455 , 12.78 , 20.16041 , 51.090759 , 14 , '898604650119C1053137' , '460048590503137' , -0 , 1678331371) [ RunTime:0.000537s ] --------------------------------------------------------------- [ 2023-03-09T11:09:48+08:00 ] 123.234.141.218 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001769s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009463s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000410s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000743s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000767s ] --------------------------------------------------------------- [ 2023-03-09T11:11:27+08:00 ] 39.144.10.28 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002103s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010620s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000702s ] --------------------------------------------------------------- [ 2023-03-09T11:11:28+08:00 ] 39.144.10.28 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678331487&v1=0.012913&v2=0.963807&v3=0.013395&v4=0.013635&v5=12.780000&t=21.683374&h=46.772522&rssi=15&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002042s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010788s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678331487,`v1`=0.012913,`v2`=0.963807,`v3`=0.013395,`v4`=0.013635,`v5`=12.78,`t`=21.683374,`h`=46.772522,`rssi`=15,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678331488 WHERE `imei` = '868922055684548' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009847s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678331487 , 0.012913 , 0.963807 , 0.013395 , 0.013635 , 12.78 , 21.683374 , 46.772522 , 15 , '898604650119C1053137' , '460048590503137' , -0 , 1678331488) [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-03-09T11:15:12+08:00 ] 223.104.255.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.003041s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010972s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000686s ] --------------------------------------------------------------- [ 2023-03-09T11:15:14+08:00 ] 223.104.255.46 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678331712&v1=0.011528&v2=11.496112&v3=0.012943&v4=0.013575&v5=12.420000&t=22.391230&h=45.582336&rssi=15&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.002091s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010797s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000795s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678331712,`v1`=0.011528,`v2`=11.496112,`v3`=0.012943,`v4`=0.013575,`v5`=12.42,`t`=22.39123,`h`=45.582336,`rssi`=15,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678331714 WHERE `imei` = '868922055684548' [ RunTime:0.000688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012952s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678331712 , 0.011528 , 11.496112 , 0.012943 , 0.013575 , 12.42 , 22.39123 , 45.582336 , 15 , '898604650119C1053137' , '460048590503137' , -0 , 1678331714) [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2023-03-09T11:17:31+08:00 ] 39.144.17.113 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001851s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000727s ] --------------------------------------------------------------- [ 2023-03-09T11:17:32+08:00 ] 39.144.17.113 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678331851&v1=0.013033&v2=0.832692&v3=0.013304&v4=0.013635&v5=12.780000&t=22.562832&h=44.125122&rssi=15&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001643s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010114s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678331851,`v1`=0.013033,`v2`=0.832692,`v3`=0.013304,`v4`=0.013635,`v5`=12.78,`t`=22.562832,`h`=44.125122,`rssi`=15,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678331852 WHERE `imei` = '868922055684548' [ RunTime:0.000782s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009876s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678331851 , 0.013033 , 0.832692 , 0.013304 , 0.013635 , 12.78 , 22.562832 , 44.125122 , 15 , '898604650119C1053137' , '460048590503137' , -0 , 1678331852) [ RunTime:0.000500s ] --------------------------------------------------------------- [ 2023-03-09T11:23:13+08:00 ] 117.132.191.221 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010558s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000695s ] --------------------------------------------------------------- [ 2023-03-09T11:23:15+08:00 ] 117.132.191.221 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678332193&v1=0.012793&v2=2.218112&v3=0.013033&v4=0.013395&v5=12.780000&t=21.511772&h=47.009033&rssi=16&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end= [ 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.010889s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678332193,`v1`=0.012793,`v2`=2.218112,`v3`=0.013033,`v4`=0.013395,`v5`=12.78,`t`=21.511772,`h`=47.009033,`rssi`=16,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678332195 WHERE `imei` = '868922055684548' [ RunTime:0.000523s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010129s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678332193 , 0.012793 , 2.218112 , 0.013033 , 0.013395 , 12.78 , 21.511772 , 47.009033 , 16 , '898604650119C1053137' , '460048590503137' , -0 , 1678332195) [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2023-03-09T11:30:04+08:00 ] 123.234.141.218 GET /admin/show/read/id/39/imei/868922055684548.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003420s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013685s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 39 LIMIT 1 [ RunTime:0.001149s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013841s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.002474s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001531s ] --------------------------------------------------------------- [ 2023-03-09T11:32:35+08:00 ] 123.234.141.218 GET /admin/show/read/id/39/imei/868922055684548.html [ 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.010941s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011434s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000551s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000874s ] --------------------------------------------------------------- [ 2023-03-09T11:32:36+08:00 ] 123.234.141.218 GET /admin/show/read/id/39/imei/868922055684548.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001903s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009871s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000701s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012571s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000521s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000924s ] --------------------------------------------------------------- [ 2023-03-09T11:33:25+08:00 ] 39.144.14.157 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001684s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010060s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-03-09T11:33:26+08:00 ] 39.144.14.157 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678332805&v1=0.012793&v2=2.687290&v3=0.013184&v4=0.013455&v5=12.780000&t=21.543947&h=49.496216&rssi=16&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001839s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011525s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678332805,`v1`=0.012793,`v2`=2.68729,`v3`=0.013184,`v4`=0.013455,`v5`=12.78,`t`=21.543947,`h`=49.496216,`rssi`=16,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678332806 WHERE `imei` = '868922055684548' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009856s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678332805 , 0.012793 , 2.68729 , 0.013184 , 0.013455 , 12.78 , 21.543947 , 49.496216 , 16 , '898604650119C1053137' , '460048590503137' , -0 , 1678332806) [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2023-03-09T11:33:29+08:00 ] 39.144.14.157 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1575515471&v1=0.012853&v2=2.073854&v3=0.013094&v4=0.013455&v5=13.140000&t=22.090927&h=46.581787&rssi=16&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001990s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009760s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1575515471,`v1`=0.012853,`v2`=2.073854,`v3`=0.013094,`v4`=0.013455,`v5`=13.14,`t`=22.090927,`h`=46.581787,`rssi`=16,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678332809 WHERE `imei` = '868922055684548' [ RunTime:0.000562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011649s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1575515471 , 0.012853 , 2.073854 , 0.013094 , 0.013455 , 13.14 , 22.090927 , 46.581787 , 16 , '898604650119C1053137' , '460048590503137' , -0 , 1678332809) [ RunTime:0.000561s ] --------------------------------------------------------------- [ 2023-03-09T11:33:31+08:00 ] 123.234.141.218 GET /admin/show/read/id/39/imei/868922055684548.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002116s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011182s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011362s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000513s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000899s ] --------------------------------------------------------------- [ 2023-03-09T11:33:33+08:00 ] 123.234.141.218 GET /admin/show/read/id/39/imei/868922055684548.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002121s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011270s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009121s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000503s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000862s ] --------------------------------------------------------------- [ 2023-03-09T11:33:39+08:00 ] 123.234.141.218 GET /admin/show/read/id/39/imei/868922055684548.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001704s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009549s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010516s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000506s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000897s ] --------------------------------------------------------------- [ 2023-03-09T11:35:28+08:00 ] 39.144.16.50 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001854s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011206s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-03-09T11:35:29+08:00 ] 39.144.16.50 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678332928&v1=0.012973&v2=0.930741&v3=0.013304&v4=0.013696&v5=12.780000&t=22.477032&h=44.262451&rssi=16&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001782s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011213s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000699s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678332928,`v1`=0.012973,`v2`=0.930741,`v3`=0.013304,`v4`=0.013696,`v5`=12.78,`t`=22.477032,`h`=44.262451,`rssi`=16,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678332929 WHERE `imei` = '868922055684548' [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011078s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678332928 , 0.012973 , 0.930741 , 0.013304 , 0.013696 , 12.78 , 22.477032 , 44.262451 , 16 , '898604650119C1053137' , '460048590503137' , -0 , 1678332929) [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2023-03-09T11:39:28+08:00 ] 111.55.137.160 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002434s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010282s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000754s ] --------------------------------------------------------------- [ 2023-03-09T11:39:29+08:00 ] 111.55.137.160 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678333168&v1=0.013094&v2=1.125276&v3=0.013274&v4=0.013635&v5=12.420000&t=22.691534&h=43.697876&rssi=16&ccid=898604650119C1053137&imsi=460048590503137&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.012562s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678333168,`v1`=0.013094,`v2`=1.125276,`v3`=0.013274,`v4`=0.013635,`v5`=12.42,`t`=22.691534,`h`=43.697876,`rssi`=16,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678333169 WHERE `imei` = '868922055684548' [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011218s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678333168 , 0.013094 , 1.125276 , 0.013274 , 0.013635 , 12.42 , 22.691534 , 43.697876 , 16 , '898604650119C1053137' , '460048590503137' , -0 , 1678333169) [ RunTime:0.000486s ] --------------------------------------------------------------- [ 2023-03-09T11:39:31+08:00 ] 111.55.137.160 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678333021&v1=0.013094&v2=1.002088&v3=0.013334&v4=0.013575&v5=13.320000&t=22.938210&h=42.980713&rssi=16&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001683s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009005s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678333021,`v1`=0.013094,`v2`=1.002088,`v3`=0.013334,`v4`=0.013575,`v5`=13.32,`t`=22.93821,`h`=42.980713,`rssi`=16,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678333171 WHERE `imei` = '868922055684548' [ RunTime:0.000964s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010568s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678333021 , 0.013094 , 1.002088 , 0.013334 , 0.013575 , 13.32 , 22.93821 , 42.980713 , 16 , '898604650119C1053137' , '460048590503137' , -0 , 1678333171) [ RunTime:0.000496s ] --------------------------------------------------------------- [ 2023-03-09T11:39:37+08:00 ] 123.234.141.218 GET /admin/show/read/id/39/imei/868922055684548.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011021s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000780s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010447s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000525s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684548' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000922s ] --------------------------------------------------------------- [ 2023-03-09T11:41:50+08:00 ] 39.144.6.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002361s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010311s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2023-03-09T11:41:52+08:00 ] 39.144.6.75 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1678333310&v1=0.014298&v2=6.947651&v3=0.014960&v4=0.015381&v5=12.780000&t=18.165543&h=56.042236&rssi=16&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002904s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013875s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.001317s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1678333310,`v1`=0.014298,`v2`=6.947651,`v3`=0.01496,`v4`=0.015381,`v5`=12.78,`t`=18.165543,`h`=56.042236,`rssi`=16,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1678333312 WHERE `imei` = '868922055683771' [ RunTime:0.000698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013738s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1678333310 , 0.014298 , 6.947651 , 0.01496 , 0.015381 , 12.78 , 18.165543 , 56.042236 , 16 , '898604650119C1053136' , '460048590503136' , -0 , 1678333312) [ RunTime:0.000819s ] --------------------------------------------------------------- [ 2023-03-09T11:42:23+08:00 ] 123.234.141.218 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001878s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011903s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000486s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000906s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000787s ] --------------------------------------------------------------- [ 2023-03-09T11:42:54+08:00 ] 123.234.141.218 GET /admin/show/read/id/40/imei/868922055683771.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_show` [ RunTime:0.009776s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012181s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000499s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683771' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000768s ] --------------------------------------------------------------- [ 2023-03-09T12:26:40+08:00 ] 223.80.202.168 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003498s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010170s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.001143s ] --------------------------------------------------------------- [ 2023-03-09T12:26:41+08:00 ] 223.80.202.168 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001672s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012496s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000799s ] --------------------------------------------------------------- [ 2023-03-09T12:26:51+08:00 ] 223.80.202.168 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001897s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010947s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000574s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000797s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000647s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012176s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.000455s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.000507s ] --------------------------------------------------------------- [ 2023-03-09T12:27:08+08:00 ] 223.80.202.168 GET /home/data/index.html?keyword=868922055684076&start_date=2023-01-01&end_date=2023-03-09 [ sql ] [ DB ] CONNECT:[ UseTime:0.001739s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010268s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000828s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000480s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000536s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011476s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1672502400 AND `update_time` <= 1678291200 ) LIMIT 1 [ RunTime:0.018869s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' AND ( `update_time` >= 1672502400 AND `update_time` <= 1678291200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.011729s ] --------------------------------------------------------------- [ 2023-03-09T12:54:08+08:00 ] 221.178.125.122 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.003296s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012431s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2023-03-09T12:54:09+08:00 ] 221.178.125.122 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1678337648&v1=0.015201&v2=1.487017&v3=0.015201&v4=0.015622&v5=12.780000&t=21.104219&h=46.551270&rssi=17&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002467s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011569s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000782s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1678337648,`v1`=0.015201,`v2`=1.487017,`v3`=0.015201,`v4`=0.015622,`v5`=12.78,`t`=21.104219,`h`=46.55127,`rssi`=17,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1678337649 WHERE `imei` = '868922055683771' [ RunTime:0.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010570s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1678337648 , 0.015201 , 1.487017 , 0.015201 , 0.015622 , 12.78 , 21.104219 , 46.55127 , 17 , '898604650119C1053136' , '460048590503136' , -0 , 1678337649) [ RunTime:0.000888s ] --------------------------------------------------------------- [ 2023-03-09T13:07:17+08:00 ] 123.234.141.218 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002251s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009689s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000428s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000832s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000748s ] --------------------------------------------------------------- [ 2023-03-09T13:07:20+08:00 ] 123.234.141.218 GET /admin/show/read/id/37/imei/868922055683912.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001539s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011359s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000515s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055683912' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000868s ] --------------------------------------------------------------- [ 2023-03-09T13:10:56+08:00 ] 221.178.125.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002403s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011137s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-03-09T13:10:57+08:00 ] 221.178.125.149 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678338656&v1=0.027542&v2=7.109225&v3=0.021672&v4=0.027903&v5=12.960000&t=20.589415&h=49.267334&rssi=15&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011225s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1678338656,`v1`=0.027542,`v2`=7.109225,`v3`=0.021672,`v4`=0.027903,`v5`=12.96,`t`=20.589415,`h`=49.267334,`rssi`=15,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678338657 WHERE `imei` = '868922055683912' [ RunTime:0.000592s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013112s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678338656 , 0.027542 , 7.109225 , 0.021672 , 0.027903 , 12.96 , 20.589415 , 49.267334 , 15 , '898604650119C1053138' , '460048590503138' , -0 , 1678338657) [ RunTime:0.000513s ] --------------------------------------------------------------- [ 2023-03-09T13:15:41+08:00 ] 123.234.141.218 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001988s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011389s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000368s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000793s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000745s ] --------------------------------------------------------------- [ 2023-03-09T13:15:44+08:00 ] 123.234.141.218 GET /admin/show/read/id/35/imei/868922056976208.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002395s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009701s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000746s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010722s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976208' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003269s ] --------------------------------------------------------------- [ 2023-03-09T13:17:42+08:00 ] 223.104.254.192 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002092s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009744s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000727s ] --------------------------------------------------------------- [ 2023-03-09T13:17:44+08:00 ] 223.104.254.192 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1678339062&v1=0.024110&v2=1.854077&v3=0.024050&v4=0.024652&v5=12.420000&t=18.755423&h=55.279297&rssi=17&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001710s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010240s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1678339062,`v1`=0.02411,`v2`=1.854077,`v3`=0.02405,`v4`=0.024652,`v5`=12.42,`t`=18.755423,`h`=55.279297,`rssi`=17,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1678339064 WHERE `imei` = '868922056976208' [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010623s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1678339062 , 0.02411 , 1.854077 , 0.02405 , 0.024652 , 12.42 , 18.755423 , 55.279297 , 17 , '898604650119C1053139' , '460048590503139' , -0 , 1678339064) [ RunTime:0.000583s ] --------------------------------------------------------------- [ 2023-03-09T14:02:27+08:00 ] 223.80.202.168 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002403s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014826s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.001658s ] --------------------------------------------------------------- [ 2023-03-09T14:03:54+08:00 ] 39.144.2.63 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.004181s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009848s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000730s ] --------------------------------------------------------------- [ 2023-03-09T14:03:55+08:00 ] 39.144.11.39 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001788s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021345s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000736s ] --------------------------------------------------------------- [ 2023-03-09T14:04:03+08:00 ] 39.144.2.63 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230309&time=140301&v1=-00.248&v2=+00.001&v3=+00.019&v4=-00.016&v5=06.0&t=+25.9&h=63.8&rssi=+225&ccid=4600485905031430000099m9990000000041000000g2890,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001522s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013133s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230309',`time`='140301',`v1`=-0.248,`v2`=0.001,`v3`=0.019,`v4`=-0.016,`v5`=6,`t`=25.9,`h`=63.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000041000000g2890,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678341843 WHERE `imei` = '868922055644013' [ RunTime:0.000594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012035s ] [ 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' , '230309' , '140301' , -0.248 , 0.001 , 0.019 , -0.016 , 6 , 25.9 , 63.8 , 225 , '4600485905031430000099m9990000000041000000g2890,N,00E000=-00.000' , 0 , 0 , 1678341843 , 1678341843) [ RunTime:0.000631s ] --------------------------------------------------------------- [ 2023-03-09T14:16:07+08:00 ] 223.80.202.168 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003344s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011853s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000867s ] --------------------------------------------------------------- [ 2023-03-09T14:48:57+08:00 ] 39.144.5.146 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002939s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011933s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000802s ] --------------------------------------------------------------- [ 2023-03-09T14:48:58+08:00 ] 39.144.5.146 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1678344537&v1=0.007194&v2=0.378326&v3=0.007375&v4=0.007615&v5=12.240000&t=19.227219&h=60.574146&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010121s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1678344537,`v1`=0.007194,`v2`=0.378326,`v3`=0.007375,`v4`=0.007615,`v5`=12.24,`t`=19.227219,`h`=60.574146,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1678344538 WHERE `imei` = '868922055677740' [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011981s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1678344537 , 0.007194 , 0.378326 , 0.007375 , 0.007615 , 12.24 , 19.227219 , 60.574146 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1678344538) [ RunTime:0.000668s ] --------------------------------------------------------------- [ 2023-03-09T15:29:37+08:00 ] 111.55.136.90 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002058s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010765s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2023-03-09T15:29:39+08:00 ] 111.55.136.90 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678346977&v1=0.029227&v2=0.570774&v3=0.028234&v4=0.028505&v5=5.400000&t=19.323853&h=54.440063&rssi=18&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001868s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009815s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1678346977,`v1`=0.029227,`v2`=0.570774,`v3`=0.028234,`v4`=0.028505,`v5`=5.4,`t`=19.323853,`h`=54.440063,`rssi`=18,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678346979 WHERE `imei` = '868922055683912' [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013051s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678346977 , 0.029227 , 0.570774 , 0.028234 , 0.028505 , 5.4 , 19.323853 , 54.440063 , 18 , '898604650119C1053138' , '460048590503138' , -0 , 1678346979) [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-03-09T15:34:33+08:00 ] 39.144.1.155 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ 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.010650s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000648s ] --------------------------------------------------------------- [ 2023-03-09T15:34:35+08:00 ] 39.144.1.155 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678347273&v1=-0.987743&v2=0.096172&v3=0.007013&v4=0.028385&v5=5.040000&t=19.527630&h=54.157776&rssi=15&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001794s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010110s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000801s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1678347273,`v1`=-0.987743,`v2`=0.096172,`v3`=0.007013,`v4`=0.028385,`v5`=5.04,`t`=19.52763,`h`=54.157776,`rssi`=15,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678347275 WHERE `imei` = '868922055683912' [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011248s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678347273 , -0.987743 , 0.096172 , 0.007013 , 0.028385 , 5.04 , 19.52763 , 54.157776 , 15 , '898604650119C1053138' , '460048590503138' , -0 , 1678347275) [ RunTime:0.000509s ] --------------------------------------------------------------- [ 2023-03-09T15:34:37+08:00 ] 39.144.1.155 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678347061&v1=0.028505&v2=0.802651&v3=0.027542&v4=0.028505&v5=-95.040001&t=19.591980&h=54.066223&rssi=15&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011338s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000863s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1678347061,`v1`=0.028505,`v2`=0.802651,`v3`=0.027542,`v4`=0.028505,`v5`=-95.040001,`t`=19.59198,`h`=54.066223,`rssi`=15,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678347277 WHERE `imei` = '868922055683912' [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010507s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678347061 , 0.028505 , 0.802651 , 0.027542 , 0.028505 , -95.040001 , 19.59198 , 54.066223 , 15 , '898604650119C1053138' , '460048590503138' , -0 , 1678347277) [ RunTime:0.000476s ] --------------------------------------------------------------- [ 2023-03-09T15:34:43+08:00 ] 123.234.141.218 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001549s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010523s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = '936931780b48039ccbe9099f8514963e' LIMIT 1 [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2023-03-09T15:36:19+08:00 ] 123.234.141.218 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002159s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010653s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = '936931780b48039ccbe9099f8514963e' LIMIT 1 [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2023-03-09T15:36:30+08:00 ] 111.55.136.148 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002497s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010858s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000646s ] --------------------------------------------------------------- [ 2023-03-09T15:36:32+08:00 ] 111.55.136.148 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678347390&v1=-0.988706&v2=0.101075&v3=0.006773&v4=0.028264&v5=5.040000&t=19.742132&h=54.035706&rssi=15&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010459s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000639s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1678347390,`v1`=-0.988706,`v2`=0.101075,`v3`=0.006773,`v4`=0.028264,`v5`=5.04,`t`=19.742132,`h`=54.035706,`rssi`=15,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678347392 WHERE `imei` = '868922055683912' [ RunTime:0.000548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010523s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678347390 , -0.988706 , 0.101075 , 0.006773 , 0.028264 , 5.04 , 19.742132 , 54.035706 , 15 , '898604650119C1053138' , '460048590503138' , -0 , 1678347392) [ RunTime:0.000500s ] --------------------------------------------------------------- [ 2023-03-09T15:36:52+08:00 ] 123.234.141.218 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001708s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.009268s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = '936931780b48039ccbe9099f8514963e' LIMIT 1 [ RunTime:0.000512s ] --------------------------------------------------------------- [ 2023-03-09T15:37:34+08:00 ] 123.234.141.218 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001549s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010980s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000531s ] --------------------------------------------------------------- [ 2023-03-09T15:37:45+08:00 ] 123.234.141.218 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001786s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011647s ] [ 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 0,10 [ RunTime:0.000804s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000790s ] --------------------------------------------------------------- [ 2023-03-09T15:37:53+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3912 [ sql ] [ DB ] CONNECT:[ UseTime:0.001670s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011624s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3912%' LIMIT 1 [ RunTime:0.000506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000760s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000838s ] --------------------------------------------------------------- [ 2023-03-09T15:39:43+08:00 ] 39.144.6.199 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.002349s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009523s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1678347583 , 1678347583) [ RunTime:0.000707s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2023-03-09T15:39:49+08:00 ] 39.144.6.199 GET /kaiwu/public/index.php?s=/index/index/update/&imei=+GSN [ sql ] [ DB ] CONNECT:[ UseTime:0.001711s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010422s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = ' GSN' LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`=' GSN',`update_time`=1678347589 WHERE `imei` = ' GSN' [ RunTime:0.000528s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010299s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `update_time`) VALUES (' GSN' , 1678347589 , 1678347589) [ RunTime:0.001181s ] --------------------------------------------------------------- [ 2023-03-09T15:39:56+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3912 [ sql ] [ DB ] CONNECT:[ UseTime:0.001864s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010364s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3912%' LIMIT 1 [ RunTime:0.000476s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000702s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000781s ] --------------------------------------------------------------- [ 2023-03-09T15:40:25+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3912 [ sql ] [ DB ] CONNECT:[ UseTime:0.001824s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009637s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3912%' LIMIT 1 [ RunTime:0.000475s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000843s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000891s ] --------------------------------------------------------------- [ 2023-03-09T15:40:54+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002233s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009486s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3912%' LIMIT 1 [ RunTime:0.000467s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000644s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000907s ] --------------------------------------------------------------- [ 2023-03-09T15:41:15+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3912 [ sql ] [ DB ] CONNECT:[ UseTime:0.001527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016918s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3912%' LIMIT 1 [ RunTime:0.000469s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000713s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000767s ] --------------------------------------------------------------- [ 2023-03-09T15:42:39+08:00 ] 39.144.14.51 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002404s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012846s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000755s ] --------------------------------------------------------------- [ 2023-03-09T15:42:40+08:00 ] 39.144.14.51 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678347759&v1=-0.992740&v2=0.272557&v3=-1.001318&v4=0.028505&v5=5.400000&t=20.160410&h=53.486389&rssi=20&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001919s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010721s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.001266s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1678347759,`v1`=-0.99274,`v2`=0.272557,`v3`=-1.001318,`v4`=0.028505,`v5`=5.4,`t`=20.16041,`h`=53.486389,`rssi`=20,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678347760 WHERE `imei` = '868922055683912' [ RunTime:0.000744s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011531s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678347759 , -0.99274 , 0.272557 , -1.001318 , 0.028505 , 5.4 , 20.16041 , 53.486389 , 20 , '898604650119C1053138' , '460048590503138' , -0 , 1678347760) [ RunTime:0.000872s ] --------------------------------------------------------------- [ 2023-03-09T15:42:43+08:00 ] 39.144.14.51 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1575515471&v1=-0.991897&v2=0.173882&v3=-1.000716&v4=0.028324&v5=-69.300003&t=20.031710&h=53.600830&rssi=20&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&e [ sql ] [ DB ] CONNECT:[ UseTime:0.001600s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011130s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000692s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1575515471,`v1`=-0.991897,`v2`=0.173882,`v3`=-1.000716,`v4`=0.028324,`v5`=-69.300003,`t`=20.03171,`h`=53.60083,`rssi`=20,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678347763 WHERE `imei` = '868922055683912' [ RunTime:0.000519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009622s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1575515471 , -0.991897 , 0.173882 , -1.000716 , 0.028324 , -69.300003 , 20.03171 , 53.60083 , 20 , '898604650119C1053138' , '460048590503138' , -0 , 1678347763) [ RunTime:0.000531s ] --------------------------------------------------------------- [ 2023-03-09T15:42:53+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3912 [ sql ] [ DB ] CONNECT:[ UseTime:0.001528s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011329s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3912%' LIMIT 1 [ RunTime:0.000502s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000695s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000841s ] --------------------------------------------------------------- [ 2023-03-09T15:44:20+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3912 [ sql ] [ DB ] CONNECT:[ UseTime:0.001648s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011138s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3912%' LIMIT 1 [ RunTime:0.000452s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000661s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2023-03-09T15:44:28+08:00 ] 111.55.138.232 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.003717s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011010s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2023-03-09T15:44:29+08:00 ] 111.55.138.232 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678347868&v1=0.028264&v2=7.116631&v3=0.028084&v4=0.028445&v5=5.400000&t=20.224760&h=53.371948&rssi=20&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009482s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1678347868,`v1`=0.028264,`v2`=7.116631,`v3`=0.028084,`v4`=0.028445,`v5`=5.4,`t`=20.22476,`h`=53.371948,`rssi`=20,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678347869 WHERE `imei` = '868922055683912' [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009385s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678347868 , 0.028264 , 7.116631 , 0.028084 , 0.028445 , 5.4 , 20.22476 , 53.371948 , 20 , '898604650119C1053138' , '460048590503138' , -0 , 1678347869) [ RunTime:0.000474s ] --------------------------------------------------------------- [ 2023-03-09T15:44:48+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3912 [ sql ] [ DB ] CONNECT:[ UseTime:0.001948s ] 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 COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3912%' LIMIT 1 [ RunTime:0.000469s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000680s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000762s ] --------------------------------------------------------------- [ 2023-03-09T15:45:26+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3912 [ sql ] [ DB ] CONNECT:[ UseTime:0.002470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011595s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3912%' LIMIT 1 [ RunTime:0.000452s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000656s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000917s ] --------------------------------------------------------------- [ 2023-03-09T15:46:49+08:00 ] 39.144.2.191 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912 [ sql ] [ DB ] CONNECT:[ UseTime:0.009185s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009834s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000667s ] --------------------------------------------------------------- [ 2023-03-09T15:46:50+08:00 ] 39.144.2.191 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1678348009&v1=0.027963&v2=7.706389&v3=0.028144&v4=-0.991174&v5=5.400000&t=20.181860&h=53.402466&rssi=31&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002209s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010987s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1678348009,`v1`=0.027963,`v2`=7.706389,`v3`=0.028144,`v4`=-0.991174,`v5`=5.4,`t`=20.18186,`h`=53.402466,`rssi`=31,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`update_time`=1678348010 WHERE `imei` = '868922055683912' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011229s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683912' , 1678348009 , 0.027963 , 7.706389 , 0.028144 , -0.991174 , 5.4 , 20.18186 , 53.402466 , 31 , '898604650119C1053138' , '460048590503138' , -0 , 1678348010) [ RunTime:0.000513s ] --------------------------------------------------------------- [ 2023-03-09T15:46:55+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3912 [ sql ] [ DB ] CONNECT:[ UseTime:0.001867s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011010s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3912%' LIMIT 1 [ RunTime:0.000463s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000642s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000764s ] --------------------------------------------------------------- [ 2023-03-09T15:49:21+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002718s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011640s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3920%' LIMIT 1 [ RunTime:0.000459s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3920%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000670s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000765s ] --------------------------------------------------------------- [ 2023-03-09T15:50:18+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002479s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010857s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3920%' LIMIT 1 [ RunTime:0.000468s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3920%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000751s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2023-03-09T15:50:33+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3920 [ sql ] [ DB ] CONNECT:[ UseTime:0.001973s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011284s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3920%' LIMIT 1 [ RunTime:0.000450s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3920%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000646s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2023-03-09T15:52:14+08:00 ] 39.144.4.253 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.001608s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009596s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000623s ] --------------------------------------------------------------- [ 2023-03-09T15:52:16+08:00 ] 39.144.4.253 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678348334&v1=-1.013268&v2=0.268593&v3=-0.000813&v4=0.015080&v5=5.400000&t=17.800888&h=56.332153&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001825s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010602s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000790s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1678348334,`v1`=-1.013268,`v2`=0.268593,`v3`=-0.000813,`v4`=0.01508,`v5`=5.4,`t`=17.800888,`h`=56.332153,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678348336 WHERE `imei` = '868922055683920' [ RunTime:0.000519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010979s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678348334 , -1.013268 , 0.268593 , -0.000813 , 0.01508 , 5.4 , 17.800888 , 56.332153 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678348336) [ RunTime:0.000514s ] --------------------------------------------------------------- [ 2023-03-09T15:52:17+08:00 ] 39.144.4.253 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1575515471&v1=-1.013268&v2=0.269949&v3=-0.001535&v4=0.014960&v5=-2.700000&t=17.189558&h=57.499451&rssi=29&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&en [ sql ] [ DB ] CONNECT:[ UseTime:0.001427s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010018s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1575515471,`v1`=-1.013268,`v2`=0.269949,`v3`=-0.001535,`v4`=0.01496,`v5`=-2.7,`t`=17.189558,`h`=57.499451,`rssi`=29,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678348337 WHERE `imei` = '868922055683920' [ RunTime:0.000487s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010697s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1575515471 , -1.013268 , 0.269949 , -0.001535 , 0.01496 , -2.7 , 17.189558 , 57.499451 , 29 , '89860426102071188500' , '460044618415250' , -0 , 1678348337) [ RunTime:0.000493s ] --------------------------------------------------------------- [ 2023-03-09T15:52:25+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002290s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010562s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3920%' LIMIT 1 [ RunTime:0.000505s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3920%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000776s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000840s ] --------------------------------------------------------------- [ 2023-03-09T15:54:24+08:00 ] 117.132.194.199 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.001698s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008468s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2023-03-09T15:54:25+08:00 ] 117.132.194.199 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678348464&v1=-1.012907&v2=0.301242&v3=-1.016368&v4=0.015140&v5=5.580000&t=18.026115&h=56.011719&rssi=28&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001510s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010832s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1678348464,`v1`=-1.012907,`v2`=0.301242,`v3`=-1.016368,`v4`=0.01514,`v5`=5.58,`t`=18.026115,`h`=56.011719,`rssi`=28,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678348465 WHERE `imei` = '868922055683920' [ RunTime:0.000532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010192s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678348464 , -1.012907 , 0.301242 , -1.016368 , 0.01514 , 5.58 , 18.026115 , 56.011719 , 28 , '89860426102071188500' , '460044618415250' , -0 , 1678348465) [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2023-03-09T15:54:32+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3920 [ sql ] [ DB ] CONNECT:[ UseTime:0.001650s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011618s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3920%' LIMIT 1 [ RunTime:0.000521s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3920%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000615s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2023-03-09T15:56:25+08:00 ] 39.144.10.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002066s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011551s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-03-09T15:56:26+08:00 ] 39.144.10.141 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1678348585&v1=0.014900&v2=6.679997&v3=0.015201&v4=-1.009897&v5=5.400000&t=18.154818&h=55.897278&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001722s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1678348585,`v1`=0.0149,`v2`=6.679997,`v3`=0.015201,`v4`=-1.009897,`v5`=5.4,`t`=18.154818,`h`=55.897278,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1678348586 WHERE `imei` = '868922055683920' [ RunTime:0.000513s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011316s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1678348585 , 0.0149 , 6.679997 , 0.015201 , -1.009897 , 5.4 , 18.154818 , 55.897278 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1678348586) [ RunTime:0.000545s ] --------------------------------------------------------------- [ 2023-03-09T15:56:37+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3920 [ sql ] [ DB ] CONNECT:[ UseTime:0.001948s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012628s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3920%' LIMIT 1 [ RunTime:0.000546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3920%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000781s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000850s ] --------------------------------------------------------------- [ 2023-03-09T15:59:07+08:00 ] 39.144.15.144 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002402s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013450s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2023-03-09T15:59:09+08:00 ] 39.144.15.144 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1678348747&v1=-1.013208&v2=0.183582&v3=-0.000331&v4=0.015381&v5=5.400000&t=17.125208&h=52.685303&rssi=18&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001663s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009845s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1678348747,`v1`=-1.013208,`v2`=0.183582,`v3`=-0.000331,`v4`=0.015381,`v5`=5.4,`t`=17.125208,`h`=52.685303,`rssi`=18,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1678348749 WHERE `imei` = '868922055683771' [ RunTime:0.000523s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011072s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1678348747 , -1.013208 , 0.183582 , -0.000331 , 0.015381 , 5.4 , 17.125208 , 52.685303 , 18 , '898604650119C1053136' , '460048590503136' , -0 , 1678348749) [ RunTime:0.001486s ] --------------------------------------------------------------- [ 2023-03-09T16:00:26+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3771 [ sql ] [ DB ] CONNECT:[ UseTime:0.001524s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010426s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3771%' LIMIT 1 [ RunTime:0.000507s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3771%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000707s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000824s ] --------------------------------------------------------------- [ 2023-03-09T16:01:50+08:00 ] 218.204.253.56 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.002080s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011494s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000756s ] --------------------------------------------------------------- [ 2023-03-09T16:01:51+08:00 ] 218.204.253.56 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1678348910&v1=-1.013449&v2=0.228018&v3=-1.008452&v4=0.015983&v5=5.400000&t=17.747263&h=51.708740&rssi=17&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end [ 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.010952s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1678348910,`v1`=-1.013449,`v2`=0.228018,`v3`=-1.008452,`v4`=0.015983,`v5`=5.4,`t`=17.747263,`h`=51.70874,`rssi`=17,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1678348911 WHERE `imei` = '868922055683771' [ RunTime:0.000517s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010068s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1678348910 , -1.013449 , 0.228018 , -1.008452 , 0.015983 , 5.4 , 17.747263 , 51.70874 , 17 , '898604650119C1053136' , '460048590503136' , -0 , 1678348911) [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-03-09T16:01:58+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3771 [ sql ] [ DB ] CONNECT:[ UseTime:0.001799s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011224s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3771%' LIMIT 1 [ RunTime:0.000504s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3771%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000826s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000923s ] --------------------------------------------------------------- [ 2023-03-09T16:03:27+08:00 ] 111.55.138.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771 [ sql ] [ DB ] CONNECT:[ UseTime:0.001844s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011159s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000755s ] --------------------------------------------------------------- [ 2023-03-09T16:03:29+08:00 ] 111.55.138.139 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1678349007&v1=0.015261&v2=15.647263&v3=0.015411&v4=-1.014291&v5=5.040000&t=18.058290&h=51.220459&rssi=17&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011057s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1678349007,`v1`=0.015261,`v2`=15.647263,`v3`=0.015411,`v4`=-1.014291,`v5`=5.04,`t`=18.05829,`h`=51.220459,`rssi`=17,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`update_time`=1678349009 WHERE `imei` = '868922055683771' [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010062s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683771' , 1678349007 , 0.015261 , 15.647263 , 0.015411 , -1.014291 , 5.04 , 18.05829 , 51.220459 , 17 , '898604650119C1053136' , '460048590503136' , -0 , 1678349009) [ RunTime:0.000573s ] --------------------------------------------------------------- [ 2023-03-09T16:03:34+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=3771 [ sql ] [ DB ] CONNECT:[ UseTime:0.001553s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010694s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%3771%' LIMIT 1 [ RunTime:0.000442s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%3771%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000612s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2023-03-09T16:05:13+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=4548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002522s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011661s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%4548%' LIMIT 1 [ RunTime:0.000554s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%4548%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000740s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000826s ] --------------------------------------------------------------- [ 2023-03-09T16:05:22+08:00 ] 39.144.11.45 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001918s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012194s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000661s ] --------------------------------------------------------------- [ 2023-03-09T16:05:23+08:00 ] 39.144.11.45 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678349122&v1=-1.012847&v2=0.265047&v3=-0.006411&v4=0.013214&v5=5.400000&t=16.996506&h=52.937073&rssi=17&ccid=898604650119C1053137&imsi=460048590503137&v6=-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.011565s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678349122,`v1`=-1.012847,`v2`=0.265047,`v3`=-0.006411,`v4`=0.013214,`v5`=5.4,`t`=16.996506,`h`=52.937073,`rssi`=17,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678349123 WHERE `imei` = '868922055684548' [ RunTime:0.000582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009595s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678349122 , -1.012847 , 0.265047 , -0.006411 , 0.013214 , 5.4 , 16.996506 , 52.937073 , 17 , '898604650119C1053137' , '460048590503137' , -0 , 1678349123) [ RunTime:0.000571s ] --------------------------------------------------------------- [ 2023-03-09T16:05:36+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=4548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001525s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010594s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%4548%' LIMIT 1 [ RunTime:0.000467s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%4548%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000650s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2023-03-09T16:07:45+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=4548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001724s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010774s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%4548%' LIMIT 1 [ RunTime:0.000513s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%4548%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000735s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000811s ] --------------------------------------------------------------- [ 2023-03-09T16:10:05+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=4548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001558s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009393s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%4548%' LIMIT 1 [ RunTime:0.000479s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%4548%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000659s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2023-03-09T16:10:29+08:00 ] 117.132.193.17 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001866s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010207s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000742s ] --------------------------------------------------------------- [ 2023-03-09T16:10:30+08:00 ] 117.132.193.17 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678349429&v1=-1.012546&v2=0.280172&v3=-1.021214&v4=0.013515&v5=5.400000&t=18.176268&h=51.373047&rssi=31&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001988s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010978s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678349429,`v1`=-1.012546,`v2`=0.280172,`v3`=-1.021214,`v4`=0.013515,`v5`=5.4,`t`=18.176268,`h`=51.373047,`rssi`=31,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678349430 WHERE `imei` = '868922055684548' [ RunTime:0.000498s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008673s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678349429 , -1.012546 , 0.280172 , -1.021214 , 0.013515 , 5.4 , 18.176268 , 51.373047 , 31 , '898604650119C1053137' , '460048590503137' , -0 , 1678349430) [ RunTime:0.000479s ] --------------------------------------------------------------- [ 2023-03-09T16:10:31+08:00 ] 117.132.193.17 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678349221&v1=-1.012726&v2=0.191405&v3=-1.021335&v4=0.013395&v5=-5.580000&t=17.543486&h=52.128357&rssi=31&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&en [ sql ] [ DB ] CONNECT:[ UseTime:0.001533s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012680s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678349221,`v1`=-1.012726,`v2`=0.191405,`v3`=-1.021335,`v4`=0.013395,`v5`=-5.58,`t`=17.543486,`h`=52.128357,`rssi`=31,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678349431 WHERE `imei` = '868922055684548' [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010920s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678349221 , -1.012726 , 0.191405 , -1.021335 , 0.013395 , -5.58 , 17.543486 , 52.128357 , 31 , '898604650119C1053137' , '460048590503137' , -0 , 1678349431) [ RunTime:0.000505s ] --------------------------------------------------------------- [ 2023-03-09T16:10:47+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=4548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001561s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011926s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%4548%' LIMIT 1 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%4548%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000773s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000919s ] --------------------------------------------------------------- [ 2023-03-09T16:12:29+08:00 ] 111.55.136.165 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002292s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011654s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [ 2023-03-09T16:12:30+08:00 ] 111.55.136.165 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1678349549&v1=0.012793&v2=12.558490&v3=0.013094&v4=-1.019649&v5=5.400000&t=18.455120&h=51.136536&rssi=31&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001623s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1678349549,`v1`=0.012793,`v2`=12.55849,`v3`=0.013094,`v4`=-1.019649,`v5`=5.4,`t`=18.45512,`h`=51.136536,`rssi`=31,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1678349550 WHERE `imei` = '868922055684548' [ RunTime:0.000564s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010670s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1678349549 , 0.012793 , 12.55849 , 0.013094 , -1.019649 , 5.4 , 18.45512 , 51.136536 , 31 , '898604650119C1053137' , '460048590503137' , -0 , 1678349550) [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2023-03-09T16:12:38+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=4548 [ sql ] [ DB ] CONNECT:[ UseTime:0.001365s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010530s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%4548%' LIMIT 1 [ RunTime:0.000543s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%4548%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000809s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2023-03-09T16:14:22+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=6208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002228s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011313s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%6208%' LIMIT 1 [ RunTime:0.000504s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%6208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000704s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000799s ] --------------------------------------------------------------- [ 2023-03-09T16:14:46+08:00 ] 39.144.14.78 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010134s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000770s ] --------------------------------------------------------------- [ 2023-03-09T16:15:18+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=6208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002385s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009797s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%6208%' LIMIT 1 [ RunTime:0.001006s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%6208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000855s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000752s ] --------------------------------------------------------------- [ 2023-03-09T16:15:42+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=6208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001510s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010798s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%6208%' LIMIT 1 [ RunTime:0.000820s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%6208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000703s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000804s ] --------------------------------------------------------------- [ 2023-03-09T16:16:30+08:00 ] 39.144.16.199 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001772s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013800s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000698s ] --------------------------------------------------------------- [ 2023-03-09T16:16:32+08:00 ] 39.144.16.199 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1678349790&v1=-1.010138&v2=0.275582&v3=0.006803&v4=0.024592&v5=5.220000&t=20.761015&h=56.568665&rssi=31&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001910s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011621s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1678349790,`v1`=-1.010138,`v2`=0.275582,`v3`=0.006803,`v4`=0.024592,`v5`=5.22,`t`=20.761015,`h`=56.568665,`rssi`=31,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1678349792 WHERE `imei` = '868922056976208' [ RunTime:0.000535s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009768s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1678349790 , -1.010138 , 0.275582 , 0.006803 , 0.024592 , 5.22 , 20.761015 , 56.568665 , 31 , '898604650119C1053139' , '460048590503139' , -0 , 1678349792) [ RunTime:0.000523s ] --------------------------------------------------------------- [ 2023-03-09T16:16:34+08:00 ] 39.144.16.199 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1678349686&v1=-1.010318&v2=0.271618&v3=0.002709&v4=0.024652&v5=123.660004&t=20.278387&h=57.453674&rssi=31&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&en [ sql ] [ DB ] CONNECT:[ UseTime:0.001846s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011575s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1678349686,`v1`=-1.010318,`v2`=0.271618,`v3`=0.002709,`v4`=0.024652,`v5`=123.660004,`t`=20.278387,`h`=57.453674,`rssi`=31,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1678349794 WHERE `imei` = '868922056976208' [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008547s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1678349686 , -1.010318 , 0.271618 , 0.002709 , 0.024652 , 123.660004 , 20.278387 , 57.453674 , 31 , '898604650119C1053139' , '460048590503139' , -0 , 1678349794) [ RunTime:0.000497s ] --------------------------------------------------------------- [ 2023-03-09T16:16:38+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=6208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002207s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012384s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%6208%' LIMIT 1 [ RunTime:0.000470s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%6208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000653s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000760s ] --------------------------------------------------------------- [ 2023-03-09T16:18:26+08:00 ] 111.55.139.173 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ 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.010371s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000654s ] --------------------------------------------------------------- [ 2023-03-09T16:18:27+08:00 ] 111.55.139.173 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1678349906&v1=-1.010017&v2=0.265673&v3=-1.001318&v4=0.025134&v5=5.220000&t=20.846817&h=56.278748&rssi=31&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001648s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009778s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1678349906,`v1`=-1.010017,`v2`=0.265673,`v3`=-1.001318,`v4`=0.025134,`v5`=5.22,`t`=20.846817,`h`=56.278748,`rssi`=31,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1678349907 WHERE `imei` = '868922056976208' [ RunTime:0.000558s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010363s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1678349906 , -1.010017 , 0.265673 , -1.001318 , 0.025134 , 5.22 , 20.846817 , 56.278748 , 31 , '898604650119C1053139' , '460048590503139' , -0 , 1678349907) [ RunTime:0.000499s ] --------------------------------------------------------------- [ 2023-03-09T16:18:50+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=6208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002731s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014871s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%6208%' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%6208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001045s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.002045s ] --------------------------------------------------------------- [ 2023-03-09T16:20:25+08:00 ] 39.144.15.160 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208 [ sql ] [ DB ] CONNECT:[ UseTime:0.001712s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-03-09T16:20:26+08:00 ] 39.144.15.160 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1678350025&v1=0.024833&v2=13.078674&v3=0.024773&v4=-0.999121&v5=5.220000&t=20.782465&h=56.278748&rssi=31&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&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.010395s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1678350025,`v1`=0.024833,`v2`=13.078674,`v3`=0.024773,`v4`=-0.999121,`v5`=5.22,`t`=20.782465,`h`=56.278748,`rssi`=31,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`update_time`=1678350026 WHERE `imei` = '868922056976208' [ RunTime:0.000558s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011196s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976208' , 1678350025 , 0.024833 , 13.078674 , 0.024773 , -0.999121 , 5.22 , 20.782465 , 56.278748 , 31 , '898604650119C1053139' , '460048590503139' , -0 , 1678350026) [ RunTime:0.000488s ] --------------------------------------------------------------- [ 2023-03-09T16:20:40+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=6208 [ sql ] [ DB ] CONNECT:[ UseTime:0.002070s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010521s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%6208%' LIMIT 1 [ RunTime:0.000461s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%6208%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000670s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000731s ] --------------------------------------------------------------- [ 2023-03-09T16:46:18+08:00 ] 123.234.141.218 GET /admin/show/index.html?keyword=4548 [ sql ] [ DB ] CONNECT:[ UseTime:0.002320s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011622s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%4548%' LIMIT 1 [ RunTime:0.000492s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%4548%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000694s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000779s ]