Query Metrics
35
Database Queries
16
Different statements
13.01 ms
Query time
0
Invalid entities
491
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM Club t0 WHERE t0.id = ?
Parameters:
[
"872"
]
|
| 2 | 0.43 ms |
SELECT DISTINCT c0_.year AS year_0, c0_.rythm AS rythm_1 FROM ClubLeague c0_ WHERE c0_.club_Id = ? ORDER BY c0_.year DESC, c0_.rythm DESC
Parameters:
[
872
]
|
| 3 | 0.15 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.Club_id AS Club_id_4, t0.Country_id AS Country_id_5 FROM ClubCountry t0 WHERE t0.Club_id = ?
Parameters:
[
872
]
|
| 4 | 0.36 ms |
SELECT c0_.id AS id_0, c0_.year AS year_1, c0_.rythm AS rythm_2, c0_.rank AS rank_3, c0_.league_champion AS league_champion_4, c0_.cup_winner AS cup_winner_5, c0_.club_Id AS club_Id_6, c0_.league_Id AS league_Id_7 FROM ClubLeague c0_ WHERE c0_.club_Id = ? AND c0_.year = ? AND c0_.rythm = ?
Parameters:
[ 872 "1998" "1" ] |
| 5 | 5.17 ms |
SELECT p0_.id AS id_0, p0_.year AS year_1, p0_.rythm AS rythm_2, p0_.goals AS goals_3, p0_.substitutions AS substitutions_4, p0_.matches AS matches_5, p0_.ordering AS ordering_6, c1_.id AS id_7, c1_.name AS name_8, c1_.slug AS slug_9, f2_.id AS id_10, f2_.name AS name_11, f2_.abbrev AS abbrev_12, f2_.lft AS lft_13, f2_.rgt AS rgt_14, f2_.root AS root_15, f2_.lvl AS lvl_16, p3_.id AS id_17, p3_.firstname AS firstname_18, p3_.surname AS surname_19, p3_.birthday AS birthday_20, p3_.dayOfBirth AS dayOfBirth_21, p3_.monthOfBirth AS monthOfBirth_22, p3_.yearOfBirth AS yearOfBirth_23, p3_.deathDay AS deathDay_24, p3_.deathMonth AS deathMonth_25, p3_.deathYear AS deathYear_26, p3_.dayOfDeath AS dayOfDeath_27, p3_.birthplace AS birthplace_28, p3_.height AS height_29, p3_.weight AS weight_30, p3_.gender AS gender_31, p3_.isPlayer AS isPlayer_32, p3_.isTrainer AS isTrainer_33, p3_.isDead AS isDead_34, p3_.slug AS slug_35, p3_.nickname AS nickname_36, p3_.foreignname AS foreignname_37, p3_.updateInvolvedGames AS updateInvolvedGames_38, p3_.updateWhoMetWhom AS updateWhoMetWhom_39, p4_.id AS id_40, p4_.year AS year_41, p4_.goals AS goals_42, p4_.substitutions AS substitutions_43, p4_.matches AS matches_44, p4_.nonFifaGoals AS nonFifaGoals_45, p4_.nonFifaSubstitutions AS nonFifaSubstitutions_46, p4_.nonFifaMatches AS nonFifaMatches_47, n5_.id AS id_48, n5_.name AS name_49, n5_.gender AS gender_50, n5_.slug AS slug_51, n5_.start AS start_52, n5_.end AS end_53, n5_.editable AS editable_54, c6_.id AS id_55, c6_.isoCode AS isoCode_56, c6_.powered_by AS powered_by_57, c6_.powered_by_link AS powered_by_link_58, c6_.map_coordinates AS map_coordinates_59, c7_.id AS id_60, c7_.start AS start_61, c7_.end AS end_62, c7_.filepath AS filepath_63, c7_.filetype AS filetype_64, c8_.id AS id_65, c8_.start AS start_66, c8_.end AS end_67, c8_.name AS name_68, c8_.foreignname AS foreignname_69, c8_.abbrev AS abbrev_70, c8_.slug AS slug_71, c9_.id AS id_72, c9_.start AS start_73, c9_.end AS end_74, c10_.id AS id_75, c10_.isoCode AS isoCode_76, c10_.powered_by AS powered_by_77, c10_.powered_by_link AS powered_by_link_78, c10_.map_coordinates AS map_coordinates_79, p0_.Person_id AS Person_id_80, p0_.Position_id AS Position_id_81, p0_.Club_id AS Club_id_82, f2_.parent_id AS parent_id_83, p3_.countryOfBirth_id AS countryOfBirth_id_84, p3_.defaultPosition_id AS defaultPosition_id_85, p4_.Person_id AS Person_id_86, p4_.NationalTeam_id AS NationalTeam_id_87, p4_.Position_id AS Position_id_88, n5_.country_id AS country_id_89, c6_.continent_id AS continent_id_90, c7_.Country_id AS Country_id_91, c8_.Country_id AS Country_id_92, c9_.Club_id AS Club_id_93, c9_.Country_id AS Country_id_94, c10_.continent_id AS continent_id_95 FROM PersonClubScores p0_ LEFT JOIN Club c1_ ON p0_.Club_id = c1_.id LEFT JOIN FieldPosition f2_ ON p0_.Position_id = f2_.id LEFT JOIN Person p3_ ON p0_.Person_id = p3_.id LEFT JOIN PersonNationalTeamScores p4_ ON p3_.id = p4_.Person_id LEFT JOIN NationalTeam n5_ ON p4_.NationalTeam_id = n5_.id LEFT JOIN Country c6_ ON n5_.country_id = c6_.id LEFT JOIN CountryImages c7_ ON c6_.id = c7_.Country_id LEFT JOIN CountryNames c8_ ON c6_.id = c8_.Country_id LEFT JOIN ClubCountry c9_ ON c1_.id = c9_.Club_id AND (c9_.end >= ?) LEFT JOIN Country c10_ ON c9_.Country_id = c10_.id WHERE p0_.Club_id = ? AND p0_.year = ? AND p0_.rythm = ? ORDER BY f2_.root DESC, p0_.matches DESC, p0_.substitutions DESC, p0_.goals DESC, f2_.lft DESC, p3_.surname ASC, p3_.firstname ASC, p4_.year DESC, c8_.start ASC
Parameters:
[ "1998" 872 "1998" "1" ] |
| 6 | 0.23 ms |
SELECT t0.id AS id_1, t0.baconbauernumber AS baconbauernumber_2, t0.created AS created_3, t0.person_id AS person_id_4 FROM Baconbauer t0 WHERE t0.person_id = ?
Parameters:
[
5805
]
|
| 7 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbrev AS abbrev_3, t0.logo AS logo_4, t0.founded AS founded_5, t0.joined_fifa AS joined_fifa_6, t0.country_id AS country_id_7 FROM CountryAssociation t0 WHERE t0.country_id = ?
Parameters:
[
163
]
|
| 8 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbrev AS abbrev_3, t0.logo AS logo_4, t0.founded AS founded_5, t0.joined_fifa AS joined_fifa_6, t0.country_id AS country_id_7 FROM CountryAssociation t0 WHERE t0.country_id = ?
Parameters:
[
67
]
|
| 9 | 0.20 ms |
SELECT t0.id AS id_1, t0.baconbauernumber AS baconbauernumber_2, t0.created AS created_3, t0.person_id AS person_id_4 FROM Baconbauer t0 WHERE t0.person_id = ?
Parameters:
[
4284
]
|
| 10 | 0.22 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.name AS name_4, t0.foreignname AS foreignname_5, t0.abbrev AS abbrev_6, t0.slug AS slug_7, t0.Country_id AS Country_id_8 FROM CountryNames t0 WHERE t0.Country_id IN (?) ORDER BY t0.start ASC
Parameters:
[
67
]
|
| 11 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbrev AS abbrev_3, t0.logo AS logo_4, t0.founded AS founded_5, t0.joined_fifa AS joined_fifa_6, t0.country_id AS country_id_7 FROM CountryAssociation t0 WHERE t0.country_id = ?
Parameters:
[
119
]
|
| 12 | 0.15 ms |
SELECT t0.id AS id_1, t0.baconbauernumber AS baconbauernumber_2, t0.created AS created_3, t0.person_id AS person_id_4 FROM Baconbauer t0 WHERE t0.person_id = ?
Parameters:
[
2796
]
|
| 13 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbrev AS abbrev_3, t0.logo AS logo_4, t0.founded AS founded_5, t0.joined_fifa AS joined_fifa_6, t0.country_id AS country_id_7 FROM CountryAssociation t0 WHERE t0.country_id = ?
Parameters:
[
78
]
|
| 14 | 0.16 ms |
SELECT t0.id AS id_1, t0.baconbauernumber AS baconbauernumber_2, t0.created AS created_3, t0.person_id AS person_id_4 FROM Baconbauer t0 WHERE t0.person_id = ?
Parameters:
[
1659
]
|
| 15 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbrev AS abbrev_3, t0.logo AS logo_4, t0.founded AS founded_5, t0.joined_fifa AS joined_fifa_6, t0.country_id AS country_id_7 FROM CountryAssociation t0 WHERE t0.country_id = ?
Parameters:
[
209
]
|
| 16 | 0.14 ms |
SELECT t0.id AS id_1, t0.baconbauernumber AS baconbauernumber_2, t0.created AS created_3, t0.person_id AS person_id_4 FROM Baconbauer t0 WHERE t0.person_id = ?
Parameters:
[
9631
]
|
| 17 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbrev AS abbrev_3, t0.logo AS logo_4, t0.founded AS founded_5, t0.joined_fifa AS joined_fifa_6, t0.country_id AS country_id_7 FROM CountryAssociation t0 WHERE t0.country_id = ?
Parameters:
[
227
]
|
| 18 | 0.19 ms |
SELECT t0.id AS id_1, t0.baconbauernumber AS baconbauernumber_2, t0.created AS created_3, t0.person_id AS person_id_4 FROM Baconbauer t0 WHERE t0.person_id = ?
Parameters:
[
20712
]
|
| 19 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbrev AS abbrev_3, t0.logo AS logo_4, t0.founded AS founded_5, t0.joined_fifa AS joined_fifa_6, t0.country_id AS country_id_7 FROM CountryAssociation t0 WHERE t0.country_id = ?
Parameters:
[
271
]
|
| 20 | 0.15 ms |
SELECT t0.id AS id_1, t0.baconbauernumber AS baconbauernumber_2, t0.created AS created_3, t0.person_id AS person_id_4 FROM Baconbauer t0 WHERE t0.person_id = ?
Parameters:
[
13913
]
|
| 21 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbrev AS abbrev_3, t0.logo AS logo_4, t0.founded AS founded_5, t0.joined_fifa AS joined_fifa_6, t0.country_id AS country_id_7 FROM CountryAssociation t0 WHERE t0.country_id = ?
Parameters:
[
55
]
|
| 22 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM League t0 WHERE t0.id = ?
Parameters:
[
550
]
|
| 23 | 0.18 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.League_id AS League_id_4, t0.LeagueCategory_id AS LeagueCategory_id_5 FROM LeagueHistory t0 WHERE t0.League_id = ? ORDER BY t0.end DESC, t0.start DESC
Parameters:
[
550
]
|
| 24 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ltype AS ltype_3, t0.level AS level_4, t0.Country_id AS Country_id_5 FROM LeagueCategory t0 WHERE t0.id = ?
Parameters:
[
926
]
|
| 25 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.map_coordinates AS map_coordinates_3, t0.slug AS slug_4, t0.confederation_id AS confederation_id_5 FROM Continent t0
Parameters:
[] |
| 26 | 0.17 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.abbrev AS abbrev_2, t0_.slug AS slug_3, t0_.created AS created_4, t0_.updated AS updated_5, t0_.createdBy AS createdBy_6, t0_.updatedBy AS updatedBy_7 FROM Tournament t0_ WHERE t0_.id < 8 ORDER BY t0_.name ASC
Parameters:
[] |
| 27 | 0.50 ms |
SELECT t0.id AS id_1, t0.year AS year_2, t0.tournamentType AS tournamentType_3, t0.gender AS gender_4, t0.winscore AS winscore_5, t0.created AS created_6, t0.updated AS updated_7, t0.createdBy AS createdBy_8, t0.updatedBy AS updatedBy_9, t0.tournament_id AS tournament_id_10, t11.id AS id_12, t11.name AS name_13, t11.leaf_type AS leaf_type_14, t11.lft AS lft_15, t11.rgt AS rgt_16, t11.root AS root_17, t11.lvl AS lvl_18, t11.qualificationStage AS qualificationStage_19, t11.numberOfCountries AS numberOfCountries_20, t11.created AS created_21, t11.updated AS updated_22, t11.createdBy AS createdBy_23, t11.updatedBy AS updatedBy_24, t11.parent_id AS parent_id_25, t11.tournament_id AS tournament_id_26, t11.linkedNode_id AS linkedNode_id_27, t11.gameSorter_id AS gameSorter_id_28, t11.groupSorter_id AS groupSorter_id_29 FROM TournamentYear t0 LEFT JOIN TournamentTree t11 ON t11.tournament_id = t0.id WHERE t0.tournament_id = ? ORDER BY t0.year DESC
Parameters:
[
2
]
|
| 28 | 0.33 ms |
SELECT t0.id AS id_1, t0.year AS year_2, t0.tournamentType AS tournamentType_3, t0.gender AS gender_4, t0.winscore AS winscore_5, t0.created AS created_6, t0.updated AS updated_7, t0.createdBy AS createdBy_8, t0.updatedBy AS updatedBy_9, t0.tournament_id AS tournament_id_10, t11.id AS id_12, t11.name AS name_13, t11.leaf_type AS leaf_type_14, t11.lft AS lft_15, t11.rgt AS rgt_16, t11.root AS root_17, t11.lvl AS lvl_18, t11.qualificationStage AS qualificationStage_19, t11.numberOfCountries AS numberOfCountries_20, t11.created AS created_21, t11.updated AS updated_22, t11.createdBy AS createdBy_23, t11.updatedBy AS updatedBy_24, t11.parent_id AS parent_id_25, t11.tournament_id AS tournament_id_26, t11.linkedNode_id AS linkedNode_id_27, t11.gameSorter_id AS gameSorter_id_28, t11.groupSorter_id AS groupSorter_id_29 FROM TournamentYear t0 LEFT JOIN TournamentTree t11 ON t11.tournament_id = t0.id WHERE t0.tournament_id = ? ORDER BY t0.year DESC
Parameters:
[
3
]
|
| 29 | 0.56 ms |
SELECT t0.id AS id_1, t0.year AS year_2, t0.tournamentType AS tournamentType_3, t0.gender AS gender_4, t0.winscore AS winscore_5, t0.created AS created_6, t0.updated AS updated_7, t0.createdBy AS createdBy_8, t0.updatedBy AS updatedBy_9, t0.tournament_id AS tournament_id_10, t11.id AS id_12, t11.name AS name_13, t11.leaf_type AS leaf_type_14, t11.lft AS lft_15, t11.rgt AS rgt_16, t11.root AS root_17, t11.lvl AS lvl_18, t11.qualificationStage AS qualificationStage_19, t11.numberOfCountries AS numberOfCountries_20, t11.created AS created_21, t11.updated AS updated_22, t11.createdBy AS createdBy_23, t11.updatedBy AS updatedBy_24, t11.parent_id AS parent_id_25, t11.tournament_id AS tournament_id_26, t11.linkedNode_id AS linkedNode_id_27, t11.gameSorter_id AS gameSorter_id_28, t11.groupSorter_id AS groupSorter_id_29 FROM TournamentYear t0 LEFT JOIN TournamentTree t11 ON t11.tournament_id = t0.id WHERE t0.tournament_id = ? ORDER BY t0.year DESC
Parameters:
[
4
]
|
| 30 | 0.39 ms |
SELECT t0.id AS id_1, t0.year AS year_2, t0.tournamentType AS tournamentType_3, t0.gender AS gender_4, t0.winscore AS winscore_5, t0.created AS created_6, t0.updated AS updated_7, t0.createdBy AS createdBy_8, t0.updatedBy AS updatedBy_9, t0.tournament_id AS tournament_id_10, t11.id AS id_12, t11.name AS name_13, t11.leaf_type AS leaf_type_14, t11.lft AS lft_15, t11.rgt AS rgt_16, t11.root AS root_17, t11.lvl AS lvl_18, t11.qualificationStage AS qualificationStage_19, t11.numberOfCountries AS numberOfCountries_20, t11.created AS created_21, t11.updated AS updated_22, t11.createdBy AS createdBy_23, t11.updatedBy AS updatedBy_24, t11.parent_id AS parent_id_25, t11.tournament_id AS tournament_id_26, t11.linkedNode_id AS linkedNode_id_27, t11.gameSorter_id AS gameSorter_id_28, t11.groupSorter_id AS groupSorter_id_29 FROM TournamentYear t0 LEFT JOIN TournamentTree t11 ON t11.tournament_id = t0.id WHERE t0.tournament_id = ? ORDER BY t0.year DESC
Parameters:
[
5
]
|
| 31 | 0.39 ms |
SELECT t0.id AS id_1, t0.year AS year_2, t0.tournamentType AS tournamentType_3, t0.gender AS gender_4, t0.winscore AS winscore_5, t0.created AS created_6, t0.updated AS updated_7, t0.createdBy AS createdBy_8, t0.updatedBy AS updatedBy_9, t0.tournament_id AS tournament_id_10, t11.id AS id_12, t11.name AS name_13, t11.leaf_type AS leaf_type_14, t11.lft AS lft_15, t11.rgt AS rgt_16, t11.root AS root_17, t11.lvl AS lvl_18, t11.qualificationStage AS qualificationStage_19, t11.numberOfCountries AS numberOfCountries_20, t11.created AS created_21, t11.updated AS updated_22, t11.createdBy AS createdBy_23, t11.updatedBy AS updatedBy_24, t11.parent_id AS parent_id_25, t11.tournament_id AS tournament_id_26, t11.linkedNode_id AS linkedNode_id_27, t11.gameSorter_id AS gameSorter_id_28, t11.groupSorter_id AS groupSorter_id_29 FROM TournamentYear t0 LEFT JOIN TournamentTree t11 ON t11.tournament_id = t0.id WHERE t0.tournament_id = ? ORDER BY t0.year DESC
Parameters:
[
6
]
|
| 32 | 0.31 ms |
SELECT t0.id AS id_1, t0.year AS year_2, t0.tournamentType AS tournamentType_3, t0.gender AS gender_4, t0.winscore AS winscore_5, t0.created AS created_6, t0.updated AS updated_7, t0.createdBy AS createdBy_8, t0.updatedBy AS updatedBy_9, t0.tournament_id AS tournament_id_10, t11.id AS id_12, t11.name AS name_13, t11.leaf_type AS leaf_type_14, t11.lft AS lft_15, t11.rgt AS rgt_16, t11.root AS root_17, t11.lvl AS lvl_18, t11.qualificationStage AS qualificationStage_19, t11.numberOfCountries AS numberOfCountries_20, t11.created AS created_21, t11.updated AS updated_22, t11.createdBy AS createdBy_23, t11.updatedBy AS updatedBy_24, t11.parent_id AS parent_id_25, t11.tournament_id AS tournament_id_26, t11.linkedNode_id AS linkedNode_id_27, t11.gameSorter_id AS gameSorter_id_28, t11.groupSorter_id AS groupSorter_id_29 FROM TournamentYear t0 LEFT JOIN TournamentTree t11 ON t11.tournament_id = t0.id WHERE t0.tournament_id = ? ORDER BY t0.year DESC
Parameters:
[
7
]
|
| 33 | 0.38 ms |
SELECT t0.id AS id_1, t0.year AS year_2, t0.tournamentType AS tournamentType_3, t0.gender AS gender_4, t0.winscore AS winscore_5, t0.created AS created_6, t0.updated AS updated_7, t0.createdBy AS createdBy_8, t0.updatedBy AS updatedBy_9, t0.tournament_id AS tournament_id_10, t11.id AS id_12, t11.name AS name_13, t11.leaf_type AS leaf_type_14, t11.lft AS lft_15, t11.rgt AS rgt_16, t11.root AS root_17, t11.lvl AS lvl_18, t11.qualificationStage AS qualificationStage_19, t11.numberOfCountries AS numberOfCountries_20, t11.created AS created_21, t11.updated AS updated_22, t11.createdBy AS createdBy_23, t11.updatedBy AS updatedBy_24, t11.parent_id AS parent_id_25, t11.tournament_id AS tournament_id_26, t11.linkedNode_id AS linkedNode_id_27, t11.gameSorter_id AS gameSorter_id_28, t11.groupSorter_id AS groupSorter_id_29 FROM TournamentYear t0 LEFT JOIN TournamentTree t11 ON t11.tournament_id = t0.id WHERE t0.tournament_id = ? ORDER BY t0.year DESC
Parameters:
[
1
]
|
| 34 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbrev AS abbrev_3, t0.lft AS lft_4, t0.rgt AS rgt_5, t0.root AS root_6, t0.lvl AS lvl_7, t0.parent_id AS parent_id_8 FROM FieldPosition t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 35 | 0.15 ms |
SELECT MAX(b0_.created) AS sclr_0 FROM BackendEvent b0_
Parameters:
[] |
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 |
|---|---|
| Nft\StoreBundle\Entity\TournamentYear | 160 |
| Nft\StoreBundle\Entity\TournamentTree | 160 |
| Nft\StoreBundle\Entity\CountryImages | 48 |
| Nft\StoreBundle\Entity\PersonNationalTeamScores | 32 |
| Nft\StoreBundle\Entity\CountryNames | 10 |
| Nft\StoreBundle\Entity\Country | 9 |
| Nft\StoreBundle\Entity\FieldPosition | 8 |
| Nft\StoreBundle\Entity\NationalTeam | 8 |
| Nft\StoreBundle\Entity\CountryAssociation | 8 |
| Nft\StoreBundle\Entity\PersonClubScores | 7 |
| Nft\StoreBundle\Entity\Person | 7 |
| Nft\StoreBundle\Entity\Baconbauer | 7 |
| Nft\StoreBundle\Entity\Tournament | 7 |
| Nft\StoreBundle\Entity\Continent | 6 |
| Nft\StoreBundle\Entity\Confederation | 6 |
| Nft\StoreBundle\Entity\LeagueHistory | 3 |
| Nft\StoreBundle\Entity\Club | 1 |
| Nft\StoreBundle\Entity\ClubCountry | 1 |
| Nft\StoreBundle\Entity\ClubLeague | 1 |
| Nft\StoreBundle\Entity\League | 1 |
| Nft\StoreBundle\Entity\LeagueCategory | 1 |