--------------------------------------------------------------- [ 2025-01-16T01:13:57+08:00 ] 111.55.120.55 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002116s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009297s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000681s ] --------------------------------------------------------------- [ 2025-01-16T01:13:59+08:00 ] 111.55.120.55 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1736961237&v1=-1.240164&v2=0.160866&v3=-0.822974&v4=-0.859877&v5=6.300000&t=-5.965928&h=73.940796&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428405,36.323159&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001514s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008089s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000578s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1736961237,`v1`=-1.240164,`v2`=0.160866,`v3`=-0.822974,`v4`=-0.859877,`v5`=6.3,`t`=-5.965928,`h`=73.940796,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428405,36.323159',`update_time`=1736961239 WHERE `imei` = '868922055684209' [ RunTime:0.000490s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012719s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1736961237 , -1.240164 , 0.160866 , -0.822974 , -0.859877 , 6.3 , -5.965928 , 73.940796 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428405,36.323159' , 1736961239) [ RunTime:0.003576s ] --------------------------------------------------------------- [ 2025-01-16T02:15:59+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/273.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002187s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012499s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 273 [ RunTime:0.000635s ] --------------------------------------------------------------- [ 2025-01-16T02:20:37+08:00 ] 66.249.74.65 GET /admin/multipledata/delete.html [ error ] [0]方法参数错误:id --------------------------------------------------------------- [ 2025-01-16T06:50:06+08:00 ] 111.55.120.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.001962s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009203s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001462s ] --------------------------------------------------------------- [ 2025-01-16T06:50:07+08:00 ] 111.55.120.23 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1736981406&v1=-1.300546&v2=0.034991&v3=-1.027295&v4=-0.684873&v5=6.300000&t=-6.823936&h=82.439941&rssi=28&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001446s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008105s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1736981406,`v1`=-1.300546,`v2`=0.034991,`v3`=-1.027295,`v4`=-0.684873,`v5`=6.3,`t`=-6.823936,`h`=82.439941,`rssi`=28,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1736981407 WHERE `imei` = '868922055644021' [ RunTime:0.000474s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009033s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1736981406 , -1.300546 , 0.034991 , -1.027295 , -0.684873 , 6.3 , -6.823936 , 82.439941 , 28 , '898604650119C1053141' , '460048590503141' , -0 , 1736981407) [ RunTime:0.001390s ] --------------------------------------------------------------- [ 2025-01-16T08:14:42+08:00 ] 218.56.88.228 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010437s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001316s ] --------------------------------------------------------------- [ 2025-01-16T08:14:43+08:00 ] 218.56.88.228 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001273s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009338s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000431s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000757s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000628s ] --------------------------------------------------------------- [ 2025-01-16T08:14:45+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001700s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009060s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000796s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008259s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.006644s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000469s ] --------------------------------------------------------------- [ 2025-01-16T10:28:48+08:00 ] 66.249.74.64 GET /admin/multipledata/delete/id/132.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002266s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010734s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 132 [ RunTime:0.000592s ] --------------------------------------------------------------- [ 2025-01-16T10:31:59+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4590.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001756s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008070s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4590 [ RunTime:0.000511s ] --------------------------------------------------------------- [ 2025-01-16T10:38:48+08:00 ] 66.249.74.64 GET /admin/multipledata/delete/id/4588.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002199s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009380s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4588 [ RunTime:0.000516s ] --------------------------------------------------------------- [ 2025-01-16T10:39:27+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/4576.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001539s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008012s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4576 [ RunTime:0.000796s ] --------------------------------------------------------------- [ 2025-01-16T10:39:48+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4589.html [ sql ] [ DB ] CONNECT:[ UseTime:0.017243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009301s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4589 [ RunTime:0.000569s ] --------------------------------------------------------------- [ 2025-01-16T10:41:22+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/4571.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001590s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008515s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4571 [ RunTime:0.000476s ] --------------------------------------------------------------- [ 2025-01-16T10:43:22+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/4513.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001691s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009268s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4513 [ RunTime:0.000491s ] --------------------------------------------------------------- [ 2025-01-16T10:47:00+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/4166.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_multipledata` [ RunTime:0.009373s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4166 [ RunTime:0.000604s ] --------------------------------------------------------------- [ 2025-01-16T10:50:24+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4167.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001381s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.007675s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4167 [ RunTime:0.000465s ] --------------------------------------------------------------- [ 2025-01-16T10:55:48+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4120.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002036s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008452s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4120 [ RunTime:0.000512s ] --------------------------------------------------------------- [ 2025-01-16T10:56:49+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4119.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001676s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010587s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4119 [ RunTime:0.000549s ] --------------------------------------------------------------- [ 2025-01-16T11:00:09+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/4118.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001873s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008414s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4118 [ RunTime:0.000992s ] --------------------------------------------------------------- [ 2025-01-16T11:00:10+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001702s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008533s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4123 [ RunTime:0.000530s ] --------------------------------------------------------------- [ 2025-01-16T11:00:15+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4125.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011087s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4125 [ RunTime:0.000729s ] --------------------------------------------------------------- [ 2025-01-16T11:01:19+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/4124.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002003s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009000s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4124 [ RunTime:0.000476s ] --------------------------------------------------------------- [ 2025-01-16T11:01:22+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/538.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001609s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008314s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 538 [ RunTime:0.000573s ] --------------------------------------------------------------- [ 2025-01-16T11:06:10+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4575.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002547s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008505s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4575 [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2025-01-16T11:08:57+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4916.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001674s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008090s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4916 [ RunTime:0.000491s ] --------------------------------------------------------------- [ 2025-01-16T11:18:19+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/4914.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002136s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011038s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4914 [ RunTime:0.000533s ] --------------------------------------------------------------- [ 2025-01-16T11:19:10+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/708.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001726s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008307s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 708 [ RunTime:0.000547s ] --------------------------------------------------------------- [ 2025-01-16T11:21:01+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4122.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002021s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009296s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4122 [ RunTime:0.000485s ] --------------------------------------------------------------- [ 2025-01-16T11:24:21+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/701.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002236s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009126s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 701 [ RunTime:0.000983s ] --------------------------------------------------------------- [ 2025-01-16T11:24:49+08:00 ] 66.249.74.65 GET /admin/shelves/read/id/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014904s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_goods` [ RunTime:0.024947s ] [ sql ] [ SQL ] SELECT * FROM `collect_goods` WHERE ( `id` = 0 ) AND `collect_goods`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001314s ] --------------------------------------------------------------- [ 2025-01-16T11:29:58+08:00 ] 66.249.74.64 GET /admin/multipledata/delete/id/4917.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011427s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4917 [ RunTime:0.000539s ] --------------------------------------------------------------- [ 2025-01-16T11:51:01+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/4920.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002195s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008121s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4920 [ RunTime:0.000474s ] --------------------------------------------------------------- [ 2025-01-16T11:55:10+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4922.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001539s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.007800s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4922 [ RunTime:0.000760s ] --------------------------------------------------------------- [ 2025-01-16T11:56:15+08:00 ] 66.249.74.66 GET /admin/multipledata/delete/id/4918.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002308s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011129s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4918 [ RunTime:0.000750s ] --------------------------------------------------------------- [ 2025-01-16T12:35:23+08:00 ] 218.56.88.228 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001912s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009234s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001290s ] --------------------------------------------------------------- [ 2025-01-16T12:35:24+08:00 ] 218.56.88.228 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001357s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010552s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000489s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000828s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000687s ] --------------------------------------------------------------- [ 2025-01-16T12:35:25+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001399s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008683s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000815s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008668s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007689s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000521s ] --------------------------------------------------------------- [ 2025-01-16T12:36:06+08:00 ] 218.56.88.228 GET /home/heating/data_analysis_day.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001788s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008748s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000411s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000814s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.010758s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) LIMIT 1 [ RunTime:0.000376s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000389s ] --------------------------------------------------------------- [ 2025-01-16T12:36:14+08:00 ] 218.56.88.228 GET /home/heating/data_analysis_day.html?keyword=123&start_date=2025-01-13&end_date=2025-01-16 [ sql ] [ DB ] CONNECT:[ UseTime:0.001440s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008354s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000844s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000380s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000610s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.007797s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1736697600 AND `create_time` <= 1736956800 ) LIMIT 1 [ RunTime:0.001251s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1736697600 AND `create_time` <= 1736956800 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000493s ] --------------------------------------------------------------- [ 2025-01-16T12:37:50+08:00 ] 218.56.88.228 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001892s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.020122s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000387s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000830s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000605s ] --------------------------------------------------------------- [ 2025-01-16T12:37:51+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001761s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008615s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007338s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000467s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007229s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2025-01-16T13:23:16+08:00 ] 218.56.88.228 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002100s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009274s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000558s ] --------------------------------------------------------------- [ 2025-01-16T13:23:17+08:00 ] 218.56.88.228 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001746s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009814s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000467s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000838s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000746s ] --------------------------------------------------------------- [ 2025-01-16T13:23:18+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001658s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008736s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000944s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008279s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007398s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000541s ] --------------------------------------------------------------- [ 2025-01-16T13:30:29+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/4127.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002022s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010267s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4127 [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2025-01-16T13:42:36+08:00 ] 116.95.203.189 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002057s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011930s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000467s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000810s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007873s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) LIMIT 1 [ RunTime:0.000339s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000364s ] --------------------------------------------------------------- [ 2025-01-16T13:42:41+08:00 ] 116.95.203.189 GET /home/heating/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_heating` [ RunTime:0.009716s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000569s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000772s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2025-01-16T13:42:44+08:00 ] 116.95.203.189 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008417s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000830s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007634s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000491s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008520s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2025-01-16T16:22:25+08:00 ] 110.7.187.121 GET /home/heating [ sql ] [ DB ] CONNECT:[ UseTime:0.002375s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008728s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000346s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000718s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000702s ] --------------------------------------------------------------- [ 2025-01-16T16:22:38+08:00 ] 110.7.187.121 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004625s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014754s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000511s ] --------------------------------------------------------------- [ 2025-01-16T16:22:39+08:00 ] 110.7.187.121 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001662s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009072s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000431s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000792s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2025-01-16T16:22:57+08:00 ] 110.7.187.121 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001535s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008183s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000996s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007453s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000699s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.006749s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000456s ] --------------------------------------------------------------- [ 2025-01-16T17:32:34+08:00 ] 39.144.0.42 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002206s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008977s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'duolucaijiyi' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2025-01-16T17:32:35+08:00 ] 39.144.0.42 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001410s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021685s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.009882s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000929s ] --------------------------------------------------------------- [ 2025-01-16T17:33:08+08:00 ] 39.144.0.42 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001630s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008136s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'duolucaijiyi' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000506s ] --------------------------------------------------------------- [ 2025-01-16T17:33:09+08:00 ] 39.144.0.42 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001804s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008632s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001054s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.007668s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000501s ] --------------------------------------------------------------- [ 2025-01-16T17:33:17+08:00 ] 39.144.0.42 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001334s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008312s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000426s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000581s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000560s ] --------------------------------------------------------------- [ 2025-01-16T17:33:26+08:00 ] 39.144.0.42 GET /home/show/index.html?keyword= [ sql ] [ DB ] CONNECT:[ UseTime:0.001663s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009054s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000428s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000577s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000594s ] --------------------------------------------------------------- [ 2025-01-16T17:33:36+08:00 ] 39.144.0.42 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001313s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007864s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000399s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000548s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012406s ] [ 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.000322s ] [ 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.000419s ] --------------------------------------------------------------- [ 2025-01-16T17:55:18+08:00 ] 218.56.88.228 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002085s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.007948s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000475s ] --------------------------------------------------------------- [ 2025-01-16T17:55:19+08:00 ] 218.56.88.228 GET /home/heating/index.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_heating` [ RunTime:0.008968s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000809s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000657s ] --------------------------------------------------------------- [ 2025-01-16T17:55:21+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002005s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008015s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000895s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008305s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.009943s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2025-01-16T20:34:05+08:00 ] 39.144.0.163 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008845s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000495s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000611s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008899s ] [ 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.000393s ] [ 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.000455s ] --------------------------------------------------------------- [ 2025-01-16T21:00:43+08:00 ] 39.144.0.163 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002468s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011880s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000544s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000776s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000707s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009198s ] [ 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.000389s ] [ 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.000548s ] --------------------------------------------------------------- [ 2025-01-16T22:54:27+08:00 ] 66.249.75.65 GET /admin/multipledata/delete/id/4998.html [ sql ] [ DB ] CONNECT:[ UseTime:0.016622s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009651s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4998 [ RunTime:0.000521s ] --------------------------------------------------------------- [ 2025-01-16T22:57:44+08:00 ] 218.56.88.228 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008650s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000497s ] --------------------------------------------------------------- [ 2025-01-16T22:57:45+08:00 ] 218.56.88.228 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001403s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010881s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000830s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000783s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000690s ] --------------------------------------------------------------- [ 2025-01-16T22:57:47+08:00 ] 218.56.88.228 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001628s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009301s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001025s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007549s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000477s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008009s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000492s ]