Symfony Profiler

[
  "route" => "verejny_ucitele"
  "route_parameters" => [
    "_route" => "verejny_ucitele"
    "_controller" => "App\Controller\RozvrhVerejnyController::ucitele"
    "katedra" => "kf"
  ]
  "request_uri" => "https://rozvrh-dev.fjfi.cvut.cz/rozvrh/ucitele/kf"
  "method" => "GET"
]

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "rbk"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "rbk"
    "serverVersion" => "11.7.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.semestr_cz AS semestr_cz_2, t0.semestr_en AS semestr_en_3, t0.mezidobi AS mezidobi_4, t0.neuplny_rozvrh AS neuplny_rozvrh_5 FROM legacy_rozvrh_nastaveni t0 LIMIT 1"
]

[
  "sql" => """
    SELECT DISTINCT s.sekce\n
                 FROM legacy_rozvrh_skupina s\n
                 LEFT JOIN katedra k ON k.zkratkaCZ = s.sekce COLLATE utf8mb4_unicode_ci\n
                 WHERE s.typ = ? AND s.aktivni = 1\n
                 ORDER BY k.kodFJFI ASC, s.sekce ASC
    """
  "params" => [
    1 => "ucitel"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1023
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.typ AS typ_2, t0.kod AS kod_3, t0.nazev_cz AS nazev_cz_4, t0.nazev_en AS nazev_en_5, t0.sekce AS sekce_6, t0.png_soubor AS png_soubor_7, t0.pdf_soubor AS pdf_soubor_8, t0.poradi AS poradi_9, t0.aktivni AS aktivni_10, t0.katedra_id AS katedra_id_11, t0.mistnost_id AS mistnost_id_12 FROM legacy_rozvrh_skupina t0 WHERE t0.typ = ? AND t0.sekce = ? AND t0.aktivni = ? ORDER BY t0.poradi ASC, t0.nazev_cz ASC"
  "params" => [
    1 => "ucitel"
    2 => "KF"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1023
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1023}
    3 => Doctrine\DBAL\ParameterType {#1113
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.poradi AS poradi_1, v0_.nazev_cz AS nazev_cz_2, v0_.nazev_en AS nazev_en_3, v0_.dynamicky_typ AS dynamicky_typ_4, v1_.id AS id_5, v1_.poradi AS poradi_6, v1_.nazev_cz AS nazev_cz_7, v1_.nazev_en AS nazev_en_8, v1_.dynamicky_typ AS dynamicky_typ_9, l2_.id AS id_10, l2_.slug AS slug_11, l2_.obsah_cz AS obsah_cz_12, l2_.obsah_en AS obsah_en_13, l2_.nadpis_cz AS nadpis_cz_14, l2_.nadpis_en AS nadpis_en_15, l2_.typ AS typ_16, l2_.viditelna AS viditelna_17, l3_.id AS id_18, l3_.slug AS slug_19, l3_.obsah_cz AS obsah_cz_20, l3_.obsah_en AS obsah_en_21, l3_.nadpis_cz AS nadpis_cz_22, l3_.nadpis_en AS nadpis_en_23, l3_.typ AS typ_24, l3_.viditelna AS viditelna_25, v0_.parent_id AS parent_id_26, v0_.stranka_id AS stranka_id_27, v1_.parent_id AS parent_id_28, v1_.stranka_id AS stranka_id_29 FROM verejny_menu_polozka v0_ LEFT JOIN verejny_menu_polozka v1_ ON v0_.id = v1_.parent_id LEFT JOIN legacy_verejny_text l2_ ON v1_.stranka_id = l2_.id LEFT JOIN legacy_verejny_text l3_ ON v0_.stranka_id = l3_.id WHERE v0_.parent_id IS NULL ORDER BY v0_.poradi ASC, v1_.poradi ASC"
]

[
  "sql" => """
    SELECT DISTINCT s.sekce\n
                 FROM legacy_rozvrh_skupina s\n
                 LEFT JOIN katedra k ON k.zkratkaCZ = s.sekce COLLATE utf8mb4_unicode_ci\n
                 WHERE s.typ = ? AND s.aktivni = 1\n
                 ORDER BY k.kodFJFI ASC, s.sekce ASC
    """
  "params" => [
    1 => "ucitel"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1023
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT DISTINCT s.sekce\n
                 FROM legacy_rozvrh_skupina s\n
                 LEFT JOIN katedra k ON k.zkratkaCZ = s.sekce COLLATE utf8mb4_unicode_ci\n
                 WHERE s.typ = ? AND s.aktivni = 1\n
                 ORDER BY k.kodFJFI ASC, s.sekce ASC
    """
  "params" => [
    1 => "ucitel"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1023
      +name: "STRING"
    }
  ]
]