подождите немного...

P. Bönig

Германия

Дата рождения	20.03.1980
Возраст	44 года
Позиция	защитник
Рост	178
Вес	73

Сезон	Команда	Турнир
2014/2015	Ferencváros	NB I	1366	19	14	5	0	14	0	5	0
2013/2014	Ferencváros	NB I	1762	24	20	4	5	6	2	1	0
2012/2013	Ferencváros	NB I	595	7	7	0	1	5	0	2	0
2011/2012	Бохум	2. Bundesliga	328	5	5	0	0	7	0	3	3
2011/2012	Bochum II	Regionalliga	180	2	2	0	0	0	0	0	0
2010/2011	Бохум	2. Bundesliga	232	6	2	4	0	14	0	0	0
2010/2011	Бохум	Bundesliga	0	0	0	0	0	2	0	0	0
2010/2011	Bochum II	Regionalliga	90	1	1	0	0	0	0	0	0
2009/2010	Бохум	Bundesliga	817	10	10	0	4	6	0	3	0
2009/2010	Bochum II	Regionalliga	180	2	2	0	0	0	0	1	0
2008/2009	Бохум	Bundesliga	1218	18	15	3	8	16	0	4	0
2007/2008	Бохум	Bundesliga	2149	25	24	1	6	6	0	3	0
2006/2007	Бохум	Bundesliga	2500	30	27	3	5	6	0	6	0
2005/2006	Бохум	Bundesliga	0	17	17	0	0	0	0	0	0

Сезон	Команда	Турнир
2014/2015	Ferencváros	League Cup	547	7	7	0	3	0	1	0
2014/2015	Ferencváros	Magyar Kupa	225	4	2	2	0	3	0	0
2013/2014	Ferencváros	League Cup	474	7	5	2	1	5	0	1
2013/2014	Ferencváros	Magyar Kupa	90	1	1	0	0	2	1	0
2012/2013	Ferencváros	League Cup	90	1	1	0	0	2	0	1
2011/2012	Бохум	DFB Pokal	120	1	1	0	0	0	0	0
2010/2011	Бохум	Play-offs 1/2	0	0	0	0	0	2	0	0
2010/2011	Бохум	DFB Pokal	90	1	1	0	0	0	0	0

Сезон	Команда	Турнир
2014/2015	Ferencváros	UEFA Europa League	90	1	1	0	0	2	0	1	0	0
2014	Ferencváros	Club Friendlies	46	1	1	0	1	0	0	0	0	0

Сезон	Команда	Турнир

Последнее обновление 15.11.2018

Трофеи

Клубы
League Cup	2014/2015, 2012/2013
2. Bundesliga	2005/2006
Magyar Kupa	2014/2015

Последние матчи

Дата	Т
30.05.2015	Ч	Ferencváros	2 - 0	Видеотон
24.05.2015	Ч	Ferencváros	1 - 0	Гонвед
16.05.2015	Ч	Paksi SE	0 - 1	Ferencváros
10.05.2015	Ч	Ferencváros	1 - 1	Debrecen
25.04.2015	Ч	Ferencváros	3 - 0	Diósgyőr
18.04.2015	Ч	Szombathelyi Haladás	0 - 3	Ferencváros
12.04.2015	Ч	Ferencváros	2 - 0	Újpest
03.04.2015	Ч	Puskás FC	1 - 2	Ferencváros
22.03.2015	Ч	Ferencváros	2 - 0	MTK
14.03.2015	Ч	Nyíregyháza Spartacus	0 - 0	Ferencváros
07.03.2015	Ч	Ferencváros	3 - 0	Győri ETO
01.03.2015	Ч	Dunaújváros-Pálhalma	0 - 1	Ferencváros
05.12.2014	Ч	Ferencváros	2 - 0	Pápa
29.11.2014	Ч	Ferencváros	3 - 1	Kecskeméti TE
23.11.2014	Ч	Видеотон	0 - 0	Ferencváros
07.11.2014	Ч	Гонвед	2 - 3	Ferencváros
01.11.2014	Ч	Ferencváros	0 - 0	Paksi SE
26.10.2014	Ч	Debrecen	2 - 2	Ferencváros
18.10.2014	Ч	Ferencváros	2 - 0	Pécsi MFC
04.10.2014	Ч	Diósgyőr	2 - 1	Ferencváros

