--------------------------------------------------------------- [ 2024-01-30T01:53:19+08:00 ] 39.144.112.33 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003815s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014883s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001227s ] --------------------------------------------------------------- [ 2024-01-30T01:53:27+08:00 ] 39.144.112.33 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=240130&time=015301&v1=-01.197&v2=+00.047&v3=-00.793&v4=-00.034&v5=04.3&t=-02.4&h=67.9&rssi=+223&ccid=4600485905031420000099m9990000000412000001g2190,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002477s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010092s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='240130',`time`='015301',`v1`=-1.197,`v2`=0.047,`v3`=-0.793,`v4`=-0.034,`v5`=4.3,`t`=-2.4,`h`=67.9,`rssi`=223,`ccid`='4600485905031420000099m9990000000412000001g2190,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1706550807 WHERE `imei` = '868922055643643' [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.023716s ] [ 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' , '240130' , '015301' , -1.197 , 0.047 , -0.793 , -0.034 , 4.3 , -2.4 , 67.9 , 223 , '4600485905031420000099m9990000000412000001g2190,N,00E000=-00.000' , 0 , 0 , 1706550807 , 1706550807) [ RunTime:0.005138s ] --------------------------------------------------------------- [ 2024-01-30T02:00:54+08:00 ] 39.144.13.98 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001827s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011265s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000744s ] --------------------------------------------------------------- [ 2024-01-30T02:01:00+08:00 ] 39.144.13.98 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240130&time=020001&v1=+00.101&v2=+00.001&v3=+00.098&v4=+00.053&v5=05.4&t=-01.3&h=71.2&rssi=+221&ccid=4600485905031430000099m9990000000011000000g0780,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003068s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011933s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000775s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='240130',`time`='020001',`v1`=0.101,`v2`=0.001,`v3`=0.098,`v4`=0.053,`v5`=5.4,`t`=-1.3,`h`=71.2,`rssi`=221,`ccid`='4600485905031430000099m9990000000011000000g0780,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1706551260 WHERE `imei` = '868922055644013' [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012443s ] [ 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' , '240130' , '020001' , 0.101 , 0.001 , 0.098 , 0.053 , 5.4 , -1.3 , 71.2 , 221 , '4600485905031430000099m9990000000011000000g0780,N,00E000=-00.000' , 0 , 0 , 1706551260 , 1706551260) [ RunTime:0.000828s ] --------------------------------------------------------------- [ 2024-01-30T13:40:30+08:00 ] 120.225.218.183 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005375s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.021229s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = ' duolucaijiyi' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000831s ] --------------------------------------------------------------- [ 2024-01-30T13:40:48+08:00 ] 120.225.218.183 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002506s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012167s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = ' duolucaijiyi' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000594s ] --------------------------------------------------------------- [ 2024-01-30T13:41:02+08:00 ] 120.225.218.183 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001777s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010478s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'duolucaijiyi' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001260s ] --------------------------------------------------------------- [ 2024-01-30T13:41:03+08:00 ] 120.225.218.183 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001797s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014130s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001378s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013090s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.002181s ] --------------------------------------------------------------- [ 2024-01-30T13:41:08+08:00 ] 120.225.218.183 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001540s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011746s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000505s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000633s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000700s ] --------------------------------------------------------------- [ 2024-01-30T13:41:10+08:00 ] 120.225.218.183 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012685s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000834s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000938s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.022910s ] [ 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.000589s ] --------------------------------------------------------------- [ 2024-01-30T13:41:12+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002734s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012441s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000943s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001452s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001229s ] --------------------------------------------------------------- [ 2024-01-30T13:41:40+08:00 ] 120.225.218.183 GET /home/multipleshow/edit/id/12.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003240s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.015964s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000956s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011861s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000486s ] --------------------------------------------------------------- [ 2024-01-30T13:41:53+08:00 ] 120.225.218.183 POST /home/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002334s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012629s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='实验1',`interval`=1440,`outage_time`=100,`gps`='119.530538,35.396872',`introduce`=' ',`update_time`=1706593313 WHERE `id` = 12 [ RunTime:0.001340s ] --------------------------------------------------------------- [ 2024-01-30T13:41:54+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002239s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010952s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000561s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001423s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001247s ] --------------------------------------------------------------- [ 2024-01-30T13:41:59+08:00 ] 120.225.218.183 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001868s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013169s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000596s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000676s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2024-01-30T13:42:03+08:00 ] 120.225.218.183 GET /home/show/index.html?keyword= [ sql ] [ DB ] CONNECT:[ UseTime:0.002410s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012440s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000651s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000662s ] --------------------------------------------------------------- [ 2024-01-30T13:42:08+08:00 ] 120.225.218.183 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002061s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011664s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000520s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000705s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000697s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012131s ] [ 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.000436s ] [ 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.000529s ] --------------------------------------------------------------- [ 2024-01-30T13:42:12+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002429s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013029s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001751s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.002096s ] --------------------------------------------------------------- [ 2024-01-30T14:25:18+08:00 ] 120.225.218.183 GET /home/multipleshow/edit/id/12.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003705s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013710s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000872s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013344s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2024-01-30T14:25:24+08:00 ] 120.225.218.183 POST /home/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002134s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010170s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='实验1',`interval`=10,`outage_time`=100,`gps`='119.530538,35.396872',`introduce`=' ',`update_time`=1706595924 WHERE `id` = 12 [ RunTime:0.001961s ] --------------------------------------------------------------- [ 2024-01-30T14:25:25+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010843s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001456s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001299s ] --------------------------------------------------------------- [ 2024-01-30T14:25:30+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.019154s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000863s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002360s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.002432s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.025292s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.077020s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003516s ] --------------------------------------------------------------- [ 2024-01-30T14:25:46+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-29&end_date=2024-01-30 [ sql ] [ DB ] CONNECT:[ UseTime:0.002062s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011728s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.000712s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000894s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000833s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.002394s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.016257s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706544000 ) LIMIT 1 [ RunTime:0.004368s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706544000 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.004016s ] --------------------------------------------------------------- [ 2024-01-30T15:06:31+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-29&end_date=2024-01-30 [ sql ] [ DB ] CONNECT:[ UseTime:0.002614s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011799s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.000817s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000481s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000791s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001284s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012834s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706544000 ) LIMIT 1 [ RunTime:0.004226s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706544000 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003794s ] --------------------------------------------------------------- [ 2024-01-30T15:06:43+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002056s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010035s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000509s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001383s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001232s ] --------------------------------------------------------------- [ 2024-01-30T15:06:46+08:00 ] 120.225.218.183 GET /home/multipleshow/edit/id/12.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002097s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012191s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000840s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012864s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000509s ] --------------------------------------------------------------- [ 2024-01-30T15:06:54+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001998s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011818s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000592s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001524s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001722s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.013557s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.005486s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003912s ] --------------------------------------------------------------- [ 2024-01-30T15:06:55+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001953s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011662s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000531s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001397s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001260s ] --------------------------------------------------------------- [ 2024-01-30T15:06:58+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002056s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011582s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000604s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001465s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001648s ] --------------------------------------------------------------- [ 2024-01-30T15:07:10+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001983s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.009886s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000526s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001357s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001440s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.013233s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.003297s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003293s ] --------------------------------------------------------------- [ 2024-01-30T15:07:20+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-29&end_date=2024-01-30 [ sql ] [ DB ] CONNECT:[ UseTime:0.002348s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010634s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000509s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000710s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001335s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.014491s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706544000 ) LIMIT 1 [ RunTime:0.005573s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706544000 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.006045s ] --------------------------------------------------------------- [ 2024-01-30T15:07:31+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-29&end_date=2024-01-30 [ sql ] [ DB ] CONNECT:[ UseTime:0.003171s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.015899s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.001082s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.001052s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001076s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.002231s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.015285s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706544000 ) LIMIT 1 [ RunTime:0.005135s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706544000 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.006215s ] --------------------------------------------------------------- [ 2024-01-30T15:07:40+08:00 ] 120.225.218.183 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013433s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000677s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000744s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011878s ] [ 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.000377s ] [ 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.000549s ] --------------------------------------------------------------- [ 2024-01-30T15:07:44+08:00 ] 120.225.218.183 GET /home/show/index.html [ 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.012111s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000980s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000939s ] --------------------------------------------------------------- [ 2024-01-30T15:07:47+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001808s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012466s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000577s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001525s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001304s ] --------------------------------------------------------------- [ 2024-01-30T15:07:56+08:00 ] 120.225.218.183 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002689s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.033627s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000664s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000708s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010916s ] [ 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.000434s ] [ 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.000541s ] --------------------------------------------------------------- [ 2024-01-30T15:08:05+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002048s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011618s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000610s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001434s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001357s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012248s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.003218s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003068s ] --------------------------------------------------------------- [ 2024-01-30T15:08:21+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-28&end_date=2024-01-31 [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013804s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.000759s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000508s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000720s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011474s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706371200 AND `update_time` <= 1706630400 ) LIMIT 1 [ RunTime:0.004150s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706371200 AND `update_time` <= 1706630400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003697s ] --------------------------------------------------------------- [ 2024-01-30T15:11:39+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-28&end_date=2024-01-31 [ sql ] [ DB ] CONNECT:[ UseTime:0.001951s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010813s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.000822s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000764s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000769s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001440s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.013576s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706371200 AND `update_time` <= 1706630400 ) LIMIT 1 [ RunTime:0.004210s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706371200 AND `update_time` <= 1706630400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.004145s ] --------------------------------------------------------------- [ 2024-01-30T15:12:02+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002147s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012582s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000601s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001446s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001245s ] --------------------------------------------------------------- [ 2024-01-30T15:12:05+08:00 ] 120.225.218.183 GET /home/multipleshow/edit/id/12.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002031s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012783s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000861s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.015169s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000574s ] --------------------------------------------------------------- [ 2024-01-30T15:12:08+08:00 ] 120.225.218.183 POST /home/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002271s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012253s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='实验1',`interval`=1,`outage_time`=100,`gps`='119.530538,35.396872',`introduce`=' ',`update_time`=1706598728 WHERE `id` = 12 [ RunTime:0.001434s ] --------------------------------------------------------------- [ 2024-01-30T15:12:09+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002155s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011991s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001517s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001387s ] --------------------------------------------------------------- [ 2024-01-30T15:12:11+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001843s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010192s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000530s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001478s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011296s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.003640s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003276s ] --------------------------------------------------------------- [ 2024-01-30T15:12:22+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-29&end_date=2024-02-01 [ sql ] [ DB ] CONNECT:[ UseTime:0.003734s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012768s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000784s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000630s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001263s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009895s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706716800 ) LIMIT 1 [ RunTime:0.004169s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706716800 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.004008s ] --------------------------------------------------------------- [ 2024-01-30T15:18:46+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-29&end_date=2024-02-01 [ sql ] [ DB ] CONNECT:[ UseTime:0.003862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012624s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.001028s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000983s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000748s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001319s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.013527s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706716800 ) LIMIT 1 [ RunTime:0.004088s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706716800 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.005536s ] --------------------------------------------------------------- [ 2024-01-30T15:18:58+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002850s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012272s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000590s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001525s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001863s ] --------------------------------------------------------------- [ 2024-01-30T15:19:16+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010455s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000499s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001475s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001258s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011302s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.003192s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003452s ] --------------------------------------------------------------- [ 2024-01-30T15:19:23+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002152s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012498s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000526s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001328s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001199s ] --------------------------------------------------------------- [ 2024-01-30T15:20:02+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001887s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011540s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000519s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001380s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001233s ] --------------------------------------------------------------- [ 2024-01-30T15:20:22+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.020189s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000838s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002778s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.002101s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012194s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.003554s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003445s ] --------------------------------------------------------------- [ 2024-01-30T15:20:32+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-29&end_date=2024-01-31 [ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011411s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.001194s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000469s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000656s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001280s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011677s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706630400 ) LIMIT 1 [ RunTime:0.003698s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706630400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003811s ] --------------------------------------------------------------- [ 2024-01-30T15:20:57+08:00 ] 120.225.218.183 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002267s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013901s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000813s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012703s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001494s ] --------------------------------------------------------------- [ 2024-01-30T15:21:05+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003126s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010920s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000577s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001566s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001402s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012774s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.003251s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.004012s ] --------------------------------------------------------------- [ 2024-01-30T15:21:14+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-29&end_date=2024-01-31 [ sql ] [ DB ] CONNECT:[ UseTime:0.001733s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011241s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.000716s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000491s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000661s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001317s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010696s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706630400 ) LIMIT 1 [ RunTime:0.004039s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706630400 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003901s ] --------------------------------------------------------------- [ 2024-01-30T15:21:17+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001994s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011621s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000528s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001555s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001383s ] --------------------------------------------------------------- [ 2024-01-30T15:22:07+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003482s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012345s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000876s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001341s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001223s ] --------------------------------------------------------------- [ 2024-01-30T15:22:12+08:00 ] 120.225.218.183 GET /home/multipleshow/edit/id/12.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003227s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013878s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.001678s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014062s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000557s ] --------------------------------------------------------------- [ 2024-01-30T15:22:18+08:00 ] 120.225.218.183 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001829s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010729s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000538s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000649s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000663s ] --------------------------------------------------------------- [ 2024-01-30T15:22:19+08:00 ] 120.225.218.183 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001985s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010189s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000599s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000754s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000769s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013450s ] [ 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.000485s ] [ 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.000709s ] --------------------------------------------------------------- [ 2024-01-30T15:22:20+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002007s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010682s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000551s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001482s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001534s ] --------------------------------------------------------------- [ 2024-01-30T15:24:40+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002117s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011623s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000536s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001401s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001230s ] --------------------------------------------------------------- [ 2024-01-30T15:24:42+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015764s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011684s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001894s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001369s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009749s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.003891s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003317s ] --------------------------------------------------------------- [ 2024-01-30T15:24:44+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002260s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011342s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000522s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001404s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001312s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010381s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.003302s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003121s ] --------------------------------------------------------------- [ 2024-01-30T15:24:44+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001900s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012297s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000569s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001488s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001371s ] --------------------------------------------------------------- [ 2024-01-30T15:25:20+08:00 ] 120.225.218.183 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002574s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011122s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001464s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001361s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012893s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.004241s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.004242s ] --------------------------------------------------------------- [ 2024-01-30T15:25:29+08:00 ] 120.225.218.183 GET /home/data/multipledata.html?keyword=862810047311997&start_date=2024-01-29&end_date=2024-02-01 [ sql ] [ DB ] CONNECT:[ UseTime:0.002114s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.024371s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '862810047311997' LIMIT 1 [ RunTime:0.000794s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '862810047311997' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000700s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.004389s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012355s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706716800 ) LIMIT 1 [ RunTime:0.003861s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' AND ( `update_time` >= 1706457600 AND `update_time` <= 1706716800 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003934s ] --------------------------------------------------------------- [ 2024-01-30T15:26:23+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001839s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011830s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000539s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001533s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001313s ] --------------------------------------------------------------- [ 2024-01-30T15:27:11+08:00 ] 218.56.88.206 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.014421s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000733s ] --------------------------------------------------------------- [ 2024-01-30T15:27:14+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001661s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011982s ] [ 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.001409s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001280s ] --------------------------------------------------------------- [ 2024-01-30T15:29:19+08:00 ] 120.225.218.183 GET /home/multipleshow/edit/id/12.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003613s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011854s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.001677s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011988s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2024-01-30T15:29:30+08:00 ] 120.225.218.183 POST /home/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001881s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012426s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='实验1',`interval`=10,`outage_time`=100,`gps`='119.530538,35.396872',`introduce`=' ',`update_time`=1706599770 WHERE `id` = 12 [ RunTime:0.000917s ] --------------------------------------------------------------- [ 2024-01-30T15:29:31+08:00 ] 120.225.218.183 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003312s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.014100s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000885s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001684s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001303s ] --------------------------------------------------------------- [ 2024-01-30T15:33:40+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002478s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010307s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000469s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001433s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001283s ] --------------------------------------------------------------- [ 2024-01-30T15:35:57+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002278s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011337s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000389s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001372s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001281s ] --------------------------------------------------------------- [ 2024-01-30T15:35:59+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001683s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012358s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000511s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001624s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001538s ] --------------------------------------------------------------- [ 2024-01-30T15:36:41+08:00 ] 218.56.88.206 GET /admin/multipleshow/read/id/12/imei/862810047311997.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_multipleshow` [ RunTime:0.009841s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000785s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012973s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' LIMIT 1 [ RunTime:0.005487s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.005840s ] --------------------------------------------------------------- [ 2024-01-30T15:36:59+08:00 ] 218.56.88.206 GET /admin/multipleshow/read/id/12/imei/862810047311997.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001955s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011452s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000830s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012730s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' LIMIT 1 [ RunTime:0.003898s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003981s ] --------------------------------------------------------------- [ 2024-01-30T15:37:00+08:00 ] 218.56.88.206 GET /admin/multipleshow/read/id/12/imei/862810047311997.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001757s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011256s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011240s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' LIMIT 1 [ RunTime:0.003603s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003694s ] --------------------------------------------------------------- [ 2024-01-30T15:40:09+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002479s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.015262s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000450s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001436s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001490s ] --------------------------------------------------------------- [ 2024-01-30T15:41:55+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002198s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010707s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000397s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001353s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001189s ] --------------------------------------------------------------- [ 2024-01-30T15:41:56+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001908s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012710s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000414s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001433s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001344s ] --------------------------------------------------------------- [ 2024-01-30T15:41:57+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002093s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011442s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000343s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001404s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001282s ] --------------------------------------------------------------- [ 2024-01-30T15:44:56+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002505s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011938s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000419s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001348s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001260s ] --------------------------------------------------------------- [ 2024-01-30T15:44:57+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001863s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012779s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001487s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001449s ] --------------------------------------------------------------- [ 2024-01-30T15:47:13+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002121s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011234s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000395s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001399s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001259s ] --------------------------------------------------------------- [ 2024-01-30T15:48:09+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003540s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.014418s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000472s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001445s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001309s ] --------------------------------------------------------------- [ 2024-01-30T15:48:11+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001812s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012569s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000439s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001469s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001260s ] --------------------------------------------------------------- [ 2024-01-30T15:50:51+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002046s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011442s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000444s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001474s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001312s ] --------------------------------------------------------------- [ 2024-01-30T15:50:52+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002157s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011433s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000447s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001489s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001232s ] --------------------------------------------------------------- [ 2024-01-30T15:50:54+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002093s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011425s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000601s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001947s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001263s ] --------------------------------------------------------------- [ 2024-01-30T15:50:55+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002041s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.009833s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000438s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001435s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001244s ] --------------------------------------------------------------- [ 2024-01-30T15:52:32+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001898s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013388s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000441s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001424s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001304s ] --------------------------------------------------------------- [ 2024-01-30T15:52:34+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001823s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010276s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000498s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001692s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001259s ] --------------------------------------------------------------- [ 2024-01-30T15:52:38+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002045s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011109s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001329s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001230s ] --------------------------------------------------------------- [ 2024-01-30T15:52:38+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002213s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010415s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000393s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001472s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001680s ] --------------------------------------------------------------- [ 2024-01-30T15:52:40+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002425s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012295s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000410s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001392s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001280s ] --------------------------------------------------------------- [ 2024-01-30T15:52:42+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.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_multipleshow` [ RunTime:0.010069s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000356s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001349s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001225s ] --------------------------------------------------------------- [ 2024-01-30T15:53:12+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002216s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.013499s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001695s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001219s ] --------------------------------------------------------------- [ 2024-01-30T15:53:15+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003097s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.016676s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000532s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001976s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001231s ] --------------------------------------------------------------- [ 2024-01-30T15:53:51+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002297s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010887s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000464s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001594s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001419s ] --------------------------------------------------------------- [ 2024-01-30T15:57:19+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002760s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010109s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000405s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001372s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001221s ] --------------------------------------------------------------- [ 2024-01-30T15:57:22+08:00 ] 218.56.88.206 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001943s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011889s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000437s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001370s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001264s ] --------------------------------------------------------------- [ 2024-01-30T15:58:05+08:00 ] 218.56.88.206 GET /admin/multipleshow/read/id/12/imei/862810047311997.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002443s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012025s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000833s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011706s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' LIMIT 1 [ RunTime:0.003923s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004452s ]