Symfony Profiler

[
  "route" => "user_profile_forums"
  "route_parameters" => [
    "_route" => "user_profile_forums"
    "_controller" => "App\Controller\User\ProfileController::forums"
    "id" => "1055"
  ]
  "request_uri" => "https://beta22.photopost.cz/autor/1055/fora"
  "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 t0.autor_id AS autor_id_1, t0.autor_login AS autor_login_2, t0.autor_pass AS autor_pass_3, t0.autor_pass2 AS autor_pass2_4, t0.autor_mail AS autor_mail_5, t0.autor_jmeno AS autor_jmeno_6, t0.autor_prijmeni AS autor_prijmeni_7, t0.autor_blok AS autor_blok_8, t0.autor_ikonka AS autor_ikonka_9, t0.autor_body AS autor_body_10, t0.autor_fotek AS autor_fotek_11, t0.autor_komentaru AS autor_komentaru_12, t0.autor_hodnoceni AS autor_hodnoceni_13, t0.autor_predplatne AS autor_predplatne_14, t0.autor_technika AS autor_technika_15, t0.autor_poznamka AS autor_poznamka_16, t0.autor_prodejni_info AS autor_prodejni_info_17, t0.autor_ip AS autor_ip_18, t0.autor_prihlaseni AS autor_prihlaseni_19, t0.autor_last_upload AS autor_last_upload_20, t0.autor_ftp AS autor_ftp_21, t0.autor_mailpp AS autor_mailpp_22, t0.autor_posta AS autor_posta_23, t0.autor_postanew AS autor_postanew_24, t0.lat AS lat_25, t0.lon AS lon_26, t0.heslo_token AS heslo_token_27, t0.heslo_token_platnost AS heslo_token_platnost_28, t0.novinky_zasilat AS novinky_zasilat_29, t0.novinky_token AS novinky_token_30, t0.autor_flag_bazar AS autor_flag_bazar_31, t0.autor_flag_bmfoto AS autor_flag_bmfoto_32, t0.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_33, t0.autor_flag_posta_back AS autor_flag_posta_back_34, t0.autor_flag_posta_pocet AS autor_flag_posta_pocet_35, t0.autor_flag_profil AS autor_flag_profil_36, t0.autor_flag_clanky AS autor_flag_clanky_37, t0.autor_flag_beztlach AS autor_flag_beztlach_38, t0.autor_flag_foto_kom AS autor_flag_foto_kom_39, t0.autor_flag_bmstart AS autor_flag_bmstart_40, t0.autor_flag_default_bodovani AS autor_flag_default_bodovani_41, t0.autor_role AS autor_role_42 FROM autor t0 WHERE t0.autor_id = ?"
  "params" => [
    1 => 1055
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +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 a0_.auditorium_id) AS sclr_0 FROM auditorium a0_ LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id WHERE a0_.auditorium_autor_id = ?"
  "params" => [
    1 => 1055
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT a0_.auditorium_id AS auditorium_id_0, a0_.auditorium_datum AS auditorium_datum_1 FROM auditorium a0_ LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id WHERE a0_.auditorium_autor_id = ? ORDER BY a0_.auditorium_datum DESC LIMIT 30"
  "params" => [
    1 => 1055
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT a0_.auditorium_id AS auditorium_id_0, a0_.auditorium_text AS auditorium_text_1, a0_.auditorium_datum AS auditorium_datum_2, a0_.auditorium_obrazek AS auditorium_obrazek_3, a1_.forum_id AS forum_id_4, a1_.forum_nazev AS forum_nazev_5, a1_.forum_popis AS forum_popis_6, a1_.forum_date AS forum_date_7, a1_.forum_status AS forum_status_8, a1_.forum_prispevku AS forum_prispevku_9, a1_.forum_posledni AS forum_posledni_10, a1_.forum_obrazek AS forum_obrazek_11, a1_.auditorium_forum_priv AS auditorium_forum_priv_12, a1_.proneprihlasene AS proneprihlasene_13, a0_.auditorium_autor_id AS auditorium_autor_id_14, a0_.auditorium_forum_id AS auditorium_forum_id_15, a1_.forum_autor_id AS forum_autor_id_16, a1_.forum_kat_id AS forum_kat_id_17 FROM auditorium a0_ LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id WHERE a0_.auditorium_autor_id = ? AND a0_.auditorium_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.auditorium_datum DESC"
  "params" => [
    1 => 1055
    2 => 317709
    3 => 313023
    4 => 313015
    5 => 300268
    6 => 266387
    7 => 266381
    8 => 266377
    9 => 250324
    10 => 250321
    11 => 250310
    12 => 250302
    13 => 247276
    14 => 247275
    15 => 244527
    16 => 244515
    17 => 244498
    18 => 244188
    19 => 244185
    20 => 244182
    21 => 244179
    22 => 243634
    23 => 243041
    24 => 243039
    25 => 243037
    26 => 243034
    27 => 243027
    28 => 243025
    29 => 243009
    30 => 241801
    31 => 241204
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#749}
    3 => Doctrine\DBAL\ParameterType {#749}
    4 => Doctrine\DBAL\ParameterType {#749}
    5 => Doctrine\DBAL\ParameterType {#749}
    6 => Doctrine\DBAL\ParameterType {#749}
    7 => Doctrine\DBAL\ParameterType {#749}
    8 => Doctrine\DBAL\ParameterType {#749}
    9 => Doctrine\DBAL\ParameterType {#749}
    10 => Doctrine\DBAL\ParameterType {#749}
    11 => Doctrine\DBAL\ParameterType {#749}
    12 => Doctrine\DBAL\ParameterType {#749}
    13 => Doctrine\DBAL\ParameterType {#749}
    14 => Doctrine\DBAL\ParameterType {#749}
    15 => Doctrine\DBAL\ParameterType {#749}
    16 => Doctrine\DBAL\ParameterType {#749}
    17 => Doctrine\DBAL\ParameterType {#749}
    18 => Doctrine\DBAL\ParameterType {#749}
    19 => Doctrine\DBAL\ParameterType {#749}
    20 => Doctrine\DBAL\ParameterType {#749}
    21 => Doctrine\DBAL\ParameterType {#749}
    22 => Doctrine\DBAL\ParameterType {#749}
    23 => Doctrine\DBAL\ParameterType {#749}
    24 => Doctrine\DBAL\ParameterType {#749}
    25 => Doctrine\DBAL\ParameterType {#749}
    26 => Doctrine\DBAL\ParameterType {#749}
    27 => Doctrine\DBAL\ParameterType {#749}
    28 => Doctrine\DBAL\ParameterType {#749}
    29 => Doctrine\DBAL\ParameterType {#749}
    30 => Doctrine\DBAL\ParameterType {#749}
    31 => Doctrine\DBAL\ParameterType {#749}
  ]
]

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

[
  "sql" => "SELECT t0.auditorium_kat_id AS auditorium_kat_id_1, t0.auditorium_kat_name AS auditorium_kat_name_2, t0.auditorium_kat_desc AS auditorium_kat_desc_3 FROM auditorium_kat t0 WHERE t0.auditorium_kat_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.auditorium_kat_id AS auditorium_kat_id_1, t0.auditorium_kat_name AS auditorium_kat_name_2, t0.auditorium_kat_desc AS auditorium_kat_desc_3 FROM auditorium_kat t0 WHERE t0.auditorium_kat_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.auditorium_kat_id AS auditorium_kat_id_1, t0.auditorium_kat_name AS auditorium_kat_name_2, t0.auditorium_kat_desc AS auditorium_kat_desc_3 FROM auditorium_kat t0 WHERE t0.auditorium_kat_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.auditorium_kat_id AS auditorium_kat_id_1, t0.auditorium_kat_name AS auditorium_kat_name_2, t0.auditorium_kat_desc AS auditorium_kat_desc_3 FROM auditorium_kat t0 WHERE t0.auditorium_kat_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.auditorium_kat_id AS auditorium_kat_id_1, t0.auditorium_kat_name AS auditorium_kat_name_2, t0.auditorium_kat_desc AS auditorium_kat_desc_3 FROM auditorium_kat t0 WHERE t0.auditorium_kat_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.auditorium_kat_id AS auditorium_kat_id_1, t0.auditorium_kat_name AS auditorium_kat_name_2, t0.auditorium_kat_desc AS auditorium_kat_desc_3 FROM auditorium_kat t0 WHERE t0.auditorium_kat_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.auditorium_kat_id AS auditorium_kat_id_1, t0.auditorium_kat_name AS auditorium_kat_name_2, t0.auditorium_kat_desc AS auditorium_kat_desc_3 FROM auditorium_kat t0 WHERE t0.auditorium_kat_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#749
      +name: "INTEGER"
    }
  ]
]

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