(default) 14 queries took 13 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Country`.`code`, `Country`.`title_ru` FROM `user28770_football`.`countries` AS `Country` WHERE 1 = 1	266	266	0
2	SELECT `Country`.`code`, `Country`.`code2`, `Country`.`title_ru`, `Country`.`title_en`, `Country`.`title_ru_full`, `Country`.`code_num`, `Country`.`code3` FROM `user28770_football`.`countries` AS `Country` WHERE 1 = 1	266	266	0
3	SELECT `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `Country`.`code`, `Country`.`code2`, `Country`.`title_ru`, `Country`.`title_en`, `Country`.`title_ru_full`, `Country`.`code_num`, `Country`.`code3` FROM `user28770_football`.`football_players` AS `FootballPlayer` LEFT JOIN `user28770_football`.`countries` AS `Country` ON (`FootballPlayer`.`country` = `Country`.`code`) WHERE `FootballPlayer`.`id` = 21782 LIMIT 1	1	1	1
4	SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 21782 AND `FootballPlayerTeamsStat`.`competition_type` = 'liga' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC	14	14	1
5	SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 21782 AND `FootballPlayerTeamsStat`.`competition_type` = 'cup' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC	8	8	1
6	SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 21782 AND `FootballPlayerTeamsStat`.`competition_type` = 'international' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC	2	2	1
7	SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 21782 AND `FootballPlayerTeamsStat`.`competition_type` = 'nation' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC	0	0	1
8	SELECT `FootballPlayerTrophy`.`id`, `FootballPlayerTrophy`.`player_id`, `FootballPlayerTrophy`.`competition_title_id`, `FootballPlayerTrophy`.`seasons`, `FootballPlayerTrophy`.`win_type`, `FootballPlayerTrophy`.`competition_type`, `FootballPlayerTrophy`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated` FROM `user28770_football`.`football_player_trophies` AS `FootballPlayerTrophy` LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTrophy`.`competition_title_id` = `CompetitionTitle`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTrophy`.`player_id` = `FootballPlayer`.`id`) WHERE `FootballPlayerTrophy`.`player_id` = 21782 AND `competition_type` = 'club'	3	3	1
9	SELECT `FootballPlayerTrophy`.`id`, `FootballPlayerTrophy`.`player_id`, `FootballPlayerTrophy`.`competition_title_id`, `FootballPlayerTrophy`.`seasons`, `FootballPlayerTrophy`.`win_type`, `FootballPlayerTrophy`.`competition_type`, `FootballPlayerTrophy`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated` FROM `user28770_football`.`football_player_trophies` AS `FootballPlayerTrophy` LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTrophy`.`competition_title_id` = `CompetitionTitle`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTrophy`.`player_id` = `FootballPlayer`.`id`) WHERE `FootballPlayerTrophy`.`player_id` = 21782 AND `competition_type` = 'club_international'	0	0	1
10	SELECT `FootballPlayerTrophy`.`id`, `FootballPlayerTrophy`.`player_id`, `FootballPlayerTrophy`.`competition_title_id`, `FootballPlayerTrophy`.`seasons`, `FootballPlayerTrophy`.`win_type`, `FootballPlayerTrophy`.`competition_type`, `FootballPlayerTrophy`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated` FROM `user28770_football`.`football_player_trophies` AS `FootballPlayerTrophy` LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTrophy`.`competition_title_id` = `CompetitionTitle`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTrophy`.`player_id` = `FootballPlayer`.`id`) WHERE `FootballPlayerTrophy`.`player_id` = 21782 AND `competition_type` = 'national'	0	0	1
11	SELECT `Country`.`code`, `Country`.`code2`, `Country`.`title_ru`, `Country`.`title_en`, `Country`.`title_ru_full`, `Country`.`code_num`, `Country`.`code3` FROM `user28770_football`.`countries` AS `Country` WHERE ((`code` = 'DEU') OR (`code3` = 'DEU')) LIMIT 1	1	1	0
12	SELECT *, `FootballMatch`.`id` FROM `user28770_football`.`football_matches` AS `FootballMatch` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam1` ON (`FootballMatch`.`team1_id` = `FootballTeam1`.`id`) LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam2` ON (`FootballMatch`.`team2_id` = `FootballTeam2`.`id`) LEFT JOIN `user28770_football`.`football_competitions` AS `FootballCompetition` ON (`FootballMatch`.`football_competition_id` = `FootballCompetition`.`id`) INNER JOIN `user28770_football`.`football_match_players` AS `FootballMatchPlayer` ON (`FootballMatch`.`id` = `FootballMatchPlayer`.`football_match_id`) WHERE `ready` = 1 AND `FootballMatchPlayer`.`player_id` = 21782 ORDER BY `match_date` desc LIMIT 20	20	20	3
13	SELECT `FootballMatchGoalPlayer`.`id`, `FootballMatchGoalPlayer`.`football_match_id`, `FootballMatchGoalPlayer`.`team_id`, `FootballMatchGoalPlayer`.`player_id`, `FootballMatchGoalPlayer`.`assist_player_id`, `FootballMatchGoalPlayer`.`minute`, `FootballMatchGoalPlayer`.`extra_minute`, `FootballMatchGoalPlayer`.`penalty`, `FootballMatchGoalPlayer`.`autogoal` FROM `user28770_football`.`football_match_goals` AS `FootballMatchGoalPlayer` WHERE `FootballMatchGoalPlayer`.`player_id` = 21782 AND `FootballMatchGoalPlayer`.`football_match_id` IN (27744, 27741, 27728, 27724, 27703, 27696, 27692, 27678, 27676, 27664, 27655, 27653, 27638, 27635, 27628, 27614, 27611, 27604, 27595, 27583) ORDER BY `FootballMatchGoalPlayer`.`minute` ASC, `FootballMatchGoalPlayer`.`extra_minute` ASC	0	0	1
14	SELECT `FootballMatchCardPlayer`.`id`, `FootballMatchCardPlayer`.`football_match_id`, `FootballMatchCardPlayer`.`team_id`, `FootballMatchCardPlayer`.`player_id`, `FootballMatchCardPlayer`.`type`, `FootballMatchCardPlayer`.`minute`, `FootballMatchCardPlayer`.`extra_minute` FROM `user28770_football`.`football_match_cards` AS `FootballMatchCardPlayer` WHERE `FootballMatchCardPlayer`.`player_id` = 21782 AND `FootballMatchCardPlayer`.`football_match_id` IN (27744, 27741, 27728, 27724, 27703, 27696, 27692, 27678, 27676, 27664, 27655, 27653, 27638, 27635, 27628, 27614, 27611, 27604, 27595, 27583)	3	3	1

(default) 14 queries took 13 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Country`.`code`, `Country`.`title_ru` FROM `user28770_football`.`countries` AS `Country` WHERE 1 = 1

