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 t0.id AS id_1, t0.name AS name_2, t0.kuerzel AS kuerzel_3, t0.slug AS slug_4 FROM bundesland t0 WHERE t0.slug = ? LIMIT 1"
(parameters:
[1 => "nordrhein-westfalen"
]
, types:
[1 => 2]
)
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 WHERE t0.slug = ? LIMIT 1"
"params" => [1 => "nordrhein-westfalen"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT p0_.id AS id_0, p0_.bezeichnung AS bezeichnung_1, p0_.examen AS examen_2, p0_.wahlfach AS wahlfach_3, p0_.bestand AS bestand_4, p0_.anzahl_pruefer AS anzahl_pruefer_5, p0_.anzahl_kandidaten AS anzahl_kandidaten_6, p0_.kennziffer_parts AS kennziffer_parts_7, p0_.noten_options AS noten_options_8, p0_.wahlfach_noten_options AS wahlfach_noten_options_9, p0_.termine AS termine_10, p0_.import_url AS import_url_11, b1_.id AS id_12, b1_.name AS name_13, b1_.kuerzel AS kuerzel_14, b1_.slug AS slug_15 FROM pruefungsamt p0_ INNER JOIN pruefungsamt_bundesland p2_ ON p0_.id = p2_.pruefungsamt_id INNER JOIN bundesland b1_ ON b1_.id = p2_.bundesland_id AND (b1_.slug = ?) WHERE p0_.examen = ? ORDER BY b1_.name ASC"
(parameters:
[1 => "nordrhein-westfalen"
2 => "1"
]
, types:
[1 => 22 => 2]
)
doctrine
[
"sql" => "SELECT p0_.id AS id_0, p0_.bezeichnung AS bezeichnung_1, p0_.examen AS examen_2, p0_.wahlfach AS wahlfach_3, p0_.bestand AS bestand_4, p0_.anzahl_pruefer AS anzahl_pruefer_5, p0_.anzahl_kandidaten AS anzahl_kandidaten_6, p0_.kennziffer_parts AS kennziffer_parts_7, p0_.noten_options AS noten_options_8, p0_.wahlfach_noten_options AS wahlfach_noten_options_9, p0_.termine AS termine_10, p0_.import_url AS import_url_11, b1_.id AS id_12, b1_.name AS name_13, b1_.kuerzel AS kuerzel_14, b1_.slug AS slug_15 FROM pruefungsamt p0_ INNER JOIN pruefungsamt_bundesland p2_ ON p0_.id = p2_.pruefungsamt_id INNER JOIN bundesland b1_ ON b1_.id = p2_.bundesland_id AND (b1_.slug = ?) WHERE p0_.examen = ? ORDER BY b1_.name ASC"
"params" => [1 => "nordrhein-westfalen"
2 => "1"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.typ AS typ_2, t0.datum AS datum_3, t0.betrag AS betrag_4 FROM gebuehr t0 INNER JOIN pruefungsamt_gebuehr ON t0.id = pruefungsamt_gebuehr.gebuehr_id WHERE pruefungsamt_gebuehr.pruefungsamt_id = ? ORDER BY t0.typ ASC, t0.datum DESC"
(parameters:
[1 => 17]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.typ AS typ_2, t0.datum AS datum_3, t0.betrag AS betrag_4 FROM gebuehr t0 INNER JOIN pruefungsamt_gebuehr ON t0.id = pruefungsamt_gebuehr.gebuehr_id WHERE pruefungsamt_gebuehr.pruefungsamt_id = ? ORDER BY t0.typ ASC, t0.datum DESC"
"params" => [1 => 17]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT p0_.id AS id_0, p0_.vorname AS vorname_1, p0_.nachname AS nachname_2, p0_.email AS email_3, p0_.anschrift AS anschrift_4, p0_.strasse AS strasse_5, p0_.hausnummer AS hausnummer_6, p0_.plz AS plz_7, p0_.ort AS ort_8, p0_.adel AS adel_9, p0_.works_at AS works_at_10, p0_.parsed_from AS parsed_from_11, p0_.quelle AS quelle_12, p0_.ordnr AS ordnr_13, p0_.rechtsgebiete AS rechtsgebiete_14, p0_.protokoll_datum AS protokoll_datum_15, p0_.appeared_first_at AS appeared_first_at_16, p0_.created_at AS created_at_17, p0_.pdf_need_update AS pdf_need_update_18, p0_.pdf_need_update_examen AS pdf_need_update_examen_19, p0_.slug AS slug_20, p0_.titel_id AS titel_id_21, p0_.dienststellung_id AS dienststellung_id_22, p0_.creator_id AS creator_id_23, p0_.alias_id AS alias_id_24 FROM pruefer p0_ INNER JOIN pruefer_pruefungsamt p2_ ON p0_.id = p2_.pruefer_id INNER JOIN pruefungsamt p1_ ON p1_.id = p2_.pruefungsamt_id AND (p1_.id = ?) LEFT JOIN pdf_protokollmappe_pruefer p3_ ON p0_.id = p3_.pruefer_id LEFT JOIN pruefer p4_ ON p0_.alias_id = p4_.id LEFT JOIN pdf_protokollmappe_pruefer p5_ ON p4_.id = p5_.pruefer_id WHERE p0_.slug = ? AND (p3_.anzahl_protokolle > 0 OR p5_.anzahl_protokolle > 0)"
[
"sql" => "SELECT p0_.id AS id_0, p0_.vorname AS vorname_1, p0_.nachname AS nachname_2, p0_.email AS email_3, p0_.anschrift AS anschrift_4, p0_.strasse AS strasse_5, p0_.hausnummer AS hausnummer_6, p0_.plz AS plz_7, p0_.ort AS ort_8, p0_.adel AS adel_9, p0_.works_at AS works_at_10, p0_.parsed_from AS parsed_from_11, p0_.quelle AS quelle_12, p0_.ordnr AS ordnr_13, p0_.rechtsgebiete AS rechtsgebiete_14, p0_.protokoll_datum AS protokoll_datum_15, p0_.appeared_first_at AS appeared_first_at_16, p0_.created_at AS created_at_17, p0_.pdf_need_update AS pdf_need_update_18, p0_.pdf_need_update_examen AS pdf_need_update_examen_19, p0_.slug AS slug_20, p0_.titel_id AS titel_id_21, p0_.dienststellung_id AS dienststellung_id_22, p0_.creator_id AS creator_id_23, p0_.alias_id AS alias_id_24 FROM pruefer p0_ INNER JOIN pruefer_pruefungsamt p2_ ON p0_.id = p2_.pruefer_id INNER JOIN pruefungsamt p1_ ON p1_.id = p2_.pruefungsamt_id AND (p1_.id = ?) LEFT JOIN pdf_protokollmappe_pruefer p3_ ON p0_.id = p3_.pruefer_id LEFT JOIN pruefer p4_ ON p0_.alias_id = p4_.id LEFT JOIN pdf_protokollmappe_pruefer p5_ ON p4_.id = p5_.pruefer_id WHERE p0_.slug = ? AND (p3_.anzahl_protokolle > 0 OR p5_.anzahl_protokolle > 0)"
"params" => [1 => 172 => "dr-verwaltungsdirektor-schlingloff"
]
"types" => [1 => 12 => 2]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.alias_id AS alias_id_4 FROM titel t0 WHERE t0.id IN (?)"
(parameters:
[1 => 3]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.alias_id AS alias_id_4 FROM titel t0 WHERE t0.id IN (?)"
"params" => [1 => 3]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.alias_id AS alias_id_4 FROM dienststellung t0 WHERE t0.id IN (?)"
(parameters:
[1 => 1270]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.alias_id AS alias_id_4 FROM dienststellung t0 WHERE t0.id IN (?)"
"params" => [1 => 1270]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.anzahl_seiten AS anzahl_seiten_2, t0.path AS path_3, t0.size AS size_4, t0.mimeType AS mimeType_5, t0.anzahl_protokolle AS anzahl_protokolle_6, t0.examen AS examen_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.pruefer_id AS pruefer_id_10 FROM pdf_protokollmappe_pruefer t0 WHERE t0.pruefer_id = ?"
(parameters:
[1 => 9637]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.anzahl_seiten AS anzahl_seiten_2, t0.path AS path_3, t0.size AS size_4, t0.mimeType AS mimeType_5, t0.anzahl_protokolle AS anzahl_protokolle_6, t0.examen AS examen_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.pruefer_id AS pruefer_id_10 FROM pdf_protokollmappe_pruefer t0 WHERE t0.pruefer_id = ?"
"params" => [1 => 9637]
"types" => [1 => 1]
]
There are no log messages.
Container Compilation Logs (0)
Log messages generated during the compilation of the service container.