GET https://test.fcakron.ru/news/2127

Query Metrics

37 Database Queries
7 Different statements
13.11 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.88 ms
SELECT t0.id AS id_1, t0.full_title AS full_title_2, t0.short_title AS short_title_3, t0.preview_text AS preview_text_4, t0.text AS text_5, t0.show_in_slider AS show_in_slider_6, t0.date_publication AS date_publication_7, t0.priority AS priority_8, t0.video_link AS video_link_9, t0.is_draft AS is_draft_10, t0.date_create AS date_create_11, t0.date_update AS date_update_12, t0.object_status AS object_status_13, t0.preview_image_id AS preview_image_id_14, t0.header_image_id AS header_image_id_15, t0.player_id AS player_id_16, t0.staff_id AS staff_id_17, t0.personnel_id AS personnel_id_18 FROM news t0 WHERE t0.id = ?
Parameters:
[
  2127
]
2 0.81 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:
[
  2127
]
3 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.object_status AS object_status_5 FROM tag t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 1.99 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_.id <> ? AND n0_.object_status = ? AND n0_.is_draft = 0 ORDER BY n0_.date_publication DESC LIMIT 5
Parameters:
[
  2127
  "active"
]
5 0.44 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:
[
  2129
]
6 0.40 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:
[
  43981
]
7 0.22 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:
[
  2128
]
8 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:
[
  43977
]
9 0.28 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
]
10 0.22 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
]
11 0.17 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:
[
  2126
]
12 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:
[
  43967
]
13 0.20 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:
[
  2125
]
14 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.object_status AS object_status_5 FROM tag t0 WHERE t0.id = ?
Parameters:
[
  5
]
15 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:
[
  43958
]
16 0.34 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:
[
  43976
]
17 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.object_status AS object_status_5, t0.file_id AS file_id_6, t0.news_id AS news_id_7 FROM news_image t0 WHERE t0.news_id = ?
Parameters:
[
  2127
]
18 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:
[
  43975
]
19 0.55 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"
]
20 0.39 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
]
21 0.34 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
]
22 0.34 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
]
23 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:
[
  43986
]
24 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:
[
  43987
]
25 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:
[
  43996
]
26 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:
[
  43988
]
27 0.26 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
]
28 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:
[
  43990
]
29 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:
[
  43991
]
30 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:
[
  43992
]
31 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:
[
  43994
]
32 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:
[
  43995
]
33 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:
[
  42271
]
34 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:
[
  42280
]
35 0.22 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
]
36 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:
[
  42532
]
37 0.33 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\Partner No errors.
App\Entity\Team\TeamPlayer 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\TeamStaff No errors.
App\Entity\Team\ClubStaff No errors.
App\Entity\Team\TeamPersonnel No errors.
App\Entity\Team\ClubPersonnel 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.