266

SELECT `Country`.`code`, `Country`.`code2`, `Country`.`title_ru`, `Country`.`title_en`, `Country`.`title_ru_full`, `Country`.`code_num`, `Country`.`code3` FROM `user28770_football`.`countries` AS `Country` WHERE 1 = 1

266

SELECT `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `Country`.`code`, `Country`.`code2`, `Country`.`title_ru`, `Country`.`title_en`, `Country`.`title_ru_full`, `Country`.`code_num`, `Country`.`code3` FROM `user28770_football`.`football_players` AS `FootballPlayer` LEFT JOIN `user28770_football`.`countries` AS `Country` ON (`FootballPlayer`.`country` = `Country`.`code`) WHERE `FootballPlayer`.`id` = 21782 LIMIT 1

SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 21782 AND `FootballPlayerTeamsStat`.`competition_type` = 'liga' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC

SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 21782 AND `FootballPlayerTeamsStat`.`competition_type` = 'cup' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC

SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 21782 AND `FootballPlayerTeamsStat`.`competition_type` = 'international' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC

SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 21782 AND `FootballPlayerTeamsStat`.`competition_type` = 'nation' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC

SELECT `FootballPlayerTrophy`.`id`, `FootballPlayerTrophy`.`player_id`, `FootballPlayerTrophy`.`competition_title_id`, `FootballPlayerTrophy`.`seasons`, `FootballPlayerTrophy`.`win_type`, `FootballPlayerTrophy`.`competition_type`, `FootballPlayerTrophy`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated` FROM `user28770_football`.`football_player_trophies` AS `FootballPlayerTrophy` LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTrophy`.`competition_title_id` = `CompetitionTitle`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTrophy`.`player_id` = `FootballPlayer`.`id`) WHERE `FootballPlayerTrophy`.`player_id` = 21782 AND `competition_type` = 'club'

