---------------------------------------------------------------
[ 2023-01-29T02:03:55+08:00 ] 39.144.2.84 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002424s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013708s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000798s ]
---------------------------------------------------------------
[ 2023-01-29T02:03:56+08:00 ] 223.104.255.185 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001957s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009970s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000777s ]
---------------------------------------------------------------
[ 2023-01-29T02:04:04+08:00 ] 39.144.2.84 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230129&time=020301&v1=-00.286&v2=+00.001&v3=+00.008&v4=-00.015&v5=05.6&t=-06.2&h=64.4&rssi=+225&ccid=4600485905031430000099m9990000000034000000g3460,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001935s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011379s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000665s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230129',`time`='020301',`v1`=-0.286,`v2`=0.001,`v3`=0.008,`v4`=-0.015,`v5`=5.6,`t`=-6.2,`h`=64.4,`rssi`=225,`ccid`='4600485905031430000099m9990000000034000000g3460,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674929044  WHERE  `imei` = '868922055644013' [ RunTime:0.000596s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012757s ]
[ 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' , '230129' , '020301' , -0.286 , 0.001 , 0.008 , -0.015 , 5.6 , -6.2 , 64.4 , 225 , '4600485905031430000099m9990000000034000000g3460,N,00E000=-00.000' , 0 , 0 , 1674929044 , 1674929044) [ RunTime:0.000684s ]
---------------------------------------------------------------
[ 2023-01-29T02:04:04+08:00 ] 223.104.255.185 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230129&time=020301&v1=-01.253&v2=+00.021&v3=-00.928&v4=-00.036&v5=05.9&t=-07.8&h=61.4&rssi=+230&ccid=4600485905031420000099m9990000000300000001g2680,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002300s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011303s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000699s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230129',`time`='020301',`v1`=-1.253,`v2`=0.021,`v3`=-0.928,`v4`=-0.036,`v5`=5.9,`t`=-7.8,`h`=61.4,`rssi`=230,`ccid`='4600485905031420000099m9990000000300000001g2680,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674929044  WHERE  `imei` = '868922055643643' [ RunTime:0.000573s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011903s ]
[ 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' , '230129' , '020301' , -1.253 , 0.021 , -0.928 , -0.036 , 5.9 , -7.8 , 61.4 , 230 , '4600485905031420000099m9990000000300000001g2680,N,00E000=-00.000' , 0 , 0 , 1674929044 , 1674929044) [ RunTime:0.000582s ]
---------------------------------------------------------------
[ 2023-01-29T06:14:39+08:00 ] 117.132.194.117 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002806s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011659s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000770s ]
---------------------------------------------------------------
[ 2023-01-29T06:14:48+08:00 ] 117.132.194.117 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230129&time=061401&v1=-01.264&v2=+00.016&v3=-01.092&v4=-00.673&v5=05.6&t=-02.8&h=80.3&rssi=+227&imsi=460044618415249&v6=-00.000&a1=00.203&a2=01.280&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002551s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011215s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000743s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230129',`time`='061401',`v1`=-1.264,`v2`=0.016,`v3`=-1.092,`v4`=-0.673,`v5`=5.6,`t`=-2.8,`h`=80.3,`rssi`=227,`imsi`='460044618415249',`v6`=-0,`a1`=0.203,`a2`=1.28,`update_time`=1674944088  WHERE  `imei` = '868922055684076' [ RunTime:0.000650s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010042s ]
[ 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' , '230129' , '061401' , -1.264 , 0.016 , -1.092 , -0.673 , 5.6 , -2.8 , 80.3 , 227 , '460044618415249' , -0 , 0.203 , 1.28 , 1674944088 , 1674944088) [ RunTime:0.001911s ]
---------------------------------------------------------------
[ 2023-01-29T13:36:15+08:00 ] 123.232.5.21 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003006s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012582s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'biandianzhan'  AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.001319s ]
---------------------------------------------------------------
[ 2023-01-29T13:36:17+08:00 ] 123.232.5.21 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001626s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011788s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000832s ]
---------------------------------------------------------------
[ 2023-01-29T13:36:24+08:00 ] 123.232.5.21 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001564s ] 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 COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000728s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000692s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012100s ]
[ 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.000478s ]
[ 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.000490s ]
---------------------------------------------------------------
[ 2023-01-29T13:36:29+08:00 ] 123.232.5.21 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002064s ] 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 COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000714s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000593s ]
---------------------------------------------------------------
[ 2023-01-29T13:36:53+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011063s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000739s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010166s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001793s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.007472s ]
---------------------------------------------------------------
[ 2023-01-29T13:37:08+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=43
[ sql ] [ DB ] CONNECT:[ UseTime:0.001915s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008974s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000707s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011546s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 420,10 [ RunTime:0.005476s ]
---------------------------------------------------------------
[ 2023-01-29T13:37:10+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=39
[ sql ] [ DB ] CONNECT:[ UseTime:0.001600s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009763s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000757s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010590s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000693s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 380,10 [ RunTime:0.005845s ]
---------------------------------------------------------------
[ 2023-01-29T13:37:17+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=37
[ sql ] [ DB ] CONNECT:[ UseTime:0.001737s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010459s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000656s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010893s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000631s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 360,10 [ RunTime:0.005198s ]
---------------------------------------------------------------
[ 2023-01-29T13:37:23+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=36
[ sql ] [ DB ] CONNECT:[ UseTime:0.001995s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009333s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000645s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010169s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000695s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 350,10 [ RunTime:0.005198s ]
---------------------------------------------------------------
[ 2023-01-29T13:37:26+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=35
[ sql ] [ DB ] CONNECT:[ UseTime:0.002138s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008780s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000643s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008988s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000660s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 340,10 [ RunTime:0.005104s ]
---------------------------------------------------------------
[ 2023-01-29T13:37:31+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=33
[ sql ] [ DB ] CONNECT:[ UseTime:0.002869s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010922s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000665s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009567s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000716s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 320,10 [ RunTime:0.005008s ]
---------------------------------------------------------------
[ 2023-01-29T13:38:06+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=32
[ sql ] [ DB ] CONNECT:[ UseTime:0.002156s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009484s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000767s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011549s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000635s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 310,10 [ RunTime:0.005475s ]
---------------------------------------------------------------
[ 2023-01-29T13:38:13+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=29
[ 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.011166s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000688s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010236s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000955s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 280,10 [ RunTime:0.004804s ]
---------------------------------------------------------------
[ 2023-01-29T13:38:22+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=26
[ sql ] [ DB ] CONNECT:[ UseTime:0.002503s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010478s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000924s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012129s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000687s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 250,10 [ RunTime:0.005689s ]
---------------------------------------------------------------
[ 2023-01-29T13:38:27+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=23
[ sql ] [ DB ] CONNECT:[ UseTime:0.002145s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011023s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000781s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009647s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000679s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 220,10 [ RunTime:0.004459s ]
---------------------------------------------------------------
[ 2023-01-29T13:38:36+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=20
[ sql ] [ DB ] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009768s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000727s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011364s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000698s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 190,10 [ RunTime:0.005005s ]
---------------------------------------------------------------
[ 2023-01-29T13:38:45+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=17
[ sql ] [ DB ] CONNECT:[ UseTime:0.001744s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011279s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000706s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010512s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 160,10 [ RunTime:0.004077s ]
---------------------------------------------------------------
[ 2023-01-29T13:39:15+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=15
[ sql ] [ DB ] CONNECT:[ UseTime:0.001990s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009823s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000716s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010844s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000639s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 140,10 [ RunTime:0.004027s ]
---------------------------------------------------------------
[ 2023-01-29T13:39:31+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=12
[ sql ] [ DB ] CONNECT:[ UseTime:0.002396s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009706s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000757s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010157s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000699s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 110,10 [ RunTime:0.004417s ]
---------------------------------------------------------------
[ 2023-01-29T13:39:55+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=9
[ sql ] [ DB ] CONNECT:[ UseTime:0.002418s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011673s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000918s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011893s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000644s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 80,10 [ RunTime:0.003751s ]
---------------------------------------------------------------
[ 2023-01-29T13:40:08+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=11
[ sql ] [ DB ] CONNECT:[ UseTime:0.001974s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010584s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000650s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010750s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000647s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 100,10 [ RunTime:0.003803s ]
---------------------------------------------------------------
[ 2023-01-29T13:40:13+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html?page=13
[ sql ] [ DB ] CONNECT:[ UseTime:0.002421s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010364s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000940s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011906s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000678s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 120,10 [ RunTime:0.004266s ]
---------------------------------------------------------------
[ 2023-01-29T13:40:53+08:00 ] 123.232.5.21 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001855s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012230s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000711s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.001121s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010005s ]
[ 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.000356s ]
[ 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.000435s ]
---------------------------------------------------------------
[ 2023-01-29T13:40:59+08:00 ] 123.232.5.21 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002253s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008814s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000772s ]
---------------------------------------------------------------
[ 2023-01-29T13:41:01+08:00 ] 123.232.5.21 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010192s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000535s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000735s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000914s ]
---------------------------------------------------------------
[ 2023-01-29T13:41:07+08:00 ] 123.232.5.21 GET /home/show/edit/id/33.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002368s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011249s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008934s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000465s ]
---------------------------------------------------------------
[ 2023-01-29T13:41:11+08:00 ] 123.232.5.21 POST /home/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002212s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010967s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `interval`=720,`gps`='120.001126,36.338007',`introduce`='<p>胶州变电站1号避雷针下</p><p>2022.10.22</p>',`update_time`=1674970871  WHERE  `id` = 33 [ RunTime:0.000741s ]
---------------------------------------------------------------
[ 2023-01-29T13:41:12+08:00 ] 123.232.5.21 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001653s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009994s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000510s ]
[ 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.000669s ]
---------------------------------------------------------------
[ 2023-01-29T13:41:31+08:00 ] 123.232.5.21 GET /home/show/read/id/32/imei/868922055643643.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001592s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010090s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 32 LIMIT 1 [ RunTime:0.000693s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009871s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001635s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002730s ]
---------------------------------------------------------------
[ 2023-01-29T13:42:17+08:00 ] 123.232.5.21 GET /home/show/read/id/32/imei/868922055643643.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002136s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010828s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 32 LIMIT 1 [ RunTime:0.000712s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011263s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000603s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.002826s ]
---------------------------------------------------------------
[ 2023-01-29T13:42:25+08:00 ] 123.232.5.21 GET /home/show/read/id/32/imei/868922055643643.html?page=8
[ sql ] [ DB ] CONNECT:[ UseTime:0.001682s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011044s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 32 LIMIT 1 [ RunTime:0.000913s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011837s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000945s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 70,10 [ RunTime:0.003110s ]
---------------------------------------------------------------
[ 2023-01-29T13:43:03+08:00 ] 123.232.5.21 GET /home/show/read/id/32/imei/868922055643643.html?page=9
[ sql ] [ DB ] CONNECT:[ UseTime:0.002389s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011205s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 32 LIMIT 1 [ RunTime:0.000668s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011344s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000602s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 80,10 [ RunTime:0.003224s ]
---------------------------------------------------------------
[ 2023-01-29T13:50:01+08:00 ] 123.232.5.21 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002435s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010412s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000577s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000759s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000668s ]
---------------------------------------------------------------
[ 2023-01-29T13:50:03+08:00 ] 123.232.5.21 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002424s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009694s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `id` = 33 LIMIT 1 [ RunTime:0.000726s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010312s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000716s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003396s ]
---------------------------------------------------------------
[ 2023-01-29T13:50:32+08:00 ] 123.232.5.21 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002383s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012790s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000594s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000740s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000617s ]
---------------------------------------------------------------
[ 2023-01-29T13:50:34+08:00 ] 123.232.5.21 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001748s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010843s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000785s ]
---------------------------------------------------------------
[ 2023-01-29T14:03:55+08:00 ] 39.144.1.98 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002238s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010790s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000712s ]
---------------------------------------------------------------
[ 2023-01-29T14:03:56+08:00 ] 39.144.2.226 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001807s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010057s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000680s ]
---------------------------------------------------------------
[ 2023-01-29T14:04:03+08:00 ] 39.144.1.98 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230129&time=140301&v1=-01.254&v2=+00.048&v3=-00.931&v4=-00.035&v5=05.7&t=+07.9&h=60.9&rssi=+230&ccid=4600485905031420000099m9990000000297000001g2680,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012250s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000852s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230129',`time`='140301',`v1`=-1.254,`v2`=0.048,`v3`=-0.931,`v4`=-0.035,`v5`=5.7,`t`=7.9,`h`=60.9,`rssi`=230,`ccid`='4600485905031420000099m9990000000297000001g2680,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674972243  WHERE  `imei` = '868922055643643' [ RunTime:0.000672s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012067s ]
[ 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' , '230129' , '140301' , -1.254 , 0.048 , -0.931 , -0.035 , 5.7 , 7.9 , 60.9 , 230 , '4600485905031420000099m9990000000297000001g2680,N,00E000=-00.000' , 0 , 0 , 1674972243 , 1674972243) [ RunTime:0.001471s ]
---------------------------------------------------------------
[ 2023-01-29T14:04:04+08:00 ] 39.144.2.226 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230129&time=140301&v1=-00.261&v2=+00.001&v3=+00.019&v4=-00.015&v5=05.9&t=+09.1&h=64.8&rssi=+228&ccid=4600485905031430000099m9990000000037000000g3180,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001934s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011894s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001153s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230129',`time`='140301',`v1`=-0.261,`v2`=0.001,`v3`=0.019,`v4`=-0.015,`v5`=5.9,`t`=9.1,`h`=64.8,`rssi`=228,`ccid`='4600485905031430000099m9990000000037000000g3180,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1674972244  WHERE  `imei` = '868922055644013' [ RunTime:0.000561s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011282s ]
[ 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' , '230129' , '140301' , -0.261 , 0.001 , 0.019 , -0.015 , 5.9 , 9.1 , 64.8 , 228 , '4600485905031430000099m9990000000037000000g3180,N,00E000=-00.000' , 0 , 0 , 1674972244 , 1674972244) [ RunTime:0.000545s ]