Symfony Profiler

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

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 = 'bayern') WHERE p0_.examen = '2' ORDER BY b1_.name ASC;

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

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 = 4 ORDER BY t0.typ ASC, t0.datum DESC;

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,
  d1_.id AS id_21,
  d1_.name AS name_22,
  d1_.slug AS slug_23,
  d2_.id AS id_24,
  d2_.name AS name_25,
  d2_.slug AS slug_26,
  t3_.id AS id_27,
  t3_.name AS name_28,
  t3_.slug AS slug_29,
  t4_.id AS id_30,
  t4_.name AS name_31,
  t4_.slug AS slug_32,
  p5_.id AS id_33,
  p5_.anzahl_seiten AS anzahl_seiten_34,
  p5_.path AS path_35,
  p5_.size AS size_36,
  p5_.mimeType AS mimeType_37,
  p5_.anzahl_protokolle AS anzahl_protokolle_38,
  p5_.examen AS examen_39,
  p5_.created_at AS created_at_40,
  p5_.updated_at AS updated_at_41,
  p0_.titel_id AS titel_id_42,
  p0_.dienststellung_id AS dienststellung_id_43,
  p0_.creator_id AS creator_id_44,
  p0_.alias_id AS alias_id_45,
  d1_.alias_id AS alias_id_46,
  d2_.alias_id AS alias_id_47,
  t3_.alias_id AS alias_id_48,
  t4_.alias_id AS alias_id_49,
  p5_.pruefer_id AS pruefer_id_50
FROM
  pruefer p0_
  INNER JOIN pruefer_pruefungsamt p7_ ON p0_.id = p7_.pruefer_id
  INNER JOIN pruefungsamt p6_ ON p6_.id = p7_.pruefungsamt_id
  AND (p6_.id = ?)
  LEFT JOIN dienststellung d1_ ON p0_.dienststellung_id = d1_.id
  LEFT JOIN dienststellung d2_ ON d1_.alias_id = d2_.id
  LEFT JOIN titel t3_ ON p0_.titel_id = t3_.id
  LEFT JOIN titel t4_ ON t3_.alias_id = t4_.id
  INNER JOIN pdf_protokollmappe_pruefer p5_ ON p0_.id = p5_.pruefer_id
  AND (p5_.anzahl_protokolle > 0)
WHERE
  p0_.alias_id IS NULL
ORDER BY
  p0_.nachname ASC,
  p0_.vorname ASC,
  p0_.adel ASC

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, d1_.id AS id_21, d1_.name AS name_22, d1_.slug AS slug_23, d2_.id AS id_24, d2_.name AS name_25, d2_.slug AS slug_26, t3_.id AS id_27, t3_.name AS name_28, t3_.slug AS slug_29, t4_.id AS id_30, t4_.name AS name_31, t4_.slug AS slug_32, p5_.id AS id_33, p5_.anzahl_seiten AS anzahl_seiten_34, p5_.path AS path_35, p5_.size AS size_36, p5_.mimeType AS mimeType_37, p5_.anzahl_protokolle AS anzahl_protokolle_38, p5_.examen AS examen_39, p5_.created_at AS created_at_40, p5_.updated_at AS updated_at_41, p0_.titel_id AS titel_id_42, p0_.dienststellung_id AS dienststellung_id_43, p0_.creator_id AS creator_id_44, p0_.alias_id AS alias_id_45, d1_.alias_id AS alias_id_46, d2_.alias_id AS alias_id_47, t3_.alias_id AS alias_id_48, t4_.alias_id AS alias_id_49, p5_.pruefer_id AS pruefer_id_50 FROM pruefer p0_ INNER JOIN pruefer_pruefungsamt p7_ ON p0_.id = p7_.pruefer_id INNER JOIN pruefungsamt p6_ ON p6_.id = p7_.pruefungsamt_id AND (p6_.id = 4) LEFT JOIN dienststellung d1_ ON p0_.dienststellung_id = d1_.id LEFT JOIN dienststellung d2_ ON d1_.alias_id = d2_.id LEFT JOIN titel t3_ ON p0_.titel_id = t3_.id LEFT JOIN titel t4_ ON t3_.alias_id = t4_.id INNER JOIN pdf_protokollmappe_pruefer p5_ ON p0_.id = p5_.pruefer_id AND (p5_.anzahl_protokolle > 0) WHERE p0_.alias_id IS NULL ORDER BY p0_.nachname ASC, p0_.vorname ASC, p0_.adel ASC;

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 >= ?
  AND p0_.pruefungsamt_id = ?

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-19' AND p0_.pruefungsamt_id = 4;

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 pruefung.pruefungsamt_id = ?
      AND pruefung.datum >= ?
    GROUP BY
      pruefung_id,
      pg.gesetz_id,
      pg.paragraph
  ) AS pruefung_stats
  JOIN gesetz ON gesetz.id = gesetz_id
GROUP BY
  gesetz.kuerzel,
  gesetz.link,
  pruefung_stats.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 pruefung.pruefungsamt_id = 4
                AND pruefung.datum >= '2025-03-19'
            GROUP BY
                pruefung_id, pg.gesetz_id, pg.paragraph
        ) AS pruefung_stats
        JOIN
            gesetz ON gesetz.id = gesetz_id
        GROUP BY
            gesetz.kuerzel, gesetz.link, pruefung_stats.paragraph
        ORDER BY
            count DESC
        LIMIT 10
        ;