22.log 8.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. [2024-08-22T12:51:06+08:00][sql] CONNECT:[ UseTime:0.001009s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  2. [2024-08-22T12:51:06+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002177s ]
  3. [2024-08-22T12:51:06+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE `id` = 116 LIMIT 1 [ RunTime:0.000238s ]
  4. [2024-08-22T12:51:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_admin` WHERE `status` >= 0 AND `id` IN (121,118,1,93,120) LIMIT 1 [ RunTime:0.000251s ]
  5. [2024-08-22T12:51:06+08:00][sql] SELECT * FROM `cp_admin` WHERE `status` >= 0 AND `id` IN (121,118,1,93,120) ORDER BY `create_time` ASC LIMIT 0,20 [ RunTime:0.000273s ]
  6. [2024-08-22T12:51:06+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002229s ]
  7. [2024-08-22T12:51:06+08:00][sql] SELECT * FROM `cp_department` WHERE `id` IN (102,17) [ RunTime:0.000257s ]
  8. [2024-08-22T12:51:06+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.002159s ]
  9. [2024-08-22T12:51:06+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 93 [ RunTime:0.000224s ]
  10. [2024-08-22T12:51:06+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.001883s ]
  11. [2024-08-22T12:51:06+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 50 [ RunTime:0.000225s ]
  12. [2024-08-22T12:51:06+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 1 [ RunTime:0.000199s ]
  13. [2024-08-22T12:51:06+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 1 [ RunTime:0.000148s ]
  14. [2024-08-22T12:51:11+08:00][sql] CONNECT:[ UseTime:0.010087s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  15. [2024-08-22T12:51:11+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002393s ]
  16. [2024-08-22T12:51:11+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 93 LIMIT 1 [ RunTime:0.000310s ]
  17. [2024-08-22T12:51:11+08:00][sql] UPDATE `cp_admin` SET `last_login_time` = 1724302271 , `last_login_ip` = '127.0.0.1' , `login_num` = 172 WHERE `id` = 93 [ RunTime:0.002630s ]
  18. [2024-08-22T12:55:20+08:00][sql] CONNECT:[ UseTime:0.011206s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  19. [2024-08-22T12:55:20+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000683s ]
  20. [2024-08-22T12:55:20+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE `id` = 93 LIMIT 1 [ RunTime:0.000269s ]
  21. [2024-08-22T12:55:20+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_admin` WHERE `status` >= 0 AND `id` IN (1,115,118,130,125,116,136,140,121) LIMIT 1 [ RunTime:0.000244s ]
  22. [2024-08-22T12:55:20+08:00][sql] SELECT * FROM `cp_admin` WHERE `status` >= 0 AND `id` IN (1,115,118,130,125,116,136,140,121) ORDER BY `create_time` ASC LIMIT 0,20 [ RunTime:0.000260s ]
  23. [2024-08-22T12:55:20+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000504s ]
  24. [2024-08-22T12:55:20+08:00][sql] SELECT * FROM `cp_department` WHERE `id` IN (137,143,17) [ RunTime:0.000323s ]
  25. [2024-08-22T12:55:20+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.000499s ]
  26. [2024-08-22T12:55:20+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 136 [ RunTime:0.000191s ]
  27. [2024-08-22T12:55:20+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.000349s ]
  28. [2024-08-22T12:55:20+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000146s ]
  29. [2024-08-22T12:55:20+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 140 [ RunTime:0.000147s ]
  30. [2024-08-22T12:55:20+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000134s ]
  31. [2024-08-22T12:55:20+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 1 [ RunTime:0.000146s ]
  32. [2024-08-22T12:55:20+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 1 [ RunTime:0.000132s ]
  33. [2024-08-22T12:55:23+08:00][sql] CONNECT:[ UseTime:0.017909s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  34. [2024-08-22T12:55:23+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000664s ]
  35. [2024-08-22T12:55:23+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000275s ]
  36. [2024-08-22T12:55:23+08:00][sql] UPDATE `cp_admin` SET `last_login_time` = 1724302523 , `last_login_ip` = '127.0.0.1' , `login_num` = 478 WHERE `id` = 1 [ RunTime:0.003122s ]
  37. [2024-08-22T13:10:47+08:00][sql] CONNECT:[ UseTime:0.000948s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  38. [2024-08-22T13:10:47+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000752s ]
  39. [2024-08-22T13:10:47+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000254s ]
  40. [2024-08-22T13:10:47+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) LIMIT 1 [ RunTime:0.000321s ]
  41. [2024-08-22T13:10:47+08:00][sql] SELECT * FROM `cp_admin` WHERE `status` >= 0 AND `id` IN (93,117,115,118,116,121,136,140) ORDER BY `create_time` ASC LIMIT 0,20 [ RunTime:0.000362s ]
  42. [2024-08-22T13:10:47+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000718s ]
  43. [2024-08-22T13:10:47+08:00][sql] SELECT * FROM `cp_department` WHERE `id` IN (102,137,143) [ RunTime:0.000336s ]
  44. [2024-08-22T13:10:47+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.000466s ]
  45. [2024-08-22T13:10:47+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 93 [ RunTime:0.000209s ]
  46. [2024-08-22T13:10:47+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.000471s ]
  47. [2024-08-22T13:10:47+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 50 [ RunTime:0.000149s ]
  48. [2024-08-22T13:10:47+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 136 [ RunTime:0.000149s ]
  49. [2024-08-22T13:10:47+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000174s ]
  50. [2024-08-22T13:10:47+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 140 [ RunTime:0.000152s ]
  51. [2024-08-22T13:10:47+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000132s ]
  52. [2024-08-22T13:10:51+08:00][sql] CONNECT:[ UseTime:0.001391s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  53. [2024-08-22T13:10:51+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000595s ]
  54. [2024-08-22T13:10:51+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 93 LIMIT 1 [ RunTime:0.000251s ]
  55. [2024-08-22T13:10:51+08:00][sql] UPDATE `cp_admin` SET `last_login_time` = 1724303451 , `last_login_ip` = '127.0.0.1' , `login_num` = 173 WHERE `id` = 93 [ RunTime:0.002815s ]
  56. [2024-08-22T14:08:49+08:00][sql] CONNECT:[ UseTime:0.001020s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  57. [2024-08-22T14:08:49+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.001023s ]
  58. [2024-08-22T14:08:49+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000317s ]
  59. [2024-08-22T14:08:49+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) LIMIT 1 [ RunTime:0.000381s ]
  60. [2024-08-22T14:08:49+08:00][sql] SELECT * FROM `cp_admin` WHERE `status` >= 0 AND `id` IN (93,117,115,118,116,121,136,140) ORDER BY `create_time` ASC LIMIT 0,20 [ RunTime:0.000338s ]
  61. [2024-08-22T14:08:49+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.000617s ]
  62. [2024-08-22T14:08:49+08:00][sql] SELECT * FROM `cp_department` WHERE `id` IN (102,137,143) [ RunTime:0.000254s ]
  63. [2024-08-22T14:08:49+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.000417s ]
  64. [2024-08-22T14:08:49+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 93 [ RunTime:0.000187s ]
  65. [2024-08-22T14:08:49+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.000451s ]
  66. [2024-08-22T14:08:49+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 50 [ RunTime:0.000229s ]
  67. [2024-08-22T14:08:49+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 136 [ RunTime:0.000246s ]
  68. [2024-08-22T14:08:49+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 60 [ RunTime:0.000175s ]
  69. [2024-08-22T14:08:49+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE `uid` = 140 [ RunTime:0.000180s ]
  70. [2024-08-22T14:08:49+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE `id` = 63 [ RunTime:0.000199s ]
  71. [2024-08-22T14:08:55+08:00][sql] CONNECT:[ UseTime:0.000885s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
  72. [2024-08-22T14:08:55+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.000639s ]
  73. [2024-08-22T14:08:55+08:00][sql] SELECT * FROM `cp_admin` WHERE `id` = 93 LIMIT 1 [ RunTime:0.000285s ]
  74. [2024-08-22T14:08:55+08:00][sql] UPDATE `cp_admin` SET `last_login_time` = 1724306935 , `last_login_ip` = '127.0.0.1' , `login_num` = 174 WHERE `id` = 93 [ RunTime:0.002874s ]