---------------------------------------------------------------
[ 2022-10-24T03:03:56+08:00 ] 39.144.15.108 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002208s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011125s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000735s ]
---------------------------------------------------------------
[ 2022-10-24T03:03:57+08:00 ] 39.144.2.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001717s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011002s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000626s ]
---------------------------------------------------------------
[ 2022-10-24T03:04:05+08:00 ] 39.144.15.108 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=030301&v1=-00.502&v2=+00.001&v3=-00.162&v4=+00.021&v5=05.9&t=+07.1&h=58.0&rssi=+223&ccid=4600485905031430000099m9990000000084000000g5650,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001447s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008886s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000582s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='030301',`v1`=-0.502,`v2`=0.001,`v3`=-0.162,`v4`=0.021,`v5`=5.9,`t`=7.1,`h`=58,`rssi`=223,`ccid`='4600485905031430000099m9990000000084000000g5650,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666551845 WHERE `imei` = '868922055644013' [ RunTime:0.000538s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010914s ]
[ 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' , '221024' , '030301' , -0.502 , 0.001 , -0.162 , 0.021 , 5.9 , 7.1 , 58 , 223 , '4600485905031430000099m9990000000084000000g5650,N,00E000=-00.000' , 0 , 0 , 1666551845 , 1666551845) [ RunTime:0.000723s ]
---------------------------------------------------------------
[ 2022-10-24T03:04:05+08:00 ] 39.144.2.16 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221024&time=030301&v1=-00.879&v2=+00.029&v3=-00.980&v4=-00.033&v5=06.0&t=+06.0&h=54.5&rssi=+229&ccid=4600485905031420000099m9990000000132000000g9040,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009744s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000594s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221024',`time`='030301',`v1`=-0.879,`v2`=0.029,`v3`=-0.98,`v4`=-0.033,`v5`=6,`t`=6,`h`=54.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000132000000g9040,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666551845 WHERE `imei` = '868922055643643' [ RunTime:0.000462s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009676s ]
[ 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' , '221024' , '030301' , -0.879 , 0.029 , -0.98 , -0.033 , 6 , 6 , 54.5 , 229 , '4600485905031420000099m9990000000132000000g9040,N,00E000=-00.000' , 0 , 0 , 1666551845 , 1666551845) [ RunTime:0.000474s ]
---------------------------------------------------------------
[ 2022-10-24T07:25:41+08:00 ] 223.104.2.58 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002332s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011990s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000763s ]
---------------------------------------------------------------
[ 2022-10-24T07:47:09+08:00 ] 113.120.89.155 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002135s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010350s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000678s ]
---------------------------------------------------------------
[ 2022-10-24T08:08:28+08:00 ] 223.104.2.58 GET /
[ sql ] [ DB ] CONNECT:[ UseTime:0.002214s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009708s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000482s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000593s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000637s ]
---------------------------------------------------------------
[ 2022-10-24T08:15:03+08:00 ] 223.104.2.58 GET /
[ sql ] [ DB ] CONNECT:[ UseTime:0.002286s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011119s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000486s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000668s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000624s ]
---------------------------------------------------------------
[ 2022-10-24T08:15:09+08:00 ] 223.104.2.58 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001540s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010187s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000514s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000648s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000614s ]
---------------------------------------------------------------
[ 2022-10-24T08:15:11+08:00 ] 223.104.2.58 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001578s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011312s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000753s ]
---------------------------------------------------------------
[ 2022-10-24T08:15:14+08:00 ] 223.104.2.58 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001785s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009605s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000523s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000662s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000655s ]
---------------------------------------------------------------
[ 2022-10-24T08:15:22+08:00 ] 223.104.2.58 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010941s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000498s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000610s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000571s ]
---------------------------------------------------------------
[ 2022-10-24T08:15:27+08:00 ] 223.104.2.58 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001326s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009405s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000658s ]
---------------------------------------------------------------
[ 2022-10-24T08:15:28+08:00 ] 223.104.2.58 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001677s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010133s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000488s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000671s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000656s ]
---------------------------------------------------------------
[ 2022-10-24T08:15:29+08:00 ] 223.104.2.58 GET /
[ sql ] [ DB ] CONNECT:[ UseTime:0.001538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009605s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'xinghuo220kv' LIMIT 1 [ RunTime:0.000496s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000848s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'xinghuo220kv' ORDER BY `id` DESC [ RunTime:0.000609s ]
---------------------------------------------------------------
[ 2022-10-24T09:03:56+08:00 ] 117.132.192.46 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002126s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011199s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000892s ]
---------------------------------------------------------------
[ 2022-10-24T09:03:57+08:00 ] 39.144.16.209 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001586s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008190s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000607s ]
---------------------------------------------------------------
[ 2022-10-24T09:04:05+08:00 ] 117.132.192.46 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221024&time=090301&v1=-00.887&v2=+00.082&v3=-00.973&v4=-00.031&v5=06.0&t=+10.6&h=52.8&rssi=+229&ccid=4600485905031420000099m9990000000117000000g9100,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002007s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010848s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000732s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221024',`time`='090301',`v1`=-0.887,`v2`=0.082,`v3`=-0.973,`v4`=-0.031,`v5`=6,`t`=10.6,`h`=52.8,`rssi`=229,`ccid`='4600485905031420000099m9990000000117000000g9100,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666573445 WHERE `imei` = '868922055643643' [ RunTime:0.000623s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011926s ]
[ 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' , '221024' , '090301' , -0.887 , 0.082 , -0.973 , -0.031 , 6 , 10.6 , 52.8 , 229 , '4600485905031420000099m9990000000117000000g9100,N,00E000=-00.000' , 0 , 0 , 1666573445 , 1666573445) [ RunTime:0.000722s ]
---------------------------------------------------------------
[ 2022-10-24T09:04:05+08:00 ] 39.144.16.209 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=090301&v1=-00.743&v2=+00.001&v3=-00.424&v4=+00.060&v5=05.9&t=+11.4&h=55.9&rssi=+226&ccid=4600485905031430000099m9990000000133000000g8050,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001398s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009703s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000668s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='090301',`v1`=-0.743,`v2`=0.001,`v3`=-0.424,`v4`=0.06,`v5`=5.9,`t`=11.4,`h`=55.9,`rssi`=226,`ccid`='4600485905031430000099m9990000000133000000g8050,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666573445 WHERE `imei` = '868922055644013' [ RunTime:0.000481s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010112s ]
[ 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' , '221024' , '090301' , -0.743 , 0.001 , -0.424 , 0.06 , 5.9 , 11.4 , 55.9 , 226 , '4600485905031430000099m9990000000133000000g8050,N,00E000=-00.000' , 0 , 0 , 1666573445 , 1666573445) [ RunTime:0.000568s ]
---------------------------------------------------------------
[ 2022-10-24T10:35:51+08:00 ] 112.9.188.102 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002179s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012011s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000594s ]
---------------------------------------------------------------
[ 2022-10-24T10:35:53+08:00 ] 112.9.188.102 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001725s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010026s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000736s ]
---------------------------------------------------------------
[ 2022-10-24T10:36:26+08:00 ] 112.9.188.102 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001611s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010874s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000500s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000608s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000526s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010972s ]
[ 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.000393s ]
[ 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.000408s ]
---------------------------------------------------------------
[ 2022-10-24T10:36:37+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-20&end_date=2022-10-25
[ sql ] [ DB ] CONNECT:[ UseTime:0.001927s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010160s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000728s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000641s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000644s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000625s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010880s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1666195200 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.001067s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1666195200 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.002560s ]
---------------------------------------------------------------
[ 2022-10-24T10:37:57+08:00 ] 27.223.154.40 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001646s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011015s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000606s ]
---------------------------------------------------------------
[ 2022-10-24T10:37:58+08:00 ] 27.223.154.40 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001728s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010565s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000740s ]
---------------------------------------------------------------
[ 2022-10-24T10:38:00+08:00 ] 27.223.154.40 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001396s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009426s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000396s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000611s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000505s ]
---------------------------------------------------------------
[ 2022-10-24T10:38:02+08:00 ] 27.223.154.40 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002390s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010383s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000920s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012042s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000524s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001372s ]
---------------------------------------------------------------
[ 2022-10-24T10:38:59+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055643643&start_date=2022-10-20&end_date=2022-10-25
[ 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.010472s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000632s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055643643' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000412s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000761s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000515s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011247s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' AND ( `update_time` >= 1666195200 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.000749s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' AND ( `update_time` >= 1666195200 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001492s ]
---------------------------------------------------------------
[ 2022-10-24T10:39:24+08:00 ] 112.9.188.102 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001479s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010157s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000479s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000659s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000567s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010619s ]
[ 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.000377s ]
[ 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.000407s ]
---------------------------------------------------------------
[ 2022-10-24T10:39:40+08:00 ] 27.223.154.40 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001565s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009270s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000611s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010720s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000529s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001097s ]
---------------------------------------------------------------
[ 2022-10-24T10:39:42+08:00 ] 27.223.154.40 GET /home/show/index.html
[ 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.009109s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000506s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000784s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000552s ]
---------------------------------------------------------------
[ 2022-10-24T10:39:44+08:00 ] 27.223.154.40 GET /home/show/read/id/32/imei/868922055643643.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001631s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011058s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000627s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010441s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000946s ]
---------------------------------------------------------------
[ 2022-10-24T10:42:21+08:00 ] 27.223.154.40 GET /home/show/read/id/32/imei/868922055643643.html
[ 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.009556s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000680s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012836s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000464s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001002s ]
---------------------------------------------------------------
[ 2022-10-24T10:42:22+08:00 ] 27.223.154.40 GET /home/show/read/id/32/imei/868922055643643.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001820s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010119s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001095s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010381s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000460s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000870s ]
---------------------------------------------------------------
[ 2022-10-24T10:42:59+08:00 ] 112.224.67.17 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001477s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010071s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000577s ]
---------------------------------------------------------------
[ 2022-10-24T10:43:00+08:00 ] 112.224.67.17 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001756s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007605s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000650s ]
---------------------------------------------------------------
[ 2022-10-24T10:43:03+08:00 ] 112.224.67.17 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001721s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010205s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000446s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001086s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000717s ]
---------------------------------------------------------------
[ 2022-10-24T10:43:05+08:00 ] 112.224.67.17 GET /home/show/read/id/33/imei/868922055644013.html
[ 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.008752s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000593s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010106s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000454s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001045s ]
---------------------------------------------------------------
[ 2022-10-24T10:46:58+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055643643&start_date=2022-10-17&end_date=2022-10-25
[ sql ] [ DB ] CONNECT:[ UseTime:0.001898s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010036s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000702s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055643643' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000394s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000473s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000518s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009673s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.000760s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001201s ]
---------------------------------------------------------------
[ 2022-10-24T10:49:31+08:00 ] 112.9.188.102 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002890s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012064s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000734s ]
---------------------------------------------------------------
[ 2022-10-24T10:49:33+08:00 ] 112.9.188.102 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013158s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000948s ]
---------------------------------------------------------------
[ 2022-10-24T10:49:37+08:00 ] 112.9.188.102 GET /home/data/index.html
[ 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.009720s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000476s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000666s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000588s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010674s ]
[ 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.000361s ]
[ 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.000449s ]
---------------------------------------------------------------
[ 2022-10-24T10:49:46+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-10&end_date=2022-10-25
[ sql ] [ DB ] CONNECT:[ UseTime:0.002174s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010741s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000677s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000386s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000461s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000568s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010623s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665331200 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.000983s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665331200 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001694s ]
---------------------------------------------------------------
[ 2022-10-24T10:58:51+08:00 ] 112.224.67.17 GET /home/show/index.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_show` [ RunTime:0.009688s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000479s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000622s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000527s ]
---------------------------------------------------------------
[ 2022-10-24T11:04:41+08:00 ] 117.136.92.0 GET /home/map/index.html
[ 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.008886s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000668s ]
---------------------------------------------------------------
[ 2022-10-24T11:04:45+08:00 ] 117.136.92.0 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001451s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009230s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000506s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000623s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000522s ]
---------------------------------------------------------------
[ 2022-10-24T11:04:48+08:00 ] 117.136.92.0 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001439s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009753s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000611s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010688s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000512s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001182s ]
---------------------------------------------------------------
[ 2022-10-24T11:04:52+08:00 ] 117.136.92.0 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001729s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010640s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000601s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010572s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001047s ]
---------------------------------------------------------------
[ 2022-10-24T11:06:11+08:00 ] 117.136.92.0 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010117s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000887s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000648s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000508s ]
---------------------------------------------------------------
[ 2022-10-24T11:06:14+08:00 ] 117.136.92.0 GET /home/show/read/id/32/imei/868922055643643.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001685s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010770s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000708s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010663s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000479s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000954s ]
---------------------------------------------------------------
[ 2022-10-24T11:31:08+08:00 ] 27.223.154.40 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002132s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010072s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000584s ]
---------------------------------------------------------------
[ 2022-10-24T11:31:09+08:00 ] 27.223.154.40 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010210s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000709s ]
---------------------------------------------------------------
[ 2022-10-24T11:31:14+08:00 ] 27.223.154.40 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001335s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008514s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000443s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000763s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000518s ]
---------------------------------------------------------------
[ 2022-10-24T11:31:17+08:00 ] 27.223.154.40 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001536s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009049s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000652s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010866s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000531s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001190s ]
---------------------------------------------------------------
[ 2022-10-24T11:32:02+08:00 ] 27.223.154.40 GET /home/show/read/id/33/imei/868922055644013.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001701s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009931s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000653s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012792s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.001079s ]
---------------------------------------------------------------
[ 2022-10-24T11:32:05+08:00 ] 27.223.154.40 GET /home/show/read/id/33/imei/868922055644013.html?page=3
[ 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.008447s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000636s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010768s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000514s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 20,10 [ RunTime:0.001188s ]
---------------------------------------------------------------
[ 2022-10-24T11:32:09+08:00 ] 27.223.154.40 GET /home/show/read/id/33/imei/868922055644013.html?page=4
[ sql ] [ DB ] CONNECT:[ UseTime:0.001649s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010980s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000755s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010077s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000558s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 30,10 [ RunTime:0.001298s ]
---------------------------------------------------------------
[ 2022-10-24T11:32:13+08:00 ] 27.223.154.40 GET /home/show/read/id/33/imei/868922055644013.html?page=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.015341s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010202s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000643s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009487s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000536s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001112s ]
---------------------------------------------------------------
[ 2022-10-24T11:33:33+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055643643&start_date=2022-10-17&end_date=2022-10-25
[ sql ] [ DB ] CONNECT:[ UseTime:0.002124s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009083s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000711s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055643643' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000434s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000470s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000543s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010307s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.000841s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001387s ]
---------------------------------------------------------------
[ 2022-10-24T11:33:43+08:00 ] 112.9.188.102 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001703s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009658s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000819s ]
---------------------------------------------------------------
[ 2022-10-24T11:33:47+08:00 ] 112.9.188.102 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001593s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009461s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2022-10-24T11:33:49+08:00 ] 112.9.188.102 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001420s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009384s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000387s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000610s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000528s ]
---------------------------------------------------------------
[ 2022-10-24T11:33:55+08:00 ] 112.9.188.102 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001366s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009647s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000385s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000604s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000496s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010064s ]
[ 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.000359s ]
[ 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.000387s ]
---------------------------------------------------------------
[ 2022-10-24T11:34:04+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-17&end_date=2022-10-25
[ sql ] [ DB ] CONNECT:[ UseTime:0.001636s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010163s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000949s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000459s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000466s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000555s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010836s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.000957s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001559s ]
---------------------------------------------------------------
[ 2022-10-24T11:34:41+08:00 ] 112.9.188.102 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001380s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.007591s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000578s ]
---------------------------------------------------------------
[ 2022-10-24T11:34:42+08:00 ] 112.9.188.102 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010789s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000675s ]
---------------------------------------------------------------
[ 2022-10-24T11:34:44+08:00 ] 112.9.188.102 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001687s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008449s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000433s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000645s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000524s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010119s ]
[ 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.000310s ]
[ 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.000399s ]
---------------------------------------------------------------
[ 2022-10-24T11:34:54+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055643643&start_date=2022-10-17&end_date=2022-10-25
[ sql ] [ DB ] CONNECT:[ UseTime:0.001404s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011861s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000682s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055643643' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000408s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000496s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000550s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011118s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.000872s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001300s ]
---------------------------------------------------------------
[ 2022-10-24T11:35:57+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-17&end_date=2022-10-25
[ 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.010325s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000670s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000500s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000514s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000529s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010496s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.001293s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001697s ]
---------------------------------------------------------------
[ 2022-10-24T11:42:14+08:00 ] 27.223.154.40 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009134s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000605s ]
---------------------------------------------------------------
[ 2022-10-24T11:42:15+08:00 ] 27.223.154.40 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001523s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010223s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000684s ]
---------------------------------------------------------------
[ 2022-10-24T11:42:18+08:00 ] 27.223.154.40 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002552s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010748s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000486s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000698s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000600s ]
---------------------------------------------------------------
[ 2022-10-24T11:42:22+08:00 ] 27.223.154.40 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001417s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011315s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000665s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011053s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000541s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001218s ]
---------------------------------------------------------------
[ 2022-10-24T11:44:09+08:00 ] 112.9.188.102 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001853s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009964s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000541s ]
---------------------------------------------------------------
[ 2022-10-24T11:44:11+08:00 ] 112.9.188.102 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001629s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009756s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000721s ]
---------------------------------------------------------------
[ 2022-10-24T11:44:14+08:00 ] 112.9.188.102 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001635s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009815s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000464s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000684s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000558s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009548s ]
[ 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.000346s ]
[ 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.000440s ]
---------------------------------------------------------------
[ 2022-10-24T11:44:27+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-17&end_date=2022-10-25
[ 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.009741s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000679s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000458s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000488s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000615s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010798s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.000962s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001630s ]
---------------------------------------------------------------
[ 2022-10-24T11:46:20+08:00 ] 112.9.188.102 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001555s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010533s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000554s ]
---------------------------------------------------------------
[ 2022-10-24T11:46:21+08:00 ] 112.9.188.102 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001442s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009782s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000685s ]
---------------------------------------------------------------
[ 2022-10-24T11:46:25+08:00 ] 112.9.188.102 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001755s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009597s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000455s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000622s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000530s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009487s ]
[ 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.000368s ]
[ 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.000420s ]
---------------------------------------------------------------
[ 2022-10-24T11:46:36+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-17&end_date=2022-10-25
[ sql ] [ DB ] CONNECT:[ UseTime:0.001310s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014025s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000633s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000391s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000512s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009068s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.000941s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001955s ]
---------------------------------------------------------------
[ 2022-10-24T11:49:35+08:00 ] 112.9.188.102 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002320s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008755s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000570s ]
---------------------------------------------------------------
[ 2022-10-24T11:49:37+08:00 ] 112.9.188.102 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001674s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011126s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000727s ]
---------------------------------------------------------------
[ 2022-10-24T11:49:40+08:00 ] 112.9.188.102 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010340s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000739s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000742s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000519s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009259s ]
[ 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.000328s ]
[ 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.000420s ]
---------------------------------------------------------------
[ 2022-10-24T11:49:48+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-17&end_date=2022-10-25
[ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009669s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000632s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000414s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000465s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000608s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009305s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.000880s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001656s ]
---------------------------------------------------------------
[ 2022-10-24T11:50:33+08:00 ] 112.9.188.102 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001777s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010802s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000660s ]
---------------------------------------------------------------
[ 2022-10-24T11:50:34+08:00 ] 112.9.188.102 GET /home/map/index.html
[ 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.009864s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000720s ]
---------------------------------------------------------------
[ 2022-10-24T11:50:39+08:00 ] 112.9.188.102 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002248s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014164s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000639s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000878s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000728s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013133s ]
[ 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.000519s ]
[ 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.000577s ]
---------------------------------------------------------------
[ 2022-10-24T11:50:49+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-17&end_date=2022-10-25
[ sql ] [ DB ] CONNECT:[ UseTime:0.001449s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008723s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000637s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000423s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000462s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000547s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009398s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) LIMIT 1 [ RunTime:0.000929s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1665936000 AND `update_time` <= 1666627200 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001563s ]
---------------------------------------------------------------
[ 2022-10-24T12:02:39+08:00 ] 27.223.154.40 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002586s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010324s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000495s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000660s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000567s ]
---------------------------------------------------------------
[ 2022-10-24T12:18:42+08:00 ] 27.223.154.40 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002809s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010773s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000742s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000848s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000635s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011359s ]
[ 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.000483s ]
[ 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.000554s ]
---------------------------------------------------------------
[ 2022-10-24T12:18:54+08:00 ] 27.223.154.40 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-06&end_date=2022-10-24
[ sql ] [ DB ] CONNECT:[ UseTime:0.001749s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009657s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000626s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000422s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000482s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000541s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009704s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1664985600 AND `update_time` <= 1666540800 ) LIMIT 1 [ RunTime:0.000936s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1664985600 AND `update_time` <= 1666540800 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.001846s ]
---------------------------------------------------------------
[ 2022-10-24T12:31:11+08:00 ] 112.9.188.102 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002551s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012026s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000643s ]
---------------------------------------------------------------
[ 2022-10-24T12:31:13+08:00 ] 112.9.188.102 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001661s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009254s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000692s ]
---------------------------------------------------------------
[ 2022-10-24T12:31:17+08:00 ] 112.9.188.102 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001551s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008777s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000505s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000935s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000507s ]
---------------------------------------------------------------
[ 2022-10-24T12:31:20+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001983s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013144s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000911s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011412s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000721s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002056s ]
---------------------------------------------------------------
[ 2022-10-24T12:31:31+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009799s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000809s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009158s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000475s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001154s ]
---------------------------------------------------------------
[ 2022-10-24T12:32:02+08:00 ] 112.9.188.102 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001923s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010012s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000482s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000652s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000610s ]
---------------------------------------------------------------
[ 2022-10-24T12:32:06+08:00 ] 112.9.188.102 GET /home/show/edit/id/33.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001504s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010194s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000675s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010756s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000480s ]
---------------------------------------------------------------
[ 2022-10-24T12:32:31+08:00 ] 112.9.188.102 POST /home/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001462s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009843s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `interval`=60,`gps`='120.001126,36.338007',`introduce`='<p>胶州å˜ç”µç«™1å·é¿é›·é’ˆä¸‹</p><p>2022.10.22</p>',`update_time`=1666585951 WHERE `id` = 33 [ RunTime:0.000657s ]
---------------------------------------------------------------
[ 2022-10-24T12:32:32+08:00 ] 112.9.188.102 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001642s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010600s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000427s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000649s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000533s ]
---------------------------------------------------------------
[ 2022-10-24T12:32:36+08:00 ] 112.9.188.102 GET /home/show/read/id/32/imei/868922055643643.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001413s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009827s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000610s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010072s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000424s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000931s ]
---------------------------------------------------------------
[ 2022-10-24T12:32:54+08:00 ] 112.9.188.102 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001448s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008951s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000463s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000596s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000793s ]
---------------------------------------------------------------
[ 2022-10-24T15:03:56+08:00 ] 39.144.14.156 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002312s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011730s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000781s ]
---------------------------------------------------------------
[ 2022-10-24T15:03:57+08:00 ] 223.104.254.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011351s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000737s ]
---------------------------------------------------------------
[ 2022-10-24T15:04:04+08:00 ] 39.144.14.156 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=150301&v1=-00.749&v2=+00.001&v3=+00.018&v4=+00.022&v5=06.0&t=+20.1&h=57.5&rssi=+228&ccid=4600485905031430000099m9990000000041000000g8300,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001984s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010666s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000683s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='150301',`v1`=-0.749,`v2`=0.001,`v3`=0.018,`v4`=0.022,`v5`=6,`t`=20.1,`h`=57.5,`rssi`=228,`ccid`='4600485905031430000099m9990000000041000000g8300,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666595044 WHERE `imei` = '868922055644013' [ RunTime:0.000578s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009677s ]
[ 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' , '221024' , '150301' , -0.749 , 0.001 , 0.018 , 0.022 , 6 , 20.1 , 57.5 , 228 , '4600485905031430000099m9990000000041000000g8300,N,00E000=-00.000' , 0 , 0 , 1666595044 , 1666595044) [ RunTime:0.000623s ]
---------------------------------------------------------------
[ 2022-10-24T15:04:05+08:00 ] 223.104.254.120 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221024&time=150301&v1=-00.900&v2=+00.075&v3=-00.983&v4=-00.040&v5=06.2&t=+18.9&h=52.7&rssi=+230&ccid=4600485905031420000099m9990000000113000000g9260,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001624s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011743s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000789s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221024',`time`='150301',`v1`=-0.9,`v2`=0.075,`v3`=-0.983,`v4`=-0.04,`v5`=6.2,`t`=18.9,`h`=52.7,`rssi`=230,`ccid`='4600485905031420000099m9990000000113000000g9260,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666595045 WHERE `imei` = '868922055643643' [ RunTime:0.000573s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010287s ]
[ 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' , '221024' , '150301' , -0.9 , 0.075 , -0.983 , -0.04 , 6.2 , 18.9 , 52.7 , 230 , '4600485905031420000099m9990000000113000000g9260,N,00E000=-00.000' , 0 , 0 , 1666595045 , 1666595045) [ RunTime:0.000563s ]
---------------------------------------------------------------
[ 2022-10-24T16:03:58+08:00 ] 39.144.3.57 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002196s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011516s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000698s ]
---------------------------------------------------------------
[ 2022-10-24T16:04:06+08:00 ] 39.144.3.57 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=160301&v1=-00.753&v2=+00.001&v3=+00.018&v4=+00.022&v5=06.0&t=+18.9&h=57.5&rssi=+226&ccid=4600485905031430000099m9990000000040000000g8330,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001455s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009535s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000711s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='160301',`v1`=-0.753,`v2`=0.001,`v3`=0.018,`v4`=0.022,`v5`=6,`t`=18.9,`h`=57.5,`rssi`=226,`ccid`='4600485905031430000099m9990000000040000000g8330,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666598646 WHERE `imei` = '868922055644013' [ RunTime:0.000633s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010901s ]
[ 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' , '221024' , '160301' , -0.753 , 0.001 , 0.018 , 0.022 , 6 , 18.9 , 57.5 , 226 , '4600485905031430000099m9990000000040000000g8330,N,00E000=-00.000' , 0 , 0 , 1666598646 , 1666598646) [ RunTime:0.000665s ]
---------------------------------------------------------------
[ 2022-10-24T17:03:57+08:00 ] 39.144.10.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002440s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010754s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000709s ]
---------------------------------------------------------------
[ 2022-10-24T17:04:06+08:00 ] 39.144.10.41 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=170301&v1=-00.756&v2=+00.001&v3=+00.019&v4=+00.021&v5=06.0&t=+17.6&h=57.6&rssi=+227&ccid=4600485905031430000099m9990000000040000000g8350,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001766s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009805s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000653s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='170301',`v1`=-0.756,`v2`=0.001,`v3`=0.019,`v4`=0.021,`v5`=6,`t`=17.6,`h`=57.6,`rssi`=227,`ccid`='4600485905031430000099m9990000000040000000g8350,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666602246 WHERE `imei` = '868922055644013' [ RunTime:0.000574s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010669s ]
[ 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' , '221024' , '170301' , -0.756 , 0.001 , 0.019 , 0.021 , 6 , 17.6 , 57.6 , 227 , '4600485905031430000099m9990000000040000000g8350,N,00E000=-00.000' , 0 , 0 , 1666602246 , 1666602246) [ RunTime:0.000731s ]
---------------------------------------------------------------
[ 2022-10-24T18:03:58+08:00 ] 39.144.16.66 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002205s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011440s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000700s ]
---------------------------------------------------------------
[ 2022-10-24T18:04:07+08:00 ] 39.144.16.66 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=180301&v1=-00.751&v2=+00.001&v3=-00.009&v4=+00.022&v5=06.0&t=+16.2&h=58.0&rssi=+227&ccid=4600485905031430000099m9990000000048000000g8280,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002108s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008214s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000683s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='180301',`v1`=-0.751,`v2`=0.001,`v3`=-0.009,`v4`=0.022,`v5`=6,`t`=16.2,`h`=58,`rssi`=227,`ccid`='4600485905031430000099m9990000000048000000g8280,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666605847 WHERE `imei` = '868922055644013' [ RunTime:0.000613s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011926s ]
[ 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' , '221024' , '180301' , -0.751 , 0.001 , -0.009 , 0.022 , 6 , 16.2 , 58 , 227 , '4600485905031430000099m9990000000048000000g8280,N,00E000=-00.000' , 0 , 0 , 1666605847 , 1666605847) [ RunTime:0.000726s ]
---------------------------------------------------------------
[ 2022-10-24T19:03:58+08:00 ] 117.132.195.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012728s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000935s ]
---------------------------------------------------------------
[ 2022-10-24T19:04:06+08:00 ] 117.132.195.150 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=190301&v1=-00.750&v2=+00.001&v3=-00.047&v4=+00.024&v5=05.7&t=+15.3&h=57.8&rssi=+225&ccid=4600485905031430000099m9990000000058000000g8270,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007836s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000719s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='190301',`v1`=-0.75,`v2`=0.001,`v3`=-0.047,`v4`=0.024,`v5`=5.7,`t`=15.3,`h`=57.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000058000000g8270,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666609446 WHERE `imei` = '868922055644013' [ RunTime:0.000588s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012012s ]
[ 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' , '221024' , '190301' , -0.75 , 0.001 , -0.047 , 0.024 , 5.7 , 15.3 , 57.8 , 225 , '4600485905031430000099m9990000000058000000g8270,N,00E000=-00.000' , 0 , 0 , 1666609446 , 1666609446) [ RunTime:0.000613s ]
---------------------------------------------------------------
[ 2022-10-24T19:44:14+08:00 ] 117.132.192.144 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211
[ sql ] [ DB ] CONNECT:[ UseTime:0.002095s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012242s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000640s ]
---------------------------------------------------------------
[ 2022-10-24T19:44:15+08:00 ] 117.132.192.144 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1666611854&v1=0.026097&v2=0.060916&v3=0.021883&v4=-0.001716&v5=6.660000&t=11.902085&h=65.090698&rssi=21&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009738s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000623s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1666611854,`v1`=0.026097,`v2`=0.060916,`v3`=0.021883,`v4`=-0.001716,`v5`=6.66,`t`=11.902085,`h`=65.090698,`rssi`=21,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1666611855 WHERE `imei` = '868922055644211' [ RunTime:0.000551s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010604s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1666611854 , 0.026097 , 0.060916 , 0.021883 , -0.001716 , 6.66 , 11.902085 , 65.090698 , 21 , '89860426102071188505' , '460044618415255' , -0 , 1666611855) [ RunTime:0.000642s ]
---------------------------------------------------------------
[ 2022-10-24T20:03:58+08:00 ] 218.204.253.101 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002140s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008587s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000614s ]
---------------------------------------------------------------
[ 2022-10-24T20:04:06+08:00 ] 218.204.253.101 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=200301&v1=-00.744&v2=+00.001&v3=-00.084&v4=+00.026&v5=06.0&t=+14.6&h=57.7&rssi=+227&ccid=4600485905031430000099m9990000000063000000g8210,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009586s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000911s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='200301',`v1`=-0.744,`v2`=0.001,`v3`=-0.084,`v4`=0.026,`v5`=6,`t`=14.6,`h`=57.7,`rssi`=227,`ccid`='4600485905031430000099m9990000000063000000g8210,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666613046 WHERE `imei` = '868922055644013' [ RunTime:0.000498s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010028s ]
[ 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' , '221024' , '200301' , -0.744 , 0.001 , -0.084 , 0.026 , 6 , 14.6 , 57.7 , 227 , '4600485905031430000099m9990000000063000000g8210,N,00E000=-00.000' , 0 , 0 , 1666613046 , 1666613046) [ RunTime:0.000479s ]
---------------------------------------------------------------
[ 2022-10-24T21:03:55+08:00 ] 39.144.3.183 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002075s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008251s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000630s ]
---------------------------------------------------------------
[ 2022-10-24T21:03:57+08:00 ] 39.144.4.174 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001418s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.017933s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000693s ]
---------------------------------------------------------------
[ 2022-10-24T21:04:04+08:00 ] 39.144.3.183 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221024&time=210301&v1=-00.905&v2=+00.040&v3=-00.979&v4=-00.039&v5=06.2&t=+12.0&h=54.4&rssi=+231&ccid=4600485905031420000099m9990000000102000000g9320,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001431s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009858s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000668s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221024',`time`='210301',`v1`=-0.905,`v2`=0.04,`v3`=-0.979,`v4`=-0.039,`v5`=6.2,`t`=12,`h`=54.4,`rssi`=231,`ccid`='4600485905031420000099m9990000000102000000g9320,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666616644 WHERE `imei` = '868922055643643' [ RunTime:0.000615s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010760s ]
[ 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' , '221024' , '210301' , -0.905 , 0.04 , -0.979 , -0.039 , 6.2 , 12 , 54.4 , 231 , '4600485905031420000099m9990000000102000000g9320,N,00E000=-00.000' , 0 , 0 , 1666616644 , 1666616644) [ RunTime:0.000593s ]
---------------------------------------------------------------
[ 2022-10-24T21:04:06+08:00 ] 39.144.4.174 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=210301&v1=-00.737&v2=+00.001&v3=-00.194&v4=+00.033&v5=05.9&t=+13.8&h=57.8&rssi=+227&ccid=4600485905031430000099m9990000000060000000g8130,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001530s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009747s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000609s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='210301',`v1`=-0.737,`v2`=0.001,`v3`=-0.194,`v4`=0.033,`v5`=5.9,`t`=13.8,`h`=57.8,`rssi`=227,`ccid`='4600485905031430000099m9990000000060000000g8130,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666616646 WHERE `imei` = '868922055644013' [ RunTime:0.000476s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010715s ]
[ 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' , '221024' , '210301' , -0.737 , 0.001 , -0.194 , 0.033 , 5.9 , 13.8 , 57.8 , 227 , '4600485905031430000099m9990000000060000000g8130,N,00E000=-00.000' , 0 , 0 , 1666616646 , 1666616646) [ RunTime:0.000562s ]
---------------------------------------------------------------
[ 2022-10-24T22:03:58+08:00 ] 218.204.252.26 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002210s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008088s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000622s ]
---------------------------------------------------------------
[ 2022-10-24T22:04:07+08:00 ] 218.204.252.26 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=220301&v1=-00.731&v2=+00.001&v3=-00.285&v4=+00.038&v5=05.9&t=+12.8&h=58.1&rssi=+227&ccid=4600485905031430000099m9990000000088000000g8060,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010693s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000600s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='220301',`v1`=-0.731,`v2`=0.001,`v3`=-0.285,`v4`=0.038,`v5`=5.9,`t`=12.8,`h`=58.1,`rssi`=227,`ccid`='4600485905031430000099m9990000000088000000g8060,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666620247 WHERE `imei` = '868922055644013' [ RunTime:0.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009399s ]
[ 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' , '221024' , '220301' , -0.731 , 0.001 , -0.285 , 0.038 , 5.9 , 12.8 , 58.1 , 227 , '4600485905031430000099m9990000000088000000g8060,N,00E000=-00.000' , 0 , 0 , 1666620247 , 1666620247) [ RunTime:0.000698s ]
---------------------------------------------------------------
[ 2022-10-24T22:07:51+08:00 ] 39.144.2.191 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.001686s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009575s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000925s ]
---------------------------------------------------------------
[ 2022-10-24T22:07:59+08:00 ] 39.144.2.191 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221024&time=220701&v1=-01.281&v2=+00.029&v3=-01.123&v4=-00.763&v5=05.9&t=+10.5&h=81.4&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.185&a2=01.298&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001386s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009579s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000635s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221024',`time`='220701',`v1`=-1.281,`v2`=0.029,`v3`=-1.123,`v4`=-0.763,`v5`=5.9,`t`=10.5,`h`=81.4,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.185,`a2`=1.298,`update_time`=1666620479 WHERE `imei` = '868922055684076' [ RunTime:0.000564s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011185s ]
[ 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' , '221024' , '220701' , -1.281 , 0.029 , -1.123 , -0.763 , 5.9 , 10.5 , 81.4 , 227 , '460044618415249' , -0 , 0.185 , 1.298 , 1666620479 , 1666620479) [ RunTime:0.000691s ]
---------------------------------------------------------------
[ 2022-10-24T23:03:58+08:00 ] 39.144.12.117 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ 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.010125s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000637s ]
---------------------------------------------------------------
[ 2022-10-24T23:04:06+08:00 ] 39.144.12.117 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221024&time=230301&v1=-00.730&v2=+00.001&v3=-00.223&v4=+00.035&v5=05.9&t=+11.5&h=58.3&rssi=+225&ccid=4600485905031430000099m9990000000078000000g8020,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001731s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009898s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000649s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221024',`time`='230301',`v1`=-0.73,`v2`=0.001,`v3`=-0.223,`v4`=0.035,`v5`=5.9,`t`=11.5,`h`=58.3,`rssi`=225,`ccid`='4600485905031430000099m9990000000078000000g8020,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1666623846 WHERE `imei` = '868922055644013' [ RunTime:0.000553s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009746s ]
[ 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' , '221024' , '230301' , -0.73 , 0.001 , -0.223 , 0.035 , 5.9 , 11.5 , 58.3 , 225 , '4600485905031430000099m9990000000078000000g8020,N,00E000=-00.000' , 0 , 0 , 1666623846 , 1666623846) [ RunTime:0.000617s ]