SHOW FULL COLUMNS FROM `users` [ RunTime:0.000659s ]
SELECT `u`.`id`,`u`.`name`,`u`.`phone`,`u`.`status`,`u`.`redline`,`u`.`grade`,`u`.`grade_expire_time`,`u`.`grade_hn`,`u`.`hn_money`,`u`.`wxnotice`,`u`.`wxopenid`,`u`.`authentication_num`,`u`.`msg_auth`,`u`.`time_rz`,`u`.`email_code_time`,`u`.`create_time`,`u`.`login_time`,`u`.`login_ip`,`u`.`login_city`,`u`.`inviterId`,l.id as listId,l.status as listStatus,`l`.`sex`,`l`.`picture`,`l`.`hide_picture` FROM `users` `u` LEFT JOIN `lists` `l` ON `u`.`id`=`l`.`createrId` WHERE `u`.`id` = '' LIMIT 1 [ RunTime:0.000442s ]
SHOW FULL COLUMNS FROM `address` [ RunTime:0.000395s ]
SELECT * FROM `address` WHERE `p` = 'xian' LIMIT 1 [ RunTime:0.000370s ]
SELECT * FROM `address` WHERE `p` IS NOT NULL AND `f` = 610100 [ RunTime:0.001129s ]
SELECT `u`.`id`,`u`.`name`,`u`.`phone`,`u`.`status`,`u`.`redline`,`u`.`grade`,`u`.`grade_expire_time`,`u`.`grade_hn`,`u`.`hn_money`,`u`.`wxnotice`,`u`.`wxopenid`,`u`.`authentication_num`,`u`.`msg_auth`,`u`.`time_rz`,`u`.`email_code_time`,`u`.`create_time`,`u`.`login_time`,`u`.`login_ip`,`u`.`login_city`,`u`.`inviterId`,l.id as listId,l.status as listStatus,`l`.`sex`,`l`.`picture`,`l`.`hide_picture` FROM `users` `u` LEFT JOIN `lists` `l` ON `u`.`id`=`l`.`createrId` WHERE `u`.`id` = '' LIMIT 1 [ RunTime:0.000434s ]
SHOW FULL COLUMNS FROM `activity_sign` [ RunTime:0.000622s ]
SELECT `s`.*,`l`.`id`,`l`.`name`,`l`.`picture`,`l`.`hide_picture`,`l`.`province`,`l`.`city`,`l`.`district`,`l`.`health` FROM `activity_sign` `s` INNER JOIN `lists` `l` ON `s`.`listId`=`l`.`id` WHERE `s`.`activityId` = '2' AND `s`.`approve` = '1' AND `l`.`status` = '1' ORDER BY `s`.`time` ASC [ RunTime:0.000576s ]
SHOW FULL COLUMNS FROM `activity_list` [ RunTime:0.000585s ]
SELECT * FROM `activity_list` WHERE `status` > 0 AND `activity_id` = 2 LIMIT 10 [ RunTime:0.000386s ]
