--------------------------------------------------------------- [ 2024-02-15T00:05:57+08:00 ] 120.225.173.180 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002922s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013750s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000716s ] --------------------------------------------------------------- [ 2024-02-15T00:06:00+08:00 ] 120.225.173.180 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002395s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013342s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000424s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001523s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.018583s ] --------------------------------------------------------------- [ 2024-02-15T00:06:49+08:00 ] 120.225.173.180 GET /admin/multipleshow/read/id/12/imei/862810047311997.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002516s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012277s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000825s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.018342s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' LIMIT 1 [ RunTime:0.089724s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.005103s ] --------------------------------------------------------------- [ 2024-02-15T01:58:52+08:00 ] 117.132.194.210 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012108s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000780s ] --------------------------------------------------------------- [ 2024-02-15T01:59:00+08:00 ] 117.132.194.210 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240215&time=015801&v1=+00.080&v2=+00.001&v3=+00.135&v4=+00.029&v5=05.6&t=+01.0&h=73.0&rssi=+223&ccid=4600485905031430000099m9990000000060000000g0550,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001950s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012000s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='240215',`time`='015801',`v1`=0.08,`v2`=0.001,`v3`=0.135,`v4`=0.029,`v5`=5.6,`t`=1,`h`=73,`rssi`=223,`ccid`='4600485905031430000099m9990000000060000000g0550,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1707933540 WHERE `imei` = '868922055644013' [ RunTime:0.000788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.025151s ] [ 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' , '240215' , '015801' , 0.08 , 0.001 , 0.135 , 0.029 , 5.6 , 1 , 73 , 223 , '4600485905031430000099m9990000000060000000g0550,N,00E000=-00.000' , 0 , 0 , 1707933540 , 1707933540) [ RunTime:0.002288s ] --------------------------------------------------------------- [ 2024-02-15T14:42:12+08:00 ] 120.225.173.180 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002770s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012859s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2024-02-15T14:42:15+08:00 ] 120.225.173.180 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001505s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013280s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000771s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002077s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001251s ] --------------------------------------------------------------- [ 2024-02-15T15:33:31+08:00 ] 120.225.173.180 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002234s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011340s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000400s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001388s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001262s ]