30.log 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. [2024-08-30T15:19:44+08:00][sql] CONNECT:[ UseTime:0.013354s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  2. [2024-08-30T15:19:44+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.003553s ]
  3. [2024-08-30T15:19:44+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000606s ]
  4. [2024-08-30T15:19:44+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.000512s ]
  5. [2024-08-30T15:19:44+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.000444s ]
  6. [2024-08-30T15:19:44+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.003314s ]
  7. [2024-08-30T15:19:44+08:00][sql] SELECT * FROM `cp_department` WHERE `id` IN (354,102,111,114,136,137,143) [ RunTime:0.000670s ]
  8. [2024-08-30T15:19:44+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.003244s ]
  9. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 331 [ RunTime:0.000533s ]
  10. [2024-08-30T15:19:44+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.003013s ]
  11. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 167 [ RunTime:0.000403s ]
  12. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 332 [ RunTime:0.000411s ]
  13. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 167 [ RunTime:0.000401s ]
  14. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 333 [ RunTime:0.000566s ]
  15. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 167 [ RunTime:0.000278s ]
  16. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 93 [ RunTime:0.000222s ]
  17. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 50 [ RunTime:0.000226s ]
  18. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 115 [ RunTime:0.000225s ]
  19. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000221s ]
  20. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 116 [ RunTime:0.000225s ]
  21. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000219s ]
  22. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 117 [ RunTime:0.000170s ]
  23. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 66 [ RunTime:0.000213s ]
  24. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 118 [ RunTime:0.000225s ]
  25. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 67 [ RunTime:0.000146s ]
  26. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 132 [ RunTime:0.000253s ]
  27. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000268s ]
  28. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 136 [ RunTime:0.000253s ]
  29. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000204s ]
  30. [2024-08-30T15:19:44+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 140 [ RunTime:0.000307s ]
  31. [2024-08-30T15:19:44+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000147s ]
  32. [2024-08-30T15:19:59+08:00][sql] CONNECT:[ UseTime:0.018474s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  33. [2024-08-30T15:19:59+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002751s ]
  34. [2024-08-30T15:19:59+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 140 LIMIT 1 [ RunTime:0.000428s ]
  35. [2024-08-30T15:19:59+08:00][sql] UPDATE `cp_admin` SET `last_login_time` = 1725002399 , `last_login_ip` = '127.0.0.1' , `login_num` = 167 WHERE `id` = 140 [ RunTime:0.018104s ]
  36. [2024-08-30T15:20:09+08:00][sql] CONNECT:[ UseTime:0.020701s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  37. [2024-08-30T15:20:09+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.001659s ]
  38. [2024-08-30T15:20:09+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE `id` = 140 LIMIT 1 [ RunTime:0.000310s ]
  39. [2024-08-30T15:20:09+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.000435s ]
  40. [2024-08-30T15:20:09+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.000452s ]
  41. [2024-08-30T15:20:09+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.003203s ]
  42. [2024-08-30T15:20:09+08:00][sql] SELECT * FROM `cp_department` WHERE `id` IN (102,137,143,17) [ RunTime:0.000824s ]
  43. [2024-08-30T15:20:09+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.000918s ]
  44. [2024-08-30T15:20:09+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 93 [ RunTime:0.000405s ]
  45. [2024-08-30T15:20:09+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.002849s ]
  46. [2024-08-30T15:20:09+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 50 [ RunTime:0.000371s ]
  47. [2024-08-30T15:20:09+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 136 [ RunTime:0.000257s ]
  48. [2024-08-30T15:20:09+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000224s ]
  49. [2024-08-30T15:20:09+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 141 [ RunTime:0.000224s ]
  50. [2024-08-30T15:20:09+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 86 [ RunTime:0.000888s ]
  51. [2024-08-30T15:20:09+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 142 [ RunTime:0.000405s ]
  52. [2024-08-30T15:20:09+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 87 [ RunTime:0.000391s ]
  53. [2024-08-30T15:20:09+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 143 [ RunTime:0.000414s ]
  54. [2024-08-30T15:20:09+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 87 [ RunTime:0.000275s ]
  55. [2024-08-30T15:20:09+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 1 [ RunTime:0.000168s ]
  56. [2024-08-30T15:20:09+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 1 [ RunTime:0.000165s ]
  57. [2024-08-30T15:20:27+08:00][sql] CONNECT:[ UseTime:0.011388s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  58. [2024-08-30T15:20:27+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.001157s ]
  59. [2024-08-30T15:20:27+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 141 LIMIT 1 [ RunTime:0.000388s ]
  60. [2024-08-30T15:20:27+08:00][sql] UPDATE `cp_admin` SET `last_login_time` = 1725002427 , `last_login_ip` = '127.0.0.1' , `login_num` = 4 WHERE `id` = 141 [ RunTime:0.019566s ]