Symfony Profiler

[
  "route" => "contest_list"
  "route_parameters" => [
    "_route" => "contest_list"
    "_controller" => "App\Controller\Contest\ContestController::list"
  ]
  "request_uri" => "https://beta22.photopost.cz/fototema"
  "method" => "GET"
]

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

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

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

[
  "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" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\OnlineTrackingSubscriber::onKernelRequest"
]

[
  "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" => "localhost"
    "port" => null
    "user" => "photopostng"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "photopostng"
    "serverVersion" => "11.4.8-MariaDB"
    "charset" => "utf8mb4"
    "unix_socket" => "/var/run/mysql/mysql.sock"
  ]
]

[
  "sql" => "SELECT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1, f0_.fotoesej_tema_text AS fotoesej_tema_text_2, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3, f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4, f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5, f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6, f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7 FROM fotoesej_tema f0_ WHERE f0_.fotoesej_tema_termin > ? ORDER BY f0_.fotoesej_tema_termin ASC LIMIT 1"
  "params" => [
    1 => "2026-05-10 16:22:29"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#511
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1, f0_.fotoesej_tema_text AS fotoesej_tema_text_2, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3, f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4, f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5, f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6, f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7 FROM fotoesej_tema f0_ WHERE f0_.fotoesej_tema_termin <= ? AND f0_.fotoesej_tema_termin > ? ORDER BY f0_.fotoesej_tema_termin DESC LIMIT 1"
  "params" => [
    1 => "2026-05-10 16:22:29"
    2 => "2026-04-30 16:22:29"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#511
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#511}
  ]
]

[
  "sql" => "SELECT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1, f0_.fotoesej_tema_text AS fotoesej_tema_text_2, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3, f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4, f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5, f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6, f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7 FROM fotoesej_tema f0_ WHERE f0_.fotoesej_tema_termin <= ? ORDER BY f0_.fotoesej_tema_termin DESC LIMIT 1"
  "params" => [
    1 => "2026-04-30 16:22:29"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#511
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT f0_.fotoesej_foto_id AS fotoesej_foto_id_0, f0_.fotoesej_foto_url AS fotoesej_foto_url_1, f0_.fotoesej_foto_hlasu AS fotoesej_foto_hlasu_2, a1_.autor_id AS autor_id_3, a1_.autor_login AS autor_login_4, a1_.autor_pass AS autor_pass_5, a1_.autor_pass2 AS autor_pass2_6, a1_.autor_mail AS autor_mail_7, a1_.autor_jmeno AS autor_jmeno_8, a1_.autor_prijmeni AS autor_prijmeni_9, a1_.autor_blok AS autor_blok_10, a1_.autor_ikonka AS autor_ikonka_11, a1_.autor_body AS autor_body_12, a1_.autor_fotek AS autor_fotek_13, a1_.autor_komentaru AS autor_komentaru_14, a1_.autor_hodnoceni AS autor_hodnoceni_15, a1_.autor_predplatne AS autor_predplatne_16, a1_.autor_technika AS autor_technika_17, a1_.autor_poznamka AS autor_poznamka_18, a1_.autor_prodejni_info AS autor_prodejni_info_19, a1_.autor_ip AS autor_ip_20, a1_.autor_prihlaseni AS autor_prihlaseni_21, a1_.autor_last_upload AS autor_last_upload_22, a1_.autor_ftp AS autor_ftp_23, a1_.autor_mailpp AS autor_mailpp_24, a1_.autor_posta AS autor_posta_25, a1_.autor_postanew AS autor_postanew_26, a1_.lat AS lat_27, a1_.lon AS lon_28, a1_.heslo_token AS heslo_token_29, a1_.heslo_token_platnost AS heslo_token_platnost_30, a1_.novinky_zasilat AS novinky_zasilat_31, a1_.novinky_token AS novinky_token_32, a1_.autor_flag_bazar AS autor_flag_bazar_33, a1_.autor_flag_bmfoto AS autor_flag_bmfoto_34, a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_35, a1_.autor_flag_posta_back AS autor_flag_posta_back_36, a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_37, a1_.autor_flag_profil AS autor_flag_profil_38, a1_.autor_flag_clanky AS autor_flag_clanky_39, a1_.autor_flag_beztlach AS autor_flag_beztlach_40, a1_.autor_flag_foto_kom AS autor_flag_foto_kom_41, a1_.autor_flag_bmstart AS autor_flag_bmstart_42, a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_43, a1_.autor_role AS autor_role_44, f0_.fotoesej_foto_autorid AS fotoesej_foto_autorid_45, f0_.fotoesej_foto_temaid AS fotoesej_foto_temaid_46 FROM fotoesej_foto f0_ LEFT JOIN autor a1_ ON f0_.fotoesej_foto_autorid = a1_.autor_id WHERE f0_.fotoesej_foto_temaid = ? ORDER BY f0_.fotoesej_foto_hlasu DESC"
  "params" => [
    1 => 283
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before"
]

[
  "sql" => "SELECT count(DISTINCT f0_.fotoesej_tema_id) AS sclr_0 FROM fotoesej_tema f0_ LEFT JOIN autor a1_ ON f0_.fotoesej_tema_autorid = a1_.autor_id"
]

[
  "sql" => "SELECT DISTINCT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_1 FROM fotoesej_tema f0_ LEFT JOIN autor a1_ ON f0_.fotoesej_tema_autorid = a1_.autor_id ORDER BY f0_.fotoesej_tema_datum DESC LIMIT 20"
]

[
  "sql" => "SELECT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1, f0_.fotoesej_tema_text AS fotoesej_tema_text_2, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3, f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4, f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5, f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6, a1_.autor_id AS autor_id_7, a1_.autor_login AS autor_login_8, a1_.autor_pass AS autor_pass_9, a1_.autor_pass2 AS autor_pass2_10, a1_.autor_mail AS autor_mail_11, a1_.autor_jmeno AS autor_jmeno_12, a1_.autor_prijmeni AS autor_prijmeni_13, a1_.autor_blok AS autor_blok_14, a1_.autor_ikonka AS autor_ikonka_15, a1_.autor_body AS autor_body_16, a1_.autor_fotek AS autor_fotek_17, a1_.autor_komentaru AS autor_komentaru_18, a1_.autor_hodnoceni AS autor_hodnoceni_19, a1_.autor_predplatne AS autor_predplatne_20, a1_.autor_technika AS autor_technika_21, a1_.autor_poznamka AS autor_poznamka_22, a1_.autor_prodejni_info AS autor_prodejni_info_23, a1_.autor_ip AS autor_ip_24, a1_.autor_prihlaseni AS autor_prihlaseni_25, a1_.autor_last_upload AS autor_last_upload_26, a1_.autor_ftp AS autor_ftp_27, a1_.autor_mailpp AS autor_mailpp_28, a1_.autor_posta AS autor_posta_29, a1_.autor_postanew AS autor_postanew_30, a1_.lat AS lat_31, a1_.lon AS lon_32, a1_.heslo_token AS heslo_token_33, a1_.heslo_token_platnost AS heslo_token_platnost_34, a1_.novinky_zasilat AS novinky_zasilat_35, a1_.novinky_token AS novinky_token_36, a1_.autor_flag_bazar AS autor_flag_bazar_37, a1_.autor_flag_bmfoto AS autor_flag_bmfoto_38, a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_39, a1_.autor_flag_posta_back AS autor_flag_posta_back_40, a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_41, a1_.autor_flag_profil AS autor_flag_profil_42, a1_.autor_flag_clanky AS autor_flag_clanky_43, a1_.autor_flag_beztlach AS autor_flag_beztlach_44, a1_.autor_flag_foto_kom AS autor_flag_foto_kom_45, a1_.autor_flag_bmstart AS autor_flag_bmstart_46, a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_47, a1_.autor_role AS autor_role_48, f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_49 FROM fotoesej_tema f0_ LEFT JOIN autor a1_ ON f0_.fotoesej_tema_autorid = a1_.autor_id WHERE f0_.fotoesej_tema_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.fotoesej_tema_datum DESC"
  "params" => [
    1 => 283
    2 => 282
    3 => 281
    4 => 280
    5 => 279
    6 => 278
    7 => 277
    8 => 276
    9 => 275
    10 => 274
    11 => 273
    12 => 272
    13 => 271
    14 => 270
    15 => 269
    16 => 268
    17 => 267
    18 => 266
    19 => 265
    20 => 264
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#610
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#610}
    3 => Doctrine\DBAL\ParameterType {#610}
    4 => Doctrine\DBAL\ParameterType {#610}
    5 => Doctrine\DBAL\ParameterType {#610}
    6 => Doctrine\DBAL\ParameterType {#610}
    7 => Doctrine\DBAL\ParameterType {#610}
    8 => Doctrine\DBAL\ParameterType {#610}
    9 => Doctrine\DBAL\ParameterType {#610}
    10 => Doctrine\DBAL\ParameterType {#610}
    11 => Doctrine\DBAL\ParameterType {#610}
    12 => Doctrine\DBAL\ParameterType {#610}
    13 => Doctrine\DBAL\ParameterType {#610}
    14 => Doctrine\DBAL\ParameterType {#610}
    15 => Doctrine\DBAL\ParameterType {#610}
    16 => Doctrine\DBAL\ParameterType {#610}
    17 => Doctrine\DBAL\ParameterType {#610}
    18 => Doctrine\DBAL\ParameterType {#610}
    19 => Doctrine\DBAL\ParameterType {#610}
    20 => Doctrine\DBAL\ParameterType {#610}
  ]
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ArraySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\CollectionSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::pagination"
]

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

[
  "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" => "App\EventSubscriber\SecurityHeadersSubscriber::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\Security\Http\RememberMe\ResponseListener::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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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