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

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

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

赛事编号  11816
全民皆乒

混合单打800-1449积分赛


积分变化
VS

积分变化
(default) 21 queries took 72 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` = 19614 LIMIT 1113
2SELECT `Stage`.`id`, `Stage`.`contest_id`, `Stage`.`scheme`, `Stage`.`serial`, `Stage`.`label`, `Stage`.`start_date`, `Stage`.`end_date`, `Stage`.`start_contest_round`, `Stage`.`end_contest_round`, `Stage`.`is_draw`, `Stage`.`is_group`, `Stage`.`has_pre_level`, `Stage`.`is_ranked_circle`, `Stage`.`default_match_minutes`, `Stage`.`scheduled_group` FROM `hpp_game`.`stages` AS `Stage` WHERE `Stage`.`contest_id` = (19614) ORDER BY `Stage`.`serial` ASC 222
3update games set focus = focus + 1 where id=11816114
4SELECT `Group`.`id`, `Group`.`stage_id`, `Group`.`serial`, `Group`.`grade`, `Group`.`size`, `Group`.`total`, `Group`.`is_set_seed`, `Group`.`is_draw`, `Group`.`rank`, `Group`.`scheme`, `Group`.`circle`, `Group`.`seed_method`, `Group`.`label`, `Group`.`base_rank`, `Group`.`has_pre_level`, `Group`.`scheduled_round`, `Group`.`match_rounds`, `Group`.`mode`, `Group`.`team_scheme`, `Group`.`serial_in_grade`, `Stage`.`id`, `Stage`.`contest_id`, `Stage`.`scheme`, `Stage`.`serial`, `Stage`.`label`, `Stage`.`start_date`, `Stage`.`end_date`, `Stage`.`start_contest_round`, `Stage`.`end_contest_round`, `Stage`.`is_draw`, `Stage`.`is_group`, `Stage`.`has_pre_level`, `Stage`.`is_ranked_circle`, `Stage`.`default_match_minutes`, `Stage`.`scheduled_group` FROM `hpp_game`.`groups` AS `Group` LEFT JOIN `hpp_game`.`stages` AS `Stage` ON (`Group`.`stage_id` = `Stage`.`id`) WHERE `Group`.`stage_id` = 35715 ORDER BY `Group`.`stage_id` asc, `Group`.`serial` asc223
5SELECT `Match`.`id`, `Match`.`number`, `Match`.`contest_id`, `Match`.`venue_id`, `Match`.`status`, `Match`.`scheduled_start_date`, `Match`.`opponent1_id`, `Match`.`opponent2_id`, `Match`.`referee1_id`, `Match`.`referee2_id`, `Match`.`referee3_id`, `Match`.`scheduled_end_date`, `Match`.`group`, `Match`.`group_round`, `Match`.`type`, `Match`.`stage`, `Match`.`label`, `Match`.`placeholder1`, `Match`.`placeholder2`, `Match`.`contest_round`, `Match`.`addition_level`, `Match`.`weight`, `Match`.`dtype`, `Match`.`credit_detail_id`, `Match`.`parent_id`, `Match`.`team_round`, `Match`.`grade`, `Match`.`rounds`, `Match`.`placeholder1_ori`, `Match`.`placeholder2_ori`, `Match`.`home`, `Match`.`opponent1_partner_id`, `Match`.`opponent2_partner_id`, `Match`.`project`, `Match`.`mtype`, `Opponent1`.`id`, `Opponent1`.`user_id`, `Opponent1`.`contest_id`, `Opponent1`.`fullname`, `Opponent1`.`number`, `Opponent1`.`gender`, `Opponent1`.`contact`, `Opponent1`.`company`, `Opponent1`.`card`, `Opponent1`.`dtype`, `Opponent1`.`colony_id`, `Opponent1`.`colony_name`, `Opponent1`.`colony_no`, `Opponent1`.`remark`, `Opponent1`.`parent_id`, `Opponent1`.`is_giveup`, `Opponent1`.`score`, `Opponent1`.`weight`, `Opponent1`.`rank`, `Opponent1`.`credit`, `Opponent1`.`email`, `Opponent1`.`avatar`, `Opponent1`.`username`, `Opponent1`.`enroll_ranking`, `Opponent1`.`created`, `Opponent1`.`assign`, `Opponent1`.`final_credit`, `Opponent1`.`club_id`, `Opponent1`.`credit_is_active`, `Opponent1`.`nickname`, `Opponent1`.`is_single_team`, `Opponent2`.`id`, `Opponent2`.`user_id`, `Opponent2`.`contest_id`, `Opponent2`.`fullname`, `Opponent2`.`number`, `Opponent2`.`gender`, `Opponent2`.`contact`, `Opponent2`.`company`, `Opponent2`.`card`, `Opponent2`.`dtype`, `Opponent2`.`colony_id`, `Opponent2`.`colony_name`, `Opponent2`.`colony_no`, `Opponent2`.`remark`, `Opponent2`.`parent_id`, `Opponent2`.`is_giveup`, `Opponent2`.`score`, `Opponent2`.`weight`, `Opponent2`.`rank`, `Opponent2`.`credit`, `Opponent2`.`email`, `Opponent2`.`avatar`, `Opponent2`.`username`, `Opponent2`.`enroll_ranking`, `Opponent2`.`created`, `Opponent2`.`assign`, `Opponent2`.`final_credit`, `Opponent2`.`club_id`, `Opponent2`.`credit_is_active`, `Opponent2`.`nickname`, `Opponent2`.`is_single_team`, `Opponent1Partner`.`id`, `Opponent1Partner`.`user_id`, `Opponent1Partner`.`contest_id`, `Opponent1Partner`.`fullname`, `Opponent1Partner`.`number`, `Opponent1Partner`.`gender`, `Opponent1Partner`.`contact`, `Opponent1Partner`.`company`, `Opponent1Partner`.`card`, `Opponent1Partner`.`dtype`, `Opponent1Partner`.`colony_id`, `Opponent1Partner`.`colony_name`, `Opponent1Partner`.`colony_no`, `Opponent1Partner`.`remark`, `Opponent1Partner`.`parent_id`, `Opponent1Partner`.`is_giveup`, `Opponent1Partner`.`score`, `Opponent1Partner`.`weight`, `Opponent1Partner`.`rank`, `Opponent1Partner`.`credit`, `Opponent1Partner`.`email`, `Opponent1Partner`.`avatar`, `Opponent1Partner`.`username`, `Opponent1Partner`.`enroll_ranking`, `Opponent1Partner`.`created`, `Opponent1Partner`.`assign`, `Opponent1Partner`.`final_credit`, `Opponent1Partner`.`club_id`, `Opponent1Partner`.`credit_is_active`, `Opponent1Partner`.`nickname`, `Opponent1Partner`.`is_single_team`, `Opponent2Partner`.`id`, `Opponent2Partner`.`user_id`, `Opponent2Partner`.`contest_id`, `Opponent2Partner`.`fullname`, `Opponent2Partner`.`number`, `Opponent2Partner`.`gender`, `Opponent2Partner`.`contact`, `Opponent2Partner`.`company`, `Opponent2Partner`.`card`, `Opponent2Partner`.`dtype`, `Opponent2Partner`.`colony_id`, `Opponent2Partner`.`colony_name`, `Opponent2Partner`.`colony_no`, `Opponent2Partner`.`remark`, `Opponent2Partner`.`parent_id`, `Opponent2Partner`.`is_giveup`, `Opponent2Partner`.`score`, `Opponent2Partner`.`weight`, `Opponent2Partner`.`rank`, `Opponent2Partner`.`credit`, `Opponent2Partner`.`email`, `Opponent2Partner`.`avatar`, `Opponent2Partner`.`username`, `Opponent2Partner`.`enroll_ranking`, `Opponent2Partner`.`created`, `Opponent2Partner`.`assign`, `Opponent2Partner`.`final_credit`, `Opponent2Partner`.`club_id`, `Opponent2Partner`.`credit_is_active`, `Opponent2Partner`.`nickname`, `Opponent2Partner`.`is_single_team`, `OpponentStage1`.`id`, `OpponentStage1`.`opponent_id`, `OpponentStage1`.`stage`, `OpponentStage1`.`group`, `OpponentStage1`.`grade`, `OpponentStage1`.`serial`, `OpponentStage1`.`is_seed`, `OpponentStage1`.`is_giveup`, `OpponentStage1`.`win`, `OpponentStage1`.`lose`, `OpponentStage1`.`score`, `OpponentStage1`.`rank`, `OpponentStage1`.`remark`, `OpponentStage1`.`calculate`, `OpponentStage1`.`is_outlet`, `OpponentStage1`.`seed_reason`, `OpponentStage1`.`win_verify`, `OpponentStage1`.`lose_verify`, `OpponentStage1`.`score_verify`, `OpponentStage1`.`draw`, `OpponentStage1`.`order`, `OpponentStage2`.`id`, `OpponentStage2`.`opponent_id`, `OpponentStage2`.`stage`, `OpponentStage2`.`group`, `OpponentStage2`.`grade`, `OpponentStage2`.`serial`, `OpponentStage2`.`is_seed`, `OpponentStage2`.`is_giveup`, `OpponentStage2`.`win`, `OpponentStage2`.`lose`, `OpponentStage2`.`score`, `OpponentStage2`.`rank`, `OpponentStage2`.`remark`, `OpponentStage2`.`calculate`, `OpponentStage2`.`is_outlet`, `OpponentStage2`.`seed_reason`, `OpponentStage2`.`win_verify`, `OpponentStage2`.`lose_verify`, `OpponentStage2`.`score_verify`, `OpponentStage2`.`draw`, `OpponentStage2`.`order`, `Venue`.`id`, `Venue`.`number`, `Venue`.`location`, `Venue`.`contest_id`, `Venue`.`serial`, `MatchResult`.`id`, `MatchResult`.`match_id`, `MatchResult`.`opponent1_final_score`, `MatchResult`.`opponent2_final_score`, `MatchResult`.`winner_opponent_id`, `MatchResult`.`loser_opponent_id`, `MatchResult`.`is_giveup_1`, `MatchResult`.`is_giveup_2`, `MatchResult`.`is_counted`, `MatchResult`.`time` FROM `hpp_game`.`matches` AS `Match` LEFT JOIN `hpp_game`.`opponents` AS `Opponent1` ON (`Match`.`opponent1_id` = `Opponent1`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2` ON (`Match`.`opponent2_id` = `Opponent2`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent1Partner` ON (`Match`.`opponent1_partner_id` = `Opponent1Partner`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2Partner` ON (`Match`.`opponent2_partner_id` = `Opponent2Partner`.`id`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage1` ON (`Opponent1`.`id` = `OpponentStage1`.`opponent_id` AND `OpponentStage1`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage2` ON (`Opponent2`.`id` = `OpponentStage2`.`opponent_id` AND `OpponentStage2`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`venues` AS `Venue` ON (`Match`.`venue_id` = `Venue`.`id`) LEFT JOIN `hpp_game`.`match_results` AS `MatchResult` ON (`MatchResult`.`match_id` = `Match`.`id`) WHERE `Match`.`contest_id` = 19614 AND `Match`.`stage` = 0 AND `Match`.`type` = 0 AND `Match`.`group` = 1 ORDER BY `Match`.`group` asc, `Match`.`number` asc363611
6SELECT `MatchResultDetail`.`id`, `MatchResultDetail`.`match_result_id`, `MatchResultDetail`.`description`, `MatchResultDetail`.`stage_name`, `MatchResultDetail`.`opponent1_score`, `MatchResultDetail`.`opponent2_score`, `MatchResultDetail`.`stage_winner` FROM `hpp_game`.`match_result_details` AS `MatchResultDetail` WHERE `MatchResultDetail`.`match_result_id` IN (798249, 798242, 798252, 798255, 798182, 798247, 798240, 798250, 798181, 798263, 798245, 798238, 798179, 798260, 798258, 798236, 798177, 798256, 798253, 798243, 798176, 798251, 798241, 798248, 798175, 798239, 798246, 798264, 798174, 798244, 798261, 798262, 798173, 798254, 798257, 798259) ORDER BY `MatchResultDetail`.`id` asc80804
7SELECT `Match`.`id`, `Match`.`number`, `Match`.`contest_id`, `Match`.`venue_id`, `Match`.`status`, `Match`.`scheduled_start_date`, `Match`.`opponent1_id`, `Match`.`opponent2_id`, `Match`.`referee1_id`, `Match`.`referee2_id`, `Match`.`referee3_id`, `Match`.`scheduled_end_date`, `Match`.`group`, `Match`.`group_round`, `Match`.`type`, `Match`.`stage`, `Match`.`label`, `Match`.`placeholder1`, `Match`.`placeholder2`, `Match`.`contest_round`, `Match`.`addition_level`, `Match`.`weight`, `Match`.`dtype`, `Match`.`credit_detail_id`, `Match`.`parent_id`, `Match`.`team_round`, `Match`.`grade`, `Match`.`rounds`, `Match`.`placeholder1_ori`, `Match`.`placeholder2_ori`, `Match`.`home`, `Match`.`opponent1_partner_id`, `Match`.`opponent2_partner_id`, `Match`.`project`, `Match`.`mtype`, `Opponent1`.`id`, `Opponent1`.`user_id`, `Opponent1`.`contest_id`, `Opponent1`.`fullname`, `Opponent1`.`number`, `Opponent1`.`gender`, `Opponent1`.`contact`, `Opponent1`.`company`, `Opponent1`.`card`, `Opponent1`.`dtype`, `Opponent1`.`colony_id`, `Opponent1`.`colony_name`, `Opponent1`.`colony_no`, `Opponent1`.`remark`, `Opponent1`.`parent_id`, `Opponent1`.`is_giveup`, `Opponent1`.`score`, `Opponent1`.`weight`, `Opponent1`.`rank`, `Opponent1`.`credit`, `Opponent1`.`email`, `Opponent1`.`avatar`, `Opponent1`.`username`, `Opponent1`.`enroll_ranking`, `Opponent1`.`created`, `Opponent1`.`assign`, `Opponent1`.`final_credit`, `Opponent1`.`club_id`, `Opponent1`.`credit_is_active`, `Opponent1`.`nickname`, `Opponent1`.`is_single_team`, `Opponent2`.`id`, `Opponent2`.`user_id`, `Opponent2`.`contest_id`, `Opponent2`.`fullname`, `Opponent2`.`number`, `Opponent2`.`gender`, `Opponent2`.`contact`, `Opponent2`.`company`, `Opponent2`.`card`, `Opponent2`.`dtype`, `Opponent2`.`colony_id`, `Opponent2`.`colony_name`, `Opponent2`.`colony_no`, `Opponent2`.`remark`, `Opponent2`.`parent_id`, `Opponent2`.`is_giveup`, `Opponent2`.`score`, `Opponent2`.`weight`, `Opponent2`.`rank`, `Opponent2`.`credit`, `Opponent2`.`email`, `Opponent2`.`avatar`, `Opponent2`.`username`, `Opponent2`.`enroll_ranking`, `Opponent2`.`created`, `Opponent2`.`assign`, `Opponent2`.`final_credit`, `Opponent2`.`club_id`, `Opponent2`.`credit_is_active`, `Opponent2`.`nickname`, `Opponent2`.`is_single_team`, `Opponent1Partner`.`id`, `Opponent1Partner`.`user_id`, `Opponent1Partner`.`contest_id`, `Opponent1Partner`.`fullname`, `Opponent1Partner`.`number`, `Opponent1Partner`.`gender`, `Opponent1Partner`.`contact`, `Opponent1Partner`.`company`, `Opponent1Partner`.`card`, `Opponent1Partner`.`dtype`, `Opponent1Partner`.`colony_id`, `Opponent1Partner`.`colony_name`, `Opponent1Partner`.`colony_no`, `Opponent1Partner`.`remark`, `Opponent1Partner`.`parent_id`, `Opponent1Partner`.`is_giveup`, `Opponent1Partner`.`score`, `Opponent1Partner`.`weight`, `Opponent1Partner`.`rank`, `Opponent1Partner`.`credit`, `Opponent1Partner`.`email`, `Opponent1Partner`.`avatar`, `Opponent1Partner`.`username`, `Opponent1Partner`.`enroll_ranking`, `Opponent1Partner`.`created`, `Opponent1Partner`.`assign`, `Opponent1Partner`.`final_credit`, `Opponent1Partner`.`club_id`, `Opponent1Partner`.`credit_is_active`, `Opponent1Partner`.`nickname`, `Opponent1Partner`.`is_single_team`, `Opponent2Partner`.`id`, `Opponent2Partner`.`user_id`, `Opponent2Partner`.`contest_id`, `Opponent2Partner`.`fullname`, `Opponent2Partner`.`number`, `Opponent2Partner`.`gender`, `Opponent2Partner`.`contact`, `Opponent2Partner`.`company`, `Opponent2Partner`.`card`, `Opponent2Partner`.`dtype`, `Opponent2Partner`.`colony_id`, `Opponent2Partner`.`colony_name`, `Opponent2Partner`.`colony_no`, `Opponent2Partner`.`remark`, `Opponent2Partner`.`parent_id`, `Opponent2Partner`.`is_giveup`, `Opponent2Partner`.`score`, `Opponent2Partner`.`weight`, `Opponent2Partner`.`rank`, `Opponent2Partner`.`credit`, `Opponent2Partner`.`email`, `Opponent2Partner`.`avatar`, `Opponent2Partner`.`username`, `Opponent2Partner`.`enroll_ranking`, `Opponent2Partner`.`created`, `Opponent2Partner`.`assign`, `Opponent2Partner`.`final_credit`, `Opponent2Partner`.`club_id`, `Opponent2Partner`.`credit_is_active`, `Opponent2Partner`.`nickname`, `Opponent2Partner`.`is_single_team`, `OpponentStage1`.`id`, `OpponentStage1`.`opponent_id`, `OpponentStage1`.`stage`, `OpponentStage1`.`group`, `OpponentStage1`.`grade`, `OpponentStage1`.`serial`, `OpponentStage1`.`is_seed`, `OpponentStage1`.`is_giveup`, `OpponentStage1`.`win`, `OpponentStage1`.`lose`, `OpponentStage1`.`score`, `OpponentStage1`.`rank`, `OpponentStage1`.`remark`, `OpponentStage1`.`calculate`, `OpponentStage1`.`is_outlet`, `OpponentStage1`.`seed_reason`, `OpponentStage1`.`win_verify`, `OpponentStage1`.`lose_verify`, `OpponentStage1`.`score_verify`, `OpponentStage1`.`draw`, `OpponentStage1`.`order`, `OpponentStage2`.`id`, `OpponentStage2`.`opponent_id`, `OpponentStage2`.`stage`, `OpponentStage2`.`group`, `OpponentStage2`.`grade`, `OpponentStage2`.`serial`, `OpponentStage2`.`is_seed`, `OpponentStage2`.`is_giveup`, `OpponentStage2`.`win`, `OpponentStage2`.`lose`, `OpponentStage2`.`score`, `OpponentStage2`.`rank`, `OpponentStage2`.`remark`, `OpponentStage2`.`calculate`, `OpponentStage2`.`is_outlet`, `OpponentStage2`.`seed_reason`, `OpponentStage2`.`win_verify`, `OpponentStage2`.`lose_verify`, `OpponentStage2`.`score_verify`, `OpponentStage2`.`draw`, `OpponentStage2`.`order`, `Venue`.`id`, `Venue`.`number`, `Venue`.`location`, `Venue`.`contest_id`, `Venue`.`serial`, `MatchResult`.`id`, `MatchResult`.`match_id`, `MatchResult`.`opponent1_final_score`, `MatchResult`.`opponent2_final_score`, `MatchResult`.`winner_opponent_id`, `MatchResult`.`loser_opponent_id`, `MatchResult`.`is_giveup_1`, `MatchResult`.`is_giveup_2`, `MatchResult`.`is_counted`, `MatchResult`.`time` FROM `hpp_game`.`matches` AS `Match` LEFT JOIN `hpp_game`.`opponents` AS `Opponent1` ON (`Match`.`opponent1_id` = `Opponent1`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2` ON (`Match`.`opponent2_id` = `Opponent2`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent1Partner` ON (`Match`.`opponent1_partner_id` = `Opponent1Partner`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2Partner` ON (`Match`.`opponent2_partner_id` = `Opponent2Partner`.`id`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage1` ON (`Opponent1`.`id` = `OpponentStage1`.`opponent_id` AND `OpponentStage1`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage2` ON (`Opponent2`.`id` = `OpponentStage2`.`opponent_id` AND `OpponentStage2`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`venues` AS `Venue` ON (`Match`.`venue_id` = `Venue`.`id`) LEFT JOIN `hpp_game`.`match_results` AS `MatchResult` ON (`MatchResult`.`match_id` = `Match`.`id`) WHERE `Match`.`contest_id` = 19614 AND `Match`.`stage` = 0 AND `Match`.`type` = 0 AND `Match`.`group` = 2 ORDER BY `Match`.`group` asc, `Match`.`number` asc363610
8SELECT `MatchResultDetail`.`id`, `MatchResultDetail`.`match_result_id`, `MatchResultDetail`.`description`, `MatchResultDetail`.`stage_name`, `MatchResultDetail`.`opponent1_score`, `MatchResultDetail`.`opponent2_score`, `MatchResultDetail`.`stage_winner` FROM `hpp_game`.`match_result_details` AS `MatchResultDetail` WHERE `MatchResultDetail`.`match_result_id` IN (798191, 798277, 798280, 798284, 798271, 798189, 798275, 798278, 798270, 798291, 798187, 798273, 798269, 798288, 798283, 798185, 798268, 798285, 798281, 798272, 798267, 798279, 798276, 798190, 798266, 798274, 798188, 798292, 798265, 798186, 798289, 798290, 798184, 798282, 798286, 798287) ORDER BY `MatchResultDetail`.`id` asc82823
9SELECT `Match`.`id`, `Match`.`number`, `Match`.`contest_id`, `Match`.`venue_id`, `Match`.`status`, `Match`.`scheduled_start_date`, `Match`.`opponent1_id`, `Match`.`opponent2_id`, `Match`.`referee1_id`, `Match`.`referee2_id`, `Match`.`referee3_id`, `Match`.`scheduled_end_date`, `Match`.`group`, `Match`.`group_round`, `Match`.`type`, `Match`.`stage`, `Match`.`label`, `Match`.`placeholder1`, `Match`.`placeholder2`, `Match`.`contest_round`, `Match`.`addition_level`, `Match`.`weight`, `Match`.`dtype`, `Match`.`credit_detail_id`, `Match`.`parent_id`, `Match`.`team_round`, `Match`.`grade`, `Match`.`rounds`, `Match`.`placeholder1_ori`, `Match`.`placeholder2_ori`, `Match`.`home`, `Match`.`opponent1_partner_id`, `Match`.`opponent2_partner_id`, `Match`.`project`, `Match`.`mtype`, `Opponent1`.`id`, `Opponent1`.`user_id`, `Opponent1`.`contest_id`, `Opponent1`.`fullname`, `Opponent1`.`number`, `Opponent1`.`gender`, `Opponent1`.`contact`, `Opponent1`.`company`, `Opponent1`.`card`, `Opponent1`.`dtype`, `Opponent1`.`colony_id`, `Opponent1`.`colony_name`, `Opponent1`.`colony_no`, `Opponent1`.`remark`, `Opponent1`.`parent_id`, `Opponent1`.`is_giveup`, `Opponent1`.`score`, `Opponent1`.`weight`, `Opponent1`.`rank`, `Opponent1`.`credit`, `Opponent1`.`email`, `Opponent1`.`avatar`, `Opponent1`.`username`, `Opponent1`.`enroll_ranking`, `Opponent1`.`created`, `Opponent1`.`assign`, `Opponent1`.`final_credit`, `Opponent1`.`club_id`, `Opponent1`.`credit_is_active`, `Opponent1`.`nickname`, `Opponent1`.`is_single_team`, `Opponent2`.`id`, `Opponent2`.`user_id`, `Opponent2`.`contest_id`, `Opponent2`.`fullname`, `Opponent2`.`number`, `Opponent2`.`gender`, `Opponent2`.`contact`, `Opponent2`.`company`, `Opponent2`.`card`, `Opponent2`.`dtype`, `Opponent2`.`colony_id`, `Opponent2`.`colony_name`, `Opponent2`.`colony_no`, `Opponent2`.`remark`, `Opponent2`.`parent_id`, `Opponent2`.`is_giveup`, `Opponent2`.`score`, `Opponent2`.`weight`, `Opponent2`.`rank`, `Opponent2`.`credit`, `Opponent2`.`email`, `Opponent2`.`avatar`, `Opponent2`.`username`, `Opponent2`.`enroll_ranking`, `Opponent2`.`created`, `Opponent2`.`assign`, `Opponent2`.`final_credit`, `Opponent2`.`club_id`, `Opponent2`.`credit_is_active`, `Opponent2`.`nickname`, `Opponent2`.`is_single_team`, `Opponent1Partner`.`id`, `Opponent1Partner`.`user_id`, `Opponent1Partner`.`contest_id`, `Opponent1Partner`.`fullname`, `Opponent1Partner`.`number`, `Opponent1Partner`.`gender`, `Opponent1Partner`.`contact`, `Opponent1Partner`.`company`, `Opponent1Partner`.`card`, `Opponent1Partner`.`dtype`, `Opponent1Partner`.`colony_id`, `Opponent1Partner`.`colony_name`, `Opponent1Partner`.`colony_no`, `Opponent1Partner`.`remark`, `Opponent1Partner`.`parent_id`, `Opponent1Partner`.`is_giveup`, `Opponent1Partner`.`score`, `Opponent1Partner`.`weight`, `Opponent1Partner`.`rank`, `Opponent1Partner`.`credit`, `Opponent1Partner`.`email`, `Opponent1Partner`.`avatar`, `Opponent1Partner`.`username`, `Opponent1Partner`.`enroll_ranking`, `Opponent1Partner`.`created`, `Opponent1Partner`.`assign`, `Opponent1Partner`.`final_credit`, `Opponent1Partner`.`club_id`, `Opponent1Partner`.`credit_is_active`, `Opponent1Partner`.`nickname`, `Opponent1Partner`.`is_single_team`, `Opponent2Partner`.`id`, `Opponent2Partner`.`user_id`, `Opponent2Partner`.`contest_id`, `Opponent2Partner`.`fullname`, `Opponent2Partner`.`number`, `Opponent2Partner`.`gender`, `Opponent2Partner`.`contact`, `Opponent2Partner`.`company`, `Opponent2Partner`.`card`, `Opponent2Partner`.`dtype`, `Opponent2Partner`.`colony_id`, `Opponent2Partner`.`colony_name`, `Opponent2Partner`.`colony_no`, `Opponent2Partner`.`remark`, `Opponent2Partner`.`parent_id`, `Opponent2Partner`.`is_giveup`, `Opponent2Partner`.`score`, `Opponent2Partner`.`weight`, `Opponent2Partner`.`rank`, `Opponent2Partner`.`credit`, `Opponent2Partner`.`email`, `Opponent2Partner`.`avatar`, `Opponent2Partner`.`username`, `Opponent2Partner`.`enroll_ranking`, `Opponent2Partner`.`created`, `Opponent2Partner`.`assign`, `Opponent2Partner`.`final_credit`, `Opponent2Partner`.`club_id`, `Opponent2Partner`.`credit_is_active`, `Opponent2Partner`.`nickname`, `Opponent2Partner`.`is_single_team`, `OpponentStage1`.`id`, `OpponentStage1`.`opponent_id`, `OpponentStage1`.`stage`, `OpponentStage1`.`group`, `OpponentStage1`.`grade`, `OpponentStage1`.`serial`, `OpponentStage1`.`is_seed`, `OpponentStage1`.`is_giveup`, `OpponentStage1`.`win`, `OpponentStage1`.`lose`, `OpponentStage1`.`score`, `OpponentStage1`.`rank`, `OpponentStage1`.`remark`, `OpponentStage1`.`calculate`, `OpponentStage1`.`is_outlet`, `OpponentStage1`.`seed_reason`, `OpponentStage1`.`win_verify`, `OpponentStage1`.`lose_verify`, `OpponentStage1`.`score_verify`, `OpponentStage1`.`draw`, `OpponentStage1`.`order`, `OpponentStage2`.`id`, `OpponentStage2`.`opponent_id`, `OpponentStage2`.`stage`, `OpponentStage2`.`group`, `OpponentStage2`.`grade`, `OpponentStage2`.`serial`, `OpponentStage2`.`is_seed`, `OpponentStage2`.`is_giveup`, `OpponentStage2`.`win`, `OpponentStage2`.`lose`, `OpponentStage2`.`score`, `OpponentStage2`.`rank`, `OpponentStage2`.`remark`, `OpponentStage2`.`calculate`, `OpponentStage2`.`is_outlet`, `OpponentStage2`.`seed_reason`, `OpponentStage2`.`win_verify`, `OpponentStage2`.`lose_verify`, `OpponentStage2`.`score_verify`, `OpponentStage2`.`draw`, `OpponentStage2`.`order`, `Venue`.`id`, `Venue`.`number`, `Venue`.`location`, `Venue`.`contest_id`, `Venue`.`serial`, `MatchResult`.`id`, `MatchResult`.`match_id`, `MatchResult`.`opponent1_final_score`, `MatchResult`.`opponent2_final_score`, `MatchResult`.`winner_opponent_id`, `MatchResult`.`loser_opponent_id`, `MatchResult`.`is_giveup_1`, `MatchResult`.`is_giveup_2`, `MatchResult`.`is_counted`, `MatchResult`.`time` FROM `hpp_game`.`matches` AS `Match` LEFT JOIN `hpp_game`.`opponents` AS `Opponent1` ON (`Match`.`opponent1_id` = `Opponent1`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2` ON (`Match`.`opponent2_id` = `Opponent2`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent1Partner` ON (`Match`.`opponent1_partner_id` = `Opponent1Partner`.`id`) LEFT JOIN `hpp_game`.`opponents` AS `Opponent2Partner` ON (`Match`.`opponent2_partner_id` = `Opponent2Partner`.`id`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage1` ON (`Opponent1`.`id` = `OpponentStage1`.`opponent_id` AND `OpponentStage1`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`opponent_stages` AS `OpponentStage2` ON (`Opponent2`.`id` = `OpponentStage2`.`opponent_id` AND `OpponentStage2`.`stage` = `Match`.`stage`) LEFT JOIN `hpp_game`.`venues` AS `Venue` ON (`Match`.`venue_id` = `Venue`.`id`) LEFT JOIN `hpp_game`.`match_results` AS `MatchResult` ON (`MatchResult`.`match_id` = `Match`.`id`) WHERE `Match`.`contest_id` = 19614 AND `Match`.`stage` = 1 ORDER BY `Match`.`contest_round` asc, `Match`.`number` asc886
10SELECT `MatchResultDetail`.`id`, `MatchResultDetail`.`match_result_id`, `MatchResultDetail`.`description`, `MatchResultDetail`.`stage_name`, `MatchResultDetail`.`opponent1_score`, `MatchResultDetail`.`opponent2_score`, `MatchResultDetail`.`stage_winner` FROM `hpp_game`.`match_result_details` AS `MatchResultDetail` WHERE `MatchResultDetail`.`match_result_id` IN (798293, 798294, 798295, 798296, 798297, 798298, 798299, 798300) ORDER BY `MatchResultDetail`.`id` asc24243
11SELECT `Group`.`id`, `Group`.`stage_id`, `Group`.`serial`, `Group`.`grade`, `Group`.`size`, `Group`.`total`, `Group`.`is_set_seed`, `Group`.`is_draw`, `Group`.`rank`, `Group`.`scheme`, `Group`.`circle`, `Group`.`seed_method`, `Group`.`label`, `Group`.`base_rank`, `Group`.`has_pre_level`, `Group`.`scheduled_round`, `Group`.`match_rounds`, `Group`.`mode`, `Group`.`team_scheme`, `Group`.`serial_in_grade` FROM `hpp_game`.`groups` AS `Group` WHERE `stage_id` = 35716 AND `serial` = 1 ORDER BY `Group`.`stage_id` asc, `Group`.`serial` asc LIMIT 1112
12SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 11816222
13SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 11816222
14SELECT `PingpongContest`.`id`, `PingpongContest`.`mode`, `PingpongContest`.`category` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE id IN (19614, 19615)222
15SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 11816 AND `Contest`.`status` <> 'cancel'222
16SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` IN (19614, 19615)222
17SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 11816112
18SELECT `Group`.`id`, `Group`.`stage_id`, `Group`.`serial`, `Group`.`grade`, `Group`.`size`, `Group`.`total`, `Group`.`is_set_seed`, `Group`.`is_draw`, `Group`.`rank`, `Group`.`scheme`, `Group`.`circle`, `Group`.`seed_method`, `Group`.`label`, `Group`.`base_rank`, `Group`.`has_pre_level`, `Group`.`scheduled_round`, `Group`.`match_rounds`, `Group`.`mode`, `Group`.`team_scheme`, `Group`.`serial_in_grade`, `Stage`.`id`, `Stage`.`contest_id`, `Stage`.`scheme`, `Stage`.`serial`, `Stage`.`label`, `Stage`.`start_date`, `Stage`.`end_date`, `Stage`.`start_contest_round`, `Stage`.`end_contest_round`, `Stage`.`is_draw`, `Stage`.`is_group`, `Stage`.`has_pre_level`, `Stage`.`is_ranked_circle`, `Stage`.`default_match_minutes`, `Stage`.`scheduled_group` FROM `hpp_game`.`groups` AS `Group` LEFT JOIN `hpp_game`.`stages` AS `Stage` ON (`Group`.`stage_id` = `Stage`.`id`) WHERE `Group`.`stage_id` = 35716 AND `Group`.`serial` = 1 ORDER BY `Group`.`stage_id` asc, `Group`.`serial` asc LIMIT 1113
19SELECT count(`Group`.`id`) as total FROM `hpp_game`.`groups` AS `Group` WHERE `Group`.`stage_id` = 35715 GROUP BY `Group`.`grade` ORDER BY `Group`.`grade` asc112
20SELECT count(`Group`.`id`) as total FROM `hpp_game`.`groups` AS `Group` WHERE `Group`.`stage_id` = 35716 GROUP BY `Group`.`grade` ORDER BY `Group`.`grade` asc112
21SELECT `Group`.`id`, `Group`.`stage_id`, `Group`.`serial`, `Group`.`grade`, `Group`.`size`, `Group`.`total`, `Group`.`is_set_seed`, `Group`.`is_draw`, `Group`.`rank`, `Group`.`scheme`, `Group`.`circle`, `Group`.`seed_method`, `Group`.`label`, `Group`.`base_rank`, `Group`.`has_pre_level`, `Group`.`scheduled_round`, `Group`.`match_rounds`, `Group`.`mode`, `Group`.`team_scheme`, `Group`.`serial_in_grade`, `Stage`.`id`, `Stage`.`contest_id`, `Stage`.`scheme`, `Stage`.`serial`, `Stage`.`label`, `Stage`.`start_date`, `Stage`.`end_date`, `Stage`.`start_contest_round`, `Stage`.`end_contest_round`, `Stage`.`is_draw`, `Stage`.`is_group`, `Stage`.`has_pre_level`, `Stage`.`is_ranked_circle`, `Stage`.`default_match_minutes`, `Stage`.`scheduled_group` FROM `hpp_game`.`groups` AS `Group` LEFT JOIN `hpp_game`.`stages` AS `Stage` ON (`Group`.`stage_id` = `Stage`.`id`) WHERE `Group`.`stage_id` = 35716 AND `Group`.`serial` = 1 ORDER BY `Group`.`stage_id` asc, `Group`.`serial` asc LIMIT 1112