乒乓球赛事
4242 人气 40 参赛者 0 照片

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

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

赛事编号  11876
全民皆乒
名次 姓名 参赛前积分 参赛后积分 积分变化
1沈卫东15941634+40
2张安苏16511645-6
3韩雨佳15631602+39
4郑杰文15001552+52
5可儿俊二郎15951584-11
5王念科16241614-10
5施鸿16321640+8
5果果15771583+6
9徐锋14601454-6
9陈宸15541559+5
9戴玉祥15501560+10
9卞梁峰14841476-8
9阿炳14711485+14
9薛峰15631553-10
9毕潇平15571529-28
9胡超15141505-9
小杰14521439-13
周建14801462-18
吴忠利15001477-23
丁杰14621445-17
(default) 9 queries took 24 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` = 19677 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` = (19677) ORDER BY `Stage`.`serial` ASC 223
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 `Opponent`.`contest_id` = 19677 ORDER BY `Opponent`.`rank` asc20205
4SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 11876332
5SELECT `Contest`.`id`, `Contest`.`name`, `Contest`.`status`, `Contest`.`published` FROM `hpp_game`.`contests` AS `Contest` WHERE `game_id` = 11876332
6SELECT `PingpongContest`.`id`, `PingpongContest`.`mode`, `PingpongContest`.`category` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE id IN (19745, 19676, 19677)333
7SELECT `Contest`.`id`, `Contest`.`enroll_count` FROM `hpp_game`.`contests` AS `Contest` WHERE `Contest`.`game_id` = 11876 AND `Contest`.`status` <> 'cancel'222
8SELECT `PingpongContest`.`id`, `PingpongContest`.`mode` FROM `hpp_game`.`pingpong_contests` AS `PingpongContest` WHERE `PingpongContest`.`id` IN (19676, 19677)222
9SELECT COUNT(*) AS `count` FROM `hpp_game`.`photos` AS `Photo` WHERE `Photo`.`type` = 2 AND `Photo`.`ex_type_id` = 11876112