caiping/runtime/acctconnect/log/202408/31.log

[2024-08-31T10:02:11+08:00][sql] CONNECT:[ UseTime:0.025338s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
[2024-08-31T10:02:11+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.003105s ]
[2024-08-31T10:02:11+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE  `id` = 141 LIMIT 1 [ RunTime:0.000530s ]
[2024-08-31T10:02:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_admin` WHERE  `status` >= 0  AND `id` = 140 LIMIT 1 [ RunTime:0.000445s ]
[2024-08-31T10:02:11+08:00][sql] SELECT * FROM `cp_admin` WHERE  `status` >= 0  AND `id` = 140 ORDER BY `create_time` ASC LIMIT 0,20 [ RunTime:0.000376s ]
[2024-08-31T10:02:11+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.003654s ]
[2024-08-31T10:02:11+08:00][sql] SELECT * FROM `cp_department` WHERE  `id` = 143 [ RunTime:0.000426s ]
[2024-08-31T10:02:11+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.002813s ]
[2024-08-31T10:02:11+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 140 [ RunTime:0.000489s ]
[2024-08-31T10:02:11+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.003105s ]
[2024-08-31T10:02:11+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 63 [ RunTime:0.001043s ]
[2024-08-31T10:02:15+08:00][sql] CONNECT:[ UseTime:0.015136s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
[2024-08-31T10:02:15+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.003145s ]
[2024-08-31T10:02:15+08:00][sql] SELECT * FROM `cp_admin` WHERE  `id` = 140 LIMIT 1 [ RunTime:0.000413s ]
[2024-08-31T10:02:15+08:00][sql] UPDATE `cp_admin`  SET `last_login_time` = 1725069735 , `last_login_ip` = '127.0.0.1' , `login_num` = 168  WHERE  `id` = 140 [ RunTime:0.004559s ]
[2024-08-31T10:02:21+08:00][sql] CONNECT:[ UseTime:0.001753s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
[2024-08-31T10:02:21+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.001368s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE  `id` = 140 LIMIT 1 [ RunTime:0.000798s ]
[2024-08-31T10:02:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_admin` WHERE  `status` >= 0  AND `id` IN (93,141,142,143,136,1) LIMIT 1 [ RunTime:0.000543s ]
[2024-08-31T10:02:21+08:00][sql] SELECT * FROM `cp_admin` WHERE  `status` >= 0  AND `id` IN (93,141,142,143,136,1) ORDER BY `create_time` ASC LIMIT 0,20 [ RunTime:0.000464s ]
[2024-08-31T10:02:21+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.001178s ]
[2024-08-31T10:02:21+08:00][sql] SELECT * FROM `cp_department` WHERE  `id` IN (102,137,143,17) [ RunTime:0.000497s ]
[2024-08-31T10:02:21+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.003538s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 93 [ RunTime:0.000428s ]
[2024-08-31T10:02:21+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.002763s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 50 [ RunTime:0.000378s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 136 [ RunTime:0.000301s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 60 [ RunTime:0.000270s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 141 [ RunTime:0.000205s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 86 [ RunTime:0.000182s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 142 [ RunTime:0.000625s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 87 [ RunTime:0.000250s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 143 [ RunTime:0.000175s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 87 [ RunTime:0.000174s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 1 [ RunTime:0.000214s ]
[2024-08-31T10:02:21+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 1 [ RunTime:0.000205s ]
[2024-08-31T10:02:27+08:00][sql] CONNECT:[ UseTime:0.025765s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
[2024-08-31T10:02:27+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.001068s ]
[2024-08-31T10:02:27+08:00][sql] SELECT * FROM `cp_admin` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000440s ]
[2024-08-31T10:02:27+08:00][sql] UPDATE `cp_admin`  SET `last_login_time` = 1725069747 , `last_login_ip` = '127.0.0.1' , `login_num` = 530  WHERE  `id` = 1 [ RunTime:0.004838s ]
[2024-08-31T10:02:34+08:00][sql] CONNECT:[ UseTime:0.024434s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
[2024-08-31T10:02:34+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000962s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000520s ]
[2024-08-31T10:02:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_admin` WHERE  `status` >= 0  AND `id` IN (93,117,115,118,116,121,136,140,331,132,332,333) LIMIT 1 [ RunTime:0.000573s ]
[2024-08-31T10:02:34+08:00][sql] SELECT * FROM `cp_admin` WHERE  `status` >= 0  AND `id` IN (93,117,115,118,116,121,136,140,331,132,332,333) ORDER BY `create_time` ASC LIMIT 0,20 [ RunTime:0.000792s ]
[2024-08-31T10:02:34+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000851s ]
[2024-08-31T10:02:34+08:00][sql] SELECT * FROM `cp_department` WHERE  `id` IN (354,102,111,114,136,137,143) [ RunTime:0.000541s ]
[2024-08-31T10:02:34+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.002553s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 331 [ RunTime:0.000488s ]
[2024-08-31T10:02:34+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.002840s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 167 [ RunTime:0.000358s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 332 [ RunTime:0.000346s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 167 [ RunTime:0.000264s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 333 [ RunTime:0.000216s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 167 [ RunTime:0.000285s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 93 [ RunTime:0.000467s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 50 [ RunTime:0.000288s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 115 [ RunTime:0.000228s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 60 [ RunTime:0.000278s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 116 [ RunTime:0.000184s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 63 [ RunTime:0.000434s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 117 [ RunTime:0.000331s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 66 [ RunTime:0.000272s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 118 [ RunTime:0.000174s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 67 [ RunTime:0.000196s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 132 [ RunTime:0.000255s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 60 [ RunTime:0.000155s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 136 [ RunTime:0.000167s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 60 [ RunTime:0.000157s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 140 [ RunTime:0.000165s ]
[2024-08-31T10:02:34+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 63 [ RunTime:0.000161s ]
[2024-08-31T10:02:37+08:00][sql] CONNECT:[ UseTime:0.013159s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
[2024-08-31T10:02:37+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.001189s ]
[2024-08-31T10:02:37+08:00][sql] SELECT * FROM `cp_admin` WHERE  `id` = 331 LIMIT 1 [ RunTime:0.000406s ]
[2024-08-31T10:02:37+08:00][sql] UPDATE `cp_admin`  SET `last_login_time` = 1725069757 , `last_login_ip` = '127.0.0.1' , `login_num` = 47  WHERE  `id` = 331 [ RunTime:0.003478s ]