Home Explore Help
Register Sign In
heshengjun
/
collect_schedule
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
collect_schedul...
/
storage
/
logs
/
sql
/
sql-2025-05-24.log

sql-2025-05-24.log 32 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200 
  1. [2025-05-24T10:53:24.529557+08:00] sql.INFO: select `uid`, `company_id`, `username`, `phone`, `status`, `password`, `insert_time`, `update_time` from `kailin_admin_company` where `username` = admin or `phone` = admin limit 1 ["RunTime:81.8ms"] []
    2. 

  2. [2025-05-24T10:53:24.575887+08:00] sql.INFO: select `name`, `status` from `kailin_company` where (`id` = 1) limit 1 ["RunTime:2.27ms"] []
    3. 

  3. [2025-05-24T10:57:54.480254+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:3.58ms"] []
    4. 

  4. [2025-05-24T10:57:54.498841+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:1.96ms"] []
    5. 

  5. [2025-05-24T10:57:54.521800+08:00] sql.INFO: select * from `kailin_company` where (`status` = 0) ["RunTime:1.32ms"] []
    6. 

  6. [2025-05-24T10:57:54.551934+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:2.55ms"] []
    7. 

  7. [2025-05-24T11:14:06.091327+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:8.21ms"] []
    8. 

  8. [2025-05-24T11:14:06.099323+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:6.11ms"] []
    9. 

  9. [2025-05-24T11:21:04.666185+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.46ms"] []
    10. 

  10. [2025-05-24T11:21:04.668589+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.77ms"] []
    11. 

  11. [2025-05-24T11:24:04.268335+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.6ms"] []
    12. 

  12. [2025-05-24T11:24:04.270701+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.75ms"] []
    13. 

  13. [2025-05-24T11:24:23.343936+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.38ms"] []
    14. 

  14. [2025-05-24T11:24:23.346245+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.64ms"] []
    15. 

  15. [2025-05-24T11:24:23.347874+08:00] sql.INFO: select * from `kailin_company` where (`status` = 0) ["RunTime:0.72ms"] []
    16. 

  16. [2025-05-24T11:24:23.359802+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:9.75ms"] []
    17. 

  17. [2025-05-24T11:24:33.674801+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:3.04ms"] []
    18. 

  18. [2025-05-24T11:24:33.677316+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.74ms"] []
    19. 

  19. [2025-05-24T11:24:33.679012+08:00] sql.INFO: select * from `kailin_company` where (`status` = 0) ["RunTime:0.8ms"] []
    20. 

  20. [2025-05-24T11:24:33.681810+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:0.69ms"] []
    21. 

  21. [2025-05-24T11:25:09.024418+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:3.05ms"] []
    22. 

  22. [2025-05-24T11:25:09.029081+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:1.97ms"] []
    23. 

  23. [2025-05-24T11:25:52.184138+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.76ms"] []
    24. 

  24. [2025-05-24T11:25:52.185904+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.21ms"] []
    25. 

  25. [2025-05-24T11:27:48.042813+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.05ms"] []
    26. 

  26. [2025-05-24T11:27:48.044739+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.23ms"] []
    27. 

  27. [2025-05-24T11:27:48.046557+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:0.18ms"] []
    28. 

  28. [2025-05-24T11:28:09.210710+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.43ms"] []
    29. 

  29. [2025-05-24T11:28:09.213219+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.67ms"] []
    30. 

  30. [2025-05-24T11:28:09.215602+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:0.66ms"] []
    31. 

  31. [2025-05-24T11:31:12.349577+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.6ms"] []
    32. 

  32. [2025-05-24T11:31:12.352910+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.85ms"] []
    33. 

  33. [2025-05-24T11:31:12.356148+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:1.03ms"] []
    34. 

  34. [2025-05-24T11:31:33.838623+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.21ms"] []
    35. 

  35. [2025-05-24T11:31:33.841449+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.81ms"] []
    36. 

  36. [2025-05-24T11:31:33.843715+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:0.66ms"] []
    37. 

  37. [2025-05-24T11:34:04.792902+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.93ms"] []
    38. 

  38. [2025-05-24T11:34:04.795804+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.33ms"] []
    39. 

  39. [2025-05-24T11:34:04.797706+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:0.2ms"] []
    40. 

  40. [2025-05-24T11:34:26.371506+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.1ms"] []
    41. 

  41. [2025-05-24T11:34:26.373888+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.73ms"] []
    42. 

  42. [2025-05-24T11:52:07.172926+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:3.04ms"] []
    43. 

  43. [2025-05-24T11:52:07.176531+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:1.16ms"] []
    44. 

  44. [2025-05-24T11:52:07.178760+08:00] sql.INFO: select * from `kailin_company` where (`status` = 0) ["RunTime:0.76ms"] []
    45. 

  45. [2025-05-24T11:52:07.182389+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:0.95ms"] []
    46. 

  46. [2025-05-24T11:52:07.217983+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) and `insert_time` between 1748016000 and 1748058727 ["RunTime:33.72ms"] []
    47. 

  47. [2025-05-24T11:52:07.218833+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`company_id` = 1) and `status` = 2 and `insert_time` between 1748016000 and 1748058727 ["RunTime:0.34ms"] []
    48. 

  48. [2025-05-24T12:06:20.425214+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:3.03ms"] []
    49. 

  49. [2025-05-24T12:06:20.427628+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.73ms"] []
    50. 

  50. [2025-05-24T12:06:20.455429+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) and `insert_time` between 1748016000 and 1748059580 ["RunTime:25.5ms"] []
    51. 

  51. [2025-05-24T12:06:20.456359+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`company_id` = 1) and `status` = 2 ["RunTime:0.36ms"] []
    52. 

  52. [2025-05-24T12:06:33.661973+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.23ms"] []
    53. 

  53. [2025-05-24T12:06:33.664690+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.94ms"] []
    54. 

  54. [2025-05-24T12:06:33.678441+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) ["RunTime:11.34ms"] []
    55. 

  55. [2025-05-24T12:06:33.679434+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`company_id` = 1) and `status` = 2 ["RunTime:0.35ms"] []
    56. 

  56. [2025-05-24T12:08:51.827305+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.86ms"] []
    57. 

  57. [2025-05-24T12:08:51.829073+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.19ms"] []
    58. 

  58. [2025-05-24T12:08:51.851186+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) ["RunTime:20.02ms"] []
    59. 

  59. [2025-05-24T12:08:51.851904+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`company_id` = 1) and `status` = 2 ["RunTime:0.24ms"] []
    60. 

  60. [2025-05-24T12:10:24.860716+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.92ms"] []
    61. 

  61. [2025-05-24T12:10:24.862574+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.22ms"] []
    62. 

  62. [2025-05-24T12:10:24.889668+08:00] sql.INFO: select * from `kailin_orders` where (`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) ["RunTime:24.91ms"] []
    63. 

  63. [2025-05-24T12:12:30.512475+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.83ms"] []
    64. 

  64. [2025-05-24T12:12:30.514561+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.26ms"] []
    65. 

  65. [2025-05-24T12:12:30.529146+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) and `insert_time` between 1748016000 and 1748059950 ["RunTime:12.44ms"] []
    66. 

  66. [2025-05-24T12:12:30.530143+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`company_id` = 1) and `status` = 2 and `insert_time` between 1748016000 and 1748059950 ["RunTime:0.36ms"] []
    67. 

  67. [2025-05-24T12:15:14.014540+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.02ms"] []
    68. 

  68. [2025-05-24T12:15:14.016512+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.22ms"] []
    69. 

  69. [2025-05-24T12:15:14.020584+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) ["RunTime:1.83ms"] []
    70. 

  70. [2025-05-24T12:15:14.021273+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`company_id` = 1) and `status` = 2 ["RunTime:0.27ms"] []
    71. 

  71. [2025-05-24T12:15:49.869684+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.11ms"] []
    72. 

  72. [2025-05-24T12:15:49.871959+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.39ms"] []
    73. 

  73. [2025-05-24T12:15:49.888682+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) ["RunTime:14.43ms"] []
    74. 

  74. [2025-05-24T12:15:49.889696+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`company_id` = 1) and `status` = 2 ["RunTime:0.39ms"] []
    75. 

  75. [2025-05-24T12:17:35.174184+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.16ms"] []
    76. 

  76. [2025-05-24T12:17:35.179631+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.67ms"] []
    77. 

  77. [2025-05-24T14:13:39.934856+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.91ms"] []
    78. 

  78. [2025-05-24T14:13:39.937281+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.31ms"] []
    79. 

  79. [2025-05-24T14:13:39.940798+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:1.04ms"] []
    80. 

  80. [2025-05-24T14:14:08.577084+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:4.07ms"] []
    81. 

  81. [2025-05-24T14:14:08.581717+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.76ms"] []
    82. 

  82. [2025-05-24T14:14:55.081631+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.22ms"] []
    83. 

  83. [2025-05-24T14:14:55.083865+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.48ms"] []
    84. 

  84. [2025-05-24T14:16:47.569558+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.44ms"] []
    85. 

  85. [2025-05-24T14:16:47.571464+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.23ms"] []
    86. 

  86. [2025-05-24T14:16:56.066520+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.09ms"] []
    87. 

  87. [2025-05-24T14:16:56.071864+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.8ms"] []
    88. 

  88. [2025-05-24T14:17:09.178089+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.14ms"] []
    89. 

  89. [2025-05-24T14:17:09.180902+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.63ms"] []
    90. 

  90. [2025-05-24T14:17:40.866891+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:3.12ms"] []
    91. 

  91. [2025-05-24T14:17:40.869703+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.96ms"] []
    92. 

  92. [2025-05-24T14:17:56.795317+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.86ms"] []
    93. 

  93. [2025-05-24T14:17:56.797851+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.47ms"] []
    94. 

  94. [2025-05-24T14:18:25.772899+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.4ms"] []
    95. 

  95. [2025-05-24T14:18:25.775170+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.42ms"] []
    96. 

  96. [2025-05-24T14:18:25.788876+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders from `kailin_orders` inner join `kailin_orders_addr` on `kailin_orders`.`id` = `kailin_orders_addr`.`order_id` where (`kailin_orders`.`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) ["RunTime:11.16ms"] []
    97. 

  97. [2025-05-24T14:18:52.338470+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.98ms"] []
    98. 

  98. [2025-05-24T14:18:52.341277+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.42ms"] []
    99. 

  99. [2025-05-24T14:18:52.360452+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders from `kailin_orders` inner join `kailin_orders_addr` on `kailin_orders`.`id` = `kailin_orders_addr`.`order_id` where (`kailin_orders`.`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) group by `kailin_orders_addr`.`contact_province` ["RunTime:14.92ms"] []
    100. 

  100. [2025-05-24T15:33:45.208605+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:5.15ms"] []
    101. 

  101. [2025-05-24T15:33:45.211663+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.94ms"] []
    102. 

  102. [2025-05-24T15:33:45.215091+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:0.92ms"] []
    103. 

  103. [2025-05-24T15:33:45.222389+08:00] sql.INFO: select `kailin_orders`.`shop_id`, SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders from `kailin_orders` inner join `kailin_orders_addr` on `kailin_orders`.`id` = `kailin_orders_addr`.`order_id` where (`kailin_orders`.`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) group by `kailin_orders_addr`.`contact_province` ["RunTime:3.84ms"] []
    104. 

  104. [2025-05-24T15:41:24.528547+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.91ms"] []
    105. 

  105. [2025-05-24T15:41:24.530728+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.39ms"] []
    106. 

  106. [2025-05-24T15:41:24.546186+08:00] sql.INFO: select `kailin_orders`.`shop_id`, SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders from `kailin_orders` inner join `kailin_orders_addr` on `kailin_orders`.`id` = `kailin_orders_addr`.`order_id` where (`kailin_orders`.`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) group by `kailin_orders_addr`.`contact_province` ["RunTime:13.03ms"] []
    107. 

  107. [2025-05-24T15:41:24.556529+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:9.6ms"] []
    108. 

  108. [2025-05-24T15:41:24.559555+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.52ms"] []
    109. 

  109. [2025-05-24T15:41:24.579852+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.57ms"] []
    110. 

  110. [2025-05-24T15:41:24.587537+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.39ms"] []
    111. 

  111. [2025-05-24T15:41:24.595605+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.53ms"] []
    112. 

  112. [2025-05-24T15:41:24.604133+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.52ms"] []
    113. 

  113. [2025-05-24T15:41:24.615545+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.62ms"] []
    114. 

  114. [2025-05-24T15:45:23.240583+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.04ms"] []
    115. 

  115. [2025-05-24T15:45:23.242847+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.31ms"] []
    116. 

  116. [2025-05-24T15:45:23.264447+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders, `kailin_orders_addr`.`contact_province` from `kailin_orders` inner join `kailin_orders_addr` on `kailin_orders`.`id` = `kailin_orders_addr`.`order_id` where (`kailin_orders`.`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) group by `kailin_orders_addr`.`contact_province` ["RunTime:18.89ms"] []
    117. 

  117. [2025-05-24T15:45:44.834275+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.77ms"] []
    118. 

  118. [2025-05-24T15:45:44.836246+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.28ms"] []
    119. 

  119. [2025-05-24T15:45:44.859082+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders, `kailin_orders_addr`.`contact_city` from `kailin_orders` inner join `kailin_orders_addr` on `kailin_orders`.`id` = `kailin_orders_addr`.`order_id` where (`kailin_orders`.`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) group by `kailin_orders_addr`.`contact_city` ["RunTime:20.41ms"] []
    120. 

  120. [2025-05-24T16:10:36.062164+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.33ms"] []
    121. 

  121. [2025-05-24T16:10:36.064971+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.37ms"] []
    122. 

  122. [2025-05-24T16:10:36.091404+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders, `kailin_orders`.`shop_id` from `kailin_orders` inner join `kailin_orders_addr` on `kailin_orders`.`id` = `kailin_orders_addr`.`order_id` where (`kailin_orders`.`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) group by `kailin_orders`.`shop_id` ["RunTime:23.94ms"] []
    123. 

  123. [2025-05-24T16:10:36.093193+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.13ms"] []
    124. 

  124. [2025-05-24T16:10:36.095228+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.27ms"] []
    125. 

  125. [2025-05-24T16:10:44.746181+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.1ms"] []
    126. 

  126. [2025-05-24T16:10:44.748058+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.26ms"] []
    127. 

  127. [2025-05-24T16:11:07.357972+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.04ms"] []
    128. 

  128. [2025-05-24T16:11:07.360361+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.42ms"] []
    129. 

  129. [2025-05-24T16:12:51.453680+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.11ms"] []
    130. 

  130. [2025-05-24T16:12:51.455534+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.22ms"] []
    131. 

  131. [2025-05-24T16:13:50.481283+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.89ms"] []
    132. 

  132. [2025-05-24T16:13:50.483844+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.9ms"] []
    133. 

  133. [2025-05-24T16:13:50.511465+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders, `kailin_orders`.`shop_id` from `kailin_orders` inner join `kailin_orders_addr` on `kailin_orders`.`id` = `kailin_orders_addr`.`order_id` where (`kailin_orders`.`company_id` = 1) and `status` in (2, 3, 5, 6, 7, 8, 9) group by `kailin_orders`.`shop_id` ["RunTime:25.25ms"] []
    134. 

  134. [2025-05-24T16:13:50.513702+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.62ms"] []
    135. 

  135. [2025-05-24T16:13:50.516474+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.46ms"] []
    136. 

  136. [2025-05-24T16:14:18.576885+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.53ms"] []
    137. 

  137. [2025-05-24T16:14:18.579145+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.43ms"] []
    138. 

  138. [2025-05-24T16:20:31.663080+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:4.17ms"] []
    139. 

  139. [2025-05-24T16:20:31.666372+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.54ms"] []
    140. 

  140. [2025-05-24T16:22:56.542162+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.13ms"] []
    141. 

  141. [2025-05-24T16:22:56.544685+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.6ms"] []
    142. 

  142. [2025-05-24T16:22:56.574965+08:00] sql.INFO: select `shop_id`, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) group by `shop_id`, `status` ["RunTime:26.11ms"] []
    143. 

  143. [2025-05-24T16:35:52.999283+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.47ms"] []
    144. 

  144. [2025-05-24T16:35:53.001305+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.24ms"] []
    145. 

  145. [2025-05-24T16:35:53.003958+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:0.31ms"] []
    146. 

  146. [2025-05-24T16:35:53.009073+08:00] sql.INFO: select `status`, `shop_id`, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) group by `shop_id`, `status` ["RunTime:1.39ms"] []
    147. 

  147. [2025-05-24T17:13:19.524995+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:3.27ms"] []
    148. 

  148. [2025-05-24T17:13:19.527350+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.4ms"] []
    149. 

  149. [2025-05-24T17:13:19.529765+08:00] sql.INFO: select * from `kailin_company` where (`status` = 0) ["RunTime:1.29ms"] []
    150. 

  150. [2025-05-24T17:13:19.532695+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:0.29ms"] []
    151. 

  151. [2025-05-24T17:13:19.536325+08:00] sql.INFO: select * from `kailin_shop` where `company_id` = 1 ["RunTime:0.81ms"] []
    152. 

  152. [2025-05-24T17:32:58.563454+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.6ms"] []
    153. 

  153. [2025-05-24T17:32:58.565254+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.22ms"] []
    154. 

  154. [2025-05-24T17:32:58.593087+08:00] sql.INFO: select `status`, `shop_id`, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) group by `shop_id`, `status` ["RunTime:23.95ms"] []
    155. 

  155. [2025-05-24T17:34:14.167684+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.22ms"] []
    156. 

  156. [2025-05-24T17:34:14.169975+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.46ms"] []
    157. 

  157. [2025-05-24T17:34:14.186944+08:00] sql.INFO: select `status`, `shop_id`, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) group by `shop_id`, `status` ["RunTime:12.29ms"] []
    158. 

  158. [2025-05-24T17:35:07.453207+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.13ms"] []
    159. 

  159. [2025-05-24T17:35:07.455621+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.38ms"] []
    160. 

  160. [2025-05-24T17:35:07.483241+08:00] sql.INFO: select `status`, `shop_id`, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) group by `shop_id`, `status` ["RunTime:23.82ms"] []
    161. 

  161. [2025-05-24T17:35:07.484811+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.56ms"] []
    162. 

  162. [2025-05-24T17:35:27.640053+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.39ms"] []
    163. 

  163. [2025-05-24T17:35:27.642246+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.41ms"] []
    164. 

  164. [2025-05-24T17:35:27.662243+08:00] sql.INFO: select `status`, `shop_id`, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) group by `shop_id`, `status` ["RunTime:15.09ms"] []
    165. 

  165. [2025-05-24T17:35:27.663655+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.5ms"] []
    166. 

  166. [2025-05-24T17:47:55.327874+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.41ms"] []
    167. 

  167. [2025-05-24T17:47:55.329871+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.25ms"] []
    168. 

  168. [2025-05-24T17:47:55.347741+08:00] sql.INFO: select `status`, `shop_id`, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) group by `shop_id`, `status` ["RunTime:13.57ms"] []
    169. 

  169. [2025-05-24T17:47:55.349680+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.97ms"] []
    170. 

  170. [2025-05-24T17:49:15.830904+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.12ms"] []
    171. 

  171. [2025-05-24T17:49:15.832985+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.38ms"] []
    172. 

  172. [2025-05-24T17:49:15.838468+08:00] sql.INFO: select `status`, `shop_id`, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) group by `shop_id`, `status` ["RunTime:1.44ms"] []
    173. 

  173. [2025-05-24T17:49:15.840332+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.13ms"] []
    174. 

  174. [2025-05-24T17:49:15.843430+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.46ms"] []
    175. 

  175. [2025-05-24T17:50:21.710743+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.99ms"] []
    176. 

  176. [2025-05-24T17:50:21.712634+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.2ms"] []
    177. 

  177. [2025-05-24T17:50:21.736314+08:00] sql.INFO: select `status`, `shop_id`, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) group by `shop_id`, `status` ["RunTime:19.83ms"] []
    178. 

  178. [2025-05-24T17:50:21.737692+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.4ms"] []
    179. 

  179. [2025-05-24T17:50:21.739250+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.31ms"] []
    180. 

  180. [2025-05-24T17:50:21.750182+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.58ms"] []
    181. 

  181. [2025-05-24T17:50:21.761089+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.63ms"] []
    182. 

  182. [2025-05-24T17:55:39.930056+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:4.77ms"] []
    183. 

  183. [2025-05-24T17:55:39.932367+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.43ms"] []
    184. 

  184. [2025-05-24T17:55:39.947826+08:00] sql.INFO: select count(*) as aggregate from (select `kailin_product`.* from `kailin_product` inner join `kailin_product_city` on `kailin_product_city`.`product_id` = `kailin_product`.`id` where (`status` = 0 and `stock` > 0 and `company_id` = 1) group by `product_id`) as `aggregate_table` ["RunTime:10.89ms"] []
    185. 

  185. [2025-05-24T17:55:39.948858+08:00] sql.INFO: select `kailin_product`.`id`, `kailin_product`.`sort`, `kailin_product`.`name`, `kailin_product`.`tag_scope`, `kailin_product`.`tag_exclude`, `kailin_product`.`thumb`, `kailin_product`.`spec`, `kailin_product`.`price`, `kailin_product`.`market_price`, `kailin_product`.`stock` from `kailin_product` inner join `kailin_product_city` on `kailin_product_city`.`product_id` = `kailin_product`.`id` where (`status` = 0 and `stock` > 0 and `company_id` = 1) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.49ms"] []
    186. 

  186. [2025-05-24T17:56:53.759850+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.43ms"] []
    187. 

  187. [2025-05-24T17:56:53.761836+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.26ms"] []
    188. 

  188. [2025-05-24T17:56:53.787122+08:00] sql.INFO: select `status`, `shop_id`, COUNT(id) as total_orders from `kailin_orders` where (`company_id` = 1) group by `shop_id`, `status` ["RunTime:21.48ms"] []
    189. 

  189. [2025-05-24T17:56:53.789354+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.04ms"] []
    190. 

  190. [2025-05-24T17:56:53.791051+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.32ms"] []
    191. 

  191. [2025-05-24T17:56:53.799726+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.34ms"] []
    192. 

  192. [2025-05-24T17:56:53.808129+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.6ms"] []
    193. 

  193. [2025-05-24T17:58:15.419000+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.2ms"] []
    194. 

  194. [2025-05-24T17:58:15.421334+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.36ms"] []
    195. 

  195. [2025-05-24T17:58:15.448722+08:00] sql.INFO: select `id`, `hide_orderbtn`, `name`, `thumb`, `stock`, `spec`, `poster`, `price`, `shop_id`, `market_price` from `kailin_product` where (`status` = 0) and `kailin_product`.`id` = 116 limit 1 ["RunTime:24.83ms"] []
    196. 

  196. [2025-05-24T17:58:15.453829+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.12ms"] []
    197. 

  197. [2025-05-24T17:58:15.466178+08:00] sql.INFO: select `id`, `sort`, `thumb` from `kailin_product_photo` where (`product_id` = 116) ["RunTime:9.62ms"] []
    198. 

  198. [2025-05-24T17:58:15.474608+08:00] sql.INFO: select `id`, `name`, `spec_id`, `product_id`, `thumb`, `remark` from `kailin_product_attr` where (`product_id` = 116) ["RunTime:7.8ms"] []
    199. 

  199. [2025-05-24T17:58:15.481554+08:00] sql.INFO: select `id`, `name`, `type_id`, `has_img`, `input_type` from `kailin_product_spec` where (`status` = 0 and `shop_id` = 1) ["RunTime:5.94ms"] []
    200. 

  200. [2025-05-24T17:58:15.490576+08:00] sql.INFO: select `id`, `attr_ids`, `attr_names`, `min_quota`, `quota`, `sku_thumb`, `price`, `market_price`, `stock`, `status` from `kailin_product_skus` where (`product_id` = 116) ["RunTime:7.51ms"] []
    201.