GET https://new.sakla.ru/

Query Metrics

11 Database Queries
8 Different statements
117.49 ms Query time
2 Invalid entities
347 Managed entities

Grouped Statements

Show all queries

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
  • The association App\AdminBundle\Entity\User#game refers to the inverse side field App\AdminBundle\Entity\Game#users which does not exist.
App\AdminBundle\Entity\NewMaterial No errors.
App\AdminBundle\Entity\News No errors.
App\AdminBundle\Entity\Contest
  • The field 'App\AdminBundle\Entity\Contest#is_published' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\AdminBundle\Entity\Post No errors.
App\AdminBundle\Entity\District No errors.
App\AdminBundle\Entity\Game No errors.
App\AdminBundle\Entity\Slider No errors.