collect_schedule/storage/logs/sql/sql-2025-04-13.log

[2025-04-13T09:56:47.967414+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.1ms"] []
[2025-04-13T09:56:48.523580+08:00] sql.INFO: select * from `kailin_admin_shop` where `uid` = 1 limit 1 ["RunTime:0.88ms"] []
[2025-04-13T09:56:48.553931+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:3.49ms"] []
[2025-04-13T17:15:17.959209+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:82.78ms"] []
[2025-04-13T17:15:17.959181+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:82.76ms"] []
[2025-04-13T17:15:18.048185+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.56ms"] []
[2025-04-13T17:15:18.049108+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.48ms"] []
[2025-04-13T17:15:18.083282+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` <= 1744535718 and `kailin_promo`.`end_time` >= 1744535718 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.94ms"] []
[2025-04-13T17:15:18.085095+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744535718 and `end_time` >= 1744535718 and `product_id` = 70) limit 1 ["RunTime:1.2ms"] []
[2025-04-13T17:15:18.085755+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744535718 and `end_time` >= 1744535718 and `product_id` = 71) limit 1 ["RunTime:0.27ms"] []
[2025-04-13T17:15:18.086479+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744535718 and `end_time` >= 1744535718 and `product_id` = 72) limit 1 ["RunTime:0.38ms"] []
[2025-04-13T17:15:18.087186+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744535718 and `end_time` >= 1744535718 and `product_id` = 73) limit 1 ["RunTime:0.37ms"] []
[2025-04-13T17:15:32.747844+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.98ms"] []
[2025-04-13T17:15:39.804611+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.42ms"] []
[2025-04-13T17:15:39.809138+08:00] sql.INFO: select `unionid`, `openid` from `kailin_custom_openid` where (`custom_uid` = 25 and `type` = 0) limit 1 ["RunTime:2.84ms"] []
[2025-04-13T17:15:39.812800+08:00] sql.INFO: select * from `kailin_custom_shop_record` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:2.64ms"] []
[2025-04-13T17:15:39.815546+08:00] sql.INFO: update `kailin_custom_shop_record` set `visit_time` = 1744535739 where (`id` = 1058) ["RunTime:1.71ms"] []
[2025-04-13T17:16:18.582208+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.25ms"] []
[2025-04-13T17:16:18.895252+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.19ms"] []
[2025-04-13T17:16:18.898336+08:00] sql.INFO: select `unionid`, `openid` from `kailin_custom_openid` where (`custom_uid` = 25 and `type` = 0) limit 1 ["RunTime:1.91ms"] []
[2025-04-13T17:16:18.901120+08:00] sql.INFO: select * from `kailin_custom_shop_record` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:1.99ms"] []
[2025-04-13T17:16:18.903499+08:00] sql.INFO: update `kailin_custom_shop_record` set `visit_time` = 1744535778 where (`id` = 1058) ["RunTime:1.71ms"] []
[2025-04-13T17:18:47.208618+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.6ms"] []
[2025-04-13T17:18:47.511312+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.53ms"] []
[2025-04-13T17:18:47.512308+08:00] sql.INFO: select `unionid`, `openid` from `kailin_custom_openid` where (`custom_uid` = 25 and `type` = 0) limit 1 ["RunTime:0.37ms"] []
[2025-04-13T17:24:31.039746+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.5ms"] []
[2025-04-13T17:24:31.417126+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:2.71ms"] []
[2025-04-13T17:24:31.420585+08:00] sql.INFO: select `unionid`, `openid` from `kailin_custom_openid` where (`custom_uid` = 25 and `type` = 0) limit 1 ["RunTime:2.04ms"] []
[2025-04-13T17:24:31.423447+08:00] sql.INFO: select * from `kailin_custom_shop_record` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:1.92ms"] []
[2025-04-13T17:24:31.425972+08:00] sql.INFO: update `kailin_custom_shop_record` set `visit_time` = 1744536271 where (`id` = 1058) ["RunTime:1.56ms"] []
[2025-04-13T17:24:31.427563+08:00] sql.INFO: select `unionid`, `openid` from `kailin_custom_openid` where (`custom_uid` = 25) limit 1 ["RunTime:0.7ms"] []
[2025-04-13T17:24:31.450240+08:00] sql.INFO: select `corpid` from `kailin_openwork_corp_authcorp` where (`company_id` = 1 and `status` = 0) limit 1 ["RunTime:1.1ms"] []