Default theme. It switches between Light and Dark automatically to match the operating system theme.
Provides greatest readability, but requires a well-lit environment.
Reduces eye fatigue. Ideal for low light environments.
Page Width
Fixed page width. Improves readability.
Dynamic page width. As wide as the browser window.
Log Messages
Level (7)
Channel (3)
Time
Message
deprecation
User Deprecated: Since symfony/monolog-bridge 6.4: The "Symfony\Bridge\Monolog\Logger" class is deprecated, use HttpKernel's DebugLoggerConfigurator instead.
User Deprecated: The "Sensio\Bundle\FrameworkExtraBundle\Configuration\Route" annotation is deprecated since version 5.2. Use "Symfony\Component\Routing\Annotation\Route" instead.
User Deprecated: Since symfony/framework-bundle 5.4: Method "Symfony\Bundle\FrameworkBundle\Controller\AbstractController::getDoctrine()" is deprecated, inject an instance of ManagerRegistry in your controller instead.
"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"
doctrine
[
"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"
]
debug
Executing query:
"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"
doctrine
[
"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"
]
debug
Executing statement:
"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 >= ?"
(parameters:
[1 => 12 => "2025-03-24"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"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 => 12 => "2025-03-24"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"""
\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
"""
(parameters:
[1 => 12 => "2025-03-24"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"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 => 12 => "2025-03-24"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"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 >= ?"
(parameters:
[1 => 22 => "2025-03-24"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"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 => 22 => "2025-03-24"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"""
\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
"""
(parameters:
[1 => 22 => "2025-03-24"
]
, types:
[1 => 12 => 2]
)
doctrine
[
"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 => 22 => "2025-03-24"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"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"
(parameters:
[1 => "1"
]
, types:
[1 => 2]
)
doctrine
[
"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]
]
debug
Executing statement:
"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"
[
"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 => 22 => 23 => 24 => 25 => 2]
]
debug
Executing statement:
"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"
(parameters:
[1 => "2"
]
, types:
[1 => 2]
)
doctrine
[
"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]
]
debug
Executing statement:
"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"
[
"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-18"
2 => "2026-03-10"
3 => "2026-02-18"
4 => "2026-01-29"
5 => "2"
]
"types" => [1 => 22 => 23 => 24 => 25 => 2]
]
debug
Executing statement:
"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 (?)"
(parameters:
[1 => 453]
, types:
[1 => 1]
)
doctrine
[
"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]
"types" => [1 => 1]
]
debug
Executing query:
"SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.kuerzel AS kuerzel_2, b0_.slug AS slug_3 FROM bundesland b0_"
doctrine
[
"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_"
]
debug
Executing statement:
"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"
(parameters:
[1 => 23]
, types:
[1 => 1]
)
doctrine
[
"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]
]
debug
Executing statement:
"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"
(parameters:
[1 => 3]
, types:
[1 => 1]
)
doctrine
[
"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]
]
debug
Executing statement:
"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"
(parameters:
[1 => 22]
, types:
[1 => 1]
)
doctrine
[
"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]
]
debug
Executing statement:
"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"
(parameters:
[1 => 18]
, types:
[1 => 1]
)
doctrine
[
"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]
]
deprecation
User Deprecated: Method "Swift_Transport_EsmtpHandler::getMailParams()" might add "array" as a native return type declaration in the future. Do the same in implementation "Swift_Transport_Esmtp_AuthHandler" now to avoid errors or add an explicit @return annotation to suppress this message.
User Deprecated: Method "Swift_Transport_EsmtpHandler::getRcptParams()" might add "array" as a native return type declaration in the future. Do the same in implementation "Swift_Transport_Esmtp_AuthHandler" now to avoid errors or add an explicit @return annotation to suppress this message.
User Deprecated: Method "Swift_Transport_Esmtp_Authenticator::authenticate()" might add "bool" as a native return type declaration in the future. Do the same in implementation "Swift_Transport_Esmtp_Auth_CramMd5Authenticator" now to avoid errors or add an explicit @return annotation to suppress this message.
User Deprecated: Method "Swift_Transport_Esmtp_Authenticator::authenticate()" might add "bool" as a native return type declaration in the future. Do the same in implementation "Swift_Transport_Esmtp_Auth_LoginAuthenticator" now to avoid errors or add an explicit @return annotation to suppress this message.
User Deprecated: Method "Swift_Transport_Esmtp_Authenticator::authenticate()" might add "bool" as a native return type declaration in the future. Do the same in implementation "Swift_Transport_Esmtp_Auth_PlainAuthenticator" now to avoid errors or add an explicit @return annotation to suppress this message.
User Deprecated: Method "Swift_Transport_Esmtp_Authenticator::authenticate()" might add "bool" as a native return type declaration in the future. Do the same in implementation "Swift_Transport_Esmtp_Auth_NTLMAuthenticator" now to avoid errors or add an explicit @return annotation to suppress this message.
User Deprecated: Method "Swift_Transport::ping()" might add "bool" as a native return type declaration in the future. Do the same in implementation "Swift_Transport_AbstractSmtpTransport" now to avoid errors or add an explicit @return annotation to suppress this message.
User Deprecated: Method "Swift_OutputByteStream::setReadPointer()" might add "bool" as a native return type declaration in the future. Do the same in implementation "Swift_Transport_StreamBuffer" now to avoid errors or add an explicit @return annotation to suppress this message.