[ SQL ] SHOW COLUMNS FROM `ob_users` [ RunTime:0.006106s ]
[ SQL ] SELECT `id`,`group_id`,`username`,`nickname`,`password`,`mobile`,`email`,`user_img`,`nick_name`,`sex`,`birthday`,`telphone`,`provinces`,`citys`,`area`,`area_path`,`address`,`qq`,`amount`,`status`,`reg_time`,`reg_ip`,`update_time`,`serviceType`,`uname`,`cardId`,`cardHand`,`cardUp`,`cardDown`,`description`,`is_authentication`,`setup_area`,`setup_type`,`setup_num`,`weixin`,`age`,`bankcard`,`bankname`,`bankusername`,`zhifubao`,`zhifubaoname`,`is_lock`,`parentId`,`is_default`,`is_default_city`,`is_base`,`is_base_type`,`inLongitude`,`inLatitude`,`device_tokens` FROM `ob_users` WHERE `citys` = '3201' AND `group_id` = 5 AND `is_default_city` LIKE '%320102%' AND `status` = 0 LIMIT 1 [ RunTime:0.010923s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_users` WHERE `setup_type` LIKE '%tencent:%' AND `group_id` IN (1) AND `is_lock` = 0 AND `citys` = '3201' AND `is_base` = 0 AND `status` = 0 LIMIT 1 [ RunTime:0.159347s ]
[ SQL ] SELECT `id`,`group_id`,`nickname`,`user_img`,`qq`,`mobile`,`area`,`area_path`,`setup_area`,`setup_type`,`setup_num`,`status`,`is_default`,`is_base`,`is_lock`,`is_authentication` FROM `ob_users` WHERE `setup_type` LIKE '%tencent:%' AND `group_id` IN (1) AND `is_lock` = 0 AND `citys` = '3201' AND `is_base` = 0 AND `status` = 0 ORDER BY is_base desc,setup_num desc LIMIT 0,20 [ RunTime:0.334453s ]
[ SQL ] SHOW COLUMNS FROM `ob_users_recommend` [ RunTime:0.004339s ]
[ SQL ] SELECT DISTINCT `uid` FROM `ob_users_recommend` WHERE `citys` = 3201 AND `end_time` > 1766429739 AND `setup_type` LIKE '%tencent:%' AND `status` = 1 [ RunTime:0.007486s ]
[ SQL ] SELECT `id`,`group_id`,`username`,`nickname`,`password`,`mobile`,`email`,`user_img`,`nick_name`,`sex`,`birthday`,`telphone`,`provinces`,`citys`,`area`,`area_path`,`address`,`qq`,`amount`,`status`,`reg_time`,`reg_ip`,`update_time`,`serviceType`,`uname`,`cardId`,`cardHand`,`cardUp`,`cardDown`,`description`,`is_authentication`,`setup_area`,`setup_type`,`setup_num`,`weixin`,`age`,`bankcard`,`bankname`,`bankusername`,`zhifubao`,`zhifubaoname`,`is_lock`,`parentId`,`is_default`,`is_default_city`,`is_base`,`is_base_type`,`inLongitude`,`inLatitude`,`device_tokens` FROM `ob_users` WHERE `id` IN (0) ORDER BY rand() LIMIT 0,10 [ RunTime:0.010556s ]
165 张