SELECT *, `FootballMatch`.`id` FROM `user28770_football`.`football_matches` AS `FootballMatch` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam1` ON (`FootballMatch`.`team1_id` = `FootballTeam1`.`id`) LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam2` ON (`FootballMatch`.`team2_id` = `FootballTeam2`.`id`) LEFT JOIN `user28770_football`.`football_competitions` AS `FootballCompetition` ON (`FootballMatch`.`football_competition_id` = `FootballCompetition`.`id`) INNER JOIN `user28770_football`.`football_match_players` AS `FootballMatchPlayer` ON (`FootballMatch`.`id` = `FootballMatchPlayer`.`football_match_id`) WHERE `ready` = 1 AND `FootballMatchPlayer`.`player_id` = 21782 ORDER BY `match_date` desc LIMIT 20

SELECT `FootballMatchGoalPlayer`.`id`, `FootballMatchGoalPlayer`.`football_match_id`, `FootballMatchGoalPlayer`.`team_id`, `FootballMatchGoalPlayer`.`player_id`, `FootballMatchGoalPlayer`.`assist_player_id`, `FootballMatchGoalPlayer`.`minute`, `FootballMatchGoalPlayer`.`extra_minute`, `FootballMatchGoalPlayer`.`penalty`, `FootballMatchGoalPlayer`.`autogoal` FROM `user28770_football`.`football_match_goals` AS `FootballMatchGoalPlayer` WHERE `FootballMatchGoalPlayer`.`player_id` = 21782 AND `FootballMatchGoalPlayer`.`football_match_id` IN (27744, 27741, 27728, 27724, 27703, 27696, 27692, 27678, 27676, 27664, 27655, 27653, 27638, 27635, 27628, 27614, 27611, 27604, 27595, 27583) ORDER BY `FootballMatchGoalPlayer`.`minute` ASC, `FootballMatchGoalPlayer`.`extra_minute` ASC

SELECT `FootballMatchCardPlayer`.`id`, `FootballMatchCardPlayer`.`football_match_id`, `FootballMatchCardPlayer`.`team_id`, `FootballMatchCardPlayer`.`player_id`, `FootballMatchCardPlayer`.`type`, `FootballMatchCardPlayer`.`minute`, `FootballMatchCardPlayer`.`extra_minute` FROM `user28770_football`.`football_match_cards` AS `FootballMatchCardPlayer` WHERE `FootballMatchCardPlayer`.`player_id` = 21782 AND `FootballMatchCardPlayer`.`football_match_id` IN (27744, 27741, 27728, 27724, 27703, 27696, 27692, 27678, 27676, 27664, 27655, 27653, 27638, 27635, 27628, 27614, 27611, 27604, 27595, 27583)