Query Metrics

28 Database Queries
9 Different statements
7.30 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.56 ms
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.main AS main_4, t0.date_create AS date_create_5, t0.date_update AS date_update_6, t0.object_status AS object_status_7, t0.club_id AS club_id_8, t0.logo_id AS logo_id_9 FROM team t0 WHERE t0.main = ? LIMIT 1
Parameters:
[
  1
]
2 0.47 ms
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.object_status AS object_status_6, t0.logo_id AS logo_id_7, t0.city_id AS city_id_8 FROM club t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.33 ms
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.main AS main_4, t0.date_create AS date_create_5, t0.date_update AS date_update_6, t0.object_status AS object_status_7, t0.club_id AS club_id_8, t0.logo_id AS logo_id_9 FROM team t0 WHERE t0.club_id = ?
Parameters:
[
  1
]
4 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.current AS current_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.object_status AS object_status_6, t0.team_id AS team_id_7 FROM season t0 WHERE t0.team_id = ? AND t0.object_status = ?
Parameters:
[
  4
  "active"
]
5 0.45 ms
SELECT t0_.id AS id_0, t0_.full_name AS full_name_1, t0_.short_name AS short_name_2, t0_.yandex_id AS yandex_id_3, t0_.date_start AS date_start_4, t0_.date_end AS date_end_5, t0_.date_create AS date_create_6, t0_.date_update AS date_update_7, t0_.object_status AS object_status_8, t0_.type_id AS type_id_9, t0_.season_id AS season_id_10, t0_.logo_id AS logo_id_11 FROM tournament t0_ WHERE t0_.season_id = ? AND t0_.object_status = ? ORDER BY t0_.id ASC
Parameters:
[
  6
  "active"
]
6 0.32 ms
SELECT t0.id AS id_1, t0.points_for_win AS points_for_win_2, t0.points_for_defeat AS points_for_defeat_3, t0.points_for_draw AS points_for_draw_4, t0.points_for_shootout_win AS points_for_shootout_win_5, t0.points_for_shootout_defeat AS points_for_shootout_defeat_6, t0.tournament_type_id AS tournament_type_id_7, t0.tournament_id AS tournament_id_8 FROM tournament_setting t0 WHERE t0.tournament_id = ?
Parameters:
[
  7
]
7 0.28 ms
SELECT t0.id AS id_1, t0.points_for_win AS points_for_win_2, t0.points_for_defeat AS points_for_defeat_3, t0.points_for_draw AS points_for_draw_4, t0.points_for_shootout_win AS points_for_shootout_win_5, t0.points_for_shootout_defeat AS points_for_shootout_defeat_6, t0.tournament_type_id AS tournament_type_id_7, t0.tournament_id AS tournament_id_8 FROM tournament_setting t0 WHERE t0.tournament_id = ?
Parameters:
[
  9
]
8 0.27 ms
SELECT t0.id AS id_1, t0.tournament_id AS tournament_id_2, t0.tournament_group_id AS tournament_group_id_3, t0.team_id AS team_id_4 FROM tournament_team t0 WHERE t0.tournament_id = ?
Parameters:
[
  7
]
9 0.31 ms
SELECT t0.id AS id_1, t0.tournament_id AS tournament_id_2, t0.tournament_group_id AS tournament_group_id_3, t0.team_id AS team_id_4 FROM tournament_team t0 WHERE t0.tournament_id = ?
Parameters:
[
  9
]
10 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.line AS line_4, t0.link AS link_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8, t0.preview_image_id AS preview_image_id_9 FROM partner t0 WHERE t0.object_status = ? ORDER BY t0.line ASC, t0.priority ASC
Parameters:
[
  "active"
]
11 0.31 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43985
]
12 0.20 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  42288
]
13 0.19 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  42273
]
14 0.17 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43986
]
15 0.25 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43987
]
16 0.20 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43996
]
17 0.25 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43988
]
18 0.17 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43989
]
19 0.17 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43990
]
20 0.21 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43991
]
21 0.15 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43992
]
22 0.16 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43994
]
23 0.17 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43995
]
24 0.18 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  42271
]
25 0.18 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  42280
]
26 0.19 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43997
]
27 0.17 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  42532
]
28 0.15 ms
SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
  43998
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Team\Team No errors.
App\Entity\Team\Club
  • The association App\Entity\Team\Club#city refers to the inverse side field App\Entity\Reference\City#clubs which does not exist.
App\Entity\Service\File No errors.
App\Entity\Team\TeamPlayer No errors.
App\Entity\Team\TeamStaff No errors.
App\Entity\Team\TeamPersonnel No errors.
App\Entity\Game\Game
  • The field App\Entity\Game\Game#gameEvents is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Game\GameEvent#game does not contain the required 'inversedBy="gameEvents"' attribute.
  • The mappings App\Entity\Game\Game#gameNews and App\Entity\Service\NewsGame#game are inconsistent with each other.
  • The mappings App\Entity\Game\Game#gameVideos and App\Entity\Service\VideoGame#game are inconsistent with each other.
  • The mappings App\Entity\Game\Game#gamePhotos and App\Entity\Service\PhotoGame#game are inconsistent with each other.
App\Entity\Reference\City No errors.
App\Entity\Team\ClubPlayer No errors.
App\Entity\Team\ClubStaff No errors.
App\Entity\Team\ClubPersonnel No errors.
App\Entity\Tournament\Season No errors.
App\Entity\Tournament\Tournament No errors.
App\Entity\Tournament\TournamentType No errors.
App\Entity\Tournament\Group No errors.
App\Entity\Tournament\TournamentTeam No errors.
App\Entity\Tournament\Stage No errors.
App\Entity\Tournament\TournamentSetting No errors.
App\Entity\Tournament\Tour No errors.
App\Entity\Content\Partner No errors.