Query Metrics
46
Database Queries
13
Different statements
30.09 ms
Query time
0
Invalid entities
96
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.50 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.previousClubs AS previousClubs_4, t0.about AS about_5, t0.bannerPicture AS bannerPicture_6, t0.active AS active_7, t0.player_id AS player_id_8, t0.team_id AS team_id_9, t0.images_id AS images_id_10 FROM football_seasonplayer t0 WHERE t0.id = ?
Parameters:
[
"382"
]
|
| 2 | 0.85 ms |
SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.name_medium AS name_medium_3, t0.name_short AS name_short_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.team_id AS team_id_8, t0.picture_id AS picture_id_9 FROM football_seasonteam t0 WHERE t0.id = ?
Parameters:
[
642
]
|
| 3 | 0.95 ms |
SELECT t0.id AS id_1, t0.facebookConnection_pageId AS facebookConnection_pageId_2, t0.facebookConnection_token AS facebookConnection_token_3, t0.team_id AS team_id_4, t0.seasonSettings_id AS seasonSettings_id_5, t0.selection_id AS selection_id_6 FROM settings t0 WHERE t0.selection_id = ? LIMIT 1
Parameters:
[
1
]
|
| 4 | 0.73 ms |
SELECT t0.id AS id_1, t0.currentSeason_year AS currentSeason_year_2, t0.currentSeason_startYear AS currentSeason_startYear_3, t0.currentSeason_endYear AS currentSeason_endYear_4, t0.firstSeason_year AS firstSeason_year_5, t0.firstSeason_startYear AS firstSeason_startYear_6, t0.firstSeason_endYear AS firstSeason_endYear_7, t0.currentSeasonTeam_id AS currentSeasonTeam_id_8, t0.mainCompetitionExecution_id AS mainCompetitionExecution_id_9 FROM settings_season t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 5 | 0.94 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.previousClubs AS previousClubs_4, t0.about AS about_5, t0.bannerPicture AS bannerPicture_6, t0.active AS active_7, t0.player_id AS player_id_8, t0.team_id AS team_id_9, t0.images_id AS images_id_10 FROM football_seasonplayer t0 WHERE t0.position = ? AND t0.team_id = ? AND t0.active = ?
Parameters:
[ "goalkeeper" 744 1 ] |
| 6 | 0.97 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.previousClubs AS previousClubs_4, t0.about AS about_5, t0.bannerPicture AS bannerPicture_6, t0.active AS active_7, t0.player_id AS player_id_8, t0.team_id AS team_id_9, t0.images_id AS images_id_10 FROM football_seasonplayer t0 WHERE t0.position = ? AND t0.team_id = ? AND t0.active = ?
Parameters:
[ "defender" 744 1 ] |
| 7 | 0.87 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.previousClubs AS previousClubs_4, t0.about AS about_5, t0.bannerPicture AS bannerPicture_6, t0.active AS active_7, t0.player_id AS player_id_8, t0.team_id AS team_id_9, t0.images_id AS images_id_10 FROM football_seasonplayer t0 WHERE t0.position = ? AND t0.team_id = ? AND t0.active = ?
Parameters:
[ "midfielder" 744 1 ] |
| 8 | 0.88 ms |
SELECT t0.id AS id_1, t0.number AS number_2, t0.position AS position_3, t0.previousClubs AS previousClubs_4, t0.about AS about_5, t0.bannerPicture AS bannerPicture_6, t0.active AS active_7, t0.player_id AS player_id_8, t0.team_id AS team_id_9, t0.images_id AS images_id_10 FROM football_seasonplayer t0 WHERE t0.position = ? AND t0.team_id = ? AND t0.active = ?
Parameters:
[ "forward" 744 1 ] |
| 9 | 0.80 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
146
]
|
| 10 | 0.84 ms |
SELECT t0.id AS id_1, t0.facebookConnection_pageId AS facebookConnection_pageId_2, t0.facebookConnection_token AS facebookConnection_token_3, t0.team_id AS team_id_4, t0.seasonSettings_id AS seasonSettings_id_5, t0.selection_id AS selection_id_6 FROM settings t0 WHERE t0.selection_id = ? LIMIT 1
Parameters:
[
1
]
|
| 11 | 0.70 ms |
SELECT t0.id AS id_1, t0.facebookConnection_pageId AS facebookConnection_pageId_2, t0.facebookConnection_token AS facebookConnection_token_3, t0.team_id AS team_id_4, t0.seasonSettings_id AS seasonSettings_id_5, t0.selection_id AS selection_id_6 FROM settings t0 WHERE t0.selection_id = ? LIMIT 1
Parameters:
[
1
]
|
| 12 | 0.81 ms |
SELECT t0.id AS id_1, t0.year AS year_2, t0.rounds AS rounds_3, t0.sort AS sort_4, t0.season_year AS season_year_5, t0.season_startYear AS season_startYear_6, t0.season_endYear AS season_endYear_7, t0.competition_id AS competition_id_8 FROM football_competition_execution t0 WHERE t0.id = ?
Parameters:
[
59
]
|
| 13 | 0.82 ms |
SELECT t0.id AS id_1, t0.facebookConnection_pageId AS facebookConnection_pageId_2, t0.facebookConnection_token AS facebookConnection_token_3, t0.team_id AS team_id_4, t0.seasonSettings_id AS seasonSettings_id_5, t0.selection_id AS selection_id_6 FROM settings t0 WHERE t0.selection_id = ? LIMIT 1
Parameters:
[
1
]
|
| 14 | 0.84 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.shortName AS shortName_4, t0.settings_overtime AS settings_overtime_5, t0.settings_penalties AS settings_penalties_6, t0.logos_id AS logos_id_7 FROM football_competition t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 15 | 0.76 ms |
SELECT t0.id AS id_1, t0.facebookConnection_pageId AS facebookConnection_pageId_2, t0.facebookConnection_token AS facebookConnection_token_3, t0.team_id AS team_id_4, t0.seasonSettings_id AS seasonSettings_id_5, t0.selection_id AS selection_id_6 FROM settings t0 WHERE t0.selection_id = ? LIMIT 1
Parameters:
[
1
]
|
| 16 | 0.92 ms |
SELECT f0_.id AS id_0, f0_.year AS year_1, f0_.rounds AS rounds_2, f0_.sort AS sort_3, f0_.season_year AS season_year_4, f0_.season_startYear AS season_startYear_5, f0_.season_endYear AS season_endYear_6, f0_.competition_id AS competition_id_7 FROM football_competition_execution f0_ WHERE f0_.season_year = ? ORDER BY f0_.sort ASC
Parameters:
[
2026
]
|
| 17 | 0.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.shortName AS shortName_4, t0.settings_overtime AS settings_overtime_5, t0.settings_penalties AS settings_penalties_6, t0.logos_id AS logos_id_7 FROM football_competition t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 18 | 0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.shortName AS shortName_4, t0.settings_overtime AS settings_overtime_5, t0.settings_penalties AS settings_penalties_6, t0.logos_id AS logos_id_7 FROM football_competition t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 19 | 1.64 ms |
SELECT t0.id AS id_1, t0.goal_id AS goal_id_2, t0.portrait_id AS portrait_id_3 FROM football_seasonplayer_images t0 WHERE t0.id = ?
Parameters:
[
108
]
|
| 20 | 0.86 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.createdAt AS createdAt_3, t0.visible AS visible_4, t0.tags AS tags_5, t0.directory_id AS directory_id_6 FROM media t0 WHERE t0.id = ?
Parameters:
[
1645
]
|
| 21 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.protected AS protected_3, t0.parent_id AS parent_id_4 FROM media_directory t0 WHERE t0.id = ?
Parameters:
[
30
]
|
| 22 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.protected AS protected_3, t0.parent_id AS parent_id_4 FROM media_directory t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 23 | 0.51 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.protected AS protected_3, t0.parent_id AS parent_id_4 FROM media_directory t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 24 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.protected AS protected_3, t0.parent_id AS parent_id_4 FROM media_directory t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 25 | 0.41 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
155
]
|
| 26 | 0.43 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
215
]
|
| 27 | 0.41 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
189
]
|
| 28 | 0.42 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
134
]
|
| 29 | 0.37 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
223
]
|
| 30 | 0.40 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
160
]
|
| 31 | 0.39 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
207
]
|
| 32 | 0.37 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
204
]
|
| 33 | 0.66 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
226
]
|
| 34 | 0.36 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
98
]
|
| 35 | 0.32 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
194
]
|
| 36 | 0.30 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
211
]
|
| 37 | 0.31 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
208
]
|
| 38 | 0.32 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
219
]
|
| 39 | 0.31 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
218
]
|
| 40 | 0.34 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
222
]
|
| 41 | 0.34 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
225
]
|
| 42 | 0.36 ms |
SELECT t0.firstName AS firstName_1, t0.lastName AS lastName_2, t0.birthDate AS birthDate_3, t0.picture AS picture_4, t0.registrationNumber AS registrationNumber_5, t0.id AS id_6 FROM football_player t0 WHERE t0.id = ?
Parameters:
[
187
]
|
| 43 | 0.98 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.url AS url_2, s0_.logo AS logo_3, s0_.position AS position_4, s0_.exposed AS exposed_5, s0_.active AS active_6 FROM sponsor s0_ WHERE s0_.active = ? AND s0_.exposed = ? ORDER BY s0_.position ASC
Parameters:
[ 1 1 ] |
| 44 | 0.80 ms |
SELECT t0.id AS id_1, t0.facebookConnection_pageId AS facebookConnection_pageId_2, t0.facebookConnection_token AS facebookConnection_token_3, t0.team_id AS team_id_4, t0.seasonSettings_id AS seasonSettings_id_5, t0.selection_id AS selection_id_6 FROM settings t0 WHERE t0.selection_id = ? LIMIT 1
Parameters:
[
1
]
|
| 45 | 0.70 ms |
SELECT t0.id AS id_1, t0.facebookConnection_pageId AS facebookConnection_pageId_2, t0.facebookConnection_token AS facebookConnection_token_3, t0.team_id AS team_id_4, t0.seasonSettings_id AS seasonSettings_id_5, t0.selection_id AS selection_id_6 FROM settings t0 WHERE t0.selection_id = ? LIMIT 1
Parameters:
[
1
]
|
| 46 | 0.64 ms |
SELECT t0.id AS id_1, t0.facebookConnection_pageId AS facebookConnection_pageId_2, t0.facebookConnection_token AS facebookConnection_token_3, t0.team_id AS team_id_4, t0.seasonSettings_id AS seasonSettings_id_5, t0.selection_id AS selection_id_6 FROM settings t0 WHERE t0.selection_id = ? LIMIT 1
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Core\Entity\Football\Player\SeasonPlayer | 20 |
| Core\Entity\Football\Player\SeasonPlayerImages | 20 |
| Core\Entity\Football\Player\Player | 19 |
| Core\Entity\Sponsor\Sponsor | 18 |
| Core\Entity\Media\Directory | 4 |
| Core\Entity\Football\CompetitionExecution | 3 |
| Core\Entity\Football\Competition | 3 |
| Core\Entity\Football\Team\SeasonTeam | 2 |
| Core\Entity\Football\CompetitionLogos | 2 |
| Core\Entity\Football\Team\Team | 1 |
| Core\Entity\Settings\Settings | 1 |
| Core\Entity\Settings\SeasonSettings | 1 |
| Core\Entity\Football\Selection | 1 |
| Core\Entity\Media\Media | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Core\Entity\Football\Player\SeasonPlayer | No errors. |
| Core\Entity\Football\Player\Player | No errors. |
| Core\Entity\Football\Team\TeamName | No errors. |
| Core\Entity\Football\Season | No errors. |
| Core\Entity\Football\Team\SeasonTeam | No errors. |
| Core\Entity\Football\Player\SeasonPlayerImages | No errors. |
| Core\Entity\Football\Team\Team | No errors. |
| Core\Entity\Media\Media | No errors. |
| Core\Entity\Settings\FacebookConnection | No errors. |
| Core\Entity\Settings\Settings | No errors. |
| Core\Entity\Settings\SeasonSettings | No errors. |
| Core\Entity\Football\Selection | No errors. |
| Core\Entity\Football\CompetitionExecution | No errors. |
| Core\Entity\Football\CompetitionSettings | No errors. |
| Core\Entity\Football\Competition | No errors. |
| Core\Entity\Football\MatchDay | No errors. |
| Core\Entity\Football\Table\PointPenalty | No errors. |
| Core\Entity\Football\CompetitionLogos | No errors. |
| Core\Entity\Media\Directory | No errors. |
| Core\Entity\Sponsor\Sponsor | No errors. |