Symfony Profiler

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

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 = 'hessen') WHERE p0_.examen = '1' 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 = 11 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,
  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 = 11) 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 = 'lrd-lars-streiberger' AND (p3_.anzahl_protokolle > 0 OR p5_.anzahl_protokolle > 0);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.alias_id AS alias_id_4
FROM
  dienststellung 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 dienststellung t0 WHERE t0.id IN (843);

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