Symfony Profiler

[
  "route" => "termine"
  "route_parameters" => [
    "_route" => "termine"
    "page" => "4"
    "_controller" => "JF\JuridicusBundle\Controller\PruefungController::indexAction"
  ]
  "request_uri" => "https://unipoll.de/termine/4/pruefer_protokolle_pruefung_jura_examen"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "JF\JuridicusBundle\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "JF\JuridicusBundle\Security\LoginFormAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "juri"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "juri"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.datum) AS sclr_0 FROM pruefung p0_ INNER JOIN pruefer_pruefung p1_ ON p0_.id = p1_.pruefung_id"
]

[
  "sql" => "SELECT p0_.datum AS datum_0 FROM pruefung p0_ INNER JOIN pruefer_pruefung p1_ ON p0_.id = p1_.pruefung_id GROUP BY p0_.datum ORDER BY p0_.datum DESC LIMIT 20 OFFSET 60"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.datum AS datum_1, p0_.auto_updateable AS auto_updateable_2, p0_.bezeichnung AS bezeichnung_3, p0_.thema_kurzvortrag AS thema_kurzvortrag_4, p0_.typ AS typ_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p1_.id AS id_8, p1_.bezeichnung AS bezeichnung_9, p1_.examen AS examen_10, p1_.wahlfach AS wahlfach_11, p1_.bestand AS bestand_12, p1_.anzahl_pruefer AS anzahl_pruefer_13, p1_.anzahl_kandidaten AS anzahl_kandidaten_14, p1_.kennziffer_parts AS kennziffer_parts_15, p1_.noten_options AS noten_options_16, p1_.wahlfach_noten_options AS wahlfach_noten_options_17, p1_.termine AS termine_18, p1_.import_url AS import_url_19, p2_.id AS id_20, p2_.vorsitz AS vorsitz_21, p2_.sortierung AS sortierung_22, p2_.fach AS fach_23, p3_.id AS id_24, p3_.vorname AS vorname_25, p3_.nachname AS nachname_26, p3_.email AS email_27, p3_.anschrift AS anschrift_28, p3_.strasse AS strasse_29, p3_.hausnummer AS hausnummer_30, p3_.plz AS plz_31, p3_.ort AS ort_32, p3_.adel AS adel_33, p3_.works_at AS works_at_34, p3_.parsed_from AS parsed_from_35, p3_.quelle AS quelle_36, p3_.ordnr AS ordnr_37, p3_.rechtsgebiete AS rechtsgebiete_38, p3_.protokoll_datum AS protokoll_datum_39, p3_.appeared_first_at AS appeared_first_at_40, p3_.created_at AS created_at_41, p3_.pdf_need_update AS pdf_need_update_42, p3_.pdf_need_update_examen AS pdf_need_update_examen_43, p3_.slug AS slug_44, d4_.id AS id_45, d4_.name AS name_46, d4_.slug AS slug_47, t5_.id AS id_48, t5_.name AS name_49, t5_.slug AS slug_50, d6_.id AS id_51, d6_.name AS name_52, d6_.slug AS slug_53, t7_.id AS id_54, t7_.name AS name_55, t7_.slug AS slug_56, p0_.creator_id AS creator_id_57, p0_.pruefungsamt_id AS pruefungsamt_id_58, p2_.pruefer_id AS pruefer_id_59, p2_.pruefung_id AS pruefung_id_60, p3_.titel_id AS titel_id_61, p3_.dienststellung_id AS dienststellung_id_62, p3_.creator_id AS creator_id_63, p3_.alias_id AS alias_id_64, d4_.alias_id AS alias_id_65, t5_.alias_id AS alias_id_66, d6_.alias_id AS alias_id_67, t7_.alias_id AS alias_id_68 FROM pruefung p0_ INNER JOIN pruefungsamt p1_ ON p0_.pruefungsamt_id = p1_.id INNER JOIN pruefer_pruefung p2_ ON p0_.id = p2_.pruefung_id INNER JOIN pruefer p3_ ON p2_.pruefer_id = p3_.id LEFT JOIN dienststellung d4_ ON p3_.dienststellung_id = d4_.id LEFT JOIN titel t5_ ON p3_.titel_id = t5_.id LEFT JOIN dienststellung d6_ ON d4_.alias_id = d6_.id LEFT JOIN titel t7_ ON t5_.alias_id = t7_.id WHERE p0_.datum IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.datum DESC, p0_.id ASC, p2_.sortierung ASC"
  "params" => [
    1 => "2025-11-06"
    2 => "2025-11-05"
    3 => "2025-11-04"
    4 => "2025-10-31"
    5 => "2025-10-28"
    6 => "2025-10-24"
    7 => "2025-10-22"
    8 => "2025-10-16"
    9 => "2025-10-14"
    10 => "2025-10-10"
    11 => "2025-10-08"
    12 => "2025-10-02"
    13 => "2025-10-01"
    14 => "2025-09-30"
    15 => "2025-09-29"
    16 => "2025-09-26"
    17 => "2025-09-25"
    18 => "2025-09-24"
    19 => "2025-09-23"
    20 => "2025-09-22"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.vorname AS vorname_2, t0.nachname AS nachname_3, t0.email AS email_4, t0.anschrift AS anschrift_5, t0.strasse AS strasse_6, t0.hausnummer AS hausnummer_7, t0.plz AS plz_8, t0.ort AS ort_9, t0.adel AS adel_10, t0.works_at AS works_at_11, t0.parsed_from AS parsed_from_12, t0.quelle AS quelle_13, t0.ordnr AS ordnr_14, t0.rechtsgebiete AS rechtsgebiete_15, t0.protokoll_datum AS protokoll_datum_16, t0.appeared_first_at AS appeared_first_at_17, t0.created_at AS created_at_18, t0.pdf_need_update AS pdf_need_update_19, t0.pdf_need_update_examen AS pdf_need_update_examen_20, t0.slug AS slug_21, t0.titel_id AS titel_id_22, t23.id AS id_24, t23.name AS name_25, t23.slug AS slug_26, t23.alias_id AS alias_id_27, t0.dienststellung_id AS dienststellung_id_28, t29.id AS id_30, t29.name AS name_31, t29.slug AS slug_32, t29.alias_id AS alias_id_33, t0.creator_id AS creator_id_34, t0.alias_id AS alias_id_35, t36.id AS id_37, t36.vorname AS vorname_38, t36.nachname AS nachname_39, t36.email AS email_40, t36.anschrift AS anschrift_41, t36.strasse AS strasse_42, t36.hausnummer AS hausnummer_43, t36.plz AS plz_44, t36.ort AS ort_45, t36.adel AS adel_46, t36.works_at AS works_at_47, t36.parsed_from AS parsed_from_48, t36.quelle AS quelle_49, t36.ordnr AS ordnr_50, t36.rechtsgebiete AS rechtsgebiete_51, t36.protokoll_datum AS protokoll_datum_52, t36.appeared_first_at AS appeared_first_at_53, t36.created_at AS created_at_54, t36.pdf_need_update AS pdf_need_update_55, t36.pdf_need_update_examen AS pdf_need_update_examen_56, t36.slug AS slug_57, t36.titel_id AS titel_id_58, t36.dienststellung_id AS dienststellung_id_59, t36.creator_id AS creator_id_60, t36.alias_id AS alias_id_61 FROM pruefer t0 LEFT JOIN titel t23 ON t0.titel_id = t23.id LEFT JOIN dienststellung t29 ON t0.dienststellung_id = t29.id LEFT JOIN pruefer t36 ON t0.alias_id = t36.id WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 5678
    2 => 5209
    3 => 7593
    4 => 3509
    5 => 6074
    6 => 7323
    7 => 10624
    8 => 11561
    9 => 102
    10 => 8242
    11 => 11044
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.kuerzel AS kuerzel_3, t0.slug AS slug_4 FROM bundesland t0 INNER JOIN pruefungsamt_bundesland ON t0.id = pruefungsamt_bundesland.bundesland_id WHERE pruefungsamt_bundesland.pruefungsamt_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.kuerzel AS kuerzel_3, t0.slug AS slug_4 FROM bundesland t0 INNER JOIN pruefungsamt_bundesland ON t0.id = pruefungsamt_bundesland.bundesland_id WHERE pruefungsamt_bundesland.pruefungsamt_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.kuerzel AS kuerzel_3, t0.slug AS slug_4 FROM bundesland t0 INNER JOIN pruefungsamt_bundesland ON t0.id = pruefungsamt_bundesland.bundesland_id WHERE pruefungsamt_bundesland.pruefungsamt_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.kuerzel AS kuerzel_3, t0.slug AS slug_4 FROM bundesland t0 INNER JOIN pruefungsamt_bundesland ON t0.id = pruefungsamt_bundesland.bundesland_id WHERE pruefungsamt_bundesland.pruefungsamt_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.kuerzel AS kuerzel_3, t0.slug AS slug_4 FROM bundesland t0 INNER JOIN pruefungsamt_bundesland ON t0.id = pruefungsamt_bundesland.bundesland_id WHERE pruefungsamt_bundesland.pruefungsamt_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.kuerzel AS kuerzel_3, t0.slug AS slug_4 FROM bundesland t0 INNER JOIN pruefungsamt_bundesland ON t0.id = pruefungsamt_bundesland.bundesland_id WHERE pruefungsamt_bundesland.pruefungsamt_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.kuerzel AS kuerzel_3, t0.slug AS slug_4 FROM bundesland t0 INNER JOIN pruefungsamt_bundesland ON t0.id = pruefungsamt_bundesland.bundesland_id WHERE pruefungsamt_bundesland.pruefungsamt_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => 1
  ]
]