Symfony Profiler

[
  "route" => "contest_photo_detail"
  "route_parameters" => [
    "_route" => "contest_photo_detail"
    "_controller" => "App\Controller\Contest\ContestController::photoDetail"
    "id" => "1122"
  ]
  "request_uri" => "https://beta22.photopost.cz/fototema/foto/1122"
  "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_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, f2_.fotoesej_tema_id AS fotoesej_tema_id_45, f2_.fotoesej_tema_nazev AS fotoesej_tema_nazev_46, f2_.fotoesej_tema_text AS fotoesej_tema_text_47, f2_.fotoesej_tema_datum AS fotoesej_tema_datum_48, f2_.fotoesej_tema_termin AS fotoesej_tema_termin_49, f2_.fotoesej_tema_fotek AS fotoesej_tema_fotek_50, f2_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_51, f0_.fotoesej_foto_autorid AS fotoesej_foto_autorid_52, f0_.fotoesej_foto_temaid AS fotoesej_foto_temaid_53, f2_.fotoesej_tema_autorid AS fotoesej_tema_autorid_54 FROM fotoesej_foto f0_ LEFT JOIN autor a1_ ON f0_.fotoesej_foto_autorid = a1_.autor_id LEFT JOIN fotoesej_tema f2_ ON f0_.fotoesej_foto_temaid = f2_.fotoesej_tema_id WHERE f0_.fotoesej_foto_id = ?"
  "params" => [
    1 => 1122
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#695
      +name: "INTEGER"
    }
  ]
]

[
  "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, f0_.fotoesej_foto_autorid AS fotoesej_foto_autorid_3, f0_.fotoesej_foto_temaid AS fotoesej_foto_temaid_4 FROM fotoesej_foto f0_ WHERE f0_.fotoesej_foto_temaid = ? AND f0_.fotoesej_foto_id <> ? AND ((f0_.fotoesej_foto_hlasu > ? OR (f0_.fotoesej_foto_hlasu = ? AND f0_.fotoesej_foto_id > ?))) ORDER BY f0_.fotoesej_foto_hlasu ASC, f0_.fotoesej_foto_id ASC LIMIT 1"
  "params" => [
    1 => 26
    2 => 1122
    3 => 32
    4 => 32
    5 => 1122
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#695
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#695}
    3 => Doctrine\DBAL\ParameterType {#695}
    4 => Doctrine\DBAL\ParameterType {#695}
    5 => Doctrine\DBAL\ParameterType {#695}
  ]
]

[
  "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, f0_.fotoesej_foto_autorid AS fotoesej_foto_autorid_3, f0_.fotoesej_foto_temaid AS fotoesej_foto_temaid_4 FROM fotoesej_foto f0_ WHERE f0_.fotoesej_foto_temaid = ? AND f0_.fotoesej_foto_id <> ? AND ((f0_.fotoesej_foto_hlasu < ? OR (f0_.fotoesej_foto_hlasu = ? AND f0_.fotoesej_foto_id < ?))) ORDER BY f0_.fotoesej_foto_hlasu DESC, f0_.fotoesej_foto_id DESC LIMIT 1"
  "params" => [
    1 => 26
    2 => 1122
    3 => 32
    4 => 32
    5 => 1122
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#695
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#695}
    3 => Doctrine\DBAL\ParameterType {#695}
    4 => Doctrine\DBAL\ParameterType {#695}
    5 => Doctrine\DBAL\ParameterType {#695}
  ]
]

[
  "sql" => "SELECT f0_.fotoesej_hlasovani_id AS fotoesej_hlasovani_id_0, a1_.autor_id AS autor_id_1, a1_.autor_login AS autor_login_2, a1_.autor_pass AS autor_pass_3, a1_.autor_pass2 AS autor_pass2_4, a1_.autor_mail AS autor_mail_5, a1_.autor_jmeno AS autor_jmeno_6, a1_.autor_prijmeni AS autor_prijmeni_7, a1_.autor_blok AS autor_blok_8, a1_.autor_ikonka AS autor_ikonka_9, a1_.autor_body AS autor_body_10, a1_.autor_fotek AS autor_fotek_11, a1_.autor_komentaru AS autor_komentaru_12, a1_.autor_hodnoceni AS autor_hodnoceni_13, a1_.autor_predplatne AS autor_predplatne_14, a1_.autor_technika AS autor_technika_15, a1_.autor_poznamka AS autor_poznamka_16, a1_.autor_prodejni_info AS autor_prodejni_info_17, a1_.autor_ip AS autor_ip_18, a1_.autor_prihlaseni AS autor_prihlaseni_19, a1_.autor_last_upload AS autor_last_upload_20, a1_.autor_ftp AS autor_ftp_21, a1_.autor_mailpp AS autor_mailpp_22, a1_.autor_posta AS autor_posta_23, a1_.autor_postanew AS autor_postanew_24, a1_.lat AS lat_25, a1_.lon AS lon_26, a1_.heslo_token AS heslo_token_27, a1_.heslo_token_platnost AS heslo_token_platnost_28, a1_.novinky_zasilat AS novinky_zasilat_29, a1_.novinky_token AS novinky_token_30, a1_.autor_flag_bazar AS autor_flag_bazar_31, a1_.autor_flag_bmfoto AS autor_flag_bmfoto_32, a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_33, a1_.autor_flag_posta_back AS autor_flag_posta_back_34, a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_35, a1_.autor_flag_profil AS autor_flag_profil_36, a1_.autor_flag_clanky AS autor_flag_clanky_37, a1_.autor_flag_beztlach AS autor_flag_beztlach_38, a1_.autor_flag_foto_kom AS autor_flag_foto_kom_39, a1_.autor_flag_bmstart AS autor_flag_bmstart_40, a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_41, a1_.autor_role AS autor_role_42, f0_.fotoesej_hlasovani_autorid AS fotoesej_hlasovani_autorid_43, f0_.fotoesej_hlasovani_fotkaid AS fotoesej_hlasovani_fotkaid_44, f0_.fotoesej_hlasovani_temaid AS fotoesej_hlasovani_temaid_45 FROM fotoesej_hlasovani f0_ LEFT JOIN autor a1_ ON f0_.fotoesej_hlasovani_autorid = a1_.autor_id WHERE f0_.fotoesej_hlasovani_fotkaid = ? ORDER BY a1_.autor_prijmeni ASC, a1_.autor_jmeno ASC"
  "params" => [
    1 => 1122
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#695
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => """
    SELECT COUNT(DISTINCT fotoesej_foto_hlasu) + 1 FROM fotoesej_foto\n
                     WHERE fotoesej_foto_temaid = ? AND fotoesej_foto_hlasu > ?
    """
  "params" => [
    1 => 26
    2 => 32
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#582
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#582}
  ]
]

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