--------------------------------------------------------------- [ 2022-09-21T05:20:20+08:00 ] 39.144.3.158 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002416s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008790s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2022-09-21T05:20:21+08:00 ] 39.144.3.158 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1663708820&v1=0.018692&v2=0.015333&v3=0.015893&v4=-0.004365&v5=12.420000&t=20.921892&h=64.747375&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001380s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008393s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000587s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1663708820,`v1`=0.018692,`v2`=0.015333,`v3`=0.015893,`v4`=-0.004365,`v5`=12.42,`t`=20.921892,`h`=64.747375,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1663708821 WHERE `imei` = '868922055683920' [ RunTime:0.000655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011128s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1663708820 , 0.018692 , 0.015333 , 0.015893 , -0.004365 , 12.42 , 20.921892 , 64.747375 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1663708821) [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2022-09-21T10:29:46+08:00 ] 39.144.1.9 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002169s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010360s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000844s ] --------------------------------------------------------------- [ 2022-09-21T10:29:47+08:00 ] 39.144.1.9 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663727386&v1=0.007916&v2=0.072598&v3=0.008037&v4=0.008579&v5=12.240000&t=25.726616&h=71.102715&rssi=99&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001634s ] 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` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1663727386,`v1`=0.007916,`v2`=0.072598,`v3`=0.008037,`v4`=0.008579,`v5`=12.24,`t`=25.726616,`h`=71.102715,`rssi`=99,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663727387 WHERE `imei` = '868922055677740' [ RunTime:0.000608s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011309s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663727386 , 0.007916 , 0.072598 , 0.008037 , 0.008579 , 12.24 , 25.726616 , 71.102715 , 99 , '89860426102071188504' , '460044618415254' , -0 , 1663727387) [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2022-09-21T16:11:46+08:00 ] 218.58.59.72 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002548s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.014764s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2022-09-21T16:11:52+08:00 ] 218.58.59.72 GET /admin/shelves/index.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_shelves` [ RunTime:0.011018s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_shelves` LIMIT 1 [ RunTime:0.000351s ] [ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000566s ] [ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC [ RunTime:0.000450s ] --------------------------------------------------------------- [ 2022-09-21T16:11:54+08:00 ] 218.58.59.72 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001569s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.012438s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000401s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000354s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000408s ] --------------------------------------------------------------- [ 2022-09-21T16:12:00+08:00 ] 218.58.59.72 GET /admin/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001483s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.013034s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000380s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001249s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000601s ] --------------------------------------------------------------- [ 2022-09-21T16:12:04+08:00 ] 218.58.59.72 GET /admin/device/read/id/11/unique_identification_number/862810047306641.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001654s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_electricmachinerydata` [ RunTime:0.014577s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_electricmachinerydata` WHERE `unique_identification_number` = '862810047306641' LIMIT 1 [ RunTime:0.001192s ] [ sql ] [ SQL ] SELECT * FROM `collect_electricmachinerydata` WHERE `unique_identification_number` = '862810047306641' LIMIT 0,100 [ RunTime:0.001620s ] --------------------------------------------------------------- [ 2022-09-21T16:12:44+08:00 ] 218.58.59.72 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001444s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010929s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001351s ] --------------------------------------------------------------- [ 2022-09-21T16:12:46+08:00 ] 218.58.59.72 GET /home/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009856s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'user' LIMIT 1 [ RunTime:0.000468s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000663s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'user' ORDER BY `id` DESC [ RunTime:0.000517s ] --------------------------------------------------------------- [ 2022-09-21T17:20:20+08:00 ] 39.144.15.11 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920 [ sql ] [ DB ] CONNECT:[ UseTime:0.002515s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012251s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000705s ] --------------------------------------------------------------- [ 2022-09-21T17:20:22+08:00 ] 39.144.15.11 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1663752020&v1=0.018873&v2=0.014812&v3=0.016254&v4=-0.004786&v5=12.420000&t=24.997429&h=65.006775&rssi=31&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001603s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009708s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000599s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1663752020,`v1`=0.018873,`v2`=0.014812,`v3`=0.016254,`v4`=-0.004786,`v5`=12.42,`t`=24.997429,`h`=65.006775,`rssi`=31,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1663752022 WHERE `imei` = '868922055683920' [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008480s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1663752020 , 0.018873 , 0.014812 , 0.016254 , -0.004786 , 12.42 , 24.997429 , 65.006775 , 31 , '89860426102071188500' , '460044618415250' , -0 , 1663752022) [ RunTime:0.000766s ] --------------------------------------------------------------- [ 2022-09-21T18:13:51+08:00 ] 117.132.194.2 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002062s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010103s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000650s ] --------------------------------------------------------------- [ 2022-09-21T18:13:59+08:00 ] 117.132.194.2 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=220921&time=181301&v1=+01.891&v2=+00.022&v3=+01.881&v4=+02.716&v5=06.0&t=+19.6&h=80.8&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.142&a2=01.527&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001361s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008339s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000579s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='220921',`time`='181301',`v1`=1.891,`v2`=0.022,`v3`=1.881,`v4`=2.716,`v5`=6,`t`=19.6,`h`=80.8,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.142,`a2`=1.527,`update_time`=1663755239 WHERE `imei` = '868922055684076' [ RunTime:0.000579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010267s ] [ 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' , '220921' , '181301' , 1.891 , 0.022 , 1.881 , 2.716 , 6 , 19.6 , 80.8 , 228 , '460044618415249' , -0 , 0.142 , 1.527 , 1663755239 , 1663755239) [ RunTime:0.000616s ] --------------------------------------------------------------- [ 2022-09-21T19:44:13+08:00 ] 39.144.11.142 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211 [ sql ] [ DB ] CONNECT:[ UseTime:0.002310s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009991s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000739s ] --------------------------------------------------------------- [ 2022-09-21T19:44:15+08:00 ] 39.144.11.142 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1663760653&v1=0.026398&v2=0.047460&v3=0.023237&v4=-0.003401&v5=6.660000&t=17.425510&h=64.762634&rssi=20&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008365s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000665s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1663760653,`v1`=0.026398,`v2`=0.04746,`v3`=0.023237,`v4`=-0.003401,`v5`=6.66,`t`=17.42551,`h`=64.762634,`rssi`=20,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1663760655 WHERE `imei` = '868922055644211' [ RunTime:0.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.021654s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1663760653 , 0.026398 , 0.04746 , 0.023237 , -0.003401 , 6.66 , 17.42551 , 64.762634 , 20 , '89860426102071188505' , '460044618415255' , -0 , 1663760655) [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2022-09-21T22:30:06+08:00 ] 39.144.1.79 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002268s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009592s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000655s ] --------------------------------------------------------------- [ 2022-09-21T22:30:07+08:00 ] 39.144.1.79 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1663770606&v1=0.007676&v2=0.041410&v3=0.007826&v4=0.008157&v5=12.240000&t=23.141872&h=70.728874&rssi=31&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007253s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000604s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1663770606,`v1`=0.007676,`v2`=0.04141,`v3`=0.007826,`v4`=0.008157,`v5`=12.24,`t`=23.141872,`h`=70.728874,`rssi`=31,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1663770607 WHERE `imei` = '868922055677740' [ RunTime:0.000512s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009006s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1663770606 , 0.007676 , 0.04141 , 0.007826 , 0.008157 , 12.24 , 23.141872 , 70.728874 , 31 , '89860426102071188504' , '460044618415254' , -0 , 1663770607) [ RunTime:0.000569s ]