GET https://new.sakla.ru/page/rules

Response
200 OK
IP
216.73.217.127
Profiled on
Token
ff110a

Query Metrics

45 Database Queries
6 Different statements
30.77 ms Query time
1 Invalid entities
35 Managed entities

Queries

Group similar statements

#▲ Time Info
1 2.75 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3, t0.textru AS textru_4, t0.textta AS textta_5 FROM pages t0 WHERE t0.path = ?
Parameters: 
[
  "rules"
]
View formatted query    View runnable query    Explain query
2 0.85 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
3 0.48 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "pre-header"
]
View formatted query    View runnable query    Explain query
4 0.65 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  8
]
View formatted query    View runnable query    Explain query
5 0.82 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
6 0.48 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "header"
]
View formatted query    View runnable query    Explain query
7 0.58 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  9
]
View formatted query    View runnable query    Explain query
8 0.57 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
9 0.46 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "post-header"
]
View formatted query    View runnable query    Explain query
10 0.48 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  10
]
View formatted query    View runnable query    Explain query
11 0.45 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
12 0.36 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "pre-body"
]
View formatted query    View runnable query    Explain query
13 2.01 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  11
]
View formatted query    View runnable query    Explain query
14 0.52 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
15 0.39 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "body"
]
View formatted query    View runnable query    Explain query
16 0.53 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  12
]
View formatted query    View runnable query    Explain query
17 0.51 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
18 0.50 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "post-body"
]
View formatted query    View runnable query    Explain query
19 0.56 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  13
]
View formatted query    View runnable query    Explain query
20 0.54 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
21 0.40 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "pre-right-sidebar"
]
View formatted query    View runnable query    Explain query
22 0.62 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  20
]
View formatted query    View runnable query    Explain query
23 1.02 ms 
SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.title AS title_2, o0_.text AS text_3, o0_.picture AS picture_4, o0_.material AS material_5, o0_.url AS url_6, o0_.rating AS rating_7, o0_.added AS added_8, o0_.user_id AS user_id_9 FROM occasion o0_ WHERE o0_.type <> 'post' ORDER BY o0_.id DESC LIMIT 7
Parameters: 
[]
View formatted query    View runnable query    Explain query
24 1.01 ms 
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: 
[
  75259
]
View formatted query    View runnable query    Explain query
25 1.00 ms 
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: 
[
  61942
]
View formatted query    View runnable query    Explain query
26 0.87 ms 
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: 
[
  76010
]
View formatted query    View runnable query    Explain query
27 0.56 ms 
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: 
[
  56501
]
View formatted query    View runnable query    Explain query
28 0.63 ms 
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: 
[
  75483
]
View formatted query    View runnable query    Explain query
29 0.52 ms 
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: 
[
  75491
]
View formatted query    View runnable query    Explain query
30 0.69 ms 
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: 
[
  74304
]
View formatted query    View runnable query    Explain query
31 0.49 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
32 0.42 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "right-sidebar"
]
View formatted query    View runnable query    Explain query
33 2.68 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  21
]
View formatted query    View runnable query    Explain query
34 0.56 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
35 0.46 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "post-right-sidebar"
]
View formatted query    View runnable query    Explain query
36 0.51 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  22
]
View formatted query    View runnable query    Explain query
37 0.41 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
38 0.44 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "pre-footer"
]
View formatted query    View runnable query    Explain query
39 0.54 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  14
]
View formatted query    View runnable query    Explain query
40 0.41 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
41 0.34 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "footer"
]
View formatted query    View runnable query    Explain query
42 0.46 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  15
]
View formatted query    View runnable query    Explain query
43 0.35 ms 
SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1
Parameters: 
[
  "App\BlogBundle\Controller\PageController"
]
View formatted query    View runnable query    Explain query
44 0.39 ms 
SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1
Parameters: 
[
  "post-footer"
]
View formatted query    View runnable query    Explain query
45 0.49 ms 
SELECT t0.id AS id_1, t0.rusannotation AS rusannotation_2, t0.tatannotation AS tatannotation_3, t0.rustitle AS rustitle_4, t0.tattitle AS tattitle_5, t0.mainphoto AS mainphoto_6, t0.url AS url_7, t0.divclass AS divclass_8, t0.controller_id AS controller_id_9, t0.templates_id AS templates_id_10 FROM banner t0 WHERE t0.controller_id = ? AND t0.templates_id = ?
Parameters: 
[
  8
  16
]
View formatted query    View runnable query    Explain query

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\BlogBundle\Entity\Template 12
App\BlogBundle\Entity\Occasion 7
App\BlogBundle\Entity\User 7
App\BlogBundle\Entity\District 6
App\BlogBundle\Entity\Page 1
App\BlogBundle\Entity\Controller 1
App\BlogBundle\Entity\Game 1

Entities Mapping

Class Mapping errors
App\BlogBundle\Entity\Page No errors.
App\BlogBundle\Entity\Controller No errors.
App\BlogBundle\Entity\Template No errors.
App\BlogBundle\Entity\Banner No errors.
App\BlogBundle\Entity\Occasion No errors.
App\BlogBundle\Entity\User
  • The association App\BlogBundle\Entity\User#game refers to the inverse side field App\BlogBundle\Entity\Game#users which does not exist.
App\BlogBundle\Entity\District No errors.
App\BlogBundle\Entity\Game No errors.
App\BlogBundle\Entity\Post No errors.