乒乓球赛事
1090 人气 13 参赛者 0 照片

2019.9.22快乐乒乓网青岛国亮乒乓球积分赛

青岛市 2019年09月22日-2019年09月22日

赛事编号  12467
全民皆乒
还没有对阵图数据

积分变化
VS

积分变化
(default) 11 queries took 30 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` = 20286 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` = (20286) ORDER BY `Stage`.`serial` ASC 222
3update games set focus = focus + 1 where id=12467114
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` = 36892 ORDER BY `Group`.`stage_id` asc, `Group`.`serial` asc003
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` = 20286 AND `Match`.`stage` = 1 ORDER BY `Match`.`contest_round` asc, `Match`.`number` asc006
6SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 12467112
7SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 12467112
8SELECT `PingpongContest`.`id`, `PingpongContest`.`mode`, `PingpongContest`.`category` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE id = (20286)112
9SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 12467 AND `Contest`.`status` <> 'cancel'112
10SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` = (20286)112
11SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 12467112