29.log 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081
  1. [2024-08-29T13:24:22+08:00][sql] CONNECT:[ UseTime:0.000963s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  2. [2024-08-29T13:24:22+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000809s ]
  3. [2024-08-29T13:24:22+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE `id` = 140 LIMIT 1 [ RunTime:0.000261s ]
  4. [2024-08-29T13:24:22+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.000221s ]
  5. [2024-08-29T13:24:22+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.000264s ]
  6. [2024-08-29T13:24:22+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002350s ]
  7. [2024-08-29T13:24:22+08:00][sql] SELECT * FROM `cp_department` WHERE `id` IN (102,137,143,17) [ RunTime:0.000310s ]
  8. [2024-08-29T13:24:22+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.000527s ]
  9. [2024-08-29T13:24:22+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 93 [ RunTime:0.000217s ]
  10. [2024-08-29T13:24:22+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.000454s ]
  11. [2024-08-29T13:24:22+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 50 [ RunTime:0.000149s ]
  12. [2024-08-29T13:24:22+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 136 [ RunTime:0.000147s ]
  13. [2024-08-29T13:24:22+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000135s ]
  14. [2024-08-29T13:24:22+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 141 [ RunTime:0.000151s ]
  15. [2024-08-29T13:24:22+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 86 [ RunTime:0.000495s ]
  16. [2024-08-29T13:24:22+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 142 [ RunTime:0.000153s ]
  17. [2024-08-29T13:24:22+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 87 [ RunTime:0.000135s ]
  18. [2024-08-29T13:24:22+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 143 [ RunTime:0.000145s ]
  19. [2024-08-29T13:24:22+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 87 [ RunTime:0.000135s ]
  20. [2024-08-29T13:24:22+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 1 [ RunTime:0.000142s ]
  21. [2024-08-29T13:24:22+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 1 [ RunTime:0.000132s ]
  22. [2024-08-29T13:24:55+08:00][sql] CONNECT:[ UseTime:0.000989s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  23. [2024-08-29T13:24:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000749s ]
  24. [2024-08-29T13:24:55+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE `id` = 140 LIMIT 1 [ RunTime:0.000234s ]
  25. [2024-08-29T13:24:55+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.000219s ]
  26. [2024-08-29T13:24:55+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.000254s ]
  27. [2024-08-29T13:24:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000412s ]
  28. [2024-08-29T13:24:55+08:00][sql] SELECT * FROM `cp_department` WHERE `id` IN (102,137,143,17) [ RunTime:0.000249s ]
  29. [2024-08-29T13:24:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.002352s ]
  30. [2024-08-29T13:24:55+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 93 [ RunTime:0.000293s ]
  31. [2024-08-29T13:24:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.002039s ]
  32. [2024-08-29T13:24:55+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 50 [ RunTime:0.000181s ]
  33. [2024-08-29T13:24:55+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 136 [ RunTime:0.000173s ]
  34. [2024-08-29T13:24:55+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000158s ]
  35. [2024-08-29T13:24:55+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 141 [ RunTime:0.000149s ]
  36. [2024-08-29T13:24:55+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 86 [ RunTime:0.000136s ]
  37. [2024-08-29T13:24:55+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 142 [ RunTime:0.000145s ]
  38. [2024-08-29T13:24:55+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 87 [ RunTime:0.000133s ]
  39. [2024-08-29T13:24:55+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 143 [ RunTime:0.000141s ]
  40. [2024-08-29T13:24:55+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 87 [ RunTime:0.000131s ]
  41. [2024-08-29T13:24:55+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 1 [ RunTime:0.000139s ]
  42. [2024-08-29T13:24:55+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 1 [ RunTime:0.000130s ]
  43. [2024-08-29T13:24:59+08:00][sql] CONNECT:[ UseTime:0.025031s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  44. [2024-08-29T13:24:59+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000810s ]
  45. [2024-08-29T13:24:59+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000370s ]
  46. [2024-08-29T13:24:59+08:00][sql] UPDATE `cp_admin` SET `last_login_time` = 1724909099 , `last_login_ip` = '127.0.0.1' , `login_num` = 528 WHERE `id` = 1 [ RunTime:0.002873s ]
  47. [2024-08-29T13:29:14+08:00][sql] CONNECT:[ UseTime:0.024020s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  48. [2024-08-29T13:29:14+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000773s ]
  49. [2024-08-29T13:29:14+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000271s ]
  50. [2024-08-29T13:29:14+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.000312s ]
  51. [2024-08-29T13:29:14+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.000368s ]
  52. [2024-08-29T13:29:14+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000543s ]
  53. [2024-08-29T13:29:14+08:00][sql] SELECT * FROM `cp_department` WHERE `id` IN (354,102,111,114,136,137,143) [ RunTime:0.000314s ]
  54. [2024-08-29T13:29:14+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.000384s ]
  55. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 331 [ RunTime:0.000180s ]
  56. [2024-08-29T13:29:14+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.000466s ]
  57. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 167 [ RunTime:0.000180s ]
  58. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 332 [ RunTime:0.000179s ]
  59. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 167 [ RunTime:0.000256s ]
  60. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 333 [ RunTime:0.000171s ]
  61. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 167 [ RunTime:0.000191s ]
  62. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 93 [ RunTime:0.000213s ]
  63. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 50 [ RunTime:0.000146s ]
  64. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 115 [ RunTime:0.000209s ]
  65. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000139s ]
  66. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 116 [ RunTime:0.000144s ]
  67. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000132s ]
  68. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 117 [ RunTime:0.000181s ]
  69. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 66 [ RunTime:0.000136s ]
  70. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 118 [ RunTime:0.000146s ]
  71. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 67 [ RunTime:0.000137s ]
  72. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 132 [ RunTime:0.000145s ]
  73. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000139s ]
  74. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 136 [ RunTime:0.000143s ]
  75. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000135s ]
  76. [2024-08-29T13:29:14+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 140 [ RunTime:0.000144s ]
  77. [2024-08-29T13:29:14+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000140s ]
  78. [2024-08-29T13:29:17+08:00][sql] CONNECT:[ UseTime:0.022796s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  79. [2024-08-29T13:29:17+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000688s ]
  80. [2024-08-29T13:29:17+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 331 LIMIT 1 [ RunTime:0.000376s ]
  81. [2024-08-29T13:29:17+08:00][sql] UPDATE `cp_admin` SET `last_login_time` = 1724909357 , `last_login_ip` = '127.0.0.1' , `login_num` = 46 WHERE `id` = 331 [ RunTime:0.003489s ]