--------------------------------------------------------------- [ 2023-12-12T02:01:52+08:00 ] 111.55.140.36 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.004903s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.034378s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001488s ] --------------------------------------------------------------- [ 2023-12-12T02:01:52+08:00 ] 117.132.197.234 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.005275s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026523s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000743s ] --------------------------------------------------------------- [ 2023-12-12T02:02:01+08:00 ] 111.55.140.36 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=231212&time=020101&v1=-00.031&v2=+00.001&v3=+00.012&v4=+00.002&v5=05.6&t=+00.4&h=70.3&rssi=+223&ccid=4600485905031430000099m9990000000028000000g0280,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.004330s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025431s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000755s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='231212',`time`='020101',`v1`=-0.031,`v2`=0.001,`v3`=0.012,`v4`=0.002,`v5`=5.6,`t`=0.4,`h`=70.3,`rssi`=223,`ccid`='4600485905031430000099m9990000000028000000g0280,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1702317720 WHERE `imei` = '868922055644013' [ RunTime:0.000962s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.039160s ] [ 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' , '231212' , '020101' , -0.031 , 0.001 , 0.012 , 0.002 , 5.6 , 0.4 , 70.3 , 223 , '4600485905031430000099m9990000000028000000g0280,N,00E000=-00.000' , 0 , 0 , 1702317721 , 1702317721) [ RunTime:0.003089s ] --------------------------------------------------------------- [ 2023-12-12T02:02:01+08:00 ] 117.132.197.234 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=231212&time=020101&v1=-01.069&v2=+00.025&v3=-00.767&v4=+00.005&v5=05.6&t=+00.3&h=66.9&rssi=+222&ccid=4600485905031420000099m9990000000418000001g1730,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.005407s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029298s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000768s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='231212',`time`='020101',`v1`=-1.069,`v2`=0.025,`v3`=-0.767,`v4`=0.005,`v5`=5.6,`t`=0.3,`h`=66.9,`rssi`=222,`ccid`='4600485905031420000099m9990000000418000001g1730,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1702317721 WHERE `imei` = '868922055643643' [ RunTime:0.000592s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.028974s ] [ 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' , '231212' , '020101' , -1.069 , 0.025 , -0.767 , 0.005 , 5.6 , 0.3 , 66.9 , 222 , '4600485905031420000099m9990000000418000001g1730,N,00E000=-00.000' , 0 , 0 , 1702317721 , 1702317721) [ RunTime:0.001549s ] --------------------------------------------------------------- [ 2023-12-12T08:14:52+08:00 ] 124.129.66.252 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.032941s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000777s ] --------------------------------------------------------------- [ 2023-12-12T08:14:56+08:00 ] 124.129.66.252 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002868s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.035949s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000500s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002337s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001500s ] --------------------------------------------------------------- [ 2023-12-12T08:14:59+08:00 ] 124.129.66.252 GET /admin/multipleshow/read/id/15/imei/863412043611030.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005021s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.026700s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000833s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.036570s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043611030' LIMIT 1 [ RunTime:0.015448s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043611030' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004052s ] --------------------------------------------------------------- [ 2023-12-12T14:00:45+08:00 ] 124.129.66.252 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004488s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.036424s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000542s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001907s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001442s ] --------------------------------------------------------------- [ 2023-12-12T14:00:51+08:00 ] 124.129.66.252 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003763s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029398s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.030336s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.005661s ] --------------------------------------------------------------- [ 2023-12-12T14:08:47+08:00 ] 124.129.66.252 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004064s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.032848s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user1' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001465s ] --------------------------------------------------------------- [ 2023-12-12T14:08:48+08:00 ] 124.129.66.252 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003567s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027674s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000974s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.034606s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000718s ] --------------------------------------------------------------- [ 2023-12-12T14:13:39+08:00 ] 124.129.66.252 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004133s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.033755s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000662s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000806s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001427s ] --------------------------------------------------------------- [ 2023-12-12T14:13:40+08:00 ] 124.129.66.252 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003786s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033705s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001009s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000858s ] --------------------------------------------------------------- [ 2023-12-12T14:14:14+08:00 ] 124.129.66.252 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004179s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027338s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000559s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000842s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000744s ] --------------------------------------------------------------- [ 2023-12-12T14:14:21+08:00 ] 124.129.66.252 GET /home/show/read/id/58/imei/868922055678110.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003617s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028351s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 58 LIMIT 1 [ RunTime:0.000891s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.039606s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.001369s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.027781s ] --------------------------------------------------------------- [ 2023-12-12T14:16:30+08:00 ] 124.129.66.252 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004566s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030907s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000920s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.029697s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000813s ] --------------------------------------------------------------- [ 2023-12-12T14:16:38+08:00 ] 124.129.66.252 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028765s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000575s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000759s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001339s ] --------------------------------------------------------------- [ 2023-12-12T14:16:41+08:00 ] 124.129.66.252 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003131s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029775s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000859s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.002261s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.031208s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.000580s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.000512s ] --------------------------------------------------------------- [ 2023-12-12T14:16:51+08:00 ] 124.129.66.252 GET /home/data/index.html?keyword=868922055678110&start_date=2023-12-01&end_date=2023-12-12 [ sql ] [ DB ] CONNECT:[ UseTime:0.003809s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029745s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000850s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000581s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000619s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000734s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.027134s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1701360000 AND `update_time` <= 1702310400 ) LIMIT 1 [ RunTime:0.003462s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1701360000 AND `update_time` <= 1702310400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.005473s ] --------------------------------------------------------------- [ 2023-12-12T14:17:22+08:00 ] 124.129.66.252 GET /home/data/index.html?keyword=868922055678110&start_date=2023-12-12&end_date=2023-12-12 [ sql ] [ DB ] CONNECT:[ UseTime:0.003150s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026113s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000742s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000983s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000561s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000712s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024580s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1702310400 AND `update_time` <= 1702310400 ) LIMIT 1 [ RunTime:0.007268s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1702310400 AND `update_time` <= 1702310400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003244s ] --------------------------------------------------------------- [ 2023-12-12T14:17:37+08:00 ] 124.129.66.252 GET /home/data/index.html?keyword=868922055678110&start_date=2020-01-12&end_date=2023-12-12 [ sql ] [ DB ] CONNECT:[ UseTime:0.003723s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028357s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000833s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000564s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000601s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.030473s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1578758400 AND `update_time` <= 1702310400 ) LIMIT 1 [ RunTime:0.003343s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1578758400 AND `update_time` <= 1702310400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.008904s ] --------------------------------------------------------------- [ 2023-12-12T14:18:03+08:00 ] 124.129.66.252 GET /home/data/index.html?keyword=868922055678110&start_date=2020-01-12&end_date=2023-12-12 [ sql ] [ DB ] CONNECT:[ UseTime:0.004197s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027951s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000833s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000541s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000582s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000723s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.030460s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1578758400 AND `update_time` <= 1702310400 ) LIMIT 1 [ RunTime:0.003415s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1578758400 AND `update_time` <= 1702310400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.006814s ] --------------------------------------------------------------- [ 2023-12-12T14:18:27+08:00 ] 124.129.66.252 GET /home/data/index.html?keyword=868922055678110&start_date=2020-01-12&end_date=2023-12-12 [ sql ] [ DB ] CONNECT:[ UseTime:0.003526s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027114s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000858s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000869s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000624s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.026542s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1578758400 AND `update_time` <= 1702310400 ) LIMIT 1 [ RunTime:0.003989s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1578758400 AND `update_time` <= 1702310400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.008111s ] --------------------------------------------------------------- [ 2023-12-12T14:18:32+08:00 ] 124.129.66.252 GET /home/data/index.html?keyword=868922055678110&start_date=2020-01-12&end_date=2023-12-12 [ sql ] [ DB ] CONNECT:[ UseTime:0.004676s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033096s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000877s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' LIMIT 1 [ RunTime:0.001280s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000601s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.002976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.027113s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1578758400 AND `update_time` <= 1702310400 ) LIMIT 1 [ RunTime:0.003329s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055678110' AND ( `update_time` >= 1578758400 AND `update_time` <= 1702310400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.006884s ] --------------------------------------------------------------- [ 2023-12-12T14:18:45+08:00 ] 124.129.66.252 GET /home/data/index.html?keyword=868922055681700&start_date=2020-01-12&end_date=2023-12-12 [ sql ] [ DB ] CONNECT:[ UseTime:0.003552s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028738s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055681700' LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055681700' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000528s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681700' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000599s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.001002s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.032829s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681700' AND ( `update_time` >= 1578758400 AND `update_time` <= 1702310400 ) LIMIT 1 [ RunTime:0.004729s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681700' AND ( `update_time` >= 1578758400 AND `update_time` <= 1702310400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.002499s ] --------------------------------------------------------------- [ 2023-12-12T14:19:43+08:00 ] 124.129.66.252 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004222s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029131s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000562s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000816s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2023-12-12T14:19:45+08:00 ] 124.129.66.252 GET /home/show/read/id/29/imei/868922055681700.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003388s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026658s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000736s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.026043s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681700' LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681700' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001721s ] --------------------------------------------------------------- [ 2023-12-12T14:19:47+08:00 ] 124.129.66.252 GET /home/show/read/id/29/imei/868922055681700.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.003852s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026227s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.029410s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681700' LIMIT 1 [ RunTime:0.000698s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681700' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.003198s ] --------------------------------------------------------------- [ 2023-12-12T14:19:48+08:00 ] 124.129.66.252 GET /home/show/read/id/29/imei/868922055681700.html?page=1 [ sql ] [ DB ] CONNECT:[ UseTime:0.005018s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029045s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000768s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.031282s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681700' LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681700' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001571s ] --------------------------------------------------------------- [ 2023-12-12T14:20:28+08:00 ] 124.129.66.252 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005378s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.035673s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000962s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.029019s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.001081s ] --------------------------------------------------------------- [ 2023-12-12T14:20:58+08:00 ] 124.129.66.252 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.007885s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028259s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000830s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2023-12-12T16:57:43+08:00 ] 124.129.66.252 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004163s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.030703s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000476s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001559s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.002994s ] --------------------------------------------------------------- [ 2023-12-12T16:57:45+08:00 ] 124.129.66.252 GET /admin/multipleshow/read/id/15/imei/863412043611030.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004904s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028489s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000894s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.033800s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043611030' LIMIT 1 [ RunTime:0.005562s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043611030' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004138s ]