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
  1020

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 1020;

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 ('2021-07-26', '2021-07-23', '2021-07-22', '2021-07-21', '2021-07-20', '2021-07-19', '2021-07-17', '2021-07-16', '2021-07-15', '2021-07-14', '2021-07-13', '2021-07-12', '2021-07-09', '2021-07-08', '2021-07-07', '2021-07-06', '2021-07-05', '2021-07-02', '2021-07-01', '2021-06-30') 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 (5252, 9602, 8902, 5441, 2907, 10007, 5628, 10891, 12, 8094, 8806, 7488, 7289, 2905, 3154, 10529, 5192, 10020, 5865, 8389, 7879, 3311, 7796, 497, 4854, 3428, 29, 135, 364, 3016, 236, 159, 5296, 3057, 9112, 5253, 8489, 8580, 8680, 5528, 8151, 9010, 5840, 7494, 5558, 5310, 7691, 4738, 222, 7801, 11632, 6525, 7048, 8056, 5493, 9167, 5220, 8320, 8608, 5413, 10051, 5466, 8954, 9570, 9294, 8694, 8674, 6361, 8589, 9380, 9523, 5412);

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 = 19 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 = 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 = 11 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 = 25 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;