乒乓球赛事
3775 人气 39 参赛者 0 照片

苏州全爱俱乐部第七届快乐乒乓网积分赛

苏州市 2018年12月02日-2018年12月02日

赛事编号  11816
全民皆乒

混合单打1450-1799积分赛

姓名 昵称 单位/学校名称 所在城市 积分 联系电话 来源
11 王念科 天涯 苏州市 1623 182*****915 app
12 彭福祥 清洋 苏州市 1481 153*****688 app
13 阿炳 徐文炳 (null) 苏州市 1477 139*****177 app
14 朱刚 13092625558 苏州市 1500
130*****558 app
15 果果 果果 苏州市 1569 182*****672 app
16 徐锋 徐锋 苏州全爱体育发展有限公司 苏州市 1473 159*****296 pc
17 锁永红 锁永红 1472 189*****368 pc
18 张安苏 15258506755 苏州市 1646 152*****755 app
19 陈文松 Cws 苏州市 1500
158*****885 pc
20 於剑秋 於剑秋 苏州市 1500
151*****286 pc

注:未激活表示该运动员未参加过积分赛,参加过一次积分赛后,积分自动激活。

赛事动态

赛事组委会

组织者
徐锋
联系人:
徐锋 (15962616296)
主办方:
全爱体育
协办方:
爱动乒乓
承办方:
爱动乒乓
赞助商:
美格尔橄榄油
(default) 34 queries took 71 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT *, `Contest`.`id` FROM `hpp_game`.`contests` AS `Contest` LEFT JOIN `hpp_game`.`games` AS `Game` ON (`Contest`.`game_id` = `Game`.`id`) LEFT JOIN `hpp_game`.`pingpong_contests` AS `PingpongContest` ON (`PingpongContest`.`id` = `Contest`.`id`) WHERE `Contest`.`id` = 19615 LIMIT 1113
2SELECT `Rule`.`id`, `Rule`.`name`, `Rule`.`contest_id`, `Rule`.`type`, `Rule`.`description`, `Rule`.`expression`, `Rule`.`active`, `Rule`.`apply_to`, `Rule`.`params`, `Rule`.`render`, `Rule`.`options` FROM `hpp_game`.`rules` AS `Rule` WHERE `Rule`.`contest_id` = (19615) 332
3update games set focus = focus + 1 where id=11816114
4SELECT `SignStatisticsLog`.`user_id` FROM `hpp_game`.`sign_statistics_log` AS `SignStatisticsLog` WHERE `SignStatisticsLog`.`contest_id` = 1961519192
5SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 1304356 LIMIT 1112
6SELECT `Enrollment`.`id`, `Enrollment`.`user_id`, `Enrollment`.`contest_id`, `Enrollment`.`participate_role`, `Enrollment`.`status`, `Enrollment`.`created`, `Enrollment`.`group`, `Enrollment`.`is_seed`, `Enrollment`.`serial`, `Enrollment`.`credit`, `Enrollment`.`remark`, `Enrollment`.`dtype2`, `Enrollment`.`colony_id`, `Enrollment`.`colony_name`, `Enrollment`.`colony_no`, `Enrollment`.`serial1`, `Enrollment`.`serial2`, `Enrollment`.`group1`, `Enrollment`.`group2`, `Enrollment`.`realname`, `Enrollment`.`contact`, `Enrollment`.`company`, `Enrollment`.`gender`, `Enrollment`.`member_no`, `Enrollment`.`card`, `Enrollment`.`dtype`, `Enrollment`.`email`, `Enrollment`.`avatar`, `Enrollment`.`city`, `Enrollment`.`club_id`, `Enrollment`.`credit_is_active`, `Enrollment`.`leader_user_id`, `Enrollment`.`leader_user`, `Enrollment`.`nickname`, `Enrollment`.`ip`, `Enrollment`.`enroll_cost`, `Enrollment`.`payment_type`, `Enrollment`.`trade_no`, `Enrollment`.`pay_time`, `Enrollment`.`enroll_type` FROM `hpp_game`.`enrollments` AS `Enrollment` INNER JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `Enrollment`.`user_id`) WHERE `Enrollment`.`contest_id` = 19615 AND `Enrollment`.`participate_role` = 'player' AND `Enrollment`.`status` <> 'canceled' AND `Enrollment`.`status` = 'approve' AND `Enrollment`.`dtype` <> 'single_team' LIMIT 10, 1010102
7SELECT `TeamEnrollment`.`id`, `TeamEnrollment`.`enrollment_id`, `TeamEnrollment`.`user_id`, `TeamEnrollment`.`credit`, `TeamEnrollment`.`realname`, `TeamEnrollment`.`contact`, `TeamEnrollment`.`company`, `TeamEnrollment`.`gender`, `TeamEnrollment`.`card`, `TeamEnrollment`.`participate_role`, `TeamEnrollment`.`status`, `TeamEnrollment`.`email`, `TeamEnrollment`.`avatar`, `TeamEnrollment`.`credit_is_active`, `TeamEnrollment`.`nickname` FROM `hpp_game`.`team_enrollments` AS `TeamEnrollment` WHERE `TeamEnrollment`.`enrollment_id` IN (422367, 422478, 423341, 423377, 422345, 422749, 423351, 422363, 422746, 422522) 002
8SELECT COUNT(*) AS `count` FROM `hpp_game`.`enrollments` AS `Enrollment` INNER JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `Enrollment`.`user_id`) WHERE `Enrollment`.`contest_id` = 19615 AND `Enrollment`.`participate_role` = 'player' AND `Enrollment`.`status` <> 'canceled' AND `Enrollment`.`status` = 'approve' AND `Enrollment`.`dtype` <> 'single_team'112
9SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1236931 LIMIT 1112
10SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1236931 AND `UserRole`.`role_id` = `Role`.`id`) 002
11SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1277263 LIMIT 1112
12SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1277263 AND `UserRole`.`role_id` = `Role`.`id`) 002
13SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1288040 LIMIT 1112
14SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1288040 AND `UserRole`.`role_id` = `Role`.`id`) 002
15SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1288315 LIMIT 1112
16SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1288315 AND `UserRole`.`role_id` = `Role`.`id`) 002
17SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1300710 LIMIT 1112
18SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1300710 AND `UserRole`.`role_id` = `Role`.`id`) 002
19SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1304356 LIMIT 1112
20SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1304356 AND `UserRole`.`role_id` = `Role`.`id`) 112
21SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1308934 LIMIT 1112
22SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1308934 AND `UserRole`.`role_id` = `Role`.`id`) 002
23SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1310600 LIMIT 1112
24SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1310600 AND `UserRole`.`role_id` = `Role`.`id`) 002
25SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1310892 LIMIT 1112
26SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1310892 AND `UserRole`.`role_id` = `Role`.`id`) 002
27SELECT `User`.`id`, `User`.`number`, `User`.`username`, `User`.`password`, `User`.`validation_code`, `User`.`last_login_date`, `User`.`fail_tried`, `User`.`blocked`, `User`.`created`, `User`.`modified`, `User`.`old_psw`, `User`.`last_shop_session_id`, `User`.`last_hs_session_id`, `User`.`lbs_id`, `User`.`location`, `User`.`last_signin_date`, `User`.`source`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`email`, `Profile`.`mobile`, `Profile`.`login_field`, `Profile`.`firstname`, `Profile`.`lastname`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`birthday`, `Profile`.`gender`, `Profile`.`identity_number`, `Profile`.`identity_type`, `Profile`.`id_image_path`, `Profile`.`portrait_image_path`, `Profile`.`zipcode`, `Profile`.`city`, `Profile`.`zone`, `Profile`.`state`, `Profile`.`country`, `Profile`.`address_line1`, `Profile`.`address_line2`, `Profile`.`qq`, `Profile`.`msn`, `Profile`.`job`, `Profile`.`image`, `Profile`.`company`, `Profile`.`school`, `Profile`.`studentID`, `Profile`.`portrait_image_name`, `Profile`.`skype`, `Profile`.`IDCard`, `Profile`.`points`, `Profile`.`card_number`, `Profile`.`fullname`, `Profile`.`avatar_crop_info`, `Profile`.`is_robot`, `Profile`.`is_robot2`, `Profile`.`nickname`, `Profile`.`sportscareer`, `Profile`.`sportscareer_link`, `Profile`.`zhengjian_type`, `Profile`.`zhengjian_number`, `Profile`.`zhiye`, `Profile`.`weixinID`, `Profile`.`mobile_verified`, `Profile`.`skill`, `Profile`.`skill_code`, `Profile`.`email_verified`, `Profile`.`is_app`, `Profile`.`often_appear`, `Profile`.`invite_code`, `Profile`.`invited_user`, `Profile`.`sigin`, `Profile`.`certify_verify`, `Profile`.`unpublish`, `Credit`.`id`, `Credit`.`user_id`, `Credit`.`sport_id`, `Credit`.`amount`, `Credit`.`is_active`, `Credit`.`last_self_testing`, `Credit`.`active_question_count`, `Credit`.`last_amount`, `Credit`.`operator_id`, `Credit`.`fc`, `Credit`.`master_point` FROM `hpp_game`.`users` AS `User` LEFT JOIN `hpp_game`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `hpp_game`.`credits` AS `Credit` ON (`Credit`.`user_id` = `User`.`id` AND `Credit`.`sport_id` = 1) WHERE `User`.`id` = 1313125 LIMIT 1112
28SELECT *, `UserRole`.`id`, `UserRole`.`user_id`, `UserRole`.`role_id`, `UserRole`.`note`, `UserRole`.`created`, `UserRole`.`modified`, `UserRole`.`type` FROM `hpp_game`.`roles` AS `Role` JOIN `hpp_game`.`users_roles` AS `UserRole` ON (`UserRole`.`user_id` = 1313125 AND `UserRole`.`role_id` = `Role`.`id`) 002
29SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 11816 AND NOT (`status` = 'cancel')222
30SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 11816 AND `Contest`.`status` <> 'cancel'222
31SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` IN (19614, 19615)222
32SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 11816112
33SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 11816222
34SELECT `Photo`.`id`, `Photo`.`user_id`, `Photo`.`type_id`, `Photo`.`ex_type_id`, `Photo`.`type`, `Photo`.`url`, `Photo`.`create_time`, `Photo`.`description` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 11816 ORDER BY `Photo`.`create_time` desc LIMIT 10002