Symfony Profiler

[
  "route" => "app_mainpage"
  "route_parameters" => [
    "_route" => "app_mainpage"
    "_controller" => "App\BlogBundle\Controller\AppController::indexAction"
  ]
  "request_uri" => "https://new.sakla.ru/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "mysql"
    "port" => 3306
    "user" => "sakla-user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "new_sakla_ru"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "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 - 05 - 12 ORDER BY n0_.added DESC"
]

[
  "sql" => "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 - 05 - 12 ORDER BY n0_.added DESC"
]

[
  "sql" => "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"
]

[
  "sql" => "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 - 05 - 12 ORDER BY n0_.added DESC"
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-05-19 18:20:47"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 76094
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2098
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 52258
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2098
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 12239
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2098
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 57592
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2098
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => """
    \n
                        SELECT\n
                            u.id,\n
                            u.username,\n
                            u.firstname,\n
                            u.surname,\n
                            u.avatar,\n
                            u.gender,\n
                            r.`2023` as rating\n
                        FROM rating_by_year r\n
                        LEFT JOIN user u ON r.user_id = u.id\n
                        WHERE r.`2023` IS NOT NULL\n
                        ORDER BY r.`2023` DESC\n
                        LIMIT 3\n
                    
    """
]

[
  "sql" => """
    \n
                        SELECT\n
                            u.id,\n
                            u.username,\n
                            u.firstname,\n
                            u.surname,\n
                            u.avatar,\n
                            u.gender,\n
                            r.`2024` as rating\n
                        FROM rating_by_year r\n
                        LEFT JOIN user u ON r.user_id = u.id\n
                        WHERE r.`2024` IS NOT NULL\n
                        ORDER BY r.`2024` DESC\n
                        LIMIT 3\n
                    
    """
]

[
  "sql" => """
    \n
                        SELECT\n
                            u.id,\n
                            u.username,\n
                            u.firstname,\n
                            u.surname,\n
                            u.avatar,\n
                            u.gender,\n
                            r.`2025` as rating\n
                        FROM rating_by_year r\n
                        LEFT JOIN user u ON r.user_id = u.id\n
                        WHERE r.`2025` IS NOT NULL\n
                        ORDER BY r.`2025` DESC\n
                        LIMIT 3\n
                    
    """
]

[
  "sql" => "SELECT s0_.mainphoto AS mainphoto_0, s0_.url AS url_1, s0_.rustitle AS rustitle_2 FROM slider s0_"
]

[
  "sql" => "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"
  "params" => [
    1 => "App\BlogBundle\Controller\AppController"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1"
  "params" => [
    1 => "pre-footer"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7
    2 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2098
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2098}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "App\BlogBundle\Controller\AppController"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1"
  "params" => [
    1 => "footer"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7
    2 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2098
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2098}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "App\BlogBundle\Controller\AppController"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1"
  "params" => [
    1 => "post-footer"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2101
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7
    2 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2098
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2098}
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]