Query Metrics
11
Database Queries
8
Different statements
117.49 ms
Query time
2
Invalid entities
347
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
101.53 ms (86.41%) |
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.username_canonical AS username_canonical_2, u0_.email AS email_3, u0_.email_canonical AS email_canonical_4, u0_.roles AS roles_5, u0_.password AS password_6, u0_.enabled AS enabled_7, u0_.locked AS locked_8, u0_.created AS created_9, u0_.rating AS rating_10, u0_.avatar AS avatar_11, u0_.game_count AS game_count_12, u0_.game_victory AS game_victory_13, u0_.firstname AS firstname_14, u0_.blogname AS blogname_15, u0_.surname AS surname_16, u0_.birthday AS birthday_17, u0_.gender AS gender_18, u0_.notification AS notification_19, u0_.school AS school_20, u0_.class AS class_21, u0_.city AS city_22, u0_.confirmation_token AS confirmation_token_23, u0_.password_requested_at AS password_requested_at_24, u0_.x1 AS x1_25, u0_.x2 AS x2_26, u0_.y1 AS y1_27, u0_.y2 AS y2_28, u0_.card_in_last_game AS card_in_last_game_29, u0_.district_id AS district_id_30, u0_.game_id AS game_id_31 FROM user u0_ ORDER BY u0_.rating DESC LIMIT 3
Parameters:
[] |
|
6.69 ms (5.69%) |
3 |
SELECT n0_.id AS id_0, n0_.material_id AS material_id_1, n0_.title AS title_2, n0_.picture AS picture_3, n0_.url AS url_4, n0_.category_title AS category_title_5, n0_.category_url AS category_url_6, n0_.added AS added_7 FROM new_matearial n0_ WHERE n0_.added > 2026 - 01 - 13 ORDER BY n0_.added DESC
Parameters:
[] |
|
4.21 ms (3.58%) |
1 |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.url AS url_2, n0_.annotation AS annotation_3, n0_.body AS body_4, n0_.created AS created_5, n0_.mainphoto AS mainphoto_6, n0_.likes AS likes_7, n0_.video AS video_8, n0_.status AS status_9, n0_.comments_count AS comments_count_10, n0_.viewing_count AS viewing_count_11, n0_.likes_count AS likes_count_12, n0_.user_id AS user_id_13 FROM news n0_ WHERE n0_.status = 1 AND n0_.created <= ? ORDER BY n0_.created DESC LIMIT 6
Parameters:
[
"2026-01-20 00:12:13"
]
|
|
1.60 ms (1.37%) |
2 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.roles AS roles_6, t0.password AS password_7, t0.enabled AS enabled_8, t0.locked AS locked_9, t0.created AS created_10, t0.rating AS rating_11, t0.avatar AS avatar_12, t0.game_count AS game_count_13, t0.game_victory AS game_victory_14, t0.firstname AS firstname_15, t0.blogname AS blogname_16, t0.surname AS surname_17, t0.birthday AS birthday_18, t0.gender AS gender_19, t0.notification AS notification_20, t0.school AS school_21, t0.class AS class_22, t0.city AS city_23, t0.confirmation_token AS confirmation_token_24, t0.password_requested_at AS password_requested_at_25, t0.x1 AS x1_26, t0.x2 AS x2_27, t0.y1 AS y1_28, t0.y2 AS y2_29, t0.card_in_last_game AS card_in_last_game_30, t0.district_id AS district_id_31, t0.game_id AS game_id_32 FROM user t0 WHERE t0.id = ?
Parameters:
[
12239
]
|
|
1.01 ms (0.86%) |
1 |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.added AS added_2, l0_.user_id AS user_id_3 FROM lenta l0_ ORDER BY l0_.id DESC LIMIT 20
Parameters:
[] |
|
0.97 ms (0.82%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.mainphoto AS mainphoto_3, p0_.text AS text_4, p0_.summary AS summary_5, p0_.status AS status_6, p0_.created AS created_7, p0_.updated AS updated_8, p0_.viewing_count AS viewing_count_9, p0_.comments_count AS comments_count_10, p0_.likes_count AS likes_count_11, p0_.dislikes_count AS dislikes_count_12, p0_.likes_balance AS likes_balance_13, p0_.user_id AS user_id_14 FROM post p0_ WHERE p0_.status = 1 ORDER BY p0_.id DESC LIMIT 9
Parameters:
[] |
|
0.88 ms (0.75%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.annotation AS annotation_2, c0_.text AS text_3, c0_.date_begin AS date_begin_4, c0_.date_end AS date_end_5, c0_.dateresult AS dateresult_6, c0_.is_published AS is_published_7, c0_.is_admin AS is_admin_8, c0_.slug AS slug_9, c0_.mainphoto AS mainphoto_10, c0_.viewed AS viewed_11, c0_.rating AS rating_12, c0_.is_anonymous AS is_anonymous_13, c0_.is_show AS is_show_14, c0_.file_type AS file_type_15 FROM contest c0_ ORDER BY c0_.id DESC LIMIT 6
Parameters:
[] |
|
0.60 ms (0.51%) |
1 |
SELECT s0_.mainphoto AS mainphoto_0, s0_.url AS url_1, s0_.rustitle AS rustitle_2 FROM slider s0_
Parameters:
[] |
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 |
|---|---|
| App\AdminBundle\Entity\NewMaterial | 289 |
| App\AdminBundle\Entity\Lenta | 20 |
| App\AdminBundle\Entity\User | 14 |
| App\AdminBundle\Entity\Post | 9 |
| App\AdminBundle\Entity\News | 6 |
| App\AdminBundle\Entity\Contest | 6 |
| App\AdminBundle\Entity\District | 2 |
| App\AdminBundle\Entity\Game | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\AdminBundle\Entity\Lenta | No errors. |
| App\AdminBundle\Entity\User |
|
| App\AdminBundle\Entity\NewMaterial | No errors. |
| App\AdminBundle\Entity\News | No errors. |
| App\AdminBundle\Entity\Contest |
|
| App\AdminBundle\Entity\Post | No errors. |
| App\AdminBundle\Entity\District | No errors. |
| App\AdminBundle\Entity\Game | No errors. |
| App\AdminBundle\Entity\Slider | No errors. |