Symfony Profiler

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

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;

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

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;

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 >= ?

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 = 1 AND p0_.datum >= '2025-03-18';

SELECT
  gesetz.kuerzel,
  gesetz.link,
  pruefung_stats.paragraph,
  COUNT(
    DISTINCT pruefung_stats.pruefung_id
  ) AS count
FROM
  (
    SELECT
      pruefung.id AS pruefung_id,
      pg.gesetz_id,
      pg.paragraph,
      COUNT(pg.id) AS nennungen
    FROM
      protokoll_infothek_pruefer AS pip
      JOIN protokoll_gesetz AS pg ON pg.protokoll_infothek_pruefer_id = pip.id
      JOIN protokoll_infothek_pruefung pipg ON pipg.id = pip.protokoll_infothek_pruefung_id
      JOIN pruefung ON pruefung.id = pipg.pruefung_id
    WHERE
      pipg.fertig = 1
      AND pipg.examen = ?
      AND pruefung.datum >= ?
    GROUP BY
      pruefung_id,
      gesetz_id,
      paragraph
  ) AS pruefung_stats
  JOIN gesetz ON gesetz.id = gesetz_id
GROUP BY
  kuerzel,
  link,
  paragraph
ORDER BY
  count DESC
LIMIT
  10

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

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 >= ?

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 = 2 AND p0_.datum >= '2025-03-18';

SELECT
  gesetz.kuerzel,
  gesetz.link,
  pruefung_stats.paragraph,
  COUNT(
    DISTINCT pruefung_stats.pruefung_id
  ) AS count
FROM
  (
    SELECT
      pruefung.id AS pruefung_id,
      pg.gesetz_id,
      pg.paragraph,
      COUNT(pg.id) AS nennungen
    FROM
      protokoll_infothek_pruefer AS pip
      JOIN protokoll_gesetz AS pg ON pg.protokoll_infothek_pruefer_id = pip.id
      JOIN protokoll_infothek_pruefung pipg ON pipg.id = pip.protokoll_infothek_pruefung_id
      JOIN pruefung ON pruefung.id = pipg.pruefung_id
    WHERE
      pipg.fertig = 1
      AND pipg.examen = ?
      AND pruefung.datum >= ?
    GROUP BY
      pruefung_id,
      gesetz_id,
      paragraph
  ) AS pruefung_stats
  JOIN gesetz ON gesetz.id = gesetz_id
GROUP BY
  kuerzel,
  link,
  paragraph
ORDER BY
  count DESC
LIMIT
  10

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

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

SELECT p0_.datum AS datum_0 FROM pruefung p0_ INNER JOIN pruefer_pruefung p1_ ON p0_.id = p1_.pruefung_id WHERE p0_.typ = '1' GROUP BY p0_.datum ORDER BY p0_.datum DESC LIMIT 4;

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

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 ('2026-03-25', '2026-02-19', '2026-02-09', '2026-02-06') AND p0_.typ = '1' ORDER BY p0_.datum DESC, p0_.id ASC, p2_.sortierung ASC;

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

SELECT p0_.datum AS datum_0 FROM pruefung p0_ INNER JOIN pruefer_pruefung p1_ ON p0_.id = p1_.pruefung_id WHERE p0_.typ = '2' GROUP BY p0_.datum ORDER BY p0_.datum DESC LIMIT 4;

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

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 ('2026-02-18', '2026-01-29', '2026-01-28', '2026-01-27') AND p0_.typ = '2' ORDER BY p0_.datum DESC, p0_.id ASC, p2_.sortierung ASC;

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 (?, ?)

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 (453, 7809);

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.kuerzel AS kuerzel_2,
  b0_.slug AS slug_3
FROM
  bundesland b0_

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.kuerzel AS kuerzel_2, b0_.slug AS slug_3 FROM bundesland b0_;

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

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 = 23 ORDER BY t0.name ASC;

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

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 = 3 ORDER BY t0.name ASC;

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

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 = 22 ORDER BY t0.name ASC;

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

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 = 18 ORDER BY t0.name ASC;

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

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 = 10 ORDER BY t0.name ASC;