Головна сторінка Огляд Довідка
Реєстрація Увійти
heshengjun
/
collect_schedule
1
0
Відгалуження 0
Файли Проблеми 0 Запити на злиття 0 Wiki
Дерево: 294fe12f81
Гілки Теги
collect_schedul...
/
storage
/
logs
/
sql
/
sql-2025-05-26.log

sql-2025-05-26.log 12 KB
Історія Запис

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 
  1. [2025-05-26T10:48:54.654898+08:00] sql.INFO: select `uid`, `shop_id`, `company_id`, `username`, `phone`, `status`, `password`, `insert_time`, `update_time` from `kailin_admin_shop` where `username` = admin or `phone` = admin limit 1 ["RunTime:116.77ms"] []
    2. 

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

  3. [2025-05-26T10:48:54.711307+08:00] sql.INFO: select `name`, `status` from `kailin_shop` where (`id` = 1) limit 1 ["RunTime:0.34ms"] []
    4. 

  4. [2025-05-26T10:48:54.739621+08:00] sql.INFO: select `company_id`, `shop_id` from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.43ms"] []
    5. 

  5. [2025-05-26T10:48:54.779618+08:00] sql.INFO: select `id`, `title`, `module`, `url`, `icon`, `type`, `pid` from `kailin_menu` where (`module` = shop and `status` = 0) order by `sort_order` asc, `id` asc ["RunTime:8.61ms"] []
    6. 

  6. [2025-05-26T10:48:54.797556+08:00] sql.INFO: select `menu_id` from `kailin_company_category_rule` where (`category_id` = 0) ["RunTime:6.2ms"] []
    7. 

  7. [2025-05-26T10:48:54.798286+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.26ms"] []
    8. 

  8. [2025-05-26T10:49:55.773420+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:4.63ms"] []
    9. 

  9. [2025-05-26T10:49:55.792196+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.59ms"] []
    10. 

  10. [2025-05-26T10:49:55.846670+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:1.22ms"] []
    11. 

  11. [2025-05-26T10:49:55.913393+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 1748188800 and 1748227795 ["RunTime:17.79ms"] []
    12. 

  12. [2025-05-26T10:49:55.914608+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`company_id` = 1) and `status` = 2 and `insert_time` between 1748188800 and 1748227795 ["RunTime:0.54ms"] []
    13. 

  13. [2025-05-26T11:06:21.046213+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:3.53ms"] []
    14. 

  14. [2025-05-26T11:06:21.050023+08:00] sql.INFO: select `name`, `status` from `kailin_company` where (`id` = 1) limit 1 ["RunTime:1.82ms"] []
    15. 

  15. [2025-05-26T11:06:29.360404+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:3.15ms"] []
    16. 

  16. [2025-05-26T11:06:29.363287+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.52ms"] []
    17. 

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

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

  19. [2025-05-26T11:06:56.434312+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.57ms"] []
    20. 

  20. [2025-05-26T11:06:56.437675+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:1.08ms"] []
    21. 

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

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

  23. [2025-05-26T11:08:30.093005+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders, `kailin_orders`.`insert_time` 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 DATE_FORMAT(kailin_orders.insert_time, 'Y-m-d') ["RunTime:21.04ms"] []
    24. 

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

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

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

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

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

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

  30. [2025-05-26T11:31:49.803380+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.1ms"] []
    31. 

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

  32. [2025-05-26T11:32:38.324440+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.64ms"] []
    33. 

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

  34. [2025-05-26T11:39:31.796484+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:3.7ms"] []
    35. 

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

  36. [2025-05-26T11:39:53.225289+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.68ms"] []
    37. 

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

  38. [2025-05-26T11:40:14.654272+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.69ms"] []
    39. 

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

  40. [2025-05-26T11:40:14.673742+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders, `kailin_orders`.`insert_time`, DATE_FORMAT(kailin_orders.insert_time,"Y-m-d") as data 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 `data` ["RunTime:15.32ms"] []
    41. 

  41. [2025-05-26T11:40:43.364764+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.69ms"] []
    42. 

  42. [2025-05-26T11:40:43.366754+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.28ms"] []
    43. 

  43. [2025-05-26T11:40:43.398856+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders, `kailin_orders`.`insert_time`, DATE_FORMAT(kailin_orders.insert_time,"Y-m-d") as data 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 `data` ["RunTime:29.57ms"] []
    44. 

  44. [2025-05-26T11:48:41.848822+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.32ms"] []
    45. 

  45. [2025-05-26T11:48:41.851039+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.34ms"] []
    46. 

  46. [2025-05-26T11:48:41.878289+08:00] sql.INFO: select SUM(pay_total) as total_sales, COUNT(kailin_orders.id) as total_orders, `kailin_orders`.`insert_time`, FROM_UNIXTIME(kailin_orders.insert_time,"Y-m-d") as data 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 `data` ["RunTime:24.5ms"] []
    47. 

  47. [2025-05-26T11:50:15.336555+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.05ms"] []
    48. 

  48. [2025-05-26T11:50:15.338788+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.32ms"] []
    49. 

  49. [2025-05-26T11:50:15.342254+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:1ms"] []
    50. 

  50. [2025-05-26T12:09:52.412933+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.17ms"] []
    51. 

  51. [2025-05-26T12:09:52.414844+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.28ms"] []
    52. 

  52. [2025-05-26T12:09:52.436164+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:16.92ms"] []
    53. 

  53. [2025-05-26T12:09:52.438000+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.78ms"] []
    54. 

  54. [2025-05-26T12:09:52.439931+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.37ms"] []
    55. 

  55. [2025-05-26T12:09:52.452548+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.61ms"] []
    56. 

  56. [2025-05-26T12:09:52.460245+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.5ms"] []
    57. 

  57. [2025-05-26T18:33:20.988640+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.93ms"] []
    58. 

  58. [2025-05-26T18:33:20.990680+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.31ms"] []
    59. 

  59. [2025-05-26T18:33:20.994277+08:00] sql.INFO: select * from `kailin_company_db_config` where `company_id` = 1 limit 1 ["RunTime:1.01ms"] []
    60. 

  60. [2025-05-26T18:33:37.168655+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.65ms"] []
    61. 

  61. [2025-05-26T18:33:37.170865+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.33ms"] []
    62. 

  62. [2025-05-26T18:34:37.214097+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.1ms"] []
    63. 

  63. [2025-05-26T18:34:37.216273+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.31ms"] []
    64. 

  64. [2025-05-26T18:35:15.059582+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.94ms"] []
    65. 

  65. [2025-05-26T18:35:15.061475+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.29ms"] []
    66. 

  66. [2025-05-26T18:35:23.687602+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.34ms"] []
    67. 

  67. [2025-05-26T18:35:23.689703+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.39ms"] []
    68. 

  68. [2025-05-26T18:35:59.120559+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.02ms"] []
    69. 

  69. [2025-05-26T18:35:59.122489+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.3ms"] []
    70. 

  70. [2025-05-26T18:36:05.240200+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:1.94ms"] []
    71. 

  71. [2025-05-26T18:36:05.242158+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.29ms"] []
    72. 

  72. [2025-05-26T18:36:20.981393+08:00] sql.INFO: select * from `kailin_admin_company` where `uid` = 1 limit 1 ["RunTime:2.31ms"] []
    73. 

  73. [2025-05-26T18:36:20.983416+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:0.36ms"] []
    74.