Symfony Profiler

SELECT
  COUNT(DISTINCT p0_.datum) AS sclr_0
FROM
  pruefung p0_
  INNER JOIN pruefer_pruefung p1_ ON p0_.id = p1_.pruefung_id

SELECT COUNT(DISTINCT p0_.datum) AS sclr_0 FROM pruefung p0_ INNER JOIN pruefer_pruefung p1_ ON p0_.id = p1_.pruefung_id;

SELECT
  p0_.datum AS datum_0
FROM
  pruefung p0_
  INNER JOIN pruefer_pruefung p1_ ON p0_.id = p1_.pruefung_id
GROUP BY
  p0_.datum
ORDER BY
  p0_.datum DESC
LIMIT
  20
OFFSET
  300

SELECT p0_.datum AS datum_0 FROM pruefung p0_ INNER JOIN pruefer_pruefung p1_ ON p0_.id = p1_.pruefung_id GROUP BY p0_.datum ORDER BY p0_.datum DESC LIMIT 20 OFFSET 300;

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
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 ('2024-09-06', '2024-09-05', '2024-09-04', '2024-09-03', '2024-09-02', '2024-08-29', '2024-08-28', '2024-08-26', '2024-08-23', '2024-08-22', '2024-08-21', '2024-08-20', '2024-08-19', '2024-08-14', '2024-08-09', '2024-08-07', '2024-08-06', '2024-08-05', '2024-08-04', '2024-08-02') 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 (4369, 6477, 4462, 8554, 3945, 70, 19, 14);

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 = 5 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 = 15 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 = 6 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 = 17 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 = 12 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 = 21 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;