Symfony Profiler

[
  "route" => "app_soutez_vysledky"
  "route_parameters" => [
    "_route" => "app_soutez_vysledky"
    "_controller" => "App\Controller\SoutezController::vysledky"
    "slug" => "ostrava2-2015"
  ]
  "request_uri" => "https://www.hasicskasoutez.cz/ostrava2-2015/vysledky/"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\MyOauth2Authenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\MyOauth2Authenticator"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventSubscriber\ApiKeySubscriber::onKernelController"
]

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

[
  "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" => "ContainerGQPjAYB\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "hasicskasoutez.cz"
    "port" => null
    "user" => "hasicskasoutezcz"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "hasicskasoutezcz"
    "serverVersion" => "10.5.23-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id_souteze AS id_souteze_1, t0.rocnik AS rocnik_2, t0.nazev AS nazev_3, t0.misto AS misto_4, t0.okres AS okres_5, t0.datum AS datum_6, t0.datum_do AS datum_do_7, t0.datum_interval_zacatek AS datum_interval_zacatek_8, t0.datum_interval_konec AS datum_interval_konec_9, t0.zacatek AS zacatek_10, t0.datump AS datump_11, t0.datumz AS datumz_12, t0.kontakt AS kontakt_13, t0.kategorie AS kategorie_14, t0.disciplina AS disciplina_15, t0.pozvanka_id_dokumentu AS pozvanka_id_dokumentu_16, t0.poradatel AS poradatel_17, t0.nocni AS nocni_18, t0.pocet_prispevku AS pocet_prispevku_19, t0.pocet_videi AS pocet_videi_20, t0.pocet_fotek AS pocet_fotek_21, t0.terce AS terce_22, t0.poradatel_sdh AS poradatel_sdh_23, t0.url_rezervace AS url_rezervace_24, t0.pocet_vysledku AS pocet_vysledku_25, t0.id_rezervace AS id_rezervace_26, t0.lat AS lat_27, t0.lng AS lng_28, t0.muzi_bezi_na_2b AS muzi_bezi_na_2b_29, t0.id_zivy_prenos AS id_zivy_prenos_30, t0.id_tipovacky AS id_tipovacky_31, t0.datum_aktualizace_vysledku AS datum_aktualizace_vysledku_32, t0.misto_f AS misto_f_33, t0.pocet_rezervaci AS pocet_rezervaci_34, t0.slug AS slug_35, t0.user_id AS user_id_36, t0.slug_old AS slug_old_37, t0.hity AS hity_38 FROM souteze t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "ostrava2-2015"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.id_soutez AS id_soutez_2, t0.id_ligy AS id_ligy_3, t0.user_id AS user_id_4, t0.razeni AS razeni_5 FROM souteze_do_ligy t0 WHERE t0.id_soutez = ?"
  "params" => [
    1 => 2107
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id_ligy AS id_ligy_1, t0.zkratka AS zkratka_2, t0.nazev AS nazev_3, t0.user_id AS user_id_4, t0.url_stranek_ligy AS url_stranek_ligy_5, t0.url_pravidla AS url_pravidla_6, t0.url_facebook AS url_facebook_7, t0.url_youtube AS url_youtube_8, t0.datump AS datump_9, t0.datumz AS datumz_10, t0.kategorie AS kategorie_11, t0.disciplina AS disciplina_12, t0.top AS top_13, t0.pravidla_hadice AS pravidla_hadice_14, t0.razeni AS razeni_15, t0.open AS open_16, t0.deti AS deti_17, t0.avatar_url AS avatar_url_18, t0.url_instagram AS url_instagram_19, t0.slug AS slug_20, t0.popis AS popis_21 FROM ligy t0 WHERE t0.id_ligy IN (?)"
  "params" => [
    1 => 39
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.onlajn_id AS onlajn_id_1, t0.id_souteze AS id_souteze_2, t0.popis AS popis_3, t0.nazev AS nazev_4, t0.kategorie AS kategorie_5, t0.youtube_embed_url AS youtube_embed_url_6, t0.user_id AS user_id_7, t0.ukonceno AS ukonceno_8, t0.datump AS datump_9 FROM onlajny t0 WHERE t0.id_souteze = ? LIMIT 1"
  "params" => [
    1 => 2107
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.datump AS datump_1, d0_.user_id AS user_id_2, d0_.id_souteze AS id_souteze_3, d0_.nazev_souboru AS nazev_souboru_4, d0_.velikost_souboru AS velikost_souboru_5, d0_.typ AS typ_6, d0_.id_tymu AS id_tymu_7, d0_.popis AS popis_8, d0_.id_ligy AS id_ligy_9 FROM dokumenty d0_ WHERE d0_.id_souteze = ? AND d0_.typ = ?"
  "params" => [
    1 => 2107
    2 => "V"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.id_souteze AS id_souteze_1, v0_.tym AS tym_2, v0_.cas_levy AS cas_levy_3, v0_.cas_pravy AS cas_pravy_4, v0_.cas AS cas_5, v0_.mc_kos AS mc_kos_6, v0_.mc_voda AS mc_voda_7, v0_.mc_rozd AS mc_rozd_8, v0_.mc_vystrik AS mc_vystrik_9, v0_.start_cislo AS start_cislo_10, v0_.um AS um_11, v0_.body AS body_12, v0_.kategorie AS kategorie_13, v0_.user_id AS user_id_14, v0_.duvod_nedokonceni AS duvod_nedokonceni_15, v0_.filtr2b AS filtr2b_16, v0_.id_tymu AS id_tymu_17, v0_.datump AS datump_18 FROM vysledky v0_ WHERE v0_.id_souteze = ? ORDER BY v0_.kategorie ASC, v0_.um ASC"
  "params" => [
    1 => 2107
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.kraj_id AS kraj_id_2, t0.okres_id AS okres_id_3, t0.alias AS alias_4, t0.okres AS okres_5 FROM okresy t0 WHERE t0.okres = ? LIMIT 1"
  "params" => [
    1 => "OV"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id_ligy AS id_ligy_1, t0.zkratka AS zkratka_2, t0.nazev AS nazev_3, t0.user_id AS user_id_4, t0.url_stranek_ligy AS url_stranek_ligy_5, t0.url_pravidla AS url_pravidla_6, t0.url_facebook AS url_facebook_7, t0.url_youtube AS url_youtube_8, t0.datump AS datump_9, t0.datumz AS datumz_10, t0.kategorie AS kategorie_11, t0.disciplina AS disciplina_12, t0.top AS top_13, t0.pravidla_hadice AS pravidla_hadice_14, t0.razeni AS razeni_15, t0.open AS open_16, t0.deti AS deti_17, t0.avatar_url AS avatar_url_18, t0.url_instagram AS url_instagram_19, t0.slug AS slug_20, t0.popis AS popis_21 FROM ligy t0 WHERE t0.id_ligy = ? LIMIT 1"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.id_souteze AS id_souteze_2, t0.id_tymu AS id_tymu_3, t0.image_url AS image_url_4, t0.image_url_sirka AS image_url_sirka_5, t0.image_url_vyska AS image_url_vyska_6, t0.datump AS datump_7, t0.user_id AS user_id_8, t0.image_url_old AS image_url_old_9, t0.image_url_default AS image_url_default_10, t0.image_url_default_sirka AS image_url_default_sirka_11, t0.image_url_default_vyska AS image_url_default_vyska_12, t0.image_url_default_851 AS image_url_default_851_13, t0.datumz AS datumz_14 FROM avatar t0 WHERE t0.id_souteze = ? LIMIT 1"
  "params" => [
    1 => 2107
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

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

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

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

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