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

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

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

赛事编号  11816
全民皆乒
混合单打800-1449积分赛 比赛冠亚季
混合单打800-1449积分赛第4-5名
  • 第4名 朱金 积分:1381 地区: 未填写
  • 第5名 陆乾 积分:1247 地区: 未填写
  • 第5名 陈冬 积分:1302 地区: 未填写
  • 第5名 臧定 积分:1423 地区: 未填写
  • 第5名 李进 积分:1344 地区: 未填写
(default) 19 queries took 46 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
3SELECT `Opponent`.`id`, `Opponent`.`user_id`, `Opponent`.`contest_id`, `Opponent`.`fullname`, `Opponent`.`number`, `Opponent`.`gender`, `Opponent`.`contact`, `Opponent`.`company`, `Opponent`.`card`, `Opponent`.`dtype`, `Opponent`.`colony_id`, `Opponent`.`colony_name`, `Opponent`.`colony_no`, `Opponent`.`remark`, `Opponent`.`parent_id`, `Opponent`.`is_giveup`, `Opponent`.`score`, `Opponent`.`weight`, `Opponent`.`rank`, `Opponent`.`credit`, `Opponent`.`email`, `Opponent`.`avatar`, `Opponent`.`username`, `Opponent`.`enroll_ranking`, `Opponent`.`created`, `Opponent`.`assign`, `Opponent`.`final_credit`, `Opponent`.`club_id`, `Opponent`.`credit_is_active`, `Opponent`.`nickname`, `Opponent`.`is_single_team` FROM `hpp_game`.`opponents` AS `Opponent` WHERE rank is not null AND `contest_id` = 19614 ORDER BY `rank` asc885
4SELECT `OpponentStage`.`id`, `OpponentStage`.`opponent_id`, `OpponentStage`.`stage`, `OpponentStage`.`group`, `OpponentStage`.`grade`, `OpponentStage`.`serial`, `OpponentStage`.`is_seed`, `OpponentStage`.`is_giveup`, `OpponentStage`.`win`, `OpponentStage`.`lose`, `OpponentStage`.`score`, `OpponentStage`.`rank`, `OpponentStage`.`remark`, `OpponentStage`.`calculate`, `OpponentStage`.`is_outlet`, `OpponentStage`.`seed_reason`, `OpponentStage`.`win_verify`, `OpponentStage`.`lose_verify`, `OpponentStage`.`score_verify`, `OpponentStage`.`draw`, `OpponentStage`.`order` FROM `hpp_game`.`opponent_stages` AS `OpponentStage` WHERE `OpponentStage`.`opponent_id` IN (523501, 523393, 523492, 523401, 523578, 523912, 523929, 523685) 16165
5SELECT `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`.`credits` AS `Credit` WHERE `user_id` = 1118 LIMIT 1112
6SELECT `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`.`credits` AS `Credit` WHERE `user_id` = 153947 LIMIT 1112
7SELECT `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`.`credits` AS `Credit` WHERE `user_id` = 91935 LIMIT 1112
8SELECT `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`.`credits` AS `Credit` WHERE `user_id` = 277259 LIMIT 1112
9SELECT `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`.`credits` AS `Credit` WHERE `user_id` = 154059 LIMIT 1112
10SELECT `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`.`credits` AS `Credit` WHERE `user_id` = 138936 LIMIT 1112
11SELECT `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`.`credits` AS `Credit` WHERE `user_id` = 1312523 LIMIT 1112
12SELECT `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`.`credits` AS `Credit` WHERE `user_id` = 1315486 LIMIT 1112
13SELECT `Profile`.`portrait_image_name`, `Profile`.`portrait_image_path`, `Profile`.`gender`, `Profile`.`user_id` FROM `hpp_game`.`profiles` AS `Profile` WHERE `Profile`.`user_id` IN (1118, 153947, 91935, 277259, 154059, 138936, 1312523, 1315486)883
14SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 11816222
15SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 11816222
16SELECT `PingpongContest`.`id`, `PingpongContest`.`mode`, `PingpongContest`.`category` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE id IN (19614, 19615)222
17SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 11816 AND `Contest`.`status` <> 'cancel'222
18SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` IN (19614, 19615)222
19SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 11816112