--------------------------------------------------------------- [ 2024-03-20T01:57:52+08:00 ] 221.178.125.210 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.003511s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012937s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000729s ] --------------------------------------------------------------- [ 2024-03-20T01:58:00+08:00 ] 221.178.125.210 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240320&time=015701&v1=-00.064&v2=+00.001&v3=+00.017&v4=-00.008&v5=05.7&t=+05.6&h=72.1&rssi=+221&ccid=4600485905031430000099m9990000000036000000g0620,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002166s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010473s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='240320',`time`='015701',`v1`=-0.064,`v2`=0.001,`v3`=0.017,`v4`=-0.008,`v5`=5.7,`t`=5.6,`h`=72.1,`rssi`=221,`ccid`='4600485905031430000099m9990000000036000000g0620,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1710871080 WHERE `imei` = '868922055644013' [ RunTime:0.000844s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013753s ] [ 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' , '240320' , '015701' , -0.064 , 0.001 , 0.017 , -0.008 , 5.7 , 5.6 , 72.1 , 221 , '4600485905031430000099m9990000000036000000g0620,N,00E000=-00.000' , 0 , 0 , 1710871080 , 1710871080) [ RunTime:0.008146s ] --------------------------------------------------------------- [ 2024-03-20T07:56:42+08:00 ] 124.129.68.57 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003282s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016131s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000580s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001919s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001603s ] --------------------------------------------------------------- [ 2024-03-20T08:17:54+08:00 ] 39.144.4.142 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012440s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000795s ] --------------------------------------------------------------- [ 2024-03-20T08:17:55+08:00 ] 39.144.4.142 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710893874&v1=-2.658734&v2=0.564903&v3=-1.111004&v4=-1.119823&v5=6.300000&t=8.706006&h=77.374023&rssi=30&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.426608,36.322914&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002277s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012963s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710893874,`v1`=-2.658734,`v2`=0.564903,`v3`=-1.111004,`v4`=-1.119823,`v5`=6.3,`t`=8.706006,`h`=77.374023,`rssi`=30,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.426608,36.322914',`update_time`=1710893875 WHERE `imei` = '868922055684209' [ RunTime:0.001058s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019278s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710893874 , -2.658734 , 0.564903 , -1.111004 , -1.119823 , 6.3 , 8.706006 , 77.374023 , 30 , '898604650119C1078511' , '460048590708511' , -0 , '120.426608,36.322914' , 1710893875) [ RunTime:0.006484s ] --------------------------------------------------------------- [ 2024-03-20T08:24:09+08:00 ] 39.144.10.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.003402s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012688s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000695s ] --------------------------------------------------------------- [ 2024-03-20T08:24:10+08:00 ] 39.144.10.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710894249&v1=-1.182974&v2=0.056286&v3=-1.043790&v4=-0.514264&v5=6.120000&t=3.847537&h=77.396912&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ 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.011645s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001134s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710894249,`v1`=-1.182974,`v2`=0.056286,`v3`=-1.04379,`v4`=-0.514264,`v5`=6.12,`t`=3.847537,`h`=77.396912,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710894250 WHERE `imei` = '868922055644021' [ RunTime:0.001023s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014784s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710894249 , -1.182974 , 0.056286 , -1.04379 , -0.514264 , 6.12 , 3.847537 , 77.396912 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1710894250) [ RunTime:0.001940s ] --------------------------------------------------------------- [ 2024-03-20T08:29:07+08:00 ] 124.129.68.57 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002362s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010279s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000389s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000899s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001165s ] --------------------------------------------------------------- [ 2024-03-20T17:51:08+08:00 ] 124.129.68.57 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012944s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000424s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001062s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001408s ] --------------------------------------------------------------- [ 2024-03-20T18:19:50+08:00 ] 112.224.194.182 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002746s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011868s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000393s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001320s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001215s ] --------------------------------------------------------------- [ 2024-03-20T18:21:04+08:00 ] 112.224.194.182 GET /admin/show/read/id/41/imei/868922055644021.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001768s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012255s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000786s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012426s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.066505s ] --------------------------------------------------------------- [ 2024-03-20T20:18:22+08:00 ] 39.144.112.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002405s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014120s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000929s ] --------------------------------------------------------------- [ 2024-03-20T20:18:23+08:00 ] 39.144.112.41 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1710937102&v1=-0.789201&v2=0.531050&v3=-0.987171&v4=-0.728880&v5=6.480000&t=5.713704&h=79.273743&rssi=29&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428359,36.323213&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002031s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011243s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000973s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1710937102,`v1`=-0.789201,`v2`=0.53105,`v3`=-0.987171,`v4`=-0.72888,`v5`=6.48,`t`=5.713704,`h`=79.273743,`rssi`=29,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428359,36.323213',`update_time`=1710937103 WHERE `imei` = '868922055684209' [ RunTime:0.001353s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.019798s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1710937102 , -0.789201 , 0.53105 , -0.987171 , -0.72888 , 6.48 , 5.713704 , 79.273743 , 29 , '898604650119C1078511' , '460048590708511' , -0 , '120.428359,36.323213' , 1710937103) [ RunTime:0.000983s ] --------------------------------------------------------------- [ 2024-03-20T20:26:09+08:00 ] 39.144.112.32 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.003189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013687s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000755s ] --------------------------------------------------------------- [ 2024-03-20T20:26:10+08:00 ] 39.144.112.32 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1710937569&v1=-1.184178&v2=0.056818&v3=-1.039245&v4=-0.519020&v5=6.300000&t=5.241799&h=79.342407&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.020099s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011295s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1710937569,`v1`=-1.184178,`v2`=0.056818,`v3`=-1.039245,`v4`=-0.51902,`v5`=6.3,`t`=5.241799,`h`=79.342407,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1710937570 WHERE `imei` = '868922055644021' [ RunTime:0.000690s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012077s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1710937569 , -1.184178 , 0.056818 , -1.039245 , -0.51902 , 6.3 , 5.241799 , 79.342407 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1710937570) [ RunTime:0.000608s ]