Inicio Explorar Axuda
Rexistro Iniciar sesión
heshengjun
/
collect_schedule
1
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: 294fe12f81
Ramas Etiquetas
collect_schedul...
/
storage
/
logs
/
sql
/
sql-2025-04-11.log

sql-2025-04-11.log 6.7 KB
Histórico Raw

123456789101112131415161718192021222324252627282930 
  1. [2025-04-11T15:09:13.088749+08:00] sql.INFO: select `id`, `pages`, `title`, `image_url`, `path` from `kailin_share_message` where (`status` = 0) ["RunTime:96.98ms"] []
    2. 

  2. [2025-04-11T15:09:13.088769+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:96.75ms"] []
    3. 

  3. [2025-04-11T15:09:13.412896+08:00] sql.INFO: select `id`, `thumb`, `name`, `link_url`, `type`, `start_time`, `end_time`, `city_ids`, `status` from `kailin_banner` where (`status` = 0 and `shop_id` = 1) ["RunTime:4.37ms"] []
    4. 

  4. [2025-04-11T15:09:13.451141+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 `shop_id` = 1) and `kailin_product_city`.`city_id` in (1) group by `product_id`) as `aggregate_table` ["RunTime:2.79ms"] []
    5. 

  5. [2025-04-11T15:09:13.452458+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 `shop_id` = 1) and `kailin_product_city`.`city_id` in (1) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.61ms"] []
    6. 

  6. [2025-04-11T15:09:13.485092+08:00] sql.INFO: select `kailin_promo`.*, `kailin_promo_product`.`product_id`, `kailin_promo_product`.`id` as `promo_product_id` from `kailin_promo_product` inner join `kailin_promo` on `kailin_promo`.`id` = `kailin_promo_product`.`promo_id` where (`kailin_promo`.`status` = 0 and `kailin_promo`.`start_time` <= 1744355353 and `kailin_promo`.`end_time` >= 1744355353 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.89ms"] []
    7. 

  7. [2025-04-11T15:09:13.487025+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744355353 and `end_time` >= 1744355353 and `product_id` = 70) limit 1 ["RunTime:1.29ms"] []
    8. 

  8. [2025-04-11T15:09:13.488020+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744355353 and `end_time` >= 1744355353 and `product_id` = 71) limit 1 ["RunTime:0.59ms"] []
    9. 

  9. [2025-04-11T15:09:13.488714+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744355353 and `end_time` >= 1744355353 and `product_id` = 72) limit 1 ["RunTime:0.31ms"] []
    10. 

  10. [2025-04-11T15:09:13.489330+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744355353 and `end_time` >= 1744355353 and `product_id` = 73) limit 1 ["RunTime:0.22ms"] []
    11. 

  11. [2025-04-11T15:09:24.392569+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:4.19ms"] []
    12. 

  12. [2025-04-11T15:09:30.498618+08:00] sql.INFO: select `uid`, `is_manager`, `external_userid`, `weiban_extid`, `phone`, `userpic`, `username`, `sex`, `city_id`, `status`, `insert_time` from `kailin_custom` where (`phone` = 18819035894) limit 1 ["RunTime:0.93ms"] []
    13. 

  13. [2025-04-11T15:09:30.756214+08:00] sql.INFO: select * from `kailin_custom_openid` where (`openid` = oNEkF7PYFD95LTg-Qeg2bEu_FfWU and `unionid` = oZ2yV5m0YPg150z6D9cGnpvcZBeg) limit 1 ["RunTime:1.39ms"] []
    14. 

  14. [2025-04-11T15:09:30.757669+08:00] sql.INFO: select * from `kailin_custom_shop_record` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:1.01ms"] []
    15. 

  15. [2025-04-11T15:09:30.759152+08:00] sql.INFO: update `kailin_custom_shop_record` set `visit_time` = 1744355370 where (`id` = 1058) ["RunTime:1.09ms"] []
    16. 

  16. [2025-04-11T15:09:31.868367+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:21.43ms"] []
    17. 

  17. [2025-04-11T15:09:31.875434+08:00] sql.INFO: select count(*) as aggregate from `kailin_custom_redpacket` inner join `kailin_redpacket` on `kailin_redpacket`.`id` = `kailin_custom_redpacket`.`redpacket_id` where (`kailin_custom_redpacket`.`custom_uid` = 25 and `kailin_custom_redpacket`.`shop_id` = 1 and `kailin_custom_redpacket`.`company_id` = 1 and `kailin_redpacket`.`start_time` <= 1744355371 and `kailin_redpacket`.`end_time` >= 1744355371 and `kailin_redpacket`.`status` = 0) ["RunTime:2.65ms"] []
    18. 

  18. [2025-04-11T15:09:31.946832+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:17.73ms"] []
    19. 

  19. [2025-04-11T15:09:31.951137+08:00] sql.INFO: select `uid`, `is_manager`, `external_userid`, `weiban_extid`, `phone`, `userpic`, `username`, `sex`, `city_id`, `status`, `insert_time` from `kailin_custom` where (`uid` = 25) limit 1 ["RunTime:1.1ms"] []
    20. 

  20. [2025-04-11T15:09:31.952579+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.96ms"] []
    21. 

  21. [2025-04-11T15:09:31.955292+08:00] sql.INFO: select `id`, `name`, `thumb`, `link_url`, `city_ids`, `status` from `kailin_weiban_qrcode` where (`status` = 0) ["RunTime:0.88ms"] []
    22. 

  22. [2025-04-11T15:09:31.959195+08:00] sql.INFO: select `id`, `name`, `pid` from `kailin_city` where (`status` = 0) ["RunTime:2.83ms"] []
    23. 

  23. [2025-04-11T15:09:31.984928+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:1.29ms"] []
    24. 

  24. [2025-04-11T15:11:38.018333+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:15.07ms"] []
    25. 

  25. [2025-04-11T15:11:38.334093+08:00] sql.INFO: select `uid`, `is_manager`, `external_userid`, `weiban_extid`, `phone`, `userpic`, `username`, `sex`, `city_id`, `status`, `insert_time` from `kailin_custom` where (`phone` = 18819035894) limit 1 ["RunTime:1.02ms"] []
    26. 

  26. [2025-04-11T15:11:38.337675+08:00] sql.INFO: select `unionid`, `openid` from `kailin_custom_openid` where (`custom_uid` = 25 and `type` = 0) limit 1 ["RunTime:2.29ms"] []
    27. 

  27. [2025-04-11T15:11:38.340156+08:00] sql.INFO: select * from `kailin_custom_shop_record` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:1.65ms"] []
    28. 

  28. [2025-04-11T15:11:38.341897+08:00] sql.INFO: update `kailin_custom_shop_record` set `visit_time` = 1744355498 where (`id` = 1058) ["RunTime:1.03ms"] []
    29. 

  29. [2025-04-11T15:11:38.343258+08:00] sql.INFO: select `unionid`, `openid` from `kailin_custom_openid` where (`custom_uid` = 25) limit 1 ["RunTime:0.5ms"] []
    30. 

  30. [2025-04-11T15:11:38.366468+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:1.61ms"] []
    31.