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

[2025-04-09T12:36:46.012886+08:00] sql.INFO: select `id`, `pages`, `title`, `image_url`, `path` from `kailin_share_message` where (`status` = 0) ["RunTime:126.78ms"] []
insert_time` from `kailin_custom` where (`uid` = 25) limit 1 ["RunTime:126.68ms"] []
[2025-04-09T12:36:46.072975+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` = 0) ["RunTime:1.08ms"] []
[2025-04-09T12:36:46.098372+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 `kailin_product_city`.`city_id` in (1) group by `product_id`) as `aggregate_table` ["RunTime:2.95ms"] []
[2025-04-09T12:36:46.131285+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` <= 1744173406 and `kailin_promo`.`end_time` >= 1744173406 and `kailin_promo_product`.`status` = 0) and 0 = 1 ["RunTime:1.65ms"] []
[2025-04-09T14:03:11.801171+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:89.2ms"] []
[2025-04-09T14:03:11.801506+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:89.11ms"] []
[2025-04-09T14:03:11.801591+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:89.07ms"] []
[2025-04-09T14:03:11.801563+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:89.1ms"] []
[2025-04-09T14:03:11.830004+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` = 0) ["RunTime:1.44ms"] []
[2025-04-09T14:03:11.830208+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` = 0) ["RunTime:1.71ms"] []
[2025-04-09T14:03:11.851954+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 `kailin_product_city`.`city_id` in (1) group by `product_id`) as `aggregate_table` ["RunTime:2.05ms"] []
[2025-04-09T14:03:11.852043+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 `kailin_product_city`.`city_id` in (1) group by `product_id`) as `aggregate_table` ["RunTime:2.16ms"] []
[2025-04-09T14:03:11.883076+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` <= 1744178591 and `kailin_promo`.`end_time` >= 1744178591 and `kailin_promo_product`.`status` = 0) and 0 = 1 ["RunTime:2.12ms"] []
[2025-04-09T14:03:33.329690+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:27.67ms"] []
[2025-04-09T14:03:33.333314+08:00] sql.INFO: insert into `kailin_custom` (`phone`, `username`, `insert_time`, `update_time`) values (18819035894, 188****5894, 1744178613, 1744178613) ["RunTime:1.17ms"] []
[2025-04-09T14:03:33.559657+08:00] sql.INFO: select * from `kailin_custom_openid` where (`openid` = oNEkF7PYFD95LTg-Qeg2bEu_FfWU and `unionid` = oZ2yV5m0YPg150z6D9cGnpvcZBeg) limit 1 ["RunTime:2.76ms"] []
[2025-04-09T14:03:33.562006+08:00] sql.INFO: insert into `kailin_custom_openid` (`openid`, `unionid`, `custom_uid`, `insert_time`, `update_time`) values (oNEkF7PYFD95LTg-Qeg2bEu_FfWU, oZ2yV5m0YPg150z6D9cGnpvcZBeg, 3, 1744178613, 1744178613) ["RunTime:1.4ms"] []
[2025-04-09T14:03:33.565170+08:00] sql.INFO: select * from `kailin_custom_shop_record` where (`custom_uid` = 3) order by `visit_time` desc limit 1 ["RunTime:2.33ms"] []
[2025-04-09T14:03:33.567403+08:00] sql.INFO: insert into `kailin_custom_shop_record` (`custom_uid`, `shop_id`, `company_id`, `visit_time`, `insert_time`, `update_time`) values (3, 1, 1, 1744178613, 1744178613, 1744178613) ["RunTime:1.28ms"] []
[2025-04-09T14:03:34.310727+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` = 3) limit 1 ["RunTime:15.19ms"] []
[2025-04-09T14:03:34.311771+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` = 3 and `kailin_redpacket`.`start_time` <= 1744178614 and `kailin_redpacket`.`end_time` >= 1744178614 and `kailin_redpacket`.`status` = 0) ["RunTime:27.03ms"] []
[2025-04-09T14:04:56.427113+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` = 3) limit 1 ["RunTime:22.19ms"] []
[2025-04-09T14:04:56.427257+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` = 3) limit 1 ["RunTime:26.29ms"] []
[2025-04-09T14:04:56.431744+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` = 0) ["RunTime:1.15ms"] []
[2025-04-09T14:04:56.431847+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 `kailin_product_city`.`city_id` in (1) group by `product_id`) as `aggregate_table` ["RunTime:1.78ms"] []
[2025-04-09T14:04:56.435561+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` <= 1744178696 and `kailin_promo`.`end_time` >= 1744178696 and `kailin_promo_product`.`status` = 0) and 0 = 1 ["RunTime:2.21ms"] []
[2025-04-09T17:02:19.856066+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` = 3) limit 1 ["RunTime:7.24ms"] []
[2025-04-09T17:02:19.858647+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.55ms"] []
[2025-04-09T17:02:19.864446+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:3.28ms"] []
[2025-04-09T17:02:19.868174+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` <= 1744189339 and `kailin_promo`.`end_time` >= 1744189339 and `kailin_promo_product`.`status` = 0) and 0 = 1 ["RunTime:1.6ms"] []
[2025-04-09T17:02:19.943809+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.44ms"] []
[2025-04-09T17:02:19.948889+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` = 3) limit 1 ["RunTime:1.31ms"] []
[2025-04-09T17:02:19.973676+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:1.32ms"] []
[2025-04-09T17:02:47.567993+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` = 3) limit 1 ["RunTime:2.16ms"] []
[2025-04-09T17:02:47.574341+08:00] sql.INFO: select `id`, `name`, `pid` from `kailin_city` where (`status` = 0) ["RunTime:4.33ms"] []
[2025-04-09T17:02:55.767722+08:00] sql.INFO: select `id` from `kailin_city` where (`name` = 北京市) limit 1 ["RunTime:21.63ms"] []
[2025-04-09T17:02:55.770179+08:00] sql.INFO: update `kailin_custom` set `city_id` = 1101, `update_time` = 1744189375 where (`uid` = 3) ["RunTime:0.85ms"] []
[2025-04-09T17:02:56.135504+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:13.21ms"] []
[2025-04-09T17:02:56.152728+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:5.27ms"] []
[2025-04-09T17:02:56.157711+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` = 3) limit 1 ["RunTime:0.76ms"] []
[2025-04-09T17:02:59.648588+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:27.84ms"] []
[2025-04-09T17:02:59.651593+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` = 3) limit 1 ["RunTime:0.41ms"] []
[2025-04-09T17:02:59.653374+08:00] sql.INFO: select `id` from `kailin_orders` where (`custom_uid` = 3 and `status` = 1 and `insert_time` >= 1739520742 and `insert_time` <= 1740039148) limit 1 ["RunTime:0.98ms"] []
[2025-04-09T17:02:59.662823+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` = 3) limit 1 ["RunTime:26.05ms"] []
[2025-04-09T17:02:59.666005+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.79ms"] []
[2025-04-09T17:02:59.669449+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, 1101) group by `product_id`) as `aggregate_table` ["RunTime:1.61ms"] []
[2025-04-09T17:02:59.670896+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` <= 1744189379 and `kailin_promo`.`end_time` >= 1744189379 and `kailin_promo_product`.`status` = 0) and 0 = 1 ["RunTime:0.28ms"] []
[2025-04-09T17:03:01.781876+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` = 3) limit 1 ["RunTime:11.4ms"] []
[2025-04-09T17:03:15.335348+08:00] sql.INFO: select `id` from `kailin_city` where (`name` = 唐山市) limit 1 ["RunTime:23.81ms"] []
[2025-04-09T17:03:15.342560+08:00] sql.INFO: update `kailin_custom` set `city_id` = 1302, `update_time` = 1744189395 where (`uid` = 3) ["RunTime:3.76ms"] []
[2025-04-09T17:03:15.527663+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:21.33ms"] []
[2025-04-09T17:03:15.544073+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:24.69ms"] []
[2025-04-09T17:03:15.547723+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` = 3) limit 1 ["RunTime:1.06ms"] []
[2025-04-09T17:03:37.084872+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:26.42ms"] []
`userpic`, `username`, `sex`, `city_id`, `status`, `insert_time` from `kailin_custom` where (`uid` = 3) limit 1 ["RunTime:22.64ms"] []
[2025-04-09T17:03:37.087703+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.93ms"] []
[2025-04-09T17:03:37.088014+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` = 3) limit 1 ["RunTime:0.71ms"] []
[2025-04-09T17:03:37.090770+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.62ms"] []
[2025-04-09T17:03:37.092685+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` <= 1744189417 and `kailin_promo`.`end_time` >= 1744189417 and `kailin_promo_product`.`status` = 0) and 0 = 1 ["RunTime:0.96ms"] []
[2025-04-09T17:07:03.880453+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` = 3) limit 1 ["RunTime:25.84ms"] []
[2025-04-09T17:07:07.426111+08:00] sql.INFO: select `id` from `kailin_city` where (`name` = 唐山市) limit 1 ["RunTime:5.42ms"] []
[2025-04-09T17:07:07.430455+08:00] sql.INFO: update `kailin_custom` set `city_id` = 1302, `update_time` = 1744189627 where (`uid` = 3) ["RunTime:1.3ms"] []
[2025-04-09T17:07:07.672400+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:14.94ms"] []
[2025-04-09T17:07:07.672865+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:15.67ms"] []
[2025-04-09T17:07:07.675686+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` = 3) limit 1 ["RunTime:0.32ms"] []
[2025-04-09T17:07:07.676832+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.64ms"] []
[2025-04-09T17:07:07.680600+08:00] sql.INFO: select `id`, `name`, `thumb`, `link_url`, `city_ids`, `status` from `kailin_weiban_qrcode` where (`status` = 0) ["RunTime:1.06ms"] []
[2025-04-09T17:07:30.855445+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:12.29ms"] []
[2025-04-09T17:07:30.858309+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` = 3) limit 1 ["RunTime:0.23ms"] []
[2025-04-09T17:07:30.870763+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` = 3) limit 1 ["RunTime:21.62ms"] []
[2025-04-09T17:07:30.873182+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.33ms"] []
[2025-04-09T17:07:30.875429+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:0.47ms"] []
[2025-04-09T17:07:30.877054+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` <= 1744189650 and `kailin_promo`.`end_time` >= 1744189650 and `kailin_promo_product`.`status` = 0) and 0 = 1 ["RunTime:0.33ms"] []
[2025-04-09T17:07:30.879363+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:1.78ms"] []
[2025-04-09T17:13:08.240916+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.54ms"] []
[2025-04-09T17:13:08.243314+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` = 3) limit 1 ["RunTime:2.18ms"] []
[2025-04-09T17:13:08.244592+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` = 3) limit 1 ["RunTime:0.82ms"] []
[2025-04-09T17:13:08.246817+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.04ms"] []
[2025-04-09T17:13:08.255932+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.65ms"] []
[2025-04-09T17:13:08.256847+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.44ms"] []
[2025-04-09T17:13:08.259756+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` <= 1744189988 and `kailin_promo`.`end_time` >= 1744189988 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.41ms"] []
[2025-04-09T17:13:08.262021+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:1.42ms"] []
[2025-04-09T17:13:08.263928+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744189988 and `end_time` >= 1744189988 and `product_id` = 70) limit 1 ["RunTime:1.18ms"] []
[2025-04-09T17:13:08.265171+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744189988 and `end_time` >= 1744189988 and `product_id` = 71) limit 1 ["RunTime:0.28ms"] []
[2025-04-09T17:13:08.265785+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744189988 and `end_time` >= 1744189988 and `product_id` = 72) limit 1 ["RunTime:0.23ms"] []
[2025-04-09T17:13:08.266314+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744189988 and `end_time` >= 1744189988 and `product_id` = 73) limit 1 ["RunTime:0.19ms"] []
[2025-04-09T17:13:10.547972+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` = 3) limit 1 ["RunTime:3.16ms"] []
[2025-04-09T17:13:13.056753+08:00] sql.INFO: select `id` from `kailin_city` where (`name` = 唐山市) limit 1 ["RunTime:29.98ms"] []
[2025-04-09T17:13:13.064126+08:00] sql.INFO: update `kailin_custom` set `city_id` = 1302, `update_time` = 1744189993 where (`uid` = 3) ["RunTime:3.27ms"] []
[2025-04-09T17:13:13.281589+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.65ms"] []
[2025-04-09T17:13:13.286467+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` = 3 and `kailin_custom_redpacket`.`shop_id` = 1 and `kailin_custom_redpacket`.`company_id` = 1 and `kailin_redpacket`.`start_time` <= 1744189993 and `kailin_redpacket`.`end_time` >= 1744189993 and `kailin_redpacket`.`status` = 0) ["RunTime:1.71ms"] []
[2025-04-09T17:13:13.300810+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:27.73ms"] []
[2025-04-09T17:13:13.306529+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` = 3) limit 1 ["RunTime:1.7ms"] []
[2025-04-09T17:13:13.308305+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18054576631) limit 1 ["RunTime:0.89ms"] []
[2025-04-09T17:13:13.312017+08:00] sql.INFO: select `id`, `name`, `thumb`, `link_url`, `city_ids`, `status` from `kailin_weiban_qrcode` where (`status` = 0) ["RunTime:1.02ms"] []
[2025-04-09T17:13:13.316421+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 3 and `shop_id` = 1) limit 1 ["RunTime:1.32ms"] []
[2025-04-09T17:13:16.885682+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` = 3) limit 1 ["RunTime:14.11ms"] []
[2025-04-09T17:13:16.885780+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:17.51ms"] []
[2025-04-09T17:13:16.888202+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.79ms"] []
[2025-04-09T17:13:16.889221+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` = 3) limit 1 ["RunTime:0.96ms"] []
[2025-04-09T17:13:16.908277+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.51ms"] []
[2025-04-09T17:13:16.909227+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.47ms"] []
[2025-04-09T17:13:16.911902+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` <= 1744189996 and `kailin_promo`.`end_time` >= 1744189996 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.37ms"] []
[2025-04-09T17:13:16.913560+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:1.02ms"] []
[2025-04-09T17:13:16.915538+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744189996 and `end_time` >= 1744189996 and `product_id` = 70) limit 1 ["RunTime:1.2ms"] []
[2025-04-09T17:13:16.916226+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744189996 and `end_time` >= 1744189996 and `product_id` = 71) limit 1 ["RunTime:0.23ms"] []
[2025-04-09T17:13:16.916982+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744189996 and `end_time` >= 1744189996 and `product_id` = 72) limit 1 ["RunTime:0.3ms"] []
[2025-04-09T17:13:16.917515+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744189996 and `end_time` >= 1744189996 and `product_id` = 73) limit 1 ["RunTime:0.14ms"] []
[2025-04-09T17:13:20.541077+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:18.59ms"] []
[2025-04-09T17:13:20.546319+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` = 3 and `kailin_custom_redpacket`.`shop_id` = 1 and `kailin_custom_redpacket`.`company_id` = 1 and `kailin_redpacket`.`start_time` <= 1744190000 and `kailin_redpacket`.`end_time` >= 1744190000 and `kailin_redpacket`.`status` = 0) ["RunTime:1.36ms"] []
[2025-04-09T17:13:20.548304+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.39ms"] []
[2025-04-09T17:13:20.554737+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` = 3) limit 1 ["RunTime:0.84ms"] []
[2025-04-09T17:13:20.556070+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18054576631) limit 1 ["RunTime:0.76ms"] []
[2025-04-09T17:13:20.560053+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 3 and `shop_id` = 1) limit 1 ["RunTime:0.88ms"] []
[2025-04-09T17:13:22.720948+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:19.81ms"] []
[2025-04-09T17:13:22.724282+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` = 3) limit 1 ["RunTime:0.66ms"] []
[2025-04-09T17:13:22.737242+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` = 3) limit 1 ["RunTime:20.77ms"] []
[2025-04-09T17:13:22.740482+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.96ms"] []
[2025-04-09T17:13:22.743986+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.46ms"] []
[2025-04-09T17:13:22.745181+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.63ms"] []
[2025-04-09T17:13:22.748902+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` <= 1744190002 and `kailin_promo`.`end_time` >= 1744190002 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.75ms"] []
[2025-04-09T17:13:22.750718+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:1.11ms"] []
[2025-04-09T17:13:22.752272+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190002 and `end_time` >= 1744190002 and `product_id` = 70) limit 1 ["RunTime:0.82ms"] []
[2025-04-09T17:13:22.753644+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190002 and `end_time` >= 1744190002 and `product_id` = 71) limit 1 ["RunTime:0.49ms"] []
[2025-04-09T17:13:22.755033+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190002 and `end_time` >= 1744190002 and `product_id` = 72) limit 1 ["RunTime:0.53ms"] []
[2025-04-09T17:13:22.756348+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190002 and `end_time` >= 1744190002 and `product_id` = 73) limit 1 ["RunTime:0.59ms"] []
[2025-04-09T17:13:28.407989+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.07ms"] []
[2025-04-09T17:13:28.412126+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` = 3) limit 1 ["RunTime:1.59ms"] []
[2025-04-09T17:13:28.413527+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18054576631) limit 1 ["RunTime:0.83ms"] []
[2025-04-09T17:13:28.418839+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 3 and `shop_id` = 1) limit 1 ["RunTime:1.12ms"] []
[2025-04-09T17:13:28.572321+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` = 3) limit 1 ["RunTime:21.35ms"] []
[2025-04-09T17:13:28.575102+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` = 70 limit 1 ["RunTime:1.07ms"] []
[2025-04-09T17:13:28.576843+08:00] sql.INFO: select `city_id` from `kailin_product_city` where (`product_id` = 70) ["RunTime:1.17ms"] []
[2025-04-09T17:13:28.580811+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.93ms"] []
[2025-04-09T17:13:28.586509+08:00] sql.INFO: select `id`, `sort`, `thumb` from `kailin_product_photo` where (`product_id` = 70) ["RunTime:2.33ms"] []
[2025-04-09T17:13:28.589966+08:00] sql.INFO: select `id`, `name`, `spec_id`, `product_id`, `thumb`, `remark` from `kailin_product_attr` where (`product_id` = 70) ["RunTime:2.27ms"] []
[2025-04-09T17:13:28.591355+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` = 70) ["RunTime:0.69ms"] []
[2025-04-09T17:13:28.592356+08:00] sql.INFO: select * from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190008 and `end_time` >= 1744190008 and `product_id` = 70) limit 1 ["RunTime:0.63ms"] []
[2025-04-09T17:13:28.592803+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.15ms"] []
[2025-04-09T17:13:28.594357+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` <= 1744190008 and `kailin_promo`.`end_time` >= 1744190008 and `kailin_promo_product`.`status` = 0 and `kailin_promo_product`.`product_id` = 70) limit 1 ["RunTime:1.01ms"] []
[2025-04-09T17:13:32.181862+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:14.63ms"] []
[2025-04-09T17:13:32.185291+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` = 3) limit 1 ["RunTime:0.91ms"] []
[2025-04-09T17:13:32.198436+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` = 3) limit 1 ["RunTime:26.51ms"] []
[2025-04-09T17:13:32.201347+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.89ms"] []
[2025-04-09T17:13:32.204558+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.36ms"] []
[2025-04-09T17:13:32.205320+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.34ms"] []
[2025-04-09T17:13:32.207740+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` <= 1744190012 and `kailin_promo`.`end_time` >= 1744190012 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.11ms"] []
[2025-04-09T17:13:32.208935+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.8ms"] []
[2025-04-09T17:13:32.210052+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190012 and `end_time` >= 1744190012 and `product_id` = 70) limit 1 ["RunTime:0.65ms"] []
[2025-04-09T17:13:32.210693+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190012 and `end_time` >= 1744190012 and `product_id` = 71) limit 1 ["RunTime:0.22ms"] []
[2025-04-09T17:13:32.211350+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190012 and `end_time` >= 1744190012 and `product_id` = 72) limit 1 ["RunTime:0.22ms"] []
[2025-04-09T17:13:32.212215+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190012 and `end_time` >= 1744190012 and `product_id` = 73) limit 1 ["RunTime:0.43ms"] []
[2025-04-09T17:13:33.409892+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.76ms"] []
[2025-04-09T17:13:33.413933+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` = 3 and `kailin_custom_redpacket`.`shop_id` = 1 and `kailin_custom_redpacket`.`company_id` = 1 and `kailin_redpacket`.`start_time` <= 1744190013 and `kailin_redpacket`.`end_time` >= 1744190013 and `kailin_redpacket`.`status` = 0) ["RunTime:1.22ms"] []
[2025-04-09T17:13:33.424906+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:26.18ms"] []
[2025-04-09T17:13:33.427975+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` = 3) limit 1 ["RunTime:0.51ms"] []
[2025-04-09T17:13:33.429188+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18054576631) limit 1 ["RunTime:0.69ms"] []
[2025-04-09T17:13:33.432815+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 3 and `shop_id` = 1) limit 1 ["RunTime:0.74ms"] []
[2025-04-09T17:13:40.714908+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.7ms"] []
[2025-04-09T17:13:40.717817+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` = 3) limit 1 ["RunTime:0.3ms"] []
[2025-04-09T17:13:40.750839+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` = 3) limit 1 ["RunTime:17.95ms"] []
[2025-04-09T17:13:40.753922+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.96ms"] []
[2025-04-09T17:13:40.756973+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.28ms"] []
[2025-04-09T17:13:40.757666+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.36ms"] []
[2025-04-09T17:13:40.759849+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` <= 1744190020 and `kailin_promo`.`end_time` >= 1744190020 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.05ms"] []
[2025-04-09T17:13:40.760779+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.6ms"] []
[2025-04-09T17:13:40.761777+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190020 and `end_time` >= 1744190020 and `product_id` = 70) limit 1 ["RunTime:0.61ms"] []
[2025-04-09T17:13:40.762505+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190020 and `end_time` >= 1744190020 and `product_id` = 71) limit 1 ["RunTime:0.31ms"] []
[2025-04-09T17:13:40.763192+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190020 and `end_time` >= 1744190020 and `product_id` = 72) limit 1 ["RunTime:0.23ms"] []
[2025-04-09T17:13:40.763769+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190020 and `end_time` >= 1744190020 and `product_id` = 73) limit 1 ["RunTime:0.2ms"] []
[2025-04-09T17:13:41.857447+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:18.8ms"] []
[2025-04-09T17:13:41.861530+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` = 3 and `kailin_custom_redpacket`.`shop_id` = 1 and `kailin_custom_redpacket`.`company_id` = 1 and `kailin_redpacket`.`start_time` <= 1744190021 and `kailin_redpacket`.`end_time` >= 1744190021 and `kailin_redpacket`.`status` = 0) ["RunTime:1.39ms"] []
[2025-04-09T17:13:41.888630+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:26.84ms"] []
[2025-04-09T17:13:41.892664+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` = 3) limit 1 ["RunTime:1.46ms"] []
[2025-04-09T17:13:41.893780+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18054576631) limit 1 ["RunTime:0.65ms"] []
[2025-04-09T17:13:41.898336+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 3 and `shop_id` = 1) limit 1 ["RunTime:0.94ms"] []
[2025-04-09T17:13:42.945466+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:26.28ms"] []
`userpic`, `username`, `sex`, `city_id`, `status`, `insert_time` from `kailin_custom` where (`uid` = 3) limit 1 ["RunTime:22.45ms"] []
[2025-04-09T17:13:42.949659+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.24ms"] []
[2025-04-09T17:13:42.951028+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` = 3) limit 1 ["RunTime:0.78ms"] []
[2025-04-09T17:13:42.963468+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.09ms"] []
[2025-04-09T17:13:42.964391+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.42ms"] []
[2025-04-09T17:13:42.966281+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` <= 1744190022 and `kailin_promo`.`end_time` >= 1744190022 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:0.49ms"] []
[2025-04-09T17:13:42.967240+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.43ms"] []
[2025-04-09T17:13:42.968543+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190022 and `end_time` >= 1744190022 and `product_id` = 70) limit 1 ["RunTime:0.51ms"] []
[2025-04-09T17:13:42.969690+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190022 and `end_time` >= 1744190022 and `product_id` = 71) limit 1 ["RunTime:0.44ms"] []
[2025-04-09T17:13:42.970612+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190022 and `end_time` >= 1744190022 and `product_id` = 72) limit 1 ["RunTime:0.33ms"] []
[2025-04-09T17:13:42.971485+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190022 and `end_time` >= 1744190022 and `product_id` = 73) limit 1 ["RunTime:0.28ms"] []
[2025-04-09T17:22:30.647250+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.65ms"] []
[2025-04-09T17:22:30.651356+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` = 3) limit 1 ["RunTime:0.78ms"] []
[2025-04-09T17:22:30.652003+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` = 3) limit 1 ["RunTime:1.88ms"] []
[2025-04-09T17:22:30.652612+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18054576631) limit 1 ["RunTime:0.72ms"] []
[2025-04-09T17:22:30.654528+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` = 70 limit 1 ["RunTime:0.79ms"] []
[2025-04-09T17:22:30.655685+08:00] sql.INFO: select `city_id` from `kailin_product_city` where (`product_id` = 70) ["RunTime:0.76ms"] []
[2025-04-09T17:22:30.656355+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 3 and `shop_id` = 1) limit 1 ["RunTime:0.7ms"] []
[2025-04-09T17:22:30.656770+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.32ms"] []
[2025-04-09T17:22:30.670572+08:00] sql.INFO: select `id`, `sort`, `thumb` from `kailin_product_photo` where (`product_id` = 70) ["RunTime:0.86ms"] []
[2025-04-09T17:22:30.671725+08:00] sql.INFO: select `id`, `name`, `spec_id`, `product_id`, `thumb`, `remark` from `kailin_product_attr` where (`product_id` = 70) ["RunTime:0.69ms"] []
[2025-04-09T17:22:30.672835+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` = 70) ["RunTime:0.69ms"] []
[2025-04-09T17:22:30.674614+08:00] sql.INFO: select * from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744190550 and `end_time` >= 1744190550 and `product_id` = 70) limit 1 ["RunTime:1.17ms"] []
[2025-04-09T17:22:30.676009+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.77ms"] []
[2025-04-09T17:22:30.678093+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` <= 1744190550 and `kailin_promo`.`end_time` >= 1744190550 and `kailin_promo_product`.`status` = 0 and `kailin_promo_product`.`product_id` = 70) limit 1 ["RunTime:1.34ms"] []
[2025-04-09T17:30:31.381862+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.08ms"] []
[2025-04-09T17:30:31.386810+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` = 3) limit 1 ["RunTime:0.42ms"] []
[2025-04-09T17:30:31.387233+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` = 3) limit 1 ["RunTime:2.86ms"] []
[2025-04-09T17:30:31.390119+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.35ms"] []
[2025-04-09T17:30:31.398930+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.61ms"] []
[2025-04-09T17:30:31.400282+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.74ms"] []
[2025-04-09T17:30:31.403142+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` <= 1744191031 and `kailin_promo`.`end_time` >= 1744191031 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.33ms"] []
[2025-04-09T17:30:31.404871+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:1.11ms"] []
[2025-04-09T17:30:31.406633+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191031 and `end_time` >= 1744191031 and `product_id` = 70) limit 1 ["RunTime:1.04ms"] []
[2025-04-09T17:30:31.407553+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191031 and `end_time` >= 1744191031 and `product_id` = 71) limit 1 ["RunTime:0.31ms"] []
[2025-04-09T17:30:31.408392+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191031 and `end_time` >= 1744191031 and `product_id` = 72) limit 1 ["RunTime:0.3ms"] []
[2025-04-09T17:30:31.409099+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191031 and `end_time` >= 1744191031 and `product_id` = 73) limit 1 ["RunTime:0.22ms"] []
[2025-04-09T17:30:33.025863+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:27.44ms"] []
[2025-04-09T17:30:33.030390+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` = 3 and `kailin_custom_redpacket`.`shop_id` = 1 and `kailin_custom_redpacket`.`company_id` = 1 and `kailin_redpacket`.`start_time` <= 1744191033 and `kailin_redpacket`.`end_time` >= 1744191033 and `kailin_redpacket`.`status` = 0) ["RunTime:1.25ms"] []
[2025-04-09T17:30:33.040670+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:25.62ms"] []
[2025-04-09T17:30:33.044471+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` = 3) limit 1 ["RunTime:0.44ms"] []
[2025-04-09T17:30:33.045259+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18054576631) limit 1 ["RunTime:0.22ms"] []
[2025-04-09T17:30:33.048739+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 3 and `shop_id` = 1) limit 1 ["RunTime:0.35ms"] []
[2025-04-09T17:30:42.990047+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.92ms"] []
[2025-04-09T17:30:43.716407+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.37ms"] []
[2025-04-09T17:30:43.981606+08:00] sql.INFO: select * from `kailin_custom_openid` where (`openid` = oNEkF7PYFD95LTg-Qeg2bEu_FfWU and `unionid` = oZ2yV5m0YPg150z6D9cGnpvcZBeg) limit 1 ["RunTime:2.35ms"] []
[2025-04-09T17:30:43.984354+08:00] sql.INFO: select * from `kailin_custom_shop_record` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:1.67ms"] []
[2025-04-09T17:30:43.986003+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.82ms"] []
[2025-04-09T17:30:43.989704+08:00] sql.INFO: insert into `kailin_custom_shop_record` (`custom_uid`, `shop_id`, `company_id`, `visit_time`, `insert_time`, `update_time`) values (25, 1, 1, 1744191043, 1744191043, 1744191043) ["RunTime:1.35ms"] []
[2025-04-09T17:30:44.191014+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:11.81ms"] []
[2025-04-09T17:30:44.191571+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:13.78ms"] []
[2025-04-09T17:30:44.196131+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` <= 1744191044 and `kailin_redpacket`.`end_time` >= 1744191044 and `kailin_redpacket`.`status` = 0) ["RunTime:1.79ms"] []
[2025-04-09T17:30:44.211429+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:0.48ms"] []
[2025-04-09T17:30:44.212979+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.86ms"] []
[2025-04-09T17:30:44.218373+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:1.2ms"] []
[2025-04-09T17:31:03.318036+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:4.6ms"] []
[2025-04-09T17:31:03.321698+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:0.71ms"] []
[2025-04-09T17:31:03.390045+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:23.43ms"] []
[2025-04-09T17:31:03.394642+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.77ms"] []
[2025-04-09T17:31:03.400587+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.24ms"] []
[2025-04-09T17:31:03.402064+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.88ms"] []
[2025-04-09T17:31:03.404311+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` <= 1744191063 and `kailin_promo`.`end_time` >= 1744191063 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.07ms"] []
[2025-04-09T17:31:03.405227+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.59ms"] []
[2025-04-09T17:31:03.406177+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191063 and `end_time` >= 1744191063 and `product_id` = 70) limit 1 ["RunTime:0.57ms"] []
[2025-04-09T17:31:03.406675+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191063 and `end_time` >= 1744191063 and `product_id` = 71) limit 1 ["RunTime:0.16ms"] []
[2025-04-09T17:31:03.407254+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191063 and `end_time` >= 1744191063 and `product_id` = 72) limit 1 ["RunTime:0.19ms"] []
[2025-04-09T17:31:03.407876+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191063 and `end_time` >= 1744191063 and `product_id` = 73) limit 1 ["RunTime:0.17ms"] []
[2025-04-09T17:31:05.827723+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:18.96ms"] []
[2025-04-09T17:31:15.443491+08:00] sql.INFO: select `id` from `kailin_city` where (`name` = 唐山市) limit 1 ["RunTime:27.68ms"] []
[2025-04-09T17:31:15.446093+08:00] sql.INFO: update `kailin_custom` set `city_id` = 1302, `update_time` = 1744191075 where (`uid` = 25) ["RunTime:0.94ms"] []
[2025-04-09T17:31:15.586846+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.57ms"] []
[2025-04-09T17:31:15.589341+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:0.28ms"] []
[2025-04-09T17:31:15.590133+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.33ms"] []
[2025-04-09T17:31:15.593452+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.29ms"] []
[2025-04-09T17:31:15.610618+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:25.17ms"] []
[2025-04-09T17:31:15.615729+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` <= 1744191075 and `kailin_redpacket`.`end_time` >= 1744191075 and `kailin_redpacket`.`status` = 0) ["RunTime:0.85ms"] []
[2025-04-09T17:31:19.949708+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.06ms"] []
[2025-04-09T17:31:19.953677+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:0.49ms"] []
[2025-04-09T17:31:19.971047+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:13.79ms"] []
[2025-04-09T17:31:19.973467+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.58ms"] []
[2025-04-09T17:31:19.976652+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:0.9ms"] []
[2025-04-09T17:31:19.978299+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.91ms"] []
[2025-04-09T17:31:19.982014+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` <= 1744191079 and `kailin_promo`.`end_time` >= 1744191079 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.14ms"] []
[2025-04-09T17:31:19.983487+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.44ms"] []
[2025-04-09T17:31:19.984812+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191079 and `end_time` >= 1744191079 and `product_id` = 70) limit 1 ["RunTime:0.43ms"] []
[2025-04-09T17:31:19.986069+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191079 and `end_time` >= 1744191079 and `product_id` = 71) limit 1 ["RunTime:0.5ms"] []
[2025-04-09T17:31:19.987224+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191079 and `end_time` >= 1744191079 and `product_id` = 72) limit 1 ["RunTime:0.4ms"] []
[2025-04-09T17:31:19.988212+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191079 and `end_time` >= 1744191079 and `product_id` = 73) limit 1 ["RunTime:0.3ms"] []
[2025-04-09T17:31:20.844540+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:19.43ms"] []
[2025-04-09T17:31:20.847463+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:0.36ms"] []
[2025-04-09T17:31:20.848485+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.25ms"] []
[2025-04-09T17:31:20.851442+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.26ms"] []
[2025-04-09T17:31:20.872361+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:23.6ms"] []
[2025-04-09T17:31:20.876229+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` <= 1744191080 and `kailin_redpacket`.`end_time` >= 1744191080 and `kailin_redpacket`.`status` = 0) ["RunTime:1.17ms"] []
[2025-04-09T17:31:22.609370+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:12.45ms"] []
[2025-04-09T17:31:22.612202+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:0.29ms"] []
[2025-04-09T17:31:22.625053+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:23.58ms"] []
[2025-04-09T17:31:22.627875+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.41ms"] []
[2025-04-09T17:31:22.630450+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:0.7ms"] []
[2025-04-09T17:31:22.632044+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.69ms"] []
[2025-04-09T17:31:22.634276+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` <= 1744191082 and `kailin_promo`.`end_time` >= 1744191082 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:0.52ms"] []
[2025-04-09T17:31:22.634849+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.2ms"] []
[2025-04-09T17:31:22.635498+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191082 and `end_time` >= 1744191082 and `product_id` = 70) limit 1 ["RunTime:0.24ms"] []
[2025-04-09T17:31:22.636131+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191082 and `end_time` >= 1744191082 and `product_id` = 71) limit 1 ["RunTime:0.25ms"] []
[2025-04-09T17:31:22.636686+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191082 and `end_time` >= 1744191082 and `product_id` = 72) limit 1 ["RunTime:0.18ms"] []
[2025-04-09T17:31:22.637206+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191082 and `end_time` >= 1744191082 and `product_id` = 73) limit 1 ["RunTime:0.2ms"] []
[2025-04-09T17:31:24.255914+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:23.9ms"] []
[2025-04-09T17:31:24.256045+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:23.5ms"] []
[2025-04-09T17:31:24.258812+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:0.36ms"] []
[2025-04-09T17:31:24.258982+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` <= 1744191084 and `kailin_redpacket`.`end_time` >= 1744191084 and `kailin_redpacket`.`status` = 0) ["RunTime:0.26ms"] []
[2025-04-09T17:31:24.259483+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.18ms"] []
[2025-04-09T17:31:24.262691+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.27ms"] []
[2025-04-09T17:31:32.610162+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:19.68ms"] []
[2025-04-09T17:31:32.893337+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.76ms"] []
[2025-04-09T17:31:33.203630+08:00] sql.INFO: select * from `kailin_custom_openid` where (`openid` = oNEkF7PYFD95LTg-Qeg2bEu_FfWU and `unionid` = oZ2yV5m0YPg150z6D9cGnpvcZBeg) limit 1 ["RunTime:1.63ms"] []
[2025-04-09T17:31:33.206077+08:00] sql.INFO: select * from `kailin_custom_shop_record` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:1.54ms"] []
[2025-04-09T17:31:33.214588+08:00] sql.INFO: update `kailin_custom_shop_record` set `visit_time` = 1744191093 where (`id` = 1058) ["RunTime:7.65ms"] []
[2025-04-09T17:31:33.443270+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:14.19ms"] []
[2025-04-09T17:31:33.446794+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:0.72ms"] []
[2025-04-09T17:31:33.448652+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:1.09ms"] []
[2025-04-09T17:31:33.452984+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:1.04ms"] []
[2025-04-09T17:31:33.475084+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:26.53ms"] []
[2025-04-09T17:31:33.478831+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` <= 1744191093 and `kailin_redpacket`.`end_time` >= 1744191093 and `kailin_redpacket`.`status` = 0) ["RunTime:0.78ms"] []
[2025-04-09T17:31:35.285214+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:13.82ms"] []
[2025-04-09T17:31:35.289051+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:0.34ms"] []
[2025-04-09T17:31:35.301501+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:22.57ms"] []
[2025-04-09T17:31:35.304172+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.48ms"] []
[2025-04-09T17:31:35.307630+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.62ms"] []
[2025-04-09T17:31:35.309233+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.94ms"] []
[2025-04-09T17:31:35.312785+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` <= 1744191095 and `kailin_promo`.`end_time` >= 1744191095 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.27ms"] []
[2025-04-09T17:31:35.315269+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:1.64ms"] []
[2025-04-09T17:31:35.317075+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191095 and `end_time` >= 1744191095 and `product_id` = 70) limit 1 ["RunTime:0.91ms"] []
[2025-04-09T17:31:35.318231+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191095 and `end_time` >= 1744191095 and `product_id` = 71) limit 1 ["RunTime:0.4ms"] []
[2025-04-09T17:31:35.319526+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191095 and `end_time` >= 1744191095 and `product_id` = 72) limit 1 ["RunTime:0.47ms"] []
[2025-04-09T17:31:35.320628+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191095 and `end_time` >= 1744191095 and `product_id` = 73) limit 1 ["RunTime:0.33ms"] []
[2025-04-09T17:31:36.719061+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:19.14ms"] []
[2025-04-09T17:31:36.727280+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:0.97ms"] []
[2025-04-09T17:31:36.728662+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.83ms"] []
[2025-04-09T17:31:36.731179+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.85ms"] []
[2025-04-09T17:31:36.732235+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.97ms"] []
[2025-04-09T17:31:36.740673+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` <= 1744191096 and `kailin_redpacket`.`end_time` >= 1744191096 and `kailin_redpacket`.`status` = 0) ["RunTime:1.01ms"] []
[2025-04-09T17:31:53.009321+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:13.39ms"] []
[2025-04-09T17:31:53.011879+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:0.26ms"] []
[2025-04-09T17:31:53.025507+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:25.78ms"] []
[2025-04-09T17:31:53.027800+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.45ms"] []
[2025-04-09T17:31:53.031538+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.59ms"] []
[2025-04-09T17:31:53.032361+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.42ms"] []
[2025-04-09T17:31:53.034592+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` <= 1744191113 and `kailin_promo`.`end_time` >= 1744191113 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.02ms"] []
[2025-04-09T17:31:53.035595+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.65ms"] []
[2025-04-09T17:31:53.036862+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191113 and `end_time` >= 1744191113 and `product_id` = 70) limit 1 ["RunTime:0.81ms"] []
[2025-04-09T17:31:53.037581+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191113 and `end_time` >= 1744191113 and `product_id` = 71) limit 1 ["RunTime:0.22ms"] []
[2025-04-09T17:31:53.038147+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191113 and `end_time` >= 1744191113 and `product_id` = 72) limit 1 ["RunTime:0.19ms"] []
[2025-04-09T17:31:53.038658+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191113 and `end_time` >= 1744191113 and `product_id` = 73) limit 1 ["RunTime:0.17ms"] []
[2025-04-09T17:31:54.060072+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:2.11ms"] []
[2025-04-09T17:31:54.062338+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` = 70 limit 1 ["RunTime:0.44ms"] []
[2025-04-09T17:31:54.062988+08:00] sql.INFO: select `city_id` from `kailin_product_city` where (`product_id` = 70) ["RunTime:0.23ms"] []
[2025-04-09T17:31:54.064228+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.44ms"] []
[2025-04-09T17:31:54.066762+08:00] sql.INFO: select `id`, `sort`, `thumb` from `kailin_product_photo` where (`product_id` = 70) ["RunTime:0.89ms"] []
[2025-04-09T17:31:54.067979+08:00] sql.INFO: select `id`, `name`, `spec_id`, `product_id`, `thumb`, `remark` from `kailin_product_attr` where (`product_id` = 70) ["RunTime:0.81ms"] []
[2025-04-09T17:31:54.069120+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` = 70) ["RunTime:0.74ms"] []
[2025-04-09T17:31:54.069785+08:00] sql.INFO: select * from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191114 and `end_time` >= 1744191114 and `product_id` = 70) limit 1 ["RunTime:0.24ms"] []
[2025-04-09T17:31:54.070293+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.17ms"] []
[2025-04-09T17:31:54.071125+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` <= 1744191114 and `kailin_promo`.`end_time` >= 1744191114 and `kailin_promo_product`.`status` = 0 and `kailin_promo_product`.`product_id` = 70) limit 1 ["RunTime:0.27ms"] []
[2025-04-09T17:31:54.084294+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:24ms"] []
[2025-04-09T17:31:54.087685+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:0.38ms"] []
[2025-04-09T17:31:54.088492+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.21ms"] []
[2025-04-09T17:31:54.092377+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.41ms"] []
[2025-04-09T17:31:55.980967+08:00] sql.INFO: select `id`, `custom_uid`, `contact_province`, `contact_city`, `contact_area`, `contact_addr`, `contact_name`, `contact_shop`, `contact_phone`, `is_default`, `shop_type` from `kailin_custom_addr` where (`custom_uid` = 25) ["RunTime:27.45ms"] []
[2025-04-09T17:31:56.039010+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:20.89ms"] []
[2025-04-09T17:31:56.043242+08:00] sql.INFO: select `kailin_custom_coupon`.`id`, `kailin_coupon`.`id` as `coupon_id`, `kailin_coupon`.`name`, `kailin_coupon`.`type_id`, `kailin_coupon`.`rebate_type`, `kailin_coupon`.`std_pay`, `kailin_coupon`.`rebate`, `kailin_custom_coupon`.`status`, `kailin_custom_coupon`.`exp_time` from `kailin_custom_coupon` inner join `kailin_coupon` on `kailin_custom_coupon`.`coupon_id` = `kailin_coupon`.`id` where (`kailin_custom_coupon`.`custom_uid` = 25 and `kailin_custom_coupon`.`status` = 0 and `kailin_custom_coupon`.`shop_id` = 1) order by `kailin_custom_coupon`.`status` asc ["RunTime:1.34ms"] []
[2025-04-09T17:31:56.044472+08:00] sql.INFO: select `coupon_id`, `product_id` from `kailin_coupon_product` where 0 = 1 ["RunTime:0.84ms"] []
[2025-04-09T17:31:56.045902+08:00] sql.INFO: select `kailin_coupon_rebate`.`coupon_id`, `kailin_coupon_rebate`.`product_id`, `kailin_coupon_rebate`.`rebate_num`, `kailin_product`.`name` as `product_name`, `kailin_product`.`spec` as `product_spec` from `kailin_coupon_rebate` inner join `kailin_product` on `kailin_coupon_rebate`.`product_id` = `kailin_product`.`id` where 0 = 1 ["RunTime:0.91ms"] []
[2025-04-09T17:31:56.048218+08:00] sql.INFO: select `coupon_id`, `product_id` from `kailin_coupon_product_exclude` where 0 = 1 ["RunTime:1.89ms"] []
[2025-04-09T17:32:00.313185+08:00] sql.INFO: select `id`, `custom_uid`, `contact_province`, `contact_city`, `contact_area`, `contact_addr`, `contact_name`, `contact_shop`, `contact_phone`, `is_default`, `shop_type` from `kailin_custom_addr` where (`custom_uid` = 25) ["RunTime:12.05ms"] []
[2025-04-09T17:32:00.343513+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:26.14ms"] []
[2025-04-09T17:32:21.781333+08:00] sql.INFO: select `contact_province`, `contact_city`, `contact_area`, `contact_addr`, `contact_shop`, `shop_type` from `kailin_custom_addr` where (`contact_shop` LIKE %测试%) limit 20 ["RunTime:2.51ms"] []
[2025-04-09T17:32:25.675123+08:00] sql.INFO: select `contact_province`, `contact_city`, `contact_area`, `contact_addr`, `contact_shop`, `shop_type` from `kailin_custom_addr` where (`contact_shop` LIKE %测试店铺%) limit 20 ["RunTime:27.71ms"] []
[2025-04-09T17:32:40.671258+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:15.81ms"] []
[2025-04-09T17:32:40.680785+08:00] sql.INFO: select count(*) as aggregate from `kailin_custom_addr` where (`custom_uid` = 25) ["RunTime:1.23ms"] []
[2025-04-09T17:32:40.681898+08:00] sql.INFO: update `kailin_custom_addr` set `is_default` = 0 where (`custom_uid` = 25) ["RunTime:0.4ms"] []
[2025-04-09T17:32:40.683313+08:00] sql.INFO: insert into `kailin_custom_addr` (`contact_province`, `contact_city`, `contact_area`, `contact_addr`, `contact_name`, `contact_shop`, `shop_type`, `contact_phone`, `is_default`, `custom_uid`, `insert_time`, `update_time`) values (河北省, 唐山市, 路南区, 一方天地, 何先生, 测试店铺, 1, 18819035894, 1, 25, 1744191160, 1744191160) ["RunTime:0.87ms"] []
[2025-04-09T17:32:40.838488+08:00] sql.INFO: select `id`, `custom_uid`, `contact_province`, `contact_city`, `contact_area`, `contact_addr`, `contact_name`, `contact_shop`, `contact_phone`, `is_default`, `shop_type` from `kailin_custom_addr` where (`custom_uid` = 25) ["RunTime:18.37ms"] []
[2025-04-09T17:32:43.469142+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:18.53ms"] []
[2025-04-09T17:32:43.469586+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:11.12ms"] []
[2025-04-09T17:32:43.470977+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` = 70 limit 1 ["RunTime:0.25ms"] []
[2025-04-09T17:32:43.471502+08:00] sql.INFO: select `city_id` from `kailin_product_city` where (`product_id` = 70) ["RunTime:0.2ms"] []
[2025-04-09T17:32:43.472371+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.25ms"] []
[2025-04-09T17:32:43.472427+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:0.2ms"] []
[2025-04-09T17:32:43.473683+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.72ms"] []
[2025-04-09T17:32:43.476829+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.75ms"] []
[2025-04-09T17:32:43.481576+08:00] sql.INFO: select `id`, `sort`, `thumb` from `kailin_product_photo` where (`product_id` = 70) ["RunTime:1.06ms"] []
[2025-04-09T17:32:43.483529+08:00] sql.INFO: select `id`, `name`, `spec_id`, `product_id`, `thumb`, `remark` from `kailin_product_attr` where (`product_id` = 70) ["RunTime:1.11ms"] []
[2025-04-09T17:32:43.486182+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` = 70) ["RunTime:1.97ms"] []
[2025-04-09T17:32:43.487575+08:00] sql.INFO: select * from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191163 and `end_time` >= 1744191163 and `product_id` = 70) limit 1 ["RunTime:0.49ms"] []
[2025-04-09T17:32:43.488794+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.65ms"] []
[2025-04-09T17:32:43.490939+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` <= 1744191163 and `kailin_promo`.`end_time` >= 1744191163 and `kailin_promo_product`.`status` = 0 and `kailin_promo_product`.`product_id` = 70) limit 1 ["RunTime:0.76ms"] []
[2025-04-09T17:32:50.799263+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:25.87ms"] []
[2025-04-09T17:32:50.808121+08:00] sql.INFO: select `id`, `custom_uid`, `contact_province`, `contact_city`, `contact_area`, `contact_addr`, `contact_name`, `contact_shop`, `contact_phone`, `is_default`, `shop_type` from `kailin_custom_addr` where (`id` = 14) limit 1 ["RunTime:1.98ms"] []
[2025-04-09T17:32:50.810078+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:0.72ms"] []
[2025-04-09T17:32:50.817658+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.39ms"] []
[2025-04-09T17:32:50.818961+08:00] sql.INFO: select `kailin_product`.`id`, `kailin_product`.`name` as `product_name`, `kailin_product`.`thumb` as `product_thumb`, `kailin_product`.`spec` as `sku_attr_names`, `kailin_product`.`price`, `kailin_product`.`stock`, `kailin_product`.`status`, `kailin_product`.`shop_id`, `kailin_product`.`quota`, `kailin_product`.`min_quota`, `kailin_product`.`quota_start`, `kailin_product`.`quota_end`, `kailin_product`.`tag_scope`, `kailin_product`.`tag_exclude`, `kailin_product`.`sku_min_quota_and` from `kailin_product` inner join `kailin_product_city` on `kailin_product_city`.`product_id` = `kailin_product`.`id` where `kailin_product_city`.`city_id` in (1, 1302) and `kailin_product`.`id` in (70) and (`kailin_product`.`status` = 0) ["RunTime:0.44ms"] []
[2025-04-09T17:32:50.822833+08:00] sql.INFO: select `id` as `sku_id`, `product_id`, `attr_names` as `sku_attr_names`, `quota`, `min_quota`, `price`, `market_price`, `stock`, `status` from `kailin_product_skus` where `id` in (0) and (`status` = 0) ["RunTime:2.27ms"] []
[2025-04-09T17:32:50.849603+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` <= 1744191170 and `kailin_promo`.`end_time` >= 1744191170 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70) ["RunTime:0.83ms"] []
[2025-04-09T17:32:50.924955+08:00] sql.INFO: update `kailin_product` set `stock` = stock+-1, `update_time` = 1744191170 where (`id` = 70) ["RunTime:0.4ms"] []
[2025-04-09T17:32:50.926506+08:00] sql.INFO: insert into `kailin_orders` (`shop_id`, `custom_uid`, `price_total`, `pay_total`, `coupon_total`, `order_score`, `snowflake_id`, `insert_time`, `update_time`) values (1, 25, 116, 116, 0, 0, 553631228507592454, 1744191170, 1744191170) ["RunTime:1.08ms"] []
[2025-04-09T17:32:50.928395+08:00] sql.INFO: insert into `kailin_orders_product` (`buy_num`, `coupon_total`, `custom_uid`, `insert_time`, `is_rebate`, `order_id`, `pay_total`, `price_total`, `product_id`, `product_name`, `product_thumb`, `shop_id`, `sku_attr_names`, `update_time`) values (1, 0, 25, 1744191170, 0, 80, 116, 116, 70, 哪吒·三界往事, https://openwork-oss.oss-cn-shenzhen.aliyuncs.com/uploads/shop/2025/04/08/a04c41767264d6b05b0e09471ab35a8f.png, 1, 精装, 1744191170) ["RunTime:1.32ms"] []
[2025-04-09T17:32:50.929542+08:00] sql.INFO: insert into `kailin_orders_addr` (`contact_name`, `contact_shop`, `shop_type`, `contact_phone`, `contact_province`, `contact_city`, `contact_area`, `contact_addr`, `order_id`, `insert_time`, `update_time`) values (何先生, 测试店铺, 1, 18819035894, 河北省, 唐山市, 路南区, 一方天地, 80, 1744191170, 1744191170) ["RunTime:0.81ms"] []
[2025-04-09T17:32:50.946109+08:00] sql.INFO: select `id`, `name`, `std_num`, `remove_custom`, `city_ids`, `status`, `start_time`, `end_time`, `coupon_id` from `kailin_coupon_reward_rule` where (`status` = 0 and `shop_id` = 1) ["RunTime:1.08ms"] []
[2025-04-09T17:32:51.033392+08:00] sql.INFO: select `city_id` from `kailin_custom` where (`uid` = 25) limit 1 ["RunTime:0.76ms"] []
[2025-04-09T17:32:51.036240+08:00] sql.INFO: select `id`, `product_id`, `product_units`, `status`, `reward_rule_id` from `kailin_coupon_reward_product` where (`status` = 0 and `reward_rule_id` = 20) ["RunTime:1.83ms"] []
[2025-04-09T17:32:51.037077+08:00] sql.INFO: select `product_id`, `buy_num` from `kailin_orders_product` where (`custom_uid` = 25 and `status` = 1 and `insert_time` >= 1744115066 and `insert_time` <= 1745324668) ["RunTime:0.29ms"] []
[2025-04-09T17:32:55.228004+08:00] sql.INFO: select * from `kailin_orders` where `id` = 80 limit 1 ["RunTime:28.95ms"] []
[2025-04-09T17:33:01.213809+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:21.65ms"] []
[2025-04-09T17:33:01.216909+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:0.37ms"] []
[2025-04-09T17:33:01.217728+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.35ms"] []
[2025-04-09T17:33:01.220857+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.4ms"] []
[2025-04-09T17:33:01.236058+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.54ms"] []
[2025-04-09T17:33:01.237953+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` = 70 limit 1 ["RunTime:0.29ms"] []
[2025-04-09T17:33:01.238777+08:00] sql.INFO: select `city_id` from `kailin_product_city` where (`product_id` = 70) ["RunTime:0.24ms"] []
[2025-04-09T17:33:01.239608+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.26ms"] []
[2025-04-09T17:33:01.241873+08:00] sql.INFO: select `id`, `sort`, `thumb` from `kailin_product_photo` where (`product_id` = 70) ["RunTime:0.82ms"] []
[2025-04-09T17:33:01.243117+08:00] sql.INFO: select `id`, `name`, `spec_id`, `product_id`, `thumb`, `remark` from `kailin_product_attr` where (`product_id` = 70) ["RunTime:0.82ms"] []
[2025-04-09T17:33:01.244204+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` = 70) ["RunTime:0.72ms"] []
[2025-04-09T17:33:01.245159+08:00] sql.INFO: select * from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191181 and `end_time` >= 1744191181 and `product_id` = 70) limit 1 ["RunTime:0.39ms"] []
[2025-04-09T17:33:01.245920+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.27ms"] []
[2025-04-09T17:33:01.247320+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` <= 1744191181 and `kailin_promo`.`end_time` >= 1744191181 and `kailin_promo_product`.`status` = 0 and `kailin_promo_product`.`product_id` = 70) limit 1 ["RunTime:0.56ms"] []
[2025-04-09T17:33:04.081721+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:2.15ms"] []
[2025-04-09T17:33:04.084427+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.4ms"] []
[2025-04-09T17:33:04.087903+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:1.55ms"] []
[2025-04-09T17:33:04.088629+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.33ms"] []
[2025-04-09T17:33:04.088950+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:13.83ms"] []
[2025-04-09T17:33:04.090932+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` <= 1744191184 and `kailin_promo`.`end_time` >= 1744191184 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.09ms"] []
[2025-04-09T17:33:04.091923+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.64ms"] []
[2025-04-09T17:33:04.092859+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191184 and `end_time` >= 1744191184 and `product_id` = 70) limit 1 ["RunTime:0.56ms"] []
[2025-04-09T17:33:04.093317+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191184 and `end_time` >= 1744191184 and `product_id` = 71) limit 1 ["RunTime:0.14ms"] []
[2025-04-09T17:33:04.094238+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191184 and `end_time` >= 1744191184 and `product_id` = 72) limit 1 ["RunTime:0.43ms"] []
[2025-04-09T17:33:04.094883+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191184 and `end_time` >= 1744191184 and `product_id` = 73) limit 1 ["RunTime:0.23ms"] []
[2025-04-09T17:33:04.096372+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:0.51ms"] []
[2025-04-09T17:33:05.190653+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.33ms"] []
[2025-04-09T17:33:05.193476+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:0.37ms"] []
[2025-04-09T17:33:05.194389+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.27ms"] []
[2025-04-09T17:33:05.198534+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.96ms"] []
[2025-04-09T17:33:05.201191+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.55ms"] []
[2025-04-09T17:33:05.206687+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` <= 1744191185 and `kailin_redpacket`.`end_time` >= 1744191185 and `kailin_redpacket`.`status` = 0) ["RunTime:2.46ms"] []
[2025-04-09T17:33:07.621512+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:14.9ms"] []
[2025-04-09T17:33:07.626158+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) ["RunTime:1.27ms"] []
[2025-04-09T17:33:07.626980+08:00] sql.INFO: select `id`, `pay_total`, `status`, `price_total`, `coupon_total`, `shop_id`, `pay_total`, `weizan_orderid`, `insert_time` from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) order by `id` desc limit 10 offset 0 ["RunTime:0.41ms"] []
[2025-04-09T17:33:07.629078+08:00] sql.INFO: select `id` as `item_id`, `order_id`, `product_id`, `buy_num`, `is_rebate`, `sku_attr_names` as `product_spec`, `product_name`, `product_thumb` from `kailin_orders_product` where `order_id` in (80) ["RunTime:0.98ms"] []
[2025-04-09T17:33:07.630313+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.33ms"] []
[2025-04-09T17:33:11.680189+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:26.6ms"] []
[2025-04-09T17:33:11.683927+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:0.38ms"] []
[2025-04-09T17:33:11.685632+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` <= 1744191191 and `kailin_redpacket`.`end_time` >= 1744191191 and `kailin_redpacket`.`status` = 0) ["RunTime:1.71ms"] []
[2025-04-09T17:33:11.685979+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:1.47ms"] []
[2025-04-09T17:33:11.692011+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.79ms"] []
[2025-04-09T17:33:12.659495+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:13.24ms"] []
[2025-04-09T17:33:12.662917+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:0.34ms"] []
[2025-04-09T17:33:12.676472+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:23.97ms"] []
[2025-04-09T17:33:12.680473+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.67ms"] []
[2025-04-09T17:33:12.683927+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:0.7ms"] []
[2025-04-09T17:33:12.685324+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.75ms"] []
[2025-04-09T17:33:12.687443+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` <= 1744191192 and `kailin_promo`.`end_time` >= 1744191192 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:0.48ms"] []
[2025-04-09T17:33:12.688038+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.18ms"] []
[2025-04-09T17:33:12.688972+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191192 and `end_time` >= 1744191192 and `product_id` = 70) limit 1 ["RunTime:0.43ms"] []
[2025-04-09T17:33:12.690206+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191192 and `end_time` >= 1744191192 and `product_id` = 71) limit 1 ["RunTime:0.52ms"] []
[2025-04-09T17:33:12.691259+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191192 and `end_time` >= 1744191192 and `product_id` = 72) limit 1 ["RunTime:0.44ms"] []
[2025-04-09T17:33:12.692129+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191192 and `end_time` >= 1744191192 and `product_id` = 73) limit 1 ["RunTime:0.32ms"] []
[2025-04-09T17:33:15.986588+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:23.22ms"] []
[2025-04-09T17:33:15.989617+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:0.31ms"] []
[2025-04-09T17:33:15.989659+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` <= 1744191195 and `kailin_redpacket`.`end_time` >= 1744191195 and `kailin_redpacket`.`status` = 0) ["RunTime:0.3ms"] []
[2025-04-09T17:33:15.990326+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.19ms"] []
[2025-04-09T17:33:15.992892+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.2ms"] []
[2025-04-09T17:33:19.581663+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:24.56ms"] []
[2025-04-09T17:33:19.584934+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) ["RunTime:0.78ms"] []
[2025-04-09T17:33:19.585551+08:00] sql.INFO: select `id`, `pay_total`, `status`, `price_total`, `coupon_total`, `shop_id`, `pay_total`, `weizan_orderid`, `insert_time` from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) order by `id` desc limit 10 offset 0 ["RunTime:0.26ms"] []
[2025-04-09T17:33:19.587008+08:00] sql.INFO: select `id` as `item_id`, `order_id`, `product_id`, `buy_num`, `is_rebate`, `sku_attr_names` as `product_spec`, `product_name`, `product_thumb` from `kailin_orders_product` where `order_id` in (80) ["RunTime:0.71ms"] []
[2025-04-09T17:33:19.587722+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.21ms"] []
[2025-04-09T17:33:21.390090+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:11.5ms"] []
[2025-04-09T17:33:21.394489+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:0.53ms"] []
[2025-04-09T17:33:21.396012+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.59ms"] []
[2025-04-09T17:33:21.398902+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.3ms"] []
[2025-04-09T17:33:21.399337+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.31ms"] []
[2025-04-09T17:33:21.404802+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` <= 1744191201 and `kailin_redpacket`.`end_time` >= 1744191201 and `kailin_redpacket`.`status` = 0) ["RunTime:0.39ms"] []
[2025-04-09T17:33:24.700582+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:26.1ms"] []
[2025-04-09T17:33:24.703658+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) ["RunTime:0.71ms"] []
[2025-04-09T17:33:24.704402+08:00] sql.INFO: select `id`, `pay_total`, `status`, `price_total`, `coupon_total`, `shop_id`, `pay_total`, `weizan_orderid`, `insert_time` from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) order by `id` desc limit 10 offset 0 ["RunTime:0.37ms"] []
[2025-04-09T17:33:24.706106+08:00] sql.INFO: select `id` as `item_id`, `order_id`, `product_id`, `buy_num`, `is_rebate`, `sku_attr_names` as `product_spec`, `product_name`, `product_thumb` from `kailin_orders_product` where `order_id` in (80) ["RunTime:0.8ms"] []
[2025-04-09T17:33:24.707036+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.36ms"] []
[2025-04-09T17:33:35.759563+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.73ms"] []
[2025-04-09T17:33:35.759584+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.81ms"] []
[2025-04-09T17:33:35.764475+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:0.84ms"] []
[2025-04-09T17:33:35.766030+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.74ms"] []
[2025-04-09T17:33:35.766155+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` <= 1744191215 and `kailin_redpacket`.`end_time` >= 1744191215 and `kailin_redpacket`.`status` = 0) ["RunTime:1.77ms"] []
[2025-04-09T17:33:35.770180+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:1.15ms"] []
[2025-04-09T17:33:37.503770+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.61ms"] []
[2025-04-09T17:33:37.507137+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:0.39ms"] []
[2025-04-09T17:33:37.523801+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:15.87ms"] []
[2025-04-09T17:33:37.526221+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.38ms"] []
[2025-04-09T17:33:37.528565+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:0.6ms"] []
[2025-04-09T17:33:37.529400+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.38ms"] []
[2025-04-09T17:33:37.531121+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` <= 1744191217 and `kailin_promo`.`end_time` >= 1744191217 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:0.33ms"] []
[2025-04-09T17:33:37.531661+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.19ms"] []
[2025-04-09T17:33:37.532285+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191217 and `end_time` >= 1744191217 and `product_id` = 70) limit 1 ["RunTime:0.21ms"] []
[2025-04-09T17:33:37.532759+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191217 and `end_time` >= 1744191217 and `product_id` = 71) limit 1 ["RunTime:0.13ms"] []
[2025-04-09T17:33:37.533285+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191217 and `end_time` >= 1744191217 and `product_id` = 72) limit 1 ["RunTime:0.18ms"] []
[2025-04-09T17:33:37.533972+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744191217 and `end_time` >= 1744191217 and `product_id` = 73) limit 1 ["RunTime:0.18ms"] []
[2025-04-09T17:33:40.636480+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:25.64ms"] []
[2025-04-09T17:33:40.641883+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:0.64ms"] []
[2025-04-09T17:33:40.645175+08:00] sql.INFO: select `kailin_shop_cart`.`id`, `kailin_shop_cart`.`checked`, `kailin_shop_cart`.`product_id`, `kailin_shop_cart`.`skuid`, `kailin_shop_cart`.`buy_num`, `kailin_product`.`stock`, `kailin_product`.`shop_id`, `kailin_product`.`spec`, `kailin_product`.`thumb`, `kailin_product`.`name`, `kailin_product`.`price`, `kailin_product`.`market_price`, `kailin_product`.`status` as `product_status` from `kailin_shop_cart` inner join `kailin_product` on `kailin_shop_cart`.`product_id` = `kailin_product`.`id` where (`kailin_shop_cart`.`custom_uid` = 25 and `kailin_shop_cart`.`shop_id` = 1 and `kailin_shop_cart`.`company_id` = 1) ["RunTime:1.86ms"] []
[2025-04-09T17:33:40.647455+08:00] sql.INFO: select `id` as `sku_id`, `product_id`, `attr_names` as `sku_attr_names`, `quota`, `min_quota`, `price`, `market_price`, `stock`, `status` from `kailin_product_skus` where 0 = 1 and (`status` = 0) ["RunTime:1.44ms"] []
[2025-04-09T17:33:40.649453+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` <= 1744191220 and `kailin_promo`.`end_time` >= 1744191220 and `kailin_promo_product`.`status` = 0) and 0 = 1 ["RunTime:0.92ms"] []
[2025-04-09T17:33:41.127971+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.87ms"] []
[2025-04-09T17:33:41.128141+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.84ms"] []
[2025-04-09T17:33:41.130914+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:0.28ms"] []
[2025-04-09T17:33:41.130962+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` <= 1744191221 and `kailin_redpacket`.`end_time` >= 1744191221 and `kailin_redpacket`.`status` = 0) ["RunTime:0.35ms"] []
[2025-04-09T17:33:41.132000+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.63ms"] []
[2025-04-09T17:33:41.135062+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.63ms"] []
[2025-04-09T17:33:42.758881+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:26.11ms"] []
[2025-04-09T17:33:42.762258+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) ["RunTime:0.81ms"] []
[2025-04-09T17:33:42.762828+08:00] sql.INFO: select `id`, `pay_total`, `status`, `price_total`, `coupon_total`, `shop_id`, `pay_total`, `weizan_orderid`, `insert_time` from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) order by `id` desc limit 10 offset 0 ["RunTime:0.26ms"] []
[2025-04-09T17:33:42.764248+08:00] sql.INFO: select `id` as `item_id`, `order_id`, `product_id`, `buy_num`, `is_rebate`, `sku_attr_names` as `product_spec`, `product_name`, `product_thumb` from `kailin_orders_product` where `order_id` in (80) ["RunTime:0.69ms"] []
[2025-04-09T17:33:42.764921+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.23ms"] []
[2025-04-09T17:35:40.870795+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.34ms"] []
[2025-04-09T17:35:40.873851+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:0.29ms"] []
[2025-04-09T17:35:40.874512+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.2ms"] []
[2025-04-09T17:35:40.879222+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.51ms"] []
[2025-04-09T17:35:41.194086+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:23.1ms"] []
[2025-04-09T17:35:41.202412+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) ["RunTime:2.18ms"] []
[2025-04-09T17:35:41.204087+08:00] sql.INFO: select `id`, `pay_total`, `status`, `price_total`, `coupon_total`, `shop_id`, `pay_total`, `weizan_orderid`, `insert_time` from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) order by `id` desc limit 10 offset 0 ["RunTime:0.75ms"] []
[2025-04-09T17:35:41.207035+08:00] sql.INFO: select `id` as `item_id`, `order_id`, `product_id`, `buy_num`, `is_rebate`, `sku_attr_names` as `product_spec`, `product_name`, `product_thumb` from `kailin_orders_product` where `order_id` in (80) ["RunTime:0.89ms"] []
[2025-04-09T17:35:41.208094+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.41ms"] []
[2025-04-09T17:37:10.700049+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.83ms"] []
[2025-04-09T17:37:10.705203+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:0.57ms"] []
[2025-04-09T17:37:10.706676+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.4ms"] []
[2025-04-09T17:37:10.713121+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.42ms"] []
[2025-04-09T17:37:14.092293+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:18.63ms"] []
[2025-04-09T17:37:14.099106+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:0.84ms"] []
[2025-04-09T17:37:14.100590+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.41ms"] []
[2025-04-09T17:37:14.106113+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.32ms"] []
[2025-04-09T17:37:14.403214+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:25.77ms"] []
[2025-04-09T17:37:14.406062+08:00] sql.INFO: select count(*) as aggregate from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) ["RunTime:0.32ms"] []
[2025-04-09T17:37:14.406639+08:00] sql.INFO: select `id`, `pay_total`, `status`, `price_total`, `coupon_total`, `shop_id`, `pay_total`, `weizan_orderid`, `insert_time` from `kailin_orders` where (`custom_uid` = 25 and `shop_id` = 1) order by `id` desc limit 10 offset 0 ["RunTime:0.27ms"] []
[2025-04-09T17:37:14.408012+08:00] sql.INFO: select `id` as `item_id`, `order_id`, `product_id`, `buy_num`, `is_rebate`, `sku_attr_names` as `product_spec`, `product_name`, `product_thumb` from `kailin_orders_product` where `order_id` in (80) ["RunTime:0.3ms"] []
[2025-04-09T17:37:14.408920+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.29ms"] []
[2025-04-09T17:56:24.042635+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.75ms"] []
[2025-04-09T17:56:24.046771+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:0.48ms"] []
[2025-04-09T17:56:24.047713+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.31ms"] []
[2025-04-09T17:56:24.052101+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.48ms"] []
[2025-04-09T17:56:24.839796+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.55ms"] []
[2025-04-09T17:56:24.843291+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:0.5ms"] []
[2025-04-09T17:56:24.850298+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:2.36ms"] []
[2025-04-09T17:56:24.853067+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.34ms"] []
[2025-04-09T17:56:24.855895+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, 1302) group by `product_id`) as `aggregate_table` ["RunTime:0.72ms"] []
[2025-04-09T17:56:24.856769+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, 1302) group by `product_id` order by `kailin_product`.`sort` asc, `kailin_product`.`id` asc limit 10 offset 0 ["RunTime:0.41ms"] []
[2025-04-09T17:56:24.858507+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` <= 1744192584 and `kailin_promo`.`end_time` >= 1744192584 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:0.39ms"] []
[2025-04-09T17:56:24.859174+08:00] sql.INFO: select `id`, `name`, `group`, `weiban_extid`, `staff_id` from `kailin_weiban_tags` where (`weiban_extid` = ) ["RunTime:0.26ms"] []
[2025-04-09T17:56:24.859985+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744192584 and `end_time` >= 1744192584 and `product_id` = 70) limit 1 ["RunTime:0.27ms"] []
[2025-04-09T17:56:24.860941+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744192584 and `end_time` >= 1744192584 and `product_id` = 71) limit 1 ["RunTime:0.46ms"] []
[2025-04-09T17:56:24.862127+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744192584 and `end_time` >= 1744192584 and `product_id` = 72) limit 1 ["RunTime:0.57ms"] []
[2025-04-09T17:56:24.862872+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744192584 and `end_time` >= 1744192584 and `product_id` = 73) limit 1 ["RunTime:0.22ms"] []
[2025-04-09T17:56:28.231628+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.9ms"] []
[2025-04-09T17:56:28.235946+08:00] sql.INFO: select count(*) as aggregate from `kailin_score_product` where (`status` = 0 and `shop_id` = 1) ["RunTime:1.1ms"] []
[2025-04-09T17:56:28.236822+08:00] sql.INFO: select `id`, `name`, `thumb`, `spec`, `score` from `kailin_score_product` where (`status` = 0 and `shop_id` = 1) limit 10 offset 0 ["RunTime:0.26ms"] []
[2025-04-09T17:56:30.683522+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:18.59ms"] []
[2025-04-09T17:56:30.690044+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` <= 1744192590 and `kailin_redpacket`.`end_time` >= 1744192590 and `kailin_redpacket`.`status` = 0) ["RunTime:1.97ms"] []
[2025-04-09T17:56:30.694251+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.88ms"] []
[2025-04-09T17:56:30.699415+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:0.78ms"] []
[2025-04-09T17:56:30.700969+08:00] sql.INFO: select `weiban_extid` from `kailin_weiban_follow` where (`phone_number` = 18819035894) limit 1 ["RunTime:0.34ms"] []
[2025-04-09T17:56:30.704459+08:00] sql.INFO: select `amount`, `transfer_amount` from `kailin_custom_amount` where (`custom_uid` = 25 and `shop_id` = 1) limit 1 ["RunTime:0.33ms"] []
[2025-04-09T17:58:31.369302+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:13.9ms"] []
[2025-04-09T17:58:31.369394+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:18.51ms"] []
[2025-04-09T17:58:31.373649+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:1.04ms"] []
[2025-04-09T17:58:31.374387+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.39ms"] []
[2025-04-09T17:58:31.375828+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` <= 1744192711 and `kailin_promo`.`end_time` >= 1744192711 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:0.29ms"] []
[2025-04-09T17:58:31.376493+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744192711 and `end_time` >= 1744192711 and `product_id` = 70) limit 1 ["RunTime:0.25ms"] []
[2025-04-09T17:58:31.377171+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744192711 and `end_time` >= 1744192711 and `product_id` = 71) limit 1 ["RunTime:0.26ms"] []
[2025-04-09T17:58:31.377837+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744192711 and `end_time` >= 1744192711 and `product_id` = 72) limit 1 ["RunTime:0.29ms"] []
[2025-04-09T17:58:31.379129+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744192711 and `end_time` >= 1744192711 and `product_id` = 73) limit 1 ["RunTime:0.77ms"] []
[2025-04-09T18:03:37.834817+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:23.99ms"] []
[2025-04-09T18:03:37.852507+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:25.9ms"] []
[2025-04-09T18:03:37.857865+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:1.68ms"] []
[2025-04-09T18:03:37.858781+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.44ms"] []
[2025-04-09T18:03:37.862835+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` <= 1744193017 and `kailin_promo`.`end_time` >= 1744193017 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:1.74ms"] []
[2025-04-09T18:03:37.864963+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744193017 and `end_time` >= 1744193017 and `product_id` = 70) limit 1 ["RunTime:1.13ms"] []
[2025-04-09T18:03:37.865814+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744193017 and `end_time` >= 1744193017 and `product_id` = 71) limit 1 ["RunTime:0.34ms"] []
[2025-04-09T18:03:37.866431+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744193017 and `end_time` >= 1744193017 and `product_id` = 72) limit 1 ["RunTime:0.2ms"] []
[2025-04-09T18:03:37.867018+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744193017 and `end_time` >= 1744193017 and `product_id` = 73) limit 1 ["RunTime:0.22ms"] []
[2025-04-09T18:03:40.411104+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` = 71 limit 1 ["RunTime:2ms"] []
[2025-04-09T18:03:40.414362+08:00] sql.INFO: select `city_id` from `kailin_product_city` where (`product_id` = 71) ["RunTime:1.13ms"] []
[2025-04-09T18:03:40.416271+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:0.5ms"] []
[2025-04-09T18:03:40.418950+08:00] sql.INFO: select `id`, `sort`, `thumb` from `kailin_product_photo` where (`product_id` = 71) ["RunTime:0.81ms"] []
[2025-04-09T18:03:40.420007+08:00] sql.INFO: select `id`, `name`, `spec_id`, `product_id`, `thumb`, `remark` from `kailin_product_attr` where (`product_id` = 71) ["RunTime:0.69ms"] []
[2025-04-09T18:03:40.421055+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` = 71) ["RunTime:0.71ms"] []
[2025-04-09T18:03:40.422307+08:00] sql.INFO: select * from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744193020 and `end_time` >= 1744193020 and `product_id` = 71) limit 1 ["RunTime:0.81ms"] []
[2025-04-09T18:03:40.424148+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` <= 1744193020 and `kailin_promo`.`end_time` >= 1744193020 and `kailin_promo_product`.`status` = 0 and `kailin_promo_product`.`product_id` = 71) limit 1 ["RunTime:1.19ms"] []
[2025-04-09T18:03:44.824415+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:1.91ms"] []
[2025-04-09T18:03:44.830557+08:00] sql.INFO: select * from `kailin_shop` where (`status` = 0) ["RunTime:2.68ms"] []
[2025-04-09T18:03:44.838570+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:0.76ms"] []
[2025-04-09T18:03:44.839438+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.39ms"] []
[2025-04-09T18:03:44.841221+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` <= 1744193024 and `kailin_promo`.`end_time` >= 1744193024 and `kailin_promo_product`.`status` = 0) and `kailin_promo_product`.`product_id` in (70, 71, 72, 73, 56) ["RunTime:0.42ms"] []
[2025-04-09T18:03:44.841951+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744193024 and `end_time` >= 1744193024 and `product_id` = 70) limit 1 ["RunTime:0.22ms"] []
[2025-04-09T18:03:44.842728+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744193024 and `end_time` >= 1744193024 and `product_id` = 71) limit 1 ["RunTime:0.39ms"] []
[2025-04-09T18:03:44.843740+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744193024 and `end_time` >= 1744193024 and `product_id` = 72) limit 1 ["RunTime:0.5ms"] []
[2025-04-09T18:03:44.844768+08:00] sql.INFO: select `id` as `active_id`, `number`, `automatic` from `kailin_regiment_active` where (`status` = 1 and `start_time` <= 1744193024 and `end_time` >= 1744193024 and `product_id` = 73) limit 1 ["RunTime:0.44ms"] []