GET https://test.fcakron.ru/

Query Metrics

45 Database Queries
12 Different statements
19.35 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 8.14 ms
SELECT n0_.id AS id_0, n0_.full_title AS full_title_1, n0_.short_title AS short_title_2, n0_.preview_text AS preview_text_3, n0_.text AS text_4, n0_.show_in_slider AS show_in_slider_5, n0_.date_publication AS date_publication_6, n0_.priority AS priority_7, n0_.video_link AS video_link_8, n0_.is_draft AS is_draft_9, n0_.date_create AS date_create_10, n0_.date_update AS date_update_11, n0_.object_status AS object_status_12, n0_.preview_image_id AS preview_image_id_13, n0_.header_image_id AS header_image_id_14, n0_.player_id AS player_id_15, n0_.staff_id AS staff_id_16, n0_.personnel_id AS personnel_id_17 FROM news n0_ WHERE n0_.show_in_slider = 1 AND n0_.object_status = ? AND n0_.is_draft = 0
Parameters:
[
  "active"
]
2 0.73 ms
SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.news_id AS news_id_5, t0.tag_id AS tag_id_6 FROM news_tag t0 WHERE t0.news_id = ?
Parameters:
[
  2098
]
3 0.44 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:
[
  43771
]
4 0.36 ms
SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.news_id AS news_id_5, t0.tag_id AS tag_id_6 FROM news_tag t0 WHERE t0.news_id = ?
Parameters:
[
  2105
]
5 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:
[
  43787
]
6 0.16 ms
SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.news_id AS news_id_5, t0.tag_id AS tag_id_6 FROM news_tag t0 WHERE t0.news_id = ?
Parameters:
[
  2119
]
7 0.13 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:
[
  43951
]
8 0.15 ms
SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.news_id AS news_id_5, t0.tag_id AS tag_id_6 FROM news_tag t0 WHERE t0.news_id = ?
Parameters:
[
  2123
]
9 0.12 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:
[
  43952
]
10 0.19 ms
SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.news_id AS news_id_5, t0.tag_id AS tag_id_6 FROM news_tag t0 WHERE t0.news_id = ?
Parameters:
[
  2124
]
11 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:
[
  43955
]
12 0.52 ms
SELECT p0_.id AS id_0, p0_.full_title AS full_title_1, p0_.short_title AS short_title_2, p0_.show_in_slider AS show_in_slider_3, p0_.date_publication AS date_publication_4, p0_.priority AS priority_5, p0_.date_create AS date_create_6, p0_.date_update AS date_update_7, p0_.object_status AS object_status_8, p0_.preview_image_id AS preview_image_id_9, p0_.header_image_id AS header_image_id_10 FROM photo p0_ WHERE p0_.show_in_slider = 1 AND p0_.object_status = ?
Parameters:
[
  "active"
]
13 0.84 ms
SELECT v0_.id AS id_0, v0_.full_title AS full_title_1, v0_.short_title AS short_title_2, v0_.show_in_slider AS show_in_slider_3, v0_.date_publication AS date_publication_4, v0_.link AS link_5, v0_.text AS text_6, v0_.priority AS priority_7, v0_.date_create AS date_create_8, v0_.date_update AS date_update_9, v0_.object_status AS object_status_10, v0_.preview_image_id AS preview_image_id_11, v0_.header_image_id AS header_image_id_12 FROM video v0_ WHERE v0_.show_in_slider = 1 AND v0_.object_status = ?
Parameters:
[
  "active"
]
14 0.55 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.current = ? AND t0.object_status = ?
Parameters:
[
  1
  "active"
]
15 0.59 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 IN (?, ?) AND t0_.object_status = ? ORDER BY t0_.id ASC
Parameters:
[
  6
  8
  "active"
]
16 0.39 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
]
17 0.22 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
]
18 0.31 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:
[
  12
]
19 0.42 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
]
20 0.47 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.id = ?
Parameters:
[
  4
]
21 0.29 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:
[
  43009
]
22 0.20 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
]
23 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:
[
  43012
]
24 0.16 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:
[
  12
]
25 0.48 ms
SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.image_id AS image_id_5 FROM banner t0 WHERE t0.object_status = ? LIMIT 1
Parameters:
[
  "active"
]
26 0.24 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:
[
  42309
]
27 0.49 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"
]
28 0.23 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
]
29 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:
[
  42288
]
30 0.24 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
]
31 0.13 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
]
32 0.11 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
]
33 0.14 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
]
34 0.11 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
]
35 0.09 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
]
36 0.10 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
]
37 0.13 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
]
38 0.10 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
]
39 0.09 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
]
40 0.09 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
]
41 0.09 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
]
42 0.10 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
]
43 0.11 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
]
44 0.09 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
]
45 0.09 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\Content\News No errors.
App\Entity\Service\File No errors.
App\Entity\Human\Player No errors.
App\Entity\Human\Staff No errors.
App\Entity\Human\Personnel No errors.
App\Entity\Service\NewsImage No errors.
App\Entity\Service\NewsTag No errors.
App\Entity\Service\NewsGame
  • The association App\Entity\Service\NewsGame#game refers to the inverse side field App\Entity\Game\Game#news which does not exist.
App\Entity\Service\Tag No errors.
App\Entity\Content\Photo No errors.
App\Entity\Content\Video No errors.
App\Entity\Tournament\Season No errors.
App\Entity\Team\Team 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\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\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\Content\Banner No errors.
App\Entity\Content\Partner No errors.
App\Entity\Team\ClubPlayer No errors.
App\Entity\Service\Document No errors.
App\Entity\Statistic\PlayerStatistic No errors.
App\Entity\Reference\Country No errors.
App\Entity\Reference\Sex No errors.
App\Entity\Team\ClubStaff No errors.
App\Entity\Team\ClubPersonnel No errors.
App\Entity\Service\PhotoImage No errors.
App\Entity\Service\PhotoGame
  • The association App\Entity\Service\PhotoGame#game refers to the inverse side field App\Entity\Game\Game#photo which does not exist.
App\Entity\Service\VideoGame
  • The association App\Entity\Service\VideoGame#game refers to the inverse side field App\Entity\Game\Game#video which does not exist.
App\Entity\Tournament\TournamentTable No errors.
App\Entity\Reference\City No errors.
App\Entity\Game\GamePlayer No errors.
App\Entity\Game\GameEvent No errors.
App\Entity\Content\Stadium
  • The association App\Entity\Content\Stadium#city refers to the inverse side field App\Entity\Reference\City#stadiums which does not exist.
App\Entity\Game\GameStaff No errors.
App\Entity\Game\GameReferee No errors.
App\Entity\Game\GameStats No errors.