Symfony Profiler

[
  "route" => "homepage"
  "route_parameters" => [
    "_route" => "homepage"
    "_controller" => "JF\JuridicusBundle\Controller\PruefungController::homeAction"
  ]
  "request_uri" => "https://unipoll.de/"
  "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(p0_.id) AS sclr_0 FROM pruefer p0_ INNER JOIN pdf_protokollmappe_pruefer p1_ ON p0_.id = p1_.pruefer_id AND (p1_.anzahl_protokolle > 0) WHERE p0_.alias_id IS NULL"
]

[
  "sql" => "SELECT SUM(p0_.anzahl_protokolle) AS sclr_0 FROM pruefer p1_ INNER JOIN pdf_protokollmappe_pruefer p0_ ON p1_.id = p0_.pruefer_id WHERE p1_.alias_id IS NULL"
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM protokoll_infothek_pruefer p1_ INNER JOIN protokoll_gesetz p2_ ON p1_.id = p2_.protokoll_infothek_pruefer_id INNER JOIN protokoll_infothek_pruefung p3_ ON p1_.protokoll_infothek_pruefung_id = p3_.id INNER JOIN pruefung p0_ ON p3_.pruefung_id = p0_.id WHERE p3_.fertig = 1 AND p3_.examen = ? AND p0_.datum >= ?"
  "params" => [
    1 => 1
    2 => "2025-03-18"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => """
    \n
            SELECT\n
                gesetz.kuerzel,\n
                gesetz.link,\n
                pruefung_stats.paragraph,\n
                COUNT(DISTINCT pruefung_stats.pruefung_id) AS count\n
            FROM\n
            (\n
                SELECT\n
                    pruefung.id AS pruefung_id,\n
                    pg.gesetz_id,\n
                    pg.paragraph,\n
                    COUNT(pg.id) AS nennungen\n
                FROM\n
                    protokoll_infothek_pruefer AS pip\n
                    JOIN protokoll_gesetz AS pg ON pg.protokoll_infothek_pruefer_id = pip.id\n
                    JOIN protokoll_infothek_pruefung pipg ON pipg.id = pip.protokoll_infothek_pruefung_id\n
                    JOIN pruefung ON pruefung.id = pipg.pruefung_id\n
                WHERE\n
                    pipg.fertig = 1\n
                    AND pipg.examen = ?\n
                    AND pruefung.datum >= ?\n
                GROUP BY\n
                    pruefung_id, gesetz_id, paragraph\n
            ) AS pruefung_stats\n
            JOIN\n
                gesetz ON gesetz.id = gesetz_id\n
            GROUP BY\n
                kuerzel, link, paragraph\n
            ORDER BY\n
                count DESC\n
            LIMIT 10\n
            
    """
  "params" => [
    1 => 1
    2 => "2025-03-18"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM protokoll_infothek_pruefer p1_ INNER JOIN protokoll_gesetz p2_ ON p1_.id = p2_.protokoll_infothek_pruefer_id INNER JOIN protokoll_infothek_pruefung p3_ ON p1_.protokoll_infothek_pruefung_id = p3_.id INNER JOIN pruefung p0_ ON p3_.pruefung_id = p0_.id WHERE p3_.fertig = 1 AND p3_.examen = ? AND p0_.datum >= ?"
  "params" => [
    1 => 2
    2 => "2025-03-18"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => """
    \n
            SELECT\n
                gesetz.kuerzel,\n
                gesetz.link,\n
                pruefung_stats.paragraph,\n
                COUNT(DISTINCT pruefung_stats.pruefung_id) AS count\n
            FROM\n
            (\n
                SELECT\n
                    pruefung.id AS pruefung_id,\n
                    pg.gesetz_id,\n
                    pg.paragraph,\n
                    COUNT(pg.id) AS nennungen\n
                FROM\n
                    protokoll_infothek_pruefer AS pip\n
                    JOIN protokoll_gesetz AS pg ON pg.protokoll_infothek_pruefer_id = pip.id\n
                    JOIN protokoll_infothek_pruefung pipg ON pipg.id = pip.protokoll_infothek_pruefung_id\n
                    JOIN pruefung ON pruefung.id = pipg.pruefung_id\n
                WHERE\n
                    pipg.fertig = 1\n
                    AND pipg.examen = ?\n
                    AND pruefung.datum >= ?\n
                GROUP BY\n
                    pruefung_id, gesetz_id, paragraph\n
            ) AS pruefung_stats\n
            JOIN\n
                gesetz ON gesetz.id = gesetz_id\n
            GROUP BY\n
                kuerzel, link, paragraph\n
            ORDER BY\n
                count DESC\n
            LIMIT 10\n
            
    """
  "params" => [
    1 => 2
    2 => "2025-03-18"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT p0_.datum AS datum_0 FROM pruefung p0_ INNER JOIN pruefer_pruefung p1_ ON p0_.id = p1_.pruefung_id WHERE p0_.typ = ? GROUP BY p0_.datum ORDER BY p0_.datum DESC LIMIT 4"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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 (?, ?, ?, ?) AND p0_.typ = ? ORDER BY p0_.datum DESC, p0_.id ASC, p2_.sortierung ASC"
  "params" => [
    1 => "2026-03-25"
    2 => "2026-02-19"
    3 => "2026-02-09"
    4 => "2026-02-06"
    5 => "1"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT p0_.datum AS datum_0 FROM pruefung p0_ INNER JOIN pruefer_pruefung p1_ ON p0_.id = p1_.pruefung_id WHERE p0_.typ = ? GROUP BY p0_.datum ORDER BY p0_.datum DESC LIMIT 4"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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 (?, ?, ?, ?) AND p0_.typ = ? ORDER BY p0_.datum DESC, p0_.id ASC, p2_.sortierung ASC"
  "params" => [
    1 => "2026-02-18"
    2 => "2026-01-29"
    3 => "2026-01-28"
    4 => "2026-01-27"
    5 => "2"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 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 => 453
    2 => 7809
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.kuerzel AS kuerzel_2, b0_.slug AS slug_3 FROM bundesland b0_"
]

[
  "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 => 23
  ]
  "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 => 22
  ]
  "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
  ]
]

[
  "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 => 10
  ]
  "types" => [
    1 => 1
  ]
]