Symfony Profiler

[
  "route" => "award_photo_report"
  "route_parameters" => [
    "_route" => "award_photo_report"
    "id" => null
    "_controller" => "App\Controller\AwardController::photoReport"
    "_region" => "msk"
  ]
  "request_uri" => "https://stg.4banket.ru/msk/award/photo-report?page=4"
  "method" => "GET"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "4bn-2.0-stg"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "4bn-2.0-stg"
    "serverVersion" => "5.7"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "msk"
  ]
  "types" => [
    1 => 2
  ]
]

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

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

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

[
  "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\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "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" => "App\EventSubscriber\RegionEventSubscriber::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" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::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" => "ContainerW4idkXj\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.archive AS archive_4, t0.about AS about_5, t0.destinations AS destinations_6, t0.start AS start_7, t0.end AS end_8, t0.application_end AS application_end_9, t0.voting_start AS voting_start_10, t0.voting_end AS voting_end_11, t0.create_short_list_start AS create_short_list_start_12, t0.create_short_list_end AS create_short_list_end_13, t0.adjudicator_voting_start AS adjudicator_voting_start_14, t0.adjudicator_voting_end AS adjudicator_voting_end_15, t0.rewarding AS rewarding_16, t0.phone AS phone_17, t0.email AS email_18, t0.whats_app AS whats_app_19, t0.website AS website_20, t0.position AS position_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.about_image_id AS about_image_id_24, t0.destinations_image_id AS destinations_image_id_25, t0.stages_image_id AS stages_image_id_26, t0.banner_image_id AS banner_image_id_27, t0.presentation_id AS presentation_id_28, t0.regulations_id AS regulations_id_29 FROM award t0 WHERE t0.active = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.active AS active_2, a0_.archive AS archive_3, a0_.about AS about_4, a0_.destinations AS destinations_5, a0_.start AS start_6, a0_.end AS end_7, a0_.application_end AS application_end_8, a0_.voting_start AS voting_start_9, a0_.voting_end AS voting_end_10, a0_.create_short_list_start AS create_short_list_start_11, a0_.create_short_list_end AS create_short_list_end_12, a0_.adjudicator_voting_start AS adjudicator_voting_start_13, a0_.adjudicator_voting_end AS adjudicator_voting_end_14, a0_.rewarding AS rewarding_15, a0_.phone AS phone_16, a0_.email AS email_17, a0_.whats_app AS whats_app_18, a0_.website AS website_19, a0_.position AS position_20, a0_.created_at AS created_at_21, a0_.updated_at AS updated_at_22, a0_.about_image_id AS about_image_id_23, a0_.destinations_image_id AS destinations_image_id_24, a0_.stages_image_id AS stages_image_id_25, a0_.banner_image_id AS banner_image_id_26, a0_.presentation_id AS presentation_id_27, a0_.regulations_id AS regulations_id_28 FROM award a0_ ORDER BY a0_.position ASC"
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.hash AS hash_1, f0_.path AS path_2, f0_.link AS link_3, f0_.name AS name_4, f0_.file_name AS file_name_5, f0_.mime_type AS mime_type_6, f0_.size AS size_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9 FROM file f0_ INNER JOIN award_image a2_ ON f0_.id = a2_.file_id INNER JOIN award a1_ ON a1_.id = a2_.award_id WHERE a1_.id = 1) dctrn_result) dctrn_table"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.link AS link_2, t0.title AS title_3, t0.h1 AS h1_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM seo_static_meta t0 WHERE t0.link = ? LIMIT 1"
  "params" => [
    1 => "/msk/award/photo-report"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.hash AS hash_1, f0_.path AS path_2, f0_.link AS link_3, f0_.name AS name_4, f0_.file_name AS file_name_5, f0_.mime_type AS mime_type_6, f0_.size AS size_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9 FROM file f0_ INNER JOIN award_image a2_ ON f0_.id = a2_.file_id INNER JOIN award a1_ ON a1_.id = a2_.award_id WHERE a1_.id = 1) dctrn_result LIMIT 16 OFFSET 48"
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.hash AS hash_1, f0_.path AS path_2, f0_.link AS link_3, f0_.name AS name_4, f0_.file_name AS file_name_5, f0_.mime_type AS mime_type_6, f0_.size AS size_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9 FROM file f0_ INNER JOIN award_image a2_ ON f0_.id = a2_.file_id INNER JOIN award a1_ ON a1_.id = a2_.award_id WHERE a1_.id = 1 AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 23887
    2 => 23888
    3 => 23889
    4 => 23890
    5 => 23891
    6 => 23892
    7 => 23893
    8 => 23894
    9 => 23895
    10 => 23896
    11 => 23897
    12 => 23898
    13 => 23899
    14 => 23900
    15 => 23901
    16 => 23902
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.hash AS hash_2, t0.path AS path_3, t0.link AS link_4, t0.name AS name_5, t0.file_name AS file_name_6, t0.mime_type AS mime_type_7, t0.size AS size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM file t0 WHERE t0.id = ?"
  "params" => [
    1 => 23838
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::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\UX\LiveComponent\EventListener\LiveComponentSubscriber::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"
]