Symfony Profiler

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

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 (3);

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

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

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 = 8554;

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
  )

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 = 17) 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 = 'dr-hans-peter-ackmann' AND (p3_.anzahl_protokolle > 0 OR p5_.anzahl_protokolle > 0);

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 (8554);

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

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

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 = 'nordrhein-westfalen' LIMIT 1;