Home Explore Help
Register Sign In
heshengjun
/
collect_schedule
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 294fe12f81
Branches Tags
collect_schedul...
/
storage
/
logs
/
sql
/
sql-2025-04-07.log

sql-2025-04-07.log 8.7 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 
  1. [2025-04-07T11:26:13.181280+08:00] sql.INFO: select `uid`, `username`, `phone`, `status`, `password`, `insert_time`, `update_time` from `kailin_admin_shop` where `username` = admin or `phone` = admin limit 1 ["RunTime:105.53ms"] []
    2. 

  2. [2025-04-07T11:26:13.259448+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.57ms"] []
    3. 

  3. [2025-04-07T11:26:13.277396+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:2.99ms"] []
    4. 

  4. [2025-04-07T11:26:27.467350+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:22.92ms"] []
    5. 

  5. [2025-04-07T11:26:27.470917+08:00] sql.INFO: select `company_id`, `shop_id` from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.23ms"] []
    6. 

  6. [2025-04-07T11:45:00.802747+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:15.09ms"] []
    7. 

  7. [2025-04-07T11:45:01.032216+08:00] sql.INFO: select `company_id`, `shop_id` from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.69ms"] []
    8. 

  8. [2025-04-07T11:45:01.033974+08:00] sql.INFO: select * from `kailin_live_lucky_bag` where (`id` = 1) limit 1 ["RunTime:1.24ms"] []
    9. 

  9. [2025-04-07T11:45:01.035369+08:00] sql.INFO: select `id`, `lucky_bag_id`, `custom_id`, `company_id`, `shop_id`, `live_id` from `kailin_live_lucky_bag_participate` where (`lucky_bag_id` = 1) ["RunTime:0.93ms"] []
    10. 

  10. [2025-04-07T11:45:12.213158+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:24.59ms"] []
    11. 

  11. [2025-04-07T11:45:12.216505+08:00] sql.INFO: select `company_id`, `shop_id` from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.25ms"] []
    12. 

  12. [2025-04-07T11:45:12.217604+08:00] sql.INFO: select * from `kailin_live_lucky_bag` where (`id` = 1) limit 1 ["RunTime:0.71ms"] []
    13. 

  13. [2025-04-07T11:45:12.218687+08:00] sql.INFO: select `id`, `lucky_bag_id`, `custom_id`, `company_id`, `shop_id`, `live_id` from `kailin_live_lucky_bag_participate` where (`lucky_bag_id` = 1) ["RunTime:0.7ms"] []
    14. 

  14. [2025-04-07T11:52:29.084325+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:76.71ms"] []
    15. 

  15. [2025-04-07T11:52:29.237032+08:00] sql.INFO: select `company_id`, `shop_id` from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.5ms"] []
    16. 

  16. [2025-04-07T11:52:29.238490+08:00] sql.INFO: select * from `kailin_live_lucky_bag` where (`id` = 1) limit 1 ["RunTime:0.98ms"] []
    17. 

  17. [2025-04-07T11:52:29.239724+08:00] sql.INFO: select `id`, `lucky_bag_id`, `custom_id`, `company_id`, `shop_id`, `live_id` from `kailin_live_lucky_bag_participate` where (`lucky_bag_id` = 1) ["RunTime:0.86ms"] []
    18. 

  18. [2025-04-07T11:53:27.222194+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:17.65ms"] []
    19. 

  19. [2025-04-07T11:53:27.226387+08:00] sql.INFO: select `company_id`, `shop_id` from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.29ms"] []
    20. 

  20. [2025-04-07T11:53:27.227440+08:00] sql.INFO: select * from `kailin_live_lucky_bag` where (`id` = 1) limit 1 ["RunTime:0.67ms"] []
    21. 

  21. [2025-04-07T11:53:27.228356+08:00] sql.INFO: select `id`, `lucky_bag_id`, `custom_id`, `company_id`, `shop_id`, `live_id` from `kailin_live_lucky_bag_participate` where (`lucky_bag_id` = 1) ["RunTime:0.59ms"] []
    22. 

  22. [2025-04-07T11:54:20.716433+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:19.24ms"] []
    23. 

  23. [2025-04-07T11:54:20.720722+08:00] sql.INFO: select `company_id`, `shop_id` from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.45ms"] []
    24. 

  24. [2025-04-07T11:54:20.722371+08:00] sql.INFO: select * from `kailin_live_lucky_bag` where (`id` = 1) limit 1 ["RunTime:1.09ms"] []
    25. 

  25. [2025-04-07T11:54:20.723921+08:00] sql.INFO: select `id`, `lucky_bag_id`, `custom_id`, `company_id`, `shop_id`, `live_id` from `kailin_live_lucky_bag_participate` where (`lucky_bag_id` = 1) ["RunTime:1.04ms"] []
    26. 

  26. [2025-04-07T12:04:45.105801+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:2.65ms"] []
    27. 

  27. [2025-04-07T12:04:45.109467+08:00] sql.INFO: select `company_id`, `shop_id` from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.32ms"] []
    28. 

  28. [2025-04-07T12:04:45.110559+08:00] sql.INFO: select * from `kailin_live_lucky_bag` where (`id` = 1) limit 1 ["RunTime:0.73ms"] []
    29. 

  29. [2025-04-07T12:04:45.111460+08:00] sql.INFO: select `id`, `lucky_bag_id`, `custom_id`, `company_id`, `shop_id`, `live_id` from `kailin_live_lucky_bag_participate` where (`lucky_bag_id` = 1) ["RunTime:0.59ms"] []
    30. 

  30. [2025-04-07T12:20:09.094496+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:2.15ms"] []
    31. 

  31. [2025-04-07T12:20:09.098037+08:00] sql.INFO: select `company_id`, `shop_id` from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.21ms"] []
    32. 

  32. [2025-04-07T12:20:09.099136+08:00] sql.INFO: select * from `kailin_live_lucky_bag` where (`id` = 1) limit 1 ["RunTime:0.78ms"] []
    33. 

  33. [2025-04-07T12:20:09.100008+08:00] sql.INFO: select `id`, `lucky_bag_id`, `custom_id`, `company_id`, `shop_id`, `live_id` from `kailin_live_lucky_bag_participate` where (`lucky_bag_id` = 1) ["RunTime:0.57ms"] []
    34. 

  34. [2025-04-07T12:20:09.135862+08:00] sql.INFO: select `score`, `use_score` from `kailin_custom_score` where (`custom_uid` = 1) limit 1 ["RunTime:1.42ms"] []
    35. 

  35. [2025-04-07T12:20:09.210557+08:00] sql.INFO: update `kailin_custom_score` set `score` = score+1, `update_time` = 1743999609 where (`custom_uid` = 1) ["RunTime:1.81ms"] []
    36. 

  36. [2025-04-07T12:20:09.225506+08:00] sql.INFO: insert into `kailin_score_record` (`custom_uid`, `order_id`, `status`, `score`, `balance`, `buy_type`, `description`, `pay_type`, `pay_time`, `insert_time`, `update_time`) values (1, 1, 1, 1, 1, 10, 直播福袋, 1, 1743999609, 1743999609, 1743999609) ["RunTime:1.76ms"] []
    37. 

  37. [2025-04-07T12:20:09.226324+08:00] sql.INFO: select `score`, `use_score` from `kailin_custom_score` where (`custom_uid` = 2) limit 1 ["RunTime:0.22ms"] []
    38. 

  38. [2025-04-07T12:20:09.228067+08:00] sql.INFO: update `kailin_custom_score` set `score` = score+1, `update_time` = 1743999609 where (`custom_uid` = 2) ["RunTime:0.69ms"] []
    39. 

  39. [2025-04-07T12:20:09.234187+08:00] sql.INFO: insert into `kailin_score_record` (`custom_uid`, `order_id`, `status`, `score`, `balance`, `buy_type`, `description`, `pay_type`, `pay_time`, `insert_time`, `update_time`) values (2, 1, 1, 1, 51, 10, 直播福袋, 1, 1743999609, 1743999609, 1743999609) ["RunTime:0.73ms"] []
    40. 

  40. [2025-04-07T12:20:09.235841+08:00] sql.INFO: insert into `kailin_live_lucky_bag_winning` (`company_id`, `custom_id`, `insert_time`, `live_id`, `lucky_bag_id`, `participate_id`, `prize`, `prize_type`, `shop_id`, `update_time`) values (1, 1, 1743999609, 1, 1, 1, 1, 1, 1, 1743999609), (1, 2, 1743999609, 1, 1, 2, 1, 1, 1, 1743999609) ["RunTime:1.11ms"] []
    41. 

  41. [2025-04-07T12:20:09.237058+08:00] sql.INFO: update `kailin_live_lucky_bag` set `is_winning` = 1, `sperform_status` = 3 where (`id` = 1) ["RunTime:0.91ms"] []
    42. 

  42. [2025-04-07T14:11:06.751843+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:2.14ms"] []
    43. 

  43. [2025-04-07T14:11:06.755488+08:00] sql.INFO: select `company_id`, `shop_id` from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.24ms"] []
    44. 

  44. [2025-04-07T14:11:06.755984+08:00] sql.INFO: select * from `kailin_live_lucky_bag` where (`id` = 1) limit 1 ["RunTime:0.17ms"] []
    45. 

  45. [2025-04-07T14:11:06.756714+08:00] sql.INFO: select `id`, `lucky_bag_id`, `custom_id`, `company_id`, `shop_id`, `live_id`, `prize_type`, `prize` from `kailin_live_lucky_bag_participate` where (`lucky_bag_id` = 1) ["RunTime:0.38ms"] []
    46. 

  46. [2025-04-07T14:11:06.798665+08:00] sql.INFO: select `score`, `use_score` from `kailin_custom_score` where (`custom_uid` = 1) limit 1 ["RunTime:1.08ms"] []
    47. 

  47. [2025-04-07T14:11:06.801113+08:00] sql.INFO: update `kailin_custom_score` set `score` = score+5, `update_time` = 1744006266 where (`custom_uid` = 1) ["RunTime:0.36ms"] []
    48. 

  48. [2025-04-07T14:11:06.807759+08:00] sql.INFO: insert into `kailin_score_record` (`custom_uid`, `order_id`, `status`, `score`, `balance`, `buy_type`, `description`, `pay_type`, `pay_time`, `insert_time`, `update_time`) values (1, 1, 1, 5, 6, 10, 直播福袋, 1, 1744006266, 1744006266, 1744006266) ["RunTime:0.93ms"] []
    49. 

  49. [2025-04-07T14:11:06.809086+08:00] sql.INFO: select `score`, `use_score` from `kailin_custom_score` where (`custom_uid` = 2) limit 1 ["RunTime:0.42ms"] []
    50. 

  50. [2025-04-07T14:11:06.810081+08:00] sql.INFO: update `kailin_custom_score` set `score` = score+5, `update_time` = 1744006266 where (`custom_uid` = 2) ["RunTime:0.17ms"] []
    51. 

  51. [2025-04-07T14:11:06.810673+08:00] sql.INFO: insert into `kailin_score_record` (`custom_uid`, `order_id`, `status`, `score`, `balance`, `buy_type`, `description`, `pay_type`, `pay_time`, `insert_time`, `update_time`) values (2, 1, 1, 5, 56, 10, 直播福袋, 1, 1744006266, 1744006266, 1744006266) ["RunTime:0.14ms"] []
    52.