stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1680741591 WHERE `id` = 22 [ RunTime:0.000577s ] --------------------------------------------------------------- [ 2023-04-06T08:39:52+08:00 ] 27.193.85.51 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001588s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010460s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000386s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000775s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000886s ] --------------------------------------------------------------- [ 2023-04-06T08:39:54+08:00 ] 27.193.85.51 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001597s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009580s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001033s ] --------------------------------------------------------------- [ 2023-04-06T08:40:11+08:00 ] 27.193.85.51 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010445s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000425s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000823s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000956s ] --------------------------------------------------------------- [ 2023-04-06T08:40:13+08:00 ] 27.193.85.51 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.003862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009564s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000397s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000954s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000955s ] --------------------------------------------------------------- [ 2023-04-06T08:40:16+08:00 ] 27.193.85.51 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001736s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010583s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010397s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000449s ] --------------------------------------------------------------- [ 2023-04-06T08:40:36+08:00 ] 27.193.85.51 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001873s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010503s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=2,`gps`='120.179380,35.985614',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1680741636 WHERE `id` = 22 [ RunTime:0.000775s ] --------------------------------------------------------------- [ 2023-04-06T08:40:37+08:00 ] 27.193.85.51 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001621s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010162s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000412s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000881s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001119s ] --------------------------------------------------------------- [ 2023-04-06T08:40:38+08:00 ] 27.193.85.51 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002605s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008597s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001003s ] --------------------------------------------------------------- [ 2023-04-06T08:43:44+08:00 ] 111.55.137.212 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002799s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012100s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000762s ] --------------------------------------------------------------- [ 2023-04-06T08:43:45+08:00 ] 111.55.137.212 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680741824&v1=0.006712&v2=1.587048&v3=0.006773&v4=0.007134&v5=13.140000&t=15.205313&h=60.848804&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.000000,0.000000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002393s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010361s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000740s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680741824,`v1`=0.006712,`v2`=1.587048,`v3`=0.006773,`v4`=0.007134,`v5`=13.14,`t`=15.205313,`h`=60.848804,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.000000,0.000000',`update_time`=1680741825 WHERE `imei` = '868922055677740' [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010525s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680741824 , 0.006712 , 1.587048 , 0.006773 , 0.007134 , 13.14 , 15.205313 , 60.848804 , 22 , '89860426102071188504' , '460044618415254' , -0 , '0.000000,0.000000' , 1680741825) [ RunTime:0.000881s ] --------------------------------------------------------------- [ 2023-04-06T08:46:46+08:00 ] 111.55.136.85 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001843s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010944s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-04-06T08:46:47+08:00 ] 111.55.136.85 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680742006&v1=0.007134&v2=2.331495&v3=0.007074&v4=0.007134&v5=13.140000&t=16.503048&h=60.597034&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.000000,0.000000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001758s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009960s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680742006,`v1`=0.007134,`v2`=2.331495,`v3`=0.007074,`v4`=0.007134,`v5`=13.14,`t`=16.503048,`h`=60.597034,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.000000,0.000000',`update_time`=1680742007 WHERE `imei` = '868922055677740' [ RunTime:0.000508s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010253s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680742006 , 0.007134 , 2.331495 , 0.007074 , 0.007134 , 13.14 , 16.503048 , 60.597034 , 23 , '89860426102071188504' , '460044618415254' , -0 , '0.000000,0.000000' , 1680742007) [ RunTime:0.000533s ] --------------------------------------------------------------- [ 2023-04-06T08:56:28+08:00 ] 39.144.7.7 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002430s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011288s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-04-06T08:59:49+08:00 ] 117.132.194.150 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009915s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-04-06T08:59:50+08:00 ] 117.132.194.150 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680742789&v1=0.007013&v2=1.829147&v3=0.006923&v4=0.007134&v5=13.140000&t=15.645041&h=59.918015&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.000000,0.000000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002060s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010945s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680742789,`v1`=0.007013,`v2`=1.829147,`v3`=0.006923,`v4`=0.007134,`v5`=13.14,`t`=15.645041,`h`=59.918015,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.000000,0.000000',`update_time`=1680742790 WHERE `imei` = '868922055677740' [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011121s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680742789 , 0.007013 , 1.829147 , 0.006923 , 0.007134 , 13.14 , 15.645041 , 59.918015 , 23 , '89860426102071188504' , '460044618415254' , -0 , '0.000000,0.000000' , 1680742790) [ RunTime:0.000537s ] --------------------------------------------------------------- [ 2023-04-06T08:59:51+08:00 ] 117.132.194.150 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680742588&v1=0.006773&v2=1.681238&v3=0.006803&v4=0.006953&v5=13.140000&t=14.980086&h=61.802479&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002115s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010378s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680742588,`v1`=0.006773,`v2`=1.681238,`v3`=0.006803,`v4`=0.006953,`v5`=13.14,`t`=14.980086,`h`=61.802479,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680742791 WHERE `imei` = '868922055677740' [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011135s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680742588 , 0.006773 , 1.681238 , 0.006803 , 0.006953 , 13.14 , 14.980086 , 61.802479 , 23 , '89860426102071188504' , '460044618415254' , -0 , 1680742791) [ RunTime:0.000512s ] --------------------------------------------------------------- [ 2023-04-06T09:02:16+08:00 ] 117.132.192.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001856s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011915s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000752s ] --------------------------------------------------------------- [ 2023-04-06T09:02:18+08:00 ] 117.132.192.227 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680742936&v1=0.006773&v2=1.810372&v3=0.006712&v4=0.007254&v5=13.140000&t=16.181295&h=58.140366&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.000000,0.000000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002171s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011713s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680742936,`v1`=0.006773,`v2`=1.810372,`v3`=0.006712,`v4`=0.007254,`v5`=13.14,`t`=16.181295,`h`=58.140366,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.000000,0.000000',`update_time`=1680742938 WHERE `imei` = '868922055677740' [ RunTime:0.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011139s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680742936 , 0.006773 , 1.810372 , 0.006712 , 0.007254 , 13.14 , 16.181295 , 58.140366 , 23 , '89860426102071188504' , '460044618415254' , -0 , '0.000000,0.000000' , 1680742938) [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2023-04-06T09:08:20+08:00 ] 117.132.195.12 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002723s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011232s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2023-04-06T09:08:21+08:00 ] 117.132.195.12 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680743300&v1=0.006893&v2=1.759782&v3=0.006923&v4=0.007134&v5=13.140000&t=15.409089&h=60.345261&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=35.985082,120.185087&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001759s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009812s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680743300,`v1`=0.006893,`v2`=1.759782,`v3`=0.006923,`v4`=0.007134,`v5`=13.14,`t`=15.409089,`h`=60.345261,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='35.985082,120.185087',`update_time`=1680743301 WHERE `imei` = '868922055677740' [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009654s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680743300 , 0.006893 , 1.759782 , 0.006923 , 0.007134 , 13.14 , 15.409089 , 60.345261 , 23 , '89860426102071188504' , '460044618415254' , -0 , '35.985082,120.185087' , 1680743301) [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2023-04-06T09:08:36+08:00 ] 27.193.85.51 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009406s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001046s ] --------------------------------------------------------------- [ 2023-04-06T09:08:40+08:00 ] 27.193.85.51 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002170s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010481s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000415s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000829s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001637s ] --------------------------------------------------------------- [ 2023-04-06T09:08:42+08:00 ] 27.193.85.51 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.002495s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010547s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000346s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000946s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000852s ] --------------------------------------------------------------- [ 2023-04-06T09:08:45+08:00 ] 27.193.85.51 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001805s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011478s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000813s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010271s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000616s ] --------------------------------------------------------------- [ 2023-04-06T09:09:09+08:00 ] 27.193.85.51 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002638s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009767s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=2,`gps`='120.185087,35.985082',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1680743349 WHERE `id` = 22 [ RunTime:0.000560s ] --------------------------------------------------------------- [ 2023-04-06T09:09:10+08:00 ] 27.193.85.51 GET /admin/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.010064s ] [ 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.000781s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000918s ] --------------------------------------------------------------- [ 2023-04-06T09:09:11+08:00 ] 27.193.85.51 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002694s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009306s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001004s ] --------------------------------------------------------------- [ 2023-04-06T09:11:35+08:00 ] 39.144.16.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002340s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011986s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000844s ] --------------------------------------------------------------- [ 2023-04-06T09:11:37+08:00 ] 39.144.16.139 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680743495&v1=0.006893&v2=2.575264&v3=0.006953&v4=0.007254&v5=13.140000&t=15.816643&h=59.071152&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=120.185087,35.985082&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001961s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010879s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000907s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680743495,`v1`=0.006893,`v2`=2.575264,`v3`=0.006953,`v4`=0.007254,`v5`=13.14,`t`=15.816643,`h`=59.071152,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='120.185087,35.985082',`update_time`=1680743497 WHERE `imei` = '868922055677740' [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011080s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680743495 , 0.006893 , 2.575264 , 0.006953 , 0.007254 , 13.14 , 15.816643 , 59.071152 , 23 , '89860426102071188504' , '460044618415254' , -0 , '120.185087,35.985082' , 1680743497) [ RunTime:0.000570s ] --------------------------------------------------------------- [ 2023-04-06T09:11:51+08:00 ] 27.193.85.51 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001445s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009261s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001036s ] --------------------------------------------------------------- [ 2023-04-06T09:18:08+08:00 ] 221.178.125.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.010598s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000659s ] --------------------------------------------------------------- [ 2023-04-06T09:18:09+08:00 ] 221.178.125.41 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680743888&v1=0.007134&v2=1.940548&v3=0.007164&v4=0.007254&v5=13.140000&t=16.578123&h=57.804672&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010512s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680743888,`v1`=0.007134,`v2`=1.940548,`v3`=0.007164,`v4`=0.007254,`v5`=13.14,`t`=16.578123,`h`=57.804672,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680743889 WHERE `imei` = '868922055677740' [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011233s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680743888 , 0.007134 , 1.940548 , 0.007164 , 0.007254 , 13.14 , 16.578123 , 57.804672 , 23 , '89860426102071188504' , '460044618415254' , -0 , 1680743889) [ RunTime:0.000704s ] --------------------------------------------------------------- [ 2023-04-06T09:23:11+08:00 ] 117.132.197.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003432s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011086s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2023-04-06T09:23:12+08:00 ] 117.132.197.20 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680744191&v1=0.006953&v2=3.341824&v3=0.006893&v4=0.007134&v5=13.140000&t=15.838093&h=60.795399&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001579s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010671s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680744191,`v1`=0.006953,`v2`=3.341824,`v3`=0.006893,`v4`=0.007134,`v5`=13.14,`t`=15.838093,`h`=60.795399,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680744192 WHERE `imei` = '868922055677740' [ RunTime:0.000524s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011162s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680744191 , 0.006953 , 3.341824 , 0.006893 , 0.007134 , 13.14 , 15.838093 , 60.795399 , 23 , '89860426102071188504' , '460044618415254' , -0 , 1680744192) [ RunTime:0.000526s ] --------------------------------------------------------------- [ 2023-04-06T09:26:49+08:00 ] 111.55.141.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002165s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010204s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000758s ] --------------------------------------------------------------- [ 2023-04-06T09:26:50+08:00 ] 111.55.141.141 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680744409&v1=0.006893&v2=1.805991&v3=0.006893&v4=0.007134&v5=13.140000&t=16.299271&h=59.696762&rssi=24&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010613s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000709s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680744409,`v1`=0.006893,`v2`=1.805991,`v3`=0.006893,`v4`=0.007134,`v5`=13.14,`t`=16.299271,`h`=59.696762,`rssi`=24,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680744410 WHERE `imei` = '868922055677740' [ RunTime:0.000559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009706s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680744409 , 0.006893 , 1.805991 , 0.006893 , 0.007134 , 13.14 , 16.299271 , 59.696762 , 24 , '89860426102071188504' , '460044618415254' , -0 , 1680744410) [ RunTime:0.000526s ] --------------------------------------------------------------- [ 2023-04-06T09:31:43+08:00 ] 39.144.17.107 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002322s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011696s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2023-04-06T09:31:45+08:00 ] 39.144.17.107 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680744703&v1=0.006953&v2=1.801819&v3=0.006863&v4=0.007194&v5=13.140000&t=15.720117&h=59.216110&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001964s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012040s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680744703,`v1`=0.006953,`v2`=1.801819,`v3`=0.006863,`v4`=0.007194,`v5`=13.14,`t`=15.720117,`h`=59.21611,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680744705 WHERE `imei` = '868922055677740' [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010055s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680744703 , 0.006953 , 1.801819 , 0.006863 , 0.007194 , 13.14 , 15.720117 , 59.21611 , 23 , '89860426102071188504' , '460044618415254' , -0 , 1680744705) [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2023-04-06T10:11:51+08:00 ] 39.144.15.130 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015252s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2023-04-06T10:11:59+08:00 ] 39.144.15.130 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230406&time=101101&v1=-01.272&v2=+00.025&v3=-01.173&v4=-00.368&v5=05.9&t=+12.5&h=79.8&rssi=+229&imsi=460044618415249&v6=-00.000&a1=00.115&a2=01.290&a3=00.000&end=$ [ 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.010015s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230406',`time`='101101',`v1`=-1.272,`v2`=0.025,`v3`=-1.173,`v4`=-0.368,`v5`=5.9,`t`=12.5,`h`=79.8,`rssi`=229,`imsi`='460044618415249',`v6`=-0,`a1`=0.115,`a2`=1.29,`update_time`=1680747119 WHERE `imei` = '868922055684076' [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011746s ] [ 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' , '230406' , '101101' , -1.272 , 0.025 , -1.173 , -0.368 , 5.9 , 12.5 , 79.8 , 229 , '460044618415249' , -0 , 0.115 , 1.29 , 1680747119 , 1680747119) [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2023-04-06T13:23:28+08:00 ] 39.144.2.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002932s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012089s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000772s ] --------------------------------------------------------------- [ 2023-04-06T13:23:29+08:00 ] 39.144.2.139 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680758608&v1=0.006833&v2=3.958389&v3=0.006893&v4=0.007013&v5=12.960000&t=15.194588&h=62.283131&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.023177,0.022678&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002459s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009544s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000662s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680758608,`v1`=0.006833,`v2`=3.958389,`v3`=0.006893,`v4`=0.007013,`v5`=12.96,`t`=15.194588,`h`=62.283131,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.023177,0.022678',`update_time`=1680758609 WHERE `imei` = '868922055677740' [ RunTime:0.000602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012444s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680758608 , 0.006833 , 3.958389 , 0.006893 , 0.007013 , 12.96 , 15.194588 , 62.283131 , 23 , '89860426102071188504' , '460044618415254' , -0 , '0.023177,0.022678' , 1680758609) [ RunTime:0.000715s ] --------------------------------------------------------------- [ 2023-04-06T14:03:54+08:00 ] 39.144.13.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002892s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011536s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2023-04-06T14:03:55+08:00 ] 117.132.198.222 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002231s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009732s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000649s ] --------------------------------------------------------------- [ 2023-04-06T14:04:03+08:00 ] 39.144.13.49 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230406&time=140301&v1=+01.179&v2=+00.005&v3=+02.875&v4=+00.344&v5=05.9&t=+14.3&h=63.1&rssi=+227&ccid=4600485905031430000099m9990000000017000004g8420,N,00E003=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001505s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011507s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230406',`time`='140301',`v1`=1.179,`v2`=0.005,`v3`=2.875,`v4`=0.344,`v5`=5.9,`t`=14.3,`h`=63.1,`rssi`=227,`ccid`='4600485905031430000099m9990000000017000004g8420,N,00E003=-00.000',`a1`=0,`a2`=0,`update_time`=1680761043 WHERE `imei` = '868922055644013' [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011924s ] [ 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' , '230406' , '140301' , 1.179 , 0.005 , 2.875 , 0.344 , 5.9 , 14.3 , 63.1 , 227 , '4600485905031430000099m9990000000017000004g8420,N,00E003=-00.000' , 0 , 0 , 1680761043 , 1680761043) [ RunTime:0.000620s ] --------------------------------------------------------------- [ 2023-04-06T14:04:04+08:00 ] 117.132.198.222 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230406&time=140301&v1=-01.321&v2=+00.042&v3=-00.985&v4=-00.022&v5=05.7&t=+14.6&h=60.4&rssi=+230&ccid=4600485905031420000099m9990000000330000001g3310,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001719s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011859s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000713s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230406',`time`='140301',`v1`=-1.321,`v2`=0.042,`v3`=-0.985,`v4`=-0.022,`v5`=5.7,`t`=14.6,`h`=60.4,`rssi`=230,`ccid`='4600485905031420000099m9990000000330000001g3310,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680761044 WHERE `imei` = '868922055643643' [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011186s ] [ 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' , '230406' , '140301' , -1.321 , 0.042 , -0.985 , -0.022 , 5.7 , 14.6 , 60.4 , 230 , '4600485905031420000099m9990000000330000001g3310,N,00E000=-00.000' , 0 , 0 , 1680761044 , 1680761044) [ RunTime:0.000593s ] --------------------------------------------------------------- [ 2023-04-06T14:46:21+08:00 ] 223.104.255.190 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002793s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010720s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2023-04-06T14:46:22+08:00 ] 223.104.255.190 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680763581&v1=0.006893&v2=0.381142&v3=0.007013&v4=0.007254&v5=13.140000&t=17.350328&h=58.331100&rssi=24&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.023177,0.022678&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001622s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009445s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680763581,`v1`=0.006893,`v2`=0.381142,`v3`=0.007013,`v4`=0.007254,`v5`=13.14,`t`=17.350328,`h`=58.3311,`rssi`=24,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.023177,0.022678',`update_time`=1680763582 WHERE `imei` = '868922055677740' [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010673s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680763581 , 0.006893 , 0.381142 , 0.007013 , 0.007254 , 13.14 , 17.350328 , 58.3311 , 24 , '89860426102071188504' , '460044618415254' , -0 , '0.023177,0.022678' , 1680763582) [ RunTime:0.000626s ] --------------------------------------------------------------- [ 2023-04-06T14:46:24+08:00 ] 223.104.255.190 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.006773&v2=0.363201&v3=0.006863&v4=0.007134&v5=-76.320000&t=16.084770&h=63.023182&rssi=24&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010334s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.006773,`v2`=0.363201,`v3`=0.006863,`v4`=0.007134,`v5`=-76.32,`t`=16.08477,`h`=63.023182,`rssi`=24,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680763584 WHERE `imei` = '868922055677740' [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011067s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041608 , 0.006773 , 0.363201 , 0.006863 , 0.007134 , -76.32 , 16.08477 , 63.023182 , 24 , '89860426102071188504' , '460044618415254' , -0 , 1680763584) [ RunTime:0.001271s ] --------------------------------------------------------------- [ 2023-04-06T14:46:25+08:00 ] 223.104.255.190 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.006953&v2=0.365078&v3=0.007043&v4=0.007495&v5=13.140000&t=17.157278&h=58.926193&rssi=24&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001608s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008305s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.006953,`v2`=0.365078,`v3`=0.007043,`v4`=0.007495,`v5`=13.14,`t`=17.157278,`h`=58.926193,`rssi`=24,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680763585 WHERE `imei` = '868922055677740' [ RunTime:0.000511s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010144s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041608 , 0.006953 , 0.365078 , 0.007043 , 0.007495 , 13.14 , 17.157278 , 58.926193 , 24 , '89860426102071188504' , '460044618415254' , -0 , 1680763585) [ RunTime:0.000567s ] --------------------------------------------------------------- [ 2023-04-06T14:46:26+08:00 ] 223.104.255.190 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.007013&v2=0.392303&v3=0.007043&v4=0.007314&v5=13.140000&t=17.135828&h=57.934372&rssi=24&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001648s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010538s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.007013,`v2`=0.392303,`v3`=0.007043,`v4`=0.007314,`v5`=13.14,`t`=17.135828,`h`=57.934372,`rssi`=24,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680763586 WHERE `imei` = '868922055677740' [ RunTime:0.000530s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009525s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041608 , 0.007013 , 0.392303 , 0.007043 , 0.007314 , 13.14 , 17.135828 , 57.934372 , 24 , '89860426102071188504' , '460044618415254' , -0 , 1680763586) [ RunTime:0.000486s ] --------------------------------------------------------------- [ 2023-04-06T14:48:52+08:00 ] 39.144.12.103 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002365s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009860s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2023-04-06T14:48:53+08:00 ] 39.144.12.103 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680763732&v1=0.006953&v2=0.518724&v3=0.007013&v4=0.007254&v5=12.960000&t=17.017851&h=58.193771&rssi=24&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.023177,0.022678&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002023s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012175s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001033s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680763732,`v1`=0.006953,`v2`=0.518724,`v3`=0.007013,`v4`=0.007254,`v5`=12.96,`t`=17.017851,`h`=58.193771,`rssi`=24,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.023177,0.022678',`update_time`=1680763733 WHERE `imei` = '868922055677740' [ RunTime:0.000559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010640s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680763732 , 0.006953 , 0.518724 , 0.007013 , 0.007254 , 12.96 , 17.017851 , 58.193771 , 24 , '89860426102071188504' , '460044618415254' , -0 , '0.023177,0.022678' , 1680763733) [ RunTime:0.000616s ] --------------------------------------------------------------- [ 2023-04-06T15:14:01+08:00 ] 39.144.5.113 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002847s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013573s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2023-04-06T15:14:02+08:00 ] 39.144.5.113 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680765241&v1=0.006592&v2=0.447482&v3=0.006773&v4=0.006953&v5=13.140000&t=14.282956&h=66.380119&rssi=20&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.023177,0.022678&end=$ [ 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.008266s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000647s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680765241,`v1`=0.006592,`v2`=0.447482,`v3`=0.006773,`v4`=0.006953,`v5`=13.14,`t`=14.282956,`h`=66.380119,`rssi`=20,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.023177,0.022678',`update_time`=1680765242 WHERE `imei` = '868922055677740' [ RunTime:0.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008798s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680765241 , 0.006592 , 0.447482 , 0.006773 , 0.006953 , 13.14 , 14.282956 , 66.380119 , 20 , '89860426102071188504' , '460044618415254' , -0 , '0.023177,0.022678' , 1680765242) [ RunTime:0.000602s ] --------------------------------------------------------------- [ 2023-04-06T15:16:35+08:00 ] 39.144.15.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010021s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2023-04-06T15:16:37+08:00 ] 39.144.15.153 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680765395&v1=0.007013&v2=0.397414&v3=0.006893&v4=0.007254&v5=13.140000&t=15.065886&h=63.381763&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.023177,0.022678&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001816s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010226s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680765395,`v1`=0.007013,`v2`=0.397414,`v3`=0.006893,`v4`=0.007254,`v5`=13.14,`t`=15.065886,`h`=63.381763,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.023177,0.022678',`update_time`=1680765397 WHERE `imei` = '868922055677740' [ RunTime:0.000526s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010133s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680765395 , 0.007013 , 0.397414 , 0.006893 , 0.007254 , 13.14 , 15.065886 , 63.381763 , 22 , '89860426102071188504' , '460044618415254' , -0 , '0.023177,0.022678' , 1680765397) [ RunTime:0.000485s ] --------------------------------------------------------------- [ 2023-04-06T15:37:09+08:00 ] 218.204.252.162 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.010934s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000674s ] --------------------------------------------------------------- [ 2023-04-06T15:37:11+08:00 ] 218.204.252.162 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680766629&v1=0.006893&v2=0.365809&v3=0.006893&v4=0.007134&v5=13.140000&t=14.990811&h=65.014458&rssi=21&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.023177,0.022678&end=$ [ 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.010849s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000778s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680766629,`v1`=0.006893,`v2`=0.365809,`v3`=0.006893,`v4`=0.007134,`v5`=13.14,`t`=14.990811,`h`=65.014458,`rssi`=21,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.023177,0.022678',`update_time`=1680766631 WHERE `imei` = '868922055677740' [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011315s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680766629 , 0.006893 , 0.365809 , 0.006893 , 0.007134 , 13.14 , 14.990811 , 65.014458 , 21 , '89860426102071188504' , '460044618415254' , -0 , '0.023177,0.022678' , 1680766631) [ RunTime:0.000564s ] --------------------------------------------------------------- [ 2023-04-06T15:39:09+08:00 ] 117.132.198.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001869s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012570s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000683s ] --------------------------------------------------------------- [ 2023-04-06T15:39:11+08:00 ] 117.132.198.217 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680766749&v1=0.006833&v2=0.349224&v3=0.006953&v4=0.007194&v5=13.140000&t=15.956068&h=61.306568&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001828s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010926s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000761s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680766749,`v1`=0.006833,`v2`=0.349224,`v3`=0.006953,`v4`=0.007194,`v5`=13.14,`t`=15.956068,`h`=61.306568,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680766751 WHERE `imei` = '868922055677740' [ RunTime:0.000571s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009562s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680766749 , 0.006833 , 0.349224 , 0.006953 , 0.007194 , 13.14 , 15.956068 , 61.306568 , 22 , '89860426102071188504' , '460044618415254' , -0 , 1680766751) [ RunTime:0.000537s ] --------------------------------------------------------------- [ 2023-04-06T15:40:41+08:00 ] 117.132.198.91 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.009946s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000828s ] --------------------------------------------------------------- [ 2023-04-06T15:40:43+08:00 ] 117.132.198.91 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680766841&v1=0.007013&v2=0.347450&v3=0.006983&v4=0.007194&v5=13.140000&t=16.438698&h=59.780685&rssi=20&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011566s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000781s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680766841,`v1`=0.007013,`v2`=0.34745,`v3`=0.006983,`v4`=0.007194,`v5`=13.14,`t`=16.438698,`h`=59.780685,`rssi`=20,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680766843 WHERE `imei` = '868922055677740' [ RunTime:0.000547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011230s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680766841 , 0.007013 , 0.34745 , 0.006983 , 0.007194 , 13.14 , 16.438698 , 59.780685 , 20 , '89860426102071188504' , '460044618415254' , -0 , 1680766843) [ RunTime:0.000542s ] --------------------------------------------------------------- [ 2023-04-06T15:42:02+08:00 ] 27.193.85.51 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001518s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009693s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001026s ] --------------------------------------------------------------- [ 2023-04-06T15:42:08+08:00 ] 27.193.85.51 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001817s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009798s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000376s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000778s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000860s ] --------------------------------------------------------------- [ 2023-04-06T15:42:11+08:00 ] 27.193.85.51 GET /admin/show/index.html?page=3 [ 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.011427s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000381s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000907s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000830s ] --------------------------------------------------------------- [ 2023-04-06T15:42:14+08:00 ] 27.193.85.51 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009638s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012111s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000469s ] --------------------------------------------------------------- [ 2023-04-06T15:47:58+08:00 ] 111.55.138.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.013570s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-04-06T15:47:59+08:00 ] 111.55.138.55 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680767278&v1=0.006652&v2=0.014603&v3=0.006773&v4=0.007074&v5=5.400000&t=14.014829&h=66.479301&rssi=20&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.023164,1.289315&end=$ [ 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.011446s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680767278,`v1`=0.006652,`v2`=0.014603,`v3`=0.006773,`v4`=0.007074,`v5`=5.4,`t`=14.014829,`h`=66.479301,`rssi`=20,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.023164,1.289315',`update_time`=1680767279 WHERE `imei` = '868922055677740' [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012777s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680767278 , 0.006652 , 0.014603 , 0.006773 , 0.007074 , 5.4 , 14.014829 , 66.479301 , 20 , '89860426102071188504' , '460044618415254' , -0 , '0.023164,1.289315' , 1680767279) [ RunTime:0.000752s ] --------------------------------------------------------------- [ 2023-04-06T15:48:19+08:00 ] 112.224.75.134 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001512s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013472s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000671s ] --------------------------------------------------------------- [ 2023-04-06T15:48:24+08:00 ] 112.224.75.134 GET /admin/show/create.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001860s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012230s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2023-04-06T15:48:26+08:00 ] 112.224.75.134 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001529s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010815s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000388s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000801s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000953s ] --------------------------------------------------------------- [ 2023-04-06T15:48:34+08:00 ] 112.224.75.134 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001784s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012842s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000446s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000978s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000956s ] --------------------------------------------------------------- [ 2023-04-06T15:48:39+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001978s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011550s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012433s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000478s ] --------------------------------------------------------------- [ 2023-04-06T15:49:23+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001941s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011614s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011318s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2023-04-06T15:49:27+08:00 ] 218.204.253.75 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.010685s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2023-04-06T15:49:28+08:00 ] 218.204.253.75 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680767367&v1=0.006712&v2=0.016063&v3=0.006863&v4=0.007074&v5=5.580000&t=14.958636&h=69.584465&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.023164,1.289315&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001478s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009728s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680767367,`v1`=0.006712,`v2`=0.016063,`v3`=0.006863,`v4`=0.007074,`v5`=5.58,`t`=14.958636,`h`=69.584465,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.023164,1.289315',`update_time`=1680767368 WHERE `imei` = '868922055677740' [ RunTime:0.000516s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009972s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680767367 , 0.006712 , 0.016063 , 0.006863 , 0.007074 , 5.58 , 14.958636 , 69.584465 , 17 , '89860426102071188504' , '460044618415254' , -0 , '0.023164,1.289315' , 1680767368) [ RunTime:0.000484s ] --------------------------------------------------------------- [ 2023-04-06T15:49:37+08:00 ] 112.224.75.134 GET /admin/show/index.html?page=3 [ 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.010041s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000398s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000922s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000913s ] --------------------------------------------------------------- [ 2023-04-06T15:49:39+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ 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.009528s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011000s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000441s ] --------------------------------------------------------------- [ 2023-04-06T16:20:35+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003070s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012852s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011971s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000509s ] --------------------------------------------------------------- [ 2023-04-06T16:20:40+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001599s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010392s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009454s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000453s ] --------------------------------------------------------------- [ 2023-04-06T16:20:44+08:00 ] 117.132.193.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.010401s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000818s ] --------------------------------------------------------------- [ 2023-04-06T16:20:44+08:00 ] 112.224.75.134 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001571s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011227s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000370s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000906s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000855s ] --------------------------------------------------------------- [ 2023-04-06T16:20:45+08:00 ] 117.132.193.19 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680769244&v1=0.006652&v2=0.017211&v3=0.006742&v4=0.006953&v5=5.580000&t=14.111355&h=65.197563&rssi=14&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011581s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680769244,`v1`=0.006652,`v2`=0.017211,`v3`=0.006742,`v4`=0.006953,`v5`=5.58,`t`=14.111355,`h`=65.197563,`rssi`=14,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680769245 WHERE `imei` = '868922055677740' [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012625s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680769244 , 0.006652 , 0.017211 , 0.006742 , 0.006953 , 5.58 , 14.111355 , 65.197563 , 14 , '89860426102071188504' , '460044618415254' , -0 , 1680769245) [ RunTime:0.000659s ] --------------------------------------------------------------- [ 2023-04-06T16:20:48+08:00 ] 117.132.193.19 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.006773&v2=0.348598&v3=0.006803&v4=0.007013&v5=13.140000&t=14.679784&h=63.549610&rssi=14&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ 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.011102s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.006773,`v2`=0.348598,`v3`=0.006803,`v4`=0.007013,`v5`=13.14,`t`=14.679784,`h`=63.54961,`rssi`=14,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680769248 WHERE `imei` = '868922055677740' [ RunTime:0.000554s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010563s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041608 , 0.006773 , 0.348598 , 0.006803 , 0.007013 , 13.14 , 14.679784 , 63.54961 , 14 , '89860426102071188504' , '460044618415254' , -0 , 1680769248) [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2023-04-06T16:20:54+08:00 ] 112.224.75.134 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001621s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011601s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000391s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000864s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000859s ] --------------------------------------------------------------- [ 2023-04-06T16:20:59+08:00 ] 112.224.75.134 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.002014s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012157s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000451s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001100s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000926s ] --------------------------------------------------------------- [ 2023-04-06T16:21:06+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002000s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011131s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010665s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000482s ] --------------------------------------------------------------- [ 2023-04-06T16:21:19+08:00 ] 112.224.75.134 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001740s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010207s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000394s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000913s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000851s ] --------------------------------------------------------------- [ 2023-04-06T16:21:49+08:00 ] 112.224.75.134 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001824s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011755s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000357s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001205s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000973s ] --------------------------------------------------------------- [ 2023-04-06T16:21:50+08:00 ] 218.204.252.125 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002121s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011072s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000797s ] --------------------------------------------------------------- [ 2023-04-06T16:21:52+08:00 ] 218.204.252.125 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680769310&v1=0.006652&v2=0.015542&v3=0.006773&v4=0.007013&v5=5.580000&t=14.325856&h=65.235710&rssi=15&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=501800050179.442800,-752133.437526&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001993s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010129s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680769310,`v1`=0.006652,`v2`=0.015542,`v3`=0.006773,`v4`=0.007013,`v5`=5.58,`t`=14.325856,`h`=65.23571,`rssi`=15,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='501800050179.442800,-752133.437526',`update_time`=1680769312 WHERE `imei` = '868922055677740' [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009408s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680769310 , 0.006652 , 0.015542 , 0.006773 , 0.007013 , 5.58 , 14.325856 , 65.23571 , 15 , '89860426102071188504' , '460044618415254' , -0 , '501800050179.442800,-752133.437526' , 1680769312) [ RunTime:0.000534s ] --------------------------------------------------------------- [ 2023-04-06T16:21:56+08:00 ] 112.224.75.134 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001678s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010776s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000417s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000940s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000903s ] --------------------------------------------------------------- [ 2023-04-06T16:22:01+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001761s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010475s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011150s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000533s ] --------------------------------------------------------------- [ 2023-04-06T16:22:54+08:00 ] 39.144.6.200 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.013051s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000715s ] --------------------------------------------------------------- [ 2023-04-06T16:22:55+08:00 ] 39.144.6.200 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680769374&v1=0.006652&v2=0.015751&v3=0.006773&v4=0.007013&v5=5.940000&t=14.540358&h=64.587212&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=-0.000580,2359.843702&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001846s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011730s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680769374,`v1`=0.006652,`v2`=0.015751,`v3`=0.006773,`v4`=0.007013,`v5`=5.94,`t`=14.540358,`h`=64.587212,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='-0.000580,2359.843702',`update_time`=1680769375 WHERE `imei` = '868922055677740' [ RunTime:0.000549s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010756s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680769374 , 0.006652 , 0.015751 , 0.006773 , 0.007013 , 5.94 , 14.540358 , 64.587212 , 99 , '89860426102071188504' , '460044618415254' , -0 , '-0.000580,2359.843702' , 1680769375) [ RunTime:0.000509s ] --------------------------------------------------------------- [ 2023-04-06T16:22:58+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.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.010180s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009083s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000478s ] --------------------------------------------------------------- [ 2023-04-06T16:23:44+08:00 ] 117.132.195.125 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.011388s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2023-04-06T16:23:45+08:00 ] 117.132.195.125 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680769424&v1=0.006773&v2=0.014812&v3=0.006803&v4=0.007194&v5=5.400000&t=14.476007&h=62.809559&rssi=15&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002492s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010391s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680769424,`v1`=0.006773,`v2`=0.014812,`v3`=0.006803,`v4`=0.007194,`v5`=5.4,`t`=14.476007,`h`=62.809559,`rssi`=15,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680769425 WHERE `imei` = '868922055677740' [ RunTime:0.000509s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009527s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680769424 , 0.006773 , 0.014812 , 0.006803 , 0.007194 , 5.4 , 14.476007 , 62.809559 , 15 , '89860426102071188504' , '460044618415254' , -0 , 1680769425) [ RunTime:0.000482s ] --------------------------------------------------------------- [ 2023-04-06T16:23:48+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001521s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010505s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011061s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2023-04-06T16:23:49+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010330s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009774s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000436s ] --------------------------------------------------------------- [ 2023-04-06T16:24:26+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002072s ] 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 `id` = 22 LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011357s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000519s ] --------------------------------------------------------------- [ 2023-04-06T16:24:36+08:00 ] 112.224.75.134 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001800s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010282s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000728s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011012s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000514s ] --------------------------------------------------------------- [ 2023-04-06T16:56:12+08:00 ] 111.55.138.45 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002554s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010862s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-04-06T16:56:13+08:00 ] 111.55.138.45 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680771372&v1=0.007074&v2=0.014812&v3=0.006983&v4=0.007314&v5=5.580000&t=17.017851&h=67.074394&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ 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.008468s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680771372,`v1`=0.007074,`v2`=0.014812,`v3`=0.006983,`v4`=0.007314,`v5`=5.58,`t`=17.017851,`h`=67.074394,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680771373 WHERE `imei` = '868922055677740' [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010695s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680771372 , 0.007074 , 0.014812 , 0.006983 , 0.007314 , 5.58 , 17.017851 , 67.074394 , 22 , '89860426102071188504' , '460044618415254' , -0 , 1680771373) [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2023-04-06T16:56:15+08:00 ] 111.55.138.45 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.006712&v2=2.376348&v3=0.006803&v4=0.007074&v5=13.140000&t=14.379481&h=63.679310&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001558s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009697s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.006712,`v2`=2.376348,`v3`=0.006803,`v4`=0.007074,`v5`=13.14,`t`=14.379481,`h`=63.67931,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680771375 WHERE `imei` = '868922055677740' [ RunTime:0.000821s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010810s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041608 , 0.006712 , 2.376348 , 0.006803 , 0.007074 , 13.14 , 14.379481 , 63.67931 , 22 , '89860426102071188504' , '460044618415254' , -0 , 1680771375) [ RunTime:0.000493s ] --------------------------------------------------------------- [ 2023-04-06T16:56:16+08:00 ] 111.55.138.45 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.006893&v2=2.456248&v3=0.006953&v4=0.007134&v5=13.140000&t=14.797760&h=62.733265&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ 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.011856s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.006893,`v2`=2.456248,`v3`=0.006953,`v4`=0.007134,`v5`=13.14,`t`=14.79776,`h`=62.733265,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680771376 WHERE `imei` = '868922055677740' [ RunTime:0.000540s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009766s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041608 , 0.006893 , 2.456248 , 0.006953 , 0.007134 , 13.14 , 14.79776 , 62.733265 , 22 , '89860426102071188504' , '460044618415254' , -0 , 1680771376) [ RunTime:0.000505s ] --------------------------------------------------------------- [ 2023-04-06T16:56:59+08:00 ] 117.132.195.41 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009995s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000686s ] --------------------------------------------------------------- [ 2023-04-06T16:57:00+08:00 ] 117.132.195.41 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680771419&v1=0.007074&v2=0.017419&v3=0.007134&v4=0.007375&v5=5.400000&t=17.597006&h=64.396477&rssi=25&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002203s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009257s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680771419,`v1`=0.007074,`v2`=0.017419,`v3`=0.007134,`v4`=0.007375,`v5`=5.4,`t`=17.597006,`h`=64.396477,`rssi`=25,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680771420 WHERE `imei` = '868922055677740' [ RunTime:0.000500s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010951s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680771419 , 0.007074 , 0.017419 , 0.007134 , 0.007375 , 5.4 , 17.597006 , 64.396477 , 25 , '89860426102071188504' , '460044618415254' , -0 , 1680771420) [ RunTime:0.000451s ] --------------------------------------------------------------- [ 2023-04-06T16:59:31+08:00 ] 39.144.15.156 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.011107s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010131s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000648s ] --------------------------------------------------------------- [ 2023-04-06T16:59:33+08:00 ] 39.144.15.156 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680771571&v1=0.007074&v2=0.015751&v3=0.007013&v4=0.007375&v5=5.400000&t=18.111809&h=63.580128&rssi=21&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=1.292255,2359.843700&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002199s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012632s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680771571,`v1`=0.007074,`v2`=0.015751,`v3`=0.007013,`v4`=0.007375,`v5`=5.4,`t`=18.111809,`h`=63.580128,`rssi`=21,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='1.292255,2359.843700',`update_time`=1680771573 WHERE `imei` = '868922055677740' [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010042s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680771571 , 0.007074 , 0.015751 , 0.007013 , 0.007375 , 5.4 , 18.111809 , 63.580128 , 21 , '89860426102071188504' , '460044618415254' , -0 , '1.292255,2359.843700' , 1680771573) [ RunTime:0.000510s ] --------------------------------------------------------------- [ 2023-04-06T17:01:25+08:00 ] 39.144.4.15 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002455s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014132s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000745s ] --------------------------------------------------------------- [ 2023-04-06T17:01:27+08:00 ] 39.144.4.15 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680771685&v1=0.007074&v2=0.014395&v3=0.007074&v4=0.007375&v5=5.400000&t=18.401386&h=63.305470&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010550s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000719s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680771685,`v1`=0.007074,`v2`=0.014395,`v3`=0.007074,`v4`=0.007375,`v5`=5.4,`t`=18.401386,`h`=63.30547,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680771687 WHERE `imei` = '868922055677740' [ RunTime:0.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011719s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680771685 , 0.007074 , 0.014395 , 0.007074 , 0.007375 , 5.4 , 18.401386 , 63.30547 , 22 , '89860426102071188504' , '460044618415254' , -0 , 1680771687) [ RunTime:0.000548s ] --------------------------------------------------------------- [ 2023-04-06T17:06:33+08:00 ] 39.144.16.195 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001835s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009800s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000709s ] --------------------------------------------------------------- [ 2023-04-06T17:06:34+08:00 ] 39.144.16.195 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680771993&v1=0.007074&v2=0.015125&v3=0.007134&v4=0.007555&v5=5.400000&t=19.720572&h=59.315292&rssi=25&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002025s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010002s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680771993,`v1`=0.007074,`v2`=0.015125,`v3`=0.007134,`v4`=0.007555,`v5`=5.4,`t`=19.720572,`h`=59.315292,`rssi`=25,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680771994 WHERE `imei` = '868922055677740' [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011473s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680771993 , 0.007074 , 0.015125 , 0.007134 , 0.007555 , 5.4 , 19.720572 , 59.315292 , 25 , '89860426102071188504' , '460044618415254' , -0 , 1680771994) [ RunTime:0.000502s ] --------------------------------------------------------------- [ 2023-04-06T17:16:51+08:00 ] 111.55.137.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002109s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010887s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000668s ] --------------------------------------------------------------- [ 2023-04-06T17:16:52+08:00 ] 111.55.137.72 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680772611&v1=0.007375&v2=0.016168&v3=0.007375&v4=0.007615&v5=5.400000&t=21.747612&h=54.760540&rssi=24&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.006500,0.006000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001828s ] 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` = '868922055677740' LIMIT 1 [ RunTime:0.000917s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680772611,`v1`=0.007375,`v2`=0.016168,`v3`=0.007375,`v4`=0.007615,`v5`=5.4,`t`=21.747612,`h`=54.76054,`rssi`=24,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.006500,0.006000',`update_time`=1680772612 WHERE `imei` = '868922055677740' [ RunTime:0.000877s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011446s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680772611 , 0.007375 , 0.016168 , 0.007375 , 0.007615 , 5.4 , 21.747612 , 54.76054 , 24 , '89860426102071188504' , '460044618415254' , -0 , '0.006500,0.006000' , 1680772612) [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-04-06T17:25:16+08:00 ] 39.144.2.211 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002329s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013258s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000753s ] --------------------------------------------------------------- [ 2023-04-06T17:25:17+08:00 ] 39.144.2.211 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680773116&v1=0.007194&v2=0.015542&v3=0.007344&v4=0.007615&v5=5.400000&t=21.962112&h=50.793255&rssi=24&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.006500,0.006000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001818s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009999s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000722s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680773116,`v1`=0.007194,`v2`=0.015542,`v3`=0.007344,`v4`=0.007615,`v5`=5.4,`t`=21.962112,`h`=50.793255,`rssi`=24,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.006500,0.006000',`update_time`=1680773117 WHERE `imei` = '868922055677740' [ RunTime:0.000512s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011451s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680773116 , 0.007194 , 0.015542 , 0.007344 , 0.007615 , 5.4 , 21.962112 , 50.793255 , 24 , '89860426102071188504' , '460044618415254' , -0 , '0.006500,0.006000' , 1680773117) [ RunTime:0.000674s ]