GET https://new.ndbeltinci.net/ekipa/2023/clani/igralec/382/marin-rantasa

Query Metrics

46 Database Queries
13 Different statements
30.09 ms Query time
0 Invalid entities
96 Managed entities

Queries

Group similar statements

# 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