Query Metrics

15 Database Queries
7 Different statements
10.37 ms Query time
0 Invalid entities
33 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.32 ms
(41.62%)
7
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
]
1.69 ms
(16.24%)
3
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
]
1.47 ms
(14.20%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.body AS body_4, t0.status AS status_5, t0.createdAt AS createdAt_6, t0.thumbnail AS thumbnail_7, t0.publicationStartsAt AS publicationStartsAt_8, t0.media AS media_9, t0.youtubeVideos AS youtubeVideos_10, t0.facebookGallery AS facebookGallery_11, t0.category_id AS category_id_12 FROM article t0 WHERE t0.id = ?
Parameters:
[
  "558"
]
0.82 ms
(7.92%)
1
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
]
0.78 ms
(7.49%)
1
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
]
0.65 ms
(6.29%)
1
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
]
0.65 ms
(6.24%)
1
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
]

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\Sponsor\Sponsor 18
Core\Entity\Football\CompetitionExecution 3
Core\Entity\Football\Competition 3
Core\Entity\Football\CompetitionLogos 2
Core\Entity\Article\Article 1
Core\Entity\Article\Category 1
Core\Entity\Settings\Settings 1
Core\Entity\Football\Team\Team 1
Core\Entity\Settings\SeasonSettings 1
Core\Entity\Football\Selection 1
Core\Entity\Football\Team\SeasonTeam